|
|
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 PR140 PR155 PR160
PR162 PR165 PR180 PR201 PR281 PR300
PR80.1 PR80.2 PR85.1
UPDATED BY
HR00.1 HR01.1 PBIP.1 PR01.1
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.
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
Federal Reserve.
BAC-BANK-NAME Alpha 30 (Lower Case) HR00.1 HR01.1
Bank Name Contains the bank name. PBIP.1 PR01.1
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
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.
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
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
(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.
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.
N = No
Y = Yes
BANKACCT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BACSET1 BNK-ACCT-NBR HBAC.1 HR00.1
HR00.2 HR01.1
HR01.2 HR200
HR201 PBIP.1
PR01.1 PR01.2
PR01.3 PR140
PR155 PR160
PR162 PR165
PR180 PR201
PR281 PR300
PR80.1 PR80.2
PR85.1
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
|