| Name | Description | Type | Additional information |
|---|---|---|---|
| ID |
Caliq internal unique identifier |
integer |
None. |
| Code |
User entered unique part number |
string |
Max length: 25 |
| Description |
Short product description |
string |
Max length: 80 |
| Cost_Valuation |
The unit cost from Caliq designated as the 'valuation cost' |
decimal number |
None. |
| StockQty |
Physical stock quantity of the item |
integer |
None. |
| POQty |
Quantity on purchase order of the item |
integer |
None. |
| MonthsCover |
Months cover |
decimal number |
None. |
| AvgMonthUsage_1 |
Average months usage based on last 1 full months sales |
decimal number |
None. |
| AvgMonthUsage_6 |
Average months usage based on last 6 full months sales |
decimal number |
None. |
| AvgMonthUsage_12 |
Average months usage based on last 12 full months sales |
decimal number |
None. |