Social Listening Setup

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

Table Type: Company

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

Table Number: 870

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 Social Listening Setup can be queried.

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Primary Key]
   ,[Solution ID]
   ,[Show on Items]
   ,[Show on Customers]
   ,[Show on Vendors]
   ,[Accept License Agreement]
   ,[Terms of Use URL]
   ,[Signup URL]
   ,[Social Listening URL]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Social Listening Setup$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Social Listening Setup table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Primary Key Primary Key Searchnvarchar(20)
3Solution ID Searchnvarchar(500)
4Show on Items Searchtinyint
5Show on Customers Searchtinyint
6Show on Vendors Searchtinyint
7Accept License Agreement Searchtinyint
8Terms of Use URL Searchnvarchar(500)
9Signup URL Searchnvarchar(500)
10Social Listening URL Searchnvarchar(500)
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 *