CREATE COLUMN TABLE "IMCYC"."PEX1" ("AbsEntry" INTEGER CS_INT NOT NULL , "LineId" INTEGER CS_INT NOT NULL , "PayRunDate" LONGDATE CS_LONGDATE, "PaymWizCod" INTEGER CS_INT, "VendorNum" NVARCHAR(15), "CustNum" NVARCHAR(15), "PaymMethod" NVARCHAR(15), "PaymDocNum" INTEGER CS_INT, "FiscalYear" LONGDATE CS_LONGDATE, "VendRefNum" NVARCHAR(100), "ObjType" NVARCHAR(20), "DocDate" LONGDATE CS_LONGDATE, "TaxDate" LONGDATE CS_LONGDATE, "CrdGLAcct" NVARCHAR(15), "DocCurr" NVARCHAR(3), "DocRate" DECIMAL(21,6) CS_FIXED, "DocTotal" DECIMAL(21,6) CS_FIXED, "DocTotalFC" DECIMAL(21,6) CS_FIXED, "DocTaxAmnt" DECIMAL(21,6) CS_FIXED, "DoxTxAmtFC" DECIMAL(21,6) CS_FIXED, "DocRemarks" NVARCHAR(254), "DocPrmTerm" SMALLINT CS_INT, "DocPymRef" NVARCHAR(27), "DocLocCurr" NVARCHAR(3), "PymTermPer" INTEGER CS_INT, "DocNum" INTEGER CS_INT, "PymNum" INTEGER CS_INT, "PayOrderNo" INTEGER CS_INT, "FreeText1" NVARCHAR(100), "FreeText2" NVARCHAR(100), "FreeText3" NVARCHAR(100), PRIMARY KEY INVERTED VALUE ("AbsEntry", "LineId")) UNLOAD PRIORITY 5  AUTO MERGE 