hi all. I'm a developer / data guy. My company pulls NS data out of the API and into Snowflake tables using a replication tool. I need to query it. Currently I'm working on a query against Customers that needs to include who created the customer record. I have figured out that this will come from the SYSTEM_NOTES table and will need to join to the NOTETYPE table. I know I need to filter on the OPERATION field to look for Created. The problem is the final link, which is from SYSTEM_NOTES to CUSTOMERS. There are fields called RECORD_ID and RECORD_TYPE_ID on SYSTEM_NOTES. I assume RECORD_ID is the ID of the linked record and RECORD_TYPE_ID indicates whether it's a customer, vendor, etc. Unfortunately, what I can't find is a table that corresponds to RECORD_TYPE_ID or any documentation of what the values mean. So I don't know how to filter for customers. Can anyone point me in the right direction to figure this out?

I'm more functional than dev/data lol so for me, I'd have a "created by" field store value on all transactions. For the existing ones, I will do a search to find the author, and csv import to fill that author in the "created by" field for all existing transactions. Then I'd also create a workflow to auto-populate the "created by" to whoever hit the "save" button, for all future transactions. In that case I worry less about those joins etc.

thanks April. I'd like to try to use the existing functionality rather than go build all that extra stuff, though. what I really want is to know what all the record types mean in case we need to use it again in the future.

gotcha. If I remember right, the record type ID is the circled "internal" ID for each record type when you go to the record browser: https://www.netsuite.com/help/helpcenter/en_US/srbrowser/Browser2016_1/script/record/salesorder.html

customization - > lists -> record types, to see internal ID for each record type you have

@April Wu unfortunately, the value on the Record Browser is a text string and I need the numeric ID

numeric ID is in link i sent

@Rob Cady yep, I was about to respond to you

you have to turn on show internal IDs in set preferences to see them in first message

ok, got it on the internal ID. but customer is still not showing up in the list. do I need to do something to see entities of that type?

I believe that list is for non native record types, for example custom ones or ones from a bundle

oh ok. can I see that for native types?

Give that blog post a read may point you into the right direction

ok will do

I think -2 is what you want to use for customer record type ID

yeah but notice this: I queried the table grouping by record_type_id to get the counts of how many times each record_type_id appears in the table. this list is sorted by record_type_id. there are no -2s.

I wonder if it's unique for each environment

that seems inefficient but likely

found another suite ID that says the same thing, -2.

huh. either it's environment-specific or there's something wrong with our environment