CollaborationOrderForecastsexceptionQuantities
CollaborationOrderForecastsexceptionQuantities
Columns
| Name | Type | Description |
| CollaborationOrderForecastsCollaborationOrderForecastId [KEY] | Long | Value that uniquely identifies the order forecast. |
| CollaborationOrderForecastId | Long | Value that uniquely identifies the collaboration order forecast. |
| ExceptionId [KEY] | Long | Value that uniquely identifies the collaboration order forecast exception. |
| BucketId [KEY] | Long | Value that uniquely identifies the time bucket. |
| ExceptionTypeCode | String | Abbreviation that identifies the exception type. Values include COMMIT_MISMATCH or FORECAST_DEVIATION. |
| BucketAggregationCode | String | Abbreviation that identifies the bucket aggregation type for the exception 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. |
| ExceptionFactor | Double | Value that identifies the amount of change based on the exception type. |
| PrimaryExceptionVariable | Double | Value that's used in the calculation of the exception factor. |
| SecondaryExceptionVariable | Double | Value that's used in the calculation of the exception factor. |
| 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. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| Finder | String | finder |