Account payables in oracle apps r12 technical

Account payables in oracle apps r12 technical

In this post , I will describe the Accounts Payables Technical Structure in oracle apps r12. I will share all the Tables names of the Account Payables which uses to store all the important information of the Accounts payable module. In Accounts Payables , we create Supplier Invoices , We do payments of the Supplier Invoices and many other important things. Account payables in oracle apps r12 technical is quite important structure of the Oracle application .

Account payables in oracle apps r12 technical

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

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.

 

ce_bank_accounts 

 

This table store internal bank accounts information

 

ce_banks_v

 

This table store only bank and branch informations

 

select * from apps.ce_bank_acct_uses_all