The MS-CRM contains many entities of type Activity. Few of the most widely used activities are PhoneCall, Email, Appointment etc..
When the activity record is created in MS-CRM, it internally loads 3 tables with the provided information
ActivityPointerBase table contains one record for each activity record that is created in the MS-CRM. While ActivityPartyBase table hols the information of the parties (participants) for particular Activity record.
Following tables are used in the query to find the distribution of the activities across
When the activity record is created in MS-CRM, it internally loads 3 tables with the provided information
- Base table for the Activity. Ex. - AppointmentBase
- ActivityPointerBase
- ActivityPartyBase
ActivityPointerBase table contains one record for each activity record that is created in the MS-CRM. While ActivityPartyBase table hols the information of the parties (participants) for particular Activity record.
Following tables are used in the query to find the distribution of the activities across
