CollaborationOrderForecasts
Provides access to published order forecasts for supplier collaboration and enables response submissions for supply commitments.
Columns
| Name | Type | Description |
| CollaborationOrderForecastId [KEY] | Long | A unique identifier for the collaboration order forecast. |
| CorrelationCode | String | A code used to correlate related collaboration order forecasts. |
| SupplyPlanName | String | The name of the supply plan associated with this collaboration order forecast. |
| SupplyPlanDescription | String | A description of the supply plan used for the collaboration order forecast. |
| SupplyPlanVersion | Int | The version number of the supply plan used for this forecast. |
| SourceSystemCode | String | A code representing the source system that provided the forecast data. |
| SourceSystem | String | The source system from which the collaboration order forecast originates. |
| CollaborationSourceId | Long | A unique identifier for the collaboration source related to the forecast. |
| CollaborationPlanId | Long | A unique identifier for the collaboration plan associated with the forecast. |
| CollaborationPlanName | String | The name of the collaboration plan linked to the forecast. |
| PlanningCycleStartDate | Date | The start date of the planning cycle for this forecast. |
| PlanningCycleEndDate | Date | The end date of the planning cycle for this forecast. |
| ShipFromSupplierId | Long | A unique identifier for the supplier shipping the item. |
| ShipFromSupplierName | String | The name of the supplier shipping the item. |
| ShipFromSupplierNumber | String | The unique number identifying the supplier shipping the item. |
| ShipFromSupplierDUNS | String | The DUNS number associated with the supplier shipping the item. |
| ShipFromSupplierAlternateName | String | An alternate name for the supplier shipping the item. |
| ShipFromSupplierSiteId | Long | A unique identifier for the supplier site shipping the item. |
| ShipFromSupplierSiteName | String | The name of the supplier site shipping the item. |
| ProcurementBUId | Long | A unique identifier for the procurement business unit responsible for the order. |
| ProcurementBUName | String | The name of the procurement business unit responsible for the order. |
| ShipToOrganizationId | String | A unique identifier for the organization receiving the shipment. |
| ShipToOrganizationCode | String | A code representing the organization receiving the shipment. |
| ShipToOrganizationName | String | The name of the organization receiving the shipment. |
| ShipToSupplierId | Long | A unique identifier for the supplier delivering to the ship-to location. |
| ShipToSupplierName | String | The name of the supplier delivering to the ship-to location. |
| ShipToSupplierSiteId | Long | A unique identifier for the supplier site delivering to the ship-to location. |
| ShipToSupplierSiteName | String | The name of the supplier site delivering to the ship-to location. |
| ShipToCustomerId | Long | A unique identifier for the customer receiving the shipment. |
| ShipToCustomerName | String | The name of the customer receiving the shipment. |
| ShipToCustomerSiteId | Long | A unique identifier for the customer site receiving the shipment. |
| ShipToCustomerSiteName | String | The name of the customer site receiving the shipment. |
| InventoryItemId | String | A unique identifier for the inventory item included in the forecast. |
| ItemNumber | String | A unique identifier for the item in the forecast. |
| ItemDescription | String | A detailed description of the item in the forecast. |
| ItemCategory | String | The category or classification of the item in the forecast. |
| UOMCode | String | A code representing the unit of measure for the item. |
| UnitOfMeasure | String | The unit of measure in which the item is quantified. |
| SupplierItemNumber | String | The supplier's unique identifier for the item. |
| ManufacturerName | String | The name of the manufacturer of the item. |
| ManufacturerPartNumber | String | The manufacturer's part number for the item. |
| ForecastTotalForecastHorizonQuantity | Decimal | The total forecasted quantity for the forecast horizon. |
| ForecastTotalCommitHorizonQuantity | Decimal | The total committed quantity for the commit horizon. |
| CommitTotalQuantity | Decimal | The total quantity committed by the supplier. |
| OnHandQuantity | Decimal | The quantity of the item currently available on hand. |
| SupplierOnHandQuantity | Decimal | The quantity of the item reported by the supplier as on hand. |
| SupplierOnHandPublishedDate | Datetime | The date and time when the supplier's on-hand quantity was published. |
| SupplierOnHandPublishedByUserName | String | The username of the person who published the supplier's on-hand quantity. |
| PublishedDate | Datetime | The date and time when the forecast was published. |
| PublishedByPersonId | Long | A unique identifier for the person who published the forecast. |
| PublishedByUserName | String | The username of the person who published the forecast. |
| OnHandPublishedDate | Datetime | The date and time when the on-hand quantity was published. |
| OnHandPublishedByUserName | String | The username of the person who published the on-hand quantity. |
| CommitDate | Datetime | The date when the commitment was made. |
| CommitDueDate | Datetime | The date by which the committed quantity is expected to be fulfilled. |
| Status | String | The current status of the collaboration order forecast. |
| StatusCode | String | A code representing the current status of the forecast. |
| CollaborationCycleVersion | Int | The version of the collaboration cycle for this forecast. |
| CreatedByPersonId | Long | A unique identifier for the person who created the forecast. |
| CreatedBy | String | The username of the person who created the forecast. |
| CreationDate | Datetime | The date and time when the forecast was created. |
| LastUpdatedBy | String | The username of the person who last updated the forecast. |
| LastUpdateDate | Datetime | The date and time when the forecast was last updated. |
| B2BOnlyFlag | Bool | Indicates whether the forecast is restricted to B2B transactions. |
| DropShipFlag | Bool | Indicates whether the forecast is for a drop-shipment order. |
| NoteToSupplier | String | A note from the collaboration planner to the supplier regarding the forecast. |
| NoteToPlanner | String | A note from the supplier to the collaboration planner regarding the forecast. |
| Finder | String | A system-generated reference used to locate the collaboration order forecast. |