 |
Lawson Insight Technical Documentation |
|
BNACCOUNTS FILE
Benefit Accounts
Contains general ledger accounts to be used on employee deduction master
override of accounts for a deduction code or a pay code.
REFERENCED BY
BN100 BN101 BN102 BN103 BN145 BN220
BN245 BN31.1 BN31.2 BN32.1 BN32.2 BN32.3
BN320 BN331 BN45.1 BN531 BN65.1 BN71.1
BN72.1 BS09.1 BS10.1 BS11.1 BS12.1 BS13.1
BS14.1 BS15.1 BS32.1 HR55.1 PRBN.1 BN215
UPDATED BY
BN105 BN15.1 BN20.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BNA-COMPANY Numeric 4 BN20.1
Company Contains the company number.
BNA-PLAN-TYPE Alpha 2 BN20.1
Type Contains the plan type.
BNA-PLAN-CODE Alpha 4 BN20.1
Plan Contains the user-defined code that
represents a benefit plan.
BNA-START-DATE Numeric 8 (yyyymmdd) BN20.1
Start Date Contains the date the general ledger
overrides take effect.
BNA-GROUP-NAME Alpha 10 BN20.1
Group Name Contains the employee group name.
BNA-DED-CODE Alpha 4 BN20.1
Deduction Code Contains the deduction code or pay code.
BNA-EXP-DIST-CO Numeric 4 BN20.1
Exp Dist Co
BNA-EXP-ACCT-UNIT Alpha 15 BN20.1
Expense Accounting The general ledger distribution
Unit accounting unit.
BNA-EXP-ACCOUNT Numeric 6 BN20.1
Expense Account The general ledger distribution account
number.
BNA-EXP-SUB-ACCT Numeric 4 BN20.1
Depr Expense The general ledger distribution
Subaccount subaccount number.
BNA-ACR-DIST-CO Numeric 4 BN20.1
Acr Dist Co
BNA-ACR-ACCT-UNIT Alpha 15 BN20.1
Accrual Accounting Contains the accrual accounting unit
Unit for the deduction code or pay code.
BNA-ACR-ACCOUNT Numeric 6 BN20.1
Accrual Account Contains the accrual account number for
Number the deduction code or pay code.
BNA-ACR-SUB-ACCT Numeric 4 BN20.1
Accrual Subaccount Contains the accrual subaccount number
Number for the deduction code or pay code.
BNA-STATUS Numeric 1 BN105 BN20.1
Status Contains the account's status.
0 = New Group New Date
1 = Existing Group New Date
2 = Change Existing Record
3 = Updated
BNACCOUNTS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BNASET1 COMPANY BN100 BN101
PLAN-TYPE BN102 BN103
PLAN-CODE BN105 BN145
START-DATE BN15.1 BN20.1
GROUP-NAME BN220 BN245
DED-CODE BN31.1 BN31.2
BN32.1 BN32.2
BN32.3 BN320
BN331 BN45.1
BN531 BN65.1
BN71.1 BN72.1
BS09.1 BS10.1
BS11.1 BS12.1
BS13.1 BS14.1
BS15.1 BS32.1
...
BNASET2 COMPANY BN100 BN101
PLAN-TYPE BN102 BN103
PLAN-CODE BN105 BN145
START-DATE* BN215 BN245
GROUP-NAME BN31.1 BN31.2
DED-CODE BN32.1 BN32.2
BN32.3 BN320
BN331 BN45.1
BN531 BN65.1
BN71.1 BN72.1
BS09.1 BS10.1
BS11.1 BS12.1
BS13.1 BS14.1
BS15.1 BS32.1
BNASET3 COMPANY BN20.1
PLAN-TYPE
PLAN-CODE
GROUP-NAME
START-DATE
DED-CODE
BNACCOUNTS FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acr Acct Desc GLMASTER Not Required
BNA-COMPANY -> GLM-COMPANY
BNA-ACR-ACCT-UNIT -> GLM-ACCT-UNIT
BNA-ACR-ACCOUNT -> GLM-ACCOUNT
BNA-ACR-SUB-ACCT -> GLM-SUB-ACCOUNT
Company PRSYSTEM Required
BNA-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Exp Acct Desc GLMASTER Not Required
BNA-COMPANY -> GLM-COMPANY
BNA-EXP-ACCT-UNIT -> GLM-ACCT-UNIT
BNA-EXP-ACCOUNT -> GLM-ACCOUNT
BNA-EXP-SUB-ACCT -> GLM-SUB-ACCOUNT
Plan PLAN Not Required
BNA-COMPANY -> PLN-COMPANY
BNA-PLAN-TYPE -> PLN-PLAN-TYPE
BNA-PLAN-CODE -> PLN-PLAN-CODE
|