Hold Instances

The Hold Instances view object that extracts hold instance details from the sales orders, such as hold code, apply date, release reason and comments, and so on.

Data Store Key : FscmTopModelAM.ScmExtractAM.DooBiccExtractAM.HoldInstanceExtractPVO

Primary Keys : HoldInstanceHoldInstanceId

Initial Extract Date : HoldInstanceCreationDate

Incremental Extract Date : HoldInstanceLastUpdateDate

Attributes

This table provides the list of exposed attributes and their descriptions.

Name	Description
HoldInstanceActiveFlag	Indicates whether the hold is active on a transaction. A list of accepted values is defined in the lookup type YES_NO.
HoldInstanceApplyDate	Date when the hold was applied.
HoldInstanceApplySystem	System that requested to apply the hold.
HoldInstanceApplyUserId	User who requested to apply the hold.
HoldInstanceCreatedBy	User who created the hold instance row.
HoldInstanceCreationDate	Date when the hold instance row was created.
HoldInstanceDeletedFlag	Indicates whether the hold was deleted. A list of accepted values is defined in the lookup type YES_NO.
HoldInstanceHoldCodeId	Value that identifies the applied hold code. This is a foreign key to the Hold Codes view object.
HoldInstanceHoldComments	Comments that the user added when applying the hold.
HoldInstanceHoldInstanceId	Value that uniquely identifies the hold instance row. This is the primary key of the Hold Instances view object.
HoldInstanceHoldReleaseComments	Comments that user added when releasing the hold.
HoldInstanceHoldReleaseReasonCode	Code that identifies the reason to release the hold. A list of accepted values is defined in the lookup type DOO_HLD_RELEASE_REASON.
HoldInstanceHoldRunningTaskFlag	Indicates whether the in-process tasks will be held. A list of accepted values is defined in the lookup type YES_NO.
HoldInstanceLastUpdateDate	Date when the hold instance row was last updated.
HoldInstanceLastUpdateLogin	Session login associated to the user who most recently updated the hold instance row.
HoldInstanceLastUpdatedBy	User who most recently updated the hold instance row.
HoldInstanceObjectVersionNumber	Number of times the hold instance row has been updated.
HoldInstanceReleaseDate	Date when the hold was released.
HoldInstanceReleaseUserId	User who requested to release the hold.
HoldInstanceSourceLineId	Value that identifies the transaction line from the source system.
HoldInstanceSourceOrderId	Value that uniquely identifies the transaction from the source system.
HoldInstanceSourceOrderRevision	Revision number of the source order.
HoldInstanceSourceOrderSystem	Code that identifies the source system that created the source order.
HoldInstanceSourceRequestId	Value that identifies the request from the source system.
HoldInstanceTransactionEntityId1	Value that identifies the transaction entity that has a hold sent to the fulfillment system.
HoldInstanceTransactionEntityName1	Name of the transaction entity.