Josh - This information should be tracked as part of the information in the Bin Card (ie Stock Card).
Need to check on the constraints on the
stock_management.stock_cards table to ensure that this is supported
stock_card_line_items.extradata could be the right place to store this data, could also be the
*_fields tables (not sure if/how these are used)
The good way to do this, would be to create an adjustment (or custom UI) to change the status of a given product-lot with a reason that would result in a new bin-card being created with the affected quantity.
Short-term, might be able to try something on the whole lot (via the bin-card) but this almost certainly won’t meet the actual requirements for many facilities