JDBC Driver for Oracle SCM

Build 22.0.8462

CollaborationOrderForecastHistoryaggregatedQuantities

The Aggregated Quantities resource gets the aggregated forecast quantities and commit quantities associated with the historical planning cycles of collaboration order forecasts in weekly, monthly, or quarterly increments.

Columns

Name Type Description
CollaborationOrderForecastHistoryCollaborationOrderForecastEntryId String Value that uniquely identifies the request.
CollaborationOrderForecastEntryId String Value that uniquely identifies the historical collaboration order forecast entry.
CollaborationOrderForecastId String Value that uniquely identifies the collaboration order forecast.
EntryDetailId String Value that uniquely identifies the historical entry detail.
BucketId String Value that uniquely identifies the time bucket.
BucketAggregationCode String Abbreviation that identifies the bucket aggregation type for the aggregated 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.
BucketStartDate Date Date when the time bucket starts.
BucketEndDate Date Date when the time bucket ends.
ForecastQuantity String Most recent forecast quantity of the aggregation type.
CommitQuantity String Most recent commit quantity of the aggregation type.
MaximumCommitVersion Int Version of the maximum commit when the exception occurred for the aggregation type.
MaximumForecastVersion Int Version of the maximum forecast when the exception occurred for the aggregation type.
CommitMismatchFactor String Identifies the amount of difference between current commit and current forecast quantities when the current commit is less than current forecast for the bucket aggregation level.
ForecastChangeFactor String Measures the amount of difference between current forecast and the previous forecast quantities for the bucket aggregation level.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462