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

ra_customer_trx_all

ra_customer_trx_lines_all

ra_cust_trx_line_gl_dist_all

ra_terms

Customer Receipts Tables

ar_cash_receipts_all

ar_receivable_applications_all 

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.

Each row in this table includes general invoice information such as customer, transaction type, and printing instructions.

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 stores the AR Invoice accounting information’s for each line of the AR Invoice.

Here will get all the Accounting Information’s. Each row in this table includes the General Ledger account and the amount of the accounting entry.

RA_CUST_TRX_LINE_SALESREPS_ALL

This Table Stores the Sales Person name used in the RA_CUSTOMER_TRX_ALL table.

This Table stores sales credit assignments for invoice lines. If Receivables bases your invoice distributions on sales credits, a mapping exists between the sales credit assignments in this table with the RA_CUST_TRX_LINE_GL_DIST_ALL table. 

AR Receipts Table

AR_CASH_RECEIPTS_ALL

This Table Stores Cash Receipt Header data. The AR_CASH_RECEIPTS_ALL table stores one record for each receipt that you enter.

Receivables concurrently create records in the AR_CASH_RECEIPT_HISTORY_ALL, AR_PAYMENT_SCHEDULES_ALL, and AR_RECEIVABLE_APPLICATIONS_ALL tables for invoice-related receipts. For receipts that are not related to invoices, such as miscellaneous receipts, Receivables creates records in the AR_MISC_CASH_DISTRIBUTIONS_ALL table instead of the AR_RECEIVABLE_APPLICATIONS_ALL table.

AR_RECEIVABLE_APPLICATIONS_ALL

This Table Stores which AR Receipt applied to which AR Invoice in the Oracle application

  

AR_PAYMENT_SCHEDULES_ALL

This Table stores all transactions except adjustments and miscellaneous cash receipts. 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.