Table "Item Statistics Buffer"
ID 5821
Namespace: Microsoft.Inventory.Analysis
Properties
| Name | Value |
|---|---|
| Caption | Item Statistics Buffer |
| DataCaptionFields | 1 |
| ReplicateData | False |
| DataClassification | CustomerContent |
Fields
| Name | Type | Description |
|---|---|---|
| Code | Code[20] | |
| "Item Filter" | Code[20] | |
| "Variant Filter" | Code[10] | |
| "Location Filter" | Code[10] | |
| "Budget Filter" | Code[10] | |
| "Global Dimension 1 Filter" | Code[20] | |
| "Global Dimension 2 Filter" | Code[20] | |
| "Date Filter" | Date | |
| "Entry Type Filter" | Enum Microsoft.Inventory.Costing."Cost Entry Type" | |
| "Item Ledger Entry Type Filter" | Enum Microsoft.Inventory.Ledger."Item Ledger Entry Type" | |
| "Item Charge No. Filter" | Code[20] | |
| "Source Type Filter" | Enum Microsoft.Foundation.Enums."Analysis Source Type" | |
| "Source No. Filter" | Code[20] | |
| "Invoiced Quantity" | Decimal | |
| "Sales Amount (Actual)" | Decimal | |
| "Cost Amount (Actual)" | Decimal | |
| "Cost Amount (Non-Invtbl.)" | Decimal | |
| "Variance Type Filter" | Enum Microsoft.Inventory.Costing."Cost Variance Type" | |
| "Sales (LCY)" | Integer | |
| "COGS (LCY)" | Integer | |
| "Profit (LCY)" | Integer | |
| "Profit %" | Integer | |
| "Inventoriable Costs" | Integer | |
| "Direct Cost (LCY)" | Integer | |
| "Revaluation (LCY)" | Integer | |
| "Rounding (LCY)" | Integer | |
| "Indirect Cost (LCY)" | Integer | |
| "Variance (LCY)" | Integer | |
| "Inventoriable Costs, Total" | Integer | |
| "Inventory (LCY)" | Integer | |
| "Non-Invtbl. Costs (LCY)" | Integer | |
| "Line Option" | Enum Microsoft.Inventory.Analysis."Item Statistics Line Option" | |
| "Column Option" | Enum Microsoft.Inventory.Analysis."Item Statistics Column Option" | |
| "Analysis Area Filter" | Enum Microsoft.Inventory.Analysis."Analysis Area Type" | |
| Quantity | Decimal | |
| "Sales Amount (Expected)" | Decimal | |
| "Cost Amount (Expected)" | Decimal | |
| "Budgeted Quantity" | Decimal | |
| "Budgeted Sales Amount" | Decimal | |
| "Budgeted Cost Amount" | Decimal | |
| "Analysis View Filter" | Code[10] | |
| "Dimension 1 Filter" | Code[20] | |
| "Dimension 2 Filter" | Code[20] | |
| "Dimension 3 Filter" | Code[20] | |
| "Analysis - Quantity" | Decimal | |
| "Analysis - Invoiced Quantity" | Decimal | |
| "Analysis - Sales Amt. (Actual)" | Decimal | |
| "Analysis - Sales Amt. (Exp)" | Decimal | |
| "Analysis - Cost Amt. (Actual)" | Decimal | |
| "Analysis - Cost Amt. (Exp)" | Decimal | |
| "Analysis CostAmt.(Non-Invtbl.)" | Decimal | |
| "Analysis - Budgeted Quantity" | Decimal | |
| "Analysis - Budgeted Sales Amt." | Decimal | |
| "Analysis - Budgeted Cost Amt." | Decimal | |
| SystemId | Guid | |
| SystemCreatedAt | DateTime | |
| SystemCreatedBy | Guid | |
| SystemModifiedAt | DateTime | |
| SystemModifiedBy | Guid | |
| SystemRowVersion | BigInteger |