AP tables in oracle apps r12

AP tables in oracle apps r12

In this post , I am sharing you all the AP tables in oracle apps r12 , which helps to fetch all the AP/Payables related information's from database. There many important tables of AP which stores different different information of the AP module like some of the Tables Stores Supplier Invoice Information's and some stores information's related to their payments. Here below is the list of most important AP tables in oracle aps r12.

 

AP tables in oracle apps 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.