BNINVDETL

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

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BIDSET1 COMPANY
PLAN-TYPE
PLAN-CODE
START-DATE
EMPLOYEE
PARTICIPNT
INV-NUMBER
BN105 BN190
BN480 BN71.1
BN72.1 BN81.1
BN81.2
BIDSET2 COMPANY
INV-TYPE
EMPLOYEE
PARTICIPNT
INV-NUMBER
PLAN-TYPE
PLAN-CODE
START-DATE
Subset
WhereSTATUS =Zeroes
BN180 BN430
BN80.1
BIDSET3 COMPANY
EMPLOYEE
PARTICIPNT
INV-DATE
INV-NUMBER
PLAN-TYPE
PLAN-CODE
START-DATE
KeyChange
BN171 BN175
BN81.1 BN81.2
BN82.1
BIDSET4 COMPANY
EMPLOYEE
PARTICIPNT
INV-NUMBER
PLAN-TYPE
PLAN-CODE
START-DATE
BN181


BNINVDETL FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Account GLMASTER Required
When BID-GL-ACCOUNT !=Zeroes
OrBID-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
NAME
RELATED 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


File created: Wed Jun 08 20:48:06 2016

Home
Contact Us



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