Time Sheet Posting Entry

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

Table Type: Company

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

Table Number: 958

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

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Time Sheet Posting Entry$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Entry No_]
   ,[Time Sheet No_]
   ,[Time Sheet Line No_]
   ,[Time Sheet Date]
   ,[Quantity]
   ,[Document No_]
   ,[Posting Date]
   ,[Description]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Time Sheet Posting Entry$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Time Sheet Posting Entry table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Entry No_ Primary Key Searchint
3Time Sheet No_ Searchnvarchar(40)
4Time Sheet Line No_ Searchint
5Time Sheet Date Searchdatetime
6Quantity Searchdecimal(38,38)
7Document No_ Searchnvarchar(40)
8Posting Date Searchdatetime
9Description Searchnvarchar(200)
10$systemId Searchuniqueidentifier
11$systemCreatedAt Searchdatetime
12$systemCreatedBy Searchuniqueidentifier
13$systemModifiedAt Searchdatetime
14$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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