Community
Showing results for 
Search instead for 
Do you mean 
Reply

Table name holding custom fields for contact entity

Copper Contributor
Posts: 28
Country: United_Kingdom

Table name holding custom fields for contact entity

I'm trying to locate the table which holds user added fields for the contact record.  I've looked at all the contact tables ( i.e dbo_CONTACT_SOURCE etc) but none of these hold user created fields.  Can anyone suggest a table name where they might be ?

Thanks.

 

Copper Contributor
Posts: 28
Country: United_Kingdom

Re: Table name holding custom fields for contact entity

Sorry - I've noticed they appear at the end of the standard contact fileds in dbo_TBL_CONTACT.   For example  CUST_ContactStatus_1233456789     where 12345...  etc seems to be a random generated string.  The field is created as "Contact Status".   I was fearful there might have been some more complex approach to storing custom fields.