Exchange Object

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

Table Type: Company

Table Name: Exchange Object
Database Table Name: CRONUS UK Ltd_$Exchange Object$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 1602

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 Exchange Object can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Exchange Object$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Item ID]
   ,[Type]
   ,[Name]
   ,[Body]
   ,[Parent ID]
   ,[Content]
   ,[ViewLink]
   ,[Owner]
   ,[Selected]
   ,[Content Type]
   ,[InitiatedAction]
   ,[VendorNo]
   ,[IsInline]
   ,[RecId]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Exchange Object$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Exchange Object table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Item ID Primary Key Searchnvarchar(500)
3Type Searchint
4Name Searchnvarchar(500)
5Body Searchimage
6Parent ID Searchnvarchar(500)
7Content Searchimage
8ViewLink Searchimage
9Owner Searchuniqueidentifier
10Selected Searchtinyint
11Content Type Searchnvarchar(500)
12InitiatedAction Searchint
13VendorNo Searchnvarchar(100)
14IsInline Searchtinyint
15RecId Searchvarbinary(448)
16$systemId Searchuniqueidentifier
17$systemCreatedAt Searchdatetime
18$systemCreatedBy Searchuniqueidentifier
19$systemModifiedAt Searchdatetime
20$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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