CREATE COLUMN TABLE "SBODEMODE"."FTR1" ("DocEntry" INTEGER CS_INT NOT NULL , "LineNum" INTEGER CS_INT NOT NULL , "ItemCode" NVARCHAR(50), "AcctCode" NVARCHAR(15), "Quantity" DECIMAL(21,6) CS_FIXED, "LineTotal" DECIMAL(21,6) CS_FIXED, "TotalFrgn" DECIMAL(21,6) CS_FIXED, "TotalSys" DECIMAL(21,6) CS_FIXED, "DprArea" NVARCHAR(15), "Remarks" NVARCHAR(100), "LogInstanc" INTEGER CS_INT DEFAULT 0, "NewItemCod" NVARCHAR(50), "Partial" NVARCHAR(1) DEFAULT 'N', "APC" DECIMAL(21,6) CS_FIXED, "NewAstCls" NVARCHAR(20), "ObjType" NVARCHAR(20), "TransType" NVARCHAR(4), "OcrCode" NVARCHAR(8), "OcrCode2" NVARCHAR(8), "OcrCode3" NVARCHAR(8), "OcrCode4" NVARCHAR(8), "OcrCode5" NVARCHAR(8), "Project" NVARCHAR(20), PRIMARY KEY ("DocEntry", "LineNum")) UNLOAD PRIORITY 5  AUTO MERGE 