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
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
[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_$Team$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Team]
ON
[Team Salesperson].[Team Code] = [Team].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Salesperson_Purchaser$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Salesperson/Purchaser]
ON
[Team Salesperson].[Salesperson Code] = [Salesperson/Purchaser].[Code]
LEFT JOIN
[User] AS [User]
ON
[Team Salesperson].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
[User] AS [User]
ON
[Team Salesperson].[SystemModifiedBy] = [User].[User Security ID]Show/hide columns in Team Salesperson table
| Field No. | Field Name | Field Caption | Class | Type | Length | SQL Column Name | SQL DataType |
|---|---|---|---|---|---|---|---|
| 1 | Team Code   | Team Code | Normal | Code | 10 | Team Code | nvarchar(20) |
Key to join to the Team table.Show/hide example querySELECT
[Team Salesperson].[Team Code]
,[Team].[Code]
FROM
[CRONUS UK Ltd_$Team Salesperson$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Team Salesperson]
LEFT JOIN
[CRONUS UK Ltd_$Team$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Team]
ON
[Team Salesperson].[Team Code] = [Team].[Code] | |||||||
| 2 | Salesperson Code | Salesperson Code | Normal | Code | 20 | Salesperson Code | nvarchar(40) |
Key to join to the Salesperson/Purchaser table.Show/hide example querySELECT
[Team Salesperson].[Salesperson Code]
,[Salesperson/Purchaser].[Code]
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].[Code] | |||||||
| 3 | Team Name | Team Name | FlowField | Text | 50 | ||
| 4 | Salesperson Name | Salesperson Name | FlowField | Text | 50 | ||
| 2000000000 | $systemId | System ID | Normal | GUID | 16 | $systemId | uniqueidentifier |
| 2000000001 | SystemCreatedAt | Created At | Normal | DateTime | 8 | $systemCreatedAt | datetime |
| 2000000002 | SystemCreatedBy | Created By | Normal | GUID | 16 | $systemCreatedBy | uniqueidentifier |
Key to join to the User table.Show/hide example querySELECT
[Team Salesperson].[$systemCreatedBy]
,[User].[User Security ID]
FROM
[CRONUS UK Ltd_$Team Salesperson$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Team Salesperson]
LEFT JOIN
[User] AS [User]
ON
[Team Salesperson].[$systemCreatedBy] = [User].[User Security ID] | |||||||
| 2000000003 | SystemModifiedAt | Modified At | Normal | DateTime | 8 | $systemModifiedAt | datetime |
| 2000000004 | SystemModifiedBy | Modified By | Normal | GUID | 16 | $systemModifiedBy | uniqueidentifier |
Key to join to the User table.Show/hide example querySELECT
[Team Salesperson].[$systemModifiedBy]
,[User].[User Security ID]
FROM
[CRONUS UK Ltd_$Team Salesperson$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Team Salesperson]
LEFT JOIN
[User] AS [User]
ON
[Team Salesperson].[$systemModifiedBy] = [User].[User Security ID] | |||||||