CREATE COLUMN TABLE "IMCYC"."ICD1" ("DocEntry" INTEGER CS_INT NOT NULL , "LineNum" INTEGER CS_INT NOT NULL , "ItemCode" NVARCHAR(50), "ItemDesc" NVARCHAR(100), "Freeze" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "WhsCode" NVARCHAR(8), "InWhsQty" DECIMAL(21,6) CS_FIXED, "Counted" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "CountQty" DECIMAL(21,6) CS_FIXED, "CountQtyT1" DECIMAL(21,6) CS_FIXED, "CountQtyT2" DECIMAL(21,6) CS_FIXED, "Remark" NVARCHAR(254), "BarCode" NVARCHAR(254), "InvUoM" CHAR(1) CS_FIXEDSTRING DEFAULT 'Y', "Difference" DECIMAL(21,6) CS_FIXED, "DiffPercen" DECIMAL(21,6) CS_FIXED, "CountDate" LONGDATE CS_LONGDATE, "CountTime" INTEGER CS_INT, "TargetRef" NVARCHAR(16), "TargetType" INTEGER CS_INT DEFAULT -1, "TargetEntr" INTEGER CS_INT, "TargetLine" INTEGER CS_INT, "ProjCode" NVARCHAR(20), "OcrCode" NVARCHAR(8), "LineStatus" CHAR(1) CS_FIXEDSTRING DEFAULT 'O', "BinEntry" INTEGER CS_INT, "VisOrder" INTEGER CS_INT, "OcrCode2" NVARCHAR(8), "OcrCode3" NVARCHAR(8), "OcrCode4" NVARCHAR(8), "OcrCode5" NVARCHAR(8), "FirmCode" SMALLINT CS_INT, "SuppCatNum" NVARCHAR(50), "PrefVendor" NVARCHAR(15), "LogIns" INTEGER CS_INT, "UgpEntry" INTEGER CS_INT, "IUomEntry" NVARCHAR(20), "CountDiff" DECIMAL(21,6) CS_FIXED, "CountDiffP" DECIMAL(21,6) CS_FIXED, "UomCode" NVARCHAR(20), "UomQty" DECIMAL(21,6) CS_FIXED, PRIMARY KEY INVERTED VALUE ("DocEntry", "LineNum")) UNLOAD PRIORITY 5  AUTO MERGE 