Time Sheet Header Archive

Dynamics 365 BC Table ReferenceTablesCompany TablesTTime Sheet Header Archive

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

Table Number: 954

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

Show/hide example query

SELECT
	       [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_]
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 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]
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 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]
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 Archive].[]
	       ,[Unit of Measure].[Code]
	FROM
	       [CRONUS UK Ltd_$Time Sheet Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Time Sheet Header Archive]
	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].[Code]
20Quantity SearchQuantityFlowFieldDecimal12
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
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 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]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Dynamics 365 BC Table ReferenceTablesCompany TablesTTime Sheet Header Archive

Leave a Reply

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