# DatacloudDandBCompany: Data Cloud D&B Company - Name: `DatacloudDandBCompany` - Catalog: `Salesforce` - Schema: `Salesforce` - Primary Keys: `id` - Label: Data Cloud D&B Company ## Table Columns The columns of the table `DatacloudDandBCompany` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `City` | `string` | City | ☐ | | | `CompanyCurrencyIsoCode` | `string` | Company Currency ISO Code | ☐ | | | `CompanyId` | `string` | Company ID | ☐ | | | `Country` | `string` | Country | ☐ | | | `CountryAccessCode` | `string` | Country Access Code | ☐ | | | `CountryCode` | `string` | Country Code | ☐ | | | `CurrencyCode` | `string` | Currency Code | ☐ | | | `Description` | `string` | Description | ☐ | | | `DomesticUltimateBusinessName` | `string` | Domestic Ultimate Business Name | ☐ | | | `DomesticUltimateDunsNumber` | `string` | Domestic Ultimate DUNS Number | ☐ | | | `DunsNumber` | `string` | DUNS Number | ☐ | | | `EmployeeQuantityGrowthRate` | `double` | Employee Quantity Growth Rate | ☐ | | | `EmployeesHere` | `double` | Employees Here | ☐ | | | `EmployeesHereReliability` | `string` | Employees Here Reliability | ☐ | | | `EmployeesTotal` | `double` | Employees Total | ☐ | | | `EmployeesTotalReliability` | `string` | Employees Total Reliability | ☐ | | | `ExternalId` | `string` | External ID | ☐ | | | `FamilyMembers` | `int32` | Family Members | ☐ | | | `Fax` | `string` | Fax | ☐ | | | `FifthNaics` | `string` | Fifth NAICS | ☐ | | | `FifthNaicsDesc` | `string` | Fifth NAICS Description | ☐ | | | `FifthSic` | `string` | Fifth SIC | ☐ | | | `FifthSic8` | `string` | Fifth SIC8 | ☐ | | | `FifthSic8Desc` | `string` | Fifth SIC8 Description | ☐ | | | `FifthSicDesc` | `string` | Fifth SIC Description | ☐ | | | `FipsMsaCode` | `string` | FIPS MSA Code | ☐ | | | `FipsMsaDesc` | `string` | FIPS MSA Description | ☐ | | | `FortuneRank` | `int32` | Fortune Rank | ☐ | | | `FourthNaics` | `string` | Fourth NAICS | ☐ | | | `FourthNaicsDesc` | `string` | Fourth NAICS Description | ☐ | | | `FourthSic` | `string` | Fourth SIC | ☐ | | | `FourthSic8` | `string` | Fourth SIC8 | ☐ | | | `FourthSic8Desc` | `string` | Fourth SIC8 Description | ☐ | | | `FourthSicDesc` | `string` | Fourth SIC Description | ☐ | | | `FullAddress` | `string` | Full Address | ☐ | | | `GeoCodeAccuracy` | `string` | Geocode Accuracy | ☐ | | | `GlobalUltimateBusinessName` | `string` | Global Ultimate Business Name | ☐ | | | `GlobalUltimateDunsNumber` | `string` | Global Ultimate DUNS Number | ☐ | | | `GlobalUltimateTotalEmployees` | `double` | Global Ultimate Total Employees | ☐ | | | `Id` | `string` | ID | ☐ | | | `ImportExportAgent` | `string` | Import Export Agent | ☐ | | | `IncludedInSnP500` | `string` | Included in S&P 500 | ☐ | | | `Industry` | `string` | Industry | ☐ | | | `IsInCrm` | `boolean` | Is in CRM | ☐ | | | `IsOwned` | `boolean` | Is Owned | ☐ | | | `IsParent` | `boolean` | Is Parent | ☐ | | | `Latitude` | `string` | Latitude | ☐ | | | `LegalStatus` | `string` | Legal Status | ☐ | | | `LocationStatus` | `string` | Location Status | ☐ | | | `Longitude` | `string` | Longitude | ☐ | | | `MailingCity` | `string` | Mailing City | ☐ | | | `MailingCountry` | `string` | Mailing Country | ☐ | | | `MailingCountryCode` | `string` | Mailing Country Code | ☐ | | | `MailingState` | `string` | Mailing State | ☐ | | | `MailingStateCode` | `string` | Mailing State Code | ☐ | | | `MailingStreet` | `string` | Mailing Street | ☐ | | | `MailingZip` | `string` | Mailing Zip | ☐ | | | `MarketingPreScreen` | `string` | Marketing Prescreen | ☐ | | | `MarketingSegmentationCluster` | `string` | Marketing Segmentation Cluster | ☐ | | | `MinorityOwned` | `string` | Minority Owned | ☐ | | | `Name` | `string` | Name | ☐ | | | `NationalId` | `string` | National ID | ☐ | | | `NationalIdType` | `string` | National ID Type | ☐ | | | `OutOfBusiness` | `string` | Out of Business | ☐ | | | `OwnOrRent` | `string` | Own or Rent | ☐ | | | `ParentOrHqBusinessName` | `string` | Parent or HQ Business Name | ☐ | | | `ParentOrHqDunsNumber` | `string` | Parent or HQ DUNS Number | ☐ | | | `Phone` | `string` | Phone | ☐ | | | `PremisesMeasure` | `int32` | Premises Measure | ☐ | | | `PremisesMeasureReliability` | `string` | Premises Measure Reliability | ☐ | | | `PremisesMeasureUnit` | `string` | Premises Measure Unit | ☐ | | | `PrimaryNaics` | `string` | Primary NAICS | ☐ | | | `PrimaryNaicsDesc` | `string` | Primary NAICS Description | ☐ | | | `PrimarySic` | `string` | Primary SIC | ☐ | | | `PrimarySic8` | `string` | Primary SIC8 | ☐ | | | `PrimarySic8Desc` | `string` | Primary SIC8 Description | ☐ | | | `PrimarySicDesc` | `string` | Primary SIC Description | ☐ | | | `PriorYearEmployees` | `int32` | Prior Year Employees | ☐ | | | `PriorYearRevenue` | `double` | Prior Year Revenue | ☐ | | | `PublicIndicator` | `string` | Public Indicator | ☐ | | | `Revenue` | `double` | Revenue | ☐ | | | `SalesTurnoverGrowthRate` | `double` | Sales Turnover Growth Rate | ☐ | | | `SalesVolume` | `double` | Sales Volume | ☐ | | | `SalesVolumeReliability` | `string` | Sales Volume Reliability | ☐ | | | `SecondNaics` | `string` | Second NAICS | ☐ | | | `SecondNaicsDesc` | `string` | Second NAICS Description | ☐ | | | `SecondSic` | `string` | Second SIC | ☐ | | | `SecondSic8` | `string` | Second SIC8 | ☐ | | | `SecondSic8Desc` | `string` | Second SIC8 Description | ☐ | | | `SecondSicDesc` | `string` | Second SIC Description | ☐ | | | `SicCodeDesc` | `string` | SIC Code Description | ☐ | | | `SixthNaics` | `string` | Sixth NAICS | ☐ | | | `SixthNaicsDesc` | `string` | Sixth NAICS Description | ☐ | | | `SixthSic` | `string` | Sixth SIC | ☐ | | | `SixthSic8` | `string` | Sixth SIC8 | ☐ | | | `SixthSic8Desc` | `string` | Sixth SIC8 Description | ☐ | | | `SixthSicDesc` | `string` | Sixth SIC Description | ☐ | | | `SmallBusiness` | `string` | Small Business | ☐ | | | `State` | `string` | State | ☐ | | | `StateCode` | `string` | State Code | ☐ | | | `StockExchange` | `string` | Stock Exchange | ☐ | | | `StockSymbol` | `string` | Stock Symbol | ☐ | | | `Street` | `string` | Street | ☐ | | | `Subsidiary` | `string` | Subsidiary | ☐ | | | `ThirdNaics` | `string` | Third NAICS | ☐ | | | `ThirdNaicsDesc` | `string` | Third NAICS Description | ☐ | | | `ThirdSic` | `string` | Third SIC | ☐ | | | `ThirdSic8` | `string` | Third SIC8 | ☐ | | | `ThirdSic8Desc` | `string` | Third SIC8 Description | ☐ | | | `ThirdSicDesc` | `string` | Third SIC Description | ☐ | | | `TradeStyle1` | `string` | Trade Style 1 | ☐ | | | `TradeStyle2` | `string` | Trade Style 2 | ☐ | | | `TradeStyle3` | `string` | Trade Style 3 | ☐ | | | `TradeStyle4` | `string` | Trade Style 4 | ☐ | | | `TradeStyle5` | `string` | Trade Style 5 | ☐ | | | `URL` | `string` | URL | ☐ | | | `UsTaxId` | `string` | US Tax ID | ☐ | | | `WomenOwned` | `string` | Women Owned | ☐ | | | `YearStarted` | `string` | Year Started | ☐ | | | `Zip` | `string` | ZIP | ☐ | |