BCPT Log Entry

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

Table Type: Company

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Entry No_]
   ,[BCPT Code]
   ,[BCPT Line No_]
   ,[Start Time]
   ,[End Time]
   ,[Message]
   ,[Codeunit ID]
   ,[Duration (ms)]
   ,[Status]
   ,[Operation]
   ,[No_ of SQL Statements]
   ,[Version]
   ,[Session No_]
   ,[Tag]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$BCPT Log Entry$75f1590f-55c5-4501-ae63-bada5534e852]

Show/hide columns in BCPT Log Entry table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Entry No_ Primary Key Searchint
3BCPT Code Searchnvarchar(20)
4BCPT Line No_ Searchint
5Start Time Searchdatetime
6End Time Searchdatetime
7Message Searchnvarchar(500)
8Codeunit ID Searchint
9Duration (ms) Searchint
10Status Searchint
11Operation Searchnvarchar(200)
12No_ of SQL Statements Searchint
13Version Searchint
14Session No_ Searchint
15Tag Searchnvarchar(40)
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 *