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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#BPD-COMPANY PK
COMPANY		Numeric 4Contains the company number. The number correlates all information about the company.BN81.1, BN81.2
#BPD-EMPLOYEE PK
EMPLOYEE		Numeric 9Contains the employee's number. The number correlates all information about the employee.BN81.1, BN81.2
#BPD-PARTICIPNT PK
PARTICIPNT		Numeric 9Contains COBRA participant numbers. The number correlates all information about the COBRA participant.BN81.1, BN81.2
#BPD-TYPE PK
TYPE		Alpha 2Indicates 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 8Contains the payment number.BN81.1, BN81.2
#BPD-INV-NUMBER PK
INV_NUMBER		Numeric 3Contains the invoice number associated with this payment.BN81.1, BN81.2
#BPD-PLAN-TYPE PK
PLAN_TYPE		Alpha 2Contains 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 4Contains 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 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, BN81.2
#BPD-AR-ACCT-UNIT
AR_ACCT_UNIT		Alpha 15Contains the accounting unit used for posting the payment.BN81.1, BN81.2
#BPD-AR-ACCOUNT
AR_ACCOUNT		Numeric 6Contains the account used for posting the payment.BN81.1, BN81.2
#BPD-AR-SUB-ACCT
AR_SUB_ACCT		Numeric 4Contains the subaccount used for posting the payment.BN81.1, BN81.2
#BPD-PMT-AMT
PMT_AMT		Signed 11.2Contains the payment amount received.BN81.1, BN81.2

Indexes (1)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
BPDSET1
  1. COMPANY
  2. EMPLOYEE
  3. PARTICIPNT
  4. TYPE
  5. CHECK-NBR
  6. INV-NUMBER
  7. PLAN-TYPE
  8. PLAN-CODE
  9. START-DATE
PrimaryBN190, BN281, BN480, BN81.1, BN81.2, BN82.1

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
GLMASTERPARTBENBNCOMPANYPRSYSTEMEMPLOYEEBNINVDETLPARTICIPNTBNPAYMENTPLANBNPAYDETL

One to one (9) — lookups and parents

RelationTableRulesConditionField map
Ar AccountGLMASTERRequiredWhen 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
BenefitPARTBENRequired
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
CompanyBNCOMPANYRequired
BPD-COMPANY→BNC-COMPANY
Company NamePRSYSTEMRequired
BPD-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL
EmployeeEMPLOYEERequiredWhen BPD-EMPLOYEE != Zeroes
BPD-COMPANY→EMP-COMPANY
BPD-EMPLOYEE→EMP-EMPLOYEE
Invoice DetailBNINVDETLRequired
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
ParticipantPARTICIPNTRequiredWhen BPD-PARTICIPNT != Zeroes
BPD-COMPANY→PAR-COMPANY
BPD-PARTICIPNT→PAR-PARTICIPNT
PaymentBNPAYMENTRequired
BPD-COMPANY→BNP-COMPANY
BPD-PARTICIPNT→BNP-EMPLOYEE
BPD-EMPLOYEE→BNP-PARTICIPNT
BPD-TYPE→BNP-TYPE
BPD-CHECK-NBR→BNP-CHECK-NBR
PlanPLANRequired
BPD-COMPANY→PLN-COMPANY
BPD-PLAN-TYPE→PLN-PLAN-TYPE
BPD-PLAN-CODE→PLN-PLAN-CODE

Programs

Updated by (3)

Referenced by (3)