O365 Document Sent History

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

Table Type: Company

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

Table Number: 2158

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 O365 Document Sent History can be queried.

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Document Type]
   ,[Document No_]
   ,[Posted]
   ,[Created Date-Time]
   ,[Source Type]
   ,[Source No_]
   ,[Job Queue Entry ID]
   ,[Job Last Status]
   ,[Job Completed]
   ,[Notified]
   ,[NotificationCleared]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$O365 Document Sent History$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in O365 Document Sent History table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Document Type Primary Key Searchint
3Document No_ Primary Key Searchnvarchar(40)
4Posted Primary Key Searchtinyint
5Created Date-Time Primary Key Searchdatetime
6Source Type Searchint
7Source No_ Searchnvarchar(40)
8Job Queue Entry ID Searchuniqueidentifier
9Job Last Status Searchint
10Job Completed Searchdatetime
11Notified Searchtinyint
12NotificationCleared Searchtinyint
13$systemId Searchuniqueidentifier
14$systemCreatedAt Searchdatetime
15$systemCreatedBy Searchuniqueidentifier
16$systemModifiedAt Searchdatetime
17$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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