|
|
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 PR01.1 PR160 PR712
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BAC-BNK-ACCT-NBR Alpha 17 HR00.1 HR01.1
Element: Bnk Acct Nbr Contains the bank account from which PR01.1
payroll payments are drawn.
BAC-BANK-ID Numeric 9 HR00.1 HR01.1
Element: Bank Id Contains the ID number assigned to the PR01.1
bank by the
Federal Reserve.
BAC-BANK-NAME Alpha 30 (Lower Case) HR00.1 HR01.1
Element: Bnk Name Contains the bank name. PR01.1
BAC-SEND-PT-ID Numeric 9 HR00.1 HR01.1
Element: Sending Bank IContains the ID assigned by the Federal PR01.1
Reserve to the bank that processes the
ACH tape.
BAC-SEND-PT-NAME Alpha 30 (Lower Case) HR00.1 HR01.1
Element: Sending Bank NContains the name of the sending DFI PR01.1
bank.
BAC-ACH-OPTION Alpha 1 HR00.1 HR01.1
Element: ACH Option Contains the value that indicates if 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
Element: Payment FormatContains the value that determines PR01.1 PR712
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
8 = Laser Print File
9 = Over/Under Mailer
BAC-RECEIPT-OPTION Numeric 1 HR00.1 HR01.1
Element: Receipt OptionContains the value that determines the PR01.1 PR712
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
8 = Laser Print File
9 = Over/Under Mailer
BAC-PRENOTE-OPTION Alpha 1 HR00.1 HR01.1
Element: Prenote OptionContains the value that indicates PR01.1
whether or not to create prenotes.
N = No
Y = Yes
BAC-COUNTRY-CODE Alpha 2 HR00.1 HR01.1
Element: Country Code The country code. Required for VAT and PR01.1
intrastat reporting. Must be defined in
IN01.1 (Country Maintenance).
BAC-DEST-DATA-CTRE Numeric 5 HR00.1 HR01.1
Element: Dest Data CtreContains the value that defines the data PR01.1
centre bank and location.
BAC-INST-ID-RET Numeric 9 HR00.1 HR01.1
Element: Inst Id Ret Used to identify the institutional ID PR01.1
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
Element: Ret Acct Nbr Contains the account where returned PR01.1
items are directed.
BAC-CLIENT-NBR Alpha 10 (Lower Case) HR00.1 HR01.1
Element: Client Nbr Identifying ID for the client. Assigned PR01.1
by the bank or bank and client.
BAC-FILE-CRT-NBR Numeric 4 PR160
Element: 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
Element: Dest Data NameContains the name of the Destination PR01.1
Data Centre.
BAC-INST-RET-NAME Alpha 30 (Lower Case) HR00.1 HR01.1
Element: Inst Ret Name Contains the name of the institution PR01.1
for returns.
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
PR01.1 PR01.2
PR140 PR155
PR160 PR162
PR165 PR180
PR189 PR195
PR201 PR281
PR300 PR712
PR80.1 PR80.2
PR82.1 PR85.1
PR89.1
BACSET2 COUNTRY-CODE PR01.1 PR201
BNK-ACCT-NBR PR712
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
|
