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.
UPDATED BY

BN180	BN181	BN190	BN480	BN80.1	BN81.1
BN81.2	BN105	BN71.1	BN72.1	BN430	BN171
BN175	BN82.1

FIELD NAME	DESCRIPTION/VALID VALUES	UPDATED BY
BID-COMPANY Element: Company Hr	Numeric 4 Contains the company number.	BN180 BN80.1
BID-PLAN-TYPE Element: Plan Type	Alpha 2 Contains 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 Element: Plan Code	Alpha 4 Contains the plan code.	BN180 BN80.1
BID-START-DATE Element: Start Date	Numeric 8 (yyyymmdd) Contains the start date of the benefit.	BN180 BN80.1
BID-EMPLOYEE Element: Employee	Numeric 9 Contains the retiree's number.	BN180 BN80.1
BID-PARTICIPNT Element: Participnt	Numeric 9 Contains COBRA participant numbers.	BN180 BN80.1
BID-INV-NUMBER Element: Inv Number	Numeric 3 Contains the invoice number.	BN180 BN80.1
BID-INV-TYPE Element: Invoice Type	Alpha 1 Contains the invoice as a manual invoice or a system created invoice.	BN180 BN80.1
BID-INV-DATE Element: Inv Date	Numeric 8 (yyyymmdd) Contains the invoice date.	BN180 BN80.1
BID-DUE-DATE Element: Due Date	Numeric 8 (yyyymmdd) Contains the invoice due date.	BN180 BN80.1
BID-INV-AMOUNT Element: Inv Amount	Signed 11.2 Contains 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 Element: Premium Amt	Signed 7.2 Contains the premium amount.	BN180 BN80.1
BID-DESC Element: Description	Alpha 30 (Lower Case) Contains a description of the invoice.	BN80.1
BID-GL-AMOUNT Element: Gl Amount	Signed 7.2 Occurs 3 Times Contains the amount to be posted to the general ledger.	BN180 BN80.1
BID-GL-ACCT-UNIT Element: Acct Unit	Alpha 15 Occurs 3 Times Contains the accounting unit for posting invoice amounts.	BN180 BN80.1
BID-GL-ACCOUNT Element: Account	Numeric 6 Occurs 3 Times Contains the account for posting invoice amounts.	BN180 BN80.1
BID-GL-SUB-ACCT Element: Sub Acct	Numeric 4 Occurs 3 Times Contains the subaccount for posting invoice amounts.	BN180 BN80.1
BID-UNPAID-AMT Element: Unpaid Amt	Signed 7.2 Contains any unpaid invoice amounts.	BN180 BN80.1 BN81.1 BN81.2
BID-GL-DIST-CO Element: Company	Numeric 4 Occurs 3 Times 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.	BN180 BN80.1
BID-STATUS Element: Status	Numeric 1 This field displays the status of the transaction.	BN180 BN181 BN190
BID-CURRENCY-CODE Element: Currency Code	Alpha 5 This field contains the company base currency code established in Company (GL10.1 ).	BN180 BN80.1
BID-CURR-ND Element: Acct Nd	Numeric 1 The number of decimals assigned to a particular account as determined by the account currency.	BN180 BN80.1

BNINVDETL FILE INDEX

BNINVDETL FILE RELATIONS

ONE TO ONE RELATIONS

BNINVDETL FILE RELATIONS

ONE TO MANY RELATIONS

All trademarks and registered trademarks are the property of their respective owners.