Office Add-in Context

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

Table Type: Company

Table Name: Office Add-in Context
Database Table Name: CRONUS UK Ltd_$Office Add-in Context$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 1600

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 Add-in Context can be queried.

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [Email]
   ,[Name]
   ,[Document Type]
   ,[Document No_]
   ,[Regular Expression Match]
   ,[Duration]
   ,[Command]
   ,[Item ID]
   ,[Version]
   ,[Contact No_]
   ,[Subject]
   ,[Item Type]
   ,[Mode]
   ,[Company]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Office Add-in Context$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns including those from all joined tables

SELECT
   *
FROM
   [CRONUS UK Ltd_$Office Add-in Context$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Office Add-in Context]
LEFT JOIN
   [CRONUS UK Ltd_$Sales Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header Archive]
      ON
         [Office Add-in Context].[Document Type] = [Sales Header Archive].[Document Type]
      AND
         [Office Add-in Context].[Document No_] = [Sales Header Archive].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header]
      ON
         [Office Add-in Context].[Document Type] = [Sales Header].[Document Type]
      AND
         [Office Add-in Context].[Document No_] = [Sales Header].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Item$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item]
      ON
         [Office Add-in Context].[Item Id] = [Item].[$systemId]
LEFT JOIN
   [CRONUS UK Ltd_$Guided Experience Item$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Guided Experience Item]
      ON
         [Office Add-in Context].[Version] = [Guided Experience Item].[Version]
LEFT JOIN
   [Company] AS [Company]
      ON
         [Office Add-in Context].[Company] = [Company].[Name]
LEFT JOIN
   [User] AS [User]
      ON
         [Office Add-in Context].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Office Add-in Context].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Office Add-in Context table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Email Primary Key SearchEmailNormalText80Emailnvarchar(160)
2Name SearchNameNormalText250Namenvarchar(500)
3Document Type SearchDocument TypeNormalText20Document Typenvarchar(40)
4Document No. SearchDocument No.NormalCode250Document No_nvarchar(500)
5Regular Expression Match SearchRegular Expression MatchNormalText250Regular Expression Matchnvarchar(500)
6Duration SearchDurationNormalText20Durationnvarchar(40)
8Command SearchCommandNormalText30Commandnvarchar(60)
12Item ID SearchItem IDNormalText250Item IDnvarchar(500)
Key to join to the Item table.

Show/hide example query

SELECT
       [Office Add-in Context].[Item ID]
       ,[Item].[$systemId]
FROM
       [CRONUS UK Ltd_$Office Add-in Context$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Office Add-in Context]
LEFT JOIN
       [CRONUS UK Ltd_$Item$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item]
              ON
                     [Office Add-in Context].[Item ID] = [Item].[$systemId]
13Version SearchVersionNormalText20Versionnvarchar(40)
Key to join to the Guided Experience Item table.

Show/hide example query

SELECT
       [Office Add-in Context].[Version]
       ,[Guided Experience Item].[Version]
FROM
       [CRONUS UK Ltd_$Office Add-in Context$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Office Add-in Context]
LEFT JOIN
       [CRONUS UK Ltd_$Guided Experience Item$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Guided Experience Item]
              ON
                     [Office Add-in Context].[Version] = [Guided Experience Item].[Version]
14Contact No. SearchContact No.NormalCode20Contact No_nvarchar(40)
Key to join to the Contact table.

Show/hide example query

SELECT
       [Office Add-in Context].[Contact No_]
       ,[Contact].[No_]
FROM
       [CRONUS UK Ltd_$Office Add-in Context$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Office Add-in Context]
LEFT JOIN
       [CRONUS UK Ltd_$Contact$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Contact]
              ON
                     [Office Add-in Context].[Contact No_] = [Contact].[No_]
15Subject SearchSubjectNormalText250Subjectnvarchar(500)
16Item Type SearchItem TypeNormalOption4Item Typeint
Available options are:
  • “Message”
  • “Appointment”
18Mode SearchModeNormalOption4Modeint
Available options are:
  • “Read”
  • “Compose”
20Company SearchCompanyNormalText50Companynvarchar(100)
Key to join to the Company table.

Show/hide example query

SELECT
       [Office Add-in Context].[Company]
       ,[Company].[Name]
FROM
       [CRONUS UK Ltd_$Office Add-in Context$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Office Add-in Context]
LEFT JOIN
       [Company] AS [Company]
              ON
                     [Office Add-in Context].[Company] = [Company].[Name]
2000000000$systemId SearchSystem IDNormalGUID16$systemIduniqueidentifier
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8$systemCreatedAtdatetime
2000000002SystemCreatedBy SearchCreated ByNormalGUID16$systemCreatedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Office Add-in Context].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Office Add-in Context$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Office Add-in Context]
LEFT JOIN
       [User] AS [User]
              ON
                     [Office Add-in Context].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Office Add-in Context].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Office Add-in Context$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Office Add-in Context]
LEFT JOIN
       [User] AS [User]
              ON
                     [Office Add-in Context].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from Office Add-in Context table

Leave a Reply

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