CRM Custom Account Field Help

(0) Share

Report

Posted on by Community Member

So my question is a bit of a weird one so bare with me. I have in our database some fields that I cant find anywhere in the CRM system. I am pretty sure that they are part of the account entity and they are custom fields that have been made, but I just cant find them anywhere. Any ideas of where I should look to figure out what and where they are? In the database they look like this:

[AccountBase].[dt_CertCharter],

[AccountBase].[dt_TotalDeposits],

[AccountBase].[dt_ContractDuration],

[AccountBase].[dt_GoLiveDate],

[AccountBase].[dt_FullRampDate]

any guidance as to where I could figure out what these are, where they are and what they might do would be extremely helpful. Thanks!

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (2)

Verified answer

tw0sh3ds 5,600 on at

Like (0)

Report

Hi,

Go to settings -> Customizations -> Customize the system. On the left pane choose Entities -> account -> fields. Sort the view by SchemaName. You should find your fields dt_XXXX there. When you click on the field and click "Show Dependencies" you will see where this field is used - on the view, form etc.

If the fields are not there, somebody probably played with CRM database in unsupported way.

Was this reply helpful? Yes No
Wayne Walton 13,730 on at

Like (1)

Report

Along with what Pawel mentioned, did you ever have a managed solution in your CRM system that you removed? From a company with "DT" in their name? That might help point to what's going on.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

yeah that is where i thought that they would be too. but the weird thing is that they aren't listed there. Have any other ideas of where they might be?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

dt is our company name, i am thinking that they might have been removed by the CRM admin before me, but am just having a hard time actually finding out what and where this is. It isn't where Pawel suggested unfortunately.

Was this reply helpful? Yes No
Verified answer

tw0sh3ds 5,600 on at

Like (0)

Report

Please also check the "AttributeLogicalView" view. If you can't find this names there then for sure they are not in CRM. Maybe it's like Wayne suggested, that there was managed solution which was uninstalled (but this should also remove the columns from DB).

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

ok great sounds good. Thanks for your help!

Was this reply helpful? Yes No