Oracle Receivables Key Tables

AR_RECEIVABLES_TRX_ALL

The table links accounting information with our receivable activities. Possible types of activities include Adjustment, Possible type of activities includes Adjustment, Miscellaneous cash and finance charges. If type is miscellaneous Cash, we can associate either a distribution set of standard accounting flexfield to our receivable activity. Oracle Receivable uses one row for each activity. We use our receivable activities to speed receipt etnry and generate finance charges.

AR_RECEIVABLE_APPLICATIONS_ALL

This table stores all accounting entries for our cash and credit memo applicaitons. Each row includes the amount applied, status and accounting flexfield information. Possible statuses of our applicaiton include APP, UNAPP, ACC and UNIND. We use this infromation to determine the applications of our payments or creditmemos. Confirmed_FLAG is denormalization from AR_CASH_RECEIPTS_ALL. If the cash receipt is not confirmed, the applications of that receipt are not reflected in the payment schedule of the transaction it is applied against. There are two kinds of applicaitons : Cash and CM. This is stored in the column Applicaiton_Type.Cash applicaitons represent applications of a cash receipt. When a cash receipt is initially created, a row is created in this table that has a status of UNAPP for the amount of the cash receipt. Each subsequent application creates two rows one with a status of APP for the amount being applied tot he invoice and one with status UNAPP for the negative of the amount being applied. If you reverse a cash applicaiton a row with status APP with the inverse amount of the original application is created.

The payment_schedule_id and the cash_receipt_id of this record identify the receipt. The applied_payment_schedule_id and the aplied_customer_trx_id of this record identify the on amount credit that we are combining with the receipt. The primary key for this table is Receivable_Applicaiton_Id, which uniquely identifies the transaction that created the row.

RA_CUST_TRX_LINE_GL_DIST_ALL

This table stores the accounting records for revenue , unearned revenue and unbilled receivables for each invoice for 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 through it is null allowed.

AR_PAYMENT_SCHEDULES_ALL

This table stores all transactions except adjustments and miscellaneous cash receipts. Oracle Receivables updates this table when acitivity occurs against an invoice debit memo, charge back, credit memo, on account credit or receipt. Oracle receivable groups different transactions by the column class. These classes include invoice, debitmemos, guarantees, deposits, creditmemos, chargebackas and receipts.