Oracle EBS AP Table Names and Description :-
AP_ACCOUNTING_EVENTS_ALL :- Accounting events table
AP_AE_HEADERS_ALL :- Accounting entry headers table
AP_AE_LINES_ALL :- Accounting entry lines table
AP_BANK_ACCOUNTS_ALL :- Bank Account Details
AP_BANK_ACCOUNT_USES_ALL :- Bank Account Uses Information
AP_BANK_BRANCHES :- Bank Branches
AP_BATCHES_ALL :- Summary invoice batch information
AP_CHECKS_ALL :- Supplier payment data
AP_HOLDS_ALL :- Invoice hold information
AP_INVOICES_ALL :- This table corresponds to the Invoices header block of Invoice workbench and holds information of all AP invoices whether it is a manually entered, imported, created from other products like Oracle Loans, Oracle Projects, iSupplier Portal, Refunds from Oracle Receivables etc.
AP_INVOICE_LINES_ALL :- contains records for invoice lines entered manually, generated automatically or imported from the Open Interface.
AP_INVOICE_DISTRIBUTIONS_ALL :- Invoice distribution line information
AP_INVOICE_PAYMENTS_ALL :- Invoice payment records
AP_PAYMENT_DISTRIBUTIONS_ALL :- Payment distribution information
AP_PAYMENT_HISTORY_ALL :- Maturity and reconciliation history for payments
AP_PAYMENT_SCHEDULES_ALL :- Scheduled payment information on invoices
AP_INTERFACE_REJECTIONS :- Information about data that could not be loaded by Payables Open Interface Import
AP_INVOICES_INTERFACE :- Information used to create an invoice using Payables Open Interface Import
AP_INVOICE_LINES_INTERFACE :- Information used to create one or more invoice distributions
AP_SUPPLIERS_ALL :- This table replaces the old PO_VENDORS table.It stores information about your supplier level attributes
AP_SUPPLIER_SITES_ALL :- This table replaces the old PO_VENDOR_SITES_ALL table.It stores information about your supplier site level attributes
AP_SUPPLIER_CONTACTS :- Stores Supplier Contacts
No comments:
Post a Comment