GovTalk Message Parts

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

Table Type: Company

Table Name: GovTalk Message Parts
Database Table Name: CRONUS UK Ltd_$GovTalk Message Parts$437dbf0e-84ff-417a-965d-ed2bb9650972

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 GovTalk Message Parts can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$GovTalk Message Parts$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Part Id]
   ,[Report No_]
   ,[VAT Report Config_ Code]
   ,[Correlation Id]
   ,[Status]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$GovTalk Message Parts$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in GovTalk Message Parts table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Part Id Primary Key Searchuniqueidentifier
3Report No_ Searchnvarchar(40)
4VAT Report Config_ Code Searchint
5Correlation Id Searchnvarchar(500)
6Status Searchint
7$systemId Searchuniqueidentifier
8$systemCreatedAt Searchdatetime
9$systemCreatedBy Searchuniqueidentifier
10$systemModifiedAt Searchdatetime
11$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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