CREATE COLUMN TABLE "IMCYC"."CASE1" ("AbsEntry" INTEGER CS_INT NOT NULL , "LineId" INTEGER CS_INT DEFAULT 0 NOT NULL , "ShortName" NVARCHAR(15), "Account" NVARCHAR(15), "OrigAbsEnt" INTEGER CS_INT, "OrigObjTyp" INTEGER CS_INT DEFAULT 0, "OrigDocNum" INTEGER CS_INT, "OrigInsNum" INTEGER CS_INT, "OrigTrnsId" INTEGER CS_INT, "OrigTrnsLn" INTEGER CS_INT, "LnkRecnAbs" INTEGER CS_INT, "LnkRecnObj" INTEGER CS_INT, "LnkRecnNum" INTEGER CS_INT, "LnkRecnIns" INTEGER CS_INT, "LnkRecnTrn" INTEGER CS_INT, "LnkRecnLn" INTEGER CS_INT, "InconsType" NVARCHAR(2), "ReconNum" INTEGER CS_INT, "NewRcnNum" INTEGER CS_INT, "CredDeb" CHAR(1) CS_FIXEDSTRING, "Amount" DECIMAL(21,6) CS_FIXED, "AmountFC" DECIMAL(21,6) CS_FIXED, "AmountSC" DECIMAL(21,6) CS_FIXED, "TransId" INTEGER CS_INT, "TransLine" INTEGER CS_INT, "X" DECIMAL(21,6) CS_FIXED, "Y" DECIMAL(21,6) CS_FIXED, "Z" DECIMAL(21,6) CS_FIXED, "LnkObjAbsE" INTEGER CS_INT, "LinkObjTyp" INTEGER CS_INT, "LinkDocNum" INTEGER CS_INT, "LinkInsNum" INTEGER CS_INT, "LinkTrnsId" INTEGER CS_INT, "LinkTrnsLn" INTEGER CS_INT, "TrnsTtlAmt" DECIMAL(21,6) CS_FIXED, "TrnsTtlFc" DECIMAL(21,6) CS_FIXED, PRIMARY KEY INVERTED VALUE ("AbsEntry", "LineId")) UNLOAD PRIORITY 5  AUTO MERGE 