Thursday, April 18, 2013

Oracle Apps Receivables (AR) Tables

Transactions
RA_CUSTOMER_TRX_ALL Transaction Header table
RA_CUSTOMER_TRX_LINES_ALL Transaction Lines table along with Tax lines.
RA_CUST_TRX_LINE_GL_DIST_ALL Distribution for Transaction Lines
RA_CUST_TRX_LINE_SALESREPS_ALL Salesrep information for Transaction Lines


Transaction Interface Tables
RA_INTERFACE_LINES_ALL Transaction Lines interface
RA_INTERFACE_SALESCREDITS_ALL Transaction Sales credit information
RA_INTERFACE_DISTRIBUTIONS_ALL Transaction Distribution information
RA_INTERFACE_ERRORS_ALL Transaction errors table
AR_PAYMENTS_INTERFACE_ALL Interface table to import receipts
AR_INTERIM_CASH_RECEIPTS_ALL Lockbox transfers the receipts that pass validation to the interim tables
AR_INTERIM_CASH_RCPT_LINES_ALL Lockbox transfers the receipts that pass validation to the interim tables


Receipts tables
AR_CASH_RECEIPTS_ALL Cash Receipt Header tables
AR_RECEIVABLE_APPLICATIONS_ALL stores Receipt Application details
AR_PAYMENT_SCHEDULES_ALL This table is updated when an activity occurs against an invoice, debit memo, chargeback, credit memo, on-account credit, bills receivable
AR_CASH_RECEIPT_HISTORY_ALL This table stores all of the activity that is contained for the life cycle of a receipt.
• Each row represents one step.
• The status field for that row tells you which step the receipt has reached.
• Possible statuses are Approved, Confirmed, Remitted, Cleared, and Reversed.


Customer Tables
HZ_PARTIES A party is an entity that can enter into a business relationship.
HZ_CUST_ACCOUNTS This table stores information about customer/financial relationships established between a Party and the deploying company.
HZ_PARTY_SITES This table links a party (HZ_PARTIES) and a location (HZ_LOCATIONS) and stores location-Specific party information such as a person’s mail stops at their work address.
HZ_CUST_ACCT_SITES_ALL This table stores information about customer/financial account sites information.
HZ_CUST_SITE_USES_ALL This table stores information about the business purposes assigned to a customer account site
HZ_LOCATIONS A location is a point in geographical space described by an address and/or geographical Indicators such as latitude or longitude.


Setup tables
RA_CUST_TRX_TYPES_ALL This table stores information about each transaction type for all classes of transactions, for example, invoices, commitments, and credit memos.
AR_RECEIPT_CLASSES This table stores the different receipt classes that you define.
AR_RECEIPT_METHODS This table stores information about Payment Methods, receipt attributes that you define and assign to Receipt Classes to account for receipts and their applications

38 comments:

Mathew Stephen said...

There are lots of information about oracle have spread around the web, but this is a unique one according to me. The strategy you have updated here will make me to get to the next level in oracle. Thanks for sharing this.

Oracle Course in Chennai | Oracle Training in Chennai | hadoop training in chennai

robin singh said...

In near future, big data handling and processing is going to the future of IT industry. Thus taking Hadoop Training in Chennai | Big Data Training in Chennai will prove beneficial for talented professionals.

savitha singh said...

Thanks for your informative article on software testing. Your post helped me to understand the future and career prospects in software testing. Keep on updating your blog with such awesome article. testing training in Chennai| Software testing training in Chennai

wildan abdul majid said...

so, if we set the bill-to for one customer, which table will save this information?

Jack Son said...

I am happy to found such helpful and fascinating post that is written in well manner.
Regards..
QTP Training in Chennai | Software Testing Training in Chennai

Mervin Parmar said...

I'am planning to join Oracle certified course. I want some expert advice whether i should go for it or not.
oracle training in chennai|oracle training institutes in chennai|FITA Chennai

complaints

Diya Patel said...

I am reading ur post from the beginning, it was so interesting to read & i feel thanks to you for posting such a good blog, keep updates regularly.Best Hadoop Training Institute In Chennai

murali karthik said...

Thanks for your informative article on UFT automation testing tool. Your post helped me to understand the features and functionality of QTP automation testing tool. QTP Training in Chennai | QTP training Chennai

mathew delport said...

There are lots of information about hadoop have spread around the web, but this is a unique one according to me. The strategy you have updated here will make me to get to the next level in big data. Thanks for sharing this. Hadoop Training in Chennai | Big Data Training in Chennai

Vikyjohn said...

Thanks for the blog.Hadoop is an open-source software for storing data and running applications on a hardware. It provides storage for any kind of data, enormous processing power and the ability to handle tasks. Hadoop changes the enterprise store, process, and analyze data.

Hadoop training in chennai

Marissa Ryan said...

I like this post. Thanks for sharing.
IELTS classes in Kuwait

caroline jesi said...

I am reading your post from the beginning, it was so interesting to read & I feel thanks to you for posting such a good blog, keep updates regularly.
Regards,
Oracle DBA Training in Chennai|Oracle Training Chennai

Anonymous said...

THANKS FOR PROVING THE INFORMATION.

kbs training institute said...

This website is providing the great design for the nice info that to sharing the great technology. Thanks a lot for sharing the nice technology is visible in this blogOracle Apps Technical Online Training

Nikshitha S said...

The strategy you have posted on the oracle hepled me to get into the next level of this technology and had lot of informations in it.
oracle training in chennai | oracle training institutes in chennai

salesforce online training in hyderabad said...

thanks for sharing information,nice article
http://hadooptraininginhyderabad.co.in/salesforce-training-in-hyderabad/

Mathew Stephen said...

Thanks for sharing informative article on Salesforce technology. Your article helped me a lot to understand the career prospects in cloud computing technology.
Regards,
salesforce course in chennai | salesforce training chennai | best salesforce training in chennai

Jhon David said...

The future of software testing is on positive note. It offers huge career prospects for talented professionals to be skilled software testers. Software testing training|Software training|Software testing training in chennai

Nikshitha S said...

Excellent post!!!. The strategy you have posted on this technology helped me to get into the next level and had lot of information in it.
SAS Training in Chennai | SAS Course in Chennai

Anonymous said...

Hi everyone,

can anyone provide join condition between AR_RECEIPT_CLASSES and AR_RECEIPT_METHODS

Thanks in advance

Andrew Son said...

Thanks for sharing this post.Plenty of opportunities are available in IT sectors.Software testing has a great scope in today's IT industry.So,start your career in testing field. Taking training will help you to achieve a respective position.
Thanks
Software testing training | Testing Training in chennai | Software training institutes in chennai

Arthur Mac said...

Quite an interesting piece of information.Good information to know and right to the point.Thanks for sharing such a nice article.
Regards,
Hadoop Training Chennai
| Best Hadoop Training in Chennai | Best hadoop training institute in Chennai

Paul Miller said...

Great and Useful article.Continue sharing.
Hadoop Training in Chennai | Hadoop course in Chennai

Andrew Son said...

Great post!!Hadoop is especially used for Big Data maintenance. It uses Hadoop distributed file system . Its operating system is in cross platform. Its framework mostly written in java programming language. The other languages which are used by hadoop framework are c, c++ (c with classes) and sometimes in shell scripting. Thank you for your informative post.
Regards,
Big Data Training in Chennai | Hadoop Training in Chennai

Mathew Stephen said...

Excellent post.
Cloud computing course in Chennai | Cloud Training in Chennai

Paul Miller said...

Useful post.
Android Training in Chennai | Best Android Training institute in Chennai

Devi.Angularjs said...

Java Training in Chennai | Java Training in Chennai | Dot Net Training in Chennai |
JavaScript Training in CHennai | Java Training Institutes | Single Page Application Development

Devi.Angularjs said...

Java Training in Chennai | Java Training in CHennai | Java Training in CHennai
Online MVC Training India | Angularjs Training | Java Training in Chennai

Devi.Angularjs said...

JMS Training Institutes in Chennai JMS Training Institutes in Chennai | JSP Training Institutes in Chennai Java Spring Hibernate Training Institutes in Chennai Java Spring Hibernate Training Institutes in Chennai EJB Training Institutes in Chennai EJB Training Institutes in Chennai | Hibernate Training Institutes in Chennai

Devi.Angularjs said...

Java Training Institutes Java Training Institutes
JSF Training Institutes in Chennai JSF Training Institutes in Chennai Java EE Training Institutes in Chennai Java EE Training Institutes in Chennai J2EE Training Institutes in Chennai J2EE Training Institutes in Chennai | Core Java Training Institutes in Chennai

Devi.Angularjs said...

Hibernate Training Institutes in ChennaiHibernate Training Institutes in Chennai Hibernate Online Training Hibernate Online Training Hibernate Training in Chennai Hibernate Training in Chennai Java Online Training Java Online Training

Devi.Angularjs said...

JavaScript Training in Chennai JavaScript Training in Chennai Angular 2 Training in Chennai Angular 2 Training in Chennai | HTML5 Training in Chennai JQuery Training in Chennai JQuery Training in Chennai

Devi.Angularjs said...

Corporate Training Companies in India Corporate Training Companies in India Corporate Training in Chennai Corporate Training in Chennai Corporate Training Companies in India Corporate Training Companies in India Java Corporate Training Companies in India Java Corporate Training Companies in India Java Corporate Training Companies in Chennai

Thulasi Raman said...

Thanks for Sharing the valuable information and thanks for sharing the wonderful article..We are glad to see such a wonderful article..
QTP Training in Chennai | QTP Training Institute in Chennai | QTP Training

Jhon Anderson said...

Useful post.
Regards,
SAS Institutes in Chennai | SAS Training Institutes in Chennai

Priya R said...

Great content thanks for sharing this informative blog which provided me technical information keep posting.
Selenium Training in Chennai | Selenium Testing Course in Chennai

Nandhini said...

Thanks for sharing this informative content which provided me the required information about the latest technology.
Salesforce training in Chennai | Salesforce CRM training in Chennai

Rekha J said...

This is my first visit to your blog, your post made productive reading, thank you. dot net training in chennai