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: 5071

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
   [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_$Inventory Period$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Period]
      ON
         [Campaign].[Ending Date] = [Inventory Period].[Ending Date]
LEFT JOIN
   [CRONUS UK Ltd_$Salesperson_Purchaser$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Salesperson/Purchaser]
      ON
         [Campaign].[Salesperson Code] = [Salesperson/Purchaser].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Campaign].[Global Dimension 1 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Campaign].[Global Dimension 2 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Campaign Status$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Campaign Status]
      ON
         [Campaign].[Status Code] = [Campaign Status].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Sales Cycle$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Cycle]
      ON
         [Campaign].[Sales Cycle Filter] = [Sales Cycle].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Contact$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Contact]
      ON
         [Campaign].[Contact Filter] = [Contact].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Team$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Team]
      ON
         [Campaign].[Team Filter] = [Team].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Salesperson_Purchaser$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Salesperson/Purchaser]
      ON
         [Campaign].[Salesperson Filter] = [Salesperson/Purchaser].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Close Opportunity Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Close Opportunity Code]
      ON
         [Campaign].[Close Opportunity Filter] = [Close Opportunity Code].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Campaign].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Campaign].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Campaign table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1No. Primary Key SearchNo.NormalCode20No_nvarchar(40)
2Description SearchDescriptionNormalText100Descriptionnvarchar(200)
3Starting Date SearchStarting DateNormalDate4Starting Datedatetime
4Ending Date SearchEnding DateNormalDate4Ending Datedatetime
Key to join to the Inventory Period table.

Show/hide example query

SELECT
       [Campaign].[Ending Date]
       ,[Inventory Period].[Ending Date]
FROM
       [CRONUS UK Ltd_$Campaign$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Campaign]
LEFT JOIN
       [CRONUS UK Ltd_$Inventory Period$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Period]
              ON
                     [Campaign].[Ending Date] = [Inventory Period].[Ending Date]
5Salesperson Code SearchSalesperson CodeNormalCode20Salesperson Codenvarchar(40)
Key to join to the Salesperson/Purchaser table.

Show/hide example query

SELECT
       [Campaign].[Salesperson Code]
       ,[Salesperson/Purchaser].[Code]
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].[Code]
6Comment SearchCommentFlowFieldBoolean4
7Last Date Modified SearchLast Date ModifiedNormalDate4Last Date Modifieddatetime
8No. Series SearchNo. SeriesNormalCode20No_ Seriesnvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Campaign].[No_ Series]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Campaign$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Campaign]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Campaign].[No_ Series] = [No. Series].[Code]
9Global Dimension 1 Code SearchGlobal Dimension 1 CodeNormalCode20Global Dimension 1 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
       [Campaign].[Global Dimension 1 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$Campaign$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Campaign]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [Campaign].[Global Dimension 1 Code] = [Dimension].[Code]
10Global Dimension 2 Code SearchGlobal Dimension 2 CodeNormalCode20Global Dimension 2 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
       [Campaign].[Global Dimension 2 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$Campaign$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Campaign]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [Campaign].[Global Dimension 2 Code] = [Dimension].[Code]
11Status Code SearchStatus CodeNormalCode10Status Codenvarchar(20)
Key to join to the Campaign Status table.

Show/hide example query

SELECT
       [Campaign].[Status Code]
       ,[Campaign Status].[Code]
FROM
       [CRONUS UK Ltd_$Campaign$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Campaign]
LEFT JOIN
       [CRONUS UK Ltd_$Campaign Status$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Campaign Status]
              ON
                     [Campaign].[Status Code] = [Campaign Status].[Code]
12Target Contacts Contacted SearchTarget Contacts ContactedFlowFieldInteger4
13Contacts Responded SearchContacts RespondedFlowFieldInteger4
14Duration (Min.) SearchDuration (Min.)FlowFieldDecimal12
16Cost (LCY) SearchCost ($)FlowFieldDecimal12
17No. of Opportunities SearchNo. of OpportunitiesFlowFieldInteger4
18Estimated Value (LCY) SearchEstimated Value ($)FlowFieldDecimal12
19Calcd. Current Value (LCY) SearchCalcd. Current Value ($)FlowFieldDecimal12
20Date Filter SearchDate FilterFlowFilterDate4
23Action Taken Filter SearchAction Taken FilterFlowFilterOption4
24Sales Cycle Filter SearchSales Cycle FilterFlowFilterCode10
25Sales Cycle Stage Filter SearchSales Cycle Stage FilterFlowFilterInteger4
26Probability % Filter SearchProbability % FilterFlowFilterDecimal12
27Completed % Filter SearchCompleted % FilterFlowFilterDecimal12
28Contact Filter SearchContact FilterFlowFilterCode20
29Contact Company Filter SearchContact Company FilterFlowFilterCode20
30Estimated Value Filter SearchEstimated Value FilterFlowFilterDecimal12
31Calcd. Current Value Filter SearchCalcd. Current Value FilterFlowFilterDecimal12
32Chances of Success % Filter SearchChances of Success % FilterFlowFilterDecimal12
33Task Status Filter SearchTask Status FilterFlowFilterOption4
34Task Closed Filter SearchTask Closed FilterFlowFilterBoolean4
35Priority Filter SearchPriority FilterFlowFilterOption4
36Team Filter SearchTeam FilterFlowFilterCode10
37Salesperson Filter SearchSalesperson FilterFlowFilterCode20
38Opportunity Entry Exists SearchOpportunity Entry ExistsFlowFieldBoolean4
39Task Entry Exists SearchTask Entry ExistsFlowFieldBoolean4
40Close Opportunity Filter SearchClose Opportunity FilterFlowFilterCode10
41Activated SearchActivatedFlowFieldBoolean4
2000000000$systemId SearchSystem IDNormalGUID16$systemIduniqueidentifier
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8$systemCreatedAtdatetime
2000000002SystemCreatedBy SearchCreated ByNormalGUID16$systemCreatedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Campaign].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Campaign$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Campaign]
LEFT JOIN
       [User] AS [User]
              ON
                     [Campaign].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Campaign].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Campaign$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Campaign]
LEFT JOIN
       [User] AS [User]
              ON
                     [Campaign].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from Campaign table

Leave a Reply

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