If I wanted to use a SuiteQL query to get the type of an item (i.e. assemblyitem, inventoryitem, etc.), how would I go about doing that? I have the query string:

SELECT item.id, item.itemid FROM item WHERE item.itemid IN(" + itemIds + ")

, which returns the fields of the item, but I cannot figure out how to get the item type. I have tried to add

item.type

to the query and I get errors about it not being a valid field. Does anyone know what field name I should be using?

The records catalog shows

itemtype

on there, did you look at the catalog?

I didn't know that the records catalog existed. That's a useful tool, thanks! Also,

itemtype

looks to be the field that I need, thanks!