Sunday, April 14, 2013

Oracle Apps: Payables Table structure

Oracle Apps Payable Table Structure:

Supplier Tables
AP_SUPPLIERS This table replaces the old PO_VENDORS table.
It stores information about your supplier level attributes.
AP_SUPPLIER_SITES_ALL It stores information about your supplier site level attributes.
IBY_EXTERNAL_PAYEES_ALL   stores Payee(supplier) information.
HZ_PARTIES  Party data for the suppliers.
HZ_PARTY_SITES  Party site data for the supplier sites.B4


Supplier Interface tables
ap_suppliers_int Supplier Interface. Execute Supplier Open Interface Import Program
ap_supplier_sites_int Supplier site interface. Execute "Supplier Sites Open Interface Import" Program


Invoice 
AP_INVOICES_ALL It contains records for invoices you enter
AP_INVOICE_LINES_ALL It contains records for invoice lines entered manually, generated automatically or imported from the Open Interface.
AP_INVOICE_DISTRIBUTIONS_ALL It holds the distribution information that is manually entered or system-generated


Invoice Interface
AP_INVOICES_INTERFACE Invoice Header Information. Run Payables Open Interface Import concurrent program
AP_INVOICE_LINES_INTERFACE Invoice Lines and Distributions Information


Payments:
AP_CHECKS_ALL  Check Header Information
AP_INVOICE_PAYMENTS_ALL Details of Invoice paid by a Check/Payment
AP_PAYMENT_HISTORY_ALL 
AP_INV_SELECTION_CRITERIA_ALL
AP_SELECTED_INVOICES_ALL
AP_PAYMENT_DISTRIBUTIONS_ALL
CE_PAYMENT_DOCUMENTS  AP_CHECK_STOCKS_ALL
IBY_PAY_SERVICE_REQUESTS   Payment Process Request information  (11i Terminology is  Payment Batch)
IBY_PAY_INSTRUCTIONS_ALL  Payment Instruction information
IBY_DOC_PAYABLES_ALL  Invoice information stored by IBY for generating payment
IBY_PAYMENTS_ALL  Payment Information


Accounting
XLA_EVENTS  replaces AP_ACOCUNTING_EVENTS_ALL  
XLA_AE_HEADERS  replaces AP_AE_HEADERS_ALL
XLA_AE_LINES replaces AP_AE_LINES_ALL


Bank Accounts
CE_BANK_ACCOUNTS   AP_BANK_ACCOUNTS_ALL
CE_BANK_ACCT_USES_ALL   replaces AP_BANK_ACCOUNT_USES_ALL


Credit Card Transactions Table
AP_EXPENSE_FEED_LINES Use the Credit Card Transaction Interface Table to load transaction datafrom your credit card issuers into your Payables system. When younsubmit the Credit Card Transaction Validation and Exception Report, for records where the CREATE_DISTRIBUTION_FLAG is Y, Payables
uses the data in the AP_EXPENSE_FEED_LINES table to create distributions with proper accounts in the AP_EXPENSE_FEED_DISTS
table

20 comments:

Deepika said...

Very good informative article. Thanks for sharing such nice article, keep on up dating such good articles.

NO.1 AQM Services | Application Quality Managment Services | Austere Technologies

Deepika said...

wow...nice blog, very helpful information. Thanks for sharing.

NO.1 API DEVELOPMENT SERVICES | MASSIL TECHNOLOGIES

Deepika said...

Excellent informative blog, keep for sharing.

Best System Integration services | Massil Technologies

cara menggugurkan hamil said...

We find lots of learning after reading this very useful article .

realtors said...

Nice article . Thanks for sharing , checkout my work on synthesis essay .

realtors said...

Nice article , Thanks for sharing , checkout my work on scholarship essay examples .

realtors said...

A graduation speech is one of the most remarkable, yet the most prepared event in the life of students. It is one of the reasons that students are often seen searching and looking for answers to the questions such as, what is graduation speech, how to write one, how to have an effective graduation speech.

realtors said...

Life is all about words, and it takes no time for words to become arguments and a lot of people don’t understand the context. The misconception of being between the unclear edge of understanding the words and the context shares a common ground of being rhetoric in nature. The world would have been so much of a happier place if people would have thought about living into compromises rather than adhering to what is restricted to words. The same idea was proposed by Carl Rogers who was a famous psychologist. He proposed the strategy of compromise under the name of Rogerian argument. In this blog we will discuss about rogerian argumentative essay

realtors said...

It is believed that a lot of hard work is required in writing essays when it comes to a specific type of essay that can help to accomplish some academic goals. However, it is obvious that almost all the writing tasks are simply pertaining to the basic principles of essay writing. This edition will help you come up with the best exemplification essay almost within the first try and with minimum effort. Make sure to review the examples also.

realtors said...

As the name indicates, a descriptive essay is all about "description". It is more like a description of the place, events, person or some kind of experience that can serve some purpose. Collectively, it can be inferred that the purpose of such an essay is to paint a picture with words.

realtors said...

The ASA format is mostly used by the students of the sociological subjects and departments, the scholars, and the academics who deal in the studies that are related to sociology. It is certain that if a student fails to understand and use the correct approach towards the citation, it can lead to some major issues particular deductions in the marks, and discredits. For general information, it is inferred that the citation style is much similar to that of the APA citations, particularly in terms of the fact that both use parenthetical references that appear under the heading of references in the end. of precis.

realtors said...

Being a college student as an individual has to come across and do different practices and conventions of academic writing. The underlying purpose of such academic conventions or writing conventions is to make the essay writing techniques more efficient and the practices more easy and more comfortable. It is one of the most commonly used terms in the assignments of English Languages. Also one of the most commonly asked questions in writing is what are writing conventions? This blog will help you understand what a convention is and how it can help to understand conventions and why mastering it is crucial.

realtors said...

Speech writing is one of the forms of communication. It is one of the ways of informing and evaluating the people while considering the underlying goals. Among different types of speeches, the significance of commemorative speech cannot be denied. It is defined as a form of speech in which an individual pays tribute to someone, it can be an event, an individual, or a group of people.

realtors said...

nice article , Thanks for sharing , checkout my work on rhetorical precis.

realtors said...

A literary analysis essay is one of the most commonly assigned tasks in academics, particularly in college students and high school. In general, the task is assumed to be a version of academic writing that is a set of both, writing skills and analyzing skills. The aim of such writing is to help the students improvise their interpretive and analyzing skills and abilities.

realtors said...

nice article , thanks for sharing checkout my work on Informative Speech

John Williams said...

nice article , thanks for sharing , checkout my work on mla format guide.

John Williams said...

ice article, thanks for sharing, check out my work on Best Neighborhoods in Los Angeles.

John Williams said...

nice article, thanks for sharing, check out my work on Best Places To live in San Diego.

AH Group said...

Good article. Thanks for sharing.
Peshawar is the city of Pakistan that is known because of its hospitality and delicious food. Peshawar’s food is listed as one of the best foods worldwide. Check out my blog on best restaurants in peshawar