View: Company EFT Banks

RotoID: CP0200
Table: CPCOBK
Protocol: Flat
DLL:CPCOBK

Keys: 1

Title Fields

Company EFT Bank BANKID

Fields: 52

Field Index Type Title Attributes Presentation

BANKID 1 String*8 Company EFT Bank E A K R  Mask: %-8N
BANKFORMAT 2 Integer Bank Format E A  List:20 entries
1 = CPA Standard 005
18 = CPA Standard 005 with Offset Record
2 = CPA Standard - Existing
3 = Alberta Treasury Branch
4 = Bank of Montreal
5 = Bank of Nova Scotia
6 = BC Central Credit Union
7 = Caisse Desjardins, Laurentian Bank
8 = Canadian Imperial Bank of Commerce
9 = First Chicago NBD Bank, Canada
10 = HSBC Bank Canada - Existing
17 = HSBC Bank Canada - New ASCII
19 = HSBC Bank Canada with Offset Record
16 = National Bank - 96 Byte Format
11 = National Bank - CPA Format
12 = Ontario Credit Union
13 = Royal Bank - Existing
14 = Royal Bank - New
15 = TD Bank
24 = IAT Transfers
ORIGNUM 3 String*10 Originator Number E A X 
COMPABREV 4 String*16 Company Abbreviated Name E A  Mask: %-15c
COMPLNAME 5 String*30 Company Name E A X 
DATACENTER 6 String*5 Data Center No. E A X  Mask: %-5d
INSTIDRTN 7 String*9 Institution ID for Returns E A X  Mask: %-9d
ACCTNORTN 8 String*18 Account No. for Returns E A X  Mask: %-12c
RESERVDORG 9 String*15 Reserved Field for Organization E A X 
ELEMENTID 10 String*11 Element ID E A X 
REGLECODE 11 String*2 Reglement Code E A X 
CPATRNCODE 12 String*3 CPA Transaction Code E A X 
CODISCDATA 13 String*20 RESERVED - US Only X 
SERVCLASS 14 String*3 RESERVED - US Only X 
ORIGSTATUS 15 Integer RESERVED - US Only X 
ORIGDFIID 16 String*9 Originator DFI ID E A X  Mask: %-9d
ALTIMMDEST 17 Boolean RESERVED - US Only X 
IMMDESTID 18 String*10 Immediate Destination ID E A X  Mask: %-9d
IMMDESTNAM 19 String*23 Immediate Destination Name E A X 
ALTIMMORIG 20 Boolean RESERVED - US Only X 
IMMORIGNUM 21 String*10 Immediate Origin No. E A X  Mask: %-9d
IMMORIGNAM 22 String*23 Immediate Origin Name E A X 
OFFRECTYPE 23 String*1 RESERVED - US Only X 
OFFTRNCODE 24 Integer RESERVED - US Only P X 
OFFRDFIID 25 String*9 RESERVED - US Only X 
OFFRDFIACC 26 String*17 RESERVED - US Only X 
OFFINDVID 27 String*15 RESERVED - US Only X 
OFFINDVNAM 28 String*22 RESERVED - US Only X 
OFFDISDATA 29 String*2 RESERVED - US Only X 
APPENDCRLF 30 Boolean Append CR/LF to Each Record? E A X 
FILEHEADER 31 String*250 Deposit File Header E A X 
FILEFOOTER 32 String*250 Deposit File Footer E A X 
DPFILENAME 33 String*8 Deposit File Name E A 
DPFILEEXT 34 String*3 Deposit File Extension E A 
EFTRUNSEQ 35 Long Last EFT Run Sequence A X 
RERUNSEQ 36 Long Last EFT Rerun Sequence A X 
CREATDATE 37 Date Last File Creation Date A X 
FILCREATNO 38 String*4 Last File Creation Number A X 
FILIDMODIF 39 String*1 RESERVED - US Only X 
ENTRYDESC 40 String*10 RESERVED - US Only X 
LASTMAINT 41 Date Last Maintained E A C 
CMBFILECNO 42 String*4 Last Combine File Creation Number E A X 
FREXIND 43 Integer Foreign Exchange Indicator E A X  List:2 entries
1 = Fixed to Variable
2 = Fixed to Fixed
FRREFIND 44 Integer Foreign Reference Indicator E A X  List:3 entries
1 = Foreign Exchange Rate
2 = Foreign Exchange Reference Number
3 = Space Filled
FREXREF 45 String*15 Foreign Exchange Reference E A X 
TRANSTYPE 46 Integer Transaction Type E A X  List:11 entries
0 = ANN- Annuity
1 = DEP- Deposit
2 = LOA- Loan
3 = MIS- Miscellaneous
4 = MOR- Mortgage
5 = PEN- Pension
6 = RLS- Rent/Lease
7 = SAL- Salary/Payroll
8 = TAX- Tax
9 = TEL- Telephone Initiated Entry
10 = WEB- Web Initiated Entry
CMPENTDESC 47 String*10 Company Entry Description E A X 
ITMTRANUM 48 Integer Item Trace Number E A X  List:2 entries
0 = Zero Fill
1 = Blank Fill
ORIGDFICTY 49 String*3 Originator DFI Country Code E A X  Mask: %-2C
EFTTYPE 50 Integer RESERVED - US Only E A X  List:2 entries
1 = Direct Deposit EFT
2 = Child Support EFT
CASESTATE 51 String*2 RESERVED - US Only E A X 
BANKNAME 100 String*60 Bank Name E A C