BNACCOUNTS

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
BN220 HR55.1 PRBN.1 BN215


UPDATED BY
BN105 BN15.1 BN20.1 BN100 BN101 BN102
BN103 BN145 BN232 BN245 BN260 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 ZB01.1 ZB10.1 ZB10.2 ZB31.1
ZB31.2 ZB32.1 ZB32.2 ZB32.3

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BNA-COMPANY
Element: Company Hr
Numeric 4
Contains the company number.
BN20.1
BNA-PLAN-TYPE
Element: Plan Type
Alpha 2
Contains the plan type.
BN20.1
BNA-PLAN-CODE
Element: Plan Code
Alpha 4
Contains the user-defined code that represents a benefit plan.
BN20.1
BNA-START-DATE
Element: Start Date
Numeric 8 (yyyymmdd)
Contains the date the general ledger overrides take effect.
BN20.1
BNA-GROUP-NAME
Element: Group Name
Alpha 10
Contains the employee group name.
BN20.1
BNA-DED-CODE
Element: Ded Code
Alpha 4
Contains the deduction code or pay code.
BN20.1
BNA-EXP-DIST-CO
Element: Company
Numeric 4
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.
BN20.1
BNA-EXP-ACCT-UNIT
Element: Acct Unit
Alpha 15
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.
BN20.1
BNA-EXP-ACCOUNT
Element: Account
Numeric 6
This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.
BN20.1
BNA-EXP-SUB-ACCT
Element: Sub Acct
Numeric 4
This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record.
BN20.1
BNA-ACR-DIST-CO
Element: Company
Numeric 4
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.
BN20.1
BNA-ACR-ACCT-UNIT
Element: Acct Unit
Alpha 15
Contains the accrual accounting unit for the deduction code or pay code.
BN20.1
BNA-ACR-ACCOUNT
Element: Account
Numeric 6
Contains the accrual account number for the deduction code or pay code.
BN20.1
BNA-ACR-SUB-ACCT
Element: Sub Acct
Numeric 4
Contains the accrual subaccount number for the deduction code or pay code.
BN20.1
BNA-STATUS
Element: Status
Numeric 1
Contains the account's status.
0 = New Group New Date
1 = Existing Group New Date
2 = Change Existing Record
3 = Updated
BN105 BN20.1
BNA-CREATE-DATE
Element: Date Stamp
Numeric 8 (yyyymmdd)
BN20.1
BNA-CREATE-TIME
Element: Time Stamp
Numeric 6 (hhmmss)
BN20.1
BNA-CREATE-USER-ID
Element: User Id
Alpha 10 (Lower Case)
BN20.1
BNA-DATE-STAMP
Element: Date Stamp
Numeric 8 (yyyymmdd)
BN20.1
BNA-TIME-STAMP
Element: Time Stamp
Numeric 6 (hhmmss)
BN20.1
BNA-USER-ID
Element: User Id
Alpha 10 (Lower Case)
BN20.1


BNACCOUNTS FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BNASET1 COMPANY
PLAN-TYPE
PLAN-CODE
START-DATE
GROUP-NAME
DED-CODE
...
BN100 BN101
BN102 BN103
BN105 BN145
BN15.1 BN20.1
BN220 BN232
BN245 BN260
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
BNASET2 COMPANY
PLAN-TYPE
PLAN-CODE
START-DATE*
GROUP-NAME
DED-CODE
...
BN100 BN101
BN102 BN103
BN105 BN145
BN215 BN232
BN245 BN260
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
BNASET3 COMPANY
PLAN-TYPE
PLAN-CODE
GROUP-NAME
START-DATE
DED-CODE
BN20.1


BNACCOUNTS FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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


File created: Thu Jun 09 02:09:53 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.