CREATE COLUMN TABLE "IMCYC"."DRF6" ("DocEntry" INTEGER CS_INT NOT NULL , "InstlmntID" SMALLINT CS_INT DEFAULT 1 NOT NULL , "ObjType" NVARCHAR(20) DEFAULT '112', "LogInstanc" INTEGER CS_INT DEFAULT 0, "DueDate" LONGDATE CS_LONGDATE, "Status" CHAR(1) CS_FIXEDSTRING DEFAULT 'O', "DunnLevel" INTEGER CS_INT DEFAULT 0, "InsTotal" DECIMAL(21,6) CS_FIXED, "InsTotalFC" DECIMAL(21,6) CS_FIXED, "InsTotalSy" DECIMAL(21,6) CS_FIXED, "PaidToDate" DECIMAL(21,6) CS_FIXED, "PaidFC" DECIMAL(21,6) CS_FIXED, "PaidSys" DECIMAL(21,6) CS_FIXED, "VatSum" DECIMAL(21,6) CS_FIXED, "VatSumFC" DECIMAL(21,6) CS_FIXED, "VatSumSy" DECIMAL(21,6) CS_FIXED, "VatPaid" DECIMAL(21,6) CS_FIXED, "VatPaidFC" DECIMAL(21,6) CS_FIXED, "VatPaidSys" DECIMAL(21,6) CS_FIXED, "TotalExpns" DECIMAL(21,6) CS_FIXED, "TotalExpFC" DECIMAL(21,6) CS_FIXED, "TotalExpSC" DECIMAL(21,6) CS_FIXED, "ExpAppl" DECIMAL(21,6) CS_FIXED, "ExpApplFC" DECIMAL(21,6) CS_FIXED, "ExpApplSC" DECIMAL(21,6) CS_FIXED, "WTSum" DECIMAL(21,6) CS_FIXED, "WTSumFC" DECIMAL(21,6) CS_FIXED, "WTSumSC" DECIMAL(21,6) CS_FIXED, "WTApplied" DECIMAL(21,6) CS_FIXED, "WTAppliedF" DECIMAL(21,6) CS_FIXED, "WTAppliedS" DECIMAL(21,6) CS_FIXED, "TotalBlck" DECIMAL(21,6) CS_FIXED, "TotalBlckF" DECIMAL(21,6) CS_FIXED, "TotalBlckS" DECIMAL(21,6) CS_FIXED, "VATBlck" DECIMAL(21,6) CS_FIXED, "VATBlckFC" DECIMAL(21,6) CS_FIXED, "VATBlckSC" DECIMAL(21,6) CS_FIXED, "ExpnsBlck" DECIMAL(21,6) CS_FIXED, "ExpnsBlckF" DECIMAL(21,6) CS_FIXED, "ExpnsBlckS" DECIMAL(21,6) CS_FIXED, "WTBlocked" DECIMAL(21,6) CS_FIXED, "WTBlockedF" DECIMAL(21,6) CS_FIXED, "WTBlockedS" DECIMAL(21,6) CS_FIXED, "InstPrcnt" DECIMAL(21,6) CS_FIXED, "DunWizBlck" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "DunDate" LONGDATE CS_LONGDATE, "Paid" DECIMAL(21,6) CS_FIXED, "PaidFrgn" DECIMAL(21,6) CS_FIXED, "PaidSc" DECIMAL(21,6) CS_FIXED, "reserved" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "TaxOnExp" DECIMAL(21,6) CS_FIXED, "TaxOnExpFc" DECIMAL(21,6) CS_FIXED, "TaxOnExpSc" DECIMAL(21,6) CS_FIXED, "TaxOnExpAp" DECIMAL(21,6) CS_FIXED, "TaxOnExApF" DECIMAL(21,6) CS_FIXED, "TaxOnExApS" DECIMAL(21,6) CS_FIXED, "TaxOnExBlo" DECIMAL(21,6) CS_FIXED, "TaxOnExBlF" DECIMAL(21,6) CS_FIXED, "TaxOnExBlS" DECIMAL(21,6) CS_FIXED, "LvlUpdDate" LONGDATE CS_LONGDATE, "Ordered" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "PaidDpm" DECIMAL(21,6) CS_FIXED, "PaidDpmFc" DECIMAL(21,6) CS_FIXED, "PaidDpmSc" DECIMAL(21,6) CS_FIXED, PRIMARY KEY INVERTED VALUE ("DocEntry", "InstlmntID")) UNLOAD PRIORITY 5  AUTO MERGE 