Search Results card_acceptor_id




Overview
Explore in AI Chat

Overview

The AP_CC_ACCEPTORS table is a core data structure within the Oracle E-Business Suite Payables (AP) module, specifically for versions 12.1.1 and 12.2.2. It serves as the master repository for information pertaining to credit card acceptors. In the context of corporate credit card programs, an acceptor is the merchant or service provider that processes a credit card transaction. This table's primary role is to store the identifying details of these acceptors, enabling the system to link detailed, line-item transaction data received from card issuers or processors back to the specific merchant. This linkage is fundamental for accurate expense reporting, audit trails, and reconciliation processes within Payables.

Key Information Stored

While the provided metadata does not list all columns, the primary and foreign key relationships define the critical data points. The central column is CARD_ACCEPTOR_ID, which is the table's primary key and uniquely identifies each acceptor record. Another essential column is CARD_PROGRAM_ID, which acts as a foreign key linking the acceptor to a specific corporate card program defined in the AP_CARD_PROGRAMS_ALL table. Typically, this table would also store descriptive information about the acceptor, such as a merchant name, location code (e.g., Merchant Category Code - MCC), and potentially address details, though these specific column names are inferred from standard implementations.

Common Use Cases and Queries

The primary use case for this table is supporting the reconciliation and reporting of corporate credit card transactions. When transaction feeds are loaded into the AP_CREDIT_CARD_TRXNS_ALL table, the CARD_ACCEPTOR_ID foreign key is populated to associate each transaction with a known merchant. Common queries involve joining these tables to produce detailed expense reports. For instance, to list all transactions for a specific merchant, one might use a query pattern such as:

SELECT trx.merchant_reference_number, trx.transaction_amount, acc.merchant_name
FROM ap_credit_card_trxns_all trx, ap_cc_acceptors acc
WHERE trx.card_acceptor_id = acc.card_acceptor_id
AND acc.merchant_name LIKE '%VendorName%';

Another common scenario is analyzing spending by merchant category across all card programs, which would involve joining AP_CC_ACCEPTORS to AP_CARD_PROGRAMS_ALL via CARD_PROGRAM_ID.

Related Objects

As documented in the provided metadata, AP_CC_ACCEPTORS has defined relationships with two key tables in the Payables schema:

  • AP_CARD_PROGRAMS_ALL: This is a parent table. The column AP_CC_ACCEPTORS.CARD_PROGRAM_ID is a foreign key referencing a card program. This relationship defines which corporate card program the acceptor is associated with for transactional purposes.
  • AP_CREDIT_CARD_TRXNS_ALL: This is a child table. The column AP_CREDIT_CARD_TRXNS_ALL.CARD_ACCEPTOR_ID is a foreign key back to AP_CC_ACCEPTORS.CARD_ACCEPTOR_ID. This is the most critical relationship, as it ties every individual credit card transaction record to its corresponding merchant/acceptor record for detailed reporting and reconciliation.
  • Table: AP_CC_ACCEPTORS 12.1.1

    owner:AP,  object_type:TABLE,  fnd_design_data:SQLAP.AP_CC_ACCEPTORS,  object_name:AP_CC_ACCEPTORS,  status:VALID,  product: AP - Payables ,  description: This table stores information about credit card acceptors who provide detail-level transaction information. ,  implementation_dba_data: AP.AP_CC_ACCEPTORS , 

  • Table: AP_CC_ACCEPTORS 12.2.2

    owner:AP,  object_type:TABLE,  fnd_design_data:SQLAP.AP_CC_ACCEPTORS,  object_name:AP_CC_ACCEPTORS,  status:VALID,  product: AP - Payables ,  description: This table stores information about credit card acceptors who provide detail-level transaction information. ,  implementation_dba_data: AP.AP_CC_ACCEPTORS , 

  • View: APBV_CREDIT_CARD_TRXNS 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:SQLAP.APBV_CREDIT_CARD_TRXNS,  object_name:APBV_CREDIT_CARD_TRXNS,  status:VALID,  product: AP - Payables ,  description: Based on AP_CREDIT_CARD_TRXNS_ALL, this business view contains credit card transaction data. ,  implementation_dba_data: APPS.APBV_CREDIT_CARD_TRXNS , 

  • View: APBV_CREDIT_CARD_TRXNS 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:SQLAP.APBV_CREDIT_CARD_TRXNS,  object_name:APBV_CREDIT_CARD_TRXNS,  status:VALID,  product: AP - Payables ,  description: Based on AP_CREDIT_CARD_TRXNS_ALL, this business view contains credit card transaction data. ,  implementation_dba_data: APPS.APBV_CREDIT_CARD_TRXNS ,