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:
CleanedByindicates who (a user) or what (a Clean job) cleaned the account record.IsDifferentindicates whether or not a field on the account record has a value that differs from the corresponding field on the matched Data.com record.IsFlaggedWrongindicates whether or not a field on the account record has a value that is flagged as wrong to Data.com.IsReviewedindicates whether or not a field on the account record is in aReviewedstate, which means that the value was reviewed but not accepted.
Their individual bits are defined here.
Introduced in API version 29.0.
This object is removed in API version 67.0
describeSObjects(), getDeleted(), getUpdated(), query(), retrieve(), update()
- Type: reference
- Properties: Filter, Group, Sort
- Description: The unique, system-generated ID assigned when the account record was created.
- Relationship name: Account
- Relationship type: masterdetail
- Refers to: Account
- Type: string
- Properties: Filter, Group, Nillable, Sort
- Description: Information about the account’s location, such as single location, headquarters, or branch.
- Type: address
- Properties: Filter, Nillable
- Description: The compound form of the address. Read-only. See Address Compound Fields for details on compound address fields.
- Type: currency
- Properties: Filter, Nillable, Sort
- Description: Estimated annual revenue of the account.
- Type: string
- Properties: Filter, Group, Nillable, Sort, Update
- Description: Details for the billing address of the account.
- Type: boolean
- Properties: Filter
- Description: Indicates whether the account record was cleaned by a Data.com Clean job (
true) or not (false).
- Type: boolean
- Properties: Filter
- Description: Indicates whether the account record was cleaned by a Salesforce user (
true) or not (false).
- Type: string
- Properties: Filter, Group, Nillable, Sort
- Description: The name of the company.
- Type: picklist
- Properties: Filter, Group, Nillable, Restricted picklist, Sort
- Description: The status of the company per Data.com. Values are:
Company is In Business per Data.comorCompany is Out of Business per Data.com.
- Type: string
- Properties: Filter, Group, Nillable, Sort, Update
- Description: Details for the billing address of the account.
- Type: string
- Properties: Filter, Group, Nillable, Sort, Update
- 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.
- Type: string
- Properties: Filter, Group, Nillable, Sort
- Description: The ID Data.com maintains for the company.
- Type: textarea
- Properties: Nillable
- Description: A description of the account.
- 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.
- Type: int
- Properties: Filter, Group, Nillable, Sort
- Description: The account’s DUNSRight confidence code.
- Type: string
- Properties: Filter, Group, Nillable, Sort
- Description: The account’s DUNSRight match grade.
- Type: phone
- Properties: Filter, Group, Nillable, Sort
- Description: The account’s fax number.
- Type: picklist
- Properties: Filter, Group, Nillable, Restricted picklist, Sort, Update
- Type: picklist
- Properties: Filter, Group, Nillable, Sort
- Description: The industry the account belongs to.
- Type: boolean
- Properties: Filter
- Description: Indicates whether the account’s
AccountSitefield value is different from the corresponding value on its matched Data.com record (true) or not (false).
- Type: boolean
- Properties: Filter
- Description: Indicates whether the account’s
AnnualRevenuefield value is different from the corresponding value on its matched Data.com record (true) or not (false).
- Type: boolean
- Properties: Filter
- Description: Indicates whether the account’s
Cityfield value is different from the corresponding value on its matched Data.com record (true) or not (false).
- Type: boolean
- Properties: Filter
- Description: Indicates whether the account’s
AccountNamefield value is different from the corresponding value on its matched Data.com record (true) or not (false).
- Type: boolean
- Properties: Filter
- Description: Indicates whether the account’s
Countryfield value is different from the corresponding value on its matched Data.com record (true) or not (false).
- Type: boolean
- Properties: Filter
- Description: Indicates whether the account’s
Country Codefield value is different from the corresponding value on its matched Data.com record (true) or not (false).
- Type: boolean
- Properties: Filter
- Description: Indicates whether the account’s
DandBCompanyIDfield value is different from the corresponding value on its matched Data.com record (true) or not (false).
- Type: boolean
- Properties: Filter
- Description: Indicates whether the account’s
Descriptionfield value is different from the corresponding value on its matched Data.com record (true) or not (false).
- Type: boolean
- Properties: Filter
- Description: Indicates whether the account’s
DunsNumberfield value is different from the D-U-N-S Number on its matched Data.com record (true) or not (false).
- Type: boolean
- Properties: Filter
- Description: Indicates whether the account’s
Faxfield value is different from the corresponding value on its matched Data.com record (true) or not (false).
- Type: boolean
- Properties: Filter
- Description: Indicates whether the account’s
Industryfield value is different from the corresponding value on its matched Data.com record (true) or not (false).
- Type: boolean
- Type: boolean
- Properties: Filter
- Description: Indicates whether the account’s
NaicsCodefield value is different from the corresponding value on its matched Data.com record (true) or not (false).
- Type: boolean
- Properties: Filter
- Description: Indicates whether the account’s
NaicsDescriptionfield value is different from the corresponding value on its matched Data.com record (true) or not (false).
- Type: boolean
- Properties: Filter
- Description: Indicates whether the account’s
NumberOf Employeesfield value is different from the corresponding value on its matched Data.com record (true) or not (false).
- Type: boolean
- Properties: Filter
- Description: Indicates whether the account’s
Ownershipfield value is different from the corresponding value on its matched Data.com record (true) or not (false).
- Type: boolean
- Properties: Filter
- Description: Indicates whether the account’s
Phonefield value is different from the corresponding value on its matched Data.com record (true) or not (false).
- Type: boolean
- Properties: Filter
- Description: Indicates whether the account’s
PostalCodefield value is different from the corresponding value on its matched Data.com record (true) or not (false).
- Type: boolean
- Properties: Filter
- Description: Indicates whether the account’s
Sicfield value is different from the corresponding value on its matched Data.com record (true) or not (false).
- Type: boolean
- Properties: Filter
- Description: Indicates whether the account’s
SicDescriptionfield value is different from the corresponding value on its matched Data.com record (true) or not (false).
- Type: boolean
- Properties: Filter
- Description: Indicates whether the account’s
Statefield value is different from the corresponding value on its matched Data.com record (true) or not (false).
- Type: boolean
- Properties: Filter
- Description: Indicates whether the account’s
State Codefield value is different from the corresponding value on its matched Data.com record (true) or not (false).
- Type: boolean
- Properties: Filter
- Description: Indicates whether the account’s
Statefield value is different from the corresponding value on its matched Data.com record (true) or not (false).
- Type: boolean
- Properties: Filter
- Description: Indicates whether the account’s
TickerSymbolfield value is different from the corresponding value on its matched Data.com record (true) or not (false).
- Type: boolean
- Properties: Filter
- Description: Indicates whether the account’s
Tradestylefield value is different from the corresponding value on its matched Data.com record (true) or not (false).
- Type: boolean
- Properties: Filter
- Description: Indicates whether the account’s
Websitefield value is different from the corresponding value on its matched Data.com record (true) or not (false).
- Type: boolean
- Properties: Filter
- Description: Indicates whether the account’s
YearStartedfield value is different from the corresponding value on its matched Data.com record (true) or not (false).
- Type: boolean
- Properties: Filter, Update
- Description: Indicates whether the account’s
AccountSitefield value is flagged as wrong to Data.com (true) or not (false).
- Type: boolean
- Properties: Filter, Update
- Description: Indicates whether the account’s
Addressfield value is flagged as wrong to Data.com (true) or not (false).
- Type: boolean
- Properties: Filter, Update
- Description: Indicates whether the account’s
AnnualRevenuefield value is flagged as wrong to Data.com (true) or not (false).
- Type: boolean
- Properties: Filter, Update
- Description: Indicates whether the account’s
CompanyNamefield value is flagged as wrong to Data.com (true) or not (false).
- Type: boolean
- Properties: Filter, Update
- Description: Indicates whether the account’s
Descriptionfield value is flagged as wrong to Data.com (true) or not (false).
- Type: boolean
- Properties: Filter, Update
- Description: Indicates whether the account’s
DunsNumberfield value is flagged as wrong to Data.com (true) or not (false).
- Type: boolean
- Properties: Filter, Update
- Description: Indicates whether the account’s
Faxfield value is flagged as wrong to Data.com (true) or not (false).
- Type: boolean
- Properties: Filter, Update
- Description: Indicates whether the account’s
Industryfield value is flagged as wrong to Data.com (true) or not (false).
- Type: boolean
- Properties: Filter, Update
- Description: Indicates whether the account’s
NaicsCodefield value is flagged as wrong to Data.com (true) or not (false).
- Type: boolean
- Properties: Filter, Update
- Description: Indicates whether the account’s
NaicsDescriptionfield value is flagged as wrong to Data.com (true) or not (false).
- Type: boolean
- Properties: Filter, Update
- Description: Indicates whether the account’s
NumberOfEmployeesfield value is flagged as wrong to Data.com (true) or not (false).
- Type: boolean
- Properties: Filter, Update
- Description: Indicates whether the account’s
Ownershipfield value is flagged as wrong to Data.com (true) or not (false).
- Type: boolean
- Properties: Filter, Update
- Description: Indicates whether the account’s
Phonefield value is flagged as wrong to Data.com (true) or not (false).
- Type: boolean
- Properties: Filter, Update
- Description: Indicates whether the account’s
Sicfield value is flagged as wrong to Data.com (true) or not (false).
- Type: boolean
- Properties: Filter, Update
- Description: Indicates whether the account’s
SicDescriptionfield value is flagged as wrong to Data.com (true) or not (false).
- Type: boolean
- Properties: Filter, Update
- Description: Indicates whether the account’s
TickerSymbolfield value is flagged as wrong to Data.com (true) or not (false).
- Type: boolean
- Properties: Filter, Update
- Description: Indicates whether the account’s
Tradestylefield value is flagged as wrong to Data.com (true) or not (false).
- Type: boolean
- Properties: Filter, Update
- Description: Indicates whether the account’s
Websitefield value is flagged as wrong to Data.com (true) or not (false).
- Type: boolean
- Properties: Filter, Update
- Description: Indicates whether the account’s
YearStartedfield value is flagged as wrong to Data.com (true) or not (false).
- Type: boolean
- Properties: Defaulted on create, Filter, Group, Sort, Update
- Description: Indicates whether the account has been reported to Data.com as
Inactive(true) or not (false). - Default value: false
- Type: boolean
- Properties: Filter, Update
- Description: Indicates whether the account’s
AccountSitefield value is in aReviewedstate (true) or not (false).
- Type: boolean
- Properties: Filter, Update
- Description: Indicates whether the account’s
Addressfield value is in aReviewedstate (true) or not (false).
- Type: boolean
- Properties: Filter, Update
- Description: Indicates whether the account’s
AnnualRevenuefield value is in aReviewedstate (true) or not (false).
- Type: boolean
- Properties: Filter, Update
- Description: Indicates whether the account’s
CompanyNamefield value is in aReviewedstate (true) or not (false).
- Type: boolean
- Properties: Filter, Update
- Description: Indicates whether the account’s
DandBCompanyIDfield value is in aReviewedstate (true) or not (false).
- Type: boolean
- Properties: Filter, Update
- Description: Indicates whether the account’s
Descriptionfield value is in aReviewedstate (true) or not (false).
- Type: boolean
- Properties: Filter, Update
- Description: Indicates whether the account’s
DunsNumberfield value is in aReviewedstate (true) or not (false).
- Type: boolean
- Properties: Filter, Update
- Description: Indicates whether the account’s
Faxfield value is in aReviewedstate (true) or not (false).
- Type: boolean
- Properties: Filter, Update
- Description: Indicates whether the account’s
Industryfield value is in aReviewedstate (true) or not (false).
- Type: boolean
- Type: boolean
- Properties: Filter, Update
- Description: Indicates whether the account’s
NaicsCodefield value is in aReviewedstate (true) or not (false).
- Type: boolean
- Properties: Filter, Update
- Description: Indicates whether the account’s
NaicsDescriptionfield value is in aReviewedstate (true) or not (false).
- Type: boolean
- Properties: Filter, Update
- Description: Indicates whether the account’s
NumberOfEmployeesfield value is in aReviewedstate (true) or not (false).
- Type: boolean
- Properties: Filter, Update
- Description: Indicates whether the account’s
Ownershipfield value is in aReviewedstate (true) or not (false).
- Type: boolean
- Properties: Filter, Update
- Description: Indicates whether the account’s
Phonefield value is in aReviewedstate (true) or not (false).
- Type: boolean
- Properties: Filter, Update
- Description: Indicates whether the account’s
Sicfield value is in aReviewedstate (true) or not (false).
- Type: boolean
- Properties: Filter, Update
- Description: Indicates whether the account’s
SicDescriptionfield value is in aReviewedstate (true) or not (false).
- Type: boolean
- Properties: Filter, Update
- Description: Indicates whether the account’s
TickerSymbolfield value is in aReviewedstate (true) or not (false).
- Type: boolean
- Properties: Filter, Update
- Description: Indicates whether the account’s
Tradestylefield value is in aReviewedstate (true) or not (false).
- Type: boolean
- Properties: Filter, Update
- Description: Indicates whether the account’s
Websitefield value is in aReviewedstate (true) or not (false).
- Type: boolean
- Properties: Filter, Update
- Description: Indicates whether the account’s
YearStartedfield value is in aReviewedstate (true) or not (false).
- Type: datetime
- Properties: Filter, Sort
- Description: The date the account record was last matched and linked to a Data.com record.
- Type: reference
- Properties: Filter, Group, Nillable, Sort
- Description: The ID of who or what last changed the record’s
Clean Statusfield value: a Salesforce user or a Clean job. - Relationship name: LastStatusChangedBy
- Relationship type: relationship
- Refers to: User
- Type: datetime
- Properties: Filter, Nillable, Sort
- Description: The date on which the record’s
Clean Statusfield value was last changed.
- Type: double
- Properties: Filter, Nillable, Sort, Update
- Description: Used with
Longitudeto specify the precise geolocation of a billing address. Data not currently provided.
- Type: double
- Properties: Filter, Nillable, Sort, Update
- Description: Used with
Latitudeto specify the precise geolocation of a billing address. Data not currently provided.
- 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.
- Type: string
- Properties: Filter, Group, Nillable, Sort
- Description: A brief description of an organization’s line of business, based on its NAICS code.
- Type: string
- Properties: Filter, Group, idLookup, Sort, Update
- Description: Field label is Account Clean Info Name. The name of the account. Maximum size is 255 characters.
- Type: int
- Properties: Filter, Group, Nillable, Sort
- Description: The number of employees working at the account.
- Type: picklist
- Properties: Filter, Group, Nillable, Sort
- Description: Ownership type for the account, for example Private, Public, or Subsidiary.
- Type: phone
- Properties: Filter, Group, Nillable, Sort
- Description: The phone number for the account.
- Type: string
- Properties: Filter, Group, Nillable, Sort, Update
- Description: Details for the billing address of the account.
- Type: string
- Properties: Filter, Group, Nillable, Sort
- Description: Standard Industrial Classification code of the company’s main business categorization, for example, 57340 for Electronics.
- Type: string
- Properties: Filter, Group, Nillable, Sort
- Description: A brief description of an organization’s line of business, based on its SIC code.
- Type: string
- Properties: Filter, Group, Nillable, Sort, Update
- Description: Details for the billing address of the account.
- Type: string
- Properties: Filter, Group, Nillable, Sort, Update
- Type: textarea
- Properties: Filter, Group, Nillable, Sort, Update
- Description: Details for the billing address of the account.
- Type: string
- Properties: Filter, Group, Nillable, Sort
- Description: The stock market symbol for the account.
- 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).
- Type: url
- Properties: Filter, Group, Nillable, Sort
- Description: The website of the account.
- 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.
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
InSyncif the only difference from matched records is thePhoneformat (for example,(415) 353-8000on the account record versus415 353 8000on the matched Data.com record). - Create a customized set of
Industryfield values for accounts. Use triggers to map values from fields on imported or cleaned records onto a standard set of values. - Read the
CleanStatusfield value on the Account object. If that value isDifferent, but a Salesforce record has no street address value, update the record’s status toNot Compared.
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.
- AccountCleanInfoChangeEvent: Introduced in API version 62.0.