ODBC Driver for Oracle Fusion Cloud SCM

Build 24.0.9060

CollaborationOrderForecasts

The Collaboration Order Forecasts resource gets the current planning cycle order forecasts that are published for supplier collaboration. You can use this resource to respond to collaboration order forecasts by providing supply commits.

Columns

Name Type Description
CollaborationOrderForecastId [KEY] Long CollaborationOrderForecastId of CollaborationOrderForecasts
CorrelationCode String CorrelationCode of CollaborationOrderForecasts
SupplyPlanName String SupplyPlanName of CollaborationOrderForecasts
SupplyPlanDescription String SupplyPlanDescription of CollaborationOrderForecasts
SupplyPlanVersion Int SupplyPlanVersion of CollaborationOrderForecasts
SourceSystemCode String SourceSystemCode of CollaborationOrderForecasts
SourceSystem String SourceSystem of CollaborationOrderForecasts
CollaborationSourceId Long CollaborationSourceId of CollaborationOrderForecasts
CollaborationPlanId Long CollaborationPlanId of CollaborationOrderForecasts
CollaborationPlanName String CollaborationPlanName of CollaborationOrderForecasts
PlanningCycleStartDate Date PlanningCycleStartDate of CollaborationOrderForecasts
PlanningCycleEndDate Date PlanningCycleEndDate of CollaborationOrderForecasts
ShipFromSupplierId Long ShipFromSupplierId of CollaborationOrderForecasts
ShipFromSupplierName String ShipFromSupplierName of CollaborationOrderForecasts
ShipFromSupplierNumber String ShipFromSupplierNumber of CollaborationOrderForecasts
ShipFromSupplierDUNS String ShipFromSupplierDUNS of CollaborationOrderForecasts
ShipFromSupplierAlternateName String ShipFromSupplierAlternateName of CollaborationOrderForecasts
ShipFromSupplierSiteId Long ShipFromSupplierSiteId of CollaborationOrderForecasts
ShipFromSupplierSiteName String ShipFromSupplierSiteName of CollaborationOrderForecasts
ProcurementBUId Long ProcurementBUId of CollaborationOrderForecasts
ProcurementBUName String ProcurementBUName of CollaborationOrderForecasts
ShipToOrganizationId String ShipToOrganizationId of CollaborationOrderForecasts
ShipToOrganizationCode String ShipToOrganizationCode of CollaborationOrderForecasts
ShipToOrganizationName String ShipToOrganizationName of CollaborationOrderForecasts
ShipToSupplierId Long ShipToSupplierId of CollaborationOrderForecasts
ShipToSupplierName String ShipToSupplierName of CollaborationOrderForecasts
ShipToSupplierSiteId Long ShipToSupplierSiteId of CollaborationOrderForecasts
ShipToSupplierSiteName String ShipToSupplierSiteName of CollaborationOrderForecasts
ShipToCustomerId Long ShipToCustomerId of CollaborationOrderForecasts
ShipToCustomerName String ShipToCustomerName of CollaborationOrderForecasts
ShipToCustomerSiteId Long ShipToCustomerSiteId of CollaborationOrderForecasts
ShipToCustomerSiteName String ShipToCustomerSiteName of CollaborationOrderForecasts
InventoryItemId String InventoryItemId of CollaborationOrderForecasts
ItemNumber String ItemNumber of CollaborationOrderForecasts
ItemDescription String ItemDescription of CollaborationOrderForecasts
ItemCategory String ItemCategory of CollaborationOrderForecasts
UOMCode String UOMCode of CollaborationOrderForecasts
UnitOfMeasure String UnitOfMeasure of CollaborationOrderForecasts
SupplierItemNumber String SupplierItemNumber of CollaborationOrderForecasts
ManufacturerName String ManufacturerName of CollaborationOrderForecasts
ManufacturerPartNumber String ManufacturerPartNumber of CollaborationOrderForecasts
ForecastTotalForecastHorizonQuantity Decimal ForecastTotalForecastHorizonQuantity of CollaborationOrderForecasts
ForecastTotalCommitHorizonQuantity Decimal ForecastTotalCommitHorizonQuantity of CollaborationOrderForecasts
CommitTotalQuantity Decimal CommitTotalQuantity of CollaborationOrderForecasts
OnHandQuantity Decimal OnHandQuantity of CollaborationOrderForecasts
SupplierOnHandQuantity Decimal SupplierOnHandQuantity of CollaborationOrderForecasts
SupplierOnHandPublishedDate Datetime SupplierOnHandPublishedDate of CollaborationOrderForecasts
SupplierOnHandPublishedByUserName String SupplierOnHandPublishedByUserName of CollaborationOrderForecasts
PublishedDate Datetime PublishedDate of CollaborationOrderForecasts
PublishedByPersonId Long PublishedByPersonId of CollaborationOrderForecasts
PublishedByUserName String PublishedByUserName of CollaborationOrderForecasts
OnHandPublishedDate Datetime OnHandPublishedDate of CollaborationOrderForecasts
OnHandPublishedByUserName String OnHandPublishedByUserName of CollaborationOrderForecasts
CommitDate Datetime CommitDate of CollaborationOrderForecasts
CommitDueDate Datetime CommitDueDate of CollaborationOrderForecasts
Status String Status of CollaborationOrderForecasts
StatusCode String StatusCode of CollaborationOrderForecasts
CollaborationCycleVersion Int CollaborationCycleVersion of CollaborationOrderForecasts
CreatedByPersonId Long CreatedByPersonId of CollaborationOrderForecasts
CreatedBy String CreatedBy of CollaborationOrderForecasts
CreationDate Datetime CreationDate of CollaborationOrderForecasts
LastUpdatedBy String LastUpdatedBy of CollaborationOrderForecasts
LastUpdateDate Datetime LastUpdateDate of CollaborationOrderForecasts
B2BOnlyFlag Bool B2BOnlyFlag of CollaborationOrderForecasts
DropShipFlag Bool DropShipFlag of CollaborationOrderForecasts
NoteToSupplier String NoteToSupplier of CollaborationOrderForecasts
NoteToPlanner String NoteToPlanner of CollaborationOrderForecasts
Finder String Finder of CollaborationOrderForecasts

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060