|
|
BANKFILE FILE
Bank Code
The purpose of this file is to create bank codes. The system uses bank codes
to link companies and general ledger cash account information to bank
accounts. When you define a payroll company, the system creates a bank code
and bank account on the Bank form tab on HR00.1 (Company). You can create
additional bank codes in PR01.1 (Bank Account).
REFERENCED BY
AC542 BN500 BN66.1 HBFL.1 HR170 HR200
HR201 HR70.1 PR140 PR141 PR155 PR162
PR180 PR189 PR195 PR201 PR560 PR80.1
PR80.2 PR81.1 PR82.1 PR85.1 PR86.1 PR89.1
UK141 UK560
UPDATED BY
HR00.1 HR01.1 PBIP.1 PR01.2 PR160 PR197
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BFL-COMPANY Numeric 4 HR00.1 HR01.1
Element: Company Contains the company number. PBIP.1 PR01.2
PR197
BFL-BANK-CODE Alpha 4 HR00.1 HR01.1
Element: Bank Contains the user-defined code that PBIP.1 PR01.2
links a bank account number to a general PR197
ledger cash account for the payroll
payments made by the company.
BFL-BNK-ACCT-NBR Alpha 17 HR00.1 HR01.1
Element: Account Contains the bank account number. PBIP.1 PR01.2
PR197
BFL-CSH-DIST-CO Numeric 4 HR00.1 HR01.1
Element: Csh Dist Co Contains the distribution company for PBIP.1 PR01.2
the company's cash account. PR197
BFL-CSH-ACCT-UNIT Alpha 15 HR00.1 HR01.1
Element: Cash Account Contains the accounting unit for the PBIP.1 PR01.2
company's cash account. PR197
BFL-CSH-ACCOUNT Numeric 6 HR00.1 HR01.1
Element: Account Contains the account number for the PBIP.1 PR01.2
company's general ledger cash account. PR197
BFL-CSH-SUB-ACCT Numeric 4 HR00.1 HR01.1
Element: Subaccount Contains the subaccount number for the PBIP.1 PR01.2
company's general ledger cash account. PR197
BFL-USED-FLAG Alpha 1 HR00.1 HR01.1
Element: Used Indicates if the record has been PBIP.1 PR01.2
accessed by some source after creation. PR160 PR197
Y = Used
BFL-BNK-ACCT-NBR2 Alpha 17 HR00.1 HR01.1
Element: Bnk Acct Nbr2 Contains the second bank account number. PBIP.1 PR01.2
PR197
BFL-CSH-DIST-CO2 Numeric 4 HR00.1 HR01.1
Element: Csh Dist Co2 Contains the distribution company for PBIP.1 PR01.2
the company's second cash account. PR197
BFL-CSH-ACCT-UNIT2 Alpha 15 HR00.1 HR01.1
Element: Csh Acct Unit2Contains the accounting unit for the PBIP.1 PR01.2
company's second cash account. PR197
BFL-CSH-ACCOUNT2 Numeric 6 HR00.1 HR01.1
Element: Csh Account2 Contains the account number for the PBIP.1 PR01.2
company's second general ledger cash PR197
account.
BFL-CSH-SUB-ACCT2 Numeric 4 HR00.1 HR01.1
Element: Csh Sub Acct2 Contains the subaccount number for the PBIP.1 PR01.2
company's second general ledger cash PR197
account.
BFL-USED-FLAG2 Alpha 1 HR00.1 HR01.1
Element: Used Flag2 Indicates if the record has been PBIP.1 PR01.2
accessed by some source after creation. PR160 PR197
Y = Used
BANKFILE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BFLSET1 COMPANY AC542 BN500
BANK-CODE BN66.1 HBFL.1
HR00.1 HR01.1
HR170 HR200
HR201 HR70.1
PBIP.1 PR01.2
PR140 PR141
PR155 PR160
PR162 PR180
PR189 PR195
PR197 PR201
PR560 PR80.1
PR80.2 PR81.1
PR82.1 PR85.1
PR86.1 PR89.1
...
BFLSET3 BNK-ACCT-NBR KeyChange HR00.1 HR01.1
COMPANY PBIP.1 PR01.1
BANK-CODE PR197 PR201
PR85.1
BFLSET4 BNK-ACCT-NBR2 KeyChange HR00.1 HR01.1
COMPANY PBIP.1 PR01.1
BANK-CODE PR197
BANKFILE FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Bank Account BANKACCT Required
BFL-BNK-ACCT-NBR -> BAC-BNK-ACCT-NBR
Bank Account2 BANKACCT Required
When BFL-BNK-ACCT-NBR2 != Spaces
BFL-BNK-ACCT-NBR2 -> BAC-BNK-ACCT-NBR
Cash Account GLMASTER Required
BFL-CSH-DIST-CO -> GLM-COMPANY
BFL-CSH-ACCT-UNIT -> GLM-ACCT-UNIT
BFL-CSH-ACCOUNT -> GLM-ACCOUNT
BFL-CSH-SUB-ACCT -> GLM-SUB-ACCOUNT
Company PRSYSTEM Required
BFL-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
|
