Query "Item Analysis View Source"
ID 7150
Namespace: Microsoft.Inventory.Analysis
Properties
| Name | Value |
|---|---|
| Caption | Item Analysis View Source |
Query columns
| Column name | Data item | Data type | Description |
|---|---|---|---|
| ItemNo | ValueEntry | Code[20] | |
| SourceType | ValueEntry | Enum Microsoft.Foundation.Enums."Analysis Source Type" | |
| SourceNo | ValueEntry | Code[20] | |
| EntryType | ValueEntry | Enum Microsoft.Inventory.Costing."Cost Entry Type" | |
| ItemLedgerEntryType | ValueEntry | Enum Microsoft.Inventory.Ledger."Item Ledger Entry Type" | |
| ItemLedgerEntryNo | ValueEntry | Integer | |
| ItemChargeNo | ValueEntry | Code[20] | |
| LocationCode | ValueEntry | Code[10] | |
| PostingDate | ValueEntry | Date | |
| DimensionSetID | ValueEntry | Integer | |
| ILEQuantity | ValueEntry | Decimal | |
| InvoicedQuantity | ValueEntry | Decimal | |
| SalesAmountActual | ValueEntry | Decimal | |
| SalesAmountExpected | ValueEntry | Decimal | |
| CostAmountActual | ValueEntry | Decimal | |
| CostAmountNonInvtbl | ValueEntry | Decimal | |
| CostAmountExpected | ValueEntry | Decimal | |
| DimVal1 | DimSet1 | Code[20] | |
| DimVal2 | DimSet2 | Code[20] | |
| DimVal3 | DimSet3 | Code[20] |