I need to access inventory detail using SuiteQL. What is the file name ?

@Simon I think you're looking for the InventoryItemLocations table. Here's a query that might help:

SELECT
	Location,
	BUILTIN.DF( Location ) AS LocationName,
	QuantityOnHand,
	QuantityAvailable
FROM
	InventoryItemLocations 
WHERE
	Item = 35277

It's getting closer but not there yet. Mine is by Serial Number. It looks like this

Ah, ok. I think you want the InventoryNumber and InventoryNumberLocation tables. Take a look at this post - https://timdietrich.me/blog/netsuite-suiteql-serialized-lot-number-expiring-items/ - and specifically at the "Multi-Location Inventory" query. I think that's what you need.

Won't give you a breakdown by bin.

@Alan Fitch 💥 💥 💥 💥 I've got 100s of lines of SuiteQL queries I can trash now... thank you kind sir

How did you find out @Alan Fitch?

Credit to @battk