CREATE COLUMN TABLE "IMCYC"."POR9" ("DocEntry" INTEGER CS_INT NOT NULL , "LineNum" INTEGER CS_INT NOT NULL , "BaseAbs" INTEGER CS_INT, "BaseLine" INTEGER CS_INT, "TargetBase" CHAR(1) CS_FIXEDSTRING DEFAULT 'B', "ObjType" NVARCHAR(20), "DrawnSum" DECIMAL(21,6) CS_FIXED, "DrawnSumFc" DECIMAL(21,6) CS_FIXED, "DrawnSumSc" DECIMAL(21,6) CS_FIXED, "LogInstanc" INTEGER CS_INT DEFAULT 0, "ObjCode" NVARCHAR(20) DEFAULT '22', "ApplDrawn" DECIMAL(21,6) CS_FIXED, "ApplDrawnF" DECIMAL(21,6) CS_FIXED, "ApplDrawnS" DECIMAL(21,6) CS_FIXED, "BaseDocNum" INTEGER CS_INT, "BsDocDate" LONGDATE CS_LONGDATE, "BsDueDate" LONGDATE CS_LONGDATE, "BsCardName" NVARCHAR(100), "BsComments" NVARCHAR(254), "Posted" CHAR(1) CS_FIXEDSTRING DEFAULT 'Y', "Vat" DECIMAL(21,6) CS_FIXED, "VatFc" DECIMAL(21,6) CS_FIXED, "VatSc" DECIMAL(21,6) CS_FIXED, "Gross" DECIMAL(21,6) CS_FIXED, "GrossFc" DECIMAL(21,6) CS_FIXED, "GrossSc" DECIMAL(21,6) CS_FIXED, "IsGross" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', PRIMARY KEY INVERTED VALUE ("DocEntry", "LineNum")) UNLOAD PRIORITY 0  AUTO MERGE 