DW_WSH_PACKING_UNIT_FREIGHT_COSTS_MAP_G (Preview)

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

Details

Module: Inventory Management

Key Columns

LPN_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
LPN_ID NUMBER 38 0 True Packing Unit identifier    
SOURCE_RECORD_ID VARCHAR2 64     This column is for Oracle Internal use only. System    
PACKING_UNIT VARCHAR2 32     Packing Unit Name    
GLOBAL_CURRENCY_CODE VARCHAR2 16     Global currency code DW_CURRENCY_DETAILS_D_TL CURRENCY_CODE
GLOBAL_SHIPPING_COST NUMBER       Aggregated Shipping Cost for the category 'Shipping costs' at the Packing Unit level in the global currency    
GLOBAL_TOTAL_SHIPPING_COST NUMBER       Total Shipping Cost at the Packing Unit level in the global currency    
PACKING_UNIT_GLOBAL_SHIPPING_COST NUMBER       Aggregated Shipping Cost for the category 'Shipping costs' where Cost Level is 'Packing Unit' in global currency    
PACKING_UNIT_GLOBAL_TOTAL_SHIPPING_COST NUMBER       Total Shipping Cost where Cost Level is 'Packing Unit' in global currency    

Copyright © 2019, 2024, Oracle and/or its affiliates.