CREATE COLUMN TABLE "IMCYC"."VPM4" ("DocNum" INTEGER CS_INT NOT NULL , "LineId" INTEGER CS_INT NOT NULL , "AcctCode" NVARCHAR(15), "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(100), "ObjType" NVARCHAR(20) DEFAULT '46', "LogInstanc" INTEGER CS_INT DEFAULT 0, "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" CHAR(1) CS_FIXEDSTRING, "VatAmnt" DECIMAL(21,6) CS_FIXED, "VatAmntFC" DECIMAL(21,6) CS_FIXED, "VatAmntSC" DECIMAL(21,6) CS_FIXED, "UserChaVat" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "TaxTypeID" INTEGER CS_INT, "OcrCode2" NVARCHAR(8), "OcrCode3" NVARCHAR(8), "OcrCode4" NVARCHAR(8), "OcrCode5" NVARCHAR(8), "Section" INTEGER CS_INT, "AsseType" CHAR(1) CS_FIXEDSTRING, "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, PRIMARY KEY INVERTED VALUE ("DocNum", "LineId")) UNLOAD PRIORITY 5  AUTO MERGE 