Through a SQL query is it possible to determine which record types a custom entity field applies to? For example, I have created a custom entity field that applies to Customer and Vendor but not Employee. Can I tell this through a SQL query? Unlike custom transaction body fields, there’s nothing like “visibleOnTransactions” that I can use AFAIK.

need someone more sql smart than me, but can you check the tables to see if they contain the custentity column?

I would have thought I’d be able to do a

SELECT custentity_my_field FROM entity

but the field is NOT on entity. I might have to try {} catch() {} it and look for

Search error occurred: Unknown identifier 'custentity_my_field'