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
HBAC.1 HR200 HR201 PR155 PR162 PR165
PR201 PR281 PR300 PR85.1
UPDATED BY
HR00.1 HR01.1 PR01.1 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 PR01.1 PR197
payroll payments are drawn.
BAC-BANK-ID Numeric 9 HR00.1 HR01.1
Bank Identification Contains the ID number assigned to the PR01.1 PR197
Number bank by the
Federal Reserve.
BAC-BANK-NAME Alpha 30 (Lower Case) HR00.1 HR01.1
Bank Name Contains the bank name. PR01.1 PR197
BAC-SEND-PT-ID Numeric 9 HR00.1 HR01.1
Sending Bank ID Contains the ID assigned by the Federal PR01.1 PR197
Reserve to the bank that processes the
ACH tape.
BAC-SEND-PT-NAME Alpha 30 (Lower Case) HR00.1 HR01.1
Sending Bank Name Contains the name of the sending DFI PR01.1 PR197
bank.
BAC-ACH-OPTION Alpha 1 HR00.1 HR01.1
ACH Option Contains the value that indicates if PR01.1 PR197
the bank account allows ACH payments to
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 PR01.1 PR197
which payment format is printed by PR160
(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 PR01.1 PR197
format for the ACH receipt.
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 PR01.1 PR197
whether or not to create prenotes.
N = No
Y = Yes
BAC-COUNTRY-CODE Alpha 2 HR00.1 HR01.1
Country Code The country code. Required for VAT and PR01.1 PR197
intrastat reporting. Must be defined in
IN01.1 (Country Maintenance).
BAC-DEST-DATA-CTRE Numeric 5 HR00.1 HR01.1
Dest Data Ctre Contains the value that defines the data PR01.1 PR197
centre bank and location.
BAC-INST-ID-RET Numeric 9 HR00.1 HR01.1
Inst Id Ret Used to identify the institutional ID PR01.1 PR197
for the account where returned items are
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 PR01.1 PR197
items are directed.
BAC-CLIENT-NBR Alpha 10 (Lower Case) HR00.1 HR01.1
Client Nbr Identifying ID for the client. Assigned PR01.1 PR197
by the bank or bank and client.
BAC-FILE-CRT-NBR Numeric 4
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 PR01.1 PR197
Data Centre.
BAC-INST-RET-NAME Alpha 30 (Lower Case) HR00.1 HR01.1
Inst Ret Name Contains the name of the institution PR01.1 PR197
for returns.
BANKACCT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BACSET1 BNK-ACCT-NBR HBAC.1 HR00.1
HR01.1 HR200
HR201 PR01.1
PR01.2 PR155
PR162 PR165
PR197 PR201
PR281 PR300
PR85.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
|
