BANKACCT – Bank Account

System: Payroll (PR)
Prefix: BAC
Primary key: BNK-ACCT-NBR
Fields: 18
Updated by: 6 programs
Referenced by: 23 programs

BANKACCT is the Bank Account table in Lawson Payroll (prefix BAC). It is indexed by BNK-ACCT-NBR (BACSET1); alternate indexes: BACSET2 and BACSET3. It is related 1:M to BANKFILE and PRCHECK. It is updated by HR00.1, HR01.1, PR01.1, PR160, PR180 and PR712 and referenced by BN66.1, HBAC.1, HR200, HR201, PR140, PR155, PR162, PR165 and 15 more. The table has 18 fields, 3 indexes and 2 documented relations.

About BANKACCT

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.

Fields (18)

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

Field / column	Type	Description & values	Updated by
`BAC-BNK-ACCT-NBR` PK BNK_ACCT_NBR	Alpha 17	Contains the bank account from which payroll payments are drawn.	HR00.1, HR01.1, PR01.1
`BAC-BANK-ID` 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` BANK_NAME	Alpha 30 (Lower Case)	Contains the bank name.	HR00.1, HR01.1, PR01.1
`BAC-SEND-PT-ID` SEND_PT_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` SEND_PT_NAME	Alpha 30 (Lower Case)	Contains the name of the sending DFI bank.	HR00.1, HR01.1, PR01.1
`BAC-ACH-OPTION` 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` CHECK_OPTION	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` 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` 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` 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` 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` 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` RET_ACCT_NBR	Alpha 12 (Lower Case)	Contains the account where returned items are directed.	HR00.1, HR01.1, PR01.1
`BAC-CLIENT-NBR` 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` 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` 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` INST_RET_NAME	Alpha 30 (Lower Case)	Contains the name of the institution for returns.	HR00.1, HR01.1, PR01.1
`BAC-BANK-MNEMONIC` BANK_MNEMONIC	Alpha 10	—	HR00.1, HR01.1, PR01.1

Indexes (3)

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

Index	Keys	Flags	Used in
`BACSET1`	`BNK-ACCT-NBR`	Primary	BN66.1, HBAC.1, HR00.1, HR01.1, HR200, HR201, PR01.1, PR01.2 +22 more
`BACSET2`	`COUNTRY-CODE`, `BNK-ACCT-NBR`		PR01.1, PR201, PR712
`BACSET3`	`BANK-MNEMONIC`, `BNK-ACCT-NBR`		—

Relations

One to many (2) — child tables

Relation	Table	Rules	Condition	Field map
Bankcode	BANKFILE	Delete Restricted		`BAC-BNK-ACCT-NBR` → `BFL-BNK-ACCT-NBR (BFLSET3)`, → `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`

Programs

Updated by (6)

HR00.1 Company
HR01.1 Process Level
PR01.1 Bank Account
PR160 Payment Print
PR180 Manual Payment Print
PR712 Employee Bank and Bank Account Update

Referenced by (23)

BN66.1 Estimated Pay Calculation
HBAC.1 Bank Account Selection Invoke
HR200 Company Listing
HR201 Process Level Listing
PR140 Earnings and Deductions Calculation
PR155 Bank Reconciliation
PR162 Payment Register
PR165 Bank Reconciliation Tape Processing
PR170 Positive Pay File Creation
PR189 Gross Up Calculation
PR195 Accrual Program
PR201 Bank Listing
PR281 Manual Payment Audit Report
PR300 History Purge
PR582 Mass Adjustment Load
PR80.1 Manual Check
PR80.2 Manual Payment Print
PR80.4 Manual Payment
PR81.1 Manual Payment Reservation
PR82.1 Adjustment
PR85.1 Bank Account Reconciliation
PR89.1 Payment Modeling
PRAT.1 Alltax connection test