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.