CREATE COLUMN TABLE "SBODEMODE"."WTR28" ("DocEntry" INTEGER CS_INT NOT NULL , "LineNum" INTEGER CS_INT NOT NULL , "ChildNum" INTEGER CS_INT NOT NULL , "TrackingNt" INTEGER CS_INT NOT NULL , "TrackiNtLn" INTEGER CS_INT NOT NULL , "Quantity" DECIMAL(21,6) CS_FIXED, "UnusedQty" DECIMAL(21,6) CS_FIXED, "LogInstanc" INTEGER CS_INT DEFAULT 0, "ObjType" NVARCHAR(20) DEFAULT '67', "SubLineNum" INTEGER CS_INT, PRIMARY KEY ("DocEntry", "LineNum", "ChildNum")) UNLOAD PRIORITY 5  AUTO MERGE ;
CREATE UNIQUE INDEX "WTR28_TCN_KEY" ON "SBODEMODE"."WTR28" ( "DocEntry" ASC, "LineNum" ASC, "TrackingNt" ASC, "TrackiNtLn" ASC )