CollaborationOrderForecastRequests
CollaborationOrderForecastRequests
Columns
| Name | Type | Description |
| CollaborationOrderForecastRequestId [KEY] | Long | Value that uniquely identifies the request for the collaboration order forecast. |
| StatusCode | String | Abbreviation that identifies the current state of the collaboration order forecast. Values included ERROR, SUBMITTED, PROCESSING, PUBLISHED, and PUBLISHED_B2B_ONLY. |
| SupplyPlanName | String | Name of the supply plan that was used to generate the collaboration order forecast. |
| SupplyPlanDescription | String | Description of the supply plan that was used to generate the collaboration order forecast. |
| ProcurementBUName | String | Name of the business unit. The application assigns the supplier to this business unit. |
| ShipFromSupplierName | String | Name of the supplier that ships the item. |
| ShipFromSupplierSiteName | String | Name of the supplier site that ships the item. |
| ShipToOrganizationCode | String | Name of the organization that receives the item. |
| ShipToCustomerName | String | Name of the customer that receives the item. |
| ShipToCustomerSiteName | String | Name of the customer site that received the item. |
| ShipToCustomerSiteNumber | String | Number that identifies the customer site that received the item. |
| ItemNumber | String | Number that identifies the item. |
| UnitOfMeasure | String | Unit of measure for the item. |
| UOMCode | String | Abbreviation that identifies the unit of measure for the item. |
| SourceSystem | String | Value that indicates the product data model source system for the supply plan that's available for supply chain collaboration. Values include External or Oracle. |
| SourceSystemCode | String | Abbreviation that indicates the product data model source system for the supply plan that's available for supply chain collaboration. Values include ORA_VCS_SRCSYSTEM_EXTERNAL or ORA_VCS_SRCSYSTEM_ORACLE. |
| CreatedBy | String | User who created the collaboration order forecast. |
| CreationDate | Datetime | Date and time when the user created the collaboration order forecast. |
| ProcessId | Long | Value that uniquely identifies the scheduled process that was used to decompose the request. |
| NoteToSupplier | String | Note provided by the collaboration planner to the supplier. |
| NoteToPlanner | String | Note provided by the supplier to the collaboration planner. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| Finder | String | finder |