Query "Item Ledger Entries"
ID 265
Namespace: Microsoft.Inventory.Ledger
Properties
| Name | Value |
|---|---|
| Caption | Item Ledger Entries |
Query columns
| Column name | Data item | Data type | Description |
|---|---|---|---|
| Entry_No | Item_Ledger_Entry | Integer | |
| Entry_Type | Item_Ledger_Entry | Enum Microsoft.Inventory.Ledger."Item Ledger Entry Type" | |
| Item_No | Item_Ledger_Entry | Code[20] | |
| Item_Reference_No | Item_Ledger_Entry | Code[50] | |
| Lot_No | Item_Ledger_Entry | Code[50] | |
| Item_Category_Code | Item_Ledger_Entry | Code[20] | |
| Posting_Date | Item_Ledger_Entry | Date | |
| Expiration_Date | Item_Ledger_Entry | Date | |
| Warranty_Date | Item_Ledger_Entry | Date | |
| Document_Date | Item_Ledger_Entry | Date | |
| Document_No | Item_Ledger_Entry | Code[20] | |
| Document_Type | Item_Ledger_Entry | Enum Microsoft.Inventory.Ledger."Item Ledger Document Type" | |
| Location_Code | Item_Ledger_Entry | Code[10] | |
| Job_No | Item_Ledger_Entry | Code[20] | |
| Job_Task_No | Item_Ledger_Entry | Code[20] | |
| Open | Item_Ledger_Entry | Boolean | |
| Quantity | Item_Ledger_Entry | Decimal | |
| Unit_of_Measure_Code | Item_Ledger_Entry | Code[10] | |
| Qty_per_Unit_of_Measure | Item_Ledger_Entry | Decimal | |
| Remaining_Quantity | Item_Ledger_Entry | Decimal | |
| Invoiced_Quantity | Item_Ledger_Entry | Decimal | |
| Cost_Amount_Expected | Item_Ledger_Entry | Decimal | |
| Cost_Amount_Actual | Item_Ledger_Entry | Decimal | |
| Cost_Amount_Non_Invtbl | Item_Ledger_Entry | Decimal | |
| Purchase_Amount_Expected | Item_Ledger_Entry | Decimal | |
| Purchase_Amount_Actual | Item_Ledger_Entry | Decimal | |
| Sales_Amount_Expected | Item_Ledger_Entry | Decimal | |
| Sales_Amount_Actual | Item_Ledger_Entry | Decimal | |
| Dimension_Set_ID | Item_Ledger_Entry | Integer | |
| Item_Description | Item | Text[100] |