BNINVDETL – Benefit Invoice Detail

System
Benefits (BN)
Prefix
BID
Primary key
COMPANY, PLAN-TYPE, PLAN-CODE, START-DATE, EMPLOYEE, PARTICIPNT, INV-NUMBER
Fields
22
Updated by
7 programs
Referenced by
7 programs

BNINVDETL is the Benefit Invoice Detail table in Lawson Benefits (prefix BID). It is indexed by COMPANY, PLAN-TYPE, PLAN-CODE, START-DATE, EMPLOYEE, PARTICIPNT, INV-NUMBER (BIDSET1); alternate indexes: BIDSET2, BIDSET3 and BIDSET4. It is related 1:1 to GLMASTER, BNCOMPANY, PRSYSTEM, CUCODES, EMPLOYEE, PARTICIPNT and PLAN and 1:M to BNPAYDETL and BNPAYMENT. It is updated by BN180, BN181, BN190, BN480, BN80.1, BN81.1 and BN81.2 and referenced by BN105, BN171, BN175, BN430, BN71.1, BN72.1 and BN82.1. The table has 22 fields, 4 indexes and 9 documented relations.

About BNINVDETL

The Benefit Invoice Detail file contains the invoice detail for retiree and participant billing. Each record contains one invoice for a retiree or COBRA participant. If the invoice is for a retiree, the retiree number displays in the BID-EMPLOYEE field. If the invoice is for a COBRA participant, the participant number displays.

Fields (22)

Column = COBOL field name without the BID- 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
#BID-COMPANY PK
COMPANY		Numeric 4Contains the company number.BN180, BN80.1
#BID-PLAN-TYPE PK
PLAN_TYPE		Alpha 2Contains the plan type of the invoice.
  • DL Dependent Life
  • DN Dental
  • EL Employee Life
  • HL Health
  • RS Spending Account
BN180, BN80.1
#BID-PLAN-CODE PK
PLAN_CODE		Alpha 4Contains the plan code.BN180, BN80.1
#BID-START-DATE PK
START_DATE		Numeric 8 (yyyymmdd)Contains the start date of the benefit.BN180, BN80.1
#BID-EMPLOYEE PK
EMPLOYEE		Numeric 9Contains the retiree's number.BN180, BN80.1
#BID-PARTICIPNT PK
PARTICIPNT		Numeric 9Contains COBRA participant numbers.BN180, BN80.1
#BID-INV-NUMBER PK
INV_NUMBER		Numeric 3Contains the invoice number.BN180, BN80.1
#BID-INV-TYPE SET2
INV_TYPE		Alpha 1Contains the invoice as a manual invoice or a system created invoice.BN180, BN80.1
#BID-INV-DATE SET3
INV_DATE		Numeric 8 (yyyymmdd)Contains the invoice date.BN180, BN80.1
#BID-DUE-DATE
DUE_DATE		Numeric 8 (yyyymmdd)Contains the invoice due date.BN180, BN80.1
#BID-INV-AMOUNT
INV_AMOUNT		Signed 11.2Contains the amount of the invoice. For retiree invoices, the invoice amount is less than or equal to the premium amount. The difference is the company expense. For COBRA invoices, the invoice amount is greater than or equal to the premium amount. The difference is the excess premium amount.BN180, BN80.1
#BID-PREMIUM-AMT
PREMIUM_AMT		Signed 7.2Contains the premium amount.BN180, BN80.1
#BID-DESC
DESC		Alpha 30 (Lower Case)Contains a description of the invoice.BN80.1
#BID-GL-AMOUNT
GL_AMOUNT		Signed 7.2 Occurs 3 Times ×3Contains the amount to be posted to the general ledger.BN180, BN80.1
#BID-GL-ACCT-UNIT
GL_ACCT_UNIT		Alpha 15 Occurs 3 Times ×3Contains the accounting unit for posting invoice amounts.BN180, BN80.1
#BID-GL-ACCOUNT
GL_ACCOUNT		Numeric 6 Occurs 3 Times ×3Contains the account for posting invoice amounts.BN180, BN80.1
#BID-GL-SUB-ACCT
GL_SUB_ACCT		Numeric 4 Occurs 3 Times ×3Contains the subaccount for posting invoice amounts.BN180, BN80.1
#BID-UNPAID-AMT
UNPAID_AMT		Signed 7.2Contains any unpaid invoice amounts.BN180, BN80.1, BN81.1, BN81.2
#BID-GL-DIST-CO
GL_DIST_CO		Numeric 4 Occurs 3 Times ×3Identifies 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.BN180, BN80.1
#BID-STATUS
STATUS		Numeric 1This field displays the status of the transaction.BN180, BN181, BN190
#BID-CURRENCY-CODE
CURRENCY_CODE		Alpha 5This field contains the company base currency code established in Company (GL10.1 ).BN180, BN80.1
#BID-CURR-ND
CURR_ND		Numeric 1The number of decimals assigned to a particular account as determined by the account currency.BN180, BN80.1

Indexes (4)

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
BIDSET1
  1. COMPANY
  2. PLAN-TYPE
  3. PLAN-CODE
  4. START-DATE
  5. EMPLOYEE
  6. PARTICIPNT
  7. INV-NUMBER
PrimaryBN105, BN190, BN480, BN71.1, BN72.1, BN81.1, BN81.2
BIDSET2
  1. COMPANY
  2. INV-TYPE
  3. EMPLOYEE
  4. PARTICIPNT
  5. INV-NUMBER
  6. PLAN-TYPE
  7. PLAN-CODE
  8. START-DATE
SubsetWhere STATUS = ZeroesBN180, BN430, BN80.1
BIDSET3
  1. COMPANY
  2. EMPLOYEE
  3. PARTICIPNT
  4. INV-DATE
  5. INV-NUMBER
  6. PLAN-TYPE
  7. PLAN-CODE
  8. START-DATE
KeyChangeBN171, BN175, BN81.1, BN81.2, BN82.1
BIDSET4
  1. COMPANY
  2. EMPLOYEE
  3. PARTICIPNT
  4. INV-NUMBER
  5. PLAN-TYPE
  6. PLAN-CODE
  7. START-DATE
BN181

Relations

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

One to one (7) — lookups and parents

RelationTableRulesConditionField map
AccountGLMASTERRequiredWhen BID-GL-ACCOUNT != Zeroes Or BID-GL-ACCT-UNIT != Spaces
BID-COMPANY→GLM-COMPANY
BID-GL-ACCT-UNIT→GLM-ACCT-UNIT
BID-GL-ACCOUNT→GLM-ACCOUNT
BID-GL-SUB-ACCT→GLM-SUB-ACCOUNT
CompanyBNCOMPANYRequired
BID-COMPANY→BNC-COMPANY
Company NamePRSYSTEMRequired
BID-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL
CurrencyCUCODESRequired
BID-CURRENCY-CODE→CUC-CURRENCY-CODE
EmployeeEMPLOYEERequiredWhen BID-EMPLOYEE != Zeroes
BID-COMPANY→EMP-COMPANY
BID-EMPLOYEE→EMP-EMPLOYEE
ParticipantPARTICIPNTRequiredWhen BID-PARTICIPNT != Zeroes
BID-COMPANY→PAR-COMPANY
BID-PARTICIPNT→PAR-PARTICIPNT
PlanPLANRequiredWhen BID-PLAN-CODE != Spaces
BID-COMPANY→PLN-COMPANY
BID-PLAN-TYPE→PLN-PLAN-TYPE
BID-PLAN-CODE→PLN-PLAN-CODE

One to many (2) — child tables

RelationTableRulesConditionField map
Payment DetailBNPAYDETLDelete Restricted
BID-COMPANY→BPD-COMPANY
BID-EMPLOYEE→BPD-EMPLOYEE
BID-PARTICIPNT→BPD-PARTICIPNT
—→BPD-TYPE
—→BPD-CHECK-NBR
—→BPD-INV-NUMBER
—→BPD-PLAN-TYPE
—→BPD-PLAN-CODE
—→BPD-START-DATE
PaymentsBNPAYMENTDelete Restricted
BID-COMPANY→BNP-COMPANY
BID-EMPLOYEE→BNP-EMPLOYEE
BID-PARTICIPNT→BNP-PARTICIPNT
—→BNP-TYPE
—→BNP-CHECK-NBR

Programs

Updated by (7)

Referenced by (7)