CData Python Connector for Oracle Fusion Cloud SCM

Build 26.0.9770

ShipmentsshippingCosts

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

Columns

Name Type SupportedFinders 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 FindByLineAttributes Primary item associated with the shipment.
DeliveryId Long PrimaryKey Identifier for the delivery linked to the shipment.
EndAssemblyItemNumber String FindByLineAttributes Final assembled item number for the shipped product.
Finder String Internal reference or tracking identifier for the shipment.
IntegrationStatus String FindByLineAttributes Current integration status of the shipment within external systems.
Item String FindByLineAttributes Item being shipped, identified by its unique product number.
LineStatus String FindByLineAttributes Current processing status of the shipment line.
OrderNumber String FindByLineAttributes Customer or internal order number linked to the shipment.
OrderType String FindByLineAttributes Type of order associated with the shipment, such as sales or transfer orders.
OrderTypeCode String FindByLineAttributes System-generated code representing the type of order.
ParentPackingUnit String FindByLineAttributes Parent packing unit containing this shipment line.
PickWave String FindByLineAttributes Identifier for the picking wave in which this shipment was processed.
QuickShipStatus String FindByLineAttributes Status indicator for expedited shipping processing.
RcvShipmentLineId Long FindByLineAttributes Receiving shipment line identifier for inbound processing.
Shipment String FindByShipmentName Reference identifier for the entire shipment.
ShipmentSet String FindByLineAttributes Grouping of shipments processed together as a set.
ShipToCustomer String FindByLineAttributes Name or identifier of the customer receiving the shipment.
ShipToPartyId String FindByLineAttributes Unique identifier for the party designated as the shipment recipient.
SourceOrder String FindByLineAttributes Originating order that generated this shipment.
SourceOrderFulfillmentLine String FindByLineAttributes Fulfillment line reference from the source order.
SourceOrderFulfillmentLineId String FindByFulfillmentLineId Unique identifier for the source order's fulfillment line.
SourceOrderLine String FindByLineAttributes Reference to the specific order line in the source order.
SourceSystemId String FindByFulfillmentLineId Identifier for the source system that created this shipment record.
TradeComplianceStatus String FindByLineAttributes Indicates whether the shipment complies with trade regulations.
TransportationPlanningStatus String FindByLineAttributes Current transportation planning status for the shipment.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9770