Hold Codes

The Hold Codes view object that extracts the definition of hold codes.

Data Store Key : FscmTopModelAM.ScmExtractAM.DooBiccExtractAM.HoldCodeExtractPVO

Primary Keys : HoldTranslationHoldCodeId, HoldHoldCodeId, HoldTranslationLanguage

Initial Extract Date : HoldCreationDate

Incremental Extract Date : HoldLastUpdateDate

Attributes

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

Name	Description
HoldCreatedBy	User who created the hold code row.
HoldCreationDate	Date when the hold code row was created.
HoldEffectiveEndDate	Date at the end of the date range within which the hold code row is effective.
HoldEffectiveStartDate	Date at the beginning of the date range within which the hold code row is effective.
HoldGeneralHoldFlag	Indicates whether the hold code prevents all services from being performed. A list of accepted values is defined in the lookup type YES_NO. The default value is N.
HoldHoldCode	Code that uniquely identifies the hold.
HoldHoldCodeId	Value that uniquely identifies the hold code row. This is the primary key of the Hold Codes view object.
HoldLastUpdateDate	Date when the hold code row was last updated.
HoldLastUpdateLogin	Session login associated to the user who most recently updated the hold code row.
HoldLastUpdatedBy	User who most recently updated the hold code row.
HoldObjectVersionNumber	Number of times the hold code row has been updated.
HoldOrchestrationApplicationId	Value that identifies the orchestration application associated to the hold code row. This is a foreign key to the DOO_ORCHESTRATION_APPLICATIONS table.
HoldSetId	Value that identifies a set of reference data shared across business units and other entities. Also known as reference data sets.
HoldSystemFlag	Indicates whether the hold code is predefined and can't be updated or deleted. A list of accepted values is defined in the lookup type YES_NO. The default value is N.
HoldTranslationCreatedBy	User who created the translated hold code row.
HoldTranslationCreationDate	Date when the translated hold code row was created.
HoldTranslationHoldCodeId	Value that uniquely identifies the hold code row.
HoldTranslationHoldDescription	Description of the hold.
HoldTranslationHoldName	Name of the hold.
HoldTranslationLanguage	Code that identifies the language into which the contents of the translatable columns are translated.
HoldTranslationLastUpdateDate	Date when the translated hold code row was last updated.
HoldTranslationLastUpdateLogin	Session login associated to the user who most recently updated the translated hold code row.
HoldTranslationLastUpdatedBy	User who most recently updated the translated hold code row.
HoldTranslationObjectVersionNumber	Number of times the translated hold code row has been updated.
HoldTranslationSourceLang	Code that identifies the language in which the contents of the translatable columns were originally created.