CREATE COLUMN TABLE "IMCYC"."ASC2" ("SrcvCallID" INTEGER CS_INT NOT NULL , "Line" SMALLINT CS_INT DEFAULT -1 NOT NULL , "ItemCode" NVARCHAR(50), "ItemName" NVARCHAR(100), "TransToTec" DECIMAL(21,6) CS_FIXED, "Delivered" DECIMAL(21,6) CS_FIXED, "RetFromTec" DECIMAL(21,6) CS_FIXED, "Returned" DECIMAL(21,6) CS_FIXED, "Bill" CHAR(1) CS_FIXEDSTRING DEFAULT 'Y', "QtyToBill" DECIMAL(21,6) CS_FIXED, "QtyToInv" DECIMAL(21,6) CS_FIXED, "ObjectType" NVARCHAR(20) DEFAULT '191', "LogInstanc" INTEGER CS_INT NOT NULL , "UserSign" SMALLINT CS_INT, "CreateDate" LONGDATE CS_LONGDATE, "UserSign2" SMALLINT CS_INT, "UpdateDate" LONGDATE CS_LONGDATE, "VisOrder" INTEGER CS_INT, PRIMARY KEY INVERTED VALUE ("SrcvCallID", "Line", "LogInstanc")) UNLOAD PRIORITY 5  AUTO MERGE 