CREATE COLUMN TABLE "IMCYC"."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" CHAR(1) CS_FIXEDSTRING DEFAULT 'G', "Status" CHAR(1) CS_FIXEDSTRING DEFAULT 'D', "Owner" INTEGER CS_INT, "Renewal" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "UseDiscnt" CHAR(1) CS_FIXEDSTRING DEFAULT 'Y', "RemindVal" SMALLINT CS_INT, "RemindUnit" CHAR(1) CS_FIXEDSTRING 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" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "DataSource" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "Transfered" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "RemindFlg" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "Fulfilled" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "Attachment" NCLOB MEMORY THRESHOLD 1000, "SettleProb" DECIMAL(21,6) CS_FIXED, "UpdtTime" INTEGER CS_INT, "Method" CHAR(1) CS_FIXEDSTRING DEFAULT 'I', "GroupNum" SMALLINT CS_INT, "ListNum" SMALLINT CS_INT, "SignDate" LONGDATE CS_LONGDATE, "AmendedTo" INTEGER CS_INT, "Series" SMALLINT CS_INT, "Number" INTEGER CS_INT, "ObjType" NVARCHAR(20) DEFAULT '1250000025', "Handwrtten" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "PIndicator" NVARCHAR(10) DEFAULT ' ', "BpType" CHAR(1) CS_FIXEDSTRING DEFAULT 'C', "Instance" SMALLINT CS_INT DEFAULT 0, "PayMethod" NVARCHAR(15), PRIMARY KEY INVERTED VALUE ("AbsID", "LogInstanc")) UNLOAD PRIORITY 5  AUTO MERGE 