IntegrationMessageDetails

The IntegrationMessageDetails table contains specific pieces of information about each message published into the system. Most of this data is already in the IntegrationMessage table, but it is cached here for quick access.

Note   Two timestamps are stored because the timestamp on the message itself is not guaranteed to be granular enough. If it goes to the second only, the system may not be able to tell which message was received if the second is the same as the first. The IntegrationTimestamp is stored to the millisecond to resolve these discrepancies.

Warning   Modifying this table could cause malfunctions in the integration process.

Column	Description
MessageID	The message ID from IntegrationMessage.MessageID.
DocumentType	The class name, including the namespace, that knows how to read this kind of message.
DocumentTypeAssembly	The name of the file (assembly or DLL) that contains the DocumentType class. <DocumentTypeAssembly> in conjunction with <DocumentType> is used to create the object at run time to read the message.
Action	The message_action from the message header.
EntityType	The message_objecttype from the message header.
EntityKey	The message_objectid from the message header. This field can store any string value including XML.
Timestamp	The message_timestamp from the message header.
IntegrationTimestamp	The time when the message was received by the integration.