Search Results wsh_new_deliveries




I'll provide a comprehensive description of the WSH_NEW_DELIVERIES table in Oracle EBS (E-Business Suite), typically used in the Shipping and Logistics modules:

Table Name: WSH_NEW_DELIVERIES

Purpose:
- Tracks new delivery information in the Shipping and Warehouse Management module
- Stores details about delivery transactions and shipments

Key Columns:
1. DELIVERY_ID (Primary Key)
- Unique identifier for each delivery
- Sequentially generated

2. ORGANIZATION_ID
- Links to inventory organization
- Identifies the shipping location/warehouse

3. CUSTOMER_ID
- References customer information
- Connects to AR_CUSTOMERS table

4. DELIVERY_TYPE
- Classifies type of delivery (e.g., Sales, Transfer, Return)

5. STATUS_CODE
- Current status of delivery (e.g., Open, Closed, In-Transit)

6. SHIPPING_METHOD_CODE
- Indicates shipping method/carrier

7. FREIGHT_TERMS_CODE
- Defines freight payment terms

8. REQUEST_DATE
- Date delivery was initially requested

9. ACTUAL_SHIPMENT_DATE
- Date shipment was actually processed

10. CREATION_DATE
- Timestamp of delivery record creation

Common Usage:
- Tracks shipment progress
- Manages delivery logistics
- Supports order fulfillment processes

Related Tables:
- WSH_DELIVERY_DETAILS
- SO_HEADERS_ALL
- MTL_MATERIAL_TRANSACTIONS

Typical Constraints:
- Foreign key relationships
- Not null constraints
- Check constraints on status codes

Note: Specific column details might vary slightly based on your Oracle EBS version and customizations.