Integration Record Table
Contains information that acts as a map between integration IDs, which point to records in Microsoft Dynamics CRM, and record IDs, which point to records in Microsoft Dynamics NAV. Using this information, the Connector for Microsoft Dynamics locates records in Microsoft Dynamics NAV and can determine when records are modified or deleted.
When you enable integration, Microsoft Dynamics NAV creates an identifier for all records that are available for integration. The Integration Record table contains the integration ID, which is a GUID, for each record. After you complete the integration of Microsoft Dynamics NAV and Microsoft Dynamics CRM, the GUID information also exists in the Microsoft Dynamics CRM database. Both applications then have a common method to point to records.
When you modify or delete a record in Microsoft Dynamics NAV, the Deleted On and Modified On fields in the table are populated with time stamp information, which is then sent to the Connector for Microsoft Dynamics during synchronization. If you delete a record in Microsoft Dynamics NAV, the Record ID field is cleared, because there is no record to point to.
|If you disable the Connector and enable it again, then all records that you have previously synchronized will have their time stamp information updated in the Modified On field. In this way, the Connector can track all modifications that may have occurred when the Connector was disabled and reintegrates all records.|
The table includes the following information:
The identifier of the table that contains the record that is identified in the Record ID field. For more information, see Table ID Field.
The identifier of the page through which you interact with the record that is identified in the Record ID field. For more information, see Page ID Field (Integration Record).
A record identifier, which identifies a record in Microsoft Dynamics NAV. For more information, see Record ID Field.
A GUID in the Integration ID field, which provides a unique identifier for synchronization. For more information, see Integration ID Field.
The time that the record was deleted in Microsoft Dynamics NAV. The field has no value if the record has not been deleted. For more information, see Deleted On Field.
The time that the record was modified in Microsoft Dynamics NAV. For more information, see Modified On Field.
This information is used to prevent a record that you intentionally deleted from Microsoft Dynamics NAV from being resynchronized and readded with the Connector for Microsoft Dynamics.
|If you disable integration with the Connector for Microsoft Dynamics, for example, to upgrade Microsoft Dynamics CRM, doing so does not cause a cleanup of the Integration Records table. You can stop and start the Connector for Microsoft Dynamics again without losing a connection to Microsoft Dynamics CRM. However, Microsoft Dynamics NAV examines the Integration Records table and locates records that have been deleted since the Connector was enabled. Microsoft Dynamics NAV marks those records as deleted.|