Views:

Applies to Product – Dynamics 365 Finance


What’s happening?
Customers are uncertain about which column ("ID" or "RecID") should be used to identify uniqueness per row in tables when using Azure Synapse Link. They also seek clarification on any potential risks associated with continuing to use the RecID column for this purpose.


Reason:
The confusion arises due to the presence of two columns ("ID" and "RecID") in tables within Azure Synapse Link. Each column serves as a unique identifier but differs in scope and usage.


Resolution:
The following guidance clarifies the recommended usage of the "ID" and "RecID" columns:

  • ID Column:
  • Typically a globally unique identifier (GUID).
  • Ensures uniqueness across all records and tables.
  • Recommended for scenarios involving integration and data consistency across multiple systems or services.
  • RecID Column:
  • Usually a unique identifier within a specific table only.
  • Ensures uniqueness within the table but may not guarantee global uniqueness across different tables.
Recommended Practice:
- For scenarios involving integration with other systems or services, it is recommended to use the ID column to ensure global uniqueness and data consistency. - If the use case is strictly limited to operations within a single table, the RecID column can be safely used without significant risk.