CREATE COLUMN TABLE "SBODEMOPT"."OIBQ" ("AbsEntry" INTEGER CS_INT NOT NULL , "ItemCode" NVARCHAR(50) NOT NULL , "BinAbs" INTEGER CS_INT NOT NULL , "OnHandQty" DECIMAL(21,6) CS_FIXED, "WhsCode" NVARCHAR(8), "Freezed" NVARCHAR(1) DEFAULT 'N', "FreezeDoc" INTEGER CS_INT, PRIMARY KEY ("AbsEntry")) UNLOAD PRIORITY 5  AUTO MERGE ;
CREATE UNIQUE INDEX "OIBQ_BUSINESS_K" ON "SBODEMOPT"."OIBQ" ( "ItemCode" ASC, "BinAbs" ASC );
CREATE INDEX "OIBQ_BIN_ABS" ON "SBODEMOPT"."OIBQ" ( "BinAbs" ASC )