JDBC Driver for Oracle Fusion Cloud SCM

Build 26.0.9770

ShipmentTransactionRequests

Manages shipment transaction requests, allowing search and updates based on various shipment and transaction attributes.

Columns

Name Type SupportedFinders Description
TransactionId [KEY] Long PrimaryKey Unique identifier for the shipment transaction request.
ActionCode String Specifies the action to be performed for this transaction request. Valid values: CreateAndConfirmShipment, ShipmentCreate, and ShipmentUpdate.
TransactionStatusCode String Code representing the status of the shipment transaction request.
TransactionStatus String Description of the shipment transaction request status.
CreatedBy String User who created the shipment transaction request.
CreationDate Datetime Date and time when the shipment transaction request was created.
LastUpdatedBy String User who last updated the shipment transaction request.
LastUpdateDate Datetime Date and time of the last update to the shipment transaction request.
Carrier String FindByAttributes The carrier responsible for transporting the shipment.
ExternalSystemTransactionReference String FindByAttributes Reference identifier from an external system for this shipment transaction request.
Finder String Search key used to locate and retrieve transaction request data.
FromActualShipDate Datetime FindByAttributes Start date range for the actual shipment date.
FromInitialShipDate Datetime FindByAttributes Start date range for the initially planned shipment date.
Item String FindByAttributes Item associated with the shipment transaction request.
ModeOfTransportCode String FindByAttributes Code representing the mode of transport (for example, AIR, SEA, ROAD).
Order String FindByAttributes Order associated with the shipment transaction request.
PackingUnit String FindByAttributes Packing unit details related to the shipment transaction request.
ServiceLevelCode String FindByAttributes Code indicating the level of shipping service requested (for example, STANDARD, EXPRESS).
ShipFromOrganizationCode String FindByAttributes Organization code for the shipping location.
Shipment String FindByAttributes Reference identifier for the shipment record.
ShipmentLine Long FindByAttributes Unique identifier for the shipment line.
SoldToCustomer String FindByAttributes Customer to whom the shipment is sold.
ToActualShipDate Datetime FindByAttributes End date range for the actual shipment date.
ToInitialShipDate Datetime FindByAttributes End date range for the initially planned shipment date.

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