Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/140
Table Type: Company
Table Name: License Agreement
Database Table Name: CRONUS UK Ltd_$License Agreement$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 License Agreement can be queried.
Show/hide an example select of all columns
SELECT
*
FROM
[CRONUS UK Ltd_$License Agreement$437dbf0e-84ff-417a-965d-ed2bb9650972]Show/hide an example select of all columns by name
SELECT
[Primary Key]
,[Message for Accepting User]
,[Effective Date]
,[Effective Date Changed By]
,[Effective Date Changed On]
,[Accepted]
,[Accepted By]
,[Accepted On]
,[$systemId]
,[$systemCreatedAt]
,[$systemCreatedBy]
,[$systemModifiedAt]
,[$systemModifiedBy]
FROM
[CRONUS UK Ltd_$License Agreement$437dbf0e-84ff-417a-965d-ed2bb9650972]Show/hide an example select of all columns including those from all joined tables
SELECT
*
FROM
[CRONUS UK Ltd_$License Agreement$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [License Agreement]
LEFT JOIN
[User] AS [User]
ON
[License Agreement].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
[User] AS [User]
ON
[License Agreement].[SystemModifiedBy] = [User].[User Security ID]Show/hide columns in License Agreement table
| Field No. | Field Name | Field Caption | Class | Type | Length | SQL Column Name | SQL DataType |
|---|---|---|---|---|---|---|---|
| 1 | Primary Key  | Primary Key | Normal | Code | 10 | Primary Key | nvarchar(20) |
| 2 | Message for Accepting User  | Message for Accepting User | Normal | Text | 250 | Message for Accepting User | nvarchar(500) |
| 3 | Effective Date | Effective Date | Normal | Date | 4 | Effective Date | datetime |
| 4 | Effective Date Changed By | Effective Date Changed By | Normal | Text | 65 | Effective Date Changed By | nvarchar(130) |
| 5 | Effective Date Changed On | Effective Date Changed On | Normal | DateTime | 8 | Effective Date Changed On | datetime |
| 6 | Accepted | Accepted | Normal | Boolean | 4 | Accepted | tinyint |
| 7 | Accepted By | Accepted By | Normal | Text | 65 | Accepted By | nvarchar(130) |
| 8 | Accepted On | Accepted On | Normal | DateTime | 8 | Accepted On | datetime |
| 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 [License Agreement].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$License Agreement$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [License Agreement] LEFT JOIN [User] AS [User] ON [License Agreement].[$systemCreatedBy] = [User].[User Security ID] | |||||||
| 2000000003 | SystemModifiedAt | Modified At | Normal | DateTime | 8 | $systemModifiedAt | datetime |
| 2000000004 | SystemModifiedBy | Modified By | Normal | GUID | 16 | $systemModifiedBy | uniqueidentifier |