What is Activity table and why should I use it instead of standard table?
I have come across to "Activity Table" type, however I could not get the clarity on how it could be more useful than the "Standard Table" - Can anyone please provide me the reference link or explain in which scenario I should use that?
I think it explains it pretty clearly. Essentially, Activity tables represent something that you can schedule and put on a calendar, and that you would like to track its completion. They have certain shared properties like start and end date etc. They can be shown in the Timeline control. Security is a consideration when creating custom Activity tables as you can only set a security role’s permissions to be for all Activities, not at an individual Activity table level.
An example of a custom activity is a Site Visit - where a user has a time booked to visit a client on a building site, for example, and this activity is used to report on how often site visits are completed etc.
I hope that makes sense. Let us know if you have a certain scenario you are thinking of using the Activity table for, but are not sure
CRM Activity Party List field is a special type of lookup field which refers to multiple entities. To hold or store these multiple entities references, Microsoft has provided one special type of entity named Activity Party.
Activity Party, has one special field called Party Id. which has the capability to store multiple entities references like user, contact, account, lead etc.