From the Product table within Attaché Data, the value in the 'Status Flags' field is a total value which is calculated by adding the following values if applicable:
1 = Allow Alternatives is ticked.
2 = An Alternative Product is listed under Products, Masterfiles, Products, Alternatives (only add once).
4 = A Superseded By product is listed (only add once).
8 = Inactive is ticked.
16 = a Barcode has been added, either the Master Barcode or under Supplementary Barcodes (add 16 for each barcode).
For example:
Allow Alternatives is ticked, and two Barcodes are listed for the product:
statusflags = 1 + 16 + 16 = 33
Only Inactive is ticked, no barcodes, no superseded, no alternatives:
statusflags = 8
Any number of alternative products are listed, Allow Alternatives is ticked and there is one Barcode:
statusflags = 1 + 2 + 16 = 19
These flags also appear in the List Wizard (F2, F11 from the Product Code field in the Product Masterfile) and also in the Product SQL Table extracted via ODBC.
📌Note: If you use the Product_master view rather than the Product table, the components of the statusflags values are separated out into different fields, eg: allowaltern.