CREATE COLUMN TABLE "SBODEMODE"."RCC4" ("DocNum" INTEGER CS_INT NOT NULL , "LineId" INTEGER CS_INT NOT NULL , "AcctCode" NVARCHAR(15) DEFAULT '-1', "SumApplied" DECIMAL(21,6) CS_FIXED, "AppliedFC" DECIMAL(21,6) CS_FIXED, "AppliedSys" DECIMAL(21,6) CS_FIXED, "Descrip" NVARCHAR(250), "VatGroup" NVARCHAR(8), "VatPrcnt" DECIMAL(21,6) CS_FIXED, "AcctName" NVARCHAR(200) DEFAULT '-1', "ObjType" NVARCHAR(20) DEFAULT '1', "LogInstanc" INTEGER CS_INT, "OcrCode" NVARCHAR(8), "Project" NVARCHAR(20), "GrossAmnt" DECIMAL(21,6) CS_FIXED, "GrssAmntFC" DECIMAL(21,6) CS_FIXED, "GrssAmntSC" DECIMAL(21,6) CS_FIXED, "AmntBase" NVARCHAR(1), "VatAmnt" DECIMAL(21,6) CS_FIXED, "VatAmntFC" DECIMAL(21,6) CS_FIXED, "VatAmntSC" DECIMAL(21,6) CS_FIXED, "UserChaVat" NVARCHAR(1) DEFAULT 'N', "TaxTypeID" INTEGER CS_INT, "OcrCode2" NVARCHAR(8), "OcrCode3" NVARCHAR(8), "OcrCode4" NVARCHAR(8), "OcrCode5" NVARCHAR(8), "Section" INTEGER CS_INT, "AsseType" NVARCHAR(1), "LocCode" INTEGER CS_INT, "MatType" INTEGER CS_INT DEFAULT 0, "EquVatPer" DECIMAL(21,6) CS_FIXED, "EquVatSum" DECIMAL(21,6) CS_FIXED, "EquVatSumF" DECIMAL(21,6) CS_FIXED, "EquVatSumS" DECIMAL(21,6) CS_FIXED, "EncryptIV" NVARCHAR(100), PRIMARY KEY ("DocNum", "LineId")) UNLOAD PRIORITY 5  AUTO MERGE 