CREATE COLUMN TABLE "IMCYC"."ADS1" ("BankCode" NVARCHAR(30), "Account" NVARCHAR(50), "Branch" NVARCHAR(50), "NextCheck" INTEGER CS_INT, "GLAccount" NVARCHAR(15), "Free" CHAR(1) CS_FIXEDSTRING, "Street" NVARCHAR(100), "Block" NVARCHAR(100), "ZipCode" NVARCHAR(20), "City" NVARCHAR(100), "County" NVARCHAR(100), "Country" NVARCHAR(3), "State" NVARCHAR(3), "BISR" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "ControlKey" NVARCHAR(2), "UsrNumber1" NVARCHAR(25), "UsrNumber2" NVARCHAR(25), "UsrNumber3" NVARCHAR(25), "UsrNumber4" NVARCHAR(25), "IBAN" NVARCHAR(50), "DscountBOE" NVARCHAR(15), "TolrnceDay" INTEGER CS_INT, "MinAmntBOE" DECIMAL(21,6) CS_FIXED, "MaxAmntBOE" DECIMAL(21,6) CS_FIXED, "DscntLimit" DECIMAL(21,6) CS_FIXED, "DaysInAdva" INTEGER CS_INT, "BankCollec" NVARCHAR(15), "BankDiscou" NVARCHAR(15), "BranchName" NVARCHAR(50), "AliasName" NVARCHAR(50), "CompanyCod" NVARCHAR(10), "AcctType" CHAR(1) CS_FIXEDSTRING, "Building" NCLOB MEMORY THRESHOLD 1000, "BIK" NVARCHAR(15), "AcctName" NVARCHAR(250), "CorresAcct" NVARCHAR(30), "Phone" NVARCHAR(25), "Fax" NVARCHAR(25), "GLIntriAct" NVARCHAR(15), "ChkPaper" CHAR(1) CS_FIXEDSTRING DEFAULT 'D', "MaxChkLine" SMALLINT CS_INT, "TmpltName" NVARCHAR(8), "AbsEntry" INTEGER CS_INT NOT NULL , "BankKey" INTEGER CS_INT, "LockChk" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "OurNum" INTEGER CS_INT, "AgreeNum" NVARCHAR(10), "AccountChk" CHAR(1) CS_FIXEDSTRING, "ISRType" SMALLINT CS_INT DEFAULT 2, "ISRBillerI" NVARCHAR(9), "CustIdNum" NVARCHAR(10) DEFAULT '0', "InSeri" SMALLINT CS_INT DEFAULT -1, "OutSeri" SMALLINT CS_INT DEFAULT -1, "JDTSeri" SMALLINT CS_INT DEFAULT -1, "FilePlug" NVARCHAR(50), "ImpStmt" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "PreNumber" CHAR(1) CS_FIXEDSTRING DEFAULT 'Y', "AddrType" NVARCHAR(100), "StreetNo" NVARCHAR(100), "LogInstanc" INTEGER CS_INT DEFAULT 0 NOT NULL , "UpdateDate" LONGDATE CS_LONGDATE, "UsrLogSign" SMALLINT CS_INT, "UserSign2" SMALLINT CS_INT, "SwiftNum" NVARCHAR(50), "FineAcct" NVARCHAR(15), "IntrstAcct" NVARCHAR(15), "DscntAcct" NVARCHAR(15), "SvcFeeAcct" NVARCHAR(15), "BranchChk" NVARCHAR(5), "RetFile" NVARCHAR(50), "IOFTaxAcct" NVARCHAR(15), "OthExpAcct" NVARCHAR(15), "OthIncAcct" NVARCHAR(15), "CollCode" NVARCHAR(50), "FileSeqNNo" INTEGER CS_INT, "RefCoLevel" CHAR(1) CS_FIXEDSTRING DEFAULT 'H', "RefFixLen1" SMALLINT CS_INT, "RefFixLen2" SMALLINT CS_INT, "Currency" NVARCHAR(3), PRIMARY KEY INVERTED VALUE ("AbsEntry", "LogInstanc")) UNLOAD PRIORITY 5  AUTO MERGE 