CRM Option Mapping – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables CCRM Option Mapping

Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/5334

Table Type: Company

Table Name: CRM Option Mapping
Database Table Name: CRONUS UK Ltd_$CRM Option Mapping$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 5334

Due to how Dynamics BC tables and columns are named, square brackets need to be wrapped around the table name and column names. Below are example queries showing how CRM Option Mapping can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$CRM Option Mapping$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT

   [Record ID]
   ,[Option Value]
   ,[Table ID]
   ,[Integration Table ID]
   ,[Integration Field ID]
   ,[Option Value Caption]
   ,[Last Synch_ Result]
   ,[Skipped]
   ,[Last Synch_ Job ID]
   ,[Last Synch_ CRM Result]
   ,[Last Synch_ CRM Job ID]
   ,[Last Synch_ Modified On]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$CRM Option Mapping$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns including those from all joined tables

SELECT
   *
FROM
   [CRONUS UK Ltd_$CRM Option Mapping$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [CRM Option Mapping]
LEFT JOIN
   [CRONUS UK Ltd_$Data Exch_ Mapping$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Data Exch. Mapping]
      ON
         [CRM Option Mapping].[Table ID] = [Data Exch. Mapping].[Table ID]
LEFT JOIN
   [User] AS [User]
      ON
         [CRM Option Mapping].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [CRM Option Mapping].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in CRM Option Mapping table

Field No.	Field Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	Record ID	Record ID	Normal	RecordID	448	Record ID	varbinary(448)
2	Option Value	Option Value	Normal	Integer	4	Option Value	int
3	Table ID	Table ID	Normal	Integer	4	Table ID	int
	Key to join to the Data Exch. Mapping table. Show/hide example query SELECT [CRM Option Mapping].[Table ID] ,[Data Exch. Mapping].[Table ID] FROM [CRONUS UK Ltd_$CRM Option Mapping$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [CRM Option Mapping] LEFT JOIN [CRONUS UK Ltd_$Data Exch_ Mapping$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Data Exch. Mapping] ON [CRM Option Mapping].[Table ID] = [Data Exch. Mapping].[Table ID]
4	Integration Table ID	Integration Table ID	Normal	Integer	4	Integration Table ID	int
5	Integration Field ID	Integration Field ID	Normal	Integer	4	Integration Field ID	int
6	Option Value Caption	Option Value Caption	Normal	Text	250	Option Value Caption	nvarchar(500)
7	Last Synch. Result	Last Synch. Result	Normal	Option	4	Last Synch_ Result	int
	Available options are: “” “Success” “Failure”
8	Skipped	Skipped	Normal	Boolean	4	Skipped	tinyint
9	Last Synch. Job ID	Last Synch. Job ID	Normal	GUID	16	Last Synch_ Job ID	uniqueidentifier
10	Last Synch. CRM Result	Last Synch. CRM Result	Normal	Option	4	Last Synch_ CRM Result	int
	Available options are: “” “Success” “Failure”
11	Last Synch. CRM Job ID	Last Synch. CRM Job ID	Normal	GUID	16	Last Synch_ CRM Job ID	uniqueidentifier
12	Last Synch. Modified On	Last Synch. Modified On	Normal	DateTime	8	Last Synch_ Modified On	datetime
2000000000	$systemId	System ID	Normal	GUID	16	$systemId	uniqueidentifier
2000000001	SystemCreatedAt	Created At	Normal	DateTime	8	$systemCreatedAt	datetime
2000000002	SystemCreatedBy	Created By	Normal	GUID	16	$systemCreatedBy	uniqueidentifier
	Key to join to the User table. Show/hide example query SELECT [CRM Option Mapping].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$CRM Option Mapping$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [CRM Option Mapping] LEFT JOIN [User] AS [User] ON [CRM Option Mapping].[$systemCreatedBy] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier