```SELECT i item i custitem producttype p name FROM item as NetSuite Professionals #suitescript

```SELECT i.item, i.custitem_producttype, p.name F...

aerin

08/18/2020, 3:48 PM

Copy code

SELECT i.item, i.custitem_producttype, p.name FROM item as i, custlist_item_producttype as p WHERE i.custitem_producttype = p.id

jen

08/18/2020, 6:02 PM

I don’t mean the possible values, I literally just mean which options are set up for which items.

2 Views