# AccountCleanInfo: Account Clean Info - Name: `AccountCleanInfo` - Catalog: `Salesforce` - Schema: `Salesforce` - Primary Keys: `id` - Label: Account Clean Info ## Table Columns The columns of the table `AccountCleanInfo` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `AccountId` | `string` | Account ID | ☐ | | | `AccountSite` | `string` | Account Site | ☐ | | | `AnnualRevenue` | `decimal` | Annual Revenue | ☐ | | | `City` | `string` | City | ☐ | | | `CleanedByJob` | `boolean` | Cleaned by Job | ☐ | | | `CleanedByUser` | `boolean` | Cleaned by User | ☐ | | | `CompanyName` | `string` | Company Name | ☐ | | | `CompanyStatusDataDotCom` | `string` | Company Status Data.com | ☐ | | | `Country` | `string` | Country | ☐ | | | `CreatedById` | `string` | Created by ID | ☐ | | | `CreatedDate` | `datetime` | Date Created | ☐ | | | `DandBCompanyDunsNumber` | `string` | D&B Company DUNS Number | ☐ | | | `DataDotComId` | `string` | Data.com ID | ☐ | | | `Description` | `string` | Description | ☐ | | | `DunsNumber` | `string` | DUNS Number | ☐ | | | `DunsRightMatchConfidence` | `int32` | DUNS Right Match Confidence | ☐ | | | `DunsRightMatchGrade` | `string` | DUNS Right Match Grade | ☐ | | | `Fax` | `string` | Fax | ☐ | | | `GeocodeAccuracy` | `string` | Geocode Accuracy | ☐ | | | `Id` | `string` | ID | ☐ | | | `Industry` | `string` | Industry | ☐ | | | `IsDeleted` | `boolean` | Is Deleted | ☐ | | | `IsDifferentAccountSite` | `boolean` | Is Different Account Site | ☐ | | | `IsDifferentAnnualRevenue` | `boolean` | Is Different Annual Revenue | ☐ | | | `IsDifferentCity` | `boolean` | Is Different City | ☐ | | | `IsDifferentCompanyName` | `boolean` | Is Different Company Name | ☐ | | | `IsDifferentCountry` | `boolean` | Is Different Country | ☐ | | | `IsDifferentCountryCode` | `boolean` | Is Different Country Code | ☐ | | | `IsDifferentDandBCompanyDunsNumber` | `boolean` | Is Different D&B Company DUNS Number | ☐ | | | `IsDifferentDescription` | `boolean` | Is Different Description | ☐ | | | `IsDifferentDunsNumber` | `boolean` | Is Different DUNS Number | ☐ | | | `IsDifferentFax` | `boolean` | Is Different Fax | ☐ | | | `IsDifferentIndustry` | `boolean` | Is Different Industry | ☐ | | | `IsDifferentNaicsCode` | `boolean` | Is Different NAICS Code | ☐ | | | `IsDifferentNaicsDescription` | `boolean` | Is Different NAICS Description | ☐ | | | `IsDifferentNumberOfEmployees` | `boolean` | Is Different Number of Employees | ☐ | | | `IsDifferentOwnership` | `boolean` | Is Different Ownership | ☐ | | | `IsDifferentPhone` | `boolean` | Is Different Phone | ☐ | | | `IsDifferentPostalCode` | `boolean` | Is Different Postal Code | ☐ | | | `IsDifferentSic` | `boolean` | Is Different SIC | ☐ | | | `IsDifferentSicDescription` | `boolean` | Is Different SIC Description | ☐ | | | `IsDifferentState` | `boolean` | Is Different State | ☐ | | | `IsDifferentStateCode` | `boolean` | Is Different State Code | ☐ | | | `IsDifferentStreet` | `boolean` | Is Different Street | ☐ | | | `IsDifferentTickerSymbol` | `boolean` | Is Different Ticker Symbol | ☐ | | | `IsDifferentTradestyle` | `boolean` | Is Different Trade Style | ☐ | | | `IsDifferentWebsite` | `boolean` | Is Different Website | ☐ | | | `IsDifferentYearStarted` | `boolean` | Is Different Year Started | ☐ | | | `IsFlaggedWrongAccountSite` | `boolean` | Is Flagged Wrong Account Site | ☐ | | | `IsFlaggedWrongAddress` | `boolean` | Is Flagged Wrong Address | ☐ | | | `IsFlaggedWrongAnnualRevenue` | `boolean` | Is Flagged Wrong Annual Revenue | ☐ | | | `IsFlaggedWrongCompanyName` | `boolean` | Is Flagged Wrong Company Name | ☐ | | | `IsFlaggedWrongDescription` | `boolean` | Is Flagged Wrong Description | ☐ | | | `IsFlaggedWrongDunsNumber` | `boolean` | Is Flagged Wrong DUNS Number | ☐ | | | `IsFlaggedWrongFax` | `boolean` | Is Flagged Wrong Fax | ☐ | | | `IsFlaggedWrongIndustry` | `boolean` | Is Flagged Wrong Industry | ☐ | | | `IsFlaggedWrongNaicsCode` | `boolean` | Is Flagged Wrong NAICS Code | ☐ | | | `IsFlaggedWrongNaicsDescription` | `boolean` | Is Flagged Wrong NAICS Description | ☐ | | | `IsFlaggedWrongNumberOfEmployees` | `boolean` | Is Flagged Wrong Number of Employees | ☐ | | | `IsFlaggedWrongOwnership` | `boolean` | Is Flagged Wrong Ownership | ☐ | | | `IsFlaggedWrongPhone` | `boolean` | Is Flagged Wrong Phone | ☐ | | | `IsFlaggedWrongSic` | `boolean` | Is Flagged Wrong SIC | ☐ | | | `IsFlaggedWrongSicDescription` | `boolean` | Is Flagged Wrong SIC Description | ☐ | | | `IsFlaggedWrongTickerSymbol` | `boolean` | Is Flagged Wrong Ticker Symbol | ☐ | | | `IsFlaggedWrongTradestyle` | `boolean` | Is Flagged Wrong Trade Style | ☐ | | | `IsFlaggedWrongWebsite` | `boolean` | Is Flagged Wrong Website | ☐ | | | `IsFlaggedWrongYearStarted` | `boolean` | Is Flagged Wrong Year Started | ☐ | | | `IsInactive` | `boolean` | Is Inactive | ☐ | | | `IsReviewedAccountSite` | `boolean` | Is Reviewed Account Site | ☐ | | | `IsReviewedAddress` | `boolean` | Is Reviewed Address | ☐ | | | `IsReviewedAnnualRevenue` | `boolean` | Is Reviewed Annual Revenue | ☐ | | | `IsReviewedCompanyName` | `boolean` | Is Reviewed Company Name | ☐ | | | `IsReviewedDandBCompanyDunsNumber` | `boolean` | Is Reviewed D&B Company DUNS Number | ☐ | | | `IsReviewedDescription` | `boolean` | Is Reviewed Description | ☐ | | | `IsReviewedDunsNumber` | `boolean` | Is Reviewed DUNS Number | ☐ | | | `IsReviewedFax` | `boolean` | Is Reviewed Fax | ☐ | | | `IsReviewedIndustry` | `boolean` | Is Reviewed Industry | ☐ | | | `IsReviewedNaicsCode` | `boolean` | Is Reviewed NAICS Code | ☐ | | | `IsReviewedNaicsDescription` | `boolean` | Is Reviewed NAICS Description | ☐ | | | `IsReviewedNumberOfEmployees` | `boolean` | Is Reviewed Number of Employees | ☐ | | | `IsReviewedOwnership` | `boolean` | Is Reviewed Ownership | ☐ | | | `IsReviewedPhone` | `boolean` | Is Reviewed Phone | ☐ | | | `IsReviewedSic` | `boolean` | Is Reviewed SIC | ☐ | | | `IsReviewedSicDescription` | `boolean` | Is Reviewed SIC Description | ☐ | | | `IsReviewedTickerSymbol` | `boolean` | Is Reviewed Ticker Symbol | ☐ | | | `IsReviewedTradestyle` | `boolean` | Is Reviewed Trade Style | ☐ | | | `IsReviewedWebsite` | `boolean` | Is Reviewed Website | ☐ | | | `IsReviewedYearStarted` | `boolean` | Is Reviewed Year Started | ☐ | | | `LastMatchedDate` | `datetime` | Last Matched Date | ☐ | | | `LastModifiedById` | `string` | Last Modified by ID | ☐ | | | `LastModifiedDate` | `datetime` | Date Last Modified | ☐ | | | `LastStatusChangedById` | `string` | Last Status Changed by ID | ☐ | | | `LastStatusChangedDate` | `datetime` | Last Status Changed Date | ☐ | | | `Latitude` | `double` | Latitude | ☐ | | | `Longitude` | `double` | Longitude | ☐ | | | `NaicsCode` | `string` | NAICS Code | ☐ | | | `NaicsDescription` | `string` | NAICS Description | ☐ | | | `Name` | `string` | Name | ☐ | | | `NumberOfEmployees` | `int32` | Number of Employees | ☐ | | | `Ownership` | `string` | Ownership | ☐ | | | `Phone` | `string` | Phone | ☐ | | | `PostalCode` | `string` | Postal Code | ☐ | | | `Sic` | `string` | SIC | ☐ | | | `SicDescription` | `string` | SIC Description | ☐ | | | `State` | `string` | State | ☐ | | | `Street` | `string` | Street | ☐ | | | `SystemModstamp` | `datetime` | System Modstamp | ☐ | | | `TickerSymbol` | `string` | Ticker Symbol | ☐ | | | `Tradestyle` | `string` | Trade Style | ☐ | | | `Website` | `string` | Website | ☐ | | | `YearStarted` | `string` | Year Started | ☐ | |