# Account: Accounts - Name: `Account` - Catalog: `Salesforce` - Schema: `Salesforce` - Primary Keys: `id` - Label: Accounts ## Table Columns The columns of the table `Account` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `AccountNumber` | `string` | Account Number | ☐ | | | `AccountSource` | `string` | Account Source | ☐ | | | `Active__c` | `string` | Active | ☐ | | | `AnnualRevenue` | `decimal` | Annual Revenue | ☐ | | | `BillingCity` | `string` | Billing City | ☐ | | | `BillingCountry` | `string` | Billing Country | ☐ | | | `BillingGeocodeAccuracy` | `string` | Billing Geocode Accuracy | ☐ | | | `BillingLatitude` | `double` | Billing Latitude | ☐ | | | `BillingLongitude` | `double` | Billing Longitude | ☐ | | | `BillingPostalCode` | `string` | Billing Postal Code | ☐ | | | `BillingState` | `string` | Billing State | ☐ | | | `BillingStreet` | `string` | Billing Street | ☐ | | | `CleanStatus` | `string` | Clean Status | ☐ | | | `CreatedById` | `string` | Created by ID | ☐ | | | `CreatedDate` | `datetime` | Date Created | ☐ | | | `CustomerPriority__c` | `string` | Customer Priority | ☐ | | | `DandbCompanyId` | `string` | D&B Company ID | ☐ | | | `Description` | `string` | Description | ☐ | | | `DunsNumber` | `string` | DUNS Number | ☐ | | | `Fax` | `string` | Fax | ☐ | | | `Id` | `string` | ID | ☐ | | | `Industry` | `string` | Industry | ☐ | | | `IsDeleted` | `boolean` | Is Deleted | ☐ | | | `Jigsaw` | `string` | Jigsaw | ☐ | | | `JigsawCompanyId` | `string` | Jigsaw Company ID | ☐ | | | `LastActivityDate` | `datetime` | Date Last Activity | ☐ | | | `LastModifiedById` | `string` | Last Modified by ID | ☐ | | | `LastModifiedDate` | `datetime` | Date Last Modified | ☐ | | | `LastReferencedDate` | `datetime` | Last Referenced Date | ☐ | | | `LastViewedDate` | `datetime` | Last Viewed Date | ☐ | | | `MasterRecordId` | `string` | Master Record ID | ☐ | | | `NaicsCode` | `string` | NAICS Code | ☐ | | | `NaicsDesc` | `string` | NAICS Description | ☐ | | | `Name` | `string` | Name | ☐ | | | `NumberOfEmployees` | `int32` | Number of Employees | ☐ | | | `NumberofLocations__c` | `double` | Number of Locations | ☐ | | | `OwnerId` | `string` | Owner ID | ☐ | | | `Ownership` | `string` | Ownership | ☐ | | | `ParentId` | `string` | Parent ID | ☐ | | | `Phone` | `string` | Phone | ☐ | | | `PhotoUrl` | `string` | Photo (URL) | ☐ | | | `Rating` | `string` | Rating | ☐ | | | `ShippingCity` | `string` | Shipping City | ☐ | | | `ShippingCountry` | `string` | Shipping Country | ☐ | | | `ShippingGeocodeAccuracy` | `string` | Shipping Geocode Accuracy | ☐ | | | `ShippingLatitude` | `double` | Shipping Latitude | ☐ | | | `ShippingLongitude` | `double` | Shipping Longitude | ☐ | | | `ShippingPostalCode` | `string` | Shipping Postal Code | ☐ | | | `ShippingState` | `string` | Shipping State | ☐ | | | `ShippingStreet` | `string` | Shipping Street | ☐ | | | `Sic` | `string` | SIC | ☐ | | | `SicDesc` | `string` | SIC Description | ☐ | | | `Site` | `string` | Site | ☐ | | | `SLA__c` | `string` | SLA | ☐ | | | `SLAExpirationDate__c` | `datetime` | SLA Expiration Date | ☐ | | | `SLASerialNumber__c` | `string` | SLA Serial Number | ☐ | | | `SystemModstamp` | `datetime` | System Modstamp | ☐ | | | `TickerSymbol` | `string` | Ticker Symbol | ☐ | | | `Tradestyle` | `string` | Trade Style | ☐ | | | `Type` | `string` | Type | ☐ | | | `UpsellOpportunity__c` | `string` | Upsell Opportunity | ☐ | | | `Website` | `string` | Website | ☐ | | | `YearStarted` | `string` | Year Started | ☐ | |