CREATE COLUMN TABLE "IMCYC"."OIWZ" ("AbsEntry" INTEGER CS_INT NOT NULL , "WizName" NVARCHAR(100), "PostDateTo" LONGDATE CS_LONGDATE, "WizType" CHAR(1) CS_FIXEDSTRING, "IndexCode" NVARCHAR(3), "IndexRate" DECIMAL(21,6) CS_FIXED, "CashAcct" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "CashFrmBl" DECIMAL(21,6) CS_FIXED, "CashCancel" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "FromItem" NVARCHAR(50), "ToItem" NVARCHAR(50), "ItemGroup" SMALLINT CS_INT, "Properties" NVARCHAR(250), "RvalMethod" CHAR(1) CS_FIXEDSTRING DEFAULT 'P', "PriceSour" SMALLINT CS_INT, "TransAbs" INTEGER CS_INT, "UseDLN" CHAR(1) CS_FIXEDSTRING DEFAULT 'Y', "UsePCH" CHAR(1) CS_FIXEDSTRING DEFAULT 'Y', "UsePCHNoSt" CHAR(1) CS_FIXEDSTRING DEFAULT 'Y', "UseImport" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "CashDifBal" DECIMAL(21,6) CS_FIXED, "CashExecut" CHAR(1) CS_FIXEDSTRING DEFAULT 'Y', "ActType" CHAR(1) CS_FIXEDSTRING DEFAULT 'A', "VarRate" DECIMAL(21,6) CS_FIXED, "FilterExe" CHAR(1) CS_FIXEDSTRING DEFAULT 'Y', "CashErrRes" INTEGER CS_INT, "CshRvToAct" NVARCHAR(15), "MarkVar" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "ChngPrice" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "UseSemestr" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "CreateDate" LONGDATE CS_LONGDATE, "CshLstRvBl" DECIMAL(21,6) CS_FIXED, "userSign" SMALLINT CS_INT, "userSign2" SMALLINT CS_INT, "CshCanclD" LONGDATE CS_LONGDATE, PRIMARY KEY ("AbsEntry")) UNLOAD PRIORITY 5  AUTO MERGE 