CREATE COLUMN TABLE "SBODEMOPT"."OSWA" ("PymntRsnCd" NVARCHAR(2) NOT NULL , "CardCode" NVARCHAR(15) NOT NULL , "FllTxInAdv" DECIMAL(21,6) CS_FIXED, "AmntsOnhld" DECIMAL(21,6) CS_FIXED, "RTAsWth" DECIMAL(21,6) CS_FIXED, "RTAsAdv" DECIMAL(21,6) CS_FIXED, "SspndRegTx" DECIMAL(21,6) CS_FIXED, "MTAsWth" DECIMAL(21,6) CS_FIXED, "MTAsAdv" DECIMAL(21,6) CS_FIXED, "SspndMTTx" DECIMAL(21,6) CS_FIXED, "TxblPrYr" DECIMAL(21,6) CS_FIXED, "WTHPrYr" DECIMAL(21,6) CS_FIXED, "ScrtyCntrP" DECIMAL(21,6) CS_FIXED, "ScrtyCntrS" DECIMAL(21,6) CS_FIXED, "ExpsRmbrsd" DECIMAL(21,6) CS_FIXED, "WTHRmbrsd" DECIMAL(21,6) CS_FIXED, "DlvryIdNo" NVARCHAR(100), "SnglCrtfNo" NVARCHAR(17), "ErnYr" SMALLINT CS_INT, "Advanced" NVARCHAR(1) DEFAULT 'N', "WTHTypCd" NVARCHAR(2), "GrssAmount" DECIMAL(21,6) CS_FIXED, "NtSbjctFrg" DECIMAL(21,6) CS_FIXED, "TxblAmnt" DECIMAL(21,6) CS_FIXED, "WTHAmnt" DECIMAL(21,6) CS_FIXED, "SSFiscalCd" NVARCHAR(16), "SSIName" NVARCHAR(100), "SSICode" NVARCHAR(1), "CompanyCd" NVARCHAR(16), "Category" NVARCHAR(1), "EmpeSSCntr" DECIMAL(21,6) CS_FIXED, "EmprSSCntr" DECIMAL(21,6) CS_FIXED, "OthCntrbts" NVARCHAR(1) DEFAULT 'N', "VOthCntrbt" DECIMAL(21,6) CS_FIXED, "OthAmntDue" DECIMAL(21,6) CS_FIXED, "OthAmntPd" DECIMAL(21,6) CS_FIXED, "AmntPdBfBr" DECIMAL(21,6) CS_FIXED, "AmntPdByTr" DECIMAL(21,6) CS_FIXED, "FiscalCode" NVARCHAR(16), "TxblAmntE" DECIMAL(21,6) CS_FIXED, "TaxAmount" DECIMAL(21,6) CS_FIXED, "TxAmntInAd" DECIMAL(21,6) CS_FIXED, "SspndWTHTx" DECIMAL(21,6) CS_FIXED, "AdRgTxIRPH" DECIMAL(21,6) CS_FIXED, "AdRgTxIRPA" DECIMAL(21,6) CS_FIXED, "SspdRgnlTx" DECIMAL(21,6) CS_FIXED, "AdCtTxIRWT" DECIMAL(21,6) CS_FIXED, "AdCtTxIWTA" DECIMAL(21,6) CS_FIXED, "SspndCtTx" DECIMAL(21,6) CS_FIXED, "FsCdTrdPty" NVARCHAR(16), "FCdTrdPtyS" NVARCHAR(16), "FscCdExpr" NVARCHAR(16), "FsCdMnDbS" NVARCHAR(16), "AmntPdS" DECIMAL(21,6) CS_FIXED, "WHTApdS" DECIMAL(21,6) CS_FIXED, "WHTNApdS" NVARCHAR(1) DEFAULT 'N', "FsCdMnDbR" NVARCHAR(16), "AmntPdR" DECIMAL(21,6) CS_FIXED, "WHTApdR" DECIMAL(21,6) CS_FIXED, "WHTNApdR" NVARCHAR(1) DEFAULT 'N', "AmntPdA" DECIMAL(21,6) CS_FIXED, "TxAppldA" DECIMAL(21,6) CS_FIXED, "AmntPdB" DECIMAL(21,6) CS_FIXED, "TxAppldB" DECIMAL(21,6) CS_FIXED, "AmntPdC" DECIMAL(21,6) CS_FIXED, "TxAppldC" DECIMAL(21,6) CS_FIXED, "AmntPdD" DECIMAL(21,6) CS_FIXED, "TxAppldD" DECIMAL(21,6) CS_FIXED, "AmtPvdNTxS" DECIMAL(21,6) CS_FIXED, "AmtPvdNTxR" DECIMAL(21,6) CS_FIXED, "CUSplit" NVARCHAR(1) DEFAULT 'N' NOT NULL , "SmRnNtWTx" DECIMAL(21,6) CS_FIXED, PRIMARY KEY ("PymntRsnCd", "CardCode", "CUSplit")) UNLOAD PRIORITY 5  AUTO MERGE 