Table 1850 "MS - Sales Forecast"
SalesAndInventoryForecast · Microsoft.Inventory.InventoryForecast
Across versions
- BC23-28not present
- BC29-30present
Neighbourhood 1 connected objects and pages
SalesAndInventoryForecast · Microsoft.Inventory.InventoryForecast · BC29-30 · source at ea08af5e · facts from BC29
Properties
| Property | Value |
|---|---|
| DataClassification | CustomerContent |
Fields
Explanation: the field’s ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.
| No. | Name | Type | Explanation | Notes |
|---|---|---|---|---|
| 1 | Item No. | Code[20] | — | TableRelation Table 27 “Item” |
| 2 | Date | Date | — | |
| 3 | Quantity | Decimal | — | |
| 4 | Delta | Decimal | — | |
| 5 | Forecast Data | Option | — | |
| 6 | Variance % | Decimal | — |
Keys
- Key1: Item No., Date
Procedures
PopulateForecastBase(var TempTimeSeriesBuffer: Record "Time Series Buffer" temporary)PopulateForecastResult(var TempTimeSeriesForecast: Record "Time Series Forecast" temporary)NewBaseRecord(ItemNo: Code[20]; NewDate: Date; NewQuantity: Decimal)NewResultRecord(ItemNo: Code[20]; NewDate: Date; NewQuantity: Decimal; NewDelta: Decimal)
Plus 3 local procedures.
Triggers
OnInsert, OnModify
Relations
- Item No.: TableRelation Table 27 “Item”
Ask your agent
Procedure bodies are not stored here (D10). For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: bcatlas_resolve_node(object_type: "table", object_name: "MS - Sales Forecast"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.