Understanding the Billing Interface Temporary Tables

The Billing Interface process is an Application Engine process that takes advantage of features, including parallel processing and set processing, that use temporary tables to reduce risk of data contention and deadlocks. To use Billing interface temporary tables, you must understand how Application Engine employs temporary tables for parallel processing.

See PeopleTools: PeopleSoft Application Engine, "Using Temporary Tables"

The Billing Interface process uses the following temporary tables. nn represents the temporary table instance number between 1 and 99.

Term	Definition
INTFC_BI_TAO nn	Temporary table for INTFC_BI.
INTFC_BIE_TAO nn	Temporary table for INTFC_BI_EXSD.
INTFC_BIA_TAO nn	Temporary table for INTFC_BI_AEDS.
INTFC_BI2_TAO nn	Temporary table for INTFC_BI2.
INTFC_BIN_TAO nn	Temporary table for INTFC_BI_NOTE.
INTFC_BIH_TAO nn	Temporary table for INTFC_BI_HDR.
INTFC_BIT_TAO nn	Temporary table for INTFC_BI_TAX.
INTFC_BI_ETMP nn	Error Processing temporary table. The interface process performs multiple data integrity edit checks. The system inserts temporary data into the INTFC_BI_ETMP table to assist with error checking.
INTFC_BI_ITMP nn	The interface process uses the INTFC_BI_ITMP table when generating accounting entries for InterUnit and IntraUnit transactions.
INTFC_BI_NTMP nn	Invoice Numbering temporary table. The interface process inserts a row of data into this table for each invoice number ID. The data in this table assists in assigning invoice numbers to new bill headers.
INTFC_BI_CTMP nn	Consolidated Bill Header temporary table. The interface process inserts a row of data into this table for every new consolidated bill header that it generates for insertion into the BI_HDR table.
INTFC_BI_DTMP nn	Discount/Surcharge Level temporary table. The interface process inserts a row of data into this table for every discount or surcharge level of each charge line for insertion into the BI_LINE_DS_LVL table.
INTFC_BI_HTMP nn	Bill Header temporary table. The interface process inserts a row of data into this table for every new bill header that it generates for insertion into the BI_HDR table.
BI_EGRNTS_TAO nn	Grants extract temporary table.
BI_ELGRNT_TAO nn	Grants line extract temporary table.
BI_IHAR_TAO nn	Bill Header AR accounting distribution temporary table. The interface process inserts a row of data into this table for every new bill header that it generates for insertion into the BI_HDR_AR table.
BI_IHVAT_TAO nn	Bill Header VAT temporary table. The interface process inserts a row of data into this table for every new bill header with VAT information. This temporary table is used only by the Billing Interface process.
BI_IHCRC_TAO nn	Bill Header Credit Card temporary table. The interface process inserts a row of data into this table for every new bill header with credit card information that it generates for insertion into the BI_HDR_CRCARD table.
BI_IHCC_TAO nn	Bill Header Courtesy Copy temporary table. The interface process inserts a row of data into this table for every piece of new bill header courtesy copy information that it generates for insertion into the BI_HDR_CC table. This table is currently not used.
BI_IHNOT_TAO nn	Bill Header Note temporary table. The interface process inserts a row of data into this table for every new bill header with note information that it generates for insertion into the BI_HDR_NOTE table.
BI_ILINE_TAO nn	Bill Line temporary table. The interface process inserts a row of data into this table for each charge line for insertion into the BI_LINE table.
BI_ITAX_TAO nn	Bill Line Tax temporary table. The interface process inserts a row of data into this table for each charge line with tax information for insertion into the BI_LINE_TAX table.
BI_ITXD_TAO nn	Bill Line Tax Detail temporary table. The interface process inserts a row of data into this table for full bill credit and bill line adjustments for insertion into the BI_LINE_TAX_DTL table.
BI_ILEXS_DTAO nn	Bill Line Excise, Sales Tax, or VAT Detail temporary table. The Billing Interface process inserts a row of data into this table for full bill credit and bill line adjustments for insertion into the BI_LINE_EXS_DTL table. This table is used for India transactions only.
BI_ILNOT_TAO nn	Bill Line Note temporary table. The interface process inserts a row of data into this table for each charge line with note information for insertion into the BI_LINE_NOTE table.
BI_IDST_TAO nn	Bill Line Revenue Distribution temporary table. The interface process inserts a row of data into this table for each charge line with revenue distribution information for insertion into the BI_LINE_DST table.
BI_IAR_TAO nn	Bill Line AR Offset Distribution temporary table. The interface process inserts a row of data into this table for each charge line with AR distribution information for insertion into the BI_LINE_DST_AR table.
BI_I_TAO nn	Bill Line Contract Asset temporary table. The interface process inserts a row of data into this table for each charge line with contract asset distribution information for insertion into the BI_LINE_DST_ table.
BI_IDFR_TAO nn	Bill Line Contract Liability Accounting Entries temporary table. The interface process inserts a row of data into this table for each charge line with contract liability distribution information for insertion into the BI_LINE_DST_DFR table.
BI_ISTA_TAO nn	Bill Line Statistical Revenue Accounting Entries temporary table. The interface process inserts a row of data into this table for each charge line with statistical revenue distribution information for insertion into the BI_LINE_DST_STA table.
BI_IIUP_TAO nn	Bill Line InterUnit Payable temporary table. The interface process inserts a row of data into this table for each charge line with InterUnit payable distribution information for insertion into the BI_LINE_IU_PAY table.
BI_IIUE_TAO nn	Bill Line InterUnit Expense temporary table. The interface process inserts a row of data into this table for each charge line with InterUnit expense distribution information for insertion into the BI_LINE_IU_EXP table.
BI_IDSD_TAO nn	Bill Line Discount/Surcharge Detail temporary table. The interface process inserts a row of data into this table for each charge line with discount or surcharge and its distribution information for insertion into the BI_LINE_DS_DTL table.
BI_ILDDS_TAO nn	Bill Line Deferred Discount/Surcharge Detail temporary table. The interface process inserts a row of data into this table for each charge line with deferred discount or surcharge and its distribution information for insertion into the BI_LINE_DS_DFR table.
BI_IDSL_TAO nn	Bill Line Discount/Surcharge Level temporary table. The interface process inserts a row of data into this table for each charge line with discount or surcharge level information for insertion into the BI_LINE_DS_LVL table.