Campaign Entry

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

Table Type: Company

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

Table Number: 5072

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Entry No_]
   ,[Campaign No_]
   ,[Description]
   ,[Date]
   ,[User ID]
   ,[Segment No_]
   ,[Canceled]
   ,[Salesperson Code]
   ,[Register No_]
   ,[Document Type]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Campaign Entry$437dbf0e-84ff-417a-965d-ed2bb9650972]

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$Campaign Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Campaign Entry]
LEFT JOIN
   [CRONUS UK Ltd_$Salesperson_Purchaser$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Salesperson_Purchaser]
      ON
         [Campaign Entry].[Salesperson Code] = [Salesperson_Purchaser].[No_]

Show/hide columns in Campaign Entry table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Entry No_ Primary Key Searchint
3Campaign No_ Searchnvarchar(40)
4Description Searchnvarchar(200)
5Date Searchdatetime
6User ID Searchnvarchar(100)
7Segment No_ Searchnvarchar(40)
8Canceled Searchtinyint
9Salesperson Code Searchnvarchar(40)
Key to join to the Salesperson_Purchaser table.

Show/hide example query

SELECT
       [Campaign Entry].[Salesperson Code]
       ,[Salesperson_Purchaser].[No_]
FROM
       [CRONUS UK Ltd_$Campaign Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Campaign Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Salesperson_Purchaser$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Salesperson_Purchaser]
              ON
                     [Campaign Entry].[Salesperson Code] = [Salesperson_Purchaser].[No_]
10Register No_ Searchint
11Document Type Searchint
12$systemId Searchuniqueidentifier
13$systemCreatedAt Searchdatetime
14$systemCreatedBy Searchuniqueidentifier
15$systemModifiedAt Searchdatetime
16$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Campaign Entry table

Leave a Reply

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