CREATE COLUMN TABLE "SBODEMOPT"."AOAT" ("AbsID" INTEGER CS_INT NOT NULL , "BpCode" NVARCHAR(15), "BpName" NVARCHAR(100), "CntctCode" INTEGER CS_INT, "StartDate" LONGDATE CS_LONGDATE, "EndDate" LONGDATE CS_LONGDATE, "TermDate" LONGDATE CS_LONGDATE, "Descript" NVARCHAR(254), "Type" NVARCHAR(1) DEFAULT 'G', "Status" NVARCHAR(1) DEFAULT 'D', "Owner" INTEGER CS_INT, "Renewal" NVARCHAR(1) DEFAULT 'N', "UseDiscnt" NVARCHAR(1) DEFAULT 'Y', "RemindVal" SMALLINT CS_INT, "RemindUnit" NVARCHAR(1) DEFAULT 'D', "Remarks" NCLOB MEMORY THRESHOLD 1000, "AtchEntry" INTEGER CS_INT, "LogInstanc" INTEGER CS_INT DEFAULT 0 NOT NULL , "UserSign" SMALLINT CS_INT, "UserSign2" SMALLINT CS_INT, "UpdtDate" LONGDATE CS_LONGDATE, "CreateDate" LONGDATE CS_LONGDATE, "Cancelled" NVARCHAR(1) DEFAULT 'N', "DataSource" NVARCHAR(1) DEFAULT 'N', "Transfered" NVARCHAR(1) DEFAULT 'N', "RemindFlg" NVARCHAR(1) DEFAULT 'N', "Fulfilled" NVARCHAR(1) DEFAULT 'N', "Attachment" NCLOB MEMORY THRESHOLD 1000, "SettleProb" DECIMAL(21,6) CS_FIXED, "UpdtTime" INTEGER CS_INT, "Method" NVARCHAR(1) DEFAULT 'I', "GroupNum" SMALLINT CS_INT, "ListNum" SMALLINT CS_INT, "SignDate" LONGDATE CS_LONGDATE, "AmendedTo" INTEGER CS_INT, "Series" INTEGER CS_INT, "Number" INTEGER CS_INT, "ObjType" NVARCHAR(20) DEFAULT '1250000025', "Handwrtten" NVARCHAR(1) DEFAULT 'N', "PIndicator" NVARCHAR(10) DEFAULT ' ', "BpType" NVARCHAR(1) DEFAULT 'C', "Instance" SMALLINT CS_INT DEFAULT 0, "PayMethod" NVARCHAR(15), "NumAtCard" NVARCHAR(100), "BPCurr" NVARCHAR(3), "FixedRate" DECIMAL(21,6) CS_FIXED, "TrnspCode" SMALLINT CS_INT, "Project" NVARCHAR(20), "PriceMode" NVARCHAR(1) DEFAULT 'N', "WddStatus" NVARCHAR(1) DEFAULT '-', "FromStat" NVARCHAR(1) DEFAULT 'D', "DPPStatus" NVARCHAR(1) DEFAULT 'N', "SAPPassprt" NCLOB MEMORY THRESHOLD 1000, "EncryptIV" NVARCHAR(100), PRIMARY KEY ("AbsID", "LogInstanc")) UNLOAD PRIORITY 5  AUTO MERGE 