--- schema_version: "1" id: 848a78aa04443db8ab34f3a4d266caf65a350826996279a3f277a776105a0264 title: AccountCleanInfo collection: legacydeveloper version: current locale: en-us portal_url: https://docs.salesforce.com/legacydeveloper/current/en-us/object_reference/sforce_api_objects_accountcleaninfo.md canonical_url: https://developer.salesforce.com/docs/atlas.en-us.object_reference.meta/object_reference/sforce_api_objects_accountcleaninfo.htm source_site: developer.salesforce.com content_type: documentation content_hash: 73d7366bfd13857370cce3420f574a12e23a3f9c962a2fb53e05dd845331a0fc description: 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. This object is removed in API version 67.0 --- # 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. This object is removed in API version 67.0 ![Note](https://developer.salesforce.com/docs/atlas.en-us.object_reference.meta/object_reference/images/icon_note.png) #### Note When your Data.com Prospector or Data.com Clean contract expires, Data.com features, objects, and fields will be removed from your org. To support customers’ needs around compliance and to remain a leader in trust and privacy, Salesforce removed all contact data from the Data.com service on February 1, 2021. For more information, see [Data.com Prospector and Clean Retirement](https://help.salesforce.com/articleView?id=000270376&language=en_US&type=1 "HTML (New Window)"). 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: - CleanedBy indicates who (a user) or what (a Clean job) cleaned the account record. - IsDifferent indicates whether or not a field on the account record has a value that differs from the corresponding field on the matched Data.com record. - IsFlaggedWrong indicates whether or not a field on the account record has a value that is flagged as wrong to Data.com. - IsReviewed indicates whether or not a field on the account record is in a Reviewed state, which means that the value was reviewed but not accepted. 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](https://developer.salesforce.com/docs/atlas.en-us.object_reference.meta/object_reference/compound_fields_address.htm "Standard addresses—addresses built into standard objects in Salesforce—are accessible in the SOAP API and REST API as an Address, a structured compound data type, as well as individual address elements. If you enabled Custom Address Fields, you can also add custom fields that mimic the standard address field behavior.") 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 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. ## Associated Objects This object has the following associated objects. If the API version isn’t specified, they’re available in the same API versions as this object. Otherwise, they’re available in the specified API version and later. [AccountCleanInfoChangeEvent](https://developer.salesforce.com/docs/atlas.en-us.object_reference.meta/object_reference/sforce_api_associated_objects_change_event.htm "A ChangeEvent object is available for each object that supports Change Data Capture. You can subscribe to a stream of change events using Change Data Capture to receive data tied to record changes in Salesforce. Changes include record creation, updates to an existing record, deletion of a record, and undeletion of a record. A change event isn’t a Salesforce object—it doesn’t support CRUD operations or queries. It’s included in the object reference so you can discover which Salesforce objects support change events.") (API version 62.0) Change events are available for the object.