CREATE COLUMN TABLE "SBODEMOPT"."OITR" ("ReconNum" INTEGER CS_INT NOT NULL , "IsCard" NVARCHAR(1), "ReconType" NVARCHAR(2), "ReconDate" LONGDATE CS_LONGDATE, "Total" DECIMAL(21,6) CS_FIXED, "ReconCurr" NVARCHAR(3), "Canceled" NVARCHAR(1) DEFAULT 'N', "CancelAbs" INTEGER CS_INT DEFAULT 0, "IsSystem" NVARCHAR(1), "InitObjTyp" NVARCHAR(20), "InitObjAbs" INTEGER CS_INT, "CreateDate" LONGDATE CS_LONGDATE, "CreateTime" SMALLINT CS_INT, "DataSource" NVARCHAR(1) DEFAULT 'N', "UserSign" SMALLINT CS_INT, "ReconRule1" NVARCHAR(2), "ReconRule2" NVARCHAR(2), "ReconRule3" NVARCHAR(2), "IsMultiBP" NVARCHAR(1) DEFAULT 'N', "VersionNum" NVARCHAR(13), "OldMatNum" INTEGER CS_INT DEFAULT 0, "ReconJEId" INTEGER CS_INT, "BuildDesc" NVARCHAR(50), "BPLId" INTEGER CS_INT, "BPLName" NVARCHAR(100), "VATRegNum" NVARCHAR(32), "IsElectr" NVARCHAR(1) DEFAULT 'N', "CreateTS" INTEGER CS_INT, "UpdateTS" INTEGER CS_INT, "ObjType" NVARCHAR(20) DEFAULT '321', PRIMARY KEY ("ReconNum")) UNLOAD PRIORITY 5  AUTO MERGE 