Loading

Friday, January 29, 2010

Basic AR Tables informatins related to Receipts

These are the main tables which holds Customer Payment information

  • AR_CASH_RECEIPTS_ALL stores one record for each receipt entry.
  • AR_CASH_RECEIPT_HISTORY_ALL stores all of the activity that is contained for the life cycle of a receipt.
  •  Each row represents one step., Possible statuses are Approved, Cleared,Confirmed, Remitted, and Reversed.
  • AR_MISC_CASH_DISTRIBUTIONS_ALL stores all accounting entries for miscellaneous cash applications.
  • AR_DISTRIBUTIONS_ALL stores the accounting distributions for cash receipts, miscellaneous receipts, adjustments,credit memo applications, cash receipt applications, and bills receivable transactions.
  • AR_RECEIVABLE_APPLICATIONS_ALL stores all accounting entries for cash and credit memo applications.
  • Each row includes the amount applied, status, and accounting flexfield information.
 

 
The ER Diagram for a customer Payment can be easily understood as:

 

 

 

1 Responses to “Basic AR Tables informatins related to Receipts”

Sridevi K said...
September 24, 2016 at 3:10 AM

Regards
Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, SQL, PL/SQL, D2K at training@oracleappstechnical.com | +91 - 9581017828.


Post a Comment

Disclaimer

The ideas, thoughts and concepts expressed here are my own. They, in no way reflect those of my employer or any other organization/client that I am associated. The articles presented doesn't imply to any particular organization or client and are meant only for knowledge Sharing purpose. The articles can't be reproduced or copied without the Owner's knowledge or permission.