CRM 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
   [timestamp]
   ,[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 columns in CRM Option Mapping table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Record ID Primary Key Searchvarbinary(448)
3Option Value Searchint
4Table ID Searchint
5Integration Table ID Searchint
6Integration Field ID Searchint
7Option Value Caption Searchnvarchar(500)
8Last Synch_ Result Searchint
9Skipped Searchtinyint
10Last Synch_ Job ID Searchuniqueidentifier
11Last Synch_ CRM Result Searchint
12Last Synch_ CRM Job ID Searchuniqueidentifier
13Last Synch_ Modified On Searchdatetime
14$systemId Searchuniqueidentifier
15$systemCreatedAt Searchdatetime
16$systemCreatedBy Searchuniqueidentifier
17$systemModifiedAt Searchdatetime
18$systemModifiedBy Searchuniqueidentifier

Leave a Reply

Your email address will not be published. Required fields are marked *