SalesOrdersForOrderHublinesholds
Manages active and released holds on sales order lines, enabling better control of order processing.
Columns
| Name | Type | Description |
| SalesOrdersForOrderHubHeaderId [KEY] | Long | Unique identifier for the sales order header, linking the hold information to the parent order in Oracle Fusion Order Management, ensuring accurate tracking of holds at the order level. |
| LinesFulfillLineId [KEY] | Long | Identifier for the fulfillment line associated with the hold, allowing detailed tracking of holds on specific lines within the order. |
| HoldInstanceId [KEY] | Long | Unique identifier for the specific hold instance, allowing for individual tracking of each hold applied to the sales order. |
| HoldName | String | Name or description of the hold applied to the sales order, providing context for the reason behind the hold (for example, payment issues, inventory issues). |
| HoldCode | String | Code representing the type or category of the hold, used to categorize different types of holds in Oracle Fusion Order Management. |
| HoldComments | String | Additional comments or notes related to the hold, providing further details about the reason for the hold or any special instructions. |
| ApplyUser | String | User who applied the hold to the sales order, enabling audit tracking and accountability for hold actions. |
| ApplyDate | Datetime | Date and time when the hold was applied to the sales order, ensuring that the timeline of the order and holds is accurately tracked. |
| HoldReleaseComments | String | Comments related to the release of the hold, providing details about why and how the hold was removed from the order. |
| HoldReleaseReasonCode | String | Code representing the reason for releasing the hold, helping to categorize why the hold was lifted. |
| HoldReleaseReason | String | Description of the reason why the hold was released, explaining the actions taken to resolve the issue that caused the hold. |
| ReleaseUser | String | User who released the hold, enabling traceability of hold release actions in Oracle Fusion Order Management. |
| ReleaseDate | Datetime | Date and time when the hold was released from the sales order, ensuring accurate tracking of hold lifecycles. |
| ApplySystem | String | System from which the hold was applied, providing insight into the origin of the hold in cases of integration with external systems. |
| ActiveFlag | Bool | Indicates whether the hold is currently active. If true, the hold is still in place. If false, the hold has been released. |
| SourceRequestId | String | Identifier from the source system that links to the request that initiated the hold, helping to maintain data consistency across systems. |
| Finder | String | Method or tool used to search for specific hold records, enabling efficient retrieval of hold information in Oracle Fusion Order Management. |
| FromDate | Date | Start date when the hold is applicable, marking the beginning of the hold period for the sales order. |
| HeaderId | Long | Unique identifier for the order header, used to link the hold details to the overall sales order, ensuring consistency in order processing. |
| OrderKey | String | Unique key for referencing the sales order associated with the hold, providing an essential linkage for all related transactions. |
| OrderNumber | String | Unique order number assigned to the sales order, used for referencing the order in reporting, invoicing, and fulfillment processes. |
| SourceTransactionNumber | String | Transaction number from the source system, linking the hold information to its originating transaction and ensuring consistency during integration. |
| SourceTransactionSystem | String | Source system from which the transaction originated, providing context for integration with external platforms. |
| ToDate | Date | End date when the hold is no longer applicable, marking the expiration of the hold period and ensuring time-bound data management. |