Attendee

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

Table Type: Company

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

Table Number: 5199

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[To-do No_]
   ,[Line No_]
   ,[Attendance Type]
   ,[Attendee Type]
   ,[Attendee No_]
   ,[Attendee Name]
   ,[Send Invitation]
   ,[Invitation Response Type]
   ,[Invitation Sent]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Attendee$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Attendee table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2To-do No_ Primary Key Searchnvarchar(40)
3Line No_ Primary Key Searchint
4Attendance Type Searchint
5Attendee Type Searchint
6Attendee No_ Searchnvarchar(40)
7Attendee Name Searchnvarchar(200)
8Send Invitation Searchtinyint
9Invitation Response Type Searchint
10Invitation Sent Searchtinyint
11$systemId Searchuniqueidentifier
12$systemCreatedAt Searchdatetime
13$systemCreatedBy Searchuniqueidentifier
14$systemModifiedAt Searchdatetime
15$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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