Query "Grouped Item Ledger Entries"
ID 5756
Namespace: Microsoft.Inventory.Ledger
Properties
| Name | Value |
|---|---|
| QueryType | Normal |
| Caption | Grouped Item Ledger Entries |
| QueryCategory | 'Item Ledger Entries' |
| OrderBy | ascending(Location_Code, Item_No, Variant_Code, Unit_of_Measure_Code, Lot_No_, Package_No_, Serial_No_) |
Query columns
| Column name | Data item | Data type | Description |
|---|---|---|---|
| Location_Code | Item_Ledger_Entry | Code[10] | |
| Item_No | Item_Ledger_Entry | Code[20] | |
| Variant_Code | Item_Ledger_Entry | Code[10] | |
| Unit_of_Measure_Code | Item_Ledger_Entry | Code[10] | |
| Serial_No_ | Item_Ledger_Entry | Code[50] | |
| Lot_No_ | Item_Ledger_Entry | Code[50] | |
| Package_No_ | Item_Ledger_Entry | Code[50] | |
| Remaining_Quantity | Item_Ledger_Entry | Decimal |