Ext Txt ID Integration Record

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

Table Type: Company

Table Name: Ext Txt ID Integration Record
Database Table Name: CRONUS UK Ltd_$Ext Txt ID Integration Record$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 5377

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 Ext Txt ID Integration Record can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Ext Txt ID Integration Record$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[External ID]
   ,[Integration ID]
   ,[Last Synch_ Modified On]
   ,[Last Synch_ Ext Modified On]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Ext Txt ID Integration Record$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Ext Txt ID Integration Record table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2External ID Primary Key Searchnvarchar(500)
3Integration ID Primary Key Searchuniqueidentifier
4Last Synch_ Modified On Searchdatetime
5Last Synch_ Ext Modified On Searchdatetime
6$systemId Searchuniqueidentifier
7$systemCreatedAt Searchdatetime
8$systemCreatedBy Searchuniqueidentifier
9$systemModifiedAt Searchdatetime
10$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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