Site stock history

The on-hand, available, on-hold and reserved quantities of an item at one site at the end of a date.

Fields

The API name is what the API, MCP and the CLI use.

NameAPI nameTypeRequiredDescription
IDidRecord IDYes
ItemproductitemIdReferenceYes
DaydateDateYesCivil date (YYYY-MM-DD) of the end-of-date snapshot in the site timezone.
CustomercustomerIdReference
On handonhandQuantityYesQuantity at the site at the end of that date, regardless of tracking identity or physical conformity. Does not mean every unit is an interchangeable instance of the nominal product. On hand equals available plus on hold plus reserved plus allocated. Does not include In transit.
AvailableavailableQuantityYesQuantity at the site that could be allocated at the end of that date. Calculated as on hand minus on hold minus reserved minus allocated.
On holdonholdQuantityYesQuantity blocked due to operational reasons at the end of that date, such as quality inspection, discrepancies, or administrative review.
ReservedreservedQuantityYesQuantity in the unit of measure used on this line.
AllocatedallocatedQuantityYesQuantity set aside for a demand document at the end of that date. Available subtracts it.
UnitcatalogunitUnit
OwnershipownershipConstantYesBeneficial owner of the stock. The custodial company remains the record's company.
Has non-nominal stockhasNonNominalBooleanYesTrue when at least one identity at this site had on hand greater than zero and was not nominal at the end of that date.
Created atcreatedAtDate and TimeYes

Relations

FieldPoints toKind
Item productitemIdProduct itemsreference
Customer customerIdCustomersreference