Mar 29, 2010

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

No comments:

OraApps Search

Custom Search

Search This Blog