IntegrationSystemEntity
The IntegrationSystemEntity table describes each entity that each system either publishes or consumes.
If you customize the integration to include a new entity, a record must be added to this table to represent the new entity.
| Column | Description |
| EntityID | A unique identifier for the record. |
| EntityType | The name of the entity, for example, account. |
| SourceSchemaName | The name of the document used to define the outbound version of this entity. This exists as a BizTalk docspec, using the <SourceSchemaName> as the name of the file. This name cannot contain spaces. |
| DestinationSchemaName | The name of the document used to define the inbound version of this entity. This exists as a BizTalk docspec, using the <DestinationSchemaName> as the name of the file. This name cannot contain spaces. |
| EntityDescription | A description based on the name of the entity in the system, such as 'Sales Order Detail' where the entitytype is 'salesorderdetail'. |
| SystemID | The ID of the system this entity comes from, and/or goes to. It is from IntegrationSystemMaster.SystemID. |
| DefaultLinkValue | This value is returned when a link is requested for an entity of this type and a value cannot be found.
For example, if shippingmethod (entitytype) cannot be found in the Microsoft CRM system, this link value is returned. |
| Publish | Specifies whether this entity is one that is published.
Values: 1 – yes 0 – no |
| Type | The type of the entity.
Values: 1 – picklist 0 – entity (such as account or customer) |
| ParentEntity | Specifies which entity the current entity is related to. This is used for picklists1.
For example, for account-paymenttermscode, the ParentEntity is the entity account's EntityID which is a GUID. |
| SystemEntityID | Specifies how the entity is referred to by its system.
For example, eEnterprise entities are referred to by SQL Server tables. Microsoft CRM entities are referred to by the MSCRMDatabase.Entity.ObjectTypeCode fields or by picklist1 names. |
| ActualEntity | This field is used if the entity in this table does not represent a 'real' entity in the system. In this case, this field contains the GUID for the real entity.
For example, the Microsoft CRM account entity's XML schema contains the data address1 and address2 for the account. Because these addresses flow out of Microsoft CRM in an account, but are actually treated like addresses in Microsoft Great Plains, the ActualEntity is marked as the account to indicate what kind of document this is published as. |
| XmlConfig | [Not used in this version.] |
| XslConfig | This field contains additional XSL data needed for this entity. |
1 For more information about picklists in Microsoft CRM, refer to the Microsoft CRM SDK at msdn.microsoft.com/library/default.asp?url=/library/en-us/CrmSdk1_2/htm/v1d2customizationobjects.asp.