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
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 ID | Column Name | Data Type |
|---|---|---|
| 1 | timestamp  | timestamp |
| 2 | No_  | int |
| 3 | Attachment File | image |
| 3 | Internet Message ID | image |
| 4 | Internet Message Checksum | int |
| 4 | Storage Type | int |
| 5 | Storage Pointer | nvarchar(500) |
| 6 | File Extension | nvarchar(500) |
| 7 | Read Only | tinyint |
| 8 | Last Date Modified | datetime |
| 9 | Last Time Modified | datetime |
| 10 | Merge Source | image |
| 11 | Email Message ID | image |
| 12 | Email Entry ID | image |
| 13 | Email Message Checksum | int |
| 14 | Email Message Url | image |
| 15 | $systemId | uniqueidentifier |
| 16 | $systemCreatedAt | datetime |
| 17 | $systemCreatedBy | uniqueidentifier |
| 18 | $systemModifiedAt | datetime |
| 19 | $systemModifiedBy | uniqueidentifier |