Results for “ap_suppliers”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

AP_SUPPLIERS is the master supplier-level table in the Oracle Payables (AP) schema, holding the core attributes that define a supplier (vendor) record within Oracle E-Business Suite 12.1.1 and 12.2.2. Every payable transaction — invoices, payments, withholding, and tax reporting — ultimately traces back to a row in this table through the VENDOR_ID identifier. The table does not store site-level or contact-level detail; those are maintained in subordinate tables such as AP_SUPPLIER_SITES_ALL, which reference AP_SUPPLIERS through the VENDOR_ID foreign key.

From a Data Vault modeling perspective, AP_SUPPLIERS exhibits the characteristics of a hub. Its primary key, AP_SUPPLIERS_PK, is a single surrogate column (VENDOR_ID) that anchors business keys and serves as the join target for numerous dependent and referencing tables across the payables, purchasing, leasing, and India localization schemas.

Key Information Stored

The table contains 180 documented columns. The most consequential for functional and reporting purposes include:

• VENDOR_ID — surrogate primary key (AP_SUPPLIERS_PK and AP_SUPPLIERS_U1), the internal identifier referenced by all dependent tables.
• SEGMENT1 — the supplier number, enforced as a second unique business key via AP_SUPPLIERS_U2.
• VENDOR_NAME / VENDOR_NAME_ALT — the supplier's primary and alternate names.
• VENDOR_TYPE_LOOKUP_CODE and ORGANIZATION_TYPE_LOOKUP_CODE — classify the supplier as an employee, external organization, or other category.
• ENABLED_FLAG and START_DATE_ACTIVE / END_DATE_ACTIVE — control whether the supplier is active and the effective window of activity.
• TERMS_ID, PAY_GROUP_LOOKUP_CODE, and PAYMENT_PRIORITY — drive default payment scheduling.
• INVOICE_CURRENCY_CODE / PAYMENT_CURRENCY_CODE and INVOICE_AMOUNT_LIMIT — define currency and value controls for invoicing.
• HOLD_ALL_PAYMENTS_FLAG, HOLD_FUTURE_PAYMENTS_FLAG, HOLD_FLAG, and PURCHASING_HOLD_REASON — payment and purchasing hold controls.
• NUM_1099, TYPE_1099, and TAX_REPORTING_NAME — U.S. tax reporting attributes.
• ACCTS_PAY_CODE_COMBINATION_ID, DISC_LOST_CODE_COMBINATION_ID, and EXPENSE_CODE_COMBINATION_ID — default accounting Flexfield assignments.
• VAT_REGISTRATION_NUM, AWT_GROUP_ID (FK to AP_AWT_GROUPS), and ALLOW_AWT_FLAG — tax and withholding configuration.
• PARTY_ID and TCA_SYNC_* columns — linkage to the Trading Community Architecture party model.
• EMPLOYEE_ID (FK to PSB_EMPLOYEES) — ties an employee-type supplier back to the HR record.

Common Use Cases and Queries

Reporting and integration scenarios typically resolve supplier identity, status, or payment defaults. A representative lookup by supplier number:

• SELECT vendor_id, vendor_name, segment1, enabled_flag FROM ap_suppliers WHERE segment1 = :supplier_num;
• SELECT s.vendor_name, s.terms_id, s.pay_group_lookup_code FROM ap_suppliers s JOIN ap_supplier_sites_all ss ON s.vendor_id = ss.vendor_id WHERE ss.vendor_site_id = :site_id;
• Identifying held suppliers: SELECT vendor_id, vendor_name, hold_reason FROM ap_suppliers WHERE hold_all_payments_flag = 'Y';
• 1099 reporting extracts leverage NUM_1099 and TYPE_1099 for year-end tax processing.
• Integration interfaces commonly stage supplier data externally and validate against SEGMENT1 before insertion, given its unique index.

Related Objects

• AP_SUPPLIER_SITES_ALL — joins on VENDOR_ID; holds site-level address, payment, and purchasing defaults.
• AP_AWT_GROUPS — referenced via AP_SUPPLIERS.AWT_GROUP_ID for withholding tax configuration.
• PSB_EMPLOYEES — referenced via EMPLOYEE_ID for employee-type suppliers.
• MTL_SERIAL_NUMBERS — joins on ORIGINAL_UNIT_VENDOR_ID for asset provenance.
• JAI_AP_TDS_INV_PAYMENTS and JAI_RETRO_LINE_CHANGES — India localization tables referencing vendor or tax authority identifiers.
• OKL_PARTY_PAYMENT_DTLS and OKL_TRX_AP_INVS_ALL_B — Oracle Leasing references on VENDOR_ID.
• Standard Payables APIs, including the Supplier API and AP_VENDOR_PUB_PKG, populate and maintain this table.