# 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, 2025, Oracle and/or its affiliates.