Table of Account Receivables in oracle R12

 The Accounts Receivable (AR) module in Oracle R12 involves several tables that store data related to customer transactions, invoices, receipts, and more. Here's an overview of some key tables in the Oracle R12 Accounts Receivable module:

Key Tables in Oracle R12 Accounts Receivable:

  1. RA_CUSTOMERS

    • Purpose: Stores customer information.
    • Key Columns: CUSTOMER_ID, CUSTOMER_NAME, STATUS, CUSTOMER_NUMBER

  2. RA_CUSTOMER_TRX_ALL

    • Purpose: Stores invoice headers for all transactions such as invoices, credit memos, debit memos, etc.
    • Key Columns: CUSTOMER_TRX_ID, TRX_NUMBER, TRX_DATE, BILL_TO_CUSTOMER_ID, STATUS

  3. RA_CUSTOMER_TRX_LINES_ALL

    • Purpose: Stores the line-level details of transactions recorded in RA_CUSTOMER_TRX_ALL.
    • Key Columns: CUSTOMER_TRX_LINE_ID, CUSTOMER_TRX_ID, LINE_NUMBER, DESCRIPTION, LINE_TYPE

  4. AR_RECEIVABLE_APPLICATIONS_ALL

    • Purpose: Stores information about the application of receipts to invoices and other transactions.
    • Key Columns: APPLICATION_ID, CASH_RECEIPT_ID, CUSTOMER_TRX_ID, APPLIED_AMOUNT, STATUS

  5. AR_CASH_RECEIPTS_ALL

    • Purpose: Stores information about cash receipts.
    • Key Columns: CASH_RECEIPT_ID, RECEIPT_NUMBER, CUSTOMER_ID, RECEIPT_DATE, RECEIPT_AMOUNT

  6. AR_PAYMENT_SCHEDULES_ALL

    • Purpose: Stores information on the payment schedules for invoices, including outstanding balances.
    • Key Columns: PAYMENT_SCHEDULE_ID, CUSTOMER_TRX_ID, DUE_DATE, AMOUNT_DUE_REMAINING, STATUS

  7. AR_ADJUSTMENTS_ALL

    • Purpose: Stores adjustment records made against customer invoices or receipts.
    • Key Columns: ADJUSTMENT_ID, CUSTOMER_TRX_ID, ADJUSTMENT_TYPE, ADJUSTED_AMOUNT, STATUS

  8. HZ_PARTIES

    • Purpose: Stores information about parties involved in transactions (can be customers, suppliers, employees, etc.).
    • Key Columns: PARTY_ID, PARTY_NAME, PARTY_NUMBER, PARTY_TYPE

  9. RA_BATCHES_ALL

    • Purpose: Stores information on batches of invoices.
    • Key Columns: BATCH_ID, BATCH_SOURCE_ID, BATCH_NAME, BATCH_DATE, STATUS

  10. RA_INTERFACE_ERRORS_ALL

    • Purpose: Stores errors encountered during the AutoInvoice process.
    • Key Columns: INTERFACE_LINE_ID, ERROR_CODE, ERROR_MESSAGE

Comments

Post a Comment

Popular posts from this blog

Accounting entries of P2P cycle in Oracle R12

 The Procure-to-Pay (P2P) cycle in Oracle R12 involves various transactions that generate accounting entries as goods and services are purchased, received, and paid for. Below is a detailed breakdown of the typical accounting entries generated during each step of the P2P cycle: 1. Purchase Order Creation When a Purchase Order (PO) is created, there are no accounting entries recorded immediately. The creation of a PO is a commitment to purchase and does not impact the financials until the goods or services are received. 2. Receipt of Goods or Services (Receiving Transaction) When goods or services are received, accounting entries are generated to reflect the receipt in inventory or as an expense. The entries depend on whether the receipt is for inventory or direct charge (expense) items. a. Inventory Receipt (Accrual-Based) Dr. Inventory Material (Asset) Reflects the increase in inventory. Cr. Accrual (Receiving Inventory or Purchase Price Variance Account) Represents the liability...
Read more

Multi Org in Oracle ERP R12

Image
Multi-Org means the implementation of multiple business units (or Organization) under a single installation of Oracle Applications. There are Hierarchy Flow of Multi-Org -  1. Business Group - This is highest level in the Organization Structure. The Business group secures HR     Information. Multiple set of books can share same business group.  2. Legal Entity - It is a legal Business purpose, At this Level we prepared income tax reports.  3. Ledger - It is use to secure Journal and Ledger Balances of a company. A Ledger is a collection of   Currency, chart of account, calendar and accounting Methods.  4. Operating Unit - It is a strategic business unit, At this level we partition and secure sales and purchase   transaction data.  5. Inventory Organization - An Organization for which you track Inventory transactions and balances   and/or an Organization that manufactures or distributes products. ...
Read more

Accounting entries of O2C cycle in Oracle R12

 The Order-to-Cash (O2C) cycle in Oracle R12 involves various transactions that generate accounting entries as goods or services are sold, shipped, invoiced, and payment is collected. Below is a detailed breakdown of the typical accounting entries generated during each step of the O2C cycle: 1. Sales Order Creation When a Sales Order (SO) is created, no accounting entries are generated. The order creation is a commitment from the customer and does not affect the financials until the goods or services are delivered or invoiced. 2. Shipping of Goods (Shipping Transaction) When goods are shipped to the customer, accounting entries are generated to reflect the reduction in inventory and the recognition of the Cost of Goods Sold (COGS). Dr. Cost of Goods Sold (COGS) Reflects the cost of the goods that are shipped to the customer. Cr. Inventory (Asset) Reduces the inventory account to reflect the goods leaving the inventory. 3. Invoicing the Customer (Invoice Creation) When an invoice is...
Read more