Table 5341 CRM Account in 18

Jonas Paprotka, Base Application 18.5.29545.46345, checked 2026-09-20

App: Base Application

Versions171819 20 21 22 23 24 25 26 27 28 latest

Source29

Fields, 156

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

Keys, 2

Name	Fields	Obsolete
Key1, clustered	AccountId	-
Key2	Name	-