Item Statistics Buffer #5821

Other table in Microsoft Dynamics 365 Business Central. 59 fields, 0 records in Cronus demo.

Fields

Records

Primary key

FlowFields

Relations

Open in Data Explorer →

Primary key

The primary key uniquely identifies each record in this table. It consists of: Code.

All fields (59)

Item Statistics Buffer — FIELDS

NO.	FIELD	TYPE	CLASS	RELATION
1	Code PK	Code	Normal
2	Item Filter	Code	FlowFilter	→ Item #27
3	Variant Filter	Code	FlowFilter	→ Item Variant #5401
4	Location Filter	Code	FlowFilter	→ Location #14
5	Budget Filter	Code	FlowFilter	→ Item Budget Name #7132
6	Global Dimension 1 Filter	Code	FlowFilter	→ Dimension Value #349
7	Global Dimension 2 Filter	Code	FlowFilter	→ Dimension Value #349
9	Date Filter	Date	FlowFilter
10	Entry Type Filter	Option	FlowFilter
11	Item Ledger Entry Type Filter	Option	FlowFilter
12	Item Charge No. Filter	Code	FlowFilter	→ Item Charge #5800
13	Source Type Filter	Option	FlowFilter
14	Source No. Filter	Code	FlowFilter
15	Invoiced Quantity ⚡ FLOW	Decimal	FlowField
16	Sales Amount (Actual) ⚡ FLOW	Decimal	FlowField
17	Cost Amount (Actual) ⚡ FLOW	Decimal	FlowField
18	Cost Amount (Non-Invtbl.) ⚡ FLOW	Decimal	FlowField
19	Variance Type Filter	Option	FlowFilter
20	Sales (LCY)	Integer	Normal
21	COGS (LCY)	Integer	Normal
22	Profit (LCY)	Integer	Normal
23	Profit %	Integer	Normal
24	Inventoriable Costs	Integer	Normal
25	Direct Cost (LCY)	Integer	Normal
26	Revaluation (LCY)	Integer	Normal
27	Rounding (LCY)	Integer	Normal
28	Indirect Cost (LCY)	Integer	Normal
29	Variance (LCY)	Integer	Normal
30	Inventoriable Costs, Total	Integer	Normal
31	Inventory (LCY)	Integer	Normal
34	Non-Invtbl. Costs (LCY)	Integer	Normal
40	Line Option	Option	Normal
41	Column Option	Option	Normal
42	Analysis Area Filter	Option	FlowFilter
45	Quantity ⚡ FLOW	Decimal	FlowField
46	Sales Amount (Expected) ⚡ FLOW	Decimal	FlowField
47	Cost Amount (Expected) ⚡ FLOW	Decimal	FlowField
50	Budgeted Quantity ⚡ FLOW	Decimal	FlowField
51	Budgeted Sales Amount ⚡ FLOW	Decimal	FlowField
52	Budgeted Cost Amount ⚡ FLOW	Decimal	FlowField
70	Analysis View Filter	Code	FlowFilter	→ Item Analysis View #7152
71	Dimension 1 Filter	Code	FlowFilter
72	Dimension 2 Filter	Code	FlowFilter
73	Dimension 3 Filter	Code	FlowFilter
80	Analysis - Quantity ⚡ FLOW	Decimal	FlowField
81	Analysis - Invoiced Quantity ⚡ FLOW	Decimal	FlowField
82	Analysis - Sales Amt. (Actual) ⚡ FLOW	Decimal	FlowField
83	Analysis - Sales Amt. (Exp) ⚡ FLOW	Decimal	FlowField
84	Analysis - Cost Amt. (Actual) ⚡ FLOW	Decimal	FlowField
85	Analysis - Cost Amt. (Exp) ⚡ FLOW	Decimal	FlowField
86	Analysis CostAmt.(Non-Invtbl.) ⚡ FLOW	Decimal	FlowField
91	Analysis - Budgeted Quantity ⚡ FLOW	Decimal	FlowField
92	Analysis - Budgeted Sales Amt. ⚡ FLOW	Decimal	FlowField
93	Analysis - Budgeted Cost Amt. ⚡ FLOW	Decimal	FlowField
2000000000	System ID	GUID	Normal
2000000001	Created At	DateTime	Normal
2000000002	Created By	GUID	Normal
2000000003	Modified At	DateTime	Normal
2000000004	Modified By	GUID	Normal

Related tables (8)

Tables referenced by fields on the Item Statistics Buffer table through TableRelation properties.

Item

#27 · Inventory · via Item Filter

Item Variant

#5401 · Other · via Variant Filter

Location

#14 · General Ledger · via Location Filter

Item Budget Name

#7132 · Other · via Budget Filter

Dimension Value

#349 · Dimensions · via Global Dimension 1 Filter, Global Dimension 2 Filter

Item Charge

#5800 · Other · via Item Charge No. Filter

Item Analysis View

#7152 · Other · via Analysis View Filter