CData Python Connector for Oracle Fusion Cloud SCM

Build 25.0.9454

ShipmentTransactionRequestsshipments

Links shipment transaction requests to related shipments, ensuring traceability and documentation.

Columns

Name Type Description
ShipmentTransactionRequestsTransactionId [KEY] Long Unique identifier for the transaction request associated with shipments.
DeliveryInterfaceId [KEY] Long Unique identifier for the delivery interface linked to the shipment transaction.
Shipment String Name of the material shipment.
Description String Detailed description of the shipment.
ShipFromOrganizationCode String Code representing the ship-from organization.
SoldToCustomerNumber String Customer number identifying the sold-to party.
SoldToCustomer String Name of the customer who purchased the shipment.
ShipToPartySiteNumber String Unique identifier for the ship-to party site.
InitialShipDate Datetime Planned shipment date as scheduled by the warehouse.
BillOfLading String Carrier-issued receipt acknowledging shipped goods and shipment terms.
GrossWeight Decimal Total weight of the shipment including packaging.
NetWeight Decimal Net weight of the shipment excluding packaging.
WeightUOMCode String Code representing the unit of measure (UOM) for shipment weight.
WeightUOM String UOM used to express shipment weight.
Volume Decimal Total volume of the shipment.
VolumeUOMCode String Code representing the UOM for shipment volume.
VolumeUOM String UOM used to express shipment volume.
Equipment String Registration number of the vehicle or equipment used for transport.
EquipmentType String Type of vehicle or equipment used for transport.
SealNumber String Number of the security seal applied to ensure shipment integrity.
CarrierNumber String Carrier-assigned number identifying the shipping carrier.
Carrier String Name of the shipping carrier handling the shipment.
ModeOfTransportCode String Code indicating the transport mode (for example, air, sea, ground).
ServiceLevelCode String Code representing the service level for the shipping method.
Waybill String Document that describes the terms of cargo transportation.
PackingSlip String List detailing the items included in the shipment.
ActualShipDate Datetime Date when the shipment was physically dispatched.
PlannedDeliveryDate Datetime Expected arrival date of the shipment at its destination.
FreightTermsCode String Code identifying the freight payment terms.
FreightTerms String Description of payment terms for freight costs.
FOBCode String Code indicating ownership of goods during transit.
FOBSiteNumber String Identifier for the freight on board (FOB) site.
FOBAddress1 String First line of the freight on board address.
FOBAddress2 String Second line of the freight on board address.
FOBAddress3 String Third line of the freight on board address.
FOBAddress4 String Fourth line of the freight on board address.
FOBCity String City for the freight on board location.
FOBCounty String County for the freight on board location.
FOBPostalCode String Postal code of the freight on board address.
FOBRegion String Region associated with the freight on board location.
FOBState String State for the freight on board location.
FOBCountry String Country for the freight on board location.
Dock String Loading dock assigned for shipment dispatch.
CODAmount Decimal Amount to be collected on delivery.
CODCurrency String Currency for the collect on delivery amount.
CODPaidBy String Party responsible for paying the collect on delivery amount.
CODRemitTo String Entity receiving the collect on delivery payment.
ASNSentDate Datetime Date the advance shipment notice (ASN) was sent.
ConfirmedDate Datetime Date and time the shipment was confirmed.
ConfirmedBy String User who confirmed the shipment.
LoadingSequenceRule String Rule determining the order of loading shipment lines.
ProblemContactReference String Contact person for issues encountered during shipment.
TransportationReasonCode String Reason code indicating the purpose of the shipment.
PlannedFlag Bool Indicates whether the shipment is planned (true) or not (false).
AutomaticallyPackFlag Bool Indicates whether the shipment is eligible for batch packing.
EnableAutoshipFlag Bool Indicates whether the shipment is eligible for batch shipping.
ProrateWeightFlag Bool Indicates whether shipment weight should be prorated.
CreatedBy String User who created the shipment transaction request.
CreationDate Datetime Timestamp when the shipment transaction request was created.
LastUpdatedBy String User who last modified the shipment transaction request.
LastUpdateDate Datetime Timestamp when the shipment transaction request was last updated.
ExternalSystemTransactionReference String Reference ID for the corresponding transaction in an external system.
Finder String Identifier used to locate or retrieve shipment transaction requests.
FromActualShipDate Datetime Start date range for actual shipment departure.
FromInitialShipDate Datetime Start date range for initially planned shipment departure.
Item String Item associated with the shipment transaction request.
Order String Order number linked to the shipment transaction request.
PackingUnit String Packing unit associated with the shipment transaction request.
ShipmentLine Long Line item number within the shipment transaction request.
ToActualShipDate Datetime End date range for actual shipment departure.
ToInitialShipDate Datetime End date range for initially planned shipment departure.
TransactionId Long Unique identifier of the shipment transaction request.

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