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.

------- 

Old Table ---- New Table 

------- 

RA_CUSTOMERS -- HZ_PARTIES & HZ_CUST_ACCOUNTS 

RA_ADDRESSES_ALL -- HZ_PARTY_SITES &HZ_LOC_ASSIGNMENTS 

HZ_LOCATIONS -- HZ_CUST_ACCT_SITES_ALL 

RA_SITE_USES_ALL -- HZ_CUST_SITE_USES_ALL

**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