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
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:
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
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