AM
AMForecastStaging
The table with results when generating forecasts on the Generate Forecast (AM502000) form (corresponding to the GenerateForecastProcess graph).
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
BeginDate | datetime | Begin Date | - | |
Description:No description available | ||||
BranchID | int | Branch | - | |
Description:No description available | ||||
ChangeUnitsNonexistent in DB | decimal? | Change in Units | - | |
Description:No description available | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | - | ||
Description:No description available | ||||
CustomerID | int | Customer | ||
Description:No description available | ||||
CustomerID2Nonexistent in DB | int? | Customer | Customer | |
Description:No description available | ||||
CustomerLocationID | int | Location | Location | |
Description:No description available | ||||
Dependent | bit | Dependent | - | |
Description:No description available | ||||
EndDate | datetime | End Date | - | |
Description:No description available | ||||
ForecastQty | decimal | Quantity | - | |
Description:No description available | ||||
InventoryID | int | Inventory ID | InventoryItem | |
Description:No description available | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
LastModifiedByScreenID | char(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | - | ||
Description:No description available | ||||
LastYearBaseQty | decimal | Last Year Base | - | |
Description:No description available | ||||
LastYearSalesQty | decimal | Last Year | - | |
Description:No description available | ||||
PercentChangeNonexistent in DB | decimal? | Percent Change | - | |
Description:No description available | ||||
Seasonality | nvarchar(10) | Seasonality | - | |
Description:No description available | ||||
SelectedNonexistent in DB | bool? | Selected | - | |
Description:No description available | ||||
SiteID | int | Warehouse | INSite | |
Description:No description available | ||||
SubItemID | int | Subitem | INSubItem | |
Description:No description available | ||||
UOM | nvarchar(6) | UOM | INUnit | |
Description:No description available | ||||
UserID | uniqueidentifier | - | ||
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||