Time Sheet Detail – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables TTime Sheet Detail

Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/952

Table Type: Company

Table Name: Time Sheet Detail
Database Table Name: CRONUS UK Ltd_$Time Sheet Detail$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 952

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 Detail can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Time Sheet Detail$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT

   [timestamp]
   ,[Time Sheet No_]
   ,[Time Sheet Line No_]
   ,[Date]
   ,[Type]
   ,[Resource No_]
   ,[Job No_]
   ,[Job Task No_]
   ,[Cause of Absence Code]
   ,[Service Order No_]
   ,[Service Order Line No_]
   ,[Quantity]
   ,[Posted Quantity]
   ,[Assembly Order No_]
   ,[Assembly Order Line No_]
   ,[Status]
   ,[Posted]
   ,[Dimension Set ID]
   ,[Id]
   ,[Last Modified DateTime]
   ,[Job Id]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Time Sheet Detail$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 Detail$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Time Sheet Detail]
LEFT JOIN
   [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job]
      ON
         [Time Sheet Detail].[Job No_] = [Job].[Job No_]
LEFT JOIN
   [CRONUS UK Ltd_$Job Task$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Task]
      ON
         [Time Sheet Detail].[Job Task No_] = [Job Task].[Job Task No_]

Show/hide columns in Time Sheet Detail table

Column ID	Column Name	Data Type
1	timestamp	timestamp
2	Time Sheet No_	nvarchar(40)
3	Time Sheet Line No_	int
4	Date	datetime
5	Type	int
6	Resource No_	nvarchar(40)
7	Job No_	nvarchar(40)
	Key to join to the Job table. Show/hide example query SELECT [Time Sheet Detail].[Job No_] ,[Job].[Job No_] FROM [CRONUS UK Ltd_$Time Sheet Detail$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Time Sheet Detail] LEFT JOIN [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job] ON [Time Sheet Detail].[Job No_] = [Job].[Job No_]
8	Job Task No_	nvarchar(40)
	Key to join to the Job Task table. Show/hide example query SELECT [Time Sheet Detail].[Job Task No_] ,[Job Task].[Job Task No_] FROM [CRONUS UK Ltd_$Time Sheet Detail$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Time Sheet Detail] LEFT JOIN [CRONUS UK Ltd_$Job Task$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Task] ON [Time Sheet Detail].[Job Task No_] = [Job Task].[Job Task No_]
9	Cause of Absence Code	nvarchar(20)
10	Service Order No_	nvarchar(40)
11	Service Order Line No_	int
12	Quantity	decimal(38,38)
13	Posted Quantity	decimal(38,38)
14	Assembly Order No_	nvarchar(40)
15	Assembly Order Line No_	int
16	Status	int
17	Posted	tinyint
18	Dimension Set ID	int
19	Id	uniqueidentifier
20	Last Modified DateTime	datetime
21	Job Id	uniqueidentifier
22	$systemId	uniqueidentifier
23	$systemCreatedAt	datetime
24	$systemCreatedBy	uniqueidentifier
25	$systemModifiedAt	datetime
26	$systemModifiedBy	uniqueidentifier