Table 2900 "Forecast Item Variant Loc"
Base Application · Microsoft.Manufacturing.Forecast
Across versions
- BC23-27present
- BC285 fields changed
- BC29-30unchanged
Neighbourhood 5 connected objects and pages
Base Application · Microsoft.Manufacturing.Forecast · BC23-30 · source at ea08af5e · facts from BC29
Properties
| Property | Value |
|---|---|
| TableType | Temporary |
| 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 | Entry No. | Integer | — | DataClassification SystemMetadata |
| 2 | No. Δ BC28 | Code[20] | Specifies the number of the involved entry or record, according to the specified number series. | TableRelation Item.“No.” |
| 3 | Description Δ BC28 | Text[100] | Specifies a description of the item. | |
| 4 | Date Filter | Date | — | FlowFilter |
| 5 | Location Filter | Code[10] | — | TableRelation Table 14 “Location”; FlowFilter |
| 6 | Variant Filter | Code[10] | — | TableRelation Table 5401 “Item Variant” (Item Variant); FlowFilter |
| 7 | Production Forecast Name | Code[10] | — | TableRelation Table 99000851 “Production Forecast Name” (Production Forecast Name); FlowFilter |
| 8 | Component Forecast | Boolean | — | FlowFilter |
| 9 | Prod. Forecast Quantity (Base) Δ BC28 | Decimal | — | FlowField: sum(“Production Forecast Entry”.“Forecast Quantity (Base)” where(“Item No.” = field(“No.”), “Production Forecast Name” = field(“Production Forecast Name”), “Forecast Date” = field(“Date Filter”), “Location Code” = field(“Location Filter”), “Component Forecast” = field(“Component Forecast”), “Variant… |
| 10 | Variant Code Δ BC28 | Code[20] | Specifies a variant code of the item. | |
| 11 | Location Code Δ BC28 | Code[10] | Specifies a location code of the item. |
Keys
- Key1: Entry No. (clustered)
Relations
- Location Filter: TableRelation Table 14 “Location”
- Variant Filter: TableRelation Table 5401 “Item Variant”
- Production Forecast Name: TableRelation Table 99000851 “Production Forecast Name”
- Prod. Forecast Quantity (Base): CalcFormula Table 99000852 “Production Forecast Entry”
Pages and codeunits on this table
- Page 2900 “Demand Forecast Variant Matrix” (source table)
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: "Forecast Item Variant Loc"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.