ODBC Driver for Oracle Fusion Cloud SCM

Build 25.0.9434

SalesOrdersForOrderHubholds

Tracks active and released holds on order lines, providing visibility into order processing constraints.

Columns

Name Type Description
SalesOrdersForOrderHubHeaderId [KEY] Long Unique identifier for the sales order header, linking the hold details to the specific sales order.
HoldInstanceId [KEY] Long Unique identifier for each instance of the hold applied to the sales order, used for tracking and managing holds.
HoldName String The name assigned to the hold, used to identify the specific type or reason for the hold on the sales order.
HoldCode String Code representing the hold applied to the sales order, used for classification and to quickly identify the type of hold.
HoldComments String Additional comments or notes related to the hold, providing context or explanations for why the hold was applied.
ApplyUser String The name or identifier of the person who applied the hold to the sales order, used for accountability and auditing purposes.
ApplyDate Datetime The date and time when the hold was applied to the sales order, marking when the action was taken.
HoldReleaseComments String Comments or notes explaining the release of the hold, providing context or reason for lifting the hold on the order.
HoldReleaseReasonCode String Code representing the reason for releasing the hold, helping to classify and track the circumstances under which the hold was lifted.
HoldReleaseReason String Description of the reason for releasing the hold, providing further clarification of the action taken.
ReleaseUser String The name or identifier of the person who released the hold, ensuring accountability for the release action.
ReleaseDate Datetime The date and time when the hold was released, marking the point when the sales order was cleared from the hold status.
ApplySystem String The system used to apply the hold to the sales order, providing context for where the action was initiated.
ActiveFlag Bool Flag indicating whether the hold is currently active. A value of 'true' means the hold is still in effect, while 'false' means it has been released.
SourceRequestId String Unique identifier for the request that initiated the hold, used to trace back to the original request or system action.
Finder String A tool or method used to search and locate specific holds on sales orders, typically employed for filtering or identifying holds within the system.
FromDate Date The start date for when the hold is valid or applicable, marking the beginning of the period during which the hold is enforced.
HeaderId Long Unique identifier for the sales order header, ensuring that the hold is linked to the correct sales order.
OrderKey String A unique key used to reference and track the sales order within the system, helping to associate the order with the applied hold.
OrderNumber String The order number associated with the sales order, used for tracking and reference in relation to the applied hold.
SourceTransactionNumber String The number associated with the source transaction that initiated the sales order hold, linking it to the original transaction.
SourceTransactionSystem String The system from which the source transaction originated, providing context about the origin of the hold.
ToDate Date The end date for when the hold is valid or applicable, marking the end of the period during which the hold is in effect.

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