Team Salesperson

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

Table Type: Company

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

Table Number: 5084

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Team Code]
   ,[Salesperson Code]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Team Salesperson$437dbf0e-84ff-417a-965d-ed2bb9650972]

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

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

Show/hide columns in Team Salesperson table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Team Code Primary Key Searchnvarchar(20)
3Salesperson Code Primary Key Searchnvarchar(40)
Key to join to the Salesperson_Purchaser table.

Show/hide example query

SELECT
       [Team Salesperson].[Salesperson Code]
       ,[Salesperson_Purchaser].[No_]
FROM
       [CRONUS UK Ltd_$Team Salesperson$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Team Salesperson]
LEFT JOIN
       [CRONUS UK Ltd_$Salesperson_Purchaser$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Salesperson_Purchaser]
              ON
                     [Team Salesperson].[Salesperson Code] = [Salesperson_Purchaser].[No_]
4$systemId Searchuniqueidentifier
5$systemCreatedAt Searchdatetime
6$systemCreatedBy Searchuniqueidentifier
7$systemModifiedAt Searchdatetime
8$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Team Salesperson table

Leave a Reply

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