Search Results ap_card_suppliers_all




Overview
Explore in AI Chat

Overview

The AP_CARD_SUPPLIERS_ALL table is a core data object within the Oracle E-Business Suite Payables module (AP). It serves as the central repository for managing the association between corporate credit cards, suppliers, and specific supplier sites. Its primary role is to enable and control the corporate card payment functionality, a critical feature for automating and streamlining employee expense reimbursements and supplier payments. By maintaining these relationships, the table ensures that card transactions can be correctly matched to the appropriate supplier records during the invoice creation and reconciliation processes in Payables, supporting multi-organization structures through its "_ALL" suffix.

Key Information Stored

The table's structure is defined by a composite primary key that uniquely identifies each valid supplier-site-card relationship. The key columns are VENDOR_ID, which links to the master supplier record in PO_VENDORS; VENDOR_SITE_ID, which specifies the precise payment location from PO_VENDOR_SITES_ALL; and CARD_ID, which references the specific corporate credit card defined in AP_CARDS_ALL. While the provided metadata does not list non-key columns, this core relationship data is fundamental. The table's existence for a given combination authorizes the use of the referenced card for payments to that specific supplier site, forming the basis for transaction validation and workflow.

Common Use Cases and Queries

The primary use case is validating and sourcing information for corporate card transaction feeds. When importing credit card transactions, the system references this table to identify the correct supplier and site for automatic invoice generation. A common reporting need is to audit which cards are enabled for which suppliers. A typical query would join to related tables to produce a readable list:

  • SELECT pv.vendor_name, pvs.vendor_site_code, aca.card_number FROM ap_card_suppliers_all acsa JOIN po_vendors pv ON acsa.vendor_id = pv.vendor_id JOIN po_vendor_sites_all pvs ON acsa.vendor_site_id = pvs.vendor_site_id JOIN ap_cards_all aca ON acsa.card_id = aca.card_id WHERE pv.vendor_name LIKE '%Supplier%';

Administrators also query this table to troubleshoot failed transaction imports, often due to missing entries here, and to manage the setup when adding new card programs or supplier sites.

Related Objects

AP_CARD_SUPPLIERS_ALL is a child table with defined foreign key relationships to three key master tables, as documented in the ETRM metadata:

  • PO_VENDORS: Joined via VENDOR_ID. This provides the master supplier information.
  • PO_VENDOR_SITES_ALL: Joined via VENDOR_SITE_ID. This provides the specific pay site details, including address and payment terms.
  • AP_CARDS_ALL: Joined via CARD_ID. This provides the details of the corporate credit card, such as card number, issuer, and employee assignee.

As the linking entity, it is also likely referenced by transactional interfaces and tables that process corporate card transactions, though those specific dependencies are not listed in the provided excerpt.