CREATE COLUMN TABLE "IMCYC"."PQT11" ("DocEntry" INTEGER CS_INT NOT NULL , "LineNum" INTEGER CS_INT NOT NULL , "LineSeq" INTEGER CS_INT NOT NULL , "BaseAbs" INTEGER CS_INT, "BaseType" INTEGER CS_INT DEFAULT -1, "VatGroup" NVARCHAR(8), "VatPrcnt" DECIMAL(21,6) CS_FIXED, "LineTotal" DECIMAL(21,6) CS_FIXED, "TotalFrgn" DECIMAL(21,6) CS_FIXED, "TotalSumSy" DECIMAL(21,6) CS_FIXED, "VatSum" DECIMAL(21,6) CS_FIXED, "VatSumFrgn" DECIMAL(21,6) CS_FIXED, "VatSumSys" DECIMAL(21,6) CS_FIXED, "ObjType" NVARCHAR(20) DEFAULT '540000006', "LogInstanc" INTEGER CS_INT, "IsAcq" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "IsAllDrawn" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "IsGross" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "Gross" DECIMAL(21,6) CS_FIXED, "GrossFc" DECIMAL(21,6) CS_FIXED, "GrossSc" DECIMAL(21,6) CS_FIXED, "ApplNet" DECIMAL(21,6) CS_FIXED, "ApplNetFc" DECIMAL(21,6) CS_FIXED, "ApplNetSc" DECIMAL(21,6) CS_FIXED, "ApplVat" DECIMAL(21,6) CS_FIXED, "ApplVatFc" DECIMAL(21,6) CS_FIXED, "ApplVatSc" DECIMAL(21,6) CS_FIXED, "BaseNet" DECIMAL(21,6) CS_FIXED, "BaseNetFc" DECIMAL(21,6) CS_FIXED, "BaseNetSc" DECIMAL(21,6) CS_FIXED, "BaseVat" DECIMAL(21,6) CS_FIXED, "BaseVatFc" DECIMAL(21,6) CS_FIXED, "BaseVatSc" DECIMAL(21,6) CS_FIXED, "BaseGross" DECIMAL(21,6) CS_FIXED, "BaseGrossF" DECIMAL(21,6) CS_FIXED, "BaseGrossS" DECIMAL(21,6) CS_FIXED, "LineType" CHAR(1) CS_FIXEDSTRING DEFAULT 'D', "DctSum" DECIMAL(21,6) CS_FIXED, "DctSumFc" DECIMAL(21,6) CS_FIXED, "DctSumSc" DECIMAL(21,6) CS_FIXED, "EqSum" DECIMAL(21,6) CS_FIXED, "EqSumFc" DECIMAL(21,6) CS_FIXED, "EqSumSc" DECIMAL(21,6) CS_FIXED, "ApplDct" DECIMAL(21,6) CS_FIXED, "ApplDctFc" DECIMAL(21,6) CS_FIXED, "ApplDctSc" DECIMAL(21,6) CS_FIXED, "ApplEq" DECIMAL(21,6) CS_FIXED, "ApplEqFc" DECIMAL(21,6) CS_FIXED, "ApplEqSc" DECIMAL(21,6) CS_FIXED, "BaseDct" DECIMAL(21,6) CS_FIXED, "BaseDctFc" DECIMAL(21,6) CS_FIXED, "BaseDctSc" DECIMAL(21,6) CS_FIXED, "BaseEq" DECIMAL(21,6) CS_FIXED, "BaseEqFc" DECIMAL(21,6) CS_FIXED, "BaseEqSc" DECIMAL(21,6) CS_FIXED, "TaxCode" NVARCHAR(8), "ApplGross" DECIMAL(21,6) CS_FIXED, "ApplGrossF" DECIMAL(21,6) CS_FIXED, "ApplGrossS" DECIMAL(21,6) CS_FIXED, "TaxAdjust" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "RvsChrgSum" DECIMAL(21,6) CS_FIXED, "RvsChrgFc" DECIMAL(21,6) CS_FIXED, "RvsChrgSc" DECIMAL(21,6) CS_FIXED, "BasRvsChrg" DECIMAL(21,6) CS_FIXED, "BasRvsFc" DECIMAL(21,6) CS_FIXED, "BasRvsSc" DECIMAL(21,6) CS_FIXED, "ApplRvs" DECIMAL(21,6) CS_FIXED, "ApplRvsFc" DECIMAL(21,6) CS_FIXED, "ApplRvsSc" DECIMAL(21,6) CS_FIXED, PRIMARY KEY INVERTED VALUE ("DocEntry", "LineNum", "LineSeq")) UNLOAD PRIORITY 5  AUTO MERGE 