Search Results rcv_shipment_headers




The RCV_SHIPMENT_HEADERS table is a critical component of Oracle E-Business Suite's Receiving module (Oracle Purchasing) that stores header-level information about inventory shipments. Here's a detailed description:

Purpose:
- Tracks details of goods received or expected to be received from suppliers
- Contains high-level information about each shipment

Key Columns:
1. SHIPMENT_HEADER_ID (Primary Key)
- Unique identifier for each shipment record
- Sequentially generated number

2. RECEIPT_SOURCE_CODE
- Indicates the source of the shipment (e.g., PO, RMA)
- Examples: VENDOR, INTERNAL, RETURN

3. VENDOR_ID
- References the supplier who sent the shipment
- Links to PO_VENDORS table

4. VENDOR_SITE_ID
- Specific vendor site associated with the shipment
- Links to PO_VENDOR_SITES table

5. EMPLOYEE_ID
- Identifies the employee who processed the shipment
- Links to HR employee records

6. LAST_UPDATE_DATE
- Timestamp of most recent modification

7. LAST_UPDATED_BY
- User who last modified the record

Additional Attributes:
- EXPECTED_RECEIPT_DATE
- SHIPPED_DATE
- RECEIPT_NUM
- BILL_OF_LADING
- COMMENTS

Typical Use Cases:
- Tracking incoming inventory
- Managing receiving processes
- Reconciling purchase orders
- Generating receiving reports