Understanding the Receivables Interface Tables

The Load AR Pending Items process (BILDAR01) inserts entries into the following tables:

Term	Definition
PENDING_ITEM_FS	Contains information about each new pending item that is created from a billing invoice.
PENDING_DST_FS	Contains any associated PeopleSoft Receivables accounting entries that are sent to PeopleSoft General Ledger by PeopleSoft Billing for each pending item. Under certain circumstances, this table also contains accounting ChartField information for VAT transactions.
GROUP_CNTRL_FS	Contains PeopleSoft Receivables group control information for the entries that are inserted.

The following additional table exists for VAT processing:

Term	Definition
PENDING_VAT_FS	Contains VAT-related information for each PeopleSoft Receivables pending item. The records in this table are grouped by physical nature, VAT tax code, VAT tax code percentage, VAT transaction type, VAT applicability, and VAT treatment. In addition, pending items for services are grouped by VAT location country and state of the buyer, VAT location country and state of the seller, where-service-performed country and state, and services-place-of-supply country and state.

Term

Definition

PENDING_VAT_FS

Contains VAT-related information for each PeopleSoft Receivables pending item. The records in this table are grouped by physical nature, VAT tax code, VAT tax code percentage, VAT transaction type, VAT applicability, and VAT treatment. In addition, pending items for services are grouped by VAT location country and state of the buyer, VAT location country and state of the seller, where-service-performed country and state, and services-place-of-supply country and state.