Understanding the Billing Interface Data Structure

PeopleSoft Billing enables you to import billing activity from external systems and a number of internal systems—including PeopleSoft Contracts, Project Costing, Inventory, Order Management, Asset Management—through several tables referred to as the Billing interface staging area. The staging area consists of the following six tables with all data attributes supported by the bill data structure: INTFC_BI, INTFC_BI_AEDS, INTFC_BI2, INTFC_BI_NOTE, INTFC_BI_EXSD, INTFC_BI_TAX, and INTFC_BI_HDR.

The structure of the Billing interface tables differs from the structure of a bill in its final form. The Billing Interface process (BIIF0001) takes information from these tables, edits the data, provides defaults, and groups the data into bills. You should understand the types of transactions stored in these tables. These topics provides detailed information about the data in each of the Billing interface tables, as well as how to populate each of the tables.