In Oracle E-Business Suite (EBS), the following tables are commonly used to store payable invoice information:
1. AP_INVOICES_ALL: This table stores header information for invoices entered into Payables. Each record represents an invoice.
2. AP_INVOICE_LINES_ALL: Contains information about the individual lines (line items) of each invoice, such as item description, amount, tax details, etc.
3. AP_INVOICE_DISTRIBUTIONS_ALL: Stores distribution information for each invoice line, including the account code combination, amount, and other accounting details.
4. AP_PAYMENT_SCHEDULES_ALL: If an invoice is scheduled for multiple payments, this table stores the payment schedule information, including due dates and payment amounts.
5. AP_CHECKS_ALL: If payments are made by checks, this table contains information about the issued checks, including check numbers, amounts, and payment dates.
6. AP_PAYMENT_HISTORY_ALL: Stores payment history information, such as payment numbers, dates, and status.
7. AP_PAYMENT_SCHEDULES_PAY: Contains detailed payment schedule information for scheduled payments.
8. AP_CHECKS_ALL: This table stores information about payments made by checks, including check numbers, amounts, and payment dates.
9. AP_CHECKS_ALL: This table contains information about payment batches, including batch numbers, status, and processing dates.
10. AP_BANK_ACCOUNTS_ALL: Stores details about bank accounts used for payments, including bank account numbers, names, and other relevant information.
These are some of the key tables in Oracle EBS Payables where invoice and payment-related information is stored. Depending on the specific needs of your organization and the configuration of your EBS instance, there may be additional tables or variations in table names. Always refer to Oracle’s official documentation or consult with your system administrator for the most accurate and up-to-date information.
