Incoming Document Attachment

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

Table Type: Company

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

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Incoming Document Entry No_]
   ,[Line No_]
   ,[Created Date-Time]
   ,[Created By User Name]
   ,[Name]
   ,[Type]
   ,[File Extension]
   ,[Content]
   ,[Document No_]
   ,[Posting Date]
   ,[Default]
   ,[Use for OCR]
   ,[External Document Reference]
   ,[OCR Service Document Reference]
   ,[Generated from OCR]
   ,[Main Attachment]
   ,[Id]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Incoming Document Attachment$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Incoming Document Attachment table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Incoming Document Entry No_ Primary Key Searchint
3Line No_ Primary Key Searchint
4Created Date-Time Searchdatetime
5Created By User Name Searchnvarchar(100)
6Name Searchnvarchar(500)
7Type Searchint
8File Extension Searchnvarchar(60)
9Content Searchimage
10Document No_ Searchnvarchar(40)
11Posting Date Searchdatetime
12Default Searchtinyint
13Use for OCR Searchtinyint
14External Document Reference Searchnvarchar(100)
15OCR Service Document Reference Searchnvarchar(100)
16Generated from OCR Searchtinyint
17Main Attachment Searchtinyint
18Id Searchuniqueidentifier
19$systemId Searchuniqueidentifier
20$systemCreatedAt Searchdatetime
21$systemCreatedBy Searchuniqueidentifier
22$systemModifiedAt Searchdatetime
23$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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