Ess_ Business Headline Per Usr

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

Table Type: Company

Table Name: Ess_ Business Headline Per Usr
Database Table Name: CRONUS UK Ltd_$Ess_ Business Headline Per Usr$2a89f298-7ffd-44a5-a7ce-e08dac98abce

Table Number: 1436

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 Ess_ Business Headline Per Usr can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Ess_ Business Headline Per Usr$2a89f298-7ffd-44a5-a7ce-e08dac98abce]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Headline Name]
   ,[User Id]
   ,[Headline Text]
   ,[Headline Visible]
   ,[Headline Computation Date]
   ,[Headline Computation WorkDate]
   ,[Headline Computation Period]
   ,[VAT Return Period Record Id]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Ess_ Business Headline Per Usr$2a89f298-7ffd-44a5-a7ce-e08dac98abce]

Show/hide columns in Ess_ Business Headline Per Usr table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Headline Name Primary Key Searchint
3User Id Primary Key Searchuniqueidentifier
4Headline Text Searchnvarchar(500)
5Headline Visible Searchtinyint
6Headline Computation Date Searchdatetime
7Headline Computation WorkDate Searchdatetime
8Headline Computation Period Searchint
9VAT Return Period Record Id Searchvarbinary(448)
10$systemId Searchuniqueidentifier
11$systemCreatedAt Searchdatetime
12$systemCreatedBy Searchuniqueidentifier
13$systemModifiedAt Searchdatetime
14$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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