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

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

AP_CHECKS_ALL  Check Header Information
AP_INVOICE_PAYMENTS_ALL Details of Invoice paid by a Check/Payment
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


Bank Accounts

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


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.


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 .

Smith said...

Oracle Apps R12 and Oracle Fusion Cloud Self Paced Online Training Videos Published on Udemy with Life Time Access & Live Meeting Support to Clear your Queries. Avail 25% to 80% discount. Please Check for Never Before Offers and Discount Coupon Codes.

saivenkat said...

Those rules moreover attempted to wind up plainly a decent approach to perceive that other individuals online have the indistinguishable enthusiasm like mine to get a handle on incredible arrangement more around this condition
CRM with Invoicing

Susan said...

Wondering where to go in 2020? Things to do has ranked as the best include a remote, idyllic island and the design capital. said...

Nice one.
Peshawar is considered to be one of the most exciting and culturally rich places to visit. The city has a centuries-old history of Alexander, Mughals and different invasions. Known to be the route of the silk road for hundreds of years, it is known for its food, textiles and hospitable people. In this blog we will talk about best restaurants in Peshawar

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

Marketing Agency said...

Oracle Apps table structure is a critical aspect of any software development project, and software houses in Pakistan with expertise in Oracle Apps can help businesses design and implement efficient and scalable database structures.