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.

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
INV_TYPE		Alpha 1Contains the invoice as a manual invoice or a system created invoice.BN180, BN80.1
BID-INV-DATE
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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
BIDSET1COMPANY, PLAN-TYPE, PLAN-CODE, START-DATE, EMPLOYEE, PARTICIPNT, INV-NUMBERPrimaryBN105, BN190, BN480, BN71.1, BN72.1, BN81.1, BN81.2
BIDSET2COMPANY, INV-TYPE, EMPLOYEE, PARTICIPNT, INV-NUMBER, PLAN-TYPE, PLAN-CODE, START-DATESubsetWhere STATUS = ZeroesBN180, BN430, BN80.1
BIDSET3COMPANY, EMPLOYEE, PARTICIPNT, INV-DATE, INV-NUMBER, PLAN-TYPE, PLAN-CODE, START-DATEKeyChangeBN171, BN175, BN81.1, BN81.2, BN82.1
BIDSET4COMPANY, EMPLOYEE, PARTICIPNT, INV-NUMBER, PLAN-TYPE, PLAN-CODE, START-DATEBN181

Relations

One to one (7) — lookups and parents

RelationTableRulesConditionField map
AccountGLMASTERRequiredWhen BID-GL-ACCOUNT != Zeroes Or BID-GL-ACCT-UNIT != SpacesBID-COMPANY → GLM-COMPANY, BID-GL-ACCT-UNIT → GLM-ACCT-UNIT, BID-GL-ACCOUNT → GLM-ACCOUNT, BID-GL-SUB-ACCT → GLM-SUB-ACCOUNT
CompanyBNCOMPANYRequiredBID-COMPANY → BNC-COMPANY
Company NamePRSYSTEMRequiredBID-COMPANY → PRS-COMPANY, Spaces → PRS-PROCESS-LEVEL
CurrencyCUCODESRequiredBID-CURRENCY-CODE → CUC-CURRENCY-CODE
EmployeeEMPLOYEERequiredWhen BID-EMPLOYEE != ZeroesBID-COMPANY → EMP-COMPANY, BID-EMPLOYEE → EMP-EMPLOYEE
ParticipantPARTICIPNTRequiredWhen BID-PARTICIPNT != ZeroesBID-COMPANY → PAR-COMPANY, BID-PARTICIPNT → PAR-PARTICIPNT
PlanPLANRequiredWhen BID-PLAN-CODE != SpacesBID-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 RestrictedBID-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 RestrictedBID-COMPANY → BNP-COMPANY, BID-EMPLOYEE → BNP-EMPLOYEE, BID-PARTICIPNT → BNP-PARTICIPNT, → BNP-TYPE, → BNP-CHECK-NBR

Programs

Updated by (7)

Referenced by (7)