Historical Demand Measures

The Historical Demand Measures view object contains information on demand collaboration historical demand measures quantities.

Data Store Key : FscmTopModelAM.ScmExtractAM.VcsDemandBiccExtractAM.VcsHistDemandMeasuresExtractPVO

Primary Keys : DCHistDemandMeasuresPEOMeasureDetailsId

Initial Extract Date : DCHistDemandMeasuresPEOCreationDate

Incremental Extract Date : DCHistDemandMeasuresPEOLastUpdateDate

Attributes

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

Name Description
DCHistDemandMeasuresPEOCreatedBy User who created the measure detail.
DCHistDemandMeasuresPEOCreationDate Date and time when the measure detail record was created.
DCHistDemandMeasuresPEOCurrentCycleFlag Contains one of the following values: Y or N. If Y, then the measure quantities are in the current planning cycle. If N, then the measure quantities have been expired and are in the previous planning cycle. This attribute doesn't have a default value.
DCHistDemandMeasuresPEOIdentityId Value that uniquely identifies the demand collaboration identity.
DCHistDemandMeasuresPEOLastUpdateDate Date and time when the measure detail was last updated.
DCHistDemandMeasuresPEOLastUpdatedBy User who last updated the measure detail.
DCHistDemandMeasuresPEOMeasureDate Date on the measure.
DCHistDemandMeasuresPEOMeasureDetailsId Value that uniquely identifies the measure detail.
DCHistDemandMeasuresPEOMeasureTypeCode Abbreviation that identifies the type of measure used for collaboration.
DCHistDemandMeasuresPEOObjectVersionNumber Number of times the object row has been updated. This attribute is used to implement optimistic locking. This number is incremented every time the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was last queried.
DCHistDemandMeasuresPEOPublishByUsername Name of the user who published the customer demand measure data.
DCHistDemandMeasuresPEOPublishDate Date when the customer demand measure was published.
DCHistDemandMeasuresPEOPublishSourceCode Abbreviation that identifies the publish source that populated measure data in the interface tables.
DCHistDemandMeasuresPEOQuantity Quantity for a specified date on the measure.