AP — Payables
237 documented tables · 236 views — Oracle EBS ETRM 12.2.2
Most-referenced tables
| Table | Description | Data Vault class* |
|---|---|---|
AP_BANK_ACCOUNTS_ALL |
hub | |
AP_INVOICES_ALL |
Detailed invoice records | hub |
AP_DISTRIBUTION_SETS_ALL |
Invoice Distribution Set definitions | hub |
AP_BANK_BRANCHES |
hub | |
AP_AWT_GROUPS |
Withholding tax groups | hub-leaning |
AP_PAYMENT_PROGRAMS |
Payment programs used for defining payment formats | hub |
AP_SUPPLIERS |
AP_SUPPLIERS stores information about your supplier level attributes. | hub |
AP_INV_SELECTION_CRITERIA_ALL |
Payment batch invoice selection criteria | hub |
AP_EXPENSE_REPORT_PARAMS_ALL |
Expense type information for expense report templates | hub-leaning |
AP_POL_LOCATIONS_B |
This table stores policy schedule location information. | hub-leaning |
AP_CARD_PROGRAMS_ALL |
Information about credit card programs you have defined | satellite-leaning |
AP_TAX_CODES_ALL |
Tax code information | hub-leaning |
AP_POL_HEADERS |
This table stores the policy schedule header information. | hub-leaning |
AP_INVOICE_PAYMENTS_ALL |
Invoice payment records | satellite-leaning |
AP_SUPPLIER_SITES_ALL |
AP_SUPPLIER_SITES_ALL stores information about your supplier site level attributes. | hub |
*Heuristic classification mined from FK structure — a modeling suggestion, not Oracle's.
Key public APIs
| Package | Class | Procedures | Used by |
|---|---|---|---|
AP_WEB_AUDIT_LIST_PUB |
PUB | 2 | 3 packages |
AP_MATCH_UTILITIES_PUB |
PUB | 1 | 2 packages |
AP_NOTES_PUB |
PUB | 3 | 1 packages |
AP_PARTYMERGE_GRP |
GRP | 7 | 0 packages |