Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/5336
Table Type: Company
Table Name: Integration Field Mapping
Database Table Name: CRONUS UK Ltd_$Integration Field Mapping$437dbf0e-84ff-417a-965d-ed2bb9650972
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 Integration Field Mapping can be queried.
Show/hide an example select of all columns
SELECT
*
FROM
[CRONUS UK Ltd_$Integration Field Mapping$437dbf0e-84ff-417a-965d-ed2bb9650972]
Show/hide an example select of all columns by name
SELECT
[timestamp]
,[No_]
,[Integration Table Mapping Name]
,[Field No_]
,[Integration Table Field No_]
,[Direction]
,[Constant Value]
,[Validate Field]
,[Validate Integration Table Fld]
,[Clear Value on Failed Sync]
,[Status]
,[Not Null]
,[Transformation Rule]
,[Transformation Direction]
,[Use For Match-Based Coupling]
,[Case-Sensitive Matching]
,[Match Priority]
,[$systemId]
,[$systemCreatedAt]
,[$systemCreatedBy]
,[$systemModifiedAt]
,[$systemModifiedBy]
FROM
[CRONUS UK Ltd_$Integration Field Mapping$437dbf0e-84ff-417a-965d-ed2bb9650972]