Table: Company EFT Banks

Table: UPCOBK
View: UP0200
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:5 entries
21 = ACH (NACHA) Standard
22 = ACH (NACHA) Non Standard with Offset Record
23 = CSB CoreState Bank
24 = IAT Transfers
25 =
ORIGNUM String*10 Originator Number
COMPABREV String*16 Company Abbreviated Name Mask: %-16c
COMPLNAME String*30 RESERVED - Cdn Only
DATACENTER String*5 RESERVED - Cdn Only
INSTIDRTN String*9 RESERVED - Cdn Only
ACCTNORTN String*18 RESERVED - Cdn Only
RESERVDORG String*15 RESERVED - Cdn Only
ELEMENTID String*11 RESERVED - Cdn Only
REGLECODE String*2 RESERVED - Cdn Only
CPATRNCODE String*3 RESERVED - Cdn Only
CODISCDATA String*20 Company Discretionary Name
SERVCLASS String*3 Service Class Code Mask: %-3d
ORIGSTATUS Integer Originator Status Code List:2 entries
1 = 1 - Bound
2 = 2 - Unbound
ORIGDFIID String*9 Originator DFI ID Mask: %-9d
ALTIMMDEST Boolean Use Alternative Imm. Dest. ID?
IMMDESTID String*10 Immediate Destination ID Mask: %-9d
IMMDESTNAM String*23 Immediate Destination Name
ALTIMMORIG Boolean Use Alternative Imm. Origin No.?
IMMORIGNUM String*10 Immediate Origin No. Mask: %-9d
IMMORIGNAM String*23 Immediate Origin Name
OFFRECTYPE String*1 Offset Record Type Code
OFFTRNCODE Integer Offset Transaction Code List:3 entries
0 =
27 = 27 - Checking
37 = 37 - Savings
OFFRDFIID String*9 Offset Receiving DFI ID Mask: %-9d
OFFRDFIACC String*17 Offset DFI Account No. Mask: %-17c
OFFINDVID String*15 Offset Individual ID No.
OFFINDVNAM String*22 Offset Individual Name
OFFDISDATA String*2 Offset Discretionary Data
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 Last File ID Modifier
ENTRYDESC String*10 Last File Entry Description
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 RESERVED - Cdn Only
ORIGDFICTY String*3 Originator DFI Country Code Mask: %-2C
EFTTYPE Integer EFT Type List:2 entries
1 = Direct Deposit EFT
2 = Child Support EFT
CASESTATE String*2 Case State