Data Structure

Data Structure of Oracle Receivables

What is Data Structure of Oracle Receivables

Ra_customers

: Customers > Standard

This table stores customer information.

Some columns of interest includes :

·         Customer_name

·         Customer_number

·         Status

·         Customer_prospect_code

·         Customer_type

·         Orig_system_reference (for imported customers from an external source)

Ra_addresses_all

: Customers > Standard

This table stores customer address information and your remit-to addresses.

Some columns of interest includes :

·         Status

·         Orig_system_reference  (for imported customer addresses from an external source)

·         Address1 to address4

·         City

·         State

·         Postal_code

Ra_site_uses_all

: Customers > Standard

This table stores the customer’s site and site purpose.  You must have one row for each address. A customer must have one bill to address for Receivables.  A customer must have one ship to address and one bill to address for Order Entry.

Some columns of interest includes :

·         Site_use_code (BILL_TO, SHIP_TO, STMTS, DUN/LEGAL)

·         Primary_flag

·         Status

·         Location

Ra_customer_trx_all

: Transactions > Transactions

This table stores invoice, debit memo, chargeback, commitment and credit memo header information.

Some columns of interest includes :

·         Cust_trx_type_id (link to ra_cust_trx_types_all)

·         Set_of_books_id (when you have more than one set of book, you’ll also need to link to gl_sets_of_books)

·         Terms_id (link to ra_terms)

·         Trx_number (invoice number)

·         Trx_date (invoice date)

Ra_customer_trx_lines_all

: Transactions > Transactions

This table stores the invoice, debit memo, chargeback, commitment and credit memo line information.

Some columns of interest includes :

·         Line_number

·         Description

·         Quantity_ordered

·         Quantity_credited

·         Quantity_invoiced

·         Unit_standard_price

·         Unit_selling_price

·         Line_type

·         Extended_amount

·         Revenue_amount

Ra_cust_trx_line_gl_dist_all

: Transactions > Transactions

This table stores the accounting information for revenue, unearned revenue, unbilled receivables, receivables, charges, freight and tax for each invoice or credit memo line.

Some columns of interest includes :

·         Amount_gl_date

·         Gl_posted_date

·         Account_class (CHARGES/FREIGHT/TAX/REC/REV/UNBILL/UNEARN)

·         Acctd_amount (functional currency)

Ar_cash_receipts

: Receipts > Receipts

This table stores the payment information.

Some columns of interest includes :

·         Set_of_books_id (when you have more than one set of book, you’ll also need to link to gl_sets_of_books)

·         Status (APP, UNAPP, UNID, NSF, STOP, REV)

·         Type (CASH, MISC)

·         Receipt_number

·         Amount

·         Currency_code

·         Pay_from_customer

·         Receipt_date

Ar_receivable_applications

: Receipts > Receipts

This table stores accounting entries for cash and credit memo applications.

Some columns of interest includes :

·         Amount_applied

·         Line_applied

·         Tax_applied

·         Application_type

·         Display

·         Gl_date

·         Set_of_books_id (when you have more than one set of book, you’ll also need to link to gl_sets_of_books)

Ar_payment_schedules

: Transactions > Transactions and Receipts > Receipts

This table stores all transactions except adjustments and miscellaneous cash receipts.  This table is updated when a transaction occurs against an invoice, debit memo, chargeback, credit memo, on-account credit, or receipt.

Some columns of interest includes :

·         Amount_due_original

·         Status

·         Class (DEP, DM, PMT, GUAR, CM, CB, INV)

·         Due_date

·         Amount_due_remaining

·         Invoice_currency_code

·         Amount_applied

·         Anmount_credited

·         Amount_adjusted