This table requires activation of Shipping Costs functional area. This table stores Shipping Costs related metrics aggregated at the Packing Unit level
Module: Inventory Management
LPN_ID
| 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.