BC Observatoryunofficial, made by waldo
tableInventoryofficial - Microsoftderived - from the source, no model text

Table 5821 "Item Statistics Buffer"

Base Application · Microsoft.Inventory.Analysis

Open in Claude5821.mdSource on GitHub

Across versions

  1. BC23present
  2. BC24declaration changed
  3. BC25-27unchanged
  4. BC2820 fields changed
  5. BC29-30unchanged

Neighbourhood 14 connected objects and pages

Table 7154 "Item Analysis View Entry" (relates to, 7 links)Item Analysis View EntryTable 5802 "Value Entry" (relates to, 6 links)Value EntryTable 7134 "Item Budget Entry" (relates to, 3 links)Item Budget EntryTable 7156 "Item Analysis View Budg. Entry" (relates to, 3 links)Item Analysis View Budg. EntryTable 27 "Item" (relates to, 2 links)ItemTable 349 "Dimension Value" (relates to, 2 links)Dimension ValueTable 14 "Location" (relates to)LocationTable 18 "Customer" (relates to)CustomerTable 23 "Vendor" (relates to)VendorTable 32 "Item Ledger Entry" (relates to)Item Ledger EntryTable 5401 "Item Variant" (relates to)Item VariantTable 5800 "Item Charge" (relates to)Item ChargeTable 7132 "Item Budget Name" (relates to)Item Budget NameTable 7152 "Item Analysis View" (relates to)Item Analysis View

Open in the neighbourhood explorer

One hop out, from the extracted relations and call graph. Up to 40 shown; the sections below list them all.

Base Application · Microsoft.Inventory.Analysis · BC23-30 · source at ea08af5e · 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”; FlowFilter
3 Variant Filter Code[10] — TableRelation Table 5401 “Item Variant” (“Item Variant”.Code); FlowFilter
4 Location Filter Code[10] — TableRelation Table 14 “Location”; FlowFilter
5 Budget Filter Code[10] — TableRelation Table 7132 “Item Budget Name” (“Item Budget Name”.Name where(“Analysis Area” = field(“Analysis Area Filter”))); FlowFilter
6 Global Dimension 1 Filter Code[20] — TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(1))); FlowFilter
7 Global Dimension 2 Filter Code[20] — TableRelation Table 349 “Dimension Value” (“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”
11 Item Ledger Entry Type Filter Enum “Item Ledger Entry Type” — FlowFilter; enum Enum 78 “Item Ledger Entry Type”
12 Item Charge No. Filter Code[20] — TableRelation Table 5800 “Item Charge” (Item Charge); FlowFilter
13 Source Type Filter Enum “Analysis Source Type” — FlowFilter; enum Enum 7131 “Analysis Source Type”
14 Source No. Filter Code[20] — TableRelation Table 18 “Customer”, Table 23 “Vendor”, Table 27 “Item” (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 Δ BC28 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) Δ BC28 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) Δ BC28 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.) Δ BC28 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”
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”; DataClassification SystemMetadata
41 Column Option Enum “Item Statistics Column Option” — enum Enum 5822 “Item Statistics Column Option”; DataClassification SystemMetadata
42 Analysis Area Filter Enum “Analysis Area Type” — FlowFilter; enum Enum 7130 “Analysis Area Type”
45 Quantity Δ BC28 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) Δ BC28 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) Δ BC28 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 Δ BC28 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 Δ BC28 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 Δ BC28 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” (“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 Δ BC28 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 Δ BC28 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) Δ BC28 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) Δ BC28 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) Δ BC28 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) Δ BC28 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.) Δ BC28 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 Δ BC28 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. Δ BC28 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. Δ BC28 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

Countries that replace it

AT, CH, DE

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.

Evidence 1 sources