查询 dynamic crm 中,TypeCode 对应的实体名称
查询语句:
select EntityId, Name, ObjectTypeCode, OriginalLocalizedName from EntityView order by ObjectTypeCode
常用列表:
|
Name |
ObjectTypeCode |
|
Account |
1 |
|
Contact |
2 |
|
Opportunity |
3 |
|
Lead |
4 |
|
Annotation |
5 |
|
BusinessUnitMap |
6 |
|
Owner |
7 |
|
SystemUser |
8 |
|
Team |
9 |
|
BusinessUnit |
10 |
|
PrincipalObjectAccess |
11 |
|
RolePrivileges |
12 |
|
SystemUserLicenses |
13 |
|
SystemUserPrincipals |
14 |
|
SystemUserRoles |
15 |
|
AccountLeads |
16 |
|
ContactInvoices |
17 |
|
ContactQuotes |
18 |
|
ContactOrders |
19 |
|
ServiceContractContacts |
20 |
|
ProductSalesLiterature |
21 |
|
ContactLeads |
22 |
|
TeamMembership |
23 |
|
LeadCompetitors |
24 |
|
OpportunityCompetitors |
25 |
|
CompetitorSalesLiterature |
26 |
|
LeadProduct |
27 |
|
RoleTemplatePrivileges |
28 |
|
Subscription |
29 |
|
FilterTemplate |
30 |
|
PrivilegeObjectTypeCodes |
31 |
|
SalesProcessInstance |
32 |
|
SubscriptionSyncInfo |
33 |
|
SubscriptionTrackingDeletedObject |
35 |
|
ClientUpdate |
36 |
|
SubscriptionManuallyTrackedObject |
37 |
|
SharedObjectsForRead |
39 |
|
TeamRoles |
40 |
|
PrincipalEntityMap |
41 |
|
SystemUserBusinessUnitEntityMap |
42 |
|
PrincipalAttributeAccessMap |
43 |
|
PrincipalObjectAttributeAccess |
44 |
|
SubscriptionStatisticsOffline |
45 |
|
SubscriptionStatisticsOutlook |
46 |
|
SubscriptionSyncEntryOffline |
47 |
|
SubscriptionSyncEntryOutlook |
48 |
|
Position |
50 |
|
SystemUserManagerMap |
51 |
|
UserSearchFacet |
52 |
|
PrincipalObjectAccessReadSnapshot |
90 |
|
RecordCountSnapshot |
91 |
|
TeamTemplate |
92 |
|
SocialProfile |
99 |
输了你,赢了世界又如何...

浙公网安备 33010602011771号