Ar Tables In R12. R12 SLA Tables connection to AP AR INVPayments Receiving R12 SLA Sub ledger Accounting 1 All accounting performed before transfer to the GL. Mostly _ALL are tables and without ALL are Views RA_CUSTOMER_TRX is corresponding view for Table.
We creates the Customer Invoices in Oracle Receivables and we receive Customer Receipts against the Customer Invoices also in the Oracle receivables Modules. 2 Run Create Accounting to populate accounting events SLA tables. The table stores information about each transaction type for all classes of transactions for example invoices commitments and credit memos.
Aging bucket lines used in Receivables aging reports.
Most of the tables for AR and RA are the one with _ALL in the endLike RA_CUSTOMER_TRX_ALLRA_CUSTOMER_TRX_LINES_ALLRA_CUST_TRX_LINES_GL_DIST_ALL etc. Table Name Table Purpose. Using the CUSTOMER_TRX_ID foreign key column the AR_PAYMENT_SCHEDULES_ALL table joins to the RA_CUSTOMER_TRX_ALL table for non-payment transaction entries such as the creation of credit memos debit memos invoices chargebacks or deposits. Drilldown from GL to AR retrieves information from following tables mainly.
