BANKFILE – Bank Code

System
Payroll (PR)
Prefix
BFL
Primary key
COMPANY, BANK-CODE
Fields
16
Updated by
5 programs
Referenced by
26 programs

BANKFILE is the Bank Code table in Lawson Payroll (prefix BFL). It is indexed by COMPANY, BANK-CODE (BFLSET1); alternate indexes: BFLSET3, BFLSET4 and BFLSET5. It is related 1:1 to BANKACCT, GLMASTER and PRSYSTEM. It is updated by HR00.1, HR01.1, PR01.2, PR160 and PR180 and referenced by BN66.1, HBNK.1, HR170, HR200, HR201, HR70.1, PR140, PR141 and 18 more. The table has 16 fields, 4 indexes and 4 documented relations.

About BANKFILE

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).

Fields (16)

Column = COBOL field name without the BFL- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
BFL-COMPANY PK
COMPANY		Numeric 4Contains the company number.HR00.1, HR01.1, PR01.2
BFL-BANK-CODE PK
BANK_CODE		Alpha 4Contains 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
BNK_ACCT_NBR		Alpha 17Contains the bank account number.HR00.1, HR01.1, PR01.2
BFL-CSH-DIST-CO
CSH_DIST_CO		Numeric 4Contains the distribution company for the company's cash account.HR00.1, HR01.1, PR01.2
BFL-CSH-ACCT-UNIT
CSH_ACCT_UNIT		Alpha 15Contains the accounting unit for the company's cash account.HR00.1, HR01.1, PR01.2
BFL-CSH-ACCOUNT
CSH_ACCOUNT		Numeric 6Contains the account number for the company's general ledger cash account.HR00.1, HR01.1, PR01.2
BFL-CSH-SUB-ACCT
CSH_SUB_ACCT		Numeric 4Contains the subaccount number for the company's general ledger cash account.HR00.1, HR01.1, PR01.2
BFL-USED-FLAG
USED_FLAG		Alpha 1Indicates 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
BNK_ACCT_NBR2		Alpha 17Contains the second bank account number.HR00.1, HR01.1, PR01.2
BFL-CSH-DIST-CO2
CSH_DIST_CO2		Numeric 4Contains the distribution company for the company's second cash account.HR00.1, HR01.1, PR01.2
BFL-CSH-ACCT-UNIT2
CSH_ACCT_UNIT2		Alpha 15Contains the accounting unit for the company's second cash account.HR00.1, HR01.1, PR01.2
BFL-CSH-ACCOUNT2
CSH_ACCOUNT2		Numeric 6Contains the account number for the company's second general ledger cash account.HR00.1, HR01.1, PR01.2
BFL-CSH-SUB-ACCT2
CSH_SUB_ACCT2		Numeric 4Contains the subaccount number for the company's second general ledger cash account.HR00.1, HR01.1, PR01.2
BFL-USED-FLAG2
USED_FLAG2		Alpha 1Indicates if the record has been accessed by some source after creation.
  • Y Used
HR00.1, HR01.1, PR01.2, PR160, PR180
BFL-BANK-MNEMONIC
BANK_MNEMONIC		Alpha 10—HR00.1, HR01.1, PR01.2
BFL-PAY-MODE
PAY_MODE		Numeric 2—
  • 01 ECS
  • 02 NEFT
  • 03 Bank Soft Copy
HR00.1, HR01.1, PR01.2

Indexes (4)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
BFLSET1COMPANY, BANK-CODEPrimaryBN66.1, HBNK.1, HR00.1, HR01.1, HR170, HR200, HR201, HR70.1 +22 more (list truncated in source)
BFLSET3BNK-ACCT-NBR, COMPANY, BANK-CODEKeyChangeHR00.1, HR01.1, PR01.1, PR201, PR85.1
BFLSET4BNK-ACCT-NBR2, COMPANY, BANK-CODEKeyChangeHR00.1, HR01.1, PR01.1
BFLSET5BANK-MNEMONIC, COMPANY, BANK-CODEKeyChange—

Relations

One to one (4) — lookups and parents

RelationTableRulesConditionField map
Bank AccountBANKACCTRequiredBFL-BNK-ACCT-NBR → BAC-BNK-ACCT-NBR (BACSET1)
Bank Account2BANKACCTRequiredWhen BFL-BNK-ACCT-NBR2 != SpacesBFL-BNK-ACCT-NBR2 → BAC-BNK-ACCT-NBR
Cash AccountGLMASTERRequiredBFL-CSH-DIST-CO → GLM-COMPANY, BFL-CSH-ACCT-UNIT → GLM-ACCT-UNIT, BFL-CSH-ACCOUNT → GLM-ACCOUNT, BFL-CSH-SUB-ACCT → GLM-SUB-ACCOUNT
CompanyPRSYSTEMRequiredBFL-COMPANY → PRS-COMPANY, Spaces → PRS-PROCESS-LEVEL

Programs

Updated by (5)

Referenced by (26)