Sunday 29 July 2018

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.
 
Account payables in oracle apps r12 technical

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

2 comments:

Anonymous said...

Wow at last I get you. This post can increase my knowledge . I am very glad to know that this is excellent site which is providing you high quality information. Thank you for your amazing post....Please contact us for Oracle Fusion Cloud Financials Training details in our Erptree Training Institute

Outbooks said...

Good Post
also if anyone looking accounting bookkeeping service
visit us our service
Bookkeeping service
Bookkeepers Ireland
Irish Accounting firm in Ireland

Post a Comment

Contact us for any Collaboration, Project Support & On Job Support Work

Name

Email *

Message *