Billing and Accounting Tables

BI_HDR (BUSINESS_UNIT, INVOICE)

Parent table that contains one record for each bill header.

BI_HDR_CC (BUSINESS_UNIT, INVOICE, SEQ_NUM): Child table that contains one record for each courtesy copy address for a bill header.

BI_HDR_CRCARD (BUSINESS_UNIT, INVOICE, SEQ_NUM): Child table that may contain one record per invoice that contains credit card payment information.

BI_HDR_VAT (BUSINESS_UNIT, INVOICE): Child table that contains header VAT information for the bill.

BI_LINE (BUSINESS_UNIT, INVOICE, LINE_SEQ_NUM)

Parent table that contains one record for each bill line for a bill header.

BI_LINE_NOTE (BUSINESS_UNIT, INVOICE, LINE_SEQ_NUM, NOTES_SEQ_NUM): Child table that contains one record for each note or comment for a bill line.

BI_LINE_DST (BUSINESS_UNIT, INVOICE, LINE_SEQ_NUM, LINE_DST_SEQ_NUM): Child table that contains one record for each distribution or accounting entry for a bill line.

BI_HDR_AR

May contain one record for each bill that contains receivables accounting information

BI_LINE_TAX

May contain one record for each line that contains sales and use tax.

BI_LINE_TAX_DTL

May contain one record for each sales and use tax authority for a bill line.

BI_LINE_DS_LVL

May contain one record for each discount or surcharge for a bill line.

BI_LINE_DS_DTL

May contain one record for each calculation of a discount or surcharge.

BI_LINE_EXS_DTL

May contain one record for each India excise tax, sales tax, and VAT calculation for a bill line.

BI_LINE_DST_AR (BUSINESS_UNIT, INVOICE, LINE_SEQ_NUM, LINE_DST_SEQ_NUM)

Contains one record for each line that contains receivables accounting information.

BI_LINE_DST_ (BUSINESS_UNIT, INVOICE, LINE_SEQ_NUM, LINE_DST_SEQ_NUM)

Contains one record for each line that contains unbilled-receivables accounting information.

BI_LINE_DST_DFR (BUSINESS_UNIT, INVOICE, LINE_SEQ_NUM, LINE_DST_SEQ_NUM)

Contains one record for each deferred distribution or accounting entry for the line that contains receivables accounting information.

BI_LINE_DST_STA (BUSINESS_UNIT, INVOICE, LINE_SEQ_NUM, LINE_DST_SEQ_NUM)

Contains one record for each bill line statistical accounting distribution that is used to create the accounting entry for the line.

BI_LINE_IU_EXP (BUSINESS_UNIT, INVOICE, LINE_SEQ_NUM, LINE_DST_SEQ_NUM)

Contains one record for each bill line InterUnit expense distribution that is used to create the accounting entry for the line. This is only for InterUnit bills. However, InterUnit bill lines that take default accounting distribution information from the InterUnit Control Definitions table do not have this distribution line.

BI_LINE_IU_PAY (BUSINESS_UNIT, INVOICE, LINE_SEQ_NUM, LINE_DST_SEQ_NUM)

Contains one record for each bill line InterUnit payables distribution that is used to create the accounting entry for the line. This is only for InterUnit bills. However, InterUnit bill lines that take default accounting distribution information from the InterUnit Control table do not have this distribution line. Also, InterUnit bills that have PeopleSoft Payables generate vouchers have accounting entries generated from PeopleSoft Payables; therefore, these bills do not have an InterUnit payables distribution line.

BI_LINE_DS_LVL (BUSINESS_UNIT, INVOICE, LINE_SEQ_NUM, DISC_SUR_LVL)

Parent table that contains one record for each discount or surcharge level for a bill line.

BI_LINE_DS_DTL (BUSINESS_UNIT, INVOICE, LINE_SEQ_NUM, DISC_SUR_LVL, DISC_SUR_ID): Child table that contains one record for each discount or surcharge for a discount or surcharge level.

BI_LINE_ADJ_AUX (BUSINESS_UNIT, INVOICE, ADJ_AUX_LINE_SEQ)

Parent table that contains one record for every bill line adjustment that does not have a reference pointer to an original bill line.

BI_LINE_TAX (BUSINESS_UNIT, INVOICE, LINE_SEQ_NUM): Child table that contains one record for each bill line that has AVP or VERTEX tax fields.

BI_LINE_TAX_DTL (BUSINESS_UNIT, INVOICE, LINE_SEQ_NUM, TAX_AUTHORITY_CD): Child table that contains one record for each tax authority for a bill line.

BI_HDR_NOTE (BUSINESS_UNIT, INVOICE, NOTES_SEQ_NUM)

Contains one record for each note or comment for a bill header.

BI_BILL_CPY_HDR (BILL_CPY_GRP_ID)

Parent table that contains one record for each bill copy group.

BI_BILL_CPY_GRP (BILL_CPY_GRP_ID, SEQ_NUM): Child table that contains one record for each invoice copy template in a bill copy group.

BI_ACCUM_KEY (BAL_ACCUM_ID, BI_CURRENCY_CD, BASE_CURRENCY, ACCUM_KEY1_VAL, ACCUM_KEY2_VAL, ACUM_KEY3_VAL, ACCUM_KEY4_VAL, ACUM_KEY5_VAL, CURRENCY_CD_XEU)

Contains one record for each key value of each balance accumulation ID, bill currency, and base currency (for example, when accumulating by contract, one record for each contract value).

BI_ACCUM_TYPE (BAL_ACCUM_ID, BALANCE_TYPE, BI_CURRENCY_CD, BASE_CURRENCY, CURRENCY_CD_XEU, ACCUM_KEY1_VAL, ACCUM_KEY2_VAL ACUM_KEY3_VAL, ACCUM_KEY4_VAL, ACUM_KEY5_VAL)

Contains from one to five records for each combination of accumulation key, accumulation ID, and currency combination. The five possible types include beginning, ceiling, invoiced, uninvoiced, and total.

BI_ACCUM_BAL (BAL_ACCUM_ID, BALANCE_TYPE, EFFDT, BI_CURRENCY_CD, BASE_CURRENCY, CURRENCY_CD_XEU, ACCUM_KEY1_VAL, ACCUM_KEY2_VAL, ACUM_KEY3_VAL, ACCUM_KEY4_VAL, ACUM_KEY5_VAL)

Contains one record for each accumulation type of each accumulation key and currency combination.

BI_HDR_EC (ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE)

Contains one record for each bill that has been invoiced with electronic data interchange.

BI_SCHEDULE (BUSINESS_UNIT, INVOICE, EVENT_OCCURENCE)

Contains one record for each scheduled event of a recurring invoice template.

BI_INSTALL_SCHE (BUSINESS_UNIT, INVOICE, EVENT_OCCURENCE)

Contains one record for each scheduled event of an installment invoice template.

BI_INSTALL_TRMS (BUSINESS_UNIT, INVOICE)

Contains one record for each installment bill plan and a schedule for an installment invoice template.

BI_HDR_ATTACH (BUSINESS_UNIT, INVOICE, SCM_ATTACH_ID)

May contain one or more records for linking supporting documentation to invoice headers.

BI_LINE_ATTACH (BUSINESS_UNIT, INVOICE, LINE_SEQ_NUM, SCM_ATTACH_ID)

May contain one or more records for linking supporting documentation to invoice lines.