IntegrationSystemMaster

The IntegrationSystemMaster table describes the systems used in the integration. For Microsoft CRM Integration, each row in this table appears as an area in the Settings and Administration Tool.

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

Column	Description
SystemID	A unique identifier for the record.
Type	The type indicates whether this is a system that actually publishes and consumes. Values: 0 – Represents an internal system, or a system that doesn't publish and/or consume data. 1 – Represents an external system that publishes and/or consumes data.
Display	This field indicates whether this system is to be represented by an area in the Settings and Administration Tool. Values: 0 – no 1 – yes
DisplayOrder	[Not used in this version.]
OrgID	This is the BizTalk organization ID for this system. Because both Microsoft CRM and Microsoft Great Plains reside in the 'Home Organization' in BizTalk, they share this OrgID. This can be found in the BZBTM database in the bts_organization table.
OrgName	[Not used in this version.]
OrgQualifier	[Not used in this version.]
OrgValue	This is the display name in the Settings and Administration Tool for each tab.
SystemName	This system name is used on all messages passed back and forth as the <message_system> node in the message header. It is a user friendly way to identify the system in APIs.
DefaultConfig	[Not used in this version.]
XSLConfig	This field contains any XSL data needed to describe the settings for a system.