CollaborationOrderForecastHistory
The Collaboration Order Forecast History resource gets the historical planning cycle order forecasts that were published for supplier collaboration.
Columns
| Name | Type | Description |
| CollaborationOrderForecastEntryId [KEY] | String | Value that uniquely identifies the historical collaboration order forecast entry. |
| CollaborationOrderForecastId | String | 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. |
| SourceSystemCode | String | Abbreviation that indicates the product data model source system for the supply plan that is 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 is available for supply chain collaboration. Values include External or Oracle. |
| CollaborationSourceId | String | Value that uniquely identifies the collaboration plan. |
| CollaborationPlanId | String | Value that uniquely identifies the collaboration plan scenario. |
| PlanningCycleStartDate | Date | Date when the collaboration planning cycle begins. |
| PlanningCycleEndDate | Date | Date when the collaboration planning cycle ends. |
| ShipFromSupplierId | String | Value that uniquely identifies the supplier who ships the item. It is 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 of the supplier that ships the item. |
| ShipFromSupplierDUNS | String | Data universal numbering system, otherwise known as D-U-N-S of the supplier who ships the item. |
| ShipFromSupplierAlternateName | String | Alternate name of the supplier that ships the item. |
| ShipFromSupplierSiteId | String | Value that uniquely identifies the supplier site in the relationship. This supplier site sends the shipment. It is 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 | String | 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 is 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 | String | Value that uniquely identifies the supplier who receives the item. It is a primary key that the application generates when it creates the supplier. |
| ShipToSupplierName | String | Name of the supplier that receives the item. |
| ShipToSupplierSiteId | String | Value that uniquely identifies the supplier site in the collaboration order forecast. This supplier site sends the shipment. It is a primary key that the application generates when it creates the supplier site. |
| ShipToSupplierSiteName | String | Name of the supplier site in the in the collaboration order forecast that receives the item. |
| ShipToCustomerId | String | Value that uniquely identifies the customer who will receive the item. It is a primary key that the application creates when it creates the customer. |
| ShipToCustomerName | String | Name of the customer that receives the item. |
| ShipToCustomerSiteId | String | Value that uniquely identifies the customer site who will receive the item. It is 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 of the item. |
| ItemDescription | String | Description of the item. |
| UOMCode | String | Abbreviation that identifies the unit of measure for the item. |
| UnitOfMeasure | String | Unit of measure for the item. |
| ForecastTotalForecastHorizonQuantity | String | Sum of the forecast quantities over the forecast horizon for a collaboration order forecast. |
| ForecastTotalCommitHorizonQuantity | String | Sum of the forecast quantities over the commit horizon for a collaboration order forecast. |
| CommitTotalQuantity | String | Sum of the commit quantities over the commit horizon for a collaboration order forecast. |
| PublishedDate | Datetime | Date when the collaboration order forecast was published. |
| PublishedByPersonId | String | 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. |
| 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. |
| CollaborationCycleVersion | Int | Version of the collaboration planning cycle. |
| CreatedByPersonId | String | 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. |
| 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 is not for a drop ship relationship. This attribute does not have a default value. |