CollaborationOrderForecasts
CollaborationOrderForecasts
Columns
| Name | Type | Description |
| CollaborationOrderForecastId [KEY] | Long | Value that uniquely identifies the collaboration order forecast. |
| CorrelationCode | String | Abbreviation that identifies the orchestration process instance. |
| 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. |
| SupplyPlanVersion | Int | Version of the supply plan that was used to generate the collaboration order forecast. |
| 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. |
| 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. |
| CollaborationSourceId | Long | Value that uniquely identifies the collaboration plan. |
| CollaborationPlanId | Long | Value that uniquely identifies the collaboration plan scenario. |
| CollaborationPlanName | String | Name of the collaboration plan. |
| PlanningCycleStartDate | Date | Date when the collaboration planning cycle begins. |
| PlanningCycleEndDate | Date | Date when the collaboration planning cycle ends. |
| ShipFromSupplierId | Long | Value that uniquely identifies the supplier who ships the item. It's a primary key that the application generates when it creates the supplier. |
| ShipFromSupplierName | String | Name of the supplier that ships the item. |
| ShipFromSupplierNumber | String | Number that identifies the supplier that ships the item. |
| ShipFromSupplierDUNS | String | Data universal numbering system of the supplier who ships the item. |
| ShipFromSupplierAlternateName | String | Alternate name of the supplier that ships the item. |
| ShipFromSupplierSiteId | Long | Value that uniquely identifies the supplier site in the relationship. This supplier site sends the shipment. It's a primary key that the application generates when it creates the supplier site. |
| ShipFromSupplierSiteName | String | Name of the supplier site that ships the item. |
| ProcurementBUId | Long | Value that uniquely identifies the business unit. |
| ProcurementBUName | String | Name of the business unit. The application assigns the supplier to this business unit. |
| ShipToOrganizationId | String | Value that uniquely identifies the organization in the collaboration order forecast. This organization receives the shipment. It's a primary key that the application generates when it creates an organization. |
| ShipToOrganizationCode | String | Abbreviation that identifies the organization that receives the item. |
| ShipToOrganizationName | String | Name of the organization that receives the item. |
| ShipToSupplierId | Long | Value that uniquely identifies the supplier who receives the item. It's a primary key that the application generates when it creates the supplier. |
| ShipToSupplierName | String | Name of the supplier that receives the item. |
| ShipToSupplierSiteId | Long | Value that uniquely identifies the supplier site in the collaboration order forecast. This supplier site sends the shipment. It's a primary key that the application generates when it creates the supplier site. |
| ShipToSupplierSiteName | String | Name of the supplier site in the collaboration order forecast that receives the item. |
| ShipToCustomerId | Long | Value that uniquely identifies the customer who will receive the item. It's a primary key that the application creates when it creates the customer. |
| ShipToCustomerName | String | Name of the customer that receives the item. |
| ShipToCustomerSiteId | Long | Value that uniquely identifies the customer site who will receive the item. It's a primary key that the application creates when it creates the customer site. |
| ShipToCustomerSiteName | String | Name of the customer site that received the item. |
| InventoryItemId | String | Value that uniquely identifies the inventory item in the relationship candidate. |
| ItemNumber | String | Number that identifies the item. |
| ItemDescription | String | Description of the item. |
| ItemCategory | String | Category that the application assigns to the item from the default planning catalog. |
| UOMCode | String | Abbreviation that identifies the unit of measure for the item. |
| UnitOfMeasure | String | Unit of measure for the item. |
| SupplierItemNumber | String | Number that identifies the item referred to by the supplier. |
| ManufacturerName | String | Name of the manufacturer. |
| ManufacturerPartNumber | String | Number that identifies the item at the manufacturer. |
| ForecastTotalForecastHorizonQuantity | Double | Sum of the forecast quantities over the forecast horizon for a collaboration order forecast. |
| ForecastTotalCommitHorizonQuantity | Double | Sum of the forecast quantities over the commit horizon for a collaboration order forecast. |
| CommitTotalQuantity | Double | Sum of the commit quantities over the commit horizon for a collaboration order forecast. |
| OnHandQuantity | Double | Quantity of the on-hand inventory for the collaboration order forecast item. |
| SupplierOnHandQuantity | Double | Quantity of the supplier's on-hand inventory for the collaboration order forecast item. |
| SupplierOnHandPublishedDate | Datetime | Date when the supplier on-hand quantity was published. |
| SupplierOnHandPublishedByUserName | String | User who most recently published the supplier on-hand quantity. |
| PublishedDate | Datetime | Date when the collaboration order forecast was published. |
| PublishedByPersonId | Long | Value that uniquely identifies the most recent user to publish the collaboration order forecast. |
| PublishedByUserName | String | User who most recently published the collaboration order forecast. |
| OnHandPublishedDate | Datetime | Date when the on-hand quantity was published. |
| OnHandPublishedByUserName | String | User who most recently published the on-hand quantity. |
| CommitDate | Datetime | Date when the supply was committed against the collaboration order forecast. |
| CommitDueDate | Datetime | Date when the supply commits are due for the collaboration order forecast. |
| Status | String | Value that indicates the current state of the collaboration order forecast. A list of accepted values is defined in the lookup type ORA_VCS_FORECAST_PROCESS_STATU. Review and update the values for this attribute using the Setup and Maintenance work area, and the Manage Supply Chain Collaboration Lookups task. |
| StatusCode | String | Abbreviation that identifies the current state of the collaboration order forecast. A list of accepted values is defined in the lookup type ORA_VCS_FORECAST_PROCESS_STATU. Review and update the values for this attribute using the Setup and Maintenance work area, and the Manage Supply Chain Collaboration Lookups task. |
| CollaborationCycleVersion | Int | Version of the collaboration planning cycle. |
| CreatedByPersonId | Long | Value that uniquely identifies the person that created the collaboration order forecast. |
| CreatedBy | String | User who created the collaboration order forecast. |
| CreationDate | Datetime | Date and time when the user created the collaboration order forecast. |
| LastUpdatedBy | String | Login of the user who most recently updated the collaboration order forecast. |
| LastUpdateDate | Datetime | Date and time when the user most recently updated the collaboration order forecast. |
| B2BOnlyFlag | Bool | Contains one of the following values: true or false. If true, then the collaboration order forecast was published to the supplier using only B2B messaging. If false, then B2B messaging wasn't the only method to publish the collaboration order forecast. This attribute doesn't have a default value. |
| DropShipFlag | Bool | Contains one of the following values: true or false. If true, then the collaboration order forecast data is for a drop ship relationship. If false, then the collaboration order forecast data isn't for a drop ship relationship. This attribute doesn't have a default value. |
| 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 |