VAT Report Archive

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

Table Type: Company

Table Name: VAT Report Archive
Database Table Name: CRONUS UK Ltd_$VAT Report Archive$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 747

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 VAT Report Archive can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$VAT Report Archive$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[VAT Report Type]
   ,[VAT Report No_]
   ,[Xml Part ID]
   ,[Submitted By]
   ,[Submission Message BLOB]
   ,[Submittion Date]
   ,[Response Message BLOB]
   ,[Response Received Date]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$VAT Report Archive$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in VAT Report Archive table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2VAT Report Type Primary Key Searchint
3VAT Report No_ Primary Key Searchnvarchar(40)
4Xml Part ID Primary Key Searchuniqueidentifier
5Submitted By Searchnvarchar(100)
6Submission Message BLOB Searchimage
7Submittion Date Searchdatetime
8Response Message BLOB Searchimage
9Response Received Date Searchdatetime
10$systemId Searchuniqueidentifier
11$systemCreatedAt Searchdatetime
12$systemCreatedBy Searchuniqueidentifier
13$systemModifiedAt Searchdatetime
14$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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