CollaborationOrderForecastsforecastQuantities
CollaborationOrderForecastsforecastQuantities
Columns
| Name | Type | Description |
| CollaborationOrderForecastsCollaborationOrderForecastId [KEY] | Long | Value that uniquely identifies the order forecast. |
| CollaborationOrderForecastId | Long | Value that uniquely identifies the collaboration order forecast. |
| CorrelationCode | String | Abbreviation that uniquely identifies the orchestration process instance. |
| CollaborationOrderForecastDetailsId [KEY] | Long | Value that uniquely identifies the collaboration order forecast details record. |
| BucketId [KEY] | Long | Value that uniquely identifies the time bucket. |
| BucketStartDate | Date | Date when the time bucket starts. |
| BucketEndDate | Date | Date when the time bucket ends. |
| BucketAggregationCode | String | Abbreviation that identifies the bucket aggregation type for the forecast 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. |
| Quantity | Double | Quantity of the supply forecast. |
| Version | Int | Version of the forecast time bucket for the collaboration order forecast. |
| PublishedByPersonId | Long | Value that uniquely identifies the user who most recently published the forecast quantity. |
| PublishedByUserName | String | User who most recently published the forecast quantity. |
| PublishedDate | Datetime | Date when the forecast quantity was published. |
| PublishSourceCode | String | Abbreviation 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. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| Finder | String | finder |