VAT Rate Change Conversion

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

Table Type: Company

Table Name: VAT Rate Change Conversion
Database Table Name: CRONUS UK Ltd_$VAT Rate Change Conversion$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 551

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 Rate Change Conversion can be queried.

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Type]
   ,[From Code]
   ,[To Code]
   ,[Converted Date]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$VAT Rate Change Conversion$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in VAT Rate Change Conversion table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Type Primary Key Searchint
3From Code Primary Key Searchnvarchar(40)
4To Code Searchnvarchar(40)
5Converted Date Searchdatetime
6$systemId Searchuniqueidentifier
7$systemCreatedAt Searchdatetime
8$systemCreatedBy Searchuniqueidentifier
9$systemModifiedAt Searchdatetime
10$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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