查询 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

 

posted @ 2024-07-02 17:54  不是豆豆  阅读(2)  评论(0编辑  收藏  举报
友情链接:迷途