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 BN340 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: Plan Type Contains the plan type.
BNA-PLAN-CODE Alpha 4 BN20.1
Element: Plan Code 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: Ded Code Contains the deduction code or pay code.
BNA-EXP-DIST-CO Numeric 4 BN20.1
Element: Company Identifies the AP company if the
resource type = V. Identifies the HR
company if the resource type = E. It is
blank for type A, P or Q resources.
BNA-EXP-ACCT-UNIT Alpha 15 BN20.1
Element: Acct Unit The accounting unit is a shorthand
notation representing the variable level
number. When used in the General Ledger
Account Master file, the accounting unit
must be defined in the General Ledger
Names file as a posting accounting unit.
BNA-EXP-ACCOUNT Numeric 6 BN20.1
Element: Account This field along with the accounting
unit and subaccount make up the location
(account) where amounts and other
account information is stored.
BNA-EXP-SUB-ACCT Numeric 4 BN20.1
Element: Sub Acct This field contains the subaccount from
your general ledger chart of accounts
that was charged with the amount carried
on this record.
BNA-ACR-DIST-CO Numeric 4 BN20.1
Element: Company Identifies the AP company if the
resource type = V. Identifies the HR
company if the resource type = E. It is
blank for type A, P or Q resources.
BNA-ACR-ACCT-UNIT Alpha 15 BN20.1
Element: Acct Unit Contains 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: Sub Acct 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
BN340 BN45.1
BN531 BN65.1
BN71.1 BN72.1
BS09.1 BS10.1
BS11.1 BS12.1
BS13.1 BS14.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
BN340 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
|