Table: Company EFT Banks

Table: UPCOBK
View: UP0200
Record length: 875
Flags: A R 

Keys: 1

Title  Flags  Fields

Company EFT Bank  BANKID

Fields: 46

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: 3 entries
21=ACH (NACHA) Standard
22=ACH (NACHA) Non Standard with Offset Record
23=CSB CoreState Bank
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   
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   

This page was generated on 2009-Nov-19

Copyright © 2001–2009 Sage Software, Inc. All rights reserved.