BCPT Header

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

Table Type: Company

Table Name: BCPT Header
Database Table Name: CRONUS UK Ltd_$BCPT Header$75f1590f-55c5-4501-ae63-bada5534e852

Table Number: 0

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

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$BCPT Header$75f1590f-55c5-4501-ae63-bada5534e852]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Code]
   ,[Description]
   ,[Duration (minutes)]
   ,[Status]
   ,[Started at]
   ,[Default Min_ User Delay (ms)]
   ,[Default Max_ User Delay (ms)]
   ,[Work date starts at]
   ,[1 Day Corresponds to (minutes)]
   ,[No_ of tests running]
   ,[Tag]
   ,[Version]
   ,[Base Version]
   ,[CurrentRunType]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$BCPT Header$75f1590f-55c5-4501-ae63-bada5534e852]

Show/hide columns in BCPT Header table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Code Primary Key Searchnvarchar(20)
3Description Searchnvarchar(100)
4Duration (minutes) Searchint
5Status Searchint
6Started at Searchdatetime
7Default Min_ User Delay (ms) Searchint
8Default Max_ User Delay (ms) Searchint
9Work date starts at Searchdatetime
101 Day Corresponds to (minutes) Searchint
11No_ of tests running Searchint
12Tag Searchnvarchar(40)
13Version Searchint
14Base Version Searchint
15CurrentRunType Searchint
16$systemId Searchuniqueidentifier
17$systemCreatedAt Searchdatetime
18$systemCreatedBy Searchuniqueidentifier
19$systemModifiedAt Searchdatetime
20$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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