DW_WSH_FREIGHT_COST_DETAILS_MAP_G (Preview)

This table requires activation of Shipping Costs functional area. This table stores Shipping Costs for Shipments, Packing Units and Shipment Lines

Details

Module: Inventory Management

Key Columns

FREIGHT_COST_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
FREIGHT_COST_ID NUMBER 38 0 True Shipping Cost identifier    
SOURCE_RECORD_ID VARCHAR2 64     This column is for Oracle Internal use only. System    
COST_LEVEL VARCHAR2 16     Level at which the Shipping Cost is defined: Shipment, Packing Unit or Shipment Line    
DELIVERY_ID NUMBER 38 0   Shipment identifier    
SHIPMENT_NUMBER VARCHAR2 32     Shipment number    
LPN_ID NUMBER 38 0   Packing Unit identifier    
PACKING_UNIT VARCHAR2 32     Packing Unit Name    
INVENTORY_ITEM_ID NUMBER 38 0   Item identifier for Shipment Line level costs #1 DW_INVENTORY_ITEM_D INVENTORY_ITEM_ID
ORGANIZATION_ID NUMBER 38 0   Organization identifier for Shipment Line level costs #1 DW_INTERNAL_ORG_D ORGANIZATION_ID
DELIVERY_DETAIL_ID NUMBER 38 0   Shipment Line identifier    
FREIGHT_COST_NAME VARCHAR2 64     Shipping Cost Type    
CATEGORY_CODE VARCHAR2 32     Shipping Cost Category DW_WSH_FREIGHT_COST_TYPE_LKP_TL WSH_FREIGHT_COST_TYPE_CODE
TRANSACTION_CURRENCY_CODE VARCHAR2 16     Transaction currency code DW_CURRENCY_DETAILS_D_TL CURRENCY_CODE
TRANSACTION_COST NUMBER       Shipping cost in transaction currency    
GLOBAL_CURRENCY_CODE VARCHAR2 16     Global currency code DW_CURRENCY_DETAILS_D_TL CURRENCY_CODE
GLOBAL_COST NUMBER       Shipping cost in global currency    
GLOBAL_CURRENCY_EXCH_RATE NUMBER       Global currency exchange rate    

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.