Time Sheet Header

Dynamics 365 BC Table ReferenceTablesCompany TablesTTime Sheet Header

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

Table Number: 950

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 NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1No. SearchNo.NormalCode20No_nvarchar(40)
3Starting Date Primary Key SearchStarting DateNormalDate4Starting Datedatetime
4Ending Date SearchEnding DateNormalDate4Ending Datedatetime
Key to join to the Inventory Period table.

Show/hide example query

SELECT
	       [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]
5Resource No. SearchResource No.NormalCode20Resource No_nvarchar(40)
Key to join to the Resource table.

Show/hide example query

SELECT
	       [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_]
6Resource Name SearchResource NameFlowFieldText100
7Owner User ID SearchOwner User IDNormalCode50Owner User IDnvarchar(100)
Key to join to the User Setup table.

Show/hide example query

SELECT
	       [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]
8Approver User ID SearchApprover User IDNormalCode50Approver User IDnvarchar(100)
Key to join to the User Setup table.

Show/hide example query

SELECT
	       [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]
10Description SearchDescriptionNormalText100Descriptionnvarchar(200)
11Unit of Measure SearchUnit of MeasureFlowFieldCode10
Key to join to the Unit of Measure table.

Show/hide example query

SELECT
	       [Time Sheet Header].[]
	       ,[Unit of Measure].[Code]
	FROM
	       [CRONUS UK Ltd_$Time Sheet Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Time Sheet Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
	              ON
	                     [Time Sheet Header].[] = [Unit of Measure].[Code]
12Open Exists SearchOpen ExistsFlowFieldBoolean4
13Submitted Exists SearchSubmitted ExistsFlowFieldBoolean4
14Rejected Exists SearchRejected ExistsFlowFieldBoolean4
15Approved Exists SearchApproved ExistsFlowFieldBoolean4
16Posted Exists SearchPosted ExistsFlowFieldBoolean4
20Quantity SearchQuantityFlowFieldDecimal12
21Posted Quantity SearchPosted QuantityFlowFieldDecimal12
26Comment SearchCommentFlowFieldBoolean4
30Status Filter SearchStatus FilterFlowFilterOption4
31Job No. Filter SearchJob No. FilterFlowFilterCode20
32Job Task No. Filter SearchJob Task No. FilterFlowFilterCode20
33Date Filter SearchDate FilterFlowFilterDate4
34Posted Filter SearchPosted FilterFlowFilterBoolean4
35Type Filter SearchType FilterFlowFilterOption4
40Quantity Open SearchQuantity OpenFlowFieldDecimal12
41Quantity Submitted SearchQuantity SubmittedFlowFieldDecimal12
42Quantity Approved SearchQuantity ApprovedFlowFieldDecimal12
43Quantity Rejected SearchQuantity RejectedFlowFieldDecimal12
2000000000$systemId SearchSystem IDNormalGUID16$systemIduniqueidentifier
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8$systemCreatedAtdatetime
2000000002SystemCreatedBy SearchCreated ByNormalGUID16$systemCreatedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
	       [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]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Dynamics 365 BC Table ReferenceTablesCompany TablesTTime Sheet Header

Leave a Reply

Your email address will not be published. Required fields are marked *