Objects/Tables/Table 5847 Average Cost Calc. Overview
Table 5847 Average Cost Calc. Overview in 27
Jonas Paprotka, Base Application 27.5.46862.47359, checked
- App
- Base Application
- Namespace
- Microsoft.Inventory.Costing
Fields, 21Keys, 3Procedures, 4Events, 1
Versions171819202122232425262728latest
Source29
Fields, 21
| Id | Name | Type | Obsolete |
|---|
| 1 | Entry No. | Integer | - |
| 2 | Type | Option | - |
| 3 | Valuation Date | Date | - |
| 4 | Item No. | Code[20] | - |
| 5 | Location Code | Code[10] | - |
| 6 | Variant Code | Code[10] | - |
| 7 | Cost is Adjusted | Boolean | - |
| 11 | Attached to Entry No. | Integer | - |
| 12 | Attached to Valuation Date | Date | - |
| 13 | Level | Integer | - |
| 21 | Item Ledger Entry No. | Integer | - |
| 22 | Posting Date | Date | - |
| 23 | Entry Type | Enum Item Ledger Entry Type | - |
| 24 | Document Type | Option | - |
| 25 | Document No. | Code[20] | - |
| 26 | Document Line No. | Integer | - |
| 27 | Description | Text[100] | - |
| 31 | Quantity | Decimal | - |
| 32 | Applied Quantity | Integer | - |
| 33 | Cost Amount (Expected) | Decimal | - |
| 34 | Cost Amount (Actual) | Decimal | - |
Keys, 3
| Name | Fields | Obsolete |
|---|
| Key1, clustered | Entry No. | - |
| Key2 | Attached to Valuation Date, Attached to Entry No., Type | - |
| Key3 | Item Ledger Entry No. | - |
Procedures, 4
| Name | Parameters | Returns | Access | Obsolete |
|---|
| CalculateAverageCost | () | Decimal | public | - |
| CalculateRemainingQty | () | Decimal | public | - |
| CalculateCostAmt | (Boolean) | Decimal | public | - |
| SetItemFilters | () | | public | - |
Events, 1
| Kind | Name | Parameters | Obsolete |
|---|
| Integration event | OnAfterSetItemFilters | (var Record Value Entry, Record Average Cost Calc. Overview) | - |