This table requires activation of Shipping Costs functional area. This table stores Shipping Costs for Shipments, Packing Units and Shipment Lines
Module: Inventory Management
FREIGHT_COST_ID
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 |
#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.