MGCLatticeCrossReference
The MGCLatticeCrossReference table stores external systems' keys for D365 records, at most one key per record and external system, per legal entity.
Fields
| Name | Type | Mandatory | Description |
|---|---|---|---|
Target | MGCLatticeCrossReferenceTarget | Yes | |
RefTableId | RefTableId | Yes | |
RefRecId | RefRecId | Yes | |
ExternalSystemId | MGCLatticeExternalSystemId | Yes | The external system, such as a CRM, a marketplace or a legacy ERP, whose key this is. |
ExternalKey | MGCLatticeExternalKey | Yes | The external system's own key for this record, such as its customer or order number. |
UniquenessDiscriminator | RefRecId | No | 0 when the settings of the target and external system require unique keys, so the database rejects a duplicated key; otherwise the record ID, so different records can share a key. |