CREATE COLUMN TABLE "SBODEMODE"."PMG1" ("AbsEntry" INTEGER CS_INT NOT NULL , "LineID" INTEGER CS_INT NOT NULL , "StageID" INTEGER CS_INT, "POS" INTEGER CS_INT NOT NULL , "START" LONGDATE CS_LONGDATE, "CLOSE" LONGDATE CS_LONGDATE, "FINISHDATE" LONGDATE CS_LONGDATE, "Task" INTEGER CS_INT, "DSCRIPTION" NCLOB MEMORY THRESHOLD 1000, "EXPCOSTS" DECIMAL(21,6) CS_FIXED, "InvAmtAR" DECIMAL(21,6) CS_FIXED, "OpenAmtAR" DECIMAL(21,6) CS_FIXED, "InvAmtAP" DECIMAL(21,6) CS_FIXED, "OpenAmtAP" DECIMAL(21,6) CS_FIXED, "PERCENT" DECIMAL(21,6) CS_FIXED, "FINISH" NVARCHAR(1) DEFAULT 'N', "OWNER" INTEGER CS_INT, "StageDep1" INTEGER CS_INT, "StageDep2" INTEGER CS_INT, "StageDep3" INTEGER CS_INT, "StageDep4" INTEGER CS_INT, "StDp1Type" NVARCHAR(1) DEFAULT 'P', "StDp2Type" NVARCHAR(1) DEFAULT 'P', "StDp3Type" NVARCHAR(1) DEFAULT 'P', "StDp4Type" NVARCHAR(1) DEFAULT 'P', "StDp1Abs" INTEGER CS_INT, "StDp2Abs" INTEGER CS_INT, "StDp3Abs" INTEGER CS_INT, "StDp4Abs" INTEGER CS_INT, "LogInstanc" INTEGER CS_INT DEFAULT 0, "AtcEntry" INTEGER CS_INT, "UniqueID" NVARCHAR(50), "EncryptIV" NVARCHAR(100), PRIMARY KEY ("AbsEntry", "LineID")) UNLOAD PRIORITY 5  AUTO MERGE ;
CREATE UNIQUE INDEX "PMG1_POS" ON "SBODEMODE"."PMG1" ( "AbsEntry" ASC, "POS" ASC )