Query would look something like this:

SELECT

Bin,

Item,

OnHand,

OnHandAvail

FROM

ItemBinQuantity

WHERE

Item = 999999

Thanks @tdietrich, where can we see all the tables or details etc.