CollaborationOrderForecastscommitQuantities
CollaborationOrderForecastscommitQuantities
Columns
| Name | Type | Description |
| CollaborationOrderForecastsCollaborationOrderForecastId [KEY] | Long | Value that uniquely identifies the order forecast. |
| CollaborationOrderForecastId | Long | Value that uniquely identifies the collaboration order forecast. |
| CollaborationOrderForecastDetailsId [KEY] | Long | Value that uniquely identifies the collaboration order forecast details record. |
| BucketId [KEY] | Long | Value that uniquely identifies the time bucket. |
| CorrelationCode | String | Abbreviation that uniquely identifies the orchestration process instance. |
| 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 commit 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 supplier commit. |
| CommitMismatchReasonCode | String | Abbreviation that identifies the reason the supplier couldn't commit to the forecast, thereby creating a mismatch between the request and the response. |
| CommitMismatchReason | String | Reason the supplier couldn't commit to the forecast, thereby creating a mismatch between the request and the response |
| Version | Int | Version of the commit time bucket for the collaboration order forecast. |
| CommittedByPersonId | Long | Value that uniquely identifies the user who committed the commit quantity. |
| CommittedByUserName | String | User who committed the commit quantity. |
| CommitDate | Datetime | Date when the user most recently committed the commit quantity. |
| CommittedByPartyCode | String | Abbreviation that identifies the type of user who performed the commit 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 |