BNPAYMENT – Benefit Payment

System
Benefits (BN)
Prefix
BNP
Primary key
COMPANY, EMPLOYEE, PARTICIPNT, TYPE, CHECK-NBR
Fields
29
Updated by
4 programs
Referenced by
2 programs

BNPAYMENT is the Benefit Payment table in Lawson Benefits (prefix BNP). It is indexed by COMPANY, EMPLOYEE, PARTICIPNT, TYPE, CHECK-NBR (BNPSET1); alternate indexes: BNPSET2. It is related 1:1 to GLMASTER, BNCOMPANY, PRSYSTEM, CUCODES, EMPLOYEE, BNINVDETL, PLAN and PARTICIPNT and 1:M to BNPAYDETL. It is updated by BN190, BN480, BN81.1 and BN81.2 and referenced by BN281 and BN82.1. The table has 29 fields, 2 indexes and 11 documented relations.

About BNPAYMENT

The Benefit Payment file contains payment information for COBRA participant and retiree premiums. Each record is for one COBRA participant or retiree transaction. BN81.1 (Cash Entry) is the primary program that updates this file.

Fields (29)

Column = COBOL field name without the BNP- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
BNP-COMPANY PK
COMPANY		Numeric 4Contains the company number. The number correlates all information about the company.BN81.1
BNP-EMPLOYEE PK
EMPLOYEE		Numeric 9Contains the employee's number.BN81.1
BNP-PARTICIPNT PK
PARTICIPNT		Numeric 9Contains COBRA participant numbers. The number correlates all information about the COBRA participant.BN81.1
BNP-TYPE PK
TYPE		Alpha 2Indicates whether the transaction is a payment or a credit memo.
  • CK Payment
  • CM Credit Memo
BN81.1
BNP-CHECK-NBR PK
CHECK_NBR		Numeric 8Contains the number of the payment.BN81.1
BNP-PMT-AMT
PMT_AMT		Signed 11.2Contains the payment amount.BN81.1
BNP-APPLIED-AMT
APPLIED_AMT		Signed 15.2Contains the amount applied to the outstanding balance.BN81.1, BN81.2
BNP-DATE
DATE		Numeric 8 (yyyymmdd)Contains the transaction date.BN81.1
BNP-REFERENCE
REFERENCE		Alpha 10 (Lower Case)Contains a user-defined reference or comment.BN81.1
BNP-DIST-CO
DIST_CO		Numeric 4Identifies 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.BN81.1
BNP-ACCT-UNIT
ACCT_UNIT		Alpha 15Contains the accounting unit for the payment.BN81.1
BNP-ACCOUNT
ACCOUNT		Numeric 6Contains the account for the payment.BN81.1
BNP-SUB-ACCT
SUB_ACCT		Numeric 4Contains the subaccount for the payment.BN81.1
BNP-OS-INV-NUMBER
OS_INV_NUMBER		Numeric 3Contains the invoice number for the over or short amount of the payment.BN81.2
BNP-OS-PLAN-TYPE
OS_PLAN_TYPE		Alpha 2Contains the benefit type.
  • HL Health
  • DN Dental
  • EL Employee Life
  • DL Dependent Life
  • RS Spending Account
BN81.2
BNP-OS-PLAN-CODE
OS_PLAN_CODE		Alpha 4Contains the benefit plan's code.BN81.2
BNP-OS-START-DATE
OS_START_DATE		Numeric 8 (yyyymmdd)Contains the start date of the benefit plan.BN81.2
BNP-OS-AMOUNT
OS_AMOUNT		Signed 7.2Contains the over or short amount.BN81.2
BNP-OS-DIST-CO
OS_DIST_CO		Numeric 4Identifies 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.BN81.2
BNP-OS-ACCT-UNIT
OS_ACCT_UNIT		Alpha 15Contains the account used for posting the over or short amount.BN81.2
BNP-OS-ACCOUNT
OS_ACCOUNT		Numeric 6Contains the account for posting the over or short amount.BN81.2
BNP-OS-SUB-ACCT
OS_SUB_ACCT		Numeric 4Contains the subaccount for posting the over or short amount.BN81.2
BNP-AR-DIST-CO
AR_DIST_CO		Numeric 4Identifies 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.BN81.2
BNP-AR-ACCT-UNIT
AR_ACCT_UNIT		Alpha 15Contains the accounting unit for the over short account.BN81.2
BNP-AR-ACCOUNT
AR_ACCOUNT		Numeric 6Contains the account for the over short payment.BN81.2
BNP-AR-SUB-ACCT
AR_SUB_ACCT		Numeric 4Contains the subaccount for the over short account.BN81.2
BNP-STATUS
STATUS		Numeric 1Contains the status of a given transaction.
  • 1 Posted to G/L
  • 0 Not Posted to G/L
BN190, BN81.1, BN81.2
BNP-CURRENCY-CODE
CURRENCY_CODE		Alpha 5This field contains the company base currency code established in Company (GL10.1 ).BN81.1, BN81.2
BNP-CURR-ND
CURR_ND		Numeric 1The number of decimals assigned to a particular account as determined by the account currency.BN81.1, BN81.2

Indexes (2)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
BNPSET1COMPANY, EMPLOYEE, PARTICIPNT, TYPE, CHECK-NBRPrimaryBN480, BN82.1
BNPSET2COMPANY, EMPLOYEE, PARTICIPNT, TYPE, CHECK-NBRSubsetWhere STATUS != 9BN190, BN281, BN81.1, BN81.2

Relations

One to one (10) — lookups and parents

RelationTableRulesConditionField map
Ar AccountGLMASTERRequiredWhen BNP-AR-ACCT-UNIT != Spaces Or BNP-AR-ACCOUNT != ZeroesBNP-COMPANY → GLM-COMPANY, BNP-AR-ACCT-UNIT → GLM-ACCT-UNIT, BNP-AR-ACCOUNT → GLM-ACCOUNT, BNP-AR-SUB-ACCT → GLM-SUB-ACCOUNT
CompanyBNCOMPANYRequiredBNP-COMPANY → BNC-COMPANY
Company NamePRSYSTEMRequiredBNP-COMPANY → PRS-COMPANY, Spaces → PRS-PROCESS-LEVEL
CurrencyCUCODESRequiredBNP-CURRENCY-CODE → CUC-CURRENCY-CODE
EmployeeEMPLOYEERequiredWhen BNP-EMPLOYEE != ZeroesBNP-COMPANY → EMP-COMPANY, BNP-EMPLOYEE → EMP-EMPLOYEE
Gl AccountGLMASTERRequiredWhen BNP-ACCT-UNIT != Spaces And BNP-ACCOUNT != Zeroes And BNP-SUB-ACCT != ZeroesBNP-COMPANY → GLM-COMPANY, BNP-ACCT-UNIT → GLM-ACCT-UNIT, BNP-ACCOUNT → GLM-ACCOUNT, BNP-SUB-ACCT → GLM-SUB-ACCOUNT
Os AccountGLMASTERRequiredWhen BNP-OS-ACCT-UNIT != Spaces Or BNP-OS-ACCOUNT != ZeroesBNP-COMPANY → GLM-COMPANY, BNP-OS-ACCT-UNIT → GLM-ACCT-UNIT, BNP-OS-ACCOUNT → GLM-ACCOUNT, BNP-OS-SUB-ACCT → GLM-SUB-ACCOUNT
Os InvoiceBNINVDETLRequiredWhen BNP-OS-INV-NUMBER != ZeroesBNP-COMPANY → BID-COMPANY, BNP-OS-PLAN-TYPE → BID-PLAN-TYPE, BNP-OS-PLAN-CODE → BID-PLAN-CODE, BNP-OS-START-DATE → BID-START-DATE, BNP-EMPLOYEE → BID-EMPLOYEE, BNP-PARTICIPNT → BID-PARTICIPNT, BNP-OS-INV-NUMBER → BID-INV-NUMBER
Os PlanPLANRequiredWhen BNP-OS-PLAN-CODE != SpacesBNP-COMPANY → PLN-COMPANY, BNP-OS-PLAN-TYPE → PLN-PLAN-TYPE, BNP-OS-PLAN-CODE → PLN-PLAN-CODE
ParticipantPARTICIPNTRequiredWhen BNP-PARTICIPNT != ZeroesBNP-COMPANY → PAR-COMPANY, BNP-PARTICIPNT → PAR-PARTICIPNT

One to many (1) — child tables

RelationTableRulesConditionField map
Payment DetailBNPAYDETLDelete RestrictedBNP-COMPANY → BPD-COMPANY, BNP-EMPLOYEE → BPD-EMPLOYEE, BNP-PARTICIPNT → BPD-PARTICIPNT, BNP-TYPE → BPD-TYPE, BNP-CHECK-NBR → BPD-CHECK-NBR, → BPD-INV-NUMBER, → BPD-PLAN-TYPE, → BPD-PLAN-CODE, → BPD-START-DATE

Programs

Updated by (4)

Referenced by (2)