Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

BNINVDETL


                             BNINVDETL FILE

                         Benefit Invoice Detail

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.

REFERENCED BY

BN105     BN71.1    BN72.1    BN430     BN171     BN175
BN82.1

UPDATED BY

BN180     BN181     BN190     BN480     BN700     BN80.1
BN81.1    BN81.2

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

BID-COMPANY            Numeric 4                                 BN180   BN80.1
Element: Company       Contains the company number.

BID-PLAN-TYPE          Alpha 2                                   BN180   BN80.1
Element: Type          Contains the plan type of the invoice.
                       DL = Dependent Life
                       DN = Dental
                       EL = Employee Life
                       HL = Health
                       RS = Spending Account

BID-PLAN-CODE          Alpha 4                                   BN180   BN80.1
Element: Plan          Contains the plan code.

BID-START-DATE         Numeric 8  (yyyymmdd)                     BN180   BN80.1
Element: Date          Contains the start date of the benefit.

BID-EMPLOYEE           Numeric 9                                 BN180   BN80.1
Element: Employee      Contains the retiree's number.

BID-PARTICIPNT         Numeric 9                                 BN180   BN80.1
Element: Participant NuContains COBRA participant numbers.

BID-INV-NUMBER         Numeric 3                                 BN180   BN80.1
Element: Invoice NumberContains the invoice number.

BID-INV-TYPE           Alpha 1                                   BN180   BN80.1
Element: Invoice Type  Contains the invoice as a manual
                       invoice or a system created invoice.

BID-INV-DATE           Numeric 8  (yyyymmdd)                     BN180   BN80.1
Element: Invoice Date  Contains the invoice date.

BID-DUE-DATE           Numeric 8  (yyyymmdd)                     BN180   BN80.1
Element: Date          Contains the invoice due date.

BID-INV-AMOUNT         Signed 11.2                               BN180   BN80.1
Element: Invoice AmountContains 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.

BID-PREMIUM-AMT        Signed 7.2                                BN180   BN80.1
Element: Premium AmountContains the premium amount.

BID-DESC               Alpha 30  (Lower Case)                    BN80.1
Element: Description   Contains a description of the invoice.

BID-GL-AMOUNT          Signed 7.2 Occurs 3 Times                 BN180   BN80.1
General Ledger         Contains the amount to be posted to the
Amount                 general ledger.

BID-GL-ACCT-UNIT       Alpha 15 Occurs 3 Times                   BN180   BN80.1
General Ledger         Contains the accounting unit for
Accounting Unit        posting invoice amounts.

BID-GL-ACCOUNT         Numeric 6 Occurs 3 Times                  BN180   BN80.1
General Ledger         Contains the account for posting
Account                invoice amounts.

BID-GL-SUB-ACCT        Numeric 4 Occurs 3 Times                  BN180   BN80.1
General Ledger         Contains the subaccount for posting
Subaccount             invoice amounts.

BID-UNPAID-AMT         Signed 7.2                                BN180   BN80.1
Invoice Unpaid         Contains any unpaid invoice amounts.      BN81.1  BN81.2
Amount

BID-GL-DIST-CO         Numeric 4 Occurs 3 Times                  BN180   BN80.1
Element: Gl Dist Co

BID-STATUS             Numeric 1                                 BN180   BN181
Element: Status        This field displays the status of the     BN190
                       transaction.

BID-CURRENCY-CODE      Alpha 5                                   BN180   BN700
Element: Currency Code This field contains the company base      BN80.1
                       currency code established in Company
                       (GL10.1 ).

BID-CURR-ND            Numeric 1                                 BN180   BN700
Account Currency                                                 BN80.1
Code

                         BNINVDETL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

BIDSET1   COMPANY                                                BN105   BN190
          PLAN-TYPE                                              BN480   BN700
          PLAN-CODE                                              BN71.1  BN72.1
          START-DATE                                             BN81.1  BN81.2
          EMPLOYEE
          PARTICIPNT
          INV-NUMBER

BIDSET2   COMPANY       Subset                                   BN180   BN430
          INV-TYPE      Where STATUS = Zeroes                    BN80.1
          EMPLOYEE
          PARTICIPNT
          INV-NUMBER
          PLAN-TYPE
          PLAN-CODE
          START-DATE

BIDSET3   COMPANY       KeyChange                                BN171   BN175
          EMPLOYEE                                               BN81.1  BN81.2
          PARTICIPNT                                             BN82.1
          INV-DATE
          INV-NUMBER
          PLAN-TYPE
          PLAN-CODE
          START-DATE

BIDSET4   COMPANY                                                BN181
          EMPLOYEE
          PARTICIPNT
          INV-NUMBER
          PLAN-TYPE
          PLAN-CODE
          START-DATE

                         BNINVDETL FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Account        GLMASTER     Required
                            When 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

Company        BNCOMPANY    Required

                            BID-COMPANY          -> BNC-COMPANY

Company Name   PRSYSTEM     Required

                            BID-COMPANY          -> PRS-COMPANY
                            Spaces               -> PRS-PROCESS-LEVEL

Currency       CUCODES      Required

                            BID-CURRENCY-CODE    -> CUC-CURRENCY-CODE

Employee       EMPLOYEE     Required
                            When BID-EMPLOYEE != Zeroes

                            BID-COMPANY          -> EMP-COMPANY
                            BID-EMPLOYEE         -> EMP-EMPLOYEE

Participant    PARTICIPNT   Required
                            When BID-PARTICIPNT != Zeroes

                            BID-COMPANY          -> PAR-COMPANY
                            BID-PARTICIPNT       -> PAR-PARTICIPNT

Plan           PLAN         Required
                            When BID-PLAN-CODE != Spaces

                            BID-COMPANY          -> PLN-COMPANY
                            BID-PLAN-TYPE        -> PLN-PLAN-TYPE
                            BID-PLAN-CODE        -> PLN-PLAN-CODE

                         BNINVDETL FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Payment Detail BNPAYDETL    Delete 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

Payments       BNPAYMENT    Delete Restricted

                            BID-COMPANY          -> BNP-COMPANY
                            BID-EMPLOYEE         -> BNP-EMPLOYEE
                            BID-PARTICIPNT       -> BNP-PARTICIPNT
                                                    BNP-TYPE
                                                    BNP-CHECK-NBR