Table 5341 CRM Account

Base Application, Microsoft.Integration.D365Sales

152 fields

IdNameTypeVersions
1AccountIdGuid17-29
2AccountCategoryCodeOption17-29
3DefaultPriceLevelIdGuid17-29
4CustomerSizeCodeOption17-29
5PreferredContactMethodCodeOption17-29
6CustomerTypeCodeOption17-29
7AccountRatingCodeOption17-29
8IndustryCodeOption17-29
9TerritoryCodeOption17-29
10AccountClassificationCodeOption17-29
11BusinessTypeCodeOption17-29
12OwningBusinessUnitGuid17-29
13TraversedPathText[250]17-29
14OwningUserGuid17-29
16ShippingMethodCodeOption17-29
17PrimaryContactIdGuid17-29
18ParticipatesInWorkflowBoolean17-29
19NameText[160]17-29
20AccountNumberText[20]17-29
21RevenueDecimal17-29
22NumberOfEmployeesInteger17-29
23DescriptionBlob17-29
24SICText[20]17-29
25OwnershipCodeOption17-29
26MarketCapDecimal17-29
27SharesOutstandingInteger17-29
28TickerSymbolText[10]17-29
29StockExchangeText[20]17-29
30WebSiteURLText[200]17-29
31FtpSiteURLText[200]17-29
32EMailAddress1Text[100]17-29
33EMailAddress2Text[100]17-29
34EMailAddress3Text[100]17-29
35DoNotPhoneBoolean17-29
36DoNotFaxBoolean17-29
37Telephone1Text[50]17-29
38DoNotEMailBoolean17-29
39Telephone2Text[50]17-29
40FaxText[50]17-29
41Telephone3Text[50]17-29
42DoNotPostalMailBoolean17-29
43DoNotBulkEMailBoolean17-29
44DoNotBulkPostalMailBoolean17-29
45CreditLimitDecimal17-29
46CreditOnHoldBoolean17-29
47CreatedOnDateTime17-29
48CreatedByGuid17-29
49ModifiedOnDateTime17-29
50ModifiedByGuid17-29
51VersionNumberBigInteger17-29
52ParentAccountIdGuid17-29
53Aging30Decimal17-29
54StateCodeOption17-29
55Aging60Decimal17-29
56StatusCodeOption17-29
57Aging90Decimal17-29
58PrimaryContactIdNameText[160]17-29
59ParentAccountIdNameText[160]17-29
60DefaultPriceLevelIdNameText[100]17-29
61Address1_AddressIdGuid17-29
62Address1_AddressTypeCodeOption17-29
63Address1_NameText[200]17-29
64Address1_PrimaryContactNameText[100]17-29
65Address1_Line1Text[250]17-29
66Address1_Line2Text[250]17-29
67Address1_Line3Text[250]17-29
68Address1_CityText[80]17-29
69Address1_StateOrProvinceText[50]17-29
70Address1_CountyText[50]17-29
71Address1_CountryText[80]17-29
72Address1_PostOfficeBoxText[20]17-29
73Address1_PostalCodeText[20]17-29
74Address1_UTCOffsetInteger17-29
76Address1_UPSZoneText[4]17-29
77Address1_LatitudeDecimal17-29
78Address1_Telephone1Text[50]17-29
79Address1_LongitudeDecimal17-29
81Address1_Telephone2Text[50]17-29
82Address1_Telephone3Text[50]17-29
83Address1_FaxText[50]17-29
84Address2_AddressIdGuid17-29
85Address2_AddressTypeCodeOption17-29
86Address2_NameText[200]17-29
87Address2_PrimaryContactNameText[100]17-29
88Address2_Line1Text[250]17-29
89Address2_Line2Text[250]17-29
90Address2_Line3Text[250]17-29
91Address2_CityText[80]17-29
92Address2_StateOrProvinceText[50]17-29
93Address2_CountyText[50]17-29
94Address2_CountryText[80]17-29
95Address2_PostOfficeBoxText[20]17-29
96Address2_PostalCodeText[20]17-29
97Address2_UTCOffsetInteger17-29
98Address2_FreightTermsCodeOption17-29
99Address2_UPSZoneText[4]17-29
100Address2_LatitudeDecimal17-29
101Address2_Telephone1Text[50]17-29
102Address2_LongitudeDecimal17-29
103Address2_ShippingMethodCodeOption17-29
104Address2_Telephone2Text[50]17-29
105Address2_Telephone3Text[50]17-29
106Address2_FaxText[50]17-29
107CreatedByNameText[200]17-29
108ModifiedByNameText[200]17-29
109OwnerIdGuid17-29
110OwnerIdTypeOption17-29
111PreferredAppointmentDayCodeOption17-29
112PreferredSystemUserIdGuid17-29
113PreferredAppointmentTimeCodeOption17-29
114MergedBoolean17-29
115DoNotSendMMBoolean17-29
116MasterIdGuid17-29
117LastUsedInCampaignDate17-29
118PreferredSystemUserIdNameText[200]17-29
119MasterAccountIdNameText[160]17-29
120ExchangeRateDecimal17-29
121UTCConversionTimeZoneCodeInteger17-29
122OverriddenCreatedOnDate17-29
123TimeZoneRuleVersionNumberInteger17-29
124ImportSequenceNumberInteger17-29
125TransactionCurrencyIdGuid17-29
126CreditLimit_BaseDecimal17-29
127TransactionCurrencyIdNameText[100]17-29
128Aging30_BaseDecimal17-29
129Revenue_BaseDecimal17-29
130Aging90_BaseDecimal17-29
131MarketCap_BaseDecimal17-29
132Aging60_BaseDecimal17-29
133YomiNameText[160]17-29
134CreatedOnBehalfByGuid17-29
135CreatedOnBehalfByNameText[200]17-29
136ModifiedOnBehalfByGuid17-29
137ModifiedOnBehalfByNameText[200]17-29
138OwningTeamGuid17-29
139StageIdGuid17-29
140ProcessIdGuid17-29
141Address2_CompositeBlob17-29
142Address1_CompositeBlob17-29
143EntityImageIdGuid17-29
144OpenDealsInteger17-29
145OpenDeals_DateDateTime17-29
146OpenDeals_StateInteger17-29
147OpenRevenueDecimal17-29
148OpenRevenue_BaseDecimal17-29
149OpenRevenue_DateDateTime17-29
150OpenRevenue_StateInteger17-29
200AccountStatiticsIdGuid17-29
202CompanyIdGuid17-29
203PaymentTermsCodeEnumEnum "CDS Payment Terms Code"17-29
204Address1_FreightTermsCodeEnumEnum "CDS Shipment Method Code"17-29
205Address1_ShippingMethodCodeEnumEnum "CDS Shipping Agent Code"17-29