Integration Your Way - (800) 235-7250
RSSBus JDBC Driver for MSCRM
Questions / Feedback? Account

Account

This is a table representing the Account entities in CRM Dynamics.

Columns

Name Type Description ReadOnly
Id [KEY] Edm.String Id of the entity. True
TerritoryCode Microsoft.Crm.Sdk.Data.Services.OptionSetValue The TerritoryCode of the Account. False
LastUsedInCampaign Edm.DateTime The LastUsedInCampaign of the Account. False
Address1_Name Edm.String The Address1_Name of the Account. False
Address1_Telephone2 Edm.String The Address1_Telephone2 of the Account. False
OverriddenCreatedOn Edm.DateTime The OverriddenCreatedOn of the Account. False
PreferredContactMethodCode Microsoft.Crm.Sdk.Data.Services.OptionSetValue The PreferredContactMethodCode of the Account. False
OwnershipCode Microsoft.Crm.Sdk.Data.Services.OptionSetValue The OwnershipCode of the Account. False
PrimaryContactId Microsoft.Crm.Sdk.Data.Services.EntityReference The PrimaryContactId of the Account. False
CreditLimit Microsoft.Crm.Sdk.Data.Services.Money The CreditLimit of the Account. False
TerritoryId Microsoft.Crm.Sdk.Data.Services.EntityReference The TerritoryId of the Account. False
Telephone3 Edm.String The Telephone3 of the Account. False
DoNotBulkPostalMail Edm.Boolean The DoNotBulkPostalMail of the Account. False
Address1_FreightTermsCode Microsoft.Crm.Sdk.Data.Services.OptionSetValue The Address1_FreightTermsCode of the Account. False
Address2_Line1 Edm.String The Address2_Line1 of the Account. False
EMailAddress2 Edm.String The EMailAddress2 of the Account. False
Address2_PrimaryContactName Edm.String The Address2_PrimaryContactName of the Account. False
Telephone2 Edm.String The Telephone2 of the Account. False
TimeZoneRuleVersionNumber Edm.Int32 The TimeZoneRuleVersionNumber of the Account. False
OwningTeam Microsoft.Crm.Sdk.Data.Services.EntityReference The OwningTeam of the Account. False
ShippingMethodCode Microsoft.Crm.Sdk.Data.Services.OptionSetValue The ShippingMethodCode of the Account. False
Address1_AddressId Edm.Guid The Address1_AddressId of the Account. False
Address2_Telephone1 Edm.String The Address2_Telephone1 of the Account. False
Address1_Fax Edm.String The Address1_Fax of the Account. False
OwningBusinessUnit Microsoft.Crm.Sdk.Data.Services.EntityReference The OwningBusinessUnit of the Account. False
OwnerId Microsoft.Crm.Sdk.Data.Services.EntityReference The OwnerId of the Account. False
CreatedOnBehalfBy Microsoft.Crm.Sdk.Data.Services.EntityReference The CreatedOnBehalfBy of the Account. False
Address2_Latitude Edm.Double The Address2_Latitude of the Account. False
Aging90_Base Microsoft.Crm.Sdk.Data.Services.Money The Aging90_Base of the Account. False
Address2_PostalCode Edm.String The Address2_PostalCode of the Account. False
Merged Edm.Boolean The Merged of the Account. False
PaymentTermsCode Microsoft.Crm.Sdk.Data.Services.OptionSetValue The PaymentTermsCode of the Account. False
DoNotSendMM Edm.Boolean The DoNotSendMM of the Account. False
Address2_County Edm.String The Address2_County of the Account. False
Aging30 Microsoft.Crm.Sdk.Data.Services.Money The Aging30 of the Account. False
Address2_City Edm.String The Address2_City of the Account. False
DoNotBulkEMail Edm.Boolean The DoNotBulkEMail of the Account. False
ImportSequenceNumber Edm.Int32 The ImportSequenceNumber of the Account. False
EMailAddress3 Edm.String The EMailAddress3 of the Account. False
Address1_City Edm.String The Address1_City of the Account. False
WebSiteURL Edm.String The WebSiteURL of the Account. False
Revenue Microsoft.Crm.Sdk.Data.Services.Money The Revenue of the Account. False
TransactionCurrencyId Microsoft.Crm.Sdk.Data.Services.EntityReference The TransactionCurrencyId of the Account. False
Address1_ShippingMethodCode Microsoft.Crm.Sdk.Data.Services.OptionSetValue The Address1_ShippingMethodCode of the Account. False
Address1_PostOfficeBox Edm.String The Address1_PostOfficeBox of the Account. False
Description Edm.String The Description of the Account. False
TickerSymbol Edm.String The TickerSymbol of the Account. False
Address2_Longitude Edm.Double The Address2_Longitude of the Account. False
SIC Edm.String The SIC of the Account. False
Address1_County Edm.String The Address1_County of the Account. False
OwningUser Microsoft.Crm.Sdk.Data.Services.EntityReference The OwningUser of the Account. False
Address1_Line1 Edm.String The Address1_Line1 of the Account. False
Address2_AddressId Edm.Guid The Address2_AddressId of the Account. False
CreditLimit_Base Microsoft.Crm.Sdk.Data.Services.Money The CreditLimit_Base of the Account. False
PreferredSystemUserId Microsoft.Crm.Sdk.Data.Services.EntityReference The PreferredSystemUserId of the Account. False
MarketCap Microsoft.Crm.Sdk.Data.Services.Money The MarketCap of the Account. False
Address1_PrimaryContactName Edm.String The Address1_PrimaryContactName of the Account. False
DoNotPostalMail Edm.Boolean The DoNotPostalMail of the Account. False
AccountCategoryCode Microsoft.Crm.Sdk.Data.Services.OptionSetValue The AccountCategoryCode of the Account. False
StateCode Microsoft.Crm.Sdk.Data.Services.OptionSetValue The StateCode of the Account. False
Address2_Telephone3 Edm.String The Address2_Telephone3 of the Account. False
Address2_AddressTypeCode Microsoft.Crm.Sdk.Data.Services.OptionSetValue The Address2_AddressTypeCode of the Account. False
DoNotFax Edm.Boolean The DoNotFax of the Account. False
DefaultPriceLevelId Microsoft.Crm.Sdk.Data.Services.EntityReference The DefaultPriceLevelId of the Account. False
ParticipatesInWorkflow Edm.Boolean The ParticipatesInWorkflow of the Account. False
CustomerSizeCode Microsoft.Crm.Sdk.Data.Services.OptionSetValue The CustomerSizeCode of the Account. False
Address2_UPSZone Edm.String The Address2_UPSZone of the Account. False
PreferredServiceId Microsoft.Crm.Sdk.Data.Services.EntityReference The PreferredServiceId of the Account. False
UTCConversionTimeZoneCode Edm.Int32 The UTCConversionTimeZoneCode of the Account. False
DoNotEMail Edm.Boolean The DoNotEMail of the Account. False
Aging60 Microsoft.Crm.Sdk.Data.Services.Money The Aging60 of the Account. False
CustomerTypeCode Microsoft.Crm.Sdk.Data.Services.OptionSetValue The CustomerTypeCode of the Account. False
Telephone1 Edm.String The Telephone1 of the Account. False
CreatedBy Microsoft.Crm.Sdk.Data.Services.EntityReference The CreatedBy of the Account. False
Address2_Name Edm.String The Address2_Name of the Account. False
ModifiedBy Microsoft.Crm.Sdk.Data.Services.EntityReference The ModifiedBy of the Account. False
YomiName Edm.String The YomiName of the Account. False
Address2_Country Edm.String The Address2_Country of the Account. False
Address2_Fax Edm.String The Address2_Fax of the Account. False
Address1_UPSZone Edm.String The Address1_UPSZone of the Account. False
Address1_PostalCode Edm.String The Address1_PostalCode of the Account. False
Address1_Country Edm.String The Address1_Country of the Account. False
NumberOfEmployees Edm.Int32 The NumberOfEmployees of the Account. False
Address2_FreightTermsCode Microsoft.Crm.Sdk.Data.Services.OptionSetValue The Address2_FreightTermsCode of the Account. False
AccountRatingCode Microsoft.Crm.Sdk.Data.Services.OptionSetValue The AccountRatingCode of the Account. False
FtpSiteURL Edm.String The FtpSiteURL of the Account. False
Address1_Longitude Edm.Double The Address1_Longitude of the Account. False
AccountId Edm.Guid The AccountId of the Account. False
OriginatingLeadId Microsoft.Crm.Sdk.Data.Services.EntityReference The OriginatingLeadId of the Account. False
Fax Edm.String The Fax of the Account. False
CreditOnHold Edm.Boolean The CreditOnHold of the Account. False
Address1_Telephone1 Edm.String The Address1_Telephone1 of the Account. False
CreatedOn Edm.DateTime The CreatedOn of the Account. False
Name Edm.String The Name of the Account. False
ExchangeRate Edm.Decimal The ExchangeRate of the Account. False
Address2_ShippingMethodCode Microsoft.Crm.Sdk.Data.Services.OptionSetValue The Address2_ShippingMethodCode of the Account. False
Address2_Line2 Edm.String The Address2_Line2 of the Account. False
VersionNumber Edm.Int64 The VersionNumber of the Account. False
AccountNumber Edm.String The AccountNumber of the Account. False
Address2_PostOfficeBox Edm.String The Address2_PostOfficeBox of the Account. False
Revenue_Base Microsoft.Crm.Sdk.Data.Services.Money The Revenue_Base of the Account. False
DoNotPhone Edm.Boolean The DoNotPhone of the Account. False
AccountClassificationCode Microsoft.Crm.Sdk.Data.Services.OptionSetValue The AccountClassificationCode of the Account. False
PreferredEquipmentId Microsoft.Crm.Sdk.Data.Services.EntityReference The PreferredEquipmentId of the Account. False
MarketCap_Base Microsoft.Crm.Sdk.Data.Services.Money The MarketCap_Base of the Account. False
Address2_Telephone2 Edm.String The Address2_Telephone2 of the Account. False
Address1_AddressTypeCode Microsoft.Crm.Sdk.Data.Services.OptionSetValue The Address1_AddressTypeCode of the Account. False
Address1_UTCOffset Edm.Int32 The Address1_UTCOffset of the Account. False
ParentAccountId Microsoft.Crm.Sdk.Data.Services.EntityReference The ParentAccountId of the Account. False
Address1_Line2 Edm.String The Address1_Line2 of the Account. False
BusinessTypeCode Microsoft.Crm.Sdk.Data.Services.OptionSetValue The BusinessTypeCode of the Account. False
Aging60_Base Microsoft.Crm.Sdk.Data.Services.Money The Aging60_Base of the Account. False
ModifiedOnBehalfBy Microsoft.Crm.Sdk.Data.Services.EntityReference The ModifiedOnBehalfBy of the Account. False
StockExchange Edm.String The StockExchange of the Account. False
Address1_Line3 Edm.String The Address1_Line3 of the Account. False
MasterId Microsoft.Crm.Sdk.Data.Services.EntityReference The MasterId of the Account. False
Aging90 Microsoft.Crm.Sdk.Data.Services.Money The Aging90 of the Account. False
StatusCode Microsoft.Crm.Sdk.Data.Services.OptionSetValue The StatusCode of the Account. False
Aging30_Base Microsoft.Crm.Sdk.Data.Services.Money The Aging30_Base of the Account. False
SharesOutstanding Edm.Int32 The SharesOutstanding of the Account. False
Address1_StateOrProvince Edm.String The Address1_StateOrProvince of the Account. False
Address1_Latitude Edm.Double The Address1_Latitude of the Account. False
ModifiedOn Edm.DateTime The ModifiedOn of the Account. False
Address2_Line3 Edm.String The Address2_Line3 of the Account. False
Address2_UTCOffset Edm.Int32 The Address2_UTCOffset of the Account. False
PreferredAppointmentDayCode Microsoft.Crm.Sdk.Data.Services.OptionSetValue The PreferredAppointmentDayCode of the Account. False
PreferredAppointmentTimeCode Microsoft.Crm.Sdk.Data.Services.OptionSetValue The PreferredAppointmentTimeCode of the Account. False
EMailAddress1 Edm.String The EMailAddress1 of the Account. False
Address2_StateOrProvince Edm.String The Address2_StateOrProvince of the Account. False
IndustryCode Microsoft.Crm.Sdk.Data.Services.OptionSetValue The IndustryCode of the Account. False
Address1_Telephone3 Edm.String The Address1_Telephone3 of the Account. False


 
Copyright © 2013 RSSBus Inc.
[x] close

Questions / Feedback?


Name:
Email:
Feedback:
Send Feedback