CREATE COLUMN TABLE "IMCYC"."PQT13" ("DocEntry" INTEGER CS_INT NOT NULL , "LineNum" INTEGER CS_INT NOT NULL , "GroupNum" INTEGER CS_INT NOT NULL , "ExpnsCode" INTEGER CS_INT, "LineTotal" DECIMAL(21,6) CS_FIXED, "TotalFrgn" DECIMAL(21,6) CS_FIXED, "TotalSumSy" DECIMAL(21,6) CS_FIXED, "PaidToDate" DECIMAL(21,6) CS_FIXED, "PaidFC" DECIMAL(21,6) CS_FIXED, "PaidSys" DECIMAL(21,6) CS_FIXED, "ObjType" NVARCHAR(20) DEFAULT '540000006', "LogInstanc" INTEGER CS_INT DEFAULT 0, "TaxStatus" CHAR(1) CS_FIXEDSTRING DEFAULT 'Y', "VatGroup" NVARCHAR(8), "VatPrcnt" DECIMAL(21,6) CS_FIXED, "VatSum" DECIMAL(21,6) CS_FIXED, "VatSumFrgn" DECIMAL(21,6) CS_FIXED, "VatSumSy" DECIMAL(21,6) CS_FIXED, "DedVatSum" DECIMAL(21,6) CS_FIXED, "DedVatSumF" DECIMAL(21,6) CS_FIXED, "DedVatSumS" DECIMAL(21,6) CS_FIXED, "IsAcquistn" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "TaxCode" NVARCHAR(8), "TaxType" CHAR(1) CS_FIXEDSTRING DEFAULT 'Y', "VatApplied" DECIMAL(21,6) CS_FIXED, "VatAppldFC" DECIMAL(21,6) CS_FIXED, "VatAppldSC" DECIMAL(21,6) CS_FIXED, "EquVatPer" DECIMAL(21,6) CS_FIXED, "EquVatSum" DECIMAL(21,6) CS_FIXED, "EquVatSumF" DECIMAL(21,6) CS_FIXED, "EquVatSumS" DECIMAL(21,6) CS_FIXED, "lineVat" DECIMAL(21,6) CS_FIXED, "lineVatlF" DECIMAL(21,6) CS_FIXED, "lineVatS" DECIMAL(21,6) CS_FIXED, "WtLiable" CHAR(1) CS_FIXEDSTRING, "BaseMethod" CHAR(1) CS_FIXEDSTRING, "Stock" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "LstPchPrce" CHAR(1) CS_FIXEDSTRING, "AnalysRpt" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "BaseAbsEnt" INTEGER CS_INT DEFAULT -1, "BaseType" INTEGER CS_INT, "BaseRef" INTEGER CS_INT, "BaseLnNum" INTEGER CS_INT, "TrgType" INTEGER CS_INT, "TrgAbsEnt" INTEGER CS_INT DEFAULT -1, "BaseGroup" INTEGER CS_INT DEFAULT -1, "Status" CHAR(1) CS_FIXEDSTRING DEFAULT 'O', "TrgGroup" INTEGER CS_INT DEFAULT -1, "VisOrder" INTEGER CS_INT, "DistrbMthd" CHAR(1) CS_FIXEDSTRING, "DistribExp" CHAR(1) CS_FIXEDSTRING, "FixCurr" NVARCHAR(3), "VatDscntPr" DECIMAL(21,6) CS_FIXED, "OcrCode" NVARCHAR(8), "OcrCode2" NVARCHAR(8), "OcrCode3" NVARCHAR(8), "OcrCode4" NVARCHAR(8), "OcrCode5" NVARCHAR(8), "Project" NVARCHAR(20), PRIMARY KEY INVERTED VALUE ("DocEntry", "LineNum", "GroupNum")) UNLOAD PRIORITY 5  AUTO MERGE ;
ALTER TABLE "IMCYC"."PQT13" WITH PARAMETERS ('CONCAT_ATTRIBUTE'=('$DocEntry$LineNum$','DocEntry','LineNum'));
CREATE INDEX "PQT13_LINE" ON "IMCYC"."PQT13" ( "DocEntry" ASC, "LineNum" ASC )