IntegrationEntityInstance
The IntegrationEntityInstance table contains a record for each entity that is created in Microsoft CRM or Microsoft Great Plains. Each record represents a single entity instance in a single system. The presence of an instance indicates that the instance is alive in its respective system. When an instance has been removed, it is automatically sent to the IntegrationEntityInstanceArchive table. This occurs when the instance is deleted from its respective system.
Warning Modifying this table could cause malfunctions in the integration process.
Column | Description |
IntID | A unique identifier for the record. |
SystemID | The ID of the system where the record exists. This comes from IntegrationSystemMaster.SystemID. |
EntityType | The type of the entity. This comes from IntegrationSystemEntity.EntityType. |
EntityKey | The unique key that identifies the entity. This field can store any string value including XML. |
LastModified | The current time when the record is modified. |