CREATE COLUMN TABLE "IMCYC"."OFLT" ("FormNum" NVARCHAR(20) NOT NULL , "QueryStr" NVARCHAR(250), "ItmOrCrd" CHAR(1) CS_FIXEDSTRING DEFAULT 'Y', "CardInclud" CHAR(1) CS_FIXEDSTRING DEFAULT 'Y', "CardFrom1" NVARCHAR(15), "CardTo1" NVARCHAR(15), "CardExclud" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "CardFrom2" NVARCHAR(15), "CardTo2" NVARCHAR(15), "ClienGroup" SMALLINT CS_INT, "VendGroup" SMALLINT CS_INT, "ClntQryGrp" NVARCHAR(250), "VeQryGroup" NVARCHAR(250), "ItmInclud" CHAR(1) CS_FIXEDSTRING DEFAULT 'Y', "ItmFrom1" NVARCHAR(50), "ItmTo1" NVARCHAR(50), "ItmExclud" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "ItmFrom2" NVARCHAR(50), "ItmTo2" NVARCHAR(50), "ItmGroup" SMALLINT CS_INT, "ItQryGroup" NVARCHAR(250), "WhsInclude" CHAR(1) CS_FIXEDSTRING DEFAULT 'Y', "WhsFrom1" NVARCHAR(8), "WhsTo1" NVARCHAR(8), "WhsExclude" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "WhsFrom2" NVARCHAR(8), "WhsTo2" NVARCHAR(8), "FromAcct" NVARCHAR(15), "ToAcct" NVARCHAR(15), "GroupMask" NVARCHAR(12), "FromDate" LONGDATE CS_LONGDATE, "ToDate" LONGDATE CS_LONGDATE, "FrmDueDate" LONGDATE CS_LONGDATE, "ToDueDate" LONGDATE CS_LONGDATE, "FromDate3" LONGDATE CS_LONGDATE, "ToDate3" LONGDATE CS_LONGDATE, "FromDate4" LONGDATE CS_LONGDATE, "ToDate4" LONGDATE CS_LONGDATE, "SourceType" SMALLINT CS_INT DEFAULT -1, "FrmTrnsNum" INTEGER CS_INT, "ToTrnsNum" INTEGER CS_INT, "FromRef1" NVARCHAR(100), "ToRef1" NVARCHAR(100), "FromRef2" NVARCHAR(100), "ToRef2" NVARCHAR(100), "FrmTrnsCod" NVARCHAR(4), "ToTrnsCod" NVARCHAR(4), "FromSum" DECIMAL(21,6) CS_FIXED, "ToSum" DECIMAL(21,6) CS_FIXED, "FrmFRNAmnt" DECIMAL(21,6) CS_FIXED, "ToFRNAmnt" DECIMAL(21,6) CS_FIXED, "MemoIn" NVARCHAR(50), "SortField1" SMALLINT CS_INT DEFAULT -1, "Break1" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "SortField2" SMALLINT CS_INT DEFAULT -1, "Break2" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "SortField3" SMALLINT CS_INT DEFAULT -1, "Break3" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "Display" CHAR(1) CS_FIXEDSTRING DEFAULT 'L', "PrntCutDat" CHAR(1) CS_FIXEDSTRING DEFAULT 'Y', "CheckBox0" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "CheckBox1" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "CheckBox2" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "CheckBox3" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "CheckBox4" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "CheckBox5" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "CheckBox6" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "CheckBox7" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "CheckBox8" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "CheckBox9" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "ShowZero" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "DateCheck" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "DueCheck" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "CutCheck" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "CutByObj" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "ObjectC1" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "ObjectC2" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "ObjectC3" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "ObjectC4" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "ObjectC5" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "ObjectC6" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "ObjectC7" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "ObjectC8" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "ObjectC9" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "ObjectC10" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "ObjectC11" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "ObjectC12" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "ObjectC13" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "ObjectC14" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "ObjectC15" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "ObjectC16" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "FromAmount" DECIMAL(21,6) CS_FIXED, "ToAmount" DECIMAL(21,6) CS_FIXED, "FrmSalsMan" SMALLINT CS_INT, "ToSalsMan" SMALLINT CS_INT, "USER_CHK1" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "USER_CHK2" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "USER_CHK3" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "USER_CHK4" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "USER_CHK5" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "UseSort" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "Sort1Up" CHAR(1) CS_FIXEDSTRING DEFAULT 'Y', "Sort2Up" CHAR(1) CS_FIXEDSTRING DEFAULT 'Y', "Sort3Up" CHAR(1) CS_FIXEDSTRING DEFAULT 'Y', "FromAmnt2" DECIMAL(21,6) CS_FIXED, "ToAmount2" DECIMAL(21,6) CS_FIXED, "TaxDateFro" LONGDATE CS_LONGDATE, "TaxDateTo" LONGDATE CS_LONGDATE, "FinancYear" LONGDATE CS_LONGDATE, "BdgtScenar" INTEGER CS_INT, "CompFolder" NVARCHAR(100), "CheckBox10" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "FROM_FC" DECIMAL(21,6) CS_FIXED, "TO_FC" DECIMAL(21,6) CS_FIXED, "FCCurrency" NVARCHAR(3), "TaxCheck" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "DateType" CHAR(1) CS_FIXEDSTRING DEFAULT 'R', "DateType2" CHAR(1) CS_FIXEDSTRING DEFAULT 'R', "FromPrject" NVARCHAR(20), "ToProject" NVARCHAR(20), "TemplateId" INTEGER CS_INT DEFAULT 0, "ShowLeads" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "MthDate" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "AccntntCod" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "UserSign" SMALLINT CS_INT NOT NULL , "BlcNunFrom" NVARCHAR(100), "BlcNunTo" NVARCHAR(100), "ImpLogFrom" NVARCHAR(20), "ImpLogTo" NVARCHAR(20), "FolderNum" CHAR(1) CS_FIXEDSTRING DEFAULT '1', "MainField" SMALLINT CS_INT DEFAULT 23, "TransMode" CHAR(1) CS_FIXEDSTRING DEFAULT 'Y', "MonthMode" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "CheckBox11" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "FromIdc" NVARCHAR(2), "ToIdc" NVARCHAR(2), "IgnoreAdj" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "RefNumFrom" NVARCHAR(254), "RefNumTo" NVARCHAR(254), "PymNumfrom" INTEGER CS_INT, "PymNumTo" INTEGER CS_INT, "BankFrom" NVARCHAR(30), "BankTo" NVARCHAR(30), "DpstFrom" INTEGER CS_INT, "DpstTo" INTEGER CS_INT, "DpstType" CHAR(1) CS_FIXEDSTRING, "ObjectC17" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "ObjectC18" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "ObjectC19" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "ObjAbs" INTEGER CS_INT, "AddBTF" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "FilePath" NCLOB MEMORY THRESHOLD 1000, "DpsBnkActF" NVARCHAR(50), "DpsBnkActT" NVARCHAR(50), "FromKey" INTEGER CS_INT, "ToKey" INTEGER CS_INT, "ObjectC20" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "ObjectC21" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "ObjectC22" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "ObjectC23" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "ObjectC25" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "USER_CHK6" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "OcrChkDim2" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "OcrChkDim3" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "OcrChkDim4" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "OcrChkDim5" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "OcrFrom2" NVARCHAR(8), "OcrFrom3" NVARCHAR(8), "OcrFrom4" NVARCHAR(8), "OcrFrom5" NVARCHAR(8), "OcrTo2" NVARCHAR(8), "OcrTo3" NVARCHAR(8), "OcrTo4" NVARCHAR(8), "OcrTo5" NVARCHAR(8), "TaxAdjRep" NCLOB MEMORY THRESHOLD 1000, "ObjectC26" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "CBFilter" CHAR(1) CS_FIXEDSTRING DEFAULT '2', "OBIncluded" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "OBFilter" CHAR(1) CS_FIXEDSTRING DEFAULT '1', "ExportCurr" CHAR(1) CS_FIXEDSTRING DEFAULT 'L', "CBIncluded" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "SlpFrom" NVARCHAR(155), "SlpTo" NVARCHAR(155), "CBUDF" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "CBREF" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "CheckBoxB" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "FilterName" NVARCHAR(30) DEFAULT '_' NOT NULL , "JDTFixedF" SMALLINT CS_INT, "JDT1FixedF" SMALLINT CS_INT, "JDTUserF" SMALLINT CS_INT, "JDT1UserF" SMALLINT CS_INT, "BPFilter" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "AcctFltr" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "ZeroLCAmt" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "SplitByBin" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "SplitBySnb" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "CheckBox12" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "CheckBox13" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "CheckBox14" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "CheckBox15" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "CheckBox16" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "CheckBox17" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "CheckBox18" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "CheckBox19" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "CheckBox20" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "CheckBox21" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "CheckBox22" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "CheckBox23" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "CheckBox24" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "CheckBox25" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "CheckBox26" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "CheckBox27" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "CheckBox28" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "CheckBox29" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "CheckBox30" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "CheckBox31" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "CheckBox32" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "CheckBox33" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "BatchFrom" NVARCHAR(36), "BatchTo" NVARCHAR(36), "BatAttr1F" NVARCHAR(36), "BatAttr1T" NVARCHAR(36), "BatAttr2F" NVARCHAR(36), "BatAttr2T" NVARCHAR(36), "SerialNoF" NVARCHAR(36), "SerialNoT" NVARCHAR(36), "MfrSerailF" NVARCHAR(36), "MfrSerailT" NVARCHAR(36), "LotNumberF" NVARCHAR(36), "LotNumberT" NVARCHAR(36), "BinLocFrom" NVARCHAR(228), "BinLocTo" NVARCHAR(228), "AltSrtCodF" NVARCHAR(50), "AltSrtCodT" NVARCHAR(50), "BinSbl1F" NVARCHAR(50), "BinSbl1To" NVARCHAR(50), "BinSbl2F" NVARCHAR(50), "BinSbl2To" NVARCHAR(50), "BinSbl3F" NVARCHAR(50), "BinSbl3To" NVARCHAR(50), "BinSbl4F" NVARCHAR(50), "BinSbl4To" NVARCHAR(50), "BinAttr1F" NVARCHAR(20), "BinAttr1To" NVARCHAR(20), "BinAttr2F" NVARCHAR(20), "BinAttr2To" NVARCHAR(20), "BinAttr3F" NVARCHAR(20), "BinAttr3To" NVARCHAR(20), "BinAttr4F" NVARCHAR(20), "BinAttr4To" NVARCHAR(20), "BinAttr5F" NVARCHAR(20), "BinAttr5To" NVARCHAR(20), "BinAttr6F" NVARCHAR(20), "BinAttr6To" NVARCHAR(20), "BinAttr7F" NVARCHAR(20), "BinAttr7To" NVARCHAR(20), "BinAttr8F" NVARCHAR(20), "BinAttr8To" NVARCHAR(20), "BinAttr9F" NVARCHAR(20), "BinAttr9To" NVARCHAR(20), "BinAttr10F" NVARCHAR(20), "BinAttr10T" NVARCHAR(20), "EnfBinFltr" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "ExItemFrom" NVARCHAR(50), "ExItemTo" NVARCHAR(50), "ExBPFrom" NVARCHAR(15), "ExBPTo" NVARCHAR(15), "CheckBox34" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "CheckBox35" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "BlAgreem" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "BAFrom" NVARCHAR(8), "BATo" NVARCHAR(8), "AdjTrans" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "TitAcctLvl" INTEGER CS_INT DEFAULT 2, "CCDFrom1" NVARCHAR(40), "CCDTo1" NVARCHAR(40), "CCDFrom2" NVARCHAR(40), "CCDTo2" NVARCHAR(40), "ArchJrnal" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "CardFrom3" NVARCHAR(15), "CardTo3" NVARCHAR(15), "OBBranch" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "AccumDbCr" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', PRIMARY KEY INVERTED VALUE ("FormNum", "UserSign", "FilterName")) UNLOAD PRIORITY 5  AUTO MERGE 