ADO.NET Provider for Oracle Fusion Cloud SCM

Build 24.0.9175

ShipmentLineTransactionRequestsshipmentLinesholds

Manages detailed information about holds placed on shipment lines, including reasons for holds and related processes.

Columns

Name Type Description
ShipmentLineTransactionRequestsTransactionId [KEY] Long The unique identifier for the shipment line transaction request that holds the shipment.
ShipmentlinesDeliveryDetailInterfaceId [KEY] Long The unique identifier for the delivery detail interface record associated with the shipment line hold.
HoldActionCode String The abbreviation that identifies the action code for the hold. Valid values typically include 'APPLY_HOLD' and 'RELEASE_HOLD'.
HoldId Long The unique identifier for the hold applied to the shipment line.
HoldReasonCode String The code that identifies the reason for applying or releasing the hold. Possible values include 'APPLY_HOLD' and 'RELEASE_HOLD'.
HoldReason String A description providing details about why the hold was applied to the shipment line.
CreatedBy String The user or system that created the hold record for the shipment line.
CreationDate Datetime The date and time when the hold record for the shipment line was created.
LastUpdatedBy String The user or system that last updated the hold record for the shipment line.
LastUpdateDate Datetime The date and time when the hold record for the shipment line was last updated.
BaseItem String The base item associated with the shipment line that is placed on hold.
BaseItemId Long The unique identifier for the base item related to the shipment line hold.
Carrier String The name of the carrier responsible for transporting the shipment line that is placed on hold.
CarrierId Long The unique identifier for the carrier associated with the shipment line hold.
CarrierNumber String The carrier's tracking or identification number for the shipment line.
EndAssemblyItem String The item representing the final product or assembly resulting from the shipment line, which is subject to the hold.
Finder String A reference value used to search or locate shipment line hold records within the system.
FromRequestedDate Datetime The start date of the requested delivery date range for the shipment line placed on hold.
FromScheduledShipDate Datetime The start date of the scheduled shipping date range for the shipment line placed on hold.
InitialDestinationId Long The unique identifier for the initial destination of the shipment line's item placed on hold.
Item String The specific item associated with the shipment line placed on hold.
ItemId Long The unique identifier for the item related to the shipment line that is placed on hold.
ModeOfTransportCode String The code identifying the mode of transport for shipping the shipment line item that is on hold.
OrderTypeCode String The code identifying the order type associated with the shipment line that is on hold.
OrganizationCode String The abbreviation identifying the ship-from organization associated with the shipment line hold.
OrganizationId Long The unique identifier for the organization handling the shipment line that is on hold.
OrganizationName String The name of the organization responsible for handling the shipment line.
ServiceLevelCode String The code identifying the service level for the shipping method used for the shipment line placed on hold.
ToRequestedDate Datetime The end date of the requested delivery date range for the shipment line placed on hold.
ToScheduledShipDate Datetime The end date of the scheduled shipping date range for the shipment line placed on hold.
TransactionId Long The unique identifier for the transaction associated with the shipment line hold.
TransportationShipment String The identifier for the planned shipment related to the shipment line on hold.

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