Stock Unit Maintenance Status Logic

In Stock Unit Maintenance program, there is a Stock Status area which commonly shows 4 types of statuses.
On Quote, Pre Sold, Sold and Swapped Out. If you notice, these statuses are not on VHSTOCK table but rather a set of criteria which produces the statuses.

Here are the logics:

1. On Quote

It requires the stock number to be present in VHQUOTEUNIT table. (Provided that it hasn't been sold or status changed to order).

2. Pre Sold 

This stock number needs to be on VHQUOTEUNIT table AND there is a date in 'Original Order Date' field in VHQUOTE table against the same Quote number.

3. Sold

The 'Salesdate' and 'Sales Inv' fields in VHSTOCK are populated with the respective info.

4. Swapped Out

There is a value in the 'Swap Out Ref' field in the VHSTOCK table.

p/s If you don't access the Database Tables, this posting might not make any sense to you. Ask your System Admin for details.