Document Attachment

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

Table Type: Company

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

Table Number: 1173

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Table ID]
   ,[No_]
   ,[Document Type]
   ,[Line No_]
   ,[ID]
   ,[Attached Date]
   ,[File Name]
   ,[File Type]
   ,[File Extension]
   ,[Document Reference ID]
   ,[Attached By]
   ,[Document Flow Purchase]
   ,[Document Flow Sales]
   ,[VAT Report Config_ Code]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Document Attachment$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Document Attachment table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Table ID Primary Key Searchint
3No_ Primary Key Searchnvarchar(40)
4Document Type Primary Key Searchint
5Line No_ Primary Key Searchint
6ID Primary Key Searchint
7Attached Date Searchdatetime
8File Name Searchnvarchar(500)
9File Type Searchint
10File Extension Searchnvarchar(60)
11Document Reference ID Searchuniqueidentifier
12Attached By Searchuniqueidentifier
13Document Flow Purchase Searchtinyint
14Document Flow Sales Searchtinyint
15VAT Report Config_ Code Searchint
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 *