CREATE COLUMN TABLE "SBODEMODE"."OSLD" ("AbsEntry" INTEGER CS_INT NOT NULL , "ObjType" NVARCHAR(20) DEFAULT '-1' NOT NULL , "DocEntry" INTEGER CS_INT NOT NULL , "DocLineNum" INTEGER CS_INT NOT NULL , "SchdLine" INTEGER CS_INT NOT NULL , "ItemCode" NVARCHAR(50), "WhsCode" NVARCHAR(8), "CfmDate" LONGDATE CS_LONGDATE, "CfmQty" DECIMAL(21,6) CS_FIXED, "FixedCfm" NVARCHAR(1) DEFAULT 'N', "ReqQty" DECIMAL(21,6) CS_FIXED, PRIMARY KEY ("AbsEntry")) UNLOAD PRIORITY 5  AUTO MERGE ;
ALTER TABLE "SBODEMODE"."OSLD" WITH PARAMETERS ('CONCAT_ATTRIBUTE'=('$ObjType$DocEntry$DocLineNum$','ObjType','DocEntry','DocLineNum'));
CREATE UNIQUE INDEX "OSLD_SCHD_LINE" ON "SBODEMODE"."OSLD" ( "ObjType" ASC, "DocEntry" ASC, "DocLineNum" ASC, "SchdLine" ASC );
CREATE INDEX "OSLD_DOCLINESLD" ON "SBODEMODE"."OSLD" ( "ObjType" ASC, "DocEntry" ASC, "DocLineNum" ASC )