Query "Value Entries"
ID 266
Namespace: Microsoft.Inventory.Ledger
Properties
| Name | Value |
|---|---|
| Caption | Value Entries |
Query columns
| Column name | Data item | Data type | Description |
|---|---|---|---|
| Entry_No | Value_Entry | Integer | |
| Item_No | Value_Entry | Code[20] | |
| Item_Ledger_Entry_No | Value_Entry | Integer | |
| Item_Ledger_Entry_Type | Value_Entry | Enum Microsoft.Inventory.Ledger."Item Ledger Entry Type" | |
| Item_Ledger_Entry_Quantity | Value_Entry | Decimal | |
| Posting_Date | Value_Entry | Date | |
| Valuation_Date | Value_Entry | Date | |
| Document_Date | Value_Entry | Date | |
| Document_Type | Value_Entry | Enum Microsoft.Inventory.Ledger."Item Ledger Document Type" | |
| Document_No | Value_Entry | Code[20] | |
| Gen_Bus_Posting_Group | Value_Entry | Code[20] | |
| Gen_Prod_Posting_Group | Value_Entry | Code[20] | |
| Location_Code | Value_Entry | Code[10] | |
| Source_Code | Value_Entry | Code[10] | |
| Reason_Code | Value_Entry | Code[10] | |
| Job_No | Value_Entry | Code[20] | |
| Job_Task_No | Value_Entry | Code[20] | |
| Job_Ledger_Entry_No | Value_Entry | Integer | |
| Valued_Quantity | Value_Entry | Decimal | |
| Invoiced_Quantity | Value_Entry | Decimal | |
| Cost_per_Unit | Value_Entry | Decimal | |
| Cost_Posted_to_G_L | Value_Entry | Decimal | |
| Expected_Cost | Value_Entry | Boolean | |
| Cost_Amount_Actual | Value_Entry | Decimal | |
| Cost_Amount_Expected | Value_Entry | Decimal | |
| Cost_Amount_Non_Invtbl | Value_Entry | Decimal | |
| Sales_Amount_Actual | Value_Entry | Decimal | |
| Sales_Amount_Expected | Value_Entry | Decimal | |
| Purchase_Amount_Actual | Value_Entry | Decimal | |
| Purchase_Amount_Expected | Value_Entry | Decimal | |
| Dimension_Set_ID | Value_Entry | Integer | |
| Item_Description | Item | Text[100] |