ODBC SQL table that holds Inventory Detail Status
On an item record there is the inventory detail tab that shows the quantity of the item in one or more bins. There is a Item Status next to the bin of either Good or Defect etc… and this is stated when an Inventory Status change is done. What SQL table is this information stored? I can find the Inventory Status table that hosts the different types of statuses and their ID. I just don’t know where it relates to another table that has the Bin number and its quantity plus its Inventory Status? I can see there is a Transaction entry and a quantity in Transaction_Lines table but no Inventory Status.
Any help would be much appreciated!