VAT Registration Log – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables VVAT Registration Log

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

Table Type: Company

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

Table Number: 249

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 Registration Log can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$VAT Registration Log$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT

   [timestamp]
   ,[Entry No_]
   ,[VAT Registration No_]
   ,[Account Type]
   ,[Account No_]
   ,[Country_Region Code]
   ,[User ID]
   ,[Status]
   ,[Verified Name]
   ,[Verified Address]
   ,[Verified Date]
   ,[Request Identifier]
   ,[Verified Street]
   ,[Verified Postcode]
   ,[Verified City]
   ,[Details Status]
   ,[Template]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$VAT Registration Log$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns including those from all joined tables

SELECT
   *
FROM
   [CRONUS UK Ltd_$VAT Registration Log$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Registration Log]
LEFT JOIN
   [CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country_Region]
      ON
         [VAT Registration Log].[Country_Region Code] = [Country_Region].[Code]

Show/hide columns in VAT Registration Log table

Column ID	Column Name	Data Type
1	timestamp	timestamp
2	Entry No_	int
3	VAT Registration No_	nvarchar(40)
4	Account Type	int
5	Account No_	nvarchar(40)
6	Country_Region Code	nvarchar(20)
	Key to join to the Country_Region table. Show/hide example query SELECT [VAT Registration Log].[Country_Region Code] ,[Country_Region].[Code] FROM [CRONUS UK Ltd_$VAT Registration Log$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Registration Log] LEFT JOIN [CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country_Region] ON [VAT Registration Log].[Country_Region Code] = [Country_Region].[Code]
7	User ID	nvarchar(100)
8	Status	int
9	Verified Name	nvarchar(300)
10	Verified Address	nvarchar(300)
11	Verified Date	datetime
12	Request Identifier	nvarchar(400)
13	Verified Street	nvarchar(100)
14	Verified Postcode	nvarchar(40)
15	Verified City	nvarchar(60)
16	Details Status	int
17	Template	nvarchar(40)
18	$systemId	uniqueidentifier
19	$systemCreatedAt	datetime
20	$systemCreatedBy	uniqueidentifier
21	$systemModifiedAt	datetime
22	$systemModifiedBy	uniqueidentifier