Table 5310 Item Statistics Cache in 28
- App
- Base Application
- Namespace
- Microsoft.Inventory.Analysis
Fields, 22Keys, 1Procedures, 3
Versions171819202122232425262728latest
Source29
Fields, 22
| Id | Name | Type | Obsolete |
|---|---|---|---|
| 1 | Item No. | Code[20] | - |
| 2 | ItemLedgerEntryNoLatest | Integer | - |
| 3 | ValueEntryNoLatest | Integer | - |
| 4 | LastUpdated | Date | - |
| 5 | CurrentInventoryValue | Decimal | - |
| 6 | ExpiredStockValue | Decimal | - |
| 7 | SalesGrowthRateThisPeriod | Decimal | - |
| 8 | NetSalesLCYThisPeriod | Decimal | - |
| 9 | GrossMarginThisPeriod | Decimal | - |
| 10 | ReturnRateThisPeriod | Decimal | - |
| 11 | SalesGrowthRateThisFY | Decimal | - |
| 12 | NetSalesLCYThisFY | Decimal | - |
| 13 | GrossMarginThisFY | Decimal | - |
| 14 | ReturnRateThisFY | Decimal | - |
| 15 | SalesGrowthRateLastFY | Decimal | - |
| 16 | NetSalesLCYLastFY | Decimal | - |
| 17 | GrossMarginLastFY | Decimal | - |
| 18 | ReturnRateLastFY | Decimal | - |
| 19 | NetSalesLCYLifetime | Decimal | - |
| 20 | GrossMarginLifetime | Decimal | - |
| 21 | ReturnRateLifetime | Decimal | - |
| 22 | Description | Text[100] | - |
Keys, 1
| Name | Fields | Obsolete |
|---|---|---|
| Key1, clustered | Item No. | - |
Procedures, 3
| Name | Parameters | Returns | Access | Obsolete | |||
|---|---|---|---|---|---|---|---|
| InitAndInsert | (Code[20]) | public | Pending 29.0 | ||||
| Use InitAndInsert with ItemNo and ItemDescription parameters instead. | |||||||
| InitAndInsert | (Code[20], Text[100]) | public | - | ||||
| UpdateIfNeeded | (Record Item, Date, Text[30], Text[30]) | public | - | ||||