BANKFILE

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
BN66.1 HBNK.1 HR170 HR200 HR201 HR70.1
PR140 PR141 PR155 PR162 PR170 PR189
PR195 PR197 PR201 PR560 PR582 PR80.1
PR80.2 PR80.4 PR81.1 PR82.1 PR85.1 PR86.1
PR89.1 PRAT.1


UPDATED BY
HR00.1 HR01.1 PR01.2 PR160 PR180

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BFL-COMPANY
Element: Company Hr
Numeric 4
Contains the company number.
HR00.1 HR01.1
PR01.2
BFL-BANK-CODE
Element: Bank
Alpha 4
Contains the user-defined code that links a bank account number to a general ledger cash account for the payroll payments made by the company.
HR00.1 HR01.1
PR01.2
BFL-BNK-ACCT-NBR
Element: Account
Alpha 17
Contains the bank account number.
HR00.1 HR01.1
PR01.2
BFL-CSH-DIST-CO
Element: Company
Numeric 4
Contains the distribution company for the company's cash account.
HR00.1 HR01.1
PR01.2
BFL-CSH-ACCT-UNIT
Element: Cash Account
Alpha 15
Contains the accounting unit for the company's cash account.
HR00.1 HR01.1
PR01.2
BFL-CSH-ACCOUNT
Element: Account
Numeric 6
Contains the account number for the company's general ledger cash account.
HR00.1 HR01.1
PR01.2
BFL-CSH-SUB-ACCT
Element: Sub Acct
Numeric 4
Contains the subaccount number for the company's general ledger cash account.
HR00.1 HR01.1
PR01.2
BFL-USED-FLAG
Element: Used Flag
Alpha 1
Indicates if the record has been accessed by some source after creation.
Y = Used
HR00.1 HR01.1
PR01.2 PR160
PR180
BFL-BNK-ACCT-NBR2
Element: Bnk Acct Nbr2
Alpha 17
Contains the second bank account number.
HR00.1 HR01.1
PR01.2
BFL-CSH-DIST-CO2
Element: Company
Numeric 4
Contains the distribution company for the company's second cash account.
HR00.1 HR01.1
PR01.2
BFL-CSH-ACCT-UNIT2
Element: Acct Unit
Alpha 15
Contains the accounting unit for the company's second cash account.
HR00.1 HR01.1
PR01.2
BFL-CSH-ACCOUNT2
Element: Account
Numeric 6
Contains the account number for the company's second general ledger cash account.
HR00.1 HR01.1
PR01.2
BFL-CSH-SUB-ACCT2
Element: Sub Acct
Numeric 4
Contains the subaccount number for the company's second general ledger cash account.
HR00.1 HR01.1
PR01.2
BFL-USED-FLAG2
Element: Used Flag2
Alpha 1
Indicates if the record has been accessed by some source after creation.
Y = Used
HR00.1 HR01.1
PR01.2 PR160
PR180
BFL-BANK-MNEMONIC
Element: Bank Mnemonic
Alpha 10
HR00.1 HR01.1
PR01.2
BFL-PAY-MODE
Element: Pay Mode
Numeric 2

01 = ECS
02 = NEFT
03 = Bank Soft Copy
HR00.1 HR01.1
PR01.2


BANKFILE FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BFLSET1 COMPANY
BANK-CODE
...
BN66.1 HBNK.1
HR00.1 HR01.1
HR170 HR200
HR201 HR70.1
PR01.2 PR140
PR141 PR155
PR160 PR162
PR170 PR180
PR189 PR195
PR197 PR201
PR560 PR582
PR80.1 PR80.2
PR80.4 PR81.1
PR82.1 PR85.1
PR86.1 PR89.1
BFLSET3 BNK-ACCT-NBR
COMPANY
BANK-CODE
KeyChange
HR00.1 HR01.1
PR01.1 PR201
PR85.1
BFLSET4 BNK-ACCT-NBR2
COMPANY
BANK-CODE
KeyChange
HR00.1 HR01.1
PR01.1
BFLSET5 BANK-MNEMONIC
COMPANY
BANK-CODE
KeyChange


BANKFILE FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Bank Account BANKACCT Required
BFL-BNK-ACCT-NBR->BAC-BNK-ACCT-NBR (BACSET1)
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


File created: Thu Jun 09 02:30:18 2016

Home
Contact Us



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