Oracle R12 AR Tables

Sr. No	Category	Table Name	Description/ Uses
1	Transactions	RA_CUSTOMER_TRX_ALL	Transaction Header table
2		RA_CUSTOMER_TRX_LINES_ALL	Transaction Lines table along with Tax lines.
3		RA_CUST_TRX_LINE_GL_DIST_ALL	Distribution for Transaction Lines
4		RA_CUST_TRX_LINE_SALESREPS_ALL	Salesrep information for Transaction Lines
5	Transaction Interface Tables	RA_INTERFACE_LINES_ALL	Transaction Lines interface
6		RA_INTERFACE_SALESCREDITS_ALL	Transaction Sales credit information
7		RA_INTERFACE_DISTRIBUTIONS_ALL	Transaction Distribution information
8		RA_INTERFACE_ERRORS_ALL	Transaction errors table
9		AR_PAYMENTS_INTERFACE_ALL	Interface table to import receipts
10		AR_INTERIM_CASH_RECEIPTS_ALL	Lockbox transfers the receipts that pass validation to the interim tables
11		AR_INTERIM_CASH_RCPT_LINES_ALL	Lockbox transfers the receipts that pass validation to the interim tables
12	Receipts tables	AR_CASH_RECEIPTS_ALL	Cash Receipt Header tables
13		AR_RECEIVABLE_APPLICATIONS_ALL	stores Receipt Application details
14		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
15		AR_CASH_RECEIPT_HISTORY_ALL	This table stores all of the activity that is contained for the life cycle of a receipt.
16			• Each row represents one step.
17			• The status field for that row tells you which step the receipt has reached.
18			• Possible statuses are Approved, Confirmed, Remitted, Cleared, and Reversed.
19	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.
20		AR_RECEIPT_CLASSES	This table stores the different receipt classes that you define.
21		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