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
Show/hide an example select of all columns by name
Show/hide an example select of all columns including those from all joined tables
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 query | |||||||
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 query | |||||||
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 query | |||||||
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 query | |||||||
2000000003 | SystemModifiedAt | Modified At | Normal | DateTime | 8 | $systemModifiedAt | datetime |
2000000004 | SystemModifiedBy | Modified By | Normal | GUID | 16 | $systemModifiedBy | uniqueidentifier |