Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/5196
Table Type: Company
Table Name: To-do Interaction Language
Database Table Name: CRONUS UK Ltd_$To-do Interaction Language$437dbf0e-84ff-417a-965d-ed2bb9650972
Table Number: 5196Due 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 To-do Interaction Language can be queried.
SELECT
*
FROM
[CRONUS UK Ltd_$To-do Interaction Language$437dbf0e-84ff-417a-965d-ed2bb9650972]
SELECT
[To-do No_]
,[Language Code]
,[Description]
,[Attachment No_]
,[$systemId]
,[$systemCreatedAt]
,[$systemCreatedBy]
,[$systemModifiedAt]
,[$systemModifiedBy]
FROM
[CRONUS UK Ltd_$To-do Interaction Language$437dbf0e-84ff-417a-965d-ed2bb9650972]
SELECT
*
FROM
[CRONUS UK Ltd_$To-do Interaction Language$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [To-do Interaction Language]
LEFT JOIN
[CRONUS UK Ltd_$Language$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Language]
ON
[To-do Interaction Language].[Language Code] = [Language].[Code]
LEFT JOIN
[User] AS [User]
ON
[To-do Interaction Language].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
[User] AS [User]
ON
[To-do Interaction Language].[SystemModifiedBy] = [User].[User Security ID]
| Field No. | Field Name | Field Caption | Class | Type | Length | SQL Column Name | SQL DataType |
|---|
| 1 | To-do No.  | Task No. | Normal | Code | 20 | To-do No_ | nvarchar(40) |
| Key to join to the To-do table.SELECT
[To-do Interaction Language].[To-do No_]
,[To-do].[No_]
FROM
[CRONUS UK Ltd_$To-do Interaction Language$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [To-do Interaction Language]
LEFT JOIN
[CRONUS UK Ltd_$To-do$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [To-do]
ON
[To-do Interaction Language].[To-do No_] = [To-do].[No_] |
| 2 | Language Code  | Language Code | Normal | Code | 10 | Language Code | nvarchar(20) |
| Key to join to the Language table.SELECT
[To-do Interaction Language].[Language Code]
,[Language].[Code]
FROM
[CRONUS UK Ltd_$To-do Interaction Language$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [To-do Interaction Language]
LEFT JOIN
[CRONUS UK Ltd_$Language$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Language]
ON
[To-do Interaction Language].[Language Code] = [Language].[Code] |
| 3 | Description | Description | Normal | Text | 100 | Description | nvarchar(200) |
| 4 | Attachment No. | Attachment No. | Normal | Integer | 4 | Attachment No_ | int |
| Key to join to the Attachment table.SELECT
[To-do Interaction Language].[Attachment No_]
,[Attachment].[No_]
FROM
[CRONUS UK Ltd_$To-do Interaction Language$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [To-do Interaction Language]
LEFT JOIN
[CRONUS UK Ltd_$Attachment$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Attachment]
ON
[To-do Interaction Language].[Attachment No_] = [Attachment].[No_] |
| 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.SELECT
[To-do Interaction Language].[$systemCreatedBy]
,[User].[User Security ID]
FROM
[CRONUS UK Ltd_$To-do Interaction Language$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [To-do Interaction Language]
LEFT JOIN
[User] AS [User]
ON
[To-do Interaction Language].[$systemCreatedBy] = [User].[User Security ID] |
| 2000000003 | SystemModifiedAt | Modified At | Normal | DateTime | 8 | $systemModifiedAt | datetime |
| 2000000004 | SystemModifiedBy | Modified By | Normal | GUID | 16 | $systemModifiedBy | uniqueidentifier |
