JDBC Driver for Oracle Fusion Cloud SCM

Build 24.0.9062

ShipmentTransactionRequests

The Shipment Transaction Requests resource manages shipments. You can search for shipment transaction requests by transaction identifier, shipment, shipment line, organization, order number, actual ship date, and many more such attributes. You can get the shipment transaction request information, which includes the details about related shipments, packing units, shipment lines, shipping costs, lots, serial numbers, and processing errors, if any. You can create and update the shipment transaction requests in the interface tables. For example, you can update shipment attributes like actual ship date, ship method, gross weight, and so on. Another example is, a warehouse management application can send the shipment confirmations using this resource.

Columns

Name Type Description
TransactionId [KEY] Long TransactionId of ShipmentTransactionRequests
ActionCode String Value that uniquely identifies the action to be run for this transaction request. Valid values are CreateAndConfirmShipment, ShipmentCreate, and ShipmentUpdate.
TransactionStatusCode String TransactionStatusCode of ShipmentTransactionRequests
TransactionStatus String TransactionStatus of ShipmentTransactionRequests
CreatedBy String CreatedBy of ShipmentTransactionRequests
CreationDate Datetime CreationDate of ShipmentTransactionRequests
LastUpdatedBy String LastUpdatedBy of ShipmentTransactionRequests
LastUpdateDate Datetime LastUpdateDate of ShipmentTransactionRequests
Carrier String Carrier of ShipmentTransactionRequests
ExternalSystemTransactionReference String ExternalSystemTransactionReference of ShipmentTransactionRequests
Finder String Finder of ShipmentTransactionRequests
FromActualShipDate Datetime FromActualShipDate of ShipmentTransactionRequests
FromInitialShipDate Datetime FromInitialShipDate of ShipmentTransactionRequests
Item String Item of ShipmentTransactionRequests
ModeOfTransportCode String ModeOfTransportCode of ShipmentTransactionRequests
Order String Order of ShipmentTransactionRequests
PackingUnit String PackingUnit of ShipmentTransactionRequests
ServiceLevelCode String ServiceLevelCode of ShipmentTransactionRequests
ShipFromOrganizationCode String ShipFromOrganizationCode of ShipmentTransactionRequests
Shipment String Shipment of ShipmentTransactionRequests
ShipmentLine Long ShipmentLine of ShipmentTransactionRequests
SoldToCustomer String SoldToCustomer of ShipmentTransactionRequests
ToActualShipDate Datetime ToActualShipDate of ShipmentTransactionRequests
ToInitialShipDate Datetime ToInitialShipDate of ShipmentTransactionRequests

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062