Search Results ap_invoices_all
I'll provide a comprehensive description of the AP_INVOICES_ALL table in Oracle E-Business Suite (EBS) Accounts Payable module:
TABLE: AP_INVOICES_ALL
Purpose:
- Stores header-level information for Accounts Payable invoices
- Contains details for both Standard and Credit invoices
- Supports multiple operating units and organizations
Key Columns:
1. INVOICE_ID (Primary Key)
- Unique identifier for each invoice
- System-generated sequential number
2. VENDOR_ID
- Links to PO_VENDORS table
- Identifies the supplier/vendor
3. INVOICE_NUM
- Vendor's original invoice number
- Used for invoice matching and tracking
4. INVOICE_DATE
- Date of the original vendor invoice
- Used for accounting and payment terms
5. INVOICE_AMOUNT
- Total invoice amount
- Represents gross invoice value
6. AMOUNT_PAID
- Cumulative amount paid against the invoice
7. CURRENCY_CODE
- Invoice currency
- Defaults from vendor or set during invoice entry
8. TERMS_ID
- Links to AP_TERMS table
- Defines payment terms and conditions
9. BATCH_ID
- Groups invoices processed together
- Useful for batch processing and tracking
10. ORG_ID
- Identifies the operating unit
- Supports multi-organization architecture
11. INVOICE_TYPE_LOOKUP_CODE
- Defines invoice classification
- Standard, Credit, Prepayment, etc.
12. PAYMENT_STATUS_FLAG
- Indicates current payment status
- Paid, Unpaid, Cancelled
13. CANCELLED_DATE
- Date of invoice cancellation (if applicable)
14. CREATION_DATE
- System timestamp of invoice creation
15. CREATED_BY
- User who created the invoice record
Important Characteristics:
- Part of Oracle Payables module
- Supports multiple currencies
- Integrated with General Ledger
- Enables detailed invoice tracking
Typical Usage:
- Invoice data entry
- Invoice matching
- Payment processing
- Financial reporting
Related Tables:
- AP_INVOICE_LINES_ALL
- PO_VENDORS
- AP_TERMS
- GL_CODE_COMBINATIONS
Recommendation:
- Implement proper indexing
- Regularly archive historical data
- Maintain data integrity through validation rules
This description provides a comprehensive overview of the AP_INVOICES_ALL table in Oracle EBS, highlighting its structure, key columns, and significance in the Accounts Payable process.
-
Table: AP_INVOICES_ALL
12.1.1
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_INVOICES_ALL, object_name:AP_INVOICES_ALL, status:VALID, product: AP - Payables , description: Detailed invoice records , implementation_dba_data: AP.AP_INVOICES_ALL ,
-
Table: AP_INVOICES_ALL
12.2.2
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_INVOICES_ALL, object_name:AP_INVOICES_ALL, status:VALID, product: AP - Payables , description: Detailed invoice records , implementation_dba_data: AP.AP_INVOICES_ALL ,
-
Table: AP_INVOICE_DISTRIBUTIONS_ALL
12.1.1
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_INVOICE_DISTRIBUTIONS_ALL, object_name:AP_INVOICE_DISTRIBUTIONS_ALL, status:VALID, product: AP - Payables , description: Invoice distribution line information , implementation_dba_data: AP.AP_INVOICE_DISTRIBUTIONS_ALL ,
-
Table: AP_INVOICE_DISTRIBUTIONS_ALL
12.2.2
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_INVOICE_DISTRIBUTIONS_ALL, object_name:AP_INVOICE_DISTRIBUTIONS_ALL, status:VALID, product: AP - Payables , description: Invoice distribution line information , implementation_dba_data: AP.AP_INVOICE_DISTRIBUTIONS_ALL ,
-
Table: AP_INVOICE_LINES_ALL
12.1.1
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_INVOICE_LINES_ALL, object_name:AP_INVOICE_LINES_ALL, status:VALID, product: AP - Payables , description: AP_INVOICE_LINES_ALL contains records for invoice lines entered manually, generated automatically or imported from the Open Interface. , implementation_dba_data: AP.AP_INVOICE_LINES_ALL ,
-
Table: AP_INVOICE_LINES_ALL
12.2.2
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_INVOICE_LINES_ALL, object_name:AP_INVOICE_LINES_ALL, status:VALID, product: AP - Payables , description: AP_INVOICE_LINES_ALL contains records for invoice lines entered manually, generated automatically or imported from the Open Interface. , implementation_dba_data: AP.AP_INVOICE_LINES_ALL ,
-
Table: AP_INVOICE_PREPAYS_ALL
12.2.2
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_INVOICE_PREPAYS_ALL, object_name:AP_INVOICE_PREPAYS_ALL, status:VALID, product: AP - Payables , description: Invoice prepayment records , implementation_dba_data: AP.AP_INVOICE_PREPAYS_ALL ,
-
Table: AP_INVOICE_RELATIONSHIPS
12.2.2
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_INVOICE_RELATIONSHIPS, object_name:AP_INVOICE_RELATIONSHIPS, status:VALID, product: AP - Payables , description: Relationships between invoices and interest invoices automatically created for overdue invoices , implementation_dba_data: AP.AP_INVOICE_RELATIONSHIPS ,
-
Table: AP_INVOICE_PREPAYS_ALL
12.1.1
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_INVOICE_PREPAYS_ALL, object_name:AP_INVOICE_PREPAYS_ALL, status:VALID, product: AP - Payables , description: Invoice prepayment records , implementation_dba_data: AP.AP_INVOICE_PREPAYS_ALL ,
-
Table: AP_INVOICE_RELATIONSHIPS
12.1.1
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_INVOICE_RELATIONSHIPS, object_name:AP_INVOICE_RELATIONSHIPS, status:VALID, product: AP - Payables , description: Relationships between invoices and interest invoices automatically created for overdue invoices , implementation_dba_data: AP.AP_INVOICE_RELATIONSHIPS ,
-
Table: AP_EXPENSE_REPORT_HEADERS_ALL
12.2.2
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_EXPENSE_REPORT_HEADERS_ALL, object_name:AP_EXPENSE_REPORT_HEADERS_ALL, status:VALID, product: AP - Payables , description: Header information about employee expense reports , implementation_dba_data: AP.AP_EXPENSE_REPORT_HEADERS_ALL ,
-
Table: AP_EXPENSE_REPORT_HEADERS_ALL
12.1.1
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_EXPENSE_REPORT_HEADERS_ALL, object_name:AP_EXPENSE_REPORT_HEADERS_ALL, status:VALID, product: AP - Payables , description: Header information about employee expense reports , implementation_dba_data: AP.AP_EXPENSE_REPORT_HEADERS_ALL ,
-
View: AP_DOCUMENT_LINES_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:SQLAP.AP_DOCUMENT_LINES_V, object_name:AP_DOCUMENT_LINES_V, status:VALID, product: AP - Payables , implementation_dba_data: APPS.AP_DOCUMENT_LINES_V ,
-
View: AP_DOCUMENT_LINES_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:SQLAP.AP_DOCUMENT_LINES_V, object_name:AP_DOCUMENT_LINES_V, status:VALID, product: AP - Payables , implementation_dba_data: APPS.AP_DOCUMENT_LINES_V ,
-
View: AP_INVOICES_READY_TO_PAY_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:SQLAP.AP_INVOICES_READY_TO_PAY_V, object_name:AP_INVOICES_READY_TO_PAY_V, status:VALID, product: AP - Payables , implementation_dba_data: APPS.AP_INVOICES_READY_TO_PAY_V ,
-
View: AP_VIEW_PREPAYS_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:SQLAP.AP_VIEW_PREPAYS_V, object_name:AP_VIEW_PREPAYS_V, status:VALID, product: AP - Payables , implementation_dba_data: APPS.AP_VIEW_PREPAYS_V ,
-
View: AP_VIEW_PREPAYS_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:SQLAP.AP_VIEW_PREPAYS_V, object_name:AP_VIEW_PREPAYS_V, status:VALID, product: AP - Payables , implementation_dba_data: APPS.AP_VIEW_PREPAYS_V ,
-
View: AP_INVOICES_READY_TO_PAY_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:SQLAP.AP_INVOICES_READY_TO_PAY_V, object_name:AP_INVOICES_READY_TO_PAY_V, status:VALID, product: AP - Payables , implementation_dba_data: APPS.AP_INVOICES_READY_TO_PAY_V ,
-
View: AP_WFAPPROVAL_HISTORY_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:SQLAP.AP_WFAPPROVAL_HISTORY_V, object_name:AP_WFAPPROVAL_HISTORY_V, status:VALID, product: AP - Payables , implementation_dba_data: APPS.AP_WFAPPROVAL_HISTORY_V ,
-
View: AP_INVOICE_PAYMENT_HISTORY_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:SQLAP.AP_INVOICE_PAYMENT_HISTORY_V, object_name:AP_INVOICE_PAYMENT_HISTORY_V, status:VALID, product: AP - Payables , implementation_dba_data: APPS.AP_INVOICE_PAYMENT_HISTORY_V ,
-
View: AP_INVOICE_PAYMENT_HISTORY_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:SQLAP.AP_INVOICE_PAYMENT_HISTORY_V, object_name:AP_INVOICE_PAYMENT_HISTORY_V, status:VALID, product: AP - Payables , implementation_dba_data: APPS.AP_INVOICE_PAYMENT_HISTORY_V ,
-
Table: AP_TRIAL_BAL
12.1.1
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_TRIAL_BAL, object_name:AP_TRIAL_BAL, status:VALID, product: AP - Payables , description: No longer used , implementation_dba_data: AP.AP_TRIAL_BAL ,
-
View: AP_INVOICE_LINES_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:SQLAP.AP_INVOICE_LINES_V, object_name:AP_INVOICE_LINES_V, status:VALID, product: AP - Payables , implementation_dba_data: APPS.AP_INVOICE_LINES_V ,
-
Table: AP_UNSELECTED_INVOICES_ALL
12.1.1
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_UNSELECTED_INVOICES_ALL, object_name:AP_UNSELECTED_INVOICES_ALL, status:VALID, product: AP - Payables , description: This table holds invoices that could not be paid by a payment batch. , implementation_dba_data: AP.AP_UNSELECTED_INVOICES_ALL ,
-
Table: AP_HOLDS_ALL
12.2.2
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_HOLDS_ALL, object_name:AP_HOLDS_ALL, status:VALID, product: AP - Payables , description: Invoice hold information , implementation_dba_data: AP.AP_HOLDS_ALL ,
-
Table: AP_HOLDS_ALL
12.1.1
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_HOLDS_ALL, object_name:AP_HOLDS_ALL, status:VALID, product: AP - Payables , description: Invoice hold information , implementation_dba_data: AP.AP_HOLDS_ALL ,
-
Table: AP_TRIAL_BAL
12.2.2
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_TRIAL_BAL, object_name:AP_TRIAL_BAL, status:VALID, product: AP - Payables , description: No longer used , implementation_dba_data: AP.AP_TRIAL_BAL ,
-
Table: AP_TRIAL_BALANCE
12.2.2
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_TRIAL_BALANCE, object_name:AP_TRIAL_BALANCE, status:VALID, product: AP - Payables , description: Denormalized information about posted invoices for your accrual set of books , implementation_dba_data: AP.AP_TRIAL_BALANCE ,
-
Table: AP_PURGE_INVOICE_LIST
12.2.2
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_PURGE_INVOICE_LIST, object_name:AP_PURGE_INVOICE_LIST, status:VALID, product: AP - Payables , description: Temporary storage of invoice IDs for invoice purge candidates , implementation_dba_data: AP.AP_PURGE_INVOICE_LIST ,
-
Table: AP_PURGE_INVOICE_LIST
12.1.1
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_PURGE_INVOICE_LIST, object_name:AP_PURGE_INVOICE_LIST, status:VALID, product: AP - Payables , description: Temporary storage of invoice IDs for invoice purge candidates , implementation_dba_data: AP.AP_PURGE_INVOICE_LIST ,
-
Table: AP_UNSELECTED_INVOICES_ALL
12.2.2
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_UNSELECTED_INVOICES_ALL, object_name:AP_UNSELECTED_INVOICES_ALL, status:VALID, product: AP - Payables , description: This table holds invoices that could not be paid by a payment batch. , implementation_dba_data: AP.AP_UNSELECTED_INVOICES_ALL ,
-
Table: AP_AWT_TAX_RATES_ALL
12.1.1
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_AWT_TAX_RATES_ALL, object_name:AP_AWT_TAX_RATES_ALL, status:VALID, product: AP - Payables , description: Withholding tax rates , implementation_dba_data: AP.AP_AWT_TAX_RATES_ALL ,
-
Table: AP_AWT_TAX_RATES_ALL
12.2.2
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_AWT_TAX_RATES_ALL, object_name:AP_AWT_TAX_RATES_ALL, status:VALID, product: AP - Payables , description: Withholding tax rates , implementation_dba_data: AP.AP_AWT_TAX_RATES_ALL ,
-
Table: AP_DOC_SEQUENCE_AUDIT
12.1.1
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_DOC_SEQUENCE_AUDIT, object_name:AP_DOC_SEQUENCE_AUDIT, status:VALID, product: AP - Payables , description: Voucher numbers assigned to invoices and payments , implementation_dba_data: AP.AP_DOC_SEQUENCE_AUDIT ,
-
Table: AP_DOC_SEQUENCE_AUDIT
12.2.2
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_DOC_SEQUENCE_AUDIT, object_name:AP_DOC_SEQUENCE_AUDIT, status:VALID, product: AP - Payables , description: Voucher numbers assigned to invoices and payments , implementation_dba_data: AP.AP_DOC_SEQUENCE_AUDIT ,
-
Table: AP_PAYMENT_SCHEDULES_ALL
12.2.2
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_PAYMENT_SCHEDULES_ALL, object_name:AP_PAYMENT_SCHEDULES_ALL, status:VALID, product: AP - Payables , description: Scheduled payment information on invoices , implementation_dba_data: AP.AP_PAYMENT_SCHEDULES_ALL ,
-
Table: AP_AWT_TEMP_DISTRIBUTIONS_ALL
12.1.1
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_AWT_TEMP_DISTRIBUTIONS_ALL, object_name:AP_AWT_TEMP_DISTRIBUTIONS_ALL, status:VALID, product: AP - Payables , description: Withholding tax temporary distributions , implementation_dba_data: AP.AP_AWT_TEMP_DISTRIBUTIONS_ALL ,
-
Table: AP_AWT_TEMP_DISTRIBUTIONS_ALL
12.2.2
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_AWT_TEMP_DISTRIBUTIONS_ALL, object_name:AP_AWT_TEMP_DISTRIBUTIONS_ALL, status:VALID, product: AP - Payables , description: Withholding tax temporary distributions , implementation_dba_data: AP.AP_AWT_TEMP_DISTRIBUTIONS_ALL ,
-
Table: AP_TRIAL_BALANCE
12.1.1
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_TRIAL_BALANCE, object_name:AP_TRIAL_BALANCE, status:VALID, product: AP - Payables , description: Denormalized information about posted invoices for your accrual set of books , implementation_dba_data: AP.AP_TRIAL_BALANCE ,
-
View: AP_INVOICE_LINES_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:SQLAP.AP_INVOICE_LINES_V, object_name:AP_INVOICE_LINES_V, status:VALID, product: AP - Payables , implementation_dba_data: APPS.AP_INVOICE_LINES_V ,
-
Table: AP_BATCHES_ALL
12.1.1
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_BATCHES_ALL, object_name:AP_BATCHES_ALL, status:VALID, product: AP - Payables , description: Summary invoice batch information , implementation_dba_data: AP.AP_BATCHES_ALL ,
-
Table: AP_PAYMENT_SCHEDULES_ALL
12.1.1
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_PAYMENT_SCHEDULES_ALL, object_name:AP_PAYMENT_SCHEDULES_ALL, status:VALID, product: AP - Payables , description: Scheduled payment information on invoices , implementation_dba_data: AP.AP_PAYMENT_SCHEDULES_ALL ,
-
Table: AP_INV_APRVL_HIST_ALL
12.1.1
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_INV_APRVL_HIST_ALL, object_name:AP_INV_APRVL_HIST_ALL, status:VALID, product: AP - Payables , description: AP_INV_APRVL_HIST_ALL contains the approval and rejection history of each invoice that passes through the Invoice Approval Workflow process. The process inserts a record for each approver assigned to review an invoice. , implementation_dba_data: AP.AP_INV_APRVL_HIST_ALL ,
-
Table: AP_INV_APRVL_HIST_ALL
12.2.2
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_INV_APRVL_HIST_ALL, object_name:AP_INV_APRVL_HIST_ALL, status:VALID, product: AP - Payables , description: AP_INV_APRVL_HIST_ALL contains the approval and rejection history of each invoice that passes through the Invoice Approval Workflow process. The process inserts a record for each approver assigned to review an invoice. , implementation_dba_data: AP.AP_INV_APRVL_HIST_ALL ,
-
Table: AP_BATCHES_ALL
12.2.2
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_BATCHES_ALL, object_name:AP_BATCHES_ALL, status:VALID, product: AP - Payables , description: Summary invoice batch information , implementation_dba_data: AP.AP_BATCHES_ALL ,
-
Table: AP_SUPPLIER_SITES_ALL
12.1.1
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_SUPPLIER_SITES_ALL, object_name:AP_SUPPLIER_SITES_ALL, status:VALID, product: AP - Payables , description: AP_SUPPLIER_SITES_ALL stores information about your supplier site level attributes. , implementation_dba_data: AP.AP_SUPPLIER_SITES_ALL ,
-
Table: AP_AWT_GROUPS
12.1.1
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_AWT_GROUPS, object_name:AP_AWT_GROUPS, status:VALID, product: AP - Payables , description: Withholding tax groups , implementation_dba_data: AP.AP_AWT_GROUPS ,
-
Table: AP_SUPPLIER_SITES_ALL
12.2.2
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_SUPPLIER_SITES_ALL, object_name:AP_SUPPLIER_SITES_ALL, status:VALID, product: AP - Payables , description: AP_SUPPLIER_SITES_ALL stores information about your supplier site level attributes. , implementation_dba_data: AP.AP_SUPPLIER_SITES_ALL ,
-
Table: AP_AWT_GROUPS
12.2.2
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_AWT_GROUPS, object_name:AP_AWT_GROUPS, status:VALID, product: AP - Payables , description: Withholding tax groups , implementation_dba_data: AP.AP_AWT_GROUPS ,
-
Table: AP_RECURRING_PAYMENTS_ALL
12.2.2
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_RECURRING_PAYMENTS_ALL, object_name:AP_RECURRING_PAYMENTS_ALL, status:VALID, product: AP - Payables , description: Recurring invoice parameters , implementation_dba_data: AP.AP_RECURRING_PAYMENTS_ALL ,