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

64 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

Campus Events said...

ERP in Chennai | ERP Providers in Chennai

https://www.bravetechnologies.in said...

I have read your blog its very Interesting and informative. ERP Solutions Chennai|ERP in Chennai

Mohana M said...

Nice sharing. R is a language and environment for statistical computing and graphics. Want to make a career in R Programming. Learn R Programming Training course @ GangBoard. We are the best provider of online training on evergreen technologies.

Mohana M said...

Excellent sharing. Testing is a wonderful field for IT peoples. Want to learn Selenium Training reach GangBoard. Hadoop Online Training

apto inn said...

You post explain everything in detail and it was very interesting to read. Thank you. nata coaching centres in chennai

Siva Seo said...

Thank you for this valuable information. I have got some important suggestions from it. Get your business to the next level in simple steps.
erp software company in chennai | erp providers in chennai.

Evelin Harriet said...

I have read your blog its very Interesting. Thanks for sharing.
erp software solutions in chennai | erp software development company chennai

sivanesan said...

Excellent post. I have read your blog it's very interesting and informative. Keep sharing.
erp in chennai

oraclefusion said...

Thanks for sharing the useful information and good points were mentioned in the article which is very valuable information and for the further information contact us at
Oracle Fusion Financials Training

Mathew Stephen said...

Informative article on Salesforce technology!!! Your post helped me to understand the career prospects in cloud based CRM tool. Salesforce Training Institutes in Chennai | Salesforce Training in Chennai

prabash said...

Great Blog.. Web Designing Training Institute in Chennai | Web Designing Training Institute in Velachery

navya said...

Wonderful post. Thank you for sharing such a informative blog.. CCNP Training Institute Institute in Chennai | CCNPP Training Institute in Velachery.

Shreeja K said...

Informative article, just what I was looking for.seo services chennai

Brave Technologies said...

Good post..Keep Sharing.! I'm working in brave technologies private limited. We are the leading ERP software development company in chennai.

vigneswaran said...

We have that much more useful information sharing here.In this article explain about oracle fusion function developing details.we update in content was the latest update. In Oracle Fusion applications, the service provider model defines relationships between business units for a specific business function, identifying one business.
Hadoop Training in Chennai
Java Training in Chenna

Krishna Veni said...

Good and Nice article... it is very useful for me to learn, i really learnt through your article... thanks for sharing your information and views...

Oracle Training in chennai | Oracle Training institute in chennai

Ramya Krishnan said...

Interesting and informative article.. very useful to me.. thanks for sharing your wonderful ideas.. please keep on updating..

Java Training in chennai | Dot Net Training in chennai | Android Training in chennai

praveen said...

Wonderful Post..Thanks for sharing..



Linux Training in Chennai | No.1 Linux Training Institute in Chennai | Red Hat Linux Training in Chennai | Online Linux Training in Chennai

deepti said...

ery useful info, and please keep updating........Web Designing Training Institute in Chennai | Web Designing Training Institute in Velachery.

Sanjana E said...

Like most IT professionals, for those of us involved in supporting an enterprise resource planning (ERP) system, upgrades are a fact of life. Whether you embrace it, fear it, avoid it, attack it or procrastinate, microsoft dynamics upgrade requires careful planning and informed decision making.

Daniel Laskar said...


Continue writing like this, very informative content, nice way to write, a real pleasur to read ! sinidomino

vamsi vasi said...

I am so happy to read your post, it's very wonderful information. keep rocking..Software Testing Training Institute in Chennai | Software Testing Training Institute in Velachery

sukere said...

Really an amazing post..! By reading your blog post i gained more information.
Bulk SMS Services in Chennai

sukere said...

Really an amazing post..! By reading your blog post i gained more information.
Bulk SMS Chennai

adhi said...

Great blog, really very interesting to read., Keep updating such a nice blog.
Diploma Project Center in Chennai | BE Project Center in Chennai | MCA Project Center in Chennai

Oracle training in Chennai said...

Really very informative data you have shared. Thanks to shared your knowledge with us.
oracle courses | oracle dba certification cost in chennai