Time Sheet Line Archive – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables TTime Sheet Line Archive

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

Table Type: Company

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

Table Number: 955

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

Show/hide an example select of all columns

SELECT

   *

FROM

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

Show/hide an example select of all columns by name

SELECT

   [timestamp]
   ,[Time Sheet No_]
   ,[Line No_]
   ,[Time Sheet Starting Date]
   ,[Type]
   ,[Job No_]
   ,[Job Task No_]
   ,[Cause of Absence Code]
   ,[Description]
   ,[Work Type Code]
   ,[Approver ID]
   ,[Service Order No_]
   ,[Service Order Line No_]
   ,[Chargeable]
   ,[Assembly Order No_]
   ,[Assembly Order Line No_]
   ,[Status]
   ,[Approved By]
   ,[Approval Date]
   ,[Posted]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

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

Show/hide columns in Time Sheet Line Archive table

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