Cancelled Document

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

Table Type: Company

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

Table Number: 1900

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Source ID]
   ,[Cancelled Doc_ No_]
   ,[Cancelled By Doc_ No_]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Cancelled Document$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Cancelled Document table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Source ID Primary Key Searchint
3Cancelled Doc_ No_ Primary Key Searchnvarchar(40)
4Cancelled By Doc_ No_ Searchnvarchar(40)
5$systemId Searchuniqueidentifier
6$systemCreatedAt Searchdatetime
7$systemCreatedBy Searchuniqueidentifier
8$systemModifiedAt Searchdatetime
9$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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