AccountCleanInfo

Stores the metadata Data.com Clean uses to determine an account record’s clean status. AccountCleanInfo helps you automate the cleaning or related processing of account records.

Account Clean Info provides a snapshot of the data in your Salesforce account record and its matched Data.com record at the time the Salesforce record was cleaned.

Account Clean Info includes a number of bit vector fields, whose component fields each correspond to individual object fields and provide related data or status information about those fields. For example, the bit vector field IsDifferent has an IsDifferentState field. If the IsDifferentState field’s value is False, that means the State field value is the same on the Salesforce account record and its matched Data.com record.

AccountCleanInfo bit vector fields include:

Their individual bits are defined here.

Supported Calls

describeSObjects()getDeleted()getUpdated()query()retrieve()update()

Fields

Field Name Details
AccountId
Type
reference
Properties
Filter, Group, Sort
Description
The unique, system-generated ID assigned when the account record was created.
AccountSite
Type
string
Properties
Filter, Group, Nillable, Sort
Description
Information about the account’s location, such as single location, headquarters, or branch.
Address
Type
address
Properties
Filter, Nillable
Description
The compound form of the address. Read-only. See Address Compound Fields for details on compound address fields.
AnnualRevenue
Type
currency
Properties
Filter, Nillable, Sort
Description
Estimated annual revenue of the account.
City
Type
string
Properties
Filter, Group, Nillable, Sort
Description
Details for the billing address of the account.
CleanedByJob
Type
boolean
Properties
Filter
Description
Indicates whether the account record was cleaned by a Data.com Clean job (true) or not (false).
CleanedByUser
Type
boolean
Properties
Filter
Description
Indicates whether the account record was cleaned by a Salesforce user (true) or not (false).
CompanyName
Type
string
Properties
Filter, Group, Nillable, Sort
Description
The name of the company.
CompanyStatusDataDotCom
Type
picklist
Properties
Filter, Group, Nillable, Sort
Description
The status of the company per Data.com. Values are: Company is In Business per Data.com or Company is Out of Business per Data.com.
Country
Type
string
Properties
Filter, Group, Nillable, Sort
Description
Details for the billing address of the account.
DandBCompanyDunsNumber
Type
string
Properties
Filter, Group, Nillable, Sort
Description
The D-U-N-S Number on the D&B Company record (if any) that is linked to the account.
DataDotComId
Type
string
Properties
Filter, Group, Nillable, Sort
Description
The ID Data.com maintains for the company.
Description
Type
textarea
Properties
Nillable
Description
A description of the account.
DunsNumber
Type
string
Properties
Filter, Group, Nillable, Sort
Description
The Data Universal Numbering System (D-U-N-S) number is a unique, nine-digit number assigned to every business location in the Dun & Bradstreet database that has a unique, separate, and distinct operation. D-U-N-S numbers are used by industries and organizations around the world as a global standard for business identification and tracking.
DunsRightMatchConfidence
Type
int
Properties
Filter, Group, Nillable, Sort
Description
The account’s DUNSRight confidence code.
DunsRightMatchGrade
Type
string
Properties
Filter, Group, Nillable, Sort
Description
The account’s DUNSRight match grade.
Fax
Type
phone
Properties
Filter, Group, Nillable, Sort
Description
The account’s fax number.
Industry
Type
picklist
Properties
Filter, Group, Nillable, Sort
Description
The industry the account belongs to.
IsDifferentAccountSite
Type
boolean
Properties
Filter
Description
Indicates whether the account’s AccountSite field value is different from the corresponding value on its matched Data.com record (true) or not (false).
IsDifferentAnnualRevenue
Type
boolean
Properties
Filter
Description
Indicates whether the account’s AnnualRevenue field value is different from the corresponding value on its matched Data.com record (true) or not (false).
IsDifferentCity
Type
boolean
Properties
Filter
Description
Indicates whether the account’s City field value is different from the corresponding value on its matched Data.com record (true) or not (false).
IsDifferentCompanyName
Type
boolean
Properties
Filter
Description
Indicates whether the account’s AccountName field value is different from the corresponding value on its matched Data.com record (true) or not (false).
IsDifferentCountry
Type
boolean
Properties
Filter
Description
Indicates whether the account’s Country field value is different from the corresponding value on its matched Data.com record (true) or not (false).
IsDifferentCountryCode
Type
boolean
Properties
Filter
Description
Indicates whether the account’s Country Code field value is different from the corresponding value on its matched Data.com record (true) or not (false).
IsDifferentDandBCompanyDunsNumber
Type
boolean
Properties
Filter
Description
Indicates whether the account’s DandBCompanyID field value is different from the corresponding value on its matched Data.com record (true) or not (false).
IsDifferentDescription
Type
boolean
Properties
Filter
Description
Indicates whether the account’s Description field value is different from the corresponding value on its matched Data.com record (true) or not (false).
IsDifferentDunsNumber
Type
boolean
Properties
Filter
Description
Indicates whether the account’s DunsNumber field value is different from the D-U-N-S Number on its matched Data.com record (true) or not (false).
IsDifferentFax
Type
boolean
Properties
Filter
Description
Indicates whether the account’s Fax field value is different from the corresponding value on its matched Data.com record (true) or not (false).
IsDifferentIndustry
Type
boolean
Properties
Filter
Description
Indicates whether the account’s Industry field value is different from the corresponding value on its matched Data.com record (true) or not (false).
IsDifferentNaicsCode
Type
boolean
Properties
Filter
Description
Indicates whether the account’s NaicsCode field value is different from the corresponding value on its matched Data.com record (true) or not (false).
IsDifferentNaicsDescription
Type
boolean
Properties
Filter
Description
Indicates whether the account’s NaicsDescription field value is different from the corresponding value on its matched Data.com record (true) or not (false).
IsDifferentNumberOfEmployees
Type
boolean
Properties
Filter
Description
Indicates whether the account’s NumberOf Employees field value is different from the corresponding value on its matched Data.com record (true) or not (false).
IsDifferentOwnership
Type
boolean
Properties
Filter
Description
Indicates whether the account’s Ownership field value is different from the corresponding value on its matched Data.com record (true) or not (false).
IsDifferentPhone
Type
boolean
Properties
Filter
Description
Indicates whether the account’s Phone field value is different from the corresponding value on its matched Data.com record (true) or not (false).
IsDifferentPostalCode
Type
boolean
Properties
Filter
Description
Indicates whether the account’s PostalCode field value is different from the corresponding value on its matched Data.com record (true) or not (false).
IsDifferentSic
Type
boolean
Properties
Filter
Description
Indicates whether the account’s Sic field value is different from the corresponding value on its matched Data.com record (true) or not (false).
IsDifferentSicDescription
Type
boolean
Properties
Filter
Description
Indicates whether the account’s SicDescription field value is different from the corresponding value on its matched Data.com record (true) or not (false).
IsDifferentState
Type
boolean
Properties
Filter
Description
Indicates whether the account’s State field value is different from the corresponding value on its matched Data.com record (true) or not (false).
IsDifferentStateCode
Type
boolean
Properties
Filter
Description
Indicates whether the account’s State Code field value is different from the corresponding value on its matched Data.com record (true) or not (false).
IsDifferentStreet
Type
boolean
Properties
Filter
Description
Indicates whether the account’s State field value is different from the corresponding value on its matched Data.com record (true) or not (false).
IsDifferentTickerSymbol
Type
boolean
Properties
Filter
Description
Indicates whether the account’s TickerSymbol field value is different from the corresponding value on its matched Data.com record (true) or not (false).
IsDifferentTradestyle
Type
boolean
Properties
Filter
Description
Indicates whether the account’s Tradestyle field value is different from the corresponding value on its matched Data.com record (true) or not (false).
IsDifferentWebsite
Type
boolean
Properties
Filter
Description
Indicates whether the account’s Website field value is different from the corresponding value on its matched Data.com record (true) or not (false).
IsDifferentYearStarted
Type
boolean
Properties
Filter
Description
Indicates whether the account’s YearStarted field value is different from the corresponding value on its matched Data.com record (true) or not (false).
IsFlaggedWrongAccountSite
Type
boolean
Properties
Filter, Update
Description
Indicates whether the account’s AccountSite field value is flagged as wrong to Data.com (true) or not (false).
IsFlaggedWrongAddress
Type
boolean
Properties
Filter, Update
Description
Indicates whether the account’s Address field value is flagged as wrong to Data.com (true) or not (false).
IsFlaggedWrongAnnualRevenue
Type
boolean
Properties
Filter, Update
Description
Indicates whether the account’s AnnualRevenue field value is flagged as wrong to Data.com (true) or not (false).
IsFlaggedWrongCompanyName
Type
boolean
Properties
Filter, Update
Description
Indicates whether the account’s CompanyName field value is flagged as wrong to Data.com (true) or not (false).
IsFlaggedWrongDescription
Type
boolean
Properties
Filter, Update
Description
Indicates whether the account’s Description field value is flagged as wrong to Data.com (true) or not (false).
IsFlaggedWrongDunsNumber
Type
boolean
Properties
Filter, Update
Description
Indicates whether the account’s DunsNumber field value is flagged as wrong to Data.com (true) or not (false).
IsFlaggedWrongFax
Type
boolean
Properties
Filter, Update
Description
Indicates whether the account’s Fax field value is flagged as wrong to Data.com (true) or not (false).
IsFlaggedWrongIndustry
Type
boolean
Properties
Filter, Update
Description
Indicates whether the account’s Industry field value is flagged as wrong to Data.com (true) or not (false).
IsFlaggedWrongNaicsCode
Type
boolean
Properties
Filter, Update
Description
Indicates whether the account’s NaicsCode field value is flagged as wrong to Data.com (true) or not (false).
IsFlaggedWrongNaicsDescription
Type
boolean
Properties
Filter, Update
Description
Indicates whether the account’s NaicsDescription field value is flagged as wrong to Data.com (true) or not (false).
IsFlaggedWrongNumberOfEmployees
Type
boolean
Properties
Filter, Update
Description
Indicates whether the account’s NumberOfEmployees field value is flagged as wrong to Data.com (true) or not (false).
IsFlaggedWrongOwnership
Type
boolean
Properties
Filter, Update
Description
Indicates whether the account’s Ownership field value is flagged as wrong to Data.com (true) or not (false).
IsFlaggedWrongPhone
Type
boolean
Properties
Filter, Update
Description
Indicates whether the account’s Phone field value is flagged as wrong to Data.com (true) or not (false).
IsFlaggedWrongSic
Type
boolean
Properties
Filter, Update
Description
Indicates whether the account’s Sic field value is flagged as wrong to Data.com (true) or not (false).
IsFlaggedWrongSicDescription
Type
boolean
Properties
Filter, Update
Description
Indicates whether the account’s SicDescription field value is flagged as wrong to Data.com (true) or not (false).
IsFlaggedWrongTickerSymbol
Type
boolean
Properties
Filter, Update
Description
Indicates whether the account’s TickerSymbol field value is flagged as wrong to Data.com (true) or not (false).
IsFlaggedWrongTradestyle
Type
boolean
Properties
Filter, Update
Description
Indicates whether the account’s Tradestyle field value is flagged as wrong to Data.com (true) or not (false).
IsFlaggedWrongWebsite
Type
boolean
Properties
Filter, Update
Description
Indicates whether the account’s Website field value is flagged as wrong to Data.com (true) or not (false).
IsFlaggedWrongYearStarted
Type
boolean
Properties
Filter, Update
Description
Indicates whether the account’s YearStarted field value is flagged as wrong to Data.com (true) or not (false).
IsInactive
Type
boolean
Properties
Defaulted on create, Filter, Group, Sort
Description
Indicates whether the account has been reported to Data.com as Inactive (true) or not (false).
IsReviewedAccountSite
Type
boolean
Properties
Filter, Update
Description
Indicates whether the account’s AccountSite field value is in a Reviewed state (true) or not (false).
IsReviewedAddress
Type
boolean
Properties
Filter, Update
Description
Indicates whether the account’s Address field value is in a Reviewed state (true) or not (false).
IsReviewedAnnualRevenue
Type
boolean
Properties
Filter, Update
Description
Indicates whether the account’s AnnualRevenue field value is in a Reviewed state (true) or not (false).
IsReviewedCompanyName
Type
boolean
Properties
Filter, Update
Description
Indicates whether the account’s CompanyName field value is in a Reviewed state (true) or not (false).
IsReviewedDandBCompanyDunsNumber
Type
boolean
Properties
Filter, Update
Description
Indicates whether the account’s DandBCompanyID field value is in a Reviewed state (true) or not (false).
IsReviewedDescription
Type
boolean
Properties
Filter, Update
Description
Indicates whether the account’s Description field value is in a Reviewed state (true) or not (false).
IsReviewedDunsNumber
Type
boolean
Properties
Filter, Update
Description
Indicates whether the account’s DunsNumber field value is in a Reviewed state (true) or not (false).
IsReviewedFax
Type
boolean
Properties
Filter, Update
Description
Indicates whether the account’s Fax field value is in a Reviewed state (true) or not (false).
IsReviewedIndustry
Type
boolean
Properties
Filter, Update
Description
Indicates whether the account’s Industry field value is in a Reviewed state (true) or not (false).
IsReviewedNaicsCode
Type
boolean
Properties
Filter, Update
Description
Indicates whether the account’s NaicsCode field value is in a Reviewed state (true) or not (false).
IsReviewedNaicsDescription
Type
boolean
Properties
Filter, Update
Description
Indicates whether the account’s NaicsDescription field value is in a Reviewed state (true) or not (false).
IsReviewedNumberOfEmployees
Type
boolean
Properties
Filter, Update
Description
Indicates whether the account’s NumberOfEmployees field value is in a Reviewed state (true) or not (false).
IsReviewedOwnership
Type
boolean
Properties
Filter, Update
Description
Indicates whether the account’s Ownership field value is in a Reviewed state (true) or not (false).
IsReviewedPhone
Type
boolean
Properties
Filter, Update
Description
Indicates whether the account’s Phone field value is in a Reviewed state (true) or not (false).
IsReviewedSic
Type
boolean
Properties
Filter, Update
Description
Indicates whether the account’s Sic field value is in a Reviewed state (true) or not (false).
IsReviewedSicDescription
Type
boolean
Properties
Filter, Update
Description
Indicates whether the account’s SicDescription field value is in a Reviewed state (true) or not (false).
IsReviewedTickerSymbol
Type
boolean
Properties
Filter, Update
Description
Indicates whether the account’s TickerSymbol field value is in a Reviewed state (true) or not (false).
IsReviewedTradestyle
Type
boolean
Properties
Filter, Update
Description
Indicates whether the account’s Tradestyle field value is in a Reviewed state (true) or not (false).
IsReviewedWebsite
Type
boolean
Properties
Filter, Update
Description
Indicates whether the account’s Website field value is in a Reviewed state (true) or not (false).
IsReviewedYearStarted
Type
boolean
Properties
Filter, Update
Description
Indicates whether the account’s YearStarted field value is in a Reviewed state (true) or not (false).
LastMatchedDate
Type
dateTime
Properties
Filter, Sort
Description
The date the account record was last matched and linked to a Data.com record.
LastStatusChangedById
Type
reference
Properties
Filter, Group, Nillable, Sort
Description
The ID of who or what last changed the record’s Clean Status field value: a Salesforce user or a Clean job.
LastStatusChangedDate
Type
dateTime
Properties
Filter, Nillable, Sort
Description
The date on which the record’s Clean Status field value was last changed.
Latitude
Type
double
Properties
Filter, Nillable, Sort
Description
Used with Longitude to specify the precise geolocation of a billing address. Data not currently provided.
Longitude
Type
double
Properties
Filter, Nillable, Sort
Description
Used with Latitude to specify the precise geolocation of a billing address. Data not currently provided.
NaicsCode
Type
string
Properties
Filter, Group, Nillable, Sort
Description
The six-digit North American Industry Classification System (NAICS) code is the standard used by business and government to classify business establishments into industries, according to their economic activity for the purpose of collecting, analyzing, and publishing statistical data related to the U.S. business economy.
NaicsDescription
Type
string
Properties
Filter, Group, Nillable, Sort
Description
A brief description of an organization’s line of business, based on its NAICS code.
Name
Type
string
Properties
Filter, Group, Sort, Update
Description
Field label is Account Clean Info Name. The name of the account. Maximum size is 255 characters.
NumberOfEmployees
Type
int
Properties
Filter, Group, Nillable, Sort
Description
The number of employees working at the account.
Ownership
Type
picklist
Properties
Filter, Group, Nillable, Sort
Description
Ownership type for the account, for example Private, Public, or Subsidiary.
Phone
Type
phone
Properties
Filter, Group, Nillable, Sort
Description
The phone number for the account.
PostalCode
Type
string
Properties
Filter, Group, Nillable, Sort
Description
Details for the billing address of the account.
Sic
Type
string
Properties
Filter, Group, Nillable, Sort
Description
Standard Industrial Classification code of the company’s main business categorization, for example, 57340 for Electronics.
SicDescription
Type
string
Properties
Filter, Group, Nillable, Sort
Description
A brief description of an organization’s line of business, based on its SIC code.
State
Type
string
Properties
Filter, Group, Nillable, Sort
Description
Details for the billing address of the account.
Street
Type
textarea
Properties
Filter, Group, Nillable, Sort
Description
Details for the billing address of the account.
TickerSymbol
Type
string
Properties
Filter, Group, Nillable, Sort
Description
The stock market symbol for the account.
Tradestyle
Type
string
Properties
Filter, Group, Nillable, Sort
Description
A name, different from its legal name, that an organization can use for conducting business. Similar to “Doing business as” (DBA).
Website
Type
url
Properties
Filter, Group, Nillable, Sort
Description
The website of the account.
YearStarted
Type
string
Properties
Filter, Group, Nillable, Sort
Description
The year the company was established or the year when current ownership or management assumed control of the company.

Usage

Administrators can modify a limited set of AccountCleanInfo fields from the Account Clean Info page.

Developers can create triggers that read the Account Clean Info fields to help automate the cleaning or related processing of account records. For example, you might create a trigger that reads the Clean Status field on the Account object. If an account record’s Clean Status field value is Different but the record has no Billing Street value, the trigger could update the record’s status to Not Compared.

Create triggers that read AccountCleanInfo fields to help automate the cleaning or related processing of account records. For example:
  • Keep account records’ status InSync if the only difference from matched records is the Phone format (for example, (415) 353-8000 on the account record versus 415 353 8000 on the matched Data.com record).
    trigger AccountPhoneTrigger on Account (before update) {
    
       for (Account account: Trigger.new) {
           Account oldAccount = Trigger.oldMap.get(account.ID);
           if (account.CleanStatus == 'Different') {
               List <AccountCleanInfo> cleanInfo = [Select Id, IsDifferentPhone, IsReviewedPhone, Phone from AccountCleanInfo where AccountId = :account.Id];
               if (cleanInfo.size() > 0 && cleanInfo[0].IsDifferentPhone && cleanInfo[0].Phone.StartsWith('+')) {
                   // if Data.com phone number is marked Different but starts with ‘+’, ignore this
                   // and set the status to “Reviewed”
                   AccountCleanInfo cleanInfoToUpdate = new AccountCleanInfo();
                   cleanInfoToUpdate.Id = cleanInfo[0].Id;
                   cleanInfoToUpdate.IsReviewedPhone = true;
                   update cleanInfoToUpdate;
                   account.CleanStatus = 'Reviewed';
               }
           }
       }
    }
  • Create a customized set of Industry field values for accounts. Use triggers to map values from fields on imported or cleaned records onto a standard set of values.
  • Read the CleanStatus field value on the Account object. If that value is Different, but a Salesforce record has no street address value, update the record’s status to Not Compared.