CREATE COLUMN TABLE "SBODEMOPT"."ADO9" ("DocEntry" INTEGER CS_INT NOT NULL , "LineNum" INTEGER CS_INT NOT NULL , "BaseAbs" INTEGER CS_INT, "BaseLine" INTEGER CS_INT, "TargetBase" NVARCHAR(1) 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 NOT NULL , "ObjCode" NVARCHAR(20) NOT NULL , "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" NVARCHAR(1) 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" NVARCHAR(1) DEFAULT 'N', PRIMARY KEY ("DocEntry", "LineNum", "ObjCode", "LogInstanc")) UNLOAD PRIORITY 5  AUTO MERGE 