---
id: object/table/5821
type: object
title: Table 5821 "Item Statistics Buffer"
summary: Table 5821 "Item Statistics Buffer" in Base Application (Microsoft.Inventory.Analysis). 54 fields. Present since at least BC23, still in BC30, changed in BC24, BC28.
tier: official
language: en
tags:
  - table
  - base application
versions:
  introduced: null
  last_changed: "28"
  deprecated: null
review:
  state: derived
  by: null
  at: null
  flags: []
generated:
  at: "2026-10-11T00:31:51.816Z"
  pipeline: 0.2.0
  prompts: {}
  input_hash: 66add99a6d89d96aab922b15b71e4de8663e78953aa0ee8be2a8861129d35bd1
evidence:
  - kind: code
    url: https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Layers/W1/BaseApp/Inventory/Analysis/ItemStatisticsBuffer.Table.al
    title: src/Layers/W1/BaseApp/Inventory/Analysis/ItemStatisticsBuffer.Table.al (releases/29.x)
    date: null
    commit: ea08af5ef2d6a9b5c5af4a029288abbe2c883220
    t: null
    quote: null
links:
  learn: []
  objects: []
  features: []
  topics: []
  localizations:
    - localization/at
    - localization/ch
    - localization/de
  videos: []
  posts: []
  guidelines: []
object_type: table
object_id: 5821
name: Item Statistics Buffer
namespace: Microsoft.Inventory.Analysis
app: Base Application
extends: null
first_version: "23"
last_version: "30"
present_in:
  - "23"
  - "24"
  - "25"
  - "26"
  - "27"
  - "28"
  - "29"
  - "30"
changed_in:
  - "24"
  - "28"
source_major: "29"
obsolete: null
countries:
  - at
  - ch
  - de
ms_search_form_ids: []
counts:
  fields: 54
  procedures: 0
  events: 0
  subscribers: 0
relations:
  out: 31
  referenced_by: 0
  pages: 0
  extended_by: 0
  event_subscribers: 0
  calls: 0
  called_by: 0
  implements: 0
---

# Table 5821 "Item Statistics Buffer"

> Table 5821 "Item Statistics Buffer" in Base Application (Microsoft.Inventory.Analysis). 54 fields. Present since at least BC23, still in BC30, changed in BC24, BC28.

Base Application · Microsoft.Inventory.Analysis · BC23-30 · [source at ea08af5e](https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Layers/W1/BaseApp/Inventory/Analysis/ItemStatisticsBuffer.Table.al) · facts from BC29

## Properties

| Property | Value |
|---|---|
| Caption | Item Statistics Buffer |
| 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 | Code | Code[20] | — | NotBlank; DataClassification SystemMetadata |
| 2 | Item Filter | Code[20] | — | TableRelation [Table 27 "Item"](../table/27.md); FlowFilter |
| 3 | Variant Filter | Code[10] | — | TableRelation [Table 5401 "Item Variant"](../table/5401.md) ("Item Variant".Code); FlowFilter |
| 4 | Location Filter | Code[10] | — | TableRelation [Table 14 "Location"](../table/14.md); FlowFilter |
| 5 | Budget Filter | Code[10] | — | TableRelation [Table 7132 "Item Budget Name"](../table/7132.md) ("Item Budget Name".Name where("Analysis Area" = field("Analysis Area Filter"))); FlowFilter |
| 6 | Global Dimension 1 Filter | Code[20] | — | TableRelation [Table 349 "Dimension Value"](../table/349.md) ("Dimension Value".Code where("Global Dimension No." = const(1))); FlowFilter |
| 7 | Global Dimension 2 Filter | Code[20] | — | TableRelation [Table 349 "Dimension Value"](../table/349.md) ("Dimension Value".Code where("Global Dimension No." = const(2))); FlowFilter |
| 9 | Date Filter | Date | — | FlowFilter |
| 10 | Entry Type Filter | Enum "Cost Entry Type" | — | FlowFilter; enum [Enum 104 "Cost Entry Type"](../enum/104.md) |
| 11 | Item Ledger Entry Type Filter | Enum "Item Ledger Entry Type" | — | FlowFilter; enum [Enum 78 "Item Ledger Entry Type"](../enum/78.md) |
| 12 | Item Charge No. Filter | Code[20] | — | TableRelation [Table 5800 "Item Charge"](../table/5800.md) (Item Charge); FlowFilter |
| 13 | Source Type Filter | Enum "Analysis Source Type" | — | FlowFilter; enum [Enum 7131 "Analysis Source Type"](../enum/7131.md) |
| 14 | Source No. Filter | Code[20] | — | TableRelation [Table 18 "Customer"](../table/18.md), [Table 23 "Vendor"](../table/23.md), [Table 27 "Item"](../table/27.md) (if ("Source Type Filter" = const(Customer)) Customer else if ("Source Type Filter" = const(Vendor)) Vendor else if ("Source Type Filter" = const(Item)) Item); FlowFilter |
| 15 | Invoiced Quantity | Decimal | — | FlowField: sum("Value Entry"."Invoiced Quantity" where("Item No." = field("Item Filter"), "Posting Date" = field("Date Filter"), "Variant Code" = field("Variant Filter"), "Location Code" = field("Location Filter"), "Entry Type" = field("Entry Type Filter"), "Item Ledger Entry Type" = field("Item Ledger Entry T...; not editable |
| 16 | Sales Amount (Actual) | Decimal | — | FlowField: sum("Value Entry"."Sales Amount (Actual)" where("Item No." = field("Item Filter"), "Posting Date" = field("Date Filter"), "Item Ledger Entry Type" = field("Item Ledger Entry Type Filter"), "Entry Type" = field("Entry Type Filter"), "Variance Type" = field("Variance Type Filter"), "Location Code" = f...; not editable |
| 17 | Cost Amount (Actual) | Decimal | — | FlowField: sum("Value Entry"."Cost Amount (Actual)" where("Item No." = field("Item Filter"), "Posting Date" = field("Date Filter"), "Item Ledger Entry Type" = field("Item Ledger Entry Type Filter"), "Entry Type" = field("Entry Type Filter"), "Variance Type" = field("Variance Type Filter"), "Location Code" = fi...; not editable |
| 18 | Cost Amount (Non-Invtbl.) | Decimal | — | FlowField: sum("Value Entry"."Cost Amount (Non-Invtbl.)" where("Item No." = field("Item Filter"), "Posting Date" = field("Date Filter"), "Item Ledger Entry Type" = field("Item Ledger Entry Type Filter"), "Variance Type" = field("Variance Type Filter"), "Entry Type" = field("Entry Type Filter"), "Location Code"...; not editable |
| 19 | Variance Type Filter | Enum "Cost Variance Type" | — | FlowFilter; enum [Enum 106 "Cost Variance Type"](../enum/106.md) |
| 20 | Sales (LCY) | Integer | — | DataClassification SystemMetadata |
| 21 | COGS (LCY) | Integer | — | DataClassification SystemMetadata |
| 22 | Profit (LCY) | Integer | — | DataClassification SystemMetadata |
| 23 | Profit % | Integer | — | DataClassification SystemMetadata |
| 24 | Inventoriable Costs | Integer | — | DataClassification SystemMetadata |
| 25 | Direct Cost (LCY) | Integer | — | DataClassification SystemMetadata |
| 26 | Revaluation (LCY) | Integer | — | DataClassification SystemMetadata |
| 27 | Rounding (LCY) | Integer | — | DataClassification SystemMetadata |
| 28 | Indirect Cost (LCY) | Integer | — | DataClassification SystemMetadata |
| 29 | Variance (LCY) | Integer | — | DataClassification SystemMetadata |
| 30 | Inventoriable Costs, Total | Integer | — | DataClassification SystemMetadata |
| 31 | Inventory (LCY) | Integer | — | DataClassification SystemMetadata |
| 34 | Non-Invtbl. Costs (LCY) | Integer | — | DataClassification SystemMetadata |
| 40 | Line Option | Enum "Item Statistics Line Option" | — | enum [Enum 5821 "Item Statistics Line Option"](../enum/5821.md); DataClassification SystemMetadata |
| 41 | Column Option | Enum "Item Statistics Column Option" | — | enum [Enum 5822 "Item Statistics Column Option"](../enum/5822.md); DataClassification SystemMetadata |
| 42 | Analysis Area Filter | Enum "Analysis Area Type" | — | FlowFilter; enum [Enum 7130 "Analysis Area Type"](../enum/7130.md) |
| 45 | Quantity | Decimal | — | FlowField: sum("Item Ledger Entry".Quantity where("Item No." = field("Item Filter"), "Source Type" = field("Source Type Filter"), "Source No." = field("Source No. Filter"), "Posting Date" = field("Date Filter"), "Entry Type" = field("Item Ledger Entry Type Filter"), "Location Code" = field("Location Filter"), ...; not editable |
| 46 | Sales Amount (Expected) | Decimal | — | FlowField: sum("Value Entry"."Sales Amount (Expected)" where("Item No." = field("Item Filter"), "Source Type" = field("Source Type Filter"), "Source No." = field("Source No. Filter"), "Posting Date" = field("Date Filter"), "Item Ledger Entry Type" = field("Item Ledger Entry Type Filter"), "Variance Type" = fie...; not editable |
| 47 | Cost Amount (Expected) | Decimal | — | FlowField: sum("Value Entry"."Cost Amount (Expected)" where("Item No." = field("Item Filter"), "Source Type" = field("Source Type Filter"), "Source No." = field("Source No. Filter"), "Posting Date" = field("Date Filter"), "Item Ledger Entry Type" = field("Item Ledger Entry Type Filter"), "Variance Type" = fiel...; not editable |
| 50 | Budgeted Quantity | Decimal | — | FlowField: sum("Item Budget Entry".Quantity where("Analysis Area" = field("Analysis Area Filter"), "Budget Name" = field("Budget Filter"), "Item No." = field("Item Filter"), Date = field("Date Filter"), "Global Dimension 1 Code" = field("Global Dimension 1 Filter"), "Global Dimension 2 Code" = field("Global Di...; not editable |
| 51 | Budgeted Sales Amount | Decimal | — | FlowField: sum("Item Budget Entry"."Sales Amount" where("Analysis Area" = field("Analysis Area Filter"), "Budget Name" = field("Budget Filter"), "Item No." = field("Item Filter"), Date = field("Date Filter"), "Global Dimension 1 Code" = field("Global Dimension 1 Filter"), "Global Dimension 2 Code" = field("Glo...; not editable |
| 52 | Budgeted Cost Amount | Decimal | — | FlowField: sum("Item Budget Entry"."Cost Amount" where("Analysis Area" = field("Analysis Area Filter"), "Budget Name" = field("Budget Filter"), "Item No." = field("Item Filter"), Date = field("Date Filter"), "Global Dimension 1 Code" = field("Global Dimension 1 Filter"), "Global Dimension 2 Code" = field("Glob...; not editable |
| 70 | Analysis View Filter | Code[10] | — | TableRelation [Table 7152 "Item Analysis View"](../table/7152.md) ("Item Analysis View".Code where("Analysis Area" = field("Analysis Area Filter"))); FlowFilter |
| 71 | Dimension 1 Filter | Code[20] | — | FlowFilter |
| 72 | Dimension 2 Filter | Code[20] | — | FlowFilter |
| 73 | Dimension 3 Filter | Code[20] | — | FlowFilter |
| 80 | Analysis - Quantity | Decimal | — | FlowField: sum("Item Analysis View Entry".Quantity where("Analysis Area" = field("Analysis Area Filter"), "Analysis View Code" = field("Analysis View Filter"), "Item No." = field("Item Filter"), "Location Code" = field("Location Filter"), "Dimension 1 Value Code" = field("Dimension 1 Filter"), "Dimension 2 Val...; not editable |
| 81 | Analysis - Invoiced Quantity | Decimal | — | FlowField: sum("Item Analysis View Entry"."Invoiced Quantity" where("Analysis Area" = field("Analysis Area Filter"), "Analysis View Code" = field("Analysis View Filter"), "Item No." = field("Item Filter"), "Location Code" = field("Location Filter"), "Dimension 1 Value Code" = field("Dimension 1 Filter"), "Dime...; not editable |
| 82 | Analysis - Sales Amt. (Actual) | Decimal | — | FlowField: sum("Item Analysis View Entry"."Sales Amount (Actual)" where("Analysis Area" = field("Analysis Area Filter"), "Analysis View Code" = field("Analysis View Filter"), "Item No." = field("Item Filter"), "Location Code" = field("Location Filter"), "Dimension 1 Value Code" = field("Dimension 1 Filter"), "...; not editable |
| 83 | Analysis - Sales Amt. (Exp) | Decimal | — | FlowField: sum("Item Analysis View Entry"."Sales Amount (Expected)" where("Analysis Area" = field("Analysis Area Filter"), "Analysis View Code" = field("Analysis View Filter"), "Item No." = field("Item Filter"), "Location Code" = field("Location Filter"), "Dimension 1 Value Code" = field("Dimension 1 Filter"),...; not editable |
| 84 | Analysis - Cost Amt. (Actual) | Decimal | — | FlowField: sum("Item Analysis View Entry"."Cost Amount (Actual)" where("Analysis Area" = field("Analysis Area Filter"), "Analysis View Code" = field("Analysis View Filter"), "Item No." = field("Item Filter"), "Location Code" = field("Location Filter"), "Dimension 1 Value Code" = field("Dimension 1 Filter"), "D...; not editable |
| 85 | Analysis - Cost Amt. (Exp) | Decimal | — | FlowField: sum("Item Analysis View Entry"."Cost Amount (Expected)" where("Analysis Area" = field("Analysis Area Filter"), "Analysis View Code" = field("Analysis View Filter"), "Item No." = field("Item Filter"), "Location Code" = field("Location Filter"), "Dimension 1 Value Code" = field("Dimension 1 Filter"), ...; not editable |
| 86 | Analysis CostAmt.(Non-Invtbl.) | Decimal | — | FlowField: sum("Item Analysis View Entry"."Cost Amount (Non-Invtbl.)" where("Analysis Area" = field("Analysis Area Filter"), "Analysis View Code" = field("Analysis View Filter"), "Item No." = field("Item Filter"), "Location Code" = field("Location Filter"), "Dimension 1 Value Code" = field("Dimension 1 Filter"...; not editable |
| 91 | Analysis - Budgeted Quantity | Decimal | — | FlowField: sum("Item Analysis View Budg. Entry".Quantity where("Analysis Area" = field("Analysis Area Filter"), "Analysis View Code" = field("Analysis View Filter"), "Budget Name" = field("Budget Filter"), "Item No." = field("Item Filter"), "Location Code" = field("Location Filter"), "Dimension 1 Value Code" =...; not editable |
| 92 | Analysis - Budgeted Sales Amt. | Decimal | — | FlowField: sum("Item Analysis View Budg. Entry"."Sales Amount" where("Analysis Area" = field("Analysis Area Filter"), "Analysis View Code" = field("Analysis View Filter"), "Budget Name" = field("Budget Filter"), "Item No." = field("Item Filter"), "Location Code" = field("Location Filter"), "Dimension 1 Value C...; not editable |
| 93 | Analysis - Budgeted Cost Amt. | Decimal | — | FlowField: sum("Item Analysis View Budg. Entry"."Cost Amount" where("Analysis Area" = field("Analysis Area Filter"), "Analysis View Code" = field("Analysis View Filter"), "Budget Name" = field("Budget Filter"), "Item No." = field("Item Filter"), "Location Code" = field("Location Filter"), "Dimension 1 Value Co...; not editable |

## Keys

- Key1: Code (clustered)

## Relations

- Location Filter: TableRelation [Table 14 "Location"](../table/14.md)
- Source No. Filter: TableRelation [Table 18 "Customer"](../table/18.md) (conditional)
- Source No. Filter: TableRelation [Table 23 "Vendor"](../table/23.md) (conditional)
- Item Filter: TableRelation [Table 27 "Item"](../table/27.md)
- Source No. Filter: TableRelation [Table 27 "Item"](../table/27.md) (conditional)
- Quantity: CalcFormula [Table 32 "Item Ledger Entry"](../table/32.md)
- Global Dimension 1 Filter: TableRelation [Table 349 "Dimension Value"](../table/349.md)
- Global Dimension 2 Filter: TableRelation [Table 349 "Dimension Value"](../table/349.md)
- Variant Filter: TableRelation [Table 5401 "Item Variant"](../table/5401.md)
- Item Charge No. Filter: TableRelation [Table 5800 "Item Charge"](../table/5800.md)
- Cost Amount (Actual): CalcFormula [Table 5802 "Value Entry"](../table/5802.md)
- Cost Amount (Expected): CalcFormula [Table 5802 "Value Entry"](../table/5802.md)
- Cost Amount (Non-Invtbl.): CalcFormula [Table 5802 "Value Entry"](../table/5802.md)
- Invoiced Quantity: CalcFormula [Table 5802 "Value Entry"](../table/5802.md)
- Sales Amount (Actual): CalcFormula [Table 5802 "Value Entry"](../table/5802.md)
- Sales Amount (Expected): CalcFormula [Table 5802 "Value Entry"](../table/5802.md)
- Budget Filter: TableRelation [Table 7132 "Item Budget Name"](../table/7132.md)
- Budgeted Cost Amount: CalcFormula [Table 7134 "Item Budget Entry"](../table/7134.md)
- Budgeted Quantity: CalcFormula [Table 7134 "Item Budget Entry"](../table/7134.md)
- Budgeted Sales Amount: CalcFormula [Table 7134 "Item Budget Entry"](../table/7134.md)
- Analysis View Filter: TableRelation [Table 7152 "Item Analysis View"](../table/7152.md)
- Analysis - Cost Amt. (Actual): CalcFormula [Table 7154 "Item Analysis View Entry"](../table/7154.md)
- Analysis - Cost Amt. (Exp): CalcFormula [Table 7154 "Item Analysis View Entry"](../table/7154.md)
- Analysis - Invoiced Quantity: CalcFormula [Table 7154 "Item Analysis View Entry"](../table/7154.md)
- Analysis - Quantity: CalcFormula [Table 7154 "Item Analysis View Entry"](../table/7154.md)
- Analysis - Sales Amt. (Actual): CalcFormula [Table 7154 "Item Analysis View Entry"](../table/7154.md)
- Analysis - Sales Amt. (Exp): CalcFormula [Table 7154 "Item Analysis View Entry"](../table/7154.md)
- Analysis CostAmt.(Non-Invtbl.): CalcFormula [Table 7154 "Item Analysis View Entry"](../table/7154.md)
- Analysis - Budgeted Cost Amt.: CalcFormula [Table 7156 "Item Analysis View Budg. Entry"](../table/7156.md)
- Analysis - Budgeted Quantity: CalcFormula [Table 7156 "Item Analysis View Budg. Entry"](../table/7156.md)
- Analysis - Budgeted Sales Amt.: CalcFormula [Table 7156 "Item Analysis View Budg. Entry"](../table/7156.md)

## Across versions

- Present in: BC23-30
- Changed (declaration) in: BC24, BC28

## Countries that replace it

[AT](../../localizations/at.md), [CH](../../localizations/ch.md), [DE](../../localizations/de.md)

Source: AL metadata extracted from the code (names, ids, signatures, properties); no code bodies (D10).

## 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: "Item Statistics Buffer")`, then `bcatlas_get_procedure_body` or `bcatlas_get_neighbors` on the returned id.