AR invoice tables in oracle apps r12. AR Tables and Joins in Oracle Apps R12
RA_CUSTOMER_TRX_ALL
This is the AR Invoice/Transactions Header Table. In
this Table , We will get the Customer Information’s, site Information’s,
Payment Terms ,Transaction Source and Transaction Type kind of Information’s.
RA_CUSTOMER_TRX_LINES_ALL
This is the AR Invoice/Transactions Lines tables. In
this Table , We will get the AR Invoice Lines Information’s along with the Tax
Lines Information’s.
Here in this Table , We will get the separate Lines for
the Each Tax line. If any invoice has 1 Line and two taxes applied to this Line.
Then we will
get three lines for this Invoice. One for Line and
Two for Taxes.
RA_CUST_TRX_LINE_GL_DIST_ALL
This table store the AR Invoice accounting information’s
for each line of the AR Invoice. Here will get all the Accounting Information’s.
RA_CUST_TRX_LINE_SALESREPS_ALL
This Table Stores the Sales Person name used in the
RA_CUSTOMER_TRX_ALL table.
AR Tables and Joins in Oracle Apps R12
select * from RA_CUSTOMER_TRX_ALL a1,RA_CUSTOMER_TRX_LINES_ALl
a2,RA_CUST_TRX_LINE_GL_DIST_ALL a3
where a1.customer_trx_id=a2.customer_trx_id
and a2.customer_trx_id=a3.customer_trx_id
and a2.customer_trx_line_id=a3.customer_trx_line_id
AR Receipts Table
AR_CASH_RECEIPTS_ALL
This Table Stores Cash Receipt Header tables
AR_RECEIVABLE_APPLICATIONS_ALL
This Table Store , Which AR Receipt applied to Which
Ar Invoice in the Oracle application
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.
The status field for that row tells you which step the
receipt has reached.
Possible statuses are Approved, Confirmed, Remitted,
Cleared, and Reversed.
