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.