CollaborationOrderForecastsreferenceQuantities
CollaborationOrderForecastsreferenceQuantities
Columns
| Name | Type | Description |
| CollaborationOrderForecastsCollaborationOrderForecastId [KEY] | Long | Value that uniquely identifies the order forecast. |
| CollaborationOrderForecastId | Long | Value that uniquely identifies the collaboration order forecast. |
| RefercenceDetailsId [KEY] | Long | Value that uniquely identifies the collaboration order forecast reference details record. |
| BucketId | Long | Value that uniquely identifies the time bucket. |
| PublisherOrderTypeCode | String | Abbreviation that identifies the order type of the reference quantity. A list of accepted values is defined in the lookup type ORA_VCS_COLLAB_ORDER_TYPES. 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. |
| Quantity | Double | Quantity of the related order type. |
| DocumentReferenceNumber | String | Value that uniquely identifies the document reference order type. The format is Header(Line)(Location). |
| 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. |
| PublishDate | Datetime | Date when the forecast quantity was published. |
| PublishSourceCode | String | Abbreviation that identifies the type of user who performed the commit. 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 |