DW_WSH_SHIPMENT_LINE_FREIGHT_COSTS_MAP_G (Preview)

This table requires activation of Shipping Costs functional area. This table stores Shipping Costs related metrics aggregated at the Shipment Line level

Details

Module: Inventory Management

Key Columns

DELIVERY_DETAIL_ID

Columns

Columns
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    

Notes

#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.