CREATE COLUMN TABLE "SBODEMODE"."RCR1" ("RcurCode" NVARCHAR(8) NOT NULL , "LineId" INTEGER CS_INT DEFAULT 0 NOT NULL , "AcctCode" NVARCHAR(15), "AcctDesc" NVARCHAR(200), "Debit" DECIMAL(21,6) CS_FIXED, "Credit" DECIMAL(21,6) CS_FIXED, "Currency" NVARCHAR(3), "Instance" SMALLINT CS_INT NOT NULL , "VatGroup" NVARCHAR(8), "UserSign" SMALLINT CS_INT, "VatLine" NVARCHAR(1) DEFAULT 'N', "CtrlAcct" NVARCHAR(15), "OcrCode" NVARCHAR(8), "TaxType" SMALLINT CS_INT DEFAULT 0, "TaxPostAcc" NVARCHAR(1) DEFAULT 'N', "StaCode" NVARCHAR(8), "StaType" INTEGER CS_INT, "TaxCode" NVARCHAR(8), "OcrCode1" NVARCHAR(8), "OcrCode2" NVARCHAR(8), "OcrCode3" NVARCHAR(8), "OcrCode4" NVARCHAR(8), "OcrCode5" NVARCHAR(8), "WtLiable" NVARCHAR(1), "WTaxLine" NVARCHAR(1) DEFAULT 'N', "GrossValue" DECIMAL(21,6) CS_FIXED, "Project" NVARCHAR(20), "BPLId" INTEGER CS_INT, "CemCode" NVARCHAR(20), PRIMARY KEY ("RcurCode", "Instance", "LineId")) UNLOAD PRIORITY 5  AUTO MERGE 