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 |
BN180 | BN181 | BN190 | BN480 | BN80.1 | BN81.1 |
BN81.2 |
FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||||
---|---|---|---|---|---|---|
BID-COMPANY Element: Company Hr | Numeric 4 Contains the company number. |
|
||||
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 |
|
||||
BID-PLAN-CODE Element: Plan Code | Alpha 4 Contains the plan code. |
|
||||
BID-START-DATE Element: Start Date | Numeric 8 (yyyymmdd) Contains the start date of the benefit. |
|
||||
BID-EMPLOYEE Element: Employee | Numeric 9 Contains the retiree's number. |
|
||||
BID-PARTICIPNT Element: Participnt | Numeric 9 Contains COBRA participant numbers. |
|
||||
BID-INV-NUMBER Element: Inv Number | Numeric 3 Contains the invoice number. |
|
||||
BID-INV-TYPE Element: Invoice Type | Alpha 1 Contains the invoice as a manual invoice or a system created invoice. |
|
||||
BID-INV-DATE Element: Inv Date | Numeric 8 (yyyymmdd) Contains the invoice date. |
|
||||
BID-DUE-DATE Element: Due Date | Numeric 8 (yyyymmdd) Contains the invoice due date. |
|
||||
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. |
|
||||
BID-PREMIUM-AMT Element: Premium Amt | Signed 7.2 Contains the premium amount. |
|
||||
BID-DESC Element: Description | Alpha 30 (Lower Case) Contains a description of the invoice. |
|
||||
BID-GL-AMOUNT Element: Gl Amount | Signed 7.2 Occurs 3 Times Contains the amount to be posted to the general ledger. |
|
||||
BID-GL-ACCT-UNIT Element: Acct Unit | Alpha 15 Occurs 3 Times Contains the accounting unit for posting invoice amounts. |
|
||||
BID-GL-ACCOUNT Element: Account | Numeric 6 Occurs 3 Times Contains the account for posting invoice amounts. |
|
||||
BID-GL-SUB-ACCT Element: Sub Acct | Numeric 4 Occurs 3 Times Contains the subaccount for posting invoice amounts. |
|
||||
BID-UNPAID-AMT Element: Unpaid Amt | Signed 7.2 Contains any unpaid invoice amounts. |
|
||||
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. |
|
||||
BID-STATUS Element: Status | Numeric 1 This field displays the status of the transaction. |
|
||||
BID-CURRENCY-CODE Element: Currency Code | Alpha 5 This field contains the company base currency code established in Company (GL10.1 ). |
|
||||
BID-CURR-ND Element: Acct Nd | Numeric 1 The number of decimals assigned to a particular account as determined by the account currency. |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
BIDSET1 |
COMPANY PLAN-TYPE PLAN-CODE START-DATE EMPLOYEE PARTICIPNT INV-NUMBER |
|
| ||||||||||||||||
BIDSET2 |
COMPANY INV-TYPE EMPLOYEE PARTICIPNT INV-NUMBER PLAN-TYPE PLAN-CODE START-DATE |
|
| ||||||||||||||||
BIDSET3 |
COMPANY EMPLOYEE PARTICIPNT INV-DATE INV-NUMBER PLAN-TYPE PLAN-CODE START-DATE |
|
| ||||||||||||||||
BIDSET4 |
COMPANY EMPLOYEE PARTICIPNT INV-NUMBER PLAN-TYPE PLAN-CODE START-DATE |
|
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Account | GLMASTER |
Required
| ||||||||||||||||||||||||
Company | BNCOMPANY |
Required
| ||||||||||||||||||||||||
Company Name | PRSYSTEM |
Required
| ||||||||||||||||||||||||
Currency | CUCODES |
Required
| ||||||||||||||||||||||||
Employee | EMPLOYEE |
Required
| ||||||||||||||||||||||||
Participant | PARTICIPNT |
Required
| ||||||||||||||||||||||||
Plan | PLAN |
Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Payment Detail | BNPAYDETL |
Delete Restricted
| |||||||||||||||||||||||||||
Payments | BNPAYMENT |
Delete Restricted
|
All trademarks and registered trademarks are the property of their
respective owners.