Skip to main content

Stock On Hand

Written by Nick Maxwell

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

Did this answer your question?