Table: Company EFT Banks

Table: CPCOBK
View: CP0200
Record Length: 915

Flags: A R 

Keys: 1

Title Flags Fields

Company EFT Bank BANKID

Fields: 55

Field Type Title Presentation

BANKID String*8 Company EFT Bank Mask: %-8N
AUDTDATE Date
AUDTTIME Time
AUDTUSER String*8
AUDTORG String*6
BANKFORMAT Integer Bank Format 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 String*10 Originator Number
COMPABREV String*16 Company Abbreviated Name Mask: %-15c
COMPLNAME String*30 Company Name
DATACENTER String*5 Data Center No. Mask: %-5d
INSTIDRTN String*9 Institution ID for Returns Mask: %-9d
ACCTNORTN String*18 Account No. for Returns Mask: %-12c
RESERVDORG String*15 Reserved Field for Organization
ELEMENTID String*11 Element ID
REGLECODE String*2 Reglement Code
CPATRNCODE String*3 CPA Transaction Code
CODISCDATA String*20 RESERVED - US Only
SERVCLASS String*3 RESERVED - US Only
ORIGSTATUS Integer RESERVED - US Only
ORIGDFIID String*9 Originator DFI ID Mask: %-9d
ALTIMMDEST Boolean RESERVED - US Only
IMMDESTID String*10 Immediate Destination ID Mask: %-9d
IMMDESTNAM String*23 Immediate Destination Name
ALTIMMORIG Boolean RESERVED - US Only
IMMORIGNUM String*10 Immediate Origin No. Mask: %-9d
IMMORIGNAM String*23 Immediate Origin Name
OFFRECTYPE String*1 RESERVED - US Only
OFFTRNCODE Integer RESERVED - US Only
OFFRDFIID String*9 RESERVED - US Only
OFFRDFIACC String*17 RESERVED - US Only
OFFINDVID String*15 RESERVED - US Only
OFFINDVNAM String*22 RESERVED - US Only
OFFDISDATA String*2 RESERVED - US Only
APPENDCRLF Boolean Append CR/LF to Each Record?
FILEHEADER String*250 Deposit File Header
FILEFOOTER String*250 Deposit File Footer
DPFILENAME String*8 Deposit File Name
DPFILEEXT String*3 Deposit File Extension
EFTRUNSEQ Long Last EFT Run Sequence
RERUNSEQ Long Last EFT Rerun Sequence
CREATDATE Date Last File Creation Date
FILCREATNO String*4 Last File Creation Number
FILIDMODIF String*1 RESERVED - US Only
ENTRYDESC String*10 RESERVED - US Only
LASTMAINT Date Last Maintained
CMBFILECNO String*4 Last Combine File Creation Number
FREXIND Integer Foreign Exchange Indicator List:2 entries
1 = Fixed to Variable
2 = Fixed to Fixed
FRREFIND Integer Foreign Reference Indicator List:3 entries
1 = Foreign Exchange Rate
2 = Foreign Exchange Reference Number
3 = Space Filled
FREXREF String*15 Foreign Exchange Reference
TRANSTYPE Integer Transaction Type 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 String*10 Company Entry Description
ITMTRANUM Integer Item Trace Number List:2 entries
0 = Zero Fill
1 = Blank Fill
ORIGDFICTY String*3 Originator DFI Country Code Mask: %-2C
EFTTYPE Integer RESERVED - US Only List:2 entries
1 = Direct Deposit EFT
2 = Child Support EFT
CASESTATE String*2 RESERVED - US Only