Marketing Setup

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

Table Type: Company

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

Table Number: 5079

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [Primary Key]
   ,[Contact Nos_]
   ,[Campaign Nos_]
   ,[Segment Nos_]
   ,[To-do Nos_]
   ,[Opportunity Nos_]
   ,[Bus_ Rel_ Code for Customers]
   ,[Bus_ Rel_ Code for Vendors]
   ,[Bus_ Rel_ Code for Bank Accs_]
   ,[Bus_ Rel_ Code for Employees]
   ,[Inherit Salesperson Code]
   ,[Inherit Territory Code]
   ,[Inherit Country_Region Code]
   ,[Inherit Language Code]
   ,[Inherit Address Details]
   ,[Inherit Communication Details]
   ,[Default Salesperson Code]
   ,[Default Territory Code]
   ,[Default Country_Region Code]
   ,[Default Language Code]
   ,[Default Format Region]
   ,[Default Sales Cycle Code]
   ,[Attachment Storage Type]
   ,[Attachment Storage Location]
   ,[Autosearch for Duplicates]
   ,[Search Hit _]
   ,[Maintain Dupl_ Search Strings]
   ,[Mergefield Language ID]
   ,[Def_ Company Salutation Code]
   ,[Default Person Salutation Code]
   ,[Default Correspondence Type]
   ,[Queue Folder Path]
   ,[Queue Folder UID]
   ,[Storage Folder Path]
   ,[Storage Folder UID]
   ,[Default To-do Date Calculation]
   ,[Autodiscovery E-Mail Address]
   ,[Email Batch Size]
   ,[Exchange Service URL]
   ,[Exchange Account User Name]
   ,[Exchange Account Password Key]
   ,[Sync with Microsoft Graph]
   ,[WebHook Run Notification As]
   ,[Cust_ Template Company Code]
   ,[Cust_ Template Person Code]
   ,[Exchange Tenant Id Key]
   ,[Exchange Client Id]
   ,[Exchange Client Secret Key]
   ,[Email Logging Enabled]
   ,[Exchange Redirect URL]
   ,[Inherit Format Region]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Marketing Setup$437dbf0e-84ff-417a-965d-ed2bb9650972]

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$Marketing Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Marketing Setup]
LEFT JOIN
   [CRONUS UK Ltd_$Territory$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Territory]
      ON
         [Marketing Setup].[Default Territory Code] = [Territory].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Language$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Language]
      ON
         [Marketing Setup].[Default Language Code] = [Language].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Sales Cycle$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Cycle]
      ON
         [Marketing Setup].[Default Sales Cycle Code] = [Sales Cycle].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Salutation$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Salutation]
      ON
         [Marketing Setup].[Default Person Salutation Code] = [Salutation].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Marketing Setup].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Marketing Setup].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Marketing Setup table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Primary Key SearchPrimary KeyNormalCode10Primary Keynvarchar(20)
2Contact Nos. Primary Key SearchContact Nos.NormalCode20Contact Nos_nvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
	       [Marketing Setup].[Contact Nos_]
	       ,[No. Series].[Code]
	FROM
	       [CRONUS UK Ltd_$Marketing Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Marketing Setup]
	LEFT JOIN
	       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
	              ON
	                     [Marketing Setup].[Contact Nos_] = [No. Series].[Code]
3Campaign Nos. SearchCampaign Nos.NormalCode20Campaign Nos_nvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
	       [Marketing Setup].[Campaign Nos_]
	       ,[No. Series].[Code]
	FROM
	       [CRONUS UK Ltd_$Marketing Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Marketing Setup]
	LEFT JOIN
	       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
	              ON
	                     [Marketing Setup].[Campaign Nos_] = [No. Series].[Code]
4Segment Nos. SearchSegment Nos.NormalCode20Segment Nos_nvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
	       [Marketing Setup].[Segment Nos_]
	       ,[No. Series].[Code]
	FROM
	       [CRONUS UK Ltd_$Marketing Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Marketing Setup]
	LEFT JOIN
	       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
	              ON
	                     [Marketing Setup].[Segment Nos_] = [No. Series].[Code]
5To-do Nos. SearchTask Nos.NormalCode20To-do Nos_nvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
	       [Marketing Setup].[To-do Nos_]
	       ,[No. Series].[Code]
	FROM
	       [CRONUS UK Ltd_$Marketing Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Marketing Setup]
	LEFT JOIN
	       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
	              ON
	                     [Marketing Setup].[To-do Nos_] = [No. Series].[Code]
6Opportunity Nos. SearchOpportunity Nos.NormalCode20Opportunity Nos_nvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
	       [Marketing Setup].[Opportunity Nos_]
	       ,[No. Series].[Code]
	FROM
	       [CRONUS UK Ltd_$Marketing Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Marketing Setup]
	LEFT JOIN
	       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
	              ON
	                     [Marketing Setup].[Opportunity Nos_] = [No. Series].[Code]
7Bus. Rel. Code for Customers SearchBus. Rel. Code for CustomersNormalCode10Bus_ Rel_ Code for Customersnvarchar(20)
Key to join to the Business Relation table.

Show/hide example query

SELECT
	       [Marketing Setup].[Bus_ Rel_ Code for Customers]
	       ,[Business Relation].[Code]
	FROM
	       [CRONUS UK Ltd_$Marketing Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Marketing Setup]
	LEFT JOIN
	       [CRONUS UK Ltd_$Business Relation$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Business Relation]
	              ON
	                     [Marketing Setup].[Bus_ Rel_ Code for Customers] = [Business Relation].[Code]
8Bus. Rel. Code for Vendors SearchBus. Rel. Code for VendorsNormalCode10Bus_ Rel_ Code for Vendorsnvarchar(20)
Key to join to the Business Relation table.

Show/hide example query

SELECT
	       [Marketing Setup].[Bus_ Rel_ Code for Vendors]
	       ,[Business Relation].[Code]
	FROM
	       [CRONUS UK Ltd_$Marketing Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Marketing Setup]
	LEFT JOIN
	       [CRONUS UK Ltd_$Business Relation$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Business Relation]
	              ON
	                     [Marketing Setup].[Bus_ Rel_ Code for Vendors] = [Business Relation].[Code]
9Bus. Rel. Code for Bank Accs. SearchBus. Rel. Code for Bank Accs.NormalCode10Bus_ Rel_ Code for Bank Accs_nvarchar(20)
Key to join to the Business Relation table.

Show/hide example query

SELECT
	       [Marketing Setup].[Bus_ Rel_ Code for Bank Accs_]
	       ,[Business Relation].[Code]
	FROM
	       [CRONUS UK Ltd_$Marketing Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Marketing Setup]
	LEFT JOIN
	       [CRONUS UK Ltd_$Business Relation$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Business Relation]
	              ON
	                     [Marketing Setup].[Bus_ Rel_ Code for Bank Accs_] = [Business Relation].[Code]
10Bus. Rel. Code for Employees SearchBus. Rel. Code for EmployeesNormalCode10Bus_ Rel_ Code for Employeesnvarchar(20)
Key to join to the Business Relation table.

Show/hide example query

SELECT
	       [Marketing Setup].[Bus_ Rel_ Code for Employees]
	       ,[Business Relation].[Code]
	FROM
	       [CRONUS UK Ltd_$Marketing Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Marketing Setup]
	LEFT JOIN
	       [CRONUS UK Ltd_$Business Relation$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Business Relation]
	              ON
	                     [Marketing Setup].[Bus_ Rel_ Code for Employees] = [Business Relation].[Code]
22Inherit Salesperson Code SearchInherit Salesperson CodeNormalBoolean4Inherit Salesperson Codetinyint
23Inherit Territory Code SearchInherit Territory CodeNormalBoolean4Inherit Territory Codetinyint
24Inherit Country/Region Code SearchInherit Country/Region CodeNormalBoolean4Inherit Country_Region Codetinyint
25Inherit Language Code SearchInherit Language CodeNormalBoolean4Inherit Language Codetinyint
26Inherit Address Details SearchInherit Address DetailsNormalBoolean4Inherit Address Detailstinyint
27Inherit Communication Details SearchInherit Communication DetailsNormalBoolean4Inherit Communication Detailstinyint
28Default Salesperson Code SearchDefault Salesperson CodeNormalCode20Default Salesperson Codenvarchar(40)
29Default Territory Code SearchDefault Territory CodeNormalCode10Default Territory Codenvarchar(20)
Key to join to the Territory table.

Show/hide example query

SELECT
	       [Marketing Setup].[Default Territory Code]
	       ,[Territory].[Code]
	FROM
	       [CRONUS UK Ltd_$Marketing Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Marketing Setup]
	LEFT JOIN
	       [CRONUS UK Ltd_$Territory$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Territory]
	              ON
	                     [Marketing Setup].[Default Territory Code] = [Territory].[Code]
30Default Country/Region Code SearchDefault Country/Region CodeNormalCode10Default Country_Region Codenvarchar(20)
31Default Language Code SearchDefault Language CodeNormalCode10Default Language Codenvarchar(20)
Key to join to the Language table.

Show/hide example query

SELECT
	       [Marketing Setup].[Default Language Code]
	       ,[Language].[Code]
	FROM
	       [CRONUS UK Ltd_$Marketing Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Marketing Setup]
	LEFT JOIN
	       [CRONUS UK Ltd_$Language$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Language]
	              ON
	                     [Marketing Setup].[Default Language Code] = [Language].[Code]
32Default Format Region SearchDefault Format RegionNormalText80Default Format Regionnvarchar(160)
33Default Sales Cycle Code SearchDefault Sales Cycle CodeNormalCode10Default Sales Cycle Codenvarchar(20)
Key to join to the Sales Cycle table.

Show/hide example query

SELECT
	       [Marketing Setup].[Default Sales Cycle Code]
	       ,[Sales Cycle].[Code]
	FROM
	       [CRONUS UK Ltd_$Marketing Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Marketing Setup]
	LEFT JOIN
	       [CRONUS UK Ltd_$Sales Cycle$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Cycle]
	              ON
	                     [Marketing Setup].[Default Sales Cycle Code] = [Sales Cycle].[Code]
35Attachment Storage Type SearchAttachment Storage TypeNormalOption4Attachment Storage Typeint
Available options are:
  • “Embedded”
  • “Disk File”
36Attachment Storage Location SearchAttachment Storage LocationNormalText250Attachment Storage Locationnvarchar(500)
37Autosearch for Duplicates SearchAutosearch for DuplicatesNormalBoolean4Autosearch for Duplicatestinyint
38Search Hit % SearchSearch Hit %NormalInteger4Search Hit _int
39Maintain Dupl. Search Strings SearchMaintain Dupl. Search StringsNormalBoolean4Maintain Dupl_ Search Stringstinyint
50Mergefield Language ID SearchMergefield Language IDNormalInteger4Mergefield Language IDint
51Def. Company Salutation Code SearchDef. Company Salutation CodeNormalCode10Def_ Company Salutation Codenvarchar(20)
Key to join to the Salutation table.

Show/hide example query

SELECT
	       [Marketing Setup].[Def_ Company Salutation Code]
	       ,[Salutation].[Code]
	FROM
	       [CRONUS UK Ltd_$Marketing Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Marketing Setup]
	LEFT JOIN
	       [CRONUS UK Ltd_$Salutation$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Salutation]
	              ON
	                     [Marketing Setup].[Def_ Company Salutation Code] = [Salutation].[Code]
52Default Person Salutation Code SearchDefault Person Salutation CodeNormalCode10Default Person Salutation Codenvarchar(20)
Key to join to the Salutation table.

Show/hide example query

SELECT
	       [Marketing Setup].[Default Person Salutation Code]
	       ,[Salutation].[Code]
	FROM
	       [CRONUS UK Ltd_$Marketing Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Marketing Setup]
	LEFT JOIN
	       [CRONUS UK Ltd_$Salutation$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Salutation]
	              ON
	                     [Marketing Setup].[Default Person Salutation Code] = [Salutation].[Code]
53Default Correspondence Type SearchDefault Correspondence TypeNormalOption4Default Correspondence Typeint
Available options are:
  • ” “
  • “Hard Copy”
  • “Email”
  • “Fax”
56Queue Folder Path SearchQueue Folder PathNormalText250Queue Folder Pathnvarchar(500)
57Queue Folder UID SearchQueue Folder UIDNormalBLOB8Queue Folder UIDimage
59Storage Folder Path SearchStorage Folder PathNormalText250Storage Folder Pathnvarchar(500)
60Storage Folder UID SearchStorage Folder UIDNormalBLOB8Storage Folder UIDimage
67Default To-do Date Calculation SearchDefault Task Date CalculationNormalDateFormula32Default To-do Date Calculationvarchar(32)
69Autodiscovery E-Mail Address SearchAutodiscovery Email AddressNormalText250Autodiscovery E-Mail Addressnvarchar(500)
70Email Batch Size SearchEmail Batch SizeNormalInteger4Email Batch Sizeint
71Exchange Service URL SearchExchange Service URLNormalText250Exchange Service URLnvarchar(500)
72Exchange Account User Name SearchExchange Account User NameNormalText250Exchange Account User Namenvarchar(500)
73Exchange Account Password Key SearchExchange Account Password KeyNormalGUID16Exchange Account Password Keyuniqueidentifier
74Sync with Microsoft Graph SearchSync with Microsoft GraphNormalBoolean4Sync with Microsoft Graphtinyint
75WebHook Run Notification As SearchWebHook Run Notification AsNormalGUID16WebHook Run Notification Asuniqueidentifier
76Cust. Template Company Code SearchCust. Template Company CodeNormalCode10Cust_ Template Company Codenvarchar(20)
77Cust. Template Person Code SearchCust. Template Person CodeNormalCode10Cust_ Template Person Codenvarchar(20)
78Exchange Tenant Id Key SearchExchange Tenant Id KeyNormalGUID16Exchange Tenant Id Keyuniqueidentifier
79Exchange Client Id SearchExchange Client IdNormalText250Exchange Client Idnvarchar(500)
80Exchange Client Secret Key SearchExchange Client Secret KeyNormalGUID16Exchange Client Secret Keyuniqueidentifier
81Email Logging Enabled SearchEmail Logging EnabledNormalBoolean4Email Logging Enabledtinyint
82Exchange Redirect URL SearchExchange Redirect URLNormalText2048Exchange Redirect URLnvarchar(4096)
83Inherit Format Region SearchInherit Format RegionNormalBoolean4Inherit Format Regiontinyint
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
	       [Marketing Setup].[$systemCreatedBy]
	       ,[User].[User Security ID]
	FROM
	       [CRONUS UK Ltd_$Marketing Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Marketing Setup]
	LEFT JOIN
	       [User] AS [User]
	              ON
	                     [Marketing Setup].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier

Leave a Reply

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