Lawson Insight Technical Documentation |
|
BNACCOUNTS
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
BN232 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
Element: Company Hr Contains the company number.
BNA-PLAN-TYPE Alpha 2 BN20.1
Element: Type Contains the plan type.
BNA-PLAN-CODE Alpha 4 BN20.1
Element: Plan Contains the user-defined code that
represents a benefit plan.
BNA-START-DATE Numeric 8 (yyyymmdd) BN20.1
Element: Start Date Contains the date the general ledger
overrides take effect.
BNA-GROUP-NAME Alpha 10 BN20.1
Element: Group Name Contains the employee group name.
BNA-DED-CODE Alpha 4 BN20.1
Element: Deduction CodeContains the deduction code or pay code.
BNA-EXP-DIST-CO Numeric 4 BN20.1
Element: Company
BNA-EXP-ACCT-UNIT Alpha 15 BN20.1
Element: Accounting UniThe general ledger distribution
accounting unit.
BNA-EXP-ACCOUNT Numeric 6 BN20.1
Element: Account The general ledger distribution account
number.
BNA-EXP-SUB-ACCT Numeric 4 BN20.1
Element: Subaccount The general ledger distribution
subaccount number.
BNA-ACR-DIST-CO Numeric 4 BN20.1
Element: Company
BNA-ACR-ACCT-UNIT Alpha 15 BN20.1
Element: Accounting UniContains the accrual accounting unit
for the deduction code or pay code.
BNA-ACR-ACCOUNT Numeric 6 BN20.1
Element: Account Contains the accrual account number for
the deduction code or pay code.
BNA-ACR-SUB-ACCT Numeric 4 BN20.1
Element: Subaccount Contains the accrual subaccount number
for the deduction code or pay code.
BNA-STATUS Numeric 1 BN105 BN20.1
Element: 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 BN232
DED-CODE 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
...
BNASET2 COMPANY BN100 BN101
PLAN-TYPE BN102 BN103
PLAN-CODE BN105 BN145
START-DATE* BN215 BN232
GROUP-NAME BN245 BN31.1
DED-CODE 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
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
|