ODBC SQL table that holds Inventory Detail Status

Hello 

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!

Thank you.

Rookie Asked on August 13, 2021 in SuiteAnalytics.
Add Comment
0 Answer(s)

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Limebox   Become a Sponsor