CREATE COLUMN TABLE "IMCYC"."OPYM" ("PayMethCod" NVARCHAR(15) NOT NULL , "Descript" NVARCHAR(100), "Type" CHAR(1) CS_FIXEDSTRING, "BankTransf" CHAR(1) CS_FIXEDSTRING, "Address" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "BankDet" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "CllctAutor" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "FrgnPmntBl" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "FrgnBnkBl" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "CurrRestr" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "PostOffBnk" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "MinAmount" DECIMAL(21,6) CS_FIXED, "MaxAmount" DECIMAL(21,6) CS_FIXED, "BnkDflt" NVARCHAR(30), "UserSign" SMALLINT CS_INT, "DataSource" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "CreateDate" LONGDATE CS_LONGDATE, "BankCountr" NVARCHAR(3), "DflAccount" NVARCHAR(50), "GLAccount" NVARCHAR(15), "Branch" NVARCHAR(50), "KeyCode" NVARCHAR(6), "TrnsType" NVARCHAR(2), "Format" NVARCHAR(11), "AgtCollect" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "SendAccept" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "GrpByDate" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "DepNorm" NVARCHAR(8), "DebitMemo" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "GroupPmRef" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "GroupInv" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "ValDateSel" CHAR(1) CS_FIXEDSTRING DEFAULT 'P', "PaymTerms" SMALLINT CS_INT, "IntrimAcct" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "BnkActKey" INTEGER CS_INT, "DocType" NVARCHAR(2), "Accepted" CHAR(1) CS_FIXEDSTRING, "PtfID" NVARCHAR(3), "PtfCode" NVARCHAR(2), "PtfNum" NVARCHAR(4), "CurCode" NVARCHAR(2), "Instruct1" NVARCHAR(2), "Instruct2" NVARCHAR(2), "PaymntPlc" NVARCHAR(128), "BoeDll" NVARCHAR(50), "BankCtlKey" NVARCHAR(2), "Active" CHAR(1) CS_FIXEDSTRING DEFAULT 'Y', "BcgPcnt" DECIMAL(21,6) CS_FIXED, "GrpByCur" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "GrpByBank" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "DflIBAN" NVARCHAR(50), "DflSwift" NVARCHAR(50), "BoeReport" NVARCHAR(8), "CancInstr" NVARCHAR(2), "OccurCode" NVARCHAR(2), "MovmntCode" NVARCHAR(10), "NegPymCode" NVARCHAR(15), "DirectDbt" NVARCHAR(5) DEFAULT ' ', "IssueIndic" CHAR(1) CS_FIXEDSTRING DEFAULT 'R', "PrintSEPA" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "PmntType" NVARCHAR(50) DEFAULT '01', "GrpByAgrNo" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', PRIMARY KEY ("PayMethCod")) UNLOAD PRIORITY 0  AUTO MERGE 