AP Invoice
Table in Oracle EBS
AP table in
oracle ebs r12
AP_INVOICES_ALL
THIS TABLE STORE ALL INFORMATION BETWEEN
Invoice Headers Workbench information
AP_INVOICE_LINES_ALL
THIS TABLE STORE ALL INVOICE LINES INFORMATION
SAME LIKE INVOICE WORKBENCH
AP_INVOICE_DISTRIBUTIONS_ALL
THIS TABLE STORE ALL INVOICE DISTRIBUTIONS
INFORMATION (ALL GL ACCOUNT INFORMATION)
AP_SUPPLIERS
TO GET ALL THE SUPPLIER INFORMATION FOR THE
INVOICE WE NEED TO GO AP_SUPPLIERS. This is supplier master table
AP_SUPPLIER_SITES_ALL
TO GET ALL THE SUPPLIER SITE INFORMATION FOR
THE INVOICE WE NEED TO GO AP_SUPPLIER_SITES_ALL. In this table we will get
supplier sites and their addresses.
AP_PAYMENT_SCHEDULES_ALL
THIS TABLE STORE INFORMATION OF THE INVOICE
PAYMENT SCHEDULE TAB SAME LIKE INVOICE WORKBENCH. This table store all
information about due dates of the payments
like on which dates we need to make the
payments . This table also store information about discounts also.
AP_PAYMENT_HISTORY_ALL
It also stores the maturity history for
future dated payments.
The table contains a row for each future dated
payment, once the future dated payment matures, i.e. becomes negotiable.
Any time a payment is cleared or un cleared, a
row is inserted into this table for the payment.
AP_BATCHES_ALL
if you are entering the payables invoices in
batches , then in this table you will get information about this batch details.
AP_CHECKS_ALL
THIS TABLE STORE ALL THE INFORMATION ABOUT
PAYMENTS, Here you will get all the payment information ,Check Number , Banks
Detail Vendor etc.
AP_INVOICE_PAYMENTS_ALL
IF YOU WANT TO SEE ONE CHECK IS DONE AGAINST
WHICH PAYABLES INVOICES THEN YOU CAN CHECK FROM THIS TABLE. Here you can see
invoices paid against check.
AP_HOLDS_ALL
THIS TABLE STORE INFORMATION ABPUT INVOICES
HOLDS