View: Company EFT Banks

RotoID: UP0200
Table: UPCOBK
Protocol: Flat
DLL:UPCOBK

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:4 entries
21 = ACH (NACHA) Standard
22 = ACH (NACHA) Non Standard with Offset Record
23 = CSB CoreState Bank
24 = IAT Transfers
ORIGNUM 3 String*10 Originator Number E A X 
COMPABREV 4 String*16 Company Abbreviated Name E A  Mask: %-16c
COMPLNAME 5 String*30 RESERVED - Cdn Only X 
DATACENTER 6 String*5 RESERVED - Cdn Only X 
INSTIDRTN 7 String*9 RESERVED - Cdn Only X 
ACCTNORTN 8 String*18 RESERVED - Cdn Only X 
RESERVDORG 9 String*15 RESERVED - Cdn Only X 
ELEMENTID 10 String*11 RESERVED - Cdn Only X 
REGLECODE 11 String*2 RESERVED - Cdn Only X 
CPATRNCODE 12 String*3 RESERVED - Cdn Only X 
CODISCDATA 13 String*20 Company Discretionary Name E A X 
SERVCLASS 14 String*3 Service Class Code E A X  Mask: %-3d
ORIGSTATUS 15 Integer Originator Status Code E A X  List:2 entries
1 = 1 - Bound
2 = 2 - Unbound
ORIGDFIID 16 String*9 Originator DFI ID E A X  Mask: %-9d
ALTIMMDEST 17 Boolean Use Alternative Imm. Dest. ID? A 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 Use Alternative Imm. Origin No.? E A 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 Offset Record Type Code A X 
OFFTRNCODE 24 Integer Offset Transaction Code A P X  List:3 entries
0 =
27 = 27 - Checking
37 = 37 - Savings
OFFRDFIID 25 String*9 Offset Receiving DFI ID A X  Mask: %-9d
OFFRDFIACC 26 String*17 Offset DFI Account No. A X  Mask: %-17c
OFFINDVID 27 String*15 Offset Individual ID No. A X 
OFFINDVNAM 28 String*22 Offset Individual Name A X 
OFFDISDATA 29 String*2 Offset Discretionary Data A 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 Last File ID Modifier A X 
ENTRYDESC 40 String*10 Last File Entry Description A 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 RESERVED - Cdn Only X 
ORIGDFICTY 49 String*3 Originator DFI Country Code E A X  Mask: %-2C
EFTTYPE 50 Integer EFT Type E A X  List:2 entries
1 = Direct Deposit EFT
2 = Child Support EFT
CASESTATE 51 String*2 Case State E A X 
BANKNAME 100 String*60 Bank Name E A C