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.
3 comments:
Thanks for sharing This informative article. It would be helpful to all ,Keep sharing.
Oracle Fusion HCM Online Training
Needs to be updated with new AR table for Detail Application of Receipts AR_ACTIVITY_DETAILS
AR_ACTIVITY_DETAILS holds the line level application details for AR receipts
Select * -- cash_receipt_id, customer_trx_line_id, apply_to line_number, amount, line_balance
from AR_ACTIVITY_DETAILS aad
where cash_receipt_id
= &cash_receipt_id
--If Header Level, cash_receipt_id does NOT EXIST on this table.
--If Line Level, cash_receipt_id EXISTS on this table.
and customer_trx_line_id = &customer_trx_line_id --for specific
AR receipt line
Post a Comment