This table requires activation of Shipping Costs functional area. This table stores Shipping Costs related metrics aggregated at the Shipment Line level
Module: Inventory Management
DELIVERY_DETAIL_ID
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
---|---|---|---|---|---|---|---|
DELIVERY_DETAIL_ID | NUMBER | 38 | 0 | True | Shipment Line indentifier | ||
SOURCE_RECORD_ID | VARCHAR2 | 64 | This column is for Oracle Internal use only. System | ||||
INVENTORY_ITEM_ID | NUMBER | 38 | 0 | Item identifier for the shipment line #1 | DW_INVENTORY_ITEM_D | INVENTORY_ITEM_ID | |
ORGANIZATION_ID | NUMBER | 38 | 0 | Organization identifier for the shipment line #1 | DW_INTERNAL_ORG_D | ORGANIZATION_ID | |
GLOBAL_CURRENCY_CODE | VARCHAR2 | 16 | Global currency code | DW_CURRENCY_DETAILS_D_TL | CURRENCY_CODE | ||
GLOBAL_SHIPPING_COST | NUMBER | Shipping Cost at the Shipment Line level for category 'Shipping costs' in global currency | |||||
GLOBAL_TOTAL_SHIPPING_COST | NUMBER | Total shipping cost at the Shipment Line level in global currency |
#1 For join with Item Dimension along with INVENTORY_ITEM_ID also join on column ORGANIZATION_ID.
Copyright © 2019, 2024, Oracle and/or its affiliates.