Table "CRM Account"
ID 5341
Namespace: Microsoft.Integration.D365Sales
Properties
| Name | Value |
|---|---|
| Caption | Dataverse Account |
| Description | Business that represents a customer or potential customer. The company that is billed in business transactions. |
| ExternalName | account |
| TableType | CRM |
| DataClassification | CustomerContent |
Fields
| Name | Type | Description |
|---|---|---|
| AccountId | Guid | |
| AccountCategoryCode | Option | |
| DefaultPriceLevelId | Guid | |
| CustomerSizeCode | Option | |
| PreferredContactMethodCode | Option | |
| CustomerTypeCode | Option | |
| AccountRatingCode | Option | |
| IndustryCode | Option | |
| TerritoryCode | Option | |
| AccountClassificationCode | Option | |
| BusinessTypeCode | Option | |
| OwningBusinessUnit | Guid | |
| TraversedPath | Text[250] | |
| OwningUser | Guid | |
| PaymentTermsCode | Option | |
| ShippingMethodCode | Option | |
| PrimaryContactId | Guid | |
| ParticipatesInWorkflow | Boolean | |
| Name | Text[160] | |
| AccountNumber | Text[20] | |
| Revenue | Decimal | |
| NumberOfEmployees | Integer | |
| Description | Blob | |
| SIC | Text[20] | |
| OwnershipCode | Option | |
| MarketCap | Decimal | |
| SharesOutstanding | Integer | |
| TickerSymbol | Text[10] | |
| StockExchange | Text[20] | |
| WebSiteURL | Text[200] | |
| FtpSiteURL | Text[200] | |
| EMailAddress1 | Text[100] | |
| EMailAddress2 | Text[100] | |
| EMailAddress3 | Text[100] | |
| DoNotPhone | Boolean | |
| DoNotFax | Boolean | |
| Telephone1 | Text[50] | |
| DoNotEMail | Boolean | |
| Telephone2 | Text[50] | |
| Fax | Text[50] | |
| Telephone3 | Text[50] | |
| DoNotPostalMail | Boolean | |
| DoNotBulkEMail | Boolean | |
| DoNotBulkPostalMail | Boolean | |
| CreditLimit | Decimal | |
| CreditOnHold | Boolean | |
| CreatedOn | DateTime | |
| CreatedBy | Guid | |
| ModifiedOn | DateTime | |
| ModifiedBy | Guid | |
| VersionNumber | BigInteger | |
| ParentAccountId | Guid | |
| Aging30 | Decimal | |
| StateCode | Option | |
| Aging60 | Decimal | |
| StatusCode | Option | |
| Aging90 | Decimal | |
| PrimaryContactIdName | Text[160] | |
| ParentAccountIdName | Text[160] | |
| DefaultPriceLevelIdName | Text[100] | |
| Address1_AddressId | Guid | |
| Address1_AddressTypeCode | Option | |
| Address1_Name | Text[200] | |
| Address1_PrimaryContactName | Text[100] | |
| Address1_Line1 | Text[250] | |
| Address1_Line2 | Text[250] | |
| Address1_Line3 | Text[250] | |
| Address1_City | Text[80] | |
| Address1_StateOrProvince | Text[50] | |
| Address1_County | Text[50] | |
| Address1_Country | Text[80] | |
| Address1_PostOfficeBox | Text[20] | |
| Address1_PostalCode | Text[20] | |
| Address1_UTCOffset | Integer | |
| Address1_FreightTermsCode | Option | |
| Address1_UPSZone | Text[4] | |
| Address1_Latitude | Decimal | |
| Address1_Telephone1 | Text[50] | |
| Address1_Longitude | Decimal | |
| Address1_ShippingMethodCode | Option | |
| Address1_Telephone2 | Text[50] | |
| Address1_Telephone3 | Text[50] | |
| Address1_Fax | Text[50] | |
| Address2_AddressId | Guid | |
| Address2_AddressTypeCode | Option | |
| Address2_Name | Text[200] | |
| Address2_PrimaryContactName | Text[100] | |
| Address2_Line1 | Text[250] | |
| Address2_Line2 | Text[250] | |
| Address2_Line3 | Text[250] | |
| Address2_City | Text[80] | |
| Address2_StateOrProvince | Text[50] | |
| Address2_County | Text[50] | |
| Address2_Country | Text[80] | |
| Address2_PostOfficeBox | Text[20] | |
| Address2_PostalCode | Text[20] | |
| Address2_UTCOffset | Integer | |
| Address2_FreightTermsCode | Option | |
| Address2_UPSZone | Text[4] | |
| Address2_Latitude | Decimal | |
| Address2_Telephone1 | Text[50] | |
| Address2_Longitude | Decimal | |
| Address2_ShippingMethodCode | Option | |
| Address2_Telephone2 | Text[50] | |
| Address2_Telephone3 | Text[50] | |
| Address2_Fax | Text[50] | |
| CreatedByName | Text[200] | |
| ModifiedByName | Text[200] | |
| OwnerId | Guid | |
| OwnerIdType | Option | |
| PreferredAppointmentDayCode | Option | |
| PreferredSystemUserId | Guid | |
| PreferredAppointmentTimeCode | Option | |
| Merged | Boolean | |
| DoNotSendMM | Boolean | |
| MasterId | Guid | |
| LastUsedInCampaign | Date | |
| PreferredSystemUserIdName | Text[200] | |
| MasterAccountIdName | Text[160] | |
| ExchangeRate | Decimal | |
| UTCConversionTimeZoneCode | Integer | |
| OverriddenCreatedOn | Date | |
| TimeZoneRuleVersionNumber | Integer | |
| ImportSequenceNumber | Integer | |
| TransactionCurrencyId | Guid | |
| CreditLimit_Base | Decimal | |
| TransactionCurrencyIdName | Text[100] | |
| Aging30_Base | Decimal | |
| Revenue_Base | Decimal | |
| Aging90_Base | Decimal | |
| MarketCap_Base | Decimal | |
| Aging60_Base | Decimal | |
| YomiName | Text[160] | |
| CreatedOnBehalfBy | Guid | |
| CreatedOnBehalfByName | Text[200] | |
| ModifiedOnBehalfBy | Guid | |
| ModifiedOnBehalfByName | Text[200] | |
| OwningTeam | Guid | |
| StageId | Guid | |
| ProcessId | Guid | |
| Address2_Composite | Blob | |
| Address1_Composite | Blob | |
| EntityImageId | Guid | |
| OpenDeals | Integer | |
| OpenDeals_Date | DateTime | |
| OpenDeals_State | Integer | |
| OpenRevenue | Decimal | |
| OpenRevenue_Base | Decimal | |
| OpenRevenue_Date | DateTime | |
| OpenRevenue_State | Integer | |
| AccountStatiticsId | Guid | |
| AccountStatiticsName | Text[100] | |
| CompanyId | Guid | |
| PaymentTermsCodeEnum | Microsoft.Integration.Dataverse."CDS Payment Terms Code" | |
| Address1_FreightTermsCodeEnum | Microsoft.Integration.Dataverse."CDS Shipment Method Code" | |
| Address1_ShippingMethodCodeEnum | Microsoft.Integration.Dataverse."CDS Shipping Agent Code" | |
| SystemId | Guid | |
| SystemRowVersion | BigInteger |