CREATE COLUMN TABLE "IMCYC"."MTH1V" ("MthAcctCod" NVARCHAR(15) NOT NULL , "IsInternal" CHAR(1) CS_FIXEDSTRING DEFAULT 'E' NOT NULL , "MatchNum" INTEGER CS_INT NOT NULL , "TransID" INTEGER CS_INT NOT NULL , "Line_ID" INTEGER CS_INT NOT NULL , "RefDate" LONGDATE CS_LONGDATE, "DueDate" LONGDATE CS_LONGDATE, "Ref1" NVARCHAR(100), "Ref2" NVARCHAR(100), "Ref3Line" NVARCHAR(27), "Debit" DECIMAL(21,6) CS_FIXED, "Credit" DECIMAL(21,6) CS_FIXED, "SYSDeb" DECIMAL(21,6) CS_FIXED, "SYSCred" DECIMAL(21,6) CS_FIXED, "FCDebit" DECIMAL(21,6) CS_FIXED, "FCCredit" DECIMAL(21,6) CS_FIXED, "Currency" NVARCHAR(3), "LineMemo" NVARCHAR(254), PRIMARY KEY INVERTED VALUE ("MthAcctCod", "IsInternal", "MatchNum", "TransID", "Line_ID")) UNLOAD PRIORITY 5  AUTO MERGE 