Table & Column Reference — Release 26A
326 tables found — showing 1–25
| Table Name | Cols | Description |
|---|---|---|
| AP AP_1099_TYPES | 11 | AP_1099_TYPES stores 1099 income tax types used for US tax reporting in Oracle Payables. Each row re... |
| AP AP_BANK_ACCOUNTS_ALL | 24 | AP_BANK_ACCOUNTS_ALL is a legacy table that stored bank accounts linked to suppliers in Oracle EBS P... |
| AP AP_BATCHES_ALL | 41 | AP_BATCHES_ALL contains summary information about invoices you enter in batches if you enable the Ba... |
| AP AP_CHECKS_ALL | 186 | AP_CHECKS_ALL stores information about payments issued to suppliers or refunds received from supplie... |
| AP AP_CHECK_FORMATS | 14 | AP_CHECK_FORMATS stores payment format definitions for checks, EFT, and wire transfers in Oracle Pay... |
| AP AP_DISTRIBUTION_SETS_ALL | 28 | AP_DISTRIBUTION_SETS_ALL contains information about Distribution Sets you define to distribute invoi... |
| AP AP_DISTRIBUTION_SET_LINES_ALL | 68 | AP_DISTRIBUTION_SET_LINES_ALL contains detailed information about individual distribution lines you ... |
| AP AP_EXPENSE_REPORT_DISTS_ALL | 15 | AP_EXPENSE_REPORT_DISTS_ALL stores accounting distributions for expense report lines. Links expense ... |
| AP AP_EXPENSE_REPORT_HEADERS_ALL | 33 | AP_EXPENSE_REPORT_HEADERS_ALL stores header information about expense reports entered in Oracle Paya... |
| AP AP_EXPENSE_REPORT_LINES_ALL | 30 | AP_EXPENSE_REPORT_LINES_ALL stores line-level detail for expense reports in Oracle Payables. One row... |
| AP AP_EXPENSE_REPORT_PARAMS_ALL | 10 | AP_EXPENSE_REPORT_PARAMS_ALL stores configuration parameters for expense reports per operating unit. |
| AP AP_HOLDS_ALL | 41 | AP_HOLDS_ALL contains information about holds that you or your Oracle Payables application place on ... |
| AP AP_HOLD_CODES | 20 | AP_HOLD_CODES contains information about hold codes and release codes that you or your Oracle Payabl... |
| AP AP_INCOME_TAX_TYPES | 12 | AP_INCOME_TAX_TYPES stores the 1099-MISC types that you can assign to a supplier for 1099 reporting.... |
| AP AP_INTERFACE_REJECTIONS | 34 | AP_INTERFACE_REJECTIONS stores information about invoice data from the AP_INVOICES_INTERFACE and AP... |
| AP AP_INVOICES_ALL | 237 | AP_INVOICES_ALL contains records for invoices you enter. There is one row for each invoice youenter... |
| AP AP_INVOICES_INTERFACE | 203 | AP_INVOICES_INTERFACE stores header information about invoices that you create or load for import. ... |
| AP AP_INVOICES_V | 21 | AP_INVOICES_V is a convenience view on AP_INVOICES_ALL that joins supplier and payment term informat... |
| AP AP_INVOICE_DISTRIBUTIONS_ALL | 251 | AP_INVOICE_DISTRIBUTIONS_ALL holds the distribution information that is manually entered or system-... |
| AP AP_INVOICE_LINES_ALL | 266 | AP_INVOICE_LINES_ALL contains records for invoice lines entered manually, generated automatically or... |
| AP AP_INVOICE_LINES_INTERFACE | 260 | AP_INVOICE_LINES_INTERFACE stores information used to create one or more invoice distributions. Not... |
| AP AP_INVOICE_PAYMENTS_ALL | 113 | AP_INVOICE_PAYMENTS_ALL contains records of invoice payments that you made to suppliers. There is o... |
| AP AP_INVOICE_V | 15 | AP_INVOICE_V is a single-invoice convenience view providing invoice details with supplier and paymen... |
| AP AP_PAYMENTS_V | 14 | AP_PAYMENTS_V is a view providing payment details joined across AP checks and invoice payment record... |
| AP AP_PAYMENT_EVENTS | 14 | AP_PAYMENT_EVENTS stores events associated with payment processing lifecycle in Oracle Payables. |