CREATE COLUMN TABLE "SBODEMODE"."AEXD" ("ExpnsCode" INTEGER CS_INT NOT NULL , "ExpnsName" NVARCHAR(20), "RevAcct" NVARCHAR(15), "ExpnsAcct" NVARCHAR(15), "TaxLiable" NVARCHAR(1) DEFAULT 'N', "RevFixSum" DECIMAL(21,6) CS_FIXED, "ExpFixSum" DECIMAL(21,6) CS_FIXED, "DataSource" NVARCHAR(1) DEFAULT 'N', "UserSign" SMALLINT CS_INT, "VatGroupI" NVARCHAR(8), "VatGroupO" NVARCHAR(8), "DistrbMthd" NVARCHAR(1) DEFAULT 'N', "In1099" NVARCHAR(1) DEFAULT 'N', "ExpOfstAct" NVARCHAR(15), "WTLiable" NVARCHAR(1) DEFAULT 'N', "BaseMethod" NVARCHAR(1) DEFAULT 'T', "Stock" NVARCHAR(1) DEFAULT 'N', "LstPchPrce" NVARCHAR(1) DEFAULT 'N', "SalseRpt" NVARCHAR(1) DEFAULT 'N', "PchRpt" NVARCHAR(1) DEFAULT 'N', "RevExmAcct" NVARCHAR(15), "ExpnsExAct" NVARCHAR(15), "RevRetAct" NVARCHAR(15), "ExpnsType" NVARCHAR(1), "OcrCode" NVARCHAR(8), "TaxDisMthd" NVARCHAR(1) DEFAULT 'N', "OcrCode2" NVARCHAR(8), "OcrCode3" NVARCHAR(8), "OcrCode4" NVARCHAR(8), "OcrCode5" NVARCHAR(8), "OcrCodeX" NVARCHAR(100), "LogInstanc" INTEGER CS_INT DEFAULT 0 NOT NULL , "UpdateDate" LONGDATE CS_LONGDATE, "UserSign2" SMALLINT CS_INT, "Project" NVARCHAR(20), "Intrastat" NVARCHAR(1) DEFAULT 'N', "GrsFreight" NVARCHAR(1) DEFAULT 'N', "SacCode" NVARCHAR(8), "FreighType" NVARCHAR(1) DEFAULT 'S', "DataVers" INTEGER CS_INT DEFAULT 1, "DocFreight" NVARCHAR(1) DEFAULT 'N', "ProdctType" NVARCHAR(1) DEFAULT 'S', "ProdTypeEx" NVARCHAR(10) DEFAULT 'S', "IsActive" NVARCHAR(1) DEFAULT 'Y', PRIMARY KEY ("ExpnsCode", "LogInstanc")) UNLOAD PRIORITY 5  AUTO MERGE 