Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/99000757
Table Type: Company
Table Name: Calendar Entry
Database Table Name: CRONUS UK Ltd_$Calendar Entry$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 Calendar Entry can be queried.
Show/hide an example select of all columns
SELECT
*
FROM
[CRONUS UK Ltd_$Calendar Entry$437dbf0e-84ff-417a-965d-ed2bb9650972]Show/hide an example select of all columns by name
SELECT
[Capacity Type]
,[No_]
,[Date]
,[Work Shift Code]
,[Starting Time]
,[Ending Time]
,[Work Center No_]
,[Work Center Group Code]
,[Capacity (Total)]
,[Capacity (Effective)]
,[Efficiency]
,[Capacity]
,[Absence Efficiency]
,[Absence Capacity]
,[Starting Date-Time]
,[Ending Date-Time]
,[$systemId]
,[$systemCreatedAt]
,[$systemCreatedBy]
,[$systemModifiedAt]
,[$systemModifiedBy]
FROM
[CRONUS UK Ltd_$Calendar Entry$437dbf0e-84ff-417a-965d-ed2bb9650972]Show/hide an example select of all columns including those from all joined tables
SELECT
*
FROM
[CRONUS UK Ltd_$Calendar Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Calendar Entry]
LEFT JOIN
[CRONUS UK Ltd_$Work Shift$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Work Shift]
ON
[Calendar Entry].[Work Shift Code] = [Work Shift].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Work Center Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Work Center Group]
ON
[Calendar Entry].[Work Center Group Code] = [Work Center Group].[Code]
LEFT JOIN
[User] AS [User]
ON
[Calendar Entry].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
[User] AS [User]
ON
[Calendar Entry].[SystemModifiedBy] = [User].[User Security ID]Show/hide columns in Calendar Entry table
| Field No. | Field Name | Field Caption | Class | Type | Length | SQL Column Name | SQL DataType |
|---|---|---|---|---|---|---|---|
| 1 | Capacity Type   | Capacity Type | Normal | Option | 4 | Capacity Type | int |
Available options are:
| |||||||
| 2 | No. | No. | Normal | Code | 20 | No_ | nvarchar(40) |
| 4 | Date | Date | Normal | Date | 4 | Date | datetime |
| 5 | Work Shift Code | Work Shift Code | Normal | Code | 10 | Work Shift Code | nvarchar(20) |
Key to join to the Work Shift table.Show/hide example querySELECT
[Calendar Entry].[Work Shift Code]
,[Work Shift].[Code]
FROM
[CRONUS UK Ltd_$Calendar Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Calendar Entry]
LEFT JOIN
[CRONUS UK Ltd_$Work Shift$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Work Shift]
ON
[Calendar Entry].[Work Shift Code] = [Work Shift].[Code] | |||||||
| 6 | Starting Time | Starting Time | Normal | Time | 4 | Starting Time | datetime |
| 7 | Ending Time | Ending Time | Normal | Time | 4 | Ending Time | datetime |
| 8 | Work Center No. | Work Center No. | Normal | Code | 20 | Work Center No_ | nvarchar(40) |
Key to join to the Work Center table.Show/hide example querySELECT
[Calendar Entry].[Work Center No_]
,[Work Center].[No_]
FROM
[CRONUS UK Ltd_$Calendar Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Calendar Entry]
LEFT JOIN
[CRONUS UK Ltd_$Work Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Work Center]
ON
[Calendar Entry].[Work Center No_] = [Work Center].[No_] | |||||||
| 9 | Work Center Group Code | Work Center Group Code | Normal | Code | 10 | Work Center Group Code | nvarchar(20) |
Key to join to the Work Center Group table.Show/hide example querySELECT
[Calendar Entry].[Work Center Group Code]
,[Work Center Group].[Code]
FROM
[CRONUS UK Ltd_$Calendar Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Calendar Entry]
LEFT JOIN
[CRONUS UK Ltd_$Work Center Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Work Center Group]
ON
[Calendar Entry].[Work Center Group Code] = [Work Center Group].[Code] | |||||||
| 10 | Capacity (Total) | Capacity (Total) | Normal | Decimal | 12 | Capacity (Total) | decimal(38,38) |
| 11 | Capacity (Effective) | Capacity (Effective) | Normal | Decimal | 12 | Capacity (Effective) | decimal(38,38) |
| 20 | Efficiency | Efficiency | Normal | Decimal | 12 | Efficiency | decimal(38,38) |
| 21 | Capacity | Capacity | Normal | Decimal | 12 | Capacity | decimal(38,38) |
| 22 | Absence Efficiency | Absence Efficiency | Normal | Decimal | 12 | Absence Efficiency | decimal(38,38) |
| 23 | Absence Capacity | Absence Capacity | Normal | Decimal | 12 | Absence Capacity | decimal(38,38) |
| 24 | Starting Date-Time | Starting Date-Time | Normal | DateTime | 8 | Starting Date-Time | datetime |
| 25 | Ending Date-Time | Ending Date-Time | Normal | DateTime | 8 | Ending Date-Time | 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
[Calendar Entry].[$systemCreatedBy]
,[User].[User Security ID]
FROM
[CRONUS UK Ltd_$Calendar Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Calendar Entry]
LEFT JOIN
[User] AS [User]
ON
[Calendar Entry].[$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
[Calendar Entry].[$systemModifiedBy]
,[User].[User Security ID]
FROM
[CRONUS UK Ltd_$Calendar Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Calendar Entry]
LEFT JOIN
[User] AS [User]
ON
[Calendar Entry].[$systemModifiedBy] = [User].[User Security ID] | |||||||