I know how to join to the map tables for multiselects. This is unrelated to that.

ITEM OPTIONS

it’s a standard built in netsuite thing

Screenshot 2024-08-22 at 5.21.04 PM.png

image.png,image.png,image.png

Just because your account happens to have one item option that is of type List/Record doesn’t help me. I’m trying to get the list of ALL Item Options that you see listed on the Transaction Item Options page. These are stored in the table

customfield

along with all other types of custom fields (Transaction Line Fields, Transaction Column Fields, Entity fields, CRM fields, etc).

I can easily identify the group of fields that includes Item Options and Transaction Line Fields because all start with

custcol_

. What I cannot do is easily tell which is which, or which apply to which items, using SuiteQL.

this is a false statement. Just like other custom fields, transaction item options can be many different field types, such as text, integer, currency, date, etc.