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