Table 5821 Item Statistics Buffer

Base Application, Microsoft.Inventory.Analysis

57 fields

IdNameTypeVersions
1CodeCode[20]17-29
2Item FilterCode[20]17-29
3Variant FilterCode[10]17-29
4Location FilterCode[10]17-29
5Budget FilterCode[10]17-29
6Global Dimension 1 FilterCode[20]17-29
7Global Dimension 2 FilterCode[20]17-29
9Date FilterDate17-29
10Entry Type FilterEnum "Cost Entry Type"17-29
11Item Ledger Entry Type FilterEnum "Item Ledger Entry Type"17-29
12Item Charge No. FilterCode[20]17-29
13Source Type FilterEnum "Analysis Source Type"17-29changed in 20
14Source No. FilterCode[20]17-29
15Invoiced QuantityDecimal17-29
16Sales Amount (Actual)Decimal17-29
17Cost Amount (Actual)Decimal17-29
18Cost Amount (Non-Invtbl.)Decimal17-29
19Variance Type FilterEnum "Cost Variance Type"17-29
20Sales (LCY)Integer17-29
21COGS (LCY)Integer17-29
22Profit (LCY)Integer17-29
23Profit %Integer17-29
24Inventoriable CostsInteger17-29
25Direct Cost (LCY)Integer17-29
26Revaluation (LCY)Integer17-29
27Rounding (LCY)Integer17-29
28Indirect Cost (LCY)Integer17-29
29Variance (LCY)Integer17-29
30Inventoriable Costs, TotalInteger17-29
31Inventory (LCY)Integer17-29
34Non-Invtbl. Costs (LCY)Integer17-29
40Line OptionEnum "Item Statistics Line Option"17-29
41Column OptionEnum "Item Statistics Column Option"17-29changed in 19
42Analysis Area FilterEnum "Analysis Area Type"17-29changed in 19
45QuantityDecimal17-29
46Sales Amount (Expected)Decimal17-29
47Cost Amount (Expected)Decimal17-29
50Budgeted QuantityDecimal17-29
51Budgeted Sales AmountDecimal17-29
52Budgeted Cost AmountDecimal17-29
70Analysis View FilterCode[10]17-29
71Dimension 1 FilterCode[20]17-29
72Dimension 2 FilterCode[20]17-29
73Dimension 3 FilterCode[20]17-29
80Analysis - QuantityDecimal17-29
81Analysis - Invoiced QuantityDecimal17-29
82Analysis - Sales Amt. (Actual)Decimal17-29
83Analysis - Sales Amt. (Exp)Decimal17-29
84Analysis - Cost Amt. (Actual)Decimal17-29
85Analysis - Cost Amt. (Exp)Decimal17-29
86Analysis CostAmt.(Non-Invtbl.)Decimal17-29
91Analysis - Budgeted QuantityDecimal17-29
92Analysis - Budgeted Sales Amt.Decimal17-29
93Analysis - Budgeted Cost Amt.Decimal17-29
11500Inv. Valuation ActualDecimal17-29
11501Inv. Valuation Exp.Decimal17-29
11502Inv. Posted to GLDecimal17-29