Office Document Selection

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

Table Type: Company

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

Table Number: 1620

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Series]
   ,[Document Type]
   ,[Document No_]
   ,[Posted]
   ,[Document Date]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Office Document Selection$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Office Document Selection table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Series Primary Key Searchint
3Document Type Primary Key Searchint
4Document No_ Primary Key Searchnvarchar(40)
5Posted Primary Key Searchtinyint
6Document Date Searchdatetime
7$systemId Searchuniqueidentifier
8$systemCreatedAt Searchdatetime
9$systemCreatedBy Searchuniqueidentifier
10$systemModifiedAt Searchdatetime
11$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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