ADO.NET Provider for Oracle Fusion Cloud SCM

Build 24.0.9175

ShipmentsunpackedShipmentLinesshipmentLineCosts

Manages cost information for unpacked shipment lines, aiding in accurate financial tracking.

Columns

Name Type Description
ShipmentsDeliveryId [KEY] Long Unique identifier for the delivery associated with the unpacked shipment line costs.
UnpackedshipmentlinesShipmentLine [KEY] Long Identifier for the specific unpacked shipment line related to shipment line costs.
FreightCostId [KEY] Long Unique identifier for the freight cost associated with the shipment line.
DeliveryDetailId Long Detailed reference for the delivery tied to the shipment line cost.
LPNId Long Identifier for the License Plate Number (LPN) associated with the shipment.
PackingUnit String Describes the packaging unit used for the shipment line.
ShippingCostTypeId Long Identifier for the type of shipping cost applied.
ShippingCost String Total shipping cost allocated to the shipment line.
ShippingCostTypeCategoryCode String Code representing the category of the shipping cost type.
ShippingCostTypeCategory String Category description of the shipping cost type, providing classification.
Amount Decimal Amount of the shipping cost applied to the shipment line.
CurrencyCode String Code representing the currency of the shipping cost.
CurrencyName String Full name of the currency used for the shipping cost.
ConversionRateTypeCode String Code indicating the type of conversion rate used for currency exchange.
ConversionRateType String Description of the conversion rate type applied to the shipping cost.
ConversionRate Decimal Numeric value representing the conversion rate applied.
ConversionDate Date Date when the conversion rate was applied to the shipping cost.
CreatedBy String User who created the shipping cost entry.
CreationDate Datetime Timestamp indicating when the shipping cost was created.
LastUpdatedBy String User who last updated the shipping cost entry.
LastUpdateDate Datetime Timestamp indicating the last update to the shipping cost entry.
BaseItem String Base item associated with the shipping cost entry.
DeliveryId Long Identifier for the delivery associated with the shipment line cost.
EndAssemblyItemNumber String Item number of the final assembly associated with the shipment line cost.
Finder String Search reference used to locate the shipment line cost details.
IntegrationStatus String Status indicating whether the shipment line cost details have been successfully integrated.
Item String Item identifier linked to the shipment line costs.
LineStatus String Current status of the shipment line with applied costs.
OrderNumber String Order number associated with the shipment line costs.
OrderType String Type of order linked to the shipment line costs.
OrderTypeCode String Code representing the order type.
ParentPackingUnit String Reference to the parent packing unit related to the shipment line cost details.
PickWave String Pick wave associated with the shipment line costs.
QuickShipStatus String Status indicating whether the shipment is eligible for quick shipping.
RcvShipmentLineId Long Identifier for the receiving shipment line associated with the shipment line costs.
Shipment String Reference identifier for the shipment linked to the shipment line cost details.
ShipmentSet String Grouping identifier for shipments processed together.
ShipToCustomer String Customer designated as the recipient of the shipment.
ShipToPartyId String Identifier for the party receiving the shipment.
SourceOrder String Order number from the source system related to the shipment line costs.
SourceOrderFulfillmentLine String Fulfillment line identifier from the source order system.
SourceOrderFulfillmentLineId String Unique identifier for the source order fulfillment line.
SourceOrderLine String Order line number from the source system.
SourceSystemId String Identifier for the source system that originated the shipment order.
TradeComplianceStatus String Compliance status of the shipment against trade regulations.
TransportationPlanningStatus String Status of transportation planning related to the shipment line costs.

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