Oracle Fusion · Data dictionary
WSH_NEW_DELIVERIES
SharedUsed in 12 subject areas20 reporting columns
Shipping (WSH).
Primary key: not yet catalogued for WSH_NEW_DELIVERIES, reference Oracle Tables & Views guide.
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ACTUAL_SHIP_DATE | ● | Actual shipment date. | |
| BILL_OF_LADING_NUMBER | ● | Bill of lading number. | |
| CONFIRM_DATE | ● | Confirm date. | |
| CREATION_DATE | ● | Date and time the row was created. | |
| DELIVERY_ID | ● | Identifier for the delivery. | |
| DELIVERY_NAME | ● | Name of the delivery. | |
| FOB_CODE | ● | Code identifying the fob. | |
| FREIGHT_TERMS_CODE | ● | Code identifying the freight terms. | |
| GROSS_WEIGHT | ● | Gross weight. | |
| INITIAL_PICKUP_DATE | ● | Initial pickup date. | |
| LAST_UPDATE_DATE | ● | Date and time the row was last updated (the incremental-extract key). | |
| PACKING_SLIP_NUMBER | ● | Packing slip number. | |
| SEAL_CODE | ● | Code identifying the seal. | |
| SOURCE_LINE_TYPE | ● | Type of source line. | |
| STATUS_CODE | ● | Code identifying the status. | |
| VEHICLE_NUMBER | ● | Vehicle number. | |
| VOLUME | ● | Volume. | |
| VOLUME_UOM_CODE | ● | Code identifying the volume unit of measure. | |
| WAYBILL | ● | Waybill. | |
| WEIGHT_UOM_CODE | ● | Code identifying the weight unit of measure. |
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_NEW_DELIVERIES?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table