CREATE COLUMN TABLE "IMCYC"."AEC2" ("AbsEntry" INTEGER CS_INT NOT NULL , "Code" CHAR(1) CS_FIXEDSTRING, "ParentID" INTEGER CS_INT, "ActType" CHAR(1) CS_FIXEDSTRING, "ActDesc" NVARCHAR(100), "ActStatus" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "IsRemoved" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "ActMessage" NVARCHAR(254), "ActEnv" INTEGER CS_INT DEFAULT -1, "BPLId" INTEGER CS_INT DEFAULT -1, "Submits" SMALLINT CS_INT, "ObjectID" NVARCHAR(50), "ReportID" NVARCHAR(50), "SrcObjType" NVARCHAR(20), "SrcObjAbs" INTEGER CS_INT, "Cancel" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "AssignedID" NVARCHAR(50), "DocBtch" NVARCHAR(50), "DocBtchLn" SMALLINT CS_INT, "GenType" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "TestMode" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "PeriodType" CHAR(1) CS_FIXEDSTRING, "PeriodNum" INTEGER CS_INT, "Year" SMALLINT CS_INT, "DateFrom" LONGDATE CS_LONGDATE, "DateTo" LONGDATE CS_LONGDATE, "UserSign" SMALLINT CS_INT, "CreateDate" LONGDATE CS_LONGDATE, "CreateTS" INTEGER CS_INT, "UserSign2" SMALLINT CS_INT, "UpdateDate" LONGDATE CS_LONGDATE, "UpdateTS" INTEGER CS_INT, "LogInstanc" SMALLINT CS_INT NOT NULL , "U_B1SYS_SignMsg" NCLOB MEMORY THRESHOLD 1000, "U_B1SYS_SignDigest" NCLOB MEMORY THRESHOLD 1000, PRIMARY KEY INVERTED VALUE ("AbsEntry", "LogInstanc")) UNLOAD PRIORITY 5  AUTO MERGE 