Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/954
Table Type: Company
Table Name: Time Sheet Header Archive
Database Table Name: CRONUS UK Ltd_$Time Sheet Header Archive$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 Archive can be queried.
Show/hide an example select of all columns
SELECT
*
FROM
[CRONUS UK Ltd_$Time Sheet Header Archive$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 Archive$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 Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Time Sheet Header Archive]
LEFT JOIN
[CRONUS UK Ltd_$Inventory Period$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Period]
ON
[Time Sheet Header Archive].[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 Archive].[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 Archive].[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 Archive].[Unit of Measure] = [Unit of Measure].[Code]
LEFT JOIN
[User] AS [User]
ON
[Time Sheet Header Archive].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
[User] AS [User]
ON
[Time Sheet Header Archive].[SystemModifiedBy] = [User].[User Security ID]Show/hide columns in Time Sheet Header Archive 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 Archive].[Ending Date]
,[Inventory Period].[Ending Date]
FROM
[CRONUS UK Ltd_$Time Sheet Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Time Sheet Header Archive]
LEFT JOIN
[CRONUS UK Ltd_$Inventory Period$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Period]
ON
[Time Sheet Header Archive].[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 Archive].[Resource No_]
,[Resource].[No_]
FROM
[CRONUS UK Ltd_$Time Sheet Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Time Sheet Header Archive]
LEFT JOIN
[CRONUS UK Ltd_$Resource$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Resource]
ON
[Time Sheet Header Archive].[Resource No_] = [Resource].[No_] | |||||||
| 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 Archive].[Owner User ID]
,[User Setup].[User ID]
FROM
[CRONUS UK Ltd_$Time Sheet Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Time Sheet Header Archive]
LEFT JOIN
[CRONUS UK Ltd_$User Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [User Setup]
ON
[Time Sheet Header Archive].[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 Archive].[Approver User ID]
,[User Setup].[User ID]
FROM
[CRONUS UK Ltd_$Time Sheet Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Time Sheet Header Archive]
LEFT JOIN
[CRONUS UK Ltd_$User Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [User Setup]
ON
[Time Sheet Header Archive].[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 | ||
| 20 | Quantity | 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 | ||
| 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 Archive].[$systemCreatedBy]
,[User].[User Security ID]
FROM
[CRONUS UK Ltd_$Time Sheet Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Time Sheet Header Archive]
LEFT JOIN
[User] AS [User]
ON
[Time Sheet Header Archive].[$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 Archive].[$systemModifiedBy]
,[User].[User Security ID]
FROM
[CRONUS UK Ltd_$Time Sheet Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Time Sheet Header Archive]
LEFT JOIN
[User] AS [User]
ON
[Time Sheet Header Archive].[$systemModifiedBy] = [User].[User Security ID] | |||||||