Campaign

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

Table Type: Company

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

Table Number: 0

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[No_]
   ,[Description]
   ,[Starting Date]
   ,[Ending Date]
   ,[Salesperson Code]
   ,[Last Date Modified]
   ,[No_ Series]
   ,[Global Dimension 1 Code]
   ,[Global Dimension 2 Code]
   ,[Status Code]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Campaign$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$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Campaign]
LEFT JOIN
   [CRONUS UK Ltd_$Salesperson_Purchaser$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Salesperson_Purchaser]
      ON
         [Campaign].[Salesperson Code] = [Salesperson_Purchaser].[No_]

Show/hide columns in Campaign table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2No_ Primary Key Searchnvarchar(40)
3Description Searchnvarchar(200)
4Starting Date Searchdatetime
5Ending Date Searchdatetime
6Salesperson Code Searchnvarchar(40)
Key to join to the Salesperson_Purchaser table.

Show/hide example query

SELECT
       [Campaign].[Salesperson Code]
       ,[Salesperson_Purchaser].[No_]
FROM
       [CRONUS UK Ltd_$Campaign$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Campaign]
LEFT JOIN
       [CRONUS UK Ltd_$Salesperson_Purchaser$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Salesperson_Purchaser]
              ON
                     [Campaign].[Salesperson Code] = [Salesperson_Purchaser].[No_]
7Last Date Modified Searchdatetime
8No_ Series Searchnvarchar(40)
9Global Dimension 1 Code Searchnvarchar(40)
10Global Dimension 2 Code Searchnvarchar(40)
11Status Code Searchnvarchar(20)
12$systemId Searchuniqueidentifier
13$systemCreatedAt Searchdatetime
14$systemCreatedBy Searchuniqueidentifier
15$systemModifiedAt Searchdatetime
16$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Campaign table

Leave a Reply

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