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. |