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.