Excel Add-In for Oracle Fusion Cloud SCM

Build 24.0.9175

ShipmentsshippingCosts

Tracks detailed cost data for shipments, supporting financial reporting and logistics cost analysis.

Columns

Name Type Description
ShipmentsDeliveryId [KEY] Long Unique identifier for the delivery associated with the shipment.
FreightCostId [KEY] Long Unique identifier for the freight cost associated with the shipment.
DeliveryDetailId Long Identifier for the specific delivery detail related to the shipment.
LPNId Long License Plate Number (LPN) identifier for the shipment.
PackingUnit String The packing unit used for shipment handling.
ShippingCostTypeId Long Identifier for the type of shipping cost applied to the shipment.
ShippingCost String Total shipping cost incurred for the shipment line.
ShippingCostTypeCategoryCode String System-generated code for the category of shipping cost.
ShippingCostTypeCategory String Category of the shipping cost, such as freight or handling.
Amount Decimal The monetary amount associated with the shipping cost.
CurrencyCode String Code representing the currency used for the shipping cost.
CurrencyName String Full name of the currency used for the shipping cost.
ConversionRateTypeCode String Code representing the type of currency conversion rate used.
ConversionRateType String Type of currency conversion rate applied to the transaction.
ConversionRate Decimal Exchange rate applied to convert currency values.
ConversionDate Date Date when the currency conversion was applied.
CreatedBy String User or process that created the shipping cost record.
CreationDate Datetime Date and time when the shipping cost record was created.
LastUpdatedBy String User or process that last updated the shipping cost record.
LastUpdateDate Datetime Date and time when the shipping cost record was last updated.
BaseItem String Primary item associated with the shipment.
DeliveryId Long Identifier for the delivery linked to the shipment.
EndAssemblyItemNumber String Final assembled item number for the shipped product.
Finder String Internal reference or tracking identifier for the shipment.
IntegrationStatus String Current integration status of the shipment within external systems.
Item String Item being shipped, identified by its unique product number.
LineStatus String Current processing status of the shipment line.
OrderNumber String Customer or internal order number linked to the shipment.
OrderType String Type of order associated with the shipment, such as sales or transfer orders.
OrderTypeCode String System-generated code representing the type of order.
ParentPackingUnit String Parent packing unit containing this shipment line.
PickWave String Identifier for the picking wave in which this shipment was processed.
QuickShipStatus String Status indicator for expedited shipping processing.
RcvShipmentLineId Long Receiving shipment line identifier for inbound processing.
Shipment String Reference identifier for the entire shipment.
ShipmentSet String Grouping of shipments processed together as a set.
ShipToCustomer String Name or identifier of the customer receiving the shipment.
ShipToPartyId String Unique identifier for the party designated as the shipment recipient.
SourceOrder String Originating order that generated this shipment.
SourceOrderFulfillmentLine String Fulfillment line reference from the source order.
SourceOrderFulfillmentLineId String Unique identifier for the source order's fulfillment line.
SourceOrderLine String Reference to the specific order line in the source order.
SourceSystemId String Identifier for the source system that created this shipment record.
TradeComplianceStatus String Indicates whether the shipment complies with trade regulations.
TransportationPlanningStatus String Current transportation planning status for the shipment.

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