AR stands for Account Receivable in Oracle Application R12, AR comes in Receivable module, in receivable usually we creates customer invoices to receive customer receipts against AR Invoices in Oracle Apps R12, listed AR table used during AR invoice/receipt creation.
Some important listed AR Table’s and descriptions:
RA_CUSTOMER_TRX_ALL: This table stores invoice, debit memo, commitment, and credit memo header information. Each row includes general invoice information such as customer, transaction type, and printing instructions. You need one row for each invoice, debit memo, commitment, and credit memo you create in Oracle Receivables.
RA_CUSTOMER_TRX_LINES_ALL: This table stores information about invoice, debit memo, credit memo, and commitment lines. For example, an invoice can have one line for Product A and another line for Product B. You need one row for each line. Invoice, debit memo, credit memo, and commitment lines are distinguished by the transaction type of the corresponding RA_CUSTOMER_TRX_ALL record.Also, credit memos are required to have a value in PREVIOUS_CUSTOMER_TRX_LINE_ID, except on account credits which are not related to specific invoices/invoice lines at creation time, will not have values in this column.
RA_CUST_TRX_LINE_GL_DIST_ALL: This table stores the accounting records for revenue, unearned revenue and unbilled receivables for each invoice or credit memo line. Each row includes the GL account and the amount of the accounting entry. The AMOUNT column in this table is required even though it is null allowed. You need one row for each accounting distribution. You must have at least one (but you can have multiple) accounting distributions for each invoice or credit memo line.
AR_CASH_RECEIPT_ALL: The Receipt table stores receipt entry per record
AR_CASH_RECEIPT_HISTORY_ALL: This table stores the AR Receipt History and AR Receipt status updates
AR_RECEIVABLE_APPLICATIONS_ALL: This table links accounting information with your Receivables Activities. Possible types of activities include Adjustment, Miscellaneous Cash, and Finance Charges. If your type is Miscellaneous Cash, you can associate either a distribution set or a standard accounting flexfield to your Receivables Activity. Oracle Receivables uses one row for each activity. You use your receivables activities to speed receipt entry and generate finance charges.