BANKACCT FILE
Bank Account
Contains information about bank accounts. PR01.1 (Bank Account) is the
primary program that updates this file. Note that company is not part of the
key, thus bank accounts can be used by more than one company.
REFERENCED BY
BN66.1 HBAC.1 HR200 HR201 PR140 PR155
PR162 PR165 PR180 PR189 PR195 PR201
PR281 PR300 PR80.1 PR80.2 PR82.1 PR85.1
PR89.1
UPDATED BY
HR00.1 HR01.1 PBIP.1 PR01.1 PR160 PR197
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BAC-BNK-ACCT-NBR Alpha 17 HR00.1 HR01.1
Bank Account Number Contains the bank account from which PBIP.1 PR01.1
payroll payments are drawn. PR197
BAC-BANK-ID Numeric 9 HR00.1 HR01.1
Bank Identification Contains the ID number assigned to the PBIP.1 PR01.1
Number bank by the PR197
Federal Reserve.
BAC-BANK-NAME Alpha 30 (Lower Case) HR00.1 HR01.1
Bank Name Contains the bank name. PBIP.1 PR01.1
PR197
BAC-SEND-PT-ID Numeric 9 HR00.1 HR01.1
Sending Bank ID Contains the ID assigned by the Federal PBIP.1 PR01.1
Reserve to the bank that processes the PR197
ACH tape.
BAC-SEND-PT-NAME Alpha 30 (Lower Case) HR00.1 HR01.1
Sending Bank Name Contains the name of the sending DFI PBIP.1 PR01.1
bank. PR197
BAC-ACH-OPTION Alpha 1 HR00.1 HR01.1
ACH Option Contains the value that indicates if PBIP.1 PR01.1
the bank account allows ACH payments to PR197
be made.
N = No ACH allowed
Y = ACH allowed
BAC-CHECK-OPTION Numeric 1 HR00.1 HR01.1
Payment Format Contains the value that determines PBIP.1 PR01.1
which payment format is printed by PR160 PR197
(Payment Print).
0 = Over/Under Limited YTD
1 = Over/Under Stub On Top
2 = Over/Under Stub On Bottom
3 = Side/Side No TA Balances
4 = Side/Side TA Balances
5 = Side/Side Heat Sealed
9 = Over/Under Mailer
BAC-RECEIPT-OPTION Numeric 1 HR00.1 HR01.1
Receipt Option Contains the value that determines the PBIP.1 PR01.1
format for the ACH receipt. PR197
0 = Over/Under Limited YTD
1 = Over/Under Stub On Top
2 = Over/Under Stub On Bottom
3 = Side/Side No TA Balances
4 = Side/Side TA Balances
5 = Side/Side Heat Sealed
9 = Over/Under Mailer
BAC-PRENOTE-OPTION Alpha 1 HR00.1 HR01.1
Prenote Option Contains the value that indicates PBIP.1 PR01.1
whether or not to create prenotes. PR197
N = No
Y = Yes
BAC-COUNTRY-CODE Alpha 2 HR00.1 HR01.1
Country Code The country code. Required for VAT and PBIP.1 PR01.1
intrastat reporting. Must be defined in PR197
IN01.1 (Country Maintenance).
BAC-DEST-DATA-CTRE Numeric 5 HR00.1 HR01.1
Dest Data Ctre Contains the value that defines the data PBIP.1 PR01.1
centre bank and location. PR197
BAC-INST-ID-RET Numeric 9 HR00.1 HR01.1
Inst Id Ret Used to identify the institutional ID PBIP.1 PR01.1
for the account where returned items are PR197
directed.
Format is: abbbccccc
a = 0 constant zero
bbb = institution number
ccccc = branch transit number.
BAC-RET-ACCT-NBR Alpha 12 (Lower Case) HR00.1 HR01.1
Ret Acct Nbr Contains the account where returned PBIP.1 PR01.1
items are directed. PR197
BAC-CLIENT-NBR Alpha 10 (Lower Case) HR00.1 HR01.1
Client Nbr Identifying ID for the client. Assigned PBIP.1 PR01.1
by the bank or bank and client. PR197
BAC-FILE-CRT-NBR Numeric 4 PR160
File Crt Nbr Contains the value which identifies the
ACSS/Direct Deposit file as unique from
the last file created. Incremented by
one each time a file is created. When it
reaches 9999, it starts over at 0001.
BAC-DEST-DATA-NAME Alpha 30 (Lower Case) HR00.1 HR01.1
Dest Data Name Contains the name of the Destination PBIP.1 PR01.1
Data Centre. PR197
BAC-INST-RET-NAME Alpha 30 (Lower Case) HR00.1 HR01.1
Inst Ret Name Contains the name of the institution PBIP.1 PR01.1
for returns. PR197
BANKACCT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BACSET1 BNK-ACCT-NBR BN66.1 HBAC.1
HR00.1 HR01.1
HR200 HR201
PBIP.1 PR01.1
PR01.2 PR140
PR155 PR160
PR162 PR165
PR180 PR189
PR195 PR197
PR201 PR281
PR300 PR80.1
PR80.2 PR82.1
PR85.1 PR89.1
BACSET2 COUNTRY-CODE PR01.1 PR201
BNK-ACCT-NBR
BANKACCT FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Bankcode BANKFILE Delete Restricted
BAC-BNK-ACCT-NBR -> BFL-BNK-ACCT-NBR
BFL-COMPANY
BFL-BANK-CODE
Checks PRCHECK Delete Restricted
BAC-BNK-ACCT-NBR -> PCH-BNK-ACCT-NBR
PCH-PRINT-TYPE
PCH-CHECK-NBR
PCH-CHECK-ID
|
