CREATE COLUMN TABLE "IMCYC"."UIVQ" ("TreeID" INTEGER CS_INT DEFAULT 0, "ParentID" INTEGER CS_INT DEFAULT -1, "LocType" SMALLINT CS_INT, "LocCode" NVARCHAR(8), "TransSeq" INTEGER CS_INT NOT NULL , "LayerID" INTEGER CS_INT NOT NULL , "OpenQty" DECIMAL(21,6) CS_FIXED, "OpenValue" DECIMAL(21,6) CS_FIXED, "ItemCode" NVARCHAR(50), "AbsEntry" INTEGER CS_INT NOT NULL , "StockActio" INTEGER CS_INT DEFAULT -1, "RemMethod" CHAR(1) CS_FIXEDSTRING DEFAULT 'U', PRIMARY KEY ("AbsEntry")) UNLOAD PRIORITY 5  AUTO MERGE ;
ALTER TABLE "IMCYC"."UIVQ" WITH PARAMETERS ('CONCAT_ATTRIBUTE'=('ALLOW_NULL_AS_COMPONENT=YES', '$uc_UIVQ_TRANS_SEQ$','TransSeq','LayerID'));
ALTER TABLE "IMCYC"."UIVQ" WITH PARAMETERS ('CONCAT_ATTRIBUTE'=('$TreeID$OpenQty$','TreeID','OpenQty'));
CREATE UNIQUE INDEX "UIVQ_TRANS_SEQ" ON "IMCYC"."UIVQ" ( "TransSeq" ASC, "LayerID" ASC );
CREATE INDEX "UIVQ_TreeOpenQt" ON "IMCYC"."UIVQ" ( "TreeID" ASC, "OpenQty" ASC )