Data Dictionary
Field | Type | Notes |
Allocated Quantity | Number | API: Stock On Hand.AllocatedQty |
Available Quantity | Number | API: Stock On Hand.AvailableQty |
Average Cost | Number | API: Stock On Hand.AvgCost |
Connection ID | Integer | The Connectorly Connection ID. If you group Connectorly's together, then you will see a Connection ID for each one. Organisations has the corresponding Connection Name for each Connection ID. |
Data current as of | Datetime | Gives the date and time that this record was taken from Unleashed. |
Days Since Last Sale | Integer | API: Stock On Hand.DaysSinceLastSale |
On Purchase | Number | API: Stock On Hand.OnPurchase |
Product Code | Text | API: Stock On Hand.ProductCode |
Product Description | Text | Derived from cleaning Product Description |
Product GUID | Text | API: Stock On Hand.ProductGuid |
Product Group Name | Text | API: Stock On Hand.ProductGroupName |
Product Source ID | Text | API: Stock On Hand.ProductSourceId |
Quantity On Hand | Number | API: Stock On Hand.QtyOnHand |
Stock On Hand GUID | Text | API: Stock On Hand.Guid |
Total Cost | Number | API: Stock On Hand.TotalCost |
Updated | Datetime | Derived from datetime with timezone conversion of Updated |
Warehouse GUID | Text | API: Stock On Hand.WarehouseId |
Warehouse Name | Text | API: Stock On Hand.Warehouse |
