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!

Thank you.

Rookie Asked on August 13, 2021 in SuiteAnalytics.

Hi Abushell,

Did you ever find the answer to this? I have the same problem. Using Suite Analytics Connect ODBC and we cannot find the Inventory detail/Inventory status to give us some insight into transactions and the inventory status that the item has



on May 11, 2023.
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   Become a Sponsor   Become a Sponsor