CREATE COLUMN TABLE "SBODEMODE"."RTW1" ("AbsEntry" INTEGER CS_INT NOT NULL , "BoeMatch" NVARCHAR(10), "BoeNo" NVARCHAR(10), "BoeDate" LONGDATE CS_LONGDATE, "BoeDueDate" LONGDATE CS_LONGDATE, "CreditDate" LONGDATE CS_LONGDATE, "CurrBoeSt" NVARCHAR(1), "ReqBoeSt" NVARCHAR(1), "Instruct1" NVARCHAR(2), "Instruct2" NVARCHAR(2), "CancelCode" NVARCHAR(4), "MovmntCode" SMALLINT CS_INT, "OccurCode" SMALLINT CS_INT, "OccurDate" LONGDATE CS_LONGDATE, "Portfolio" NVARCHAR(1), "OurNum" INTEGER CS_INT, "ValueOfT" DECIMAL(21,6) CS_FIXED, "NetAmnt" DECIMAL(21,6) CS_FIXED, "PaidAmnt" DECIMAL(21,6) CS_FIXED, "FineAmnt" DECIMAL(21,6) CS_FIXED, "IntAmnt" DECIMAL(21,6) CS_FIXED, "Discounts" DECIMAL(21,6) CS_FIXED, "ServiceFee" DECIMAL(21,6) CS_FIXED, "IOFTax" DECIMAL(21,6) CS_FIXED, "OtherCred" DECIMAL(21,6) CS_FIXED, "OtherExp" DECIMAL(21,6) CS_FIXED, "OtherInc" DECIMAL(21,6) CS_FIXED, "Errors" NVARCHAR(8), "RefNum" NVARCHAR(254), "Ref2" NVARCHAR(254), "CardName" NVARCHAR(200), "BoEBPName" NVARCHAR(200), "MatchCode" NVARCHAR(1) DEFAULT 'N', "Selected" NVARCHAR(1) DEFAULT 'N', "BoeRec" INTEGER CS_INT, "RetIndex" INTEGER CS_INT, "Filtered" NVARCHAR(1) DEFAULT 'Y', "Executed" NVARCHAR(1) DEFAULT 'N', "Failed" NVARCHAR(1) DEFAULT 'N', "LastRun" NVARCHAR(1) DEFAULT 'N', "ErrorMsg" NVARCHAR(254), "JETransId" NVARCHAR(10), "CardCode" NVARCHAR(15), "PostType" NVARCHAR(1) DEFAULT 'C', PRIMARY KEY ("AbsEntry")) UNLOAD PRIORITY 5  AUTO MERGE 