Getting the list of bins associated with an Item for a given location/subsidiary via SuiteQL query.
I am attempting to fetch the Bins associated with an Item for a given location/Subsidiary executing a SuiteQL query via Rest API Call.. I am attaching a few screenshots.
- One screenshot describes the sub-list called “BinNumbers” under the Purchasing/Inventory tab in the item form.
- One screenshot describes a custom view of the “BinNumbers” under the “Inventory Details” tab in the item form
- The 3rd screenshot describes the Collections/Joins available to fetch the bin numbers associated with an Item. Both these collections listed in the records catalog seem to return the same results with them pulling the BinNumbers listed under the “Inventory Details” tab.
So my question is what is the underlying table or join table, which possibly would help me fetch the records contained in the sub-list of “BinNumbers” that are located under the Purchasing/Inventory tab in the items form via SuiteQL Query.