Oracle Fusion · Data dictionary
WSH_DELIVERY_DETAILS
SharedUsed in 12 subject areas44 reporting columns
Shipping (WSH), detail-level data.
Likely primary key: DELIVERY_DETAIL_ID (inferred from Oracle naming conventions, verify against Tables & Views)
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ALLOW_ITEM_SUBSTITUTION_FLAG | ● | Indicator (Y/N) for the allow item substitution. | |
| CREATION_DATE | ● | Date and time the row was created. | |
| CUST_PO_NUMBER | ● | Customer purchase order number. | |
| DATE_REQUESTED | ● | Date requested. | |
| DATE_SCHEDULED | ● | Date scheduled. | |
| DELIVERY_DETAIL_ID | PK? | ● | Identifier for the delivery detail. |
| FOB_CODE | ● | Code identifying the fob. | |
| FREIGHT_TERMS_CODE | ● | Code identifying the freight terms. | |
| GROSS_WEIGHT | ● | Gross weight. | |
| INV_INTERFACED_FLAG | ● | Indicator (Y/N) for the inventory interfaced. | |
| LAST_UPDATE_DATE | ● | Date and time the row was last updated (the incremental-extract key). | |
| LOAD_SEQ_NUMBER | ● | Load seq number. | |
| LOT_NUMBER | ● | Lot number. | |
| NET_WEIGHT | ● | Net weight. | |
| NEW_SOURCE_SHIPMENT_ID | ● | Identifier for the new source shipment. | |
| NEW_SOURCE_SHIPMENT_NUMBER | ● | New source shipment number. | |
| ORIGINAL_DELIVERY_DETAIL_ID | ● | Identifier for the original delivery detail. | |
| ORIGINAL_ITEM_CONVERTED_QTY | ● | Original item converted quantity. | |
| ORIGINAL_ITEM_ID | ● | Identifier for the original item. | |
| RELEASED_STATUS | ● | Status of the released. | |
| REQUESTED_QUANTITY | ● | Requested quantity. | |
| REQUESTED_QUANTITY2 | ● | Requested quantity2. | |
| REQUESTED_QUANTITY_UOM | ● | Requested quantity unit of measure. | |
| REQUESTED_QUANTITY_UOM2 | ● | Requested quantity uom2. | |
| REVISION | ● | Revision. | |
| SALES_ORDER_LINE_NUMBER | ● | Sales order line number. | |
| SALES_ORDER_NUMBER | ● | Sales order number. | |
| SEAL_CODE | ● | Code identifying the seal. | |
| SHIPPED_QUANTITY | ● | Shipped quantity. | |
| SHIPPED_QUANTITY2 | ● | Shipped quantity2. | |
| SHIP_SET_NAME | ● | Name of the shipment set. | |
| SOURCE_LINE_TYPE | ● | Type of source line. | |
| SOURCE_SHIPMENT_ID | ● | Identifier for the source shipment. | |
| SOURCE_SHIPMENT_NUMBER | ● | Source shipment number. | |
| TP_RECEIVED_DATE | ● | Tp received date. | |
| TP_SHIPMENT_LINE | ● | Tp shipment line. | |
| TP_SHIPMENT_NUMBER | ● | Tp shipment number. | |
| TP_STATUS_CODE | ● | Code identifying the tp status. | |
| TRACKING_NUMBER | ● | Tracking number. | |
| VOLUME | ● | Volume. | |
| VOLUME_UOM_CODE | ● | Code identifying the volume unit of measure. | |
| WEIGHT_UOM_CODE | ● | Code identifying the weight unit of measure. | |
| WMS_SHIP_TOLERANCE_ABOVE | ● | Wms shipment tolerance above. | |
| WMS_SHIP_TOLERANCE_BELOW | ● | Wms shipment tolerance below. |
Used by reports
No cataloged report reads from this table yet, it's part of the broader Fusion dictionary.
- ,
Where this surfaces in OTBI
The OTBI subject areas that expose this table. You can't join across them in OTBI, the owned conformed model joins them on shared keys.
- Costing - Cost Accounting Real Time
- Costing - Work Order Costs Real Time
- Inventory - Inventory Transfer Order Real Time
- Inventory - Kanban Activity Real Time
- Maintenance Management - Maintenance Exception Real Time
- Maintenance Management - Material Usage Real Time
- Maintenance Management - Work Order Performance Real Time
- Manufacturing - Actual Production Real Time
- Manufacturing - Material Usage Real Time
- Manufacturing - Production Exceptions Real Time
- Manufacturing - Work Order Performance Real Time
- Shipping Real Time
Need the extract + dbt staging for WSH_DELIVERY_DETAILS?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table