BNPAYDETL – Benefit Payment Detail

System: Benefits (BN)
Prefix: BPD
Primary key: COMPANY, EMPLOYEE, PARTICIPNT, TYPE, CHECK-NBR, INV-NUMBER, PLAN-TYPE, PLAN-CODE, START-DATE
Fields: 14
Updated by: 3 programs
Referenced by: 3 programs

BNPAYDETL is the Benefit Payment Detail table in Lawson Benefits (prefix BPD). It is indexed by COMPANY, EMPLOYEE, PARTICIPNT, TYPE, CHECK-NBR, INV-NUMBER, PLAN-TYPE, PLAN-CODE, START-DATE (BPDSET1). It is related 1:1 to GLMASTER, PARTBEN, BNCOMPANY, PRSYSTEM, EMPLOYEE, BNINVDETL, PARTICIPNT, BNPAYMENT and 1 more. It is updated by BN480, BN81.1 and BN81.2 and referenced by BN190, BN281 and BN82.1. The table has 14 fields, 1 index and 9 documented relations.

About BNPAYDETL

The Benefit Payment Detail file contains payment information for COBRA participants and retirees. Each payment is stored by invoice number and general ledger posting account. BN81.1 (Cash Entry) is the primary program that loads this file.

Fields (14)

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

Field / column	Type	Description & values	Updated by
`BPD-COMPANY` PK COMPANY	Numeric 4	Contains the company number. The number correlates all information about the company.	BN81.1, BN81.2
`BPD-EMPLOYEE` PK EMPLOYEE	Numeric 9	Contains the employee's number. The number correlates all information about the employee.	BN81.1, BN81.2
`BPD-PARTICIPNT` PK PARTICIPNT	Numeric 9	Contains COBRA participant numbers. The number correlates all information about the COBRA participant.	BN81.1, BN81.2
`BPD-TYPE` PK TYPE	Alpha 2	Indicates whether the cash entry is for a payment or a credit memo. `CK` Payment `CM` Credit Memo	BN81.1, BN81.2
`BPD-CHECK-NBR` PK CHECK_NBR	Numeric 8	Contains the payment number.	BN81.1, BN81.2
`BPD-INV-NUMBER` PK INV_NUMBER	Numeric 3	Contains the invoice number associated with this payment.	BN81.1, BN81.2
`BPD-PLAN-TYPE` PK PLAN_TYPE	Alpha 2	Contains the benefit plan type used to identify the kind of plan associated with this payment. `DL` Dependent Life `DN` Dental `EL` Employee Life `HL` Health `RS` Spending Account	BN81.1, BN81.2
`BPD-PLAN-CODE` PK PLAN_CODE	Alpha 4	Contains the plan code.	BN81.1, BN81.2
`BPD-START-DATE` PK START_DATE	Numeric 8 (yyyymmdd)	Contains the start date of the benefit plan.	BN81.1, BN81.2
`BPD-AR-DIST-CO` AR_DIST_CO	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.	BN81.1, BN81.2
`BPD-AR-ACCT-UNIT` AR_ACCT_UNIT	Alpha 15	Contains the accounting unit used for posting the payment.	BN81.1, BN81.2
`BPD-AR-ACCOUNT` AR_ACCOUNT	Numeric 6	Contains the account used for posting the payment.	BN81.1, BN81.2
`BPD-AR-SUB-ACCT` AR_SUB_ACCT	Numeric 4	Contains the subaccount used for posting the payment.	BN81.1, BN81.2
`BPD-PMT-AMT` PMT_AMT	Signed 11.2	Contains the payment amount received.	BN81.1, BN81.2

Indexes (1)

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

Index	Keys	Flags	Condition	Used in
`BPDSET1`	`COMPANY`, `EMPLOYEE`, `PARTICIPNT`, `TYPE`, `CHECK-NBR`, `INV-NUMBER`, `PLAN-TYPE`, `PLAN-CODE`, `START-DATE`	Primary		BN190, BN281, BN480, BN81.1, BN81.2, BN82.1

Relations

One to one (9) — lookups and parents

Relation	Table	Rules	Condition	Field map
Ar Account	GLMASTER	Required	When BPD-AR-ACCT-UNIT != Spaces Or BPD-AR-ACCOUNT != Zeroes	`BPD-COMPANY` → `GLM-COMPANY`, `BPD-AR-ACCT-UNIT` → `GLM-ACCT-UNIT`, `BPD-AR-ACCOUNT` → `GLM-ACCOUNT`, `BPD-AR-SUB-ACCT` → `GLM-SUB-ACCOUNT`
Benefit	PARTBEN	Required		`BPD-COMPANY` → `PTB-COMPANY`, `BPD-PLAN-TYPE` → `PTB-PLAN-TYPE`, `BPD-PARTICIPNT` → `PTB-PARTICIPNT`, `BPD-EMPLOYEE` → `PTB-EMPLOYEE`, `BPD-START-DATE` → `PTB-START-DATE`, `BPD-PLAN-CODE` → `PTB-PLAN-CODE`
Company	BNCOMPANY	Required		`BPD-COMPANY` → `BNC-COMPANY`
Company Name	PRSYSTEM	Required		`BPD-COMPANY` → `PRS-COMPANY`, `Spaces` → `PRS-PROCESS-LEVEL`
Employee	EMPLOYEE	Required	When BPD-EMPLOYEE != Zeroes	`BPD-COMPANY` → `EMP-COMPANY`, `BPD-EMPLOYEE` → `EMP-EMPLOYEE`
Invoice Detail	BNINVDETL	Required		`BPD-COMPANY` → `BID-COMPANY`, `BPD-EMPLOYEE` → `BID-EMPLOYEE`, `BPD-PARTICIPNT` → `BID-PARTICIPNT`, `BPD-INV-NUMBER` → `BID-INV-NUMBER`, `BPD-PLAN-TYPE` → `BID-PLAN-TYPE`, `BPD-PLAN-CODE` → `BID-PLAN-CODE`, `BPD-START-DATE` → `BID-START-DATE`
Participant	PARTICIPNT	Required	When BPD-PARTICIPNT != Zeroes	`BPD-COMPANY` → `PAR-COMPANY`, `BPD-PARTICIPNT` → `PAR-PARTICIPNT`
Payment	BNPAYMENT	Required		`BPD-COMPANY` → `BNP-COMPANY`, `BPD-PARTICIPNT` → `BNP-EMPLOYEE`, `BPD-EMPLOYEE` → `BNP-PARTICIPNT`, `BPD-TYPE` → `BNP-TYPE`, `BPD-CHECK-NBR` → `BNP-CHECK-NBR`
Plan	PLAN	Required		`BPD-COMPANY` → `PLN-COMPANY`, `BPD-PLAN-TYPE` → `PLN-PLAN-TYPE`, `BPD-PLAN-CODE` → `PLN-PLAN-CODE`

BNPAYDETL – Benefit Payment Detail

About BNPAYDETL

Fields (14)

Indexes (1)

Relations

One to one (9) — lookups and parents

Programs

Updated by (3)

Referenced by (3)