Attachment

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

Table Type: Company

Table Name: Attachment
Database Table Name: CRONUS UK Ltd_$Attachment$114e4e19-182b-42e2-b5a9-91d8b8ee8ce1

Table Number: 0

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

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Attachment$114e4e19-182b-42e2-b5a9-91d8b8ee8ce1]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[No_]
   ,[Internet Message ID]
   ,[Attachment File]
   ,[Storage Type]
   ,[Internet Message Checksum]
   ,[Storage Pointer]
   ,[File Extension]
   ,[Read Only]
   ,[Last Date Modified]
   ,[Last Time Modified]
   ,[Merge Source]
   ,[Email Message ID]
   ,[Email Entry ID]
   ,[Email Message Checksum]
   ,[Email Message Url]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Attachment$114e4e19-182b-42e2-b5a9-91d8b8ee8ce1]

Show/hide columns in Attachment table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2No_ Primary Key Searchint
3Attachment File Searchimage
3Internet Message ID Searchimage
4Internet Message Checksum Searchint
4Storage Type Searchint
5Storage Pointer Searchnvarchar(500)
6File Extension Searchnvarchar(500)
7Read Only Searchtinyint
8Last Date Modified Searchdatetime
9Last Time Modified Searchdatetime
10Merge Source Searchimage
11Email Message ID Searchimage
12Email Entry ID Searchimage
13Email Message Checksum Searchint
14Email Message Url Searchimage
15$systemId Searchuniqueidentifier
16$systemCreatedAt Searchdatetime
17$systemCreatedBy Searchuniqueidentifier
18$systemModifiedAt Searchdatetime
19$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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