Excel Add-In for Oracle Fusion Cloud SCM

Build 24.0.9175

ShipmentsouterPackingUnitspackingUnitCosts

Tracks and manages costs associated with specific packing units, aiding in cost allocation and analysis.

Columns

Name Type Description
ShipmentsDeliveryId [KEY] Long Unique identifier for the delivery associated with the outer packing unit in the packing unit cost records, used for tracking delivery status and associated costs.
OuterpackingunitsLPNId [KEY] Long License Plate Number (LPN) identifier for the outer packing unit, used for identifying and tracking the packaging of goods during transportation.
FreightCostId [KEY] Long Unique identifier for the freight cost associated with the packing unit, used for tracking the cost of transportation services.
DeliveryDetailId Long Unique identifier for the delivery detail, representing specific delivery-related costs for the packing unit.
LPNId Long LPN identifier for the packing unit, used to track and identify the individual unit in transit or storage.
PackingUnit String Name or identifier for the packing unit, used to classify the packing unit for shipment and cost allocation purposes.
ShippingCostTypeId Long Unique identifier for the shipping cost type, used to classify different types of shipping costs such as freight, handling, or insurance.
ShippingCost String Amount of the shipping cost allocated to the packing unit, used for cost tracking and reporting.
ShippingCostTypeCategoryCode String Code representing the category of shipping cost, such as 'freight', 'insurance', or 'handling', to further classify the shipping costs.
ShippingCostTypeCategory String Category of the shipping cost type, providing additional context for the classification of shipping-related charges.
Amount Decimal The total amount of the shipping cost or associated cost allocated to the packing unit, crucial for financial analysis and reporting.
CurrencyCode String Currency code for the cost amount, used to standardize and track costs across different currencies.
CurrencyName String Name of the currency used for the cost amounts, ensuring clarity and consistency when interpreting financial data.
ConversionRateTypeCode String Code representing the type of conversion rate applied for currency conversion, used when converting costs between different currencies.
ConversionRateType String Type of conversion rate used for the cost conversion, such as 'spot rate' or 'fixed rate', ensuring the correct methodology for currency conversion.
ConversionRate Decimal The rate at which the currency conversion occurs, used to calculate the equivalent value in another currency.
ConversionDate Date Date when the currency conversion took place, providing a timestamp for when the exchange rate was applied.
CreatedBy String User or system that created the record for the packing unit cost, used for audit and tracking purposes.
CreationDate Datetime Date and time when the packing unit cost record was created, important for recordkeeping and analysis of cost changes over time.
LastUpdatedBy String User or system that last updated the packing unit cost record, used for tracking changes and updates to the cost data.
LastUpdateDate Datetime Date and time when the packing unit cost record was last updated, ensuring that data remains current and accurate.
BaseItem String The primary item or product linked to the packing unit cost record, typically the most important or central item in the shipment.
DeliveryId Long Unique identifier for the delivery associated with the packing unit cost record, helping to track deliveries in the system.
EndAssemblyItemNumber String Item number for the end assembly product, used for identifying the final product or item in an assembly or kit.
Finder String Searchable reference or keyword used to locate the packing unit cost record in the system.
IntegrationStatus String Status of the integration for the packing unit cost record, ensuring synchronization between different systems or databases.
Item String The specific item associated with the packing unit cost, linking the cost to the item for inventory and cost management purposes.
LineStatus String Status of the cost line item, indicating whether the cost is pending, approved, or closed, ensuring clarity on cost progress.
OrderNumber String Order number associated with the packing unit, used to trace costs back to the originating order in the system.
OrderType String Type of order linked to the packing unit cost, such as 'purchase order' or 'sales order', to classify the nature of the order.
OrderTypeCode String Code representing the order type, used for quick classification and filtering of order-related costs.
ParentPackingUnit String Identifier for the parent packing unit, linking the packing unit cost record to its higher-level packaging unit.
PickWave String Identifier for the pick wave associated with the packing unit, used to manage and track the process of picking goods for shipment.
QuickShipStatus String Status indicator for whether the packing unit is eligible for expedited shipping, helping manage urgent shipping requirements.
RcvShipmentLineId Long Identifier for the received shipment line linked to the packing unit cost, helping to match shipments with cost records.
Shipment String Shipment identifier for the packing unit, used to track and manage shipments across the supply chain.
ShipmentSet String Identifier for the shipment set to which the packing unit belongs, organizing related shipments for efficient handling.
ShipToCustomer String Customer receiving the packing unit, critical for delivery tracking and customer service management.
ShipToPartyId String Unique identifier for the party receiving the packing unit, used for cross-referencing in shipment records.
SourceOrder String The source order number from which the packing unit is derived, linking the cost record to the original order.
SourceOrderFulfillmentLine String Line number from the source order fulfillment, providing more granular details about the fulfillment process.
SourceOrderFulfillmentLineId String Unique identifier for the fulfillment line from the source order, linking it to the packing unit and associated costs.
SourceOrderLine String Line item from the source order that corresponds to the packing unit, helping to trace costs back to the order.
SourceSystemId String Identifier for the source system that generated the packing unit cost record, ensuring consistency across systems.
TradeComplianceStatus String Status of the trade compliance check for the packing unit, ensuring that the shipment adheres to regulatory requirements.
TransportationPlanningStatus String Current status of the transportation planning for the packing unit, used to manage the logistics and shipment planning process.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 24.0.9175