External Supply Forecast Reference Measures

The External Supply Forecast Reference Measures view object contains information on the current cycle reference measures from Oracle Supply Planning product data model.

Data Store Key : FscmTopModelAM.ScmExtractAM.VcsBiccExtractAM.VcsExtSupplyForecastReferenceMeasureExtractPVO

Primary Keys : VcsExtSupplyForecastReferenceMeasurePEOReferenceDetailId

Initial Extract Date :

Incremental Extract Date : VcsExtSupplyForecastReferenceMeasurePEOLastUpdateDate

Attributes

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

Name	Description
VcsExtSupplyForecastReferenceMeasurePEOCollaborationOrderForecastEntryId	Value that uniquely identifies the collaboration order forecast entry.
VcsExtSupplyForecastReferenceMeasurePEOCollaborationSourceId	Value that uniquely identifies the source of the collaboration plan.
VcsExtSupplyForecastReferenceMeasurePEOCreatedBy	User who created the reference measure quantity.
VcsExtSupplyForecastReferenceMeasurePEOCreationDate	Date and time when the reference measure quantity was created.
VcsExtSupplyForecastReferenceMeasurePEOLastUpdateDate	Date and time when the reference measure was last updated.
VcsExtSupplyForecastReferenceMeasurePEOLastUpdatedBy	User who most recently updated the reference measure.
VcsExtSupplyForecastReferenceMeasurePEOObjectVersionNumber	Number of times the object row has been updated. This attribute is used to implement optimistic locking. This number is incremented every time that 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 queried.
VcsExtSupplyForecastReferenceMeasurePEOPublisherOrderType	Code that identifies the publisher order type. Values include InTransitShipment, PlannedOrder, PurchaseOrder, ReceivedShipment, and Requisition.
VcsExtSupplyForecastReferenceMeasurePEOReceivedDate	Date and time when the historical reference measure entry was received from Oracle Supply Planning Cloud or uploaded from a spreadsheet.
VcsExtSupplyForecastReferenceMeasurePEORefMeasureBucketEndDate	Date when the time bucket ends.
VcsExtSupplyForecastReferenceMeasurePEORefMeasureBucketId	Value that uniquely identifies the time bucket.
VcsExtSupplyForecastReferenceMeasurePEORefMeasureBucketStartDate	Date when the time bucket starts.
VcsExtSupplyForecastReferenceMeasurePEORefMeasureBucketType	Code that identifies the bucket aggregation type for the reference measure quantity. A list of accepted values is defined in the lookup type ORA_VCS_BUCKET_AGGR_LEVEL. Review and update the values for this attribute using the Setup and Maintenance work area, and the Manage Supply Chain Collaboration Lookups task.
VcsExtSupplyForecastReferenceMeasurePEORefMeasurePublishedByPartyCode	Code that identifies the type of user who performed the publish action. A list of accepted values is defined in the lookup type ORA_VCS_PARTY_ORIGIN. Review and update the values for this attribute using the Setup and Maintenance work area, and the Manage Supply Chain Collaboration Lookups task.
VcsExtSupplyForecastReferenceMeasurePEORefMeasurePublishedByPersonId	User who most recently published the reference measure quantity.
VcsExtSupplyForecastReferenceMeasurePEORefMeasurePublishedDate	Date and time when the reference measure quantity was published.
VcsExtSupplyForecastReferenceMeasurePEORefMeasureQuantity	Value that identifies the quantity of the reference measure for the item in the reference measure unit of measure.
VcsExtSupplyForecastReferenceMeasurePEORefMeasureQuantityUOM	Code that identifies the unit of measure of a reference measure quantity.
VcsExtSupplyForecastReferenceMeasurePEOReferenceDetailId	Value that uniquely identifies the reference measure details record.
VcsExtSupplyForecastReferenceMeasurePEOReferenceHeaderId	Value that uniquely identifies the header of the reference measure quantity.
VcsExtSupplyForecastReferenceMeasurePEOReferenceHeaderNumber	Value that identifies the header number of the reference measure quantity.
VcsExtSupplyForecastReferenceMeasurePEOReferenceLineId	Value that uniquely identifies the line of the reference measure quantity.
VcsExtSupplyForecastReferenceMeasurePEOReferenceLineLocationId	Value that uniquely identifies the line location of the reference measure quantity.
VcsExtSupplyForecastReferenceMeasurePEOReferenceLineLocationNumber	Value that identifies the line location number of the reference measure quantity.
VcsExtSupplyForecastReferenceMeasurePEOReferenceLineNumber	Value that identifies the line number of the reference measure quantity.