---
title: "Table 5341 CRM Account"
author: "Jonas Paprotka"
url: https://jonas-paprotka.de/ref/table/5341-crm-account/
type: table
id: 5341
name: "CRM Account"
app: "Base Application"
namespace: Microsoft.Integration.D365Sales
versions: "17-28"
build: 28.5.54151.54365
source: "https://jonas-paprotka.de/ref/table/5341-crm-account/source/29/"
checked: 2026-09-20
subject: "Microsoft Dynamics 365 Business Central"
license: "Content © 2026 Jonas Paprotka. Quote freely with attribution and a link."
---

# Table 5341 CRM Account

Jonas Paprotka, https://jonas-paprotka.de/ref/table/5341-crm-account/

| | |
| --- | --- |
| App | Base Application |
| Namespace | Microsoft.Integration.D365Sales |
| Versions | 17-28 |
| Source file | Integration/D365Sales/CRMAccount.Table.al |

## Fields

| Id | Name | Type | Versions | Obsolete | Reason |
| --- | --- | --- | --- | --- | --- |
| 1 | AccountId | Guid | 17-28 | - | - |
| 2 | AccountCategoryCode | Option | 17-28 | - | - |
| 3 | DefaultPriceLevelId | Guid | 17-28 | - | - |
| 4 | CustomerSizeCode | Option | 17-28 | - | - |
| 5 | PreferredContactMethodCode | Option | 17-28 | - | - |
| 6 | CustomerTypeCode | Option | 17-28 | - | - |
| 7 | AccountRatingCode | Option | 17-28 | - | - |
| 8 | IndustryCode | Option | 17-28 | - | - |
| 9 | TerritoryCode | Option | 17-28 | - | - |
| 10 | AccountClassificationCode | Option | 17-28 | - | - |
| 11 | BusinessTypeCode | Option | 17-28 | - | - |
| 12 | OwningBusinessUnit | Guid | 17-28 | - | - |
| 13 | TraversedPath | Text[250] | 17-28 | - | - |
| 14 | OwningUser | Guid | 17-28 | - | - |
| 15 | PaymentTermsCode | Option | 17-25 | Removed 19.0 | This field is replaced by field 203 PaymentTermsCodeEnum. |
| 16 | ShippingMethodCode | Option | 17-28 | - | - |
| 17 | PrimaryContactId | Guid | 17-28 | - | - |
| 18 | ParticipatesInWorkflow | Boolean | 17-28 | - | - |
| 19 | Name | Text[160] | 17-28 | - | - |
| 20 | AccountNumber | Text[20] | 17-28 | - | - |
| 21 | Revenue | Decimal | 17-28 | - | - |
| 22 | NumberOfEmployees | Integer | 17-28 | - | - |
| 23 | Description | Blob | 17-28 | - | - |
| 24 | SIC | Text[20] | 17-28 | - | - |
| 25 | OwnershipCode | Option | 17-28 | - | - |
| 26 | MarketCap | Decimal | 17-28 | - | - |
| 27 | SharesOutstanding | Integer | 17-28 | - | - |
| 28 | TickerSymbol | Text[10] | 17-28 | - | - |
| 29 | StockExchange | Text[20] | 17-28 | - | - |
| 30 | WebSiteURL | Text[200] | 17-28 | - | - |
| 31 | FtpSiteURL | Text[200] | 17-28 | - | - |
| 32 | EMailAddress1 | Text[100] | 17-28 | - | - |
| 33 | EMailAddress2 | Text[100] | 17-28 | - | - |
| 34 | EMailAddress3 | Text[100] | 17-28 | - | - |
| 35 | DoNotPhone | Boolean | 17-28 | - | - |
| 36 | DoNotFax | Boolean | 17-28 | - | - |
| 37 | Telephone1 | Text[50] | 17-28 | - | - |
| 38 | DoNotEMail | Boolean | 17-28 | - | - |
| 39 | Telephone2 | Text[50] | 17-28 | - | - |
| 40 | Fax | Text[50] | 17-28 | - | - |
| 41 | Telephone3 | Text[50] | 17-28 | - | - |
| 42 | DoNotPostalMail | Boolean | 17-28 | - | - |
| 43 | DoNotBulkEMail | Boolean | 17-28 | - | - |
| 44 | DoNotBulkPostalMail | Boolean | 17-28 | - | - |
| 45 | CreditLimit | Decimal | 17-28 | - | - |
| 46 | CreditOnHold | Boolean | 17-28 | - | - |
| 47 | CreatedOn | DateTime | 17-28 | - | - |
| 48 | CreatedBy | Guid | 17-28 | - | - |
| 49 | ModifiedOn | DateTime | 17-28 | - | - |
| 50 | ModifiedBy | Guid | 17-28 | - | - |
| 51 | VersionNumber | BigInteger | 17-28 | - | - |
| 52 | ParentAccountId | Guid | 17-28 | - | - |
| 53 | Aging30 | Decimal | 17-28 | - | - |
| 54 | StateCode | Option | 17-28 | - | - |
| 55 | Aging60 | Decimal | 17-28 | - | - |
| 56 | StatusCode | Option | 17-28 | - | - |
| 57 | Aging90 | Decimal | 17-28 | - | - |
| 58 | PrimaryContactIdName | Text[160] | 17-28 | - | - |
| 59 | ParentAccountIdName | Text[160] | 17-28 | - | - |
| 60 | DefaultPriceLevelIdName | Text[100] | 17-28 | - | - |
| 61 | Address1_AddressId | Guid | 17-28 | - | - |
| 62 | Address1_AddressTypeCode | Option | 17-28 | - | - |
| 63 | Address1_Name | Text[200] | 17-28 | - | - |
| 64 | Address1_PrimaryContactName | Text[100] | 17-28 | - | - |
| 65 | Address1_Line1 | Text[250] | 17-28 | - | - |
| 66 | Address1_Line2 | Text[250] | 17-28 | - | - |
| 67 | Address1_Line3 | Text[250] | 17-28 | - | - |
| 68 | Address1_City | Text[80] | 17-28 | - | - |
| 69 | Address1_StateOrProvince | Text[50] | 17-28 | - | - |
| 70 | Address1_County | Text[50] | 17-28 | - | - |
| 71 | Address1_Country | Text[80] | 17-28 | - | - |
| 72 | Address1_PostOfficeBox | Text[20] | 17-28 | - | - |
| 73 | Address1_PostalCode | Text[20] | 17-28 | - | - |
| 74 | Address1_UTCOffset | Integer | 17-28 | - | - |
| 75 | Address1_FreightTermsCode | Option | 17-25 | Removed 19.0 | This field is replaced by field 204 Address1_FreightTermsCodeEnum. |
| 76 | Address1_UPSZone | Text[4] | 17-28 | - | - |
| 77 | Address1_Latitude | Decimal | 17-28 | - | - |
| 78 | Address1_Telephone1 | Text[50] | 17-28 | - | - |
| 79 | Address1_Longitude | Decimal | 17-28 | - | - |
| 80 | Address1_ShippingMethodCode | Option | 17-25 | Removed 19.0 | This field is replaced by field 205 Address1_ShippingMethodCodeEnum. |
| 81 | Address1_Telephone2 | Text[50] | 17-28 | - | - |
| 82 | Address1_Telephone3 | Text[50] | 17-28 | - | - |
| 83 | Address1_Fax | Text[50] | 17-28 | - | - |
| 84 | Address2_AddressId | Guid | 17-28 | - | - |
| 85 | Address2_AddressTypeCode | Option | 17-28 | - | - |
| 86 | Address2_Name | Text[200] | 17-28 | - | - |
| 87 | Address2_PrimaryContactName | Text[100] | 17-28 | - | - |
| 88 | Address2_Line1 | Text[250] | 17-28 | - | - |
| 89 | Address2_Line2 | Text[250] | 17-28 | - | - |
| 90 | Address2_Line3 | Text[250] | 17-28 | - | - |
| 91 | Address2_City | Text[80] | 17-28 | - | - |
| 92 | Address2_StateOrProvince | Text[50] | 17-28 | - | - |
| 93 | Address2_County | Text[50] | 17-28 | - | - |
| 94 | Address2_Country | Text[80] | 17-28 | - | - |
| 95 | Address2_PostOfficeBox | Text[20] | 17-28 | - | - |
| 96 | Address2_PostalCode | Text[20] | 17-28 | - | - |
| 97 | Address2_UTCOffset | Integer | 17-28 | - | - |
| 98 | Address2_FreightTermsCode | Option | 17-28 | - | - |
| 99 | Address2_UPSZone | Text[4] | 17-28 | - | - |
| 100 | Address2_Latitude | Decimal | 17-28 | - | - |
| 101 | Address2_Telephone1 | Text[50] | 17-28 | - | - |
| 102 | Address2_Longitude | Decimal | 17-28 | - | - |
| 103 | Address2_ShippingMethodCode | Option | 17-28 | - | - |
| 104 | Address2_Telephone2 | Text[50] | 17-28 | - | - |
| 105 | Address2_Telephone3 | Text[50] | 17-28 | - | - |
| 106 | Address2_Fax | Text[50] | 17-28 | - | - |
| 107 | CreatedByName | Text[200] | 17-28 | - | - |
| 108 | ModifiedByName | Text[200] | 17-28 | - | - |
| 109 | OwnerId | Guid | 17-28 | - | - |
| 110 | OwnerIdType | Option | 17-28 | - | - |
| 111 | PreferredAppointmentDayCode | Option | 17-28 | - | - |
| 112 | PreferredSystemUserId | Guid | 17-28 | - | - |
| 113 | PreferredAppointmentTimeCode | Option | 17-28 | - | - |
| 114 | Merged | Boolean | 17-28 | - | - |
| 115 | DoNotSendMM | Boolean | 17-28 | - | - |
| 116 | MasterId | Guid | 17-28 | - | - |
| 117 | LastUsedInCampaign | Date | 17-28 | - | - |
| 118 | PreferredSystemUserIdName | Text[200] | 17-28 | - | - |
| 119 | MasterAccountIdName | Text[160] | 17-28 | - | - |
| 120 | ExchangeRate | Decimal | 17-28 | - | - |
| 121 | UTCConversionTimeZoneCode | Integer | 17-28 | - | - |
| 122 | OverriddenCreatedOn | Date | 17-28 | - | - |
| 123 | TimeZoneRuleVersionNumber | Integer | 17-28 | - | - |
| 124 | ImportSequenceNumber | Integer | 17-28 | - | - |
| 125 | TransactionCurrencyId | Guid | 17-28 | - | - |
| 126 | CreditLimit_Base | Decimal | 17-28 | - | - |
| 127 | TransactionCurrencyIdName | Text[100] | 17-28 | - | - |
| 128 | Aging30_Base | Decimal | 17-28 | - | - |
| 129 | Revenue_Base | Decimal | 17-28 | - | - |
| 130 | Aging90_Base | Decimal | 17-28 | - | - |
| 131 | MarketCap_Base | Decimal | 17-28 | - | - |
| 132 | Aging60_Base | Decimal | 17-28 | - | - |
| 133 | YomiName | Text[160] | 17-28 | - | - |
| 134 | CreatedOnBehalfBy | Guid | 17-28 | - | - |
| 135 | CreatedOnBehalfByName | Text[200] | 17-28 | - | - |
| 136 | ModifiedOnBehalfBy | Guid | 17-28 | - | - |
| 137 | ModifiedOnBehalfByName | Text[200] | 17-28 | - | - |
| 138 | OwningTeam | Guid | 17-28 | - | - |
| 139 | StageId | Guid | 17-28 | - | - |
| 140 | ProcessId | Guid | 17-28 | - | - |
| 141 | Address2_Composite | Blob | 17-28 | - | - |
| 142 | Address1_Composite | Blob | 17-28 | - | - |
| 143 | EntityImageId | Guid | 17-28 | - | - |
| 144 | OpenDeals | Integer | 17-28 | - | - |
| 145 | OpenDeals_Date | DateTime | 17-28 | - | - |
| 146 | OpenDeals_State | Integer | 17-28 | - | - |
| 147 | OpenRevenue | Decimal | 17-28 | - | - |
| 148 | OpenRevenue_Base | Decimal | 17-28 | - | - |
| 149 | OpenRevenue_Date | DateTime | 17-28 | - | - |
| 150 | OpenRevenue_State | Integer | 17-28 | - | - |
| 200 | AccountStatiticsId | Guid | 17-28 | - | - |
| 201 | AccountStatiticsName | Text[100] | 17-25 | Removed 24.0 | This field is obsolete. Get CRMAccountStatistics via AccountStatiticsId, then use its name. |
| 202 | CompanyId | Guid | 17-28 | - | - |
| 203 | PaymentTermsCodeEnum | Enum CDS Payment Terms Code | 17-28 | - | - |
| 204 | Address1_FreightTermsCodeEnum | Enum CDS Shipment Method Code | 17-28 | - | - |
| 205 | Address1_ShippingMethodCodeEnum | Enum CDS Shipping Agent Code | 17-28 | - | - |

## Keys

| Name | Fields | Versions |
| --- | --- | --- |
| Key1, clustered | AccountId | 17-28 |
| Key2 | Name | 17-28 |

## Source

Symbols: Microsoft.BaseApplication.symbols.437dbf0e-84ff-417a-965d-ed2bb9650972, https://dynamicssmb2.pkgs.visualstudio.com/DynamicsBCPublicFeeds/_packaging/MSSymbols/nuget/v3/index.json, highest build per major on 2026-09-20.
AL source 29: https://github.com/microsoft/BCApps, MIT, releases/29.x at a66254c3b8b5bb1cea290dc8f9d097aec4381153.

Jonas Paprotka, 2026-09-20.