Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/950
Table Type: Company
Table Name: Time Sheet Header
Database Table Name: CRONUS UK Ltd_$Time Sheet Header$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 Time Sheet Header can be queried.
Show/hide an example select of all columns
SELECT
*
FROM
[CRONUS UK Ltd_$Time Sheet Header$437dbf0e-84ff-417a-965d-ed2bb9650972]Show/hide an example select of all columns by name
SELECT
[No_]
,[Starting Date]
,[Ending Date]
,[Resource No_]
,[Owner User ID]
,[Approver User ID]
,[Description]
,[$systemId]
,[$systemCreatedAt]
,[$systemCreatedBy]
,[$systemModifiedAt]
,[$systemModifiedBy]
FROM
[CRONUS UK Ltd_$Time Sheet Header$437dbf0e-84ff-417a-965d-ed2bb9650972]Show/hide an example select of all columns including those from all joined tables
SELECT
*
FROM
[CRONUS UK Ltd_$Time Sheet Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Time Sheet Header]
LEFT JOIN
[CRONUS UK Ltd_$Inventory Period$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Period]
ON
[Time Sheet Header].[Ending Date] = [Inventory Period].[Ending Date]
LEFT JOIN
[CRONUS UK Ltd_$User Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [User Setup]
ON
[Time Sheet Header].[Owner User ID] = [User Setup].[User ID]
LEFT JOIN
[CRONUS UK Ltd_$User Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [User Setup]
ON
[Time Sheet Header].[Approver User ID] = [User Setup].[User ID]
LEFT JOIN
[CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
ON
[Time Sheet Header].[Unit of Measure] = [Unit of Measure].[Code]
LEFT JOIN
[User] AS [User]
ON
[Time Sheet Header].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
[User] AS [User]
ON
[Time Sheet Header].[SystemModifiedBy] = [User].[User Security ID]Show/hide columns in Time Sheet Header table
| Field No. | Field Name | Field Caption | Class | Type | Length | SQL Column Name | SQL DataType |
|---|---|---|---|---|---|---|---|
| 1 | No.   | No. | Normal | Code | 20 | No_ | nvarchar(40) |
| 3 | Starting Date | Starting Date | Normal | Date | 4 | Starting Date | datetime |
| 4 | Ending Date | Ending Date | Normal | Date | 4 | Ending Date | datetime |
Key to join to the Inventory Period table.Show/hide example querySELECT
[Time Sheet Header].[Ending Date]
,[Inventory Period].[Ending Date]
FROM
[CRONUS UK Ltd_$Time Sheet Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Time Sheet Header]
LEFT JOIN
[CRONUS UK Ltd_$Inventory Period$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Period]
ON
[Time Sheet Header].[Ending Date] = [Inventory Period].[Ending Date] | |||||||
| 5 | Resource No. | Resource No. | Normal | Code | 20 | Resource No_ | nvarchar(40) |
Key to join to the Resource table.Show/hide example querySELECT
[Time Sheet Header].[Resource No_]
,[Resource].[No_]
FROM
[CRONUS UK Ltd_$Time Sheet Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Time Sheet Header]
LEFT JOIN
[CRONUS UK Ltd_$Resource$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Resource]
ON
[Time Sheet Header].[Resource No_] = [Resource].[No_] | |||||||
| 6 | Resource Name | Resource Name | FlowField | Text | 100 | ||
| 7 | Owner User ID | Owner User ID | Normal | Code | 50 | Owner User ID | nvarchar(100) |
Key to join to the User Setup table.Show/hide example querySELECT
[Time Sheet Header].[Owner User ID]
,[User Setup].[User ID]
FROM
[CRONUS UK Ltd_$Time Sheet Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Time Sheet Header]
LEFT JOIN
[CRONUS UK Ltd_$User Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [User Setup]
ON
[Time Sheet Header].[Owner User ID] = [User Setup].[User ID] | |||||||
| 8 | Approver User ID | Approver User ID | Normal | Code | 50 | Approver User ID | nvarchar(100) |
Key to join to the User Setup table.Show/hide example querySELECT
[Time Sheet Header].[Approver User ID]
,[User Setup].[User ID]
FROM
[CRONUS UK Ltd_$Time Sheet Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Time Sheet Header]
LEFT JOIN
[CRONUS UK Ltd_$User Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [User Setup]
ON
[Time Sheet Header].[Approver User ID] = [User Setup].[User ID] | |||||||
| 10 | Description | Description | Normal | Text | 100 | Description | nvarchar(200) |
| 11 | Unit of Measure | Unit of Measure | FlowField | Code | 10 | ||
| 12 | Open Exists | Open Exists | FlowField | Boolean | 4 | ||
| 13 | Submitted Exists | Submitted Exists | FlowField | Boolean | 4 | ||
| 14 | Rejected Exists | Rejected Exists | FlowField | Boolean | 4 | ||
| 15 | Approved Exists | Approved Exists | FlowField | Boolean | 4 | ||
| 16 | Posted Exists | Posted Exists | FlowField | Boolean | 4 | ||
| 20 | Quantity | Quantity | FlowField | Decimal | 12 | ||
| 21 | Posted Quantity | Posted Quantity | FlowField | Decimal | 12 | ||
| 26 | Comment | Comment | FlowField | Boolean | 4 | ||
| 30 | Status Filter | Status Filter | FlowFilter | Option | 4 | ||
| 31 | Job No. Filter | Job No. Filter | FlowFilter | Code | 20 | ||
| 32 | Job Task No. Filter | Job Task No. Filter | FlowFilter | Code | 20 | ||
| 33 | Date Filter | Date Filter | FlowFilter | Date | 4 | ||
| 34 | Posted Filter | Posted Filter | FlowFilter | Boolean | 4 | ||
| 35 | Type Filter | Type Filter | FlowFilter | Option | 4 | ||
| 40 | Quantity Open | Quantity Open | FlowField | Decimal | 12 | ||
| 41 | Quantity Submitted | Quantity Submitted | FlowField | Decimal | 12 | ||
| 42 | Quantity Approved | Quantity Approved | FlowField | Decimal | 12 | ||
| 43 | Quantity Rejected | Quantity Rejected | FlowField | Decimal | 12 | ||
| 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
[Time Sheet Header].[$systemCreatedBy]
,[User].[User Security ID]
FROM
[CRONUS UK Ltd_$Time Sheet Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Time Sheet Header]
LEFT JOIN
[User] AS [User]
ON
[Time Sheet Header].[$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
[Time Sheet Header].[$systemModifiedBy]
,[User].[User Security ID]
FROM
[CRONUS UK Ltd_$Time Sheet Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Time Sheet Header]
LEFT JOIN
[User] AS [User]
ON
[Time Sheet Header].[$systemModifiedBy] = [User].[User Security ID] | |||||||