ADO.NET Provider for Salesforce

Build 25.0.9434

AccountCleanInfo

Schema file for AccountCleanInfo.

Columns

Name Type ReadOnly References Description
Id [KEY] String True

Unique identifier for the record.

IsDeleted Bool True

Indicates whether the record has been moved to the Recycle Bin.

Name String False

Name of the record.

CurrencyIsoCode String False

ISO code for the currency in which the revenue amount is expressed.

CreatedDate Datetime True

Date and time when the record was created.

CreatedById String True

User.Id

ID of the user who created the record.

LastModifiedById String True

User.Id

ID of the user who last modified the record.

AccountId String True

Account.Id

ID of the Account associated with this record.

LastMatchedDate Datetime True

Date associated with LastMatched.

LastStatusChangedDate Datetime True

Date associated with LastStatusChanged.

LastStatusChangedById String True

User.Id

ID of the LastStatusChangedBy associated with this record.

IsInactive Bool False

Indicates whether the record has the Inactive characteristic.

CompanyName String True

Field containing CompanyName information.

Phone String True

Phone number for the contact or account.

Street String True

Street address.

City String True

City portion of the address.

State String True

State or province portion of the address.

PostalCode String True

Postal code portion of the address.

Country String True

Country portion of the address.

Latitude Double True

Used with Longitude to specify the precise geolocation of an address.

Longitude Double True

Used with Latitude to specify the precise geolocation of an address.

GeocodeAccuracy String True

Accuracy level of the geocode for the address.

Website String True

Website URL for this account.

TickerSymbol String True

The stock market symbol for the account.

AnnualRevenue Decimal True

Estimated annual revenue of the account.

NumberOfEmployees Int True

Number of employees working at the company represented by this account.

Industry String True

Industry that the account belongs to.

Ownership String True

Ownership type for the account.

DunsNumber String True

The Data Universal Number System (D-U-N-S) number is a nine-digit number assigned to companies by Dun & Bradstreet.

Sic String True

Standard Industrial Classification code of the company's main business categorization.

SicDescription String True

Field containing SicDescription information.

NaicsCode String True

Field containing NaicsCode information.

NaicsDescription String True

Field containing NaicsDescription information.

YearStarted String True

Field containing YearStarted information.

Fax String True

Fax number for the contact or account.

AccountSite String True

Field containing AccountSite information.

Description String True

Text description of the record.

Tradestyle String True

Field containing Tradestyle information.

DandBCompanyDunsNumber String True

DandBCompanyDuns identification number.

DunsRightMatchGrade String True

Field containing DunsRightMatchGrade information.

DunsRightMatchConfidence Int True

Field containing DunsRightMatchConfidence information.

CompanyStatusDataDotCom String True

Field containing CompanyStatusDataDotCom information.

IsReviewedCompanyName Bool False

Indicates whether the record has the ReviewedCompanyName characteristic.

IsReviewedPhone Bool False

Indicates whether the record has the ReviewedPhone characteristic.

IsReviewedAddress Bool False

Indicates whether the record has the ReviewedAddress characteristic.

IsReviewedWebsite Bool False

Indicates whether the record has the ReviewedWebsite characteristic.

IsReviewedTickerSymbol Bool False

Indicates whether the record has the ReviewedTickerSymbol characteristic.

IsReviewedAnnualRevenue Bool False

Indicates whether the record has the ReviewedAnnualRevenue characteristic.

IsReviewedNumberOfEmployees Bool False

Indicates whether the record has the ReviewedNumberOfEmployees characteristic.

IsReviewedIndustry Bool False

Indicates whether the record has the ReviewedIndustry characteristic.

IsReviewedOwnership Bool False

Indicates whether the record has the ReviewedOwnership characteristic.

IsReviewedDunsNumber Bool False

Indicates whether the record has the ReviewedDunsNumber characteristic.

IsReviewedSic Bool False

Indicates whether the record has the ReviewedSic characteristic.

IsReviewedSicDescription Bool False

Indicates whether the record has the ReviewedSicDescription characteristic.

IsReviewedNaicsCode Bool False

Indicates whether the record has the ReviewedNaicsCode characteristic.

IsReviewedNaicsDescription Bool False

Indicates whether the record has the ReviewedNaicsDescription characteristic.

IsReviewedYearStarted Bool False

Indicates whether the record has the ReviewedYearStarted characteristic.

IsReviewedFax Bool False

Indicates whether the record has the ReviewedFax characteristic.

IsReviewedAccountSite Bool False

Indicates whether the record has the ReviewedAccountSite characteristic.

IsReviewedDescription Bool False

Indicates whether the record has the ReviewedDescription characteristic.

IsReviewedTradestyle Bool False

Indicates whether the record has the ReviewedTradestyle characteristic.

IsReviewedDandBCompanyDunsNumber Bool False

Indicates whether the record has the ReviewedDandBCompanyDunsNumber characteristic.

IsDifferentCompanyName Bool True

Indicates whether the record has the DifferentCompanyName characteristic.

IsDifferentPhone Bool True

Indicates whether the record has the DifferentPhone characteristic.

IsDifferentStreet Bool True

Indicates whether the record has the DifferentStreet characteristic.

IsDifferentCity Bool True

Indicates whether the record has the DifferentCity characteristic.

IsDifferentState Bool True

Indicates whether the record has the DifferentState characteristic.

IsDifferentPostalCode Bool True

Indicates whether the record has the DifferentPostalCode characteristic.

IsDifferentCountry Bool True

Indicates whether the record has the DifferentCountry characteristic.

IsDifferentWebsite Bool True

Indicates whether the record has the DifferentWebsite characteristic.

IsDifferentTickerSymbol Bool True

Indicates whether the record has the DifferentTickerSymbol characteristic.

IsDifferentAnnualRevenue Bool True

Indicates whether the record has the DifferentAnnualRevenue characteristic.

IsDifferentNumberOfEmployees Bool True

Indicates whether the record has the DifferentNumberOfEmployees characteristic.

IsDifferentIndustry Bool True

Indicates whether the record has the DifferentIndustry characteristic.

IsDifferentOwnership Bool True

Indicates whether the record has the DifferentOwnership characteristic.

IsDifferentDunsNumber Bool True

Indicates whether the record has the DifferentDunsNumber characteristic.

IsDifferentSic Bool True

Indicates whether the record has the DifferentSic characteristic.

IsDifferentSicDescription Bool True

Indicates whether the record has the DifferentSicDescription characteristic.

IsDifferentNaicsCode Bool True

Indicates whether the record has the DifferentNaicsCode characteristic.

IsDifferentNaicsDescription Bool True

Indicates whether the record has the DifferentNaicsDescription characteristic.

IsDifferentYearStarted Bool True

Indicates whether the record has the DifferentYearStarted characteristic.

IsDifferentFax Bool True

Indicates whether the record has the DifferentFax characteristic.

IsDifferentAccountSite Bool True

Indicates whether the record has the DifferentAccountSite characteristic.

IsDifferentDescription Bool True

Indicates whether the record has the DifferentDescription characteristic.

IsDifferentTradestyle Bool True

Indicates whether the record has the DifferentTradestyle characteristic.

IsDifferentDandBCompanyDunsNumber Bool True

Indicates whether the record has the DifferentDandBCompanyDunsNumber characteristic.

IsDifferentStateCode Bool True

Indicates whether the record has the DifferentStateCode characteristic.

IsDifferentCountryCode Bool True

Indicates whether the record has the DifferentCountryCode characteristic.

CleanedByJob Bool True

Field containing CleanedByJob information.

CleanedByUser Bool True

Field containing CleanedByUser information.

IsFlaggedWrongCompanyName Bool False

Indicates whether the record has the FlaggedWrongCompanyName characteristic.

IsFlaggedWrongPhone Bool False

Indicates whether the record has the FlaggedWrongPhone characteristic.

IsFlaggedWrongAddress Bool False

Indicates whether the record has the FlaggedWrongAddress characteristic.

IsFlaggedWrongWebsite Bool False

Indicates whether the record has the FlaggedWrongWebsite characteristic.

IsFlaggedWrongTickerSymbol Bool False

Indicates whether the record has the FlaggedWrongTickerSymbol characteristic.

IsFlaggedWrongAnnualRevenue Bool False

Indicates whether the record has the FlaggedWrongAnnualRevenue characteristic.

IsFlaggedWrongNumberOfEmployees Bool False

Indicates whether the record has the FlaggedWrongNumberOfEmployees characteristic.

IsFlaggedWrongIndustry Bool False

Indicates whether the record has the FlaggedWrongIndustry characteristic.

IsFlaggedWrongOwnership Bool False

Indicates whether the record has the FlaggedWrongOwnership characteristic.

IsFlaggedWrongDunsNumber Bool False

Indicates whether the record has the FlaggedWrongDunsNumber characteristic.

IsFlaggedWrongSic Bool False

Indicates whether the record has the FlaggedWrongSic characteristic.

IsFlaggedWrongSicDescription Bool False

Indicates whether the record has the FlaggedWrongSicDescription characteristic.

IsFlaggedWrongNaicsCode Bool False

Indicates whether the record has the FlaggedWrongNaicsCode characteristic.

IsFlaggedWrongNaicsDescription Bool False

Indicates whether the record has the FlaggedWrongNaicsDescription characteristic.

IsFlaggedWrongYearStarted Bool False

Indicates whether the record has the FlaggedWrongYearStarted characteristic.

IsFlaggedWrongFax Bool False

Indicates whether the record has the FlaggedWrongFax characteristic.

IsFlaggedWrongAccountSite Bool False

Indicates whether the record has the FlaggedWrongAccountSite characteristic.

IsFlaggedWrongDescription Bool False

Indicates whether the record has the FlaggedWrongDescription characteristic.

IsFlaggedWrongTradestyle Bool False

Indicates whether the record has the FlaggedWrongTradestyle characteristic.

DataDotComId String True

ID of the DataDotCom associated with this record.

SOQL String False

Specifies the SOQL query to execute against the Salesforce servers. If this pseudo column is set from the WHERE clause it will take precedence over the original query.

ExternalIdColumn String False

Specifies the external Id column to use if performing an insert. If this value is specified, upsert will be used when the INSERT command is called.

FilterScope String False

Optional scope to limit the records returned from queries. This property can take one of these values: Delegated, Everything, Mine, MineAndMyGroups, My_Territory, My_Team_Territory, or Team.

SystemModstamp Datetime True

Date and time when the record was last modified by a user or by an automated process.

LastModifiedDate Datetime True

Date and time when the record was last modified.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434