|
|
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 BN80.1 BN81.1
BN81.2
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BID-COMPANY Numeric 4 BN180 BN80.1
Element: Company Hr Contains the company number.
BID-PLAN-TYPE Alpha 2 BN180 BN80.1
Element: Plan 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 Code Contains the plan code.
BID-START-DATE Numeric 8 (yyyymmdd) BN180 BN80.1
Element: Start 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: Participnt Contains COBRA participant numbers.
BID-INV-NUMBER Numeric 3 BN180 BN80.1
Element: Inv Number Contains 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: Inv Date Contains the invoice date.
BID-DUE-DATE Numeric 8 (yyyymmdd) BN180 BN80.1
Element: Due Date Contains the invoice due date.
BID-INV-AMOUNT Signed 11.2 BN180 BN80.1
Element: Inv Amount 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 Signed 7.2 BN180 BN80.1
Element: Premium Amt Contains 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
Element: Gl Amount Contains the amount to be posted to the
general ledger.
BID-GL-ACCT-UNIT Alpha 15 Occurs 3 Times BN180 BN80.1
Element: Acct Unit Contains the accounting unit for
posting invoice amounts.
BID-GL-ACCOUNT Numeric 6 Occurs 3 Times BN180 BN80.1
Element: Account Contains the account for posting
invoice amounts.
BID-GL-SUB-ACCT Numeric 4 Occurs 3 Times BN180 BN80.1
Element: Sub Acct Contains the subaccount for posting
invoice amounts.
BID-UNPAID-AMT Signed 7.2 BN180 BN80.1
Element: Unpaid Amt Contains any unpaid invoice amounts. BN81.1 BN81.2
BID-GL-DIST-CO Numeric 4 Occurs 3 Times BN180 BN80.1
Element: Company 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 Numeric 1 BN180 BN181
Element: Status This field displays the status of the BN190
transaction.
BID-CURRENCY-CODE Alpha 5 BN180 BN80.1
Element: Currency Code This field contains the company base
currency code established in Company
(GL10.1 ).
BID-CURR-ND Numeric 1 BN180 BN80.1
Element: Acct Nd The number of decimals assigned to a
particular account as determined by the
account currency.
BNINVDETL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BIDSET1 COMPANY BN105 BN190
PLAN-TYPE BN480 BN71.1
PLAN-CODE BN72.1 BN81.1
START-DATE 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
|
