CREATE COLUMN TABLE "IMCYC"."AOPR" ("OpprId" INTEGER CS_INT NOT NULL , "CardCode" NVARCHAR(15), "SlpCode" INTEGER CS_INT, "CprCode" INTEGER CS_INT, "Source" INTEGER CS_INT, "IntCat1" INTEGER CS_INT, "IntCat2" INTEGER CS_INT, "IntCat3" INTEGER CS_INT, "IntRate" INTEGER CS_INT, "OpenDate" LONGDATE CS_LONGDATE, "DifType" CHAR(1) CS_FIXEDSTRING DEFAULT 'D', "PredDate" LONGDATE CS_LONGDATE, "MaxSumLoc" DECIMAL(21,6) CS_FIXED, "MaxSumSys" DECIMAL(21,6) CS_FIXED, "WtSumLoc" DECIMAL(21,6) CS_FIXED, "WtSumSys" DECIMAL(21,6) CS_FIXED, "PrcnProf" DECIMAL(21,6) CS_FIXED, "SumProfL" DECIMAL(21,6) CS_FIXED, "SumProfS" DECIMAL(21,6) CS_FIXED, "Memo" NCLOB MEMORY THRESHOLD 1000, "Status" CHAR(1) CS_FIXEDSTRING DEFAULT 'O', "StatusRem" NVARCHAR(30), "Reason" INTEGER CS_INT, "RealSumLoc" DECIMAL(21,6) CS_FIXED, "RealSumSys" DECIMAL(21,6) CS_FIXED, "RealProfL" DECIMAL(21,6) CS_FIXED, "RealProfS" DECIMAL(21,6) CS_FIXED, "CloPrcnt" DECIMAL(21,6) CS_FIXED, "StepLast" SMALLINT CS_INT, "UserSign" SMALLINT CS_INT, "Transfered" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "Instance" SMALLINT CS_INT DEFAULT 0, "CardName" NVARCHAR(100), "CloseDate" LONGDATE CS_LONGDATE, "LastSlp" INTEGER CS_INT, "Name" NVARCHAR(100), "Territory" INTEGER CS_INT, "Industry" INTEGER CS_INT, "ChnCrdCode" NVARCHAR(15), "ChnCrdName" NVARCHAR(100), "PrjCode" NVARCHAR(20), "CardGroup" SMALLINT CS_INT, "ChnCrdCon" INTEGER CS_INT, "Owner" INTEGER CS_INT, "attachment" NCLOB MEMORY THRESHOLD 1000, "DocType" NVARCHAR(9) DEFAULT '-1', "DocNum" INTEGER CS_INT, "DocEntry" INTEGER CS_INT, "DocChkbox" CHAR(1) CS_FIXEDSTRING, "AtcEntry" INTEGER CS_INT, "LogInstanc" INTEGER CS_INT DEFAULT 0 NOT NULL , "UserSign2" SMALLINT CS_INT, "UpdateDate" LONGDATE CS_LONGDATE, "OpprType" CHAR(1) CS_FIXEDSTRING DEFAULT 'R', "UpdateTS" INTEGER CS_INT, PRIMARY KEY INVERTED VALUE ("OpprId", "LogInstanc")) UNLOAD PRIORITY 5  AUTO MERGE 