AR Tables in Oracle Apps r12

AR Tables in Oracle Apps r12

AR is the Receivable module in the Oracle apps r12. We creates the Customer Invoices in Oracle Receivables and we receive Customer Receipts against the Customer Invoices also in the Oracle receivables Modules. In each Activity , we saves these transactional data in the AR Tables in Oracle apps r12. I will describe all the AR Tables of Oracle apps r12 step by step.

 

 

Customer Transaction/Invoice Table

 

 

 

Customer Receipts Tables

 

 

Here above is the key ar tables in oracle apps. Here below i am sharing the detail description of each table one by one.

 

 

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

Click To Know More