Contract Change Log

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

Table Type: Company

Table Name: Contract Change Log
Database Table Name: CRONUS UK Ltd_$Contract Change Log$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 5967

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 Contract Change Log can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Contract Change Log$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Contract No_]
   ,[Change No_]
   ,[Contract Type]
   ,[User ID]
   ,[Date of Change]
   ,[Time of Change]
   ,[Contract Part]
   ,[Field Description]
   ,[Old Value]
   ,[New Value]
   ,[Type of Change]
   ,[Service Item No_]
   ,[Serv_ Contract Line No_]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Contract Change Log$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Contract Change Log table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Contract No_ Primary Key Searchnvarchar(40)
3Change No_ Primary Key Searchint
4Contract Type Searchint
5User ID Searchnvarchar(100)
6Date of Change Searchdatetime
7Time of Change Searchdatetime
8Contract Part Searchint
9Field Description Searchnvarchar(200)
10Old Value Searchnvarchar(200)
11New Value Searchnvarchar(200)
12Type of Change Searchint
13Service Item No_ Searchnvarchar(40)
14Serv_ Contract Line No_ Searchint
15$systemId Searchuniqueidentifier
16$systemCreatedAt Searchdatetime
17$systemCreatedBy Searchuniqueidentifier
18$systemModifiedAt Searchdatetime
19$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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