Search Results rcv_transactions




I'll provide a detailed description of the RCV_TRANSACTIONS table in Oracle E-Business Suite (EBS), specifically in the Purchasing/Receiving module:

Table Name: RCV_TRANSACTIONS
Module: Purchasing (PO)
Purpose: Stores detailed information about receiving transactions

Key Columns:
1. TRANSACTION_ID (Primary Key)
- Unique identifier for each receiving transaction
- Sequentially generated

2. ORGANIZATION_ID
- Inventory organization where the receipt occurred
- Links to HR_ORGANIZATION_UNITS

3. INVENTORY_ITEM_ID
- Item being received
- Links to MTL_SYSTEM_ITEMS_B

4. PURCHASE_ORDER_ID
- Related Purchase Order
- Links to PO_HEADERS_ALL

5. PURCHASE_ORDER_LINE_ID
- Specific PO line associated with transaction
- Links to PO_LINES_ALL

6. TRANSACTION_TYPE
- Receipt type (Standard Receipt, Return to Vendor, etc.)
- Stored as coded value

7. QUANTITY
- Quantity received in transactional UOM

8. UNIT_OF_MEASURE
- Unit of measurement for receipt

9. TRANSACTION_DATE
- Date and time of receiving transaction

10. CURRENCY_CODE
- Transaction currency

Important Attributes:
- Tracks detailed receiving history
- Supports multiple receiving scenarios
- Integrated with Inventory and Purchasing modules

Typical Uses:
- Receiving goods
- Tracking inventory receipts
- Reconciling purchase orders
- Generating receiving reports

Recommendation: Always join with related tables for complete transaction details.