Company stock history

The on-hand, available, on-hold and reserved quantities of an item for one company 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 organization timezone.
CustomercustomerIdReference
On handonhandQuantityYesQuantity at the company 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 company 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 company 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