Understanding the Billing Interface Staging Area

Consider the Billing interface staging tables as the denormalized form of the online bill data structure. Therefore, the Billing interface staging area supports the online bill data structure, storing one or more rows of data for each line of chargeable activity sent into PeopleSoft Billing.

The type of data stored in the Billing interface is characterized by one of five transaction types.

Term	Definition
LINE	Represents a bill line charge. For any bill line presented to the interface staging area, one or more accounting entries may be related. For example, if a charge is presented to the staging area and the revenue is distributed 50 percent to one account and 50 percent to another account, then two account entry (AE) transactions are populated in the Billing interface, one for each of the accounts.
AE (accounting entry)	Represents different types of accounting entries for the LINE transaction. The different types of accounting entries are revenue, contract liability, accounts receivable (AR), Contract Asset, InterUnit payables, InterUnit expenses, and statistical information. AE transactions for general ledger (GL) are only mandatory for a LINE transaction when PeopleSoft Billing is generating GL accounting distributions.
NOTE	Represents a note or comment for the LINE transaction. Notes or comments may be related to a LINE transaction and may represent bill header notes or comments or bill line notes or comments. In the event that there are multiple notes or comments for a particular LINE transaction, multiple NOTE rows may be populated in the interface staging area for the LINE transaction. Note or comment transactions (NOTE) are not mandatory for LINE transactions.
DS (discount or surcharge)	Represents an optional discount or surcharge for the LINE transaction. Discounts and surcharges may be related to a LINE transaction. In the event that there are multiple discounts or surcharges for a specific LINE transaction, multiple DS rows may be populated in the interface staging area for the LINE transaction. DS transactions are optional for LINE transactions.
DDS (deferred discount surcharge)	Represents deferred accounting distribution for the discount or surcharge of the LINE transaction. When the contract liability feature is enabled, each DS entry has DDS accounting distribution.
AHDR (adjustment header)	Represents an adjustment header. This transaction type is used only when adjusting an entire bill (CRALL and RBALL). It is also used to specify values to appear on the rebill header. AHDR is the only transaction type that does not require an associated LINE transaction.

Term	Definition
EXSD (excise, sales tax, and VAT detail)	Represents excise, sales tax, and VAT detail. This transaction type is used only for India transactions and is applicable only to transactions from the PeopleSoft Order Management feeder system.

Term	Definition
TAX (sales tax detail)	Represents sales tax detail of the LINE transaction. This transaction type is applicable only to transactions from the PeopleSoft Order Management feeder system.

Note:

To ensure that the data is populated correctly in the Billing interface staging tables, populate all of the Billing interface fields for which you have valid data. Even though the system provides default values for some fields if you leave them blank, you should populate all fields for which you have valid data. This also reduces the work required by the Billing Interface process and can impact batch performance.