Account

Columns

Name

Type

ReadOnly

References

Description

Id [KEY]

String

True

Unique identifier of the Account.

IsDeleted

Boolean

True

Label Deleted corresponds to this field.

MasterRecordId

String

True

Account.Id

Label Master Record ID corresponds to this field.

Name

String

False

Label Account Name corresponds to this field.

Type

String

False

Label Account Type corresponds to this field.

ParentId

String

False

Account.Id

Label Parent Account ID corresponds to this field.

BillingStreet

String

False

Label Billing Street corresponds to this field.

BillingCity

String

False

Label Billing City corresponds to this field.

BillingState

String

False

Label Billing State/Province corresponds to this field.

BillingPostalCode

String

False

Label Billing Zip/Postal Code corresponds to this field.

BillingCountry

String

False

Label Billing Country corresponds to this field.

BillingLatitude

Double

False

Label Billing Latitude corresponds to this field.

BillingLongitude

Double

False

Label Billing Longitude corresponds to this field.

ShippingStreet

String

False

Label Shipping Street corresponds to this field.

ShippingCity

String

False

Label Shipping City corresponds to this field.

ShippingState

String

False

Label Shipping State/Province corresponds to this field.

ShippingPostalCode

String

False

Label Shipping Zip/Postal Code corresponds to this field.

ShippingCountry

String

False

Label Shipping Country corresponds to this field.

ShippingLatitude

Double

False

Label Shipping Latitude corresponds to this field.

ShippingLongitude

Double

False

Label Shipping Longitude corresponds to this field.

Phone

String

False

Label Account Phone corresponds to this field.

Fax

String

False

Label Account Fax corresponds to this field.

AccountNumber

String

False

Label Account Number corresponds to this field.

Website

String

False

Label Website corresponds to this field.

Sic

String

False

Label SIC Code corresponds to this field.

Industry

String

False

Label Industry corresponds to this field.

AnnualRevenue

Double

False

Label Annual Revenue corresponds to this field.

NumberOfEmployees

Int

False

Label Employees corresponds to this field.

Ownership

String

False

Label Ownership corresponds to this field.

TickerSymbol

String

False

Label Ticker Symbol corresponds to this field.

Description

String

False

Label Account Description corresponds to this field.

Rating

String

False

Label Account Rating corresponds to this field.

Site

String

False

Label Account Site corresponds to this field.

OwnerId

String

False

User.Id

Label Owner ID corresponds to this field.

CreatedDate

Datetime

True

Label Created Date corresponds to this field.

CreatedById

String

True

User.Id

Label Created By ID corresponds to this field.

LastModifiedDate

Datetime

True

Label Last Modified Date corresponds to this field.

LastModifiedById

String

True

User.Id

Label Last Modified By ID corresponds to this field.

SystemModstamp

Datetime

True

Label System Modstamp corresponds to this field.

LastActivityDate

Datetime

True

Label Last Activity corresponds to this field.

LastViewedDate

Datetime

True

Label Last Viewed Date corresponds to this field.

LastReferencedDate

Datetime

True

Label Last Referenced Date corresponds to this field.

Jigsaw

String

False

Label Data.com Key corresponds to this field.

JigsawCompanyId

String

True

Label Jigsaw Company ID corresponds to this field.

AccountSource

String

False

Label Account Source corresponds to this field.

SicDesc

String

False

Label SIC Description corresponds to this field.

NumberofLocations__c

Double

False

Label Number of Locations corresponds to this field.

SLAExpirationDate__c

Datetime

False

Label SLA Expiration Date corresponds to this field.

UpsellOpportunity__c

String

False

Label Upsell Opportunity corresponds to this field.

SLASerialNumber__c

String

False

Label SLA Serial Number corresponds to this field.

SLA__c

String

False

Label SLA corresponds to this field.

CustomerPriority__c

String

False

Label Customer Priority corresponds to this field.

Active__c

String

False

Label Active corresponds to this field.

MyAutoNumber__c

String

True

Label MyAutoNumber corresponds to this field.

MyFormula__c

String

True

Label MyFormula corresponds to this field.

MyRollupSummary__c

Double

True

Label MyRollupSummary corresponds to this field.

MyCheckBox__c

Boolean

False

Label MyCheckBox corresponds to this field.

MyEmail__c

String

False

Label MyEmail corresponds to this field.

MyPercent__c

Double

False

Label MyPercent corresponds to this field.

Custom_Date_Time__c

Datetime

False

Label Custom Date Time corresponds to this field.

New_Currency_Field__c

Double

False

Label New_Currency_Field corresponds to this field.

New_Currency_Field_2__c

Double

False

Label New_Currency_Field_2 corresponds to this field.

DO_NOT_USE__c

Boolean

False

Label DO_NOT_USE corresponds to this field.

CustomNumber__c

Double

False

Label CustomNumber corresponds to this field.

FiveChar_TextField__c

String

False

Label FiveChar_TextField corresponds to this field.

FiveChar_CurrencyField__c

Double

False

Label FiveChar_CurrencyField corresponds to this field.