Oracle Apps R12 Account Receivables (AR) Tables

Posted by

The below given are the Account Receivables (AR) Tables used for AR Setup , AR Transactions.

Oracle Apps R12 Account Receivables (AR) Tables
                    Table Name                                          Table Description
AR Setup tables
RA_BATCH_SOURCESAR Table for storing the transaction sources
RA_CUST_TRX_TYPES_ALLThe table stores information about each transaction type for all classes of transactions, for example, invoices, commitments, and credit memos
AR_RECEIPT_CLASSESThe table stores the different receipt classes that you define
AR_RECEIPT_METHODSThe table stores information about Payment Methods, receipt attributes that you define and assign to Receipt Classes to account for receipts and their applications
AR Transaction Tables
RA_CUSTOMER_TRX_ALL AR Transaction Header table
RA_CUSTOMER_TRX_LINES_ALL AR Transaction Lines table along with Tax lines
RA_CUST_TRX_LINE_GL_DIST_ALL AR Distribution Table  for Transaction Lines
RA_CUST_TRX_LINE_SALESREPS_ALLSalesrep information for Transaction Lines
AR Transaction Interface Tables
RA_INTERFACE_LINES_ALLAR Transaction Lines interface
RA_INTERFACE_SALESCREDITS_ALLAR Transaction Sales credit information
RA_INTERFACE_DISTRIBUTIONS_ALLAR Transaction Distribution information
RA_INTERFACE_ERRORS_ALLAR Transaction errors table
AR_PAYMENTS_INTERFACE_ALLAR Interface table to import receipts
AR_INTERIM_CASH_RECEIPTS_ALLAR Lockbox transfers the receipts that pass validation to the interim tables
AR_INTERIM_CASH_RCPT_LINES_ALLAR Lockbox transfers the receipts that pass validation to the interim tables
AR Receipt Tables
AR_CASH_RECEIPTS_ALLThe Table provides  Cash Receipt Header details
AR_RECEIVABLE_APPLICATIONS_ALLThe Table provides AR Receipt Application details .
AR_PAYMENT_SCHEDULES_ALLThe table is updated when an activity occurs against an invoice, debit memo, charge back, credit memo, on-account credit, bills receivable . The table stores all of the activity that is contained for the life cycle of a receipt
AR_CASH_RECEIPT_HISTORY_ALLThe table provides the complete history of the receipt and each row represents a step for the receipt execution . The status field for that row tells you which step the receipt has reached. The  statuses could be Approved, Confirmed, Remitted, Cleared, and Reversed.