BANKACCT

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 HR200 HR201 PR140 PR155 PR165
PR189 PR195 PR281 PR300 PR582 PR80.1
PR80.2 PR80.4 PR81.1 PR82.1 PR85.1 PR89.1


UPDATED BY
HR00.1 HR01.1 PR01.1 PR160 PR180 PR712
HBAC.1 PR162 PR201

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BAC-BNK-ACCT-NBR
Element: Bnk Acct Nbr
Alpha 17
Contains the bank account from which payroll payments are drawn.
HR00.1 HR01.1
PR01.1
BAC-BANK-ID
Element: Bank Id
Numeric 9
Contains the ID number assigned to the bank by the Federal Reserve.
HR00.1 HR01.1
PR01.1
BAC-BANK-NAME
Element: Bnk Name
Alpha 30 (Lower Case)
Contains the bank name.
HR00.1 HR01.1
PR01.1
BAC-SEND-PT-ID
Element: Sending Bank ID
Numeric 10
Contains the ID assigned by the Federal Reserve to the bank that processes the ACH tape.
HR00.1 HR01.1
PR01.1
BAC-SEND-PT-NAME
Element: Sending Bank Name
Alpha 30 (Lower Case)
Contains the name of the sending DFI bank.
HR00.1 HR01.1
PR01.1
BAC-ACH-OPTION
Element: ACH Option
Alpha 1
Contains the value that indicates if the bank account allows ACH payments to be made.
N = No ACH allowed
Y = ACH allowed
B = Yes; System & Manual Payments
HR00.1 HR01.1
PR01.1
BAC-CHECK-OPTION
Element: Payment Format
Numeric 1
Contains the value that determines 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
HR00.1 HR01.1
PR01.1 PR712
BAC-RECEIPT-OPTION
Element: Receipt Option
Numeric 1
Contains the value that determines the 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
HR00.1 HR01.1
PR01.1 PR712
BAC-PRENOTE-OPTION
Element: Prenote Option
Alpha 1
Contains the value that indicates whether or not to create prenotes.
N = No
Y = Yes
HR00.1 HR01.1
PR01.1
BAC-COUNTRY-CODE
Element: Country Code
Alpha 2
The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance).
HR00.1 HR01.1
PR01.1
BAC-DEST-DATA-CTRE
Element: Dest Data Ctre
Numeric 5
Contains the value that defines the data centre bank and location.
HR00.1 HR01.1
PR01.1
BAC-INST-ID-RET
Element: Inst Id Ret
Numeric 9
Used to identify the institutional ID for the account where returned items are directed. Format is: abbbccccc a = 0 constant zero bbb = institution number ccccc = branch transit number.
HR00.1 HR01.1
PR01.1
BAC-RET-ACCT-NBR
Element: Ret Acct Nbr
Alpha 12 (Lower Case)
Contains the account where returned items are directed.
HR00.1 HR01.1
PR01.1
BAC-CLIENT-NBR
Element: Client Nbr
Alpha 10 (Lower Case)
Identifying ID for the client. Assigned by the bank or bank and client.
HR00.1 HR01.1
PR01.1
BAC-FILE-CRT-NBR
Element: File Crt Nbr
Numeric 4
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.
PR160 PR180
BAC-DEST-DATA-NAME
Element: Dest Data Name
Alpha 30 (Lower Case)
Contains the name of the Destination Data Centre.
HR00.1 HR01.1
PR01.1
BAC-INST-RET-NAME
Element: Inst Ret Name
Alpha 30 (Lower Case)
Contains the name of the institution for returns.
HR00.1 HR01.1
PR01.1


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 PR582
PR712 PR80.1
PR80.2 PR80.4
PR81.1 PR82.1
PR85.1 PR89.1
BACSET2 COUNTRY-CODE
BNK-ACCT-NBR
PR01.1 PR201
PR712


BANKACCT FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED 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


File created: Wed Jun 08 20:51:06 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.