BCPT Line

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

Table Type: Company

Table Name: BCPT Line
Database Table Name: CRONUS UK Ltd_$BCPT Line$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 Line can be queried.

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[BCPT Code]
   ,[Line No_]
   ,[Codeunit ID]
   ,[No_ of Sessions]
   ,[Description]
   ,[Status]
   ,[Min_ User Delay (ms)]
   ,[Max_ User Delay (ms)]
   ,[Delay (sec_ btwn_ iter_)]
   ,[Delay Type]
   ,[Run in Foreground]
   ,[Sequence]
   ,[Indentation]
   ,[No_ of Running Sessions]
   ,[Parameters]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$BCPT Line$75f1590f-55c5-4501-ae63-bada5534e852]

Show/hide columns in BCPT Line table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2BCPT Code Primary Key Searchnvarchar(20)
3Line No_ Primary Key Searchint
4Codeunit ID Searchint
5No_ of Sessions Searchint
6Description Searchnvarchar(100)
7Status Searchint
8Min_ User Delay (ms) Searchint
9Max_ User Delay (ms) Searchint
10Delay (sec_ btwn_ iter_) Searchint
11Delay Type Searchint
12Run in Foreground Searchtinyint
13Sequence Searchint
14Indentation Searchint
15No_ of Running Sessions Searchint
16Parameters Searchnvarchar(2000)
17$systemId Searchuniqueidentifier
18$systemCreatedAt Searchdatetime
19$systemCreatedBy Searchuniqueidentifier
20$systemModifiedAt Searchdatetime
21$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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