Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


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

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