Collected Lookup Values

The Collected Lookup Values view object that extracts the definition of collected lookup value.

Data Store Key : FscmTopModelAM.ScmExtractAM.DooBiccExtractAM.SrLookupValuesExtractPVO

Primary Keys : SrLookupValueTranslationLookupType, SrLookupValuesBaseLookupCode, SrLookupValueTranslationLanguage, SrLookupValueTranslationLookupCode, SrLookupValuesBaseLookupType, SrLookupValueTranslationSourceLang

Initial Extract Date : SrLookupValueTranslationCreationDate

Incremental Extract Date : SrLookupValuesBaseLastUpdateDate

Attributes

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

Name Description
SrLookupValueTranslationCreatedBy User who created the translated collected lookup value row.
SrLookupValueTranslationCreationDate Date when the translated collected lookup value was created.
SrLookupValueTranslationDescription Description of the lookup value.
SrLookupValueTranslationLanguage Code that identifies the language into which the contents of the translatable columns are translated.
SrLookupValueTranslationLastUpdateDate Date when the translated collected lookup value row was last updated.
SrLookupValueTranslationLastUpdateLogin Session login associated with the user who most recently updated the translated collected lookup value row.
SrLookupValueTranslationLastUpdatedBy User who most recently updated the translated collected lookup value row.
SrLookupValueTranslationLookupCode Value that identifies the code of the lookup value.
SrLookupValueTranslationLookupType Code that identifies the type of the lookup.
SrLookupValueTranslationMeaning Meaning of the lookup value.
SrLookupValueTranslationRefreshNumber Number of refresh for the translated collected lookup value row. It's populated by the collection program.
SrLookupValueTranslationSourceLang Code that identifies the language in which the contents of the translatable columns were originally created.
SrLookupValuesBaseCreatedBy User who created the collected lookup value row.
SrLookupValuesBaseCreationDate Date when the collected lookup value row was created.
SrLookupValuesBaseEnabledFlag Indicates whether the lookup value is enabled. A list of accepted values is defined in the lookup type YES_NO.
SrLookupValuesBaseEndDateActive Date at the end of the date range within which the lookup value is effective.
SrLookupValuesBaseLastUpdateDate Date when the collected lookup value row was last updated.
SrLookupValuesBaseLastUpdateLogin Session login associated with the user who most recently updated the collected lookup value row.
SrLookupValuesBaseLastUpdatedBy User who most recently updated the collected lookup value row.
SrLookupValuesBaseLookupCode Value that identifies the code of the lookup value.
SrLookupValuesBaseLookupType Code that identifies the type of the lookup.
SrLookupValuesBaseRefreshNumber Number of refresh for the collected lookup value row. It's populated by the collection program.
SrLookupValuesBaseStartDateActive Date at the beginning of the date range within which the lookup value is effective.