Salesperson/Purchaser

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

Table Type: Company

Table Name: Salesperson/Purchaser
Database Table Name: CRONUS UK Ltd_$Salesperson_Purchaser$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 13

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [Code]
   ,[Name]
   ,[Commission _]
   ,[Image]
   ,[Privacy Blocked]
   ,[Coupled to CRM]
   ,[Global Dimension 1 Code]
   ,[Global Dimension 2 Code]
   ,[E-Mail]
   ,[Phone No_]
   ,[Job Title]
   ,[Search E-Mail]
   ,[E-Mail 2]
   ,[Blocked]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Salesperson_Purchaser$437dbf0e-84ff-417a-965d-ed2bb9650972]

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$Salesperson_Purchaser$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Salesperson/Purchaser]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Salesperson/Purchaser].[Global Dimension 1 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Salesperson/Purchaser].[Global Dimension 2 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Sales Cycle$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Cycle]
      ON
         [Salesperson/Purchaser].[Sales Cycle Filter] = [Sales Cycle].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Contact$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Contact]
      ON
         [Salesperson/Purchaser].[Contact Filter] = [Contact].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Campaign$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Campaign]
      ON
         [Salesperson/Purchaser].[Campaign Filter] = [Campaign].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Team$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Team]
      ON
         [Salesperson/Purchaser].[Team Filter] = [Team].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Close Opportunity Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Close Opportunity Code]
      ON
         [Salesperson/Purchaser].[Close Opportunity Filter] = [Close Opportunity Code].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Salesperson/Purchaser].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Salesperson/Purchaser].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Salesperson/Purchaser table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Code Primary Key SearchCodeNormalCode20Codenvarchar(40)
2Name SearchNameNormalText50Namenvarchar(100)
3Commission % SearchCommission %NormalDecimal12Commission _decimal(38,38)
140Image SearchImageNormalMedia16Imageuniqueidentifier
150Privacy Blocked SearchPrivacy BlockedNormalBoolean4Privacy Blockedtinyint
720Coupled to CRM SearchCoupled to DataverseNormalBoolean4Coupled to CRMtinyint
721Coupled to Dataverse SearchCoupled to DataverseFlowFieldBoolean4
5050Global Dimension 1 Code SearchGlobal Dimension 1 CodeNormalCode20Global Dimension 1 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

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

Show/hide example query

SELECT
       [Salesperson/Purchaser].[Global Dimension 2 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$Salesperson_Purchaser$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Salesperson/Purchaser]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [Salesperson/Purchaser].[Global Dimension 2 Code] = [Dimension].[Code]
5052E-Mail SearchEmailNormalText80E-Mailnvarchar(160)
5053Phone No. SearchPhone No.NormalText30Phone No_nvarchar(60)
5054Next Task Date SearchNext Task DateFlowFieldDate4
5055No. of Opportunities SearchNo. of OpportunitiesFlowFieldInteger4
5056Estimated Value (LCY) SearchEstimated Value ($)FlowFieldDecimal12
5057Calcd. Current Value (LCY) SearchCalcd. Current Value ($)FlowFieldDecimal12
5058Date Filter SearchDate FilterFlowFilterDate4
5059No. of Interactions SearchNo. of InteractionsFlowFieldInteger4
5060Cost (LCY) SearchCost ($)FlowFieldDecimal12
5061Duration (Min.) SearchDuration (Min.)FlowFieldDecimal12
5062Job Title SearchJob TitleNormalText30Job Titlenvarchar(60)
5063Action Taken Filter SearchAction Taken FilterFlowFilterOption4
5064Sales Cycle Filter SearchSales Cycle FilterFlowFilterCode10
5065Sales Cycle Stage Filter SearchSales Cycle Stage FilterFlowFilterInteger4
5066Probability % Filter SearchProbability % FilterFlowFilterDecimal12
5067Completed % Filter SearchCompleted % FilterFlowFilterDecimal12
5068Avg. Estimated Value (LCY) SearchAvg. Estimated Value ($)FlowFieldDecimal12
5069Avg.Calcd. Current Value (LCY) SearchAvg.Calcd. Current Value ($)FlowFieldDecimal12
5070Contact Filter SearchContact FilterFlowFilterCode20
5071Contact Company Filter SearchContact Company FilterFlowFilterCode20
5072Campaign Filter SearchCampaign FilterFlowFilterCode20
5073Estimated Value Filter SearchEstimated Value FilterFlowFilterDecimal12
5074Calcd. Current Value Filter SearchCalcd. Current Value FilterFlowFilterDecimal12
5075Chances of Success % Filter SearchChances of Success % FilterFlowFilterDecimal12
5076Task Status Filter SearchTask Status FilterFlowFilterOption4
5077Closed Task Filter SearchClosed Task FilterFlowFilterBoolean4
5078Priority Filter SearchPriority FilterFlowFilterOption4
5079Team Filter SearchTeam FilterFlowFilterCode10
5082Opportunity Entry Exists SearchOpportunity Entry ExistsFlowFieldBoolean4
5083Task Entry Exists SearchTask Entry ExistsFlowFieldBoolean4
5084Close Opportunity Filter SearchClose Opportunity FilterFlowFilterCode10
5085Search E-Mail SearchSearch EmailNormalCode80Search E-Mailnvarchar(160)
5086E-Mail 2 SearchEmail 2NormalText80E-Mail 2nvarchar(160)
5087Blocked SearchBlockedNormalBoolean4Blockedtinyint
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
       [Salesperson/Purchaser].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Salesperson_Purchaser$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Salesperson/Purchaser]
LEFT JOIN
       [User] AS [User]
              ON
                     [Salesperson/Purchaser].[$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
       [Salesperson/Purchaser].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Salesperson_Purchaser$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Salesperson/Purchaser]
LEFT JOIN
       [User] AS [User]
              ON
                     [Salesperson/Purchaser].[$systemModifiedBy] = [User].[User Security ID]

Leave a Reply

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