CREATE COLUMN TABLE "IMCYC"."UGP1" ("UgpEntry" INTEGER CS_INT NOT NULL , "UomEntry" INTEGER CS_INT NOT NULL , "AltQty" DECIMAL(21,6) CS_FIXED, "BaseQty" DECIMAL(21,6) CS_FIXED, "LogInstanc" INTEGER CS_INT DEFAULT 0, "LineNum" INTEGER CS_INT NOT NULL , "WghtFactor" SMALLINT CS_INT DEFAULT 0, "UdfFactor" INTEGER CS_INT DEFAULT -1, PRIMARY KEY INVERTED VALUE ("UgpEntry", "LineNum")) UNLOAD PRIORITY 5  AUTO MERGE ;
ALTER TABLE "IMCYC"."UGP1" WITH PARAMETERS ('CONCAT_ATTRIBUTE'=('ALLOW_NULL_AS_COMPONENT=YES', '$uc_UGP1_GROUP$','UgpEntry','UomEntry'));
CREATE UNIQUE INDEX "UGP1_GROUP" ON "IMCYC"."UGP1" ( "UgpEntry" ASC, "UomEntry" ASC )