Temp Integration Field Mapping

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

Table Type: Company

Table Name: Temp Integration Field Mapping
Database Table Name: CRONUS UK Ltd_$Temp Integration Field Mapping$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 5337

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 Temp Integration Field Mapping can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Temp Integration Field Mapping$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [No_]
   ,[Integration Table Mapping Name]
   ,[Source Field No_]
   ,[Destination Field No_]
   ,[Validate Destination Field]
   ,[Bidirectional]
   ,[Constant Value]
   ,[Not Null]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Temp Integration Field 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_$Temp Integration Field Mapping$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Temp Integration Field Mapping]
LEFT JOIN
   [CRONUS UK Ltd_$Integration Table Mapping$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Integration Table Mapping]
      ON
         [Temp Integration Field Mapping].[Integration Table Mapping Name] = [Integration Table Mapping].[Name]
LEFT JOIN
   [User] AS [User]
      ON
         [Temp Integration Field Mapping].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Temp Integration Field Mapping].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Temp Integration Field Mapping table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1No. Primary Key SearchNo.NormalInteger4No_int
2Integration Table Mapping Name SearchIntegration Table Mapping NameNormalCode20Integration Table Mapping Namenvarchar(40)
Key to join to the Integration Table Mapping table.

Show/hide example query

SELECT
       [Temp Integration Field Mapping].[Integration Table Mapping Name]
       ,[Integration Table Mapping].[Name]
FROM
       [CRONUS UK Ltd_$Temp Integration Field Mapping$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Temp Integration Field Mapping]
LEFT JOIN
       [CRONUS UK Ltd_$Integration Table Mapping$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Integration Table Mapping]
              ON
                     [Temp Integration Field Mapping].[Integration Table Mapping Name] = [Integration Table Mapping].[Name]
3Source Field No. SearchSource Field No.NormalInteger4Source Field No_int
4Destination Field No. SearchDestination Field No.NormalInteger4Destination Field No_int
5Validate Destination Field SearchValidate Destination FieldNormalBoolean4Validate Destination Fieldtinyint
6Bidirectional SearchBidirectionalNormalBoolean4Bidirectionaltinyint
7Constant Value SearchConstant ValueNormalText100Constant Valuenvarchar(200)
8Not Null SearchNot NullNormalBoolean4Not Nulltinyint
2000000000$systemId SearchSystem IDNormalGUID16$systemIduniqueidentifier
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8$systemCreatedAtdatetime
2000000002SystemCreatedBy SearchCreated ByNormalGUID16$systemCreatedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Temp Integration Field Mapping].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Temp Integration Field Mapping$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Temp Integration Field Mapping]
LEFT JOIN
       [User] AS [User]
              ON
                     [Temp Integration Field Mapping].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Temp Integration Field Mapping].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Temp Integration Field Mapping$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Temp Integration Field Mapping]
LEFT JOIN
       [User] AS [User]
              ON
                     [Temp Integration Field Mapping].[$systemModifiedBy] = [User].[User Security ID]

Leave a Reply

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