CREATE COLUMN TABLE "IMCYC"."OBBQ" ("AbsEntry" INTEGER CS_INT NOT NULL , "ItemCode" NVARCHAR(50), "SnBMDAbs" INTEGER CS_INT NOT NULL , "BinAbs" INTEGER CS_INT NOT NULL , "OnHandQty" DECIMAL(21,6) CS_FIXED, "WhsCode" NVARCHAR(8), PRIMARY KEY ("AbsEntry")) UNLOAD PRIORITY 5  AUTO MERGE ;
ALTER TABLE "IMCYC"."OBBQ" WITH PARAMETERS ('CONCAT_ATTRIBUTE'=('ALLOW_NULL_AS_COMPONENT=YES', '$uc_OBBQ_BUSINESS_K$','SnBMDAbs','BinAbs'));
CREATE UNIQUE INDEX "OBBQ_BUSINESS_K" ON "IMCYC"."OBBQ" ( "SnBMDAbs" ASC, "BinAbs" ASC );
CREATE INDEX "OBBQ_BIN_ABS" ON "IMCYC"."OBBQ" ( "BinAbs" ASC )