VAT Report Line

Dynamics 365 BC Table ReferenceTablesCompany TablesVVAT Report Line

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

Table Type: Company

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

Table Number: 741

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

Show/hide an example select of all columns

SELECT

   *

FROM

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

Show/hide an example select of all columns by name

SELECT

   [VAT Report No_]
   ,[Line No_]
   ,[Gen_ Prod_ Posting Group]
   ,[Posting Date]
   ,[Document No_]
   ,[Document Type]
   ,[Type]
   ,[Base]
   ,[Amount]
   ,[VAT Calculation Type]
   ,[Bill-to_Pay-to No_]
   ,[EU 3-Party Trade]
   ,[Source Code]
   ,[Reason Code]
   ,[Country_Region Code]
   ,[Internal Ref_ No_]
   ,[Unrealized Amount]
   ,[Unrealized Base]
   ,[External Document No_]
   ,[VAT Bus_ Posting Group]
   ,[VAT Prod_ Posting Group]
   ,[VAT Registration No_]
   ,[Gen_ Bus_ Posting Group]
   ,[Record Identifier]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$VAT Report Line$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 Report Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Report Line]
LEFT JOIN
   [CRONUS UK Ltd_$Sales Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header Archive]
      ON
         [VAT Report Line].[Document Type] = [Sales Header Archive].[Document Type]
      AND
         [VAT Report Line].[Document No_] = [Sales Header Archive].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header]
      ON
         [VAT Report Line].[Document Type] = [Sales Header].[Document Type]
      AND
         [VAT Report Line].[Document No_] = [Sales Header].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
      ON
         [VAT Report Line].[Source Code] = [Source Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Reason Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reason Code]
      ON
         [VAT Report Line].[Reason Code] = [Reason Code].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [VAT Report Line].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [VAT Report Line].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [VAT Report Line].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in VAT Report Line table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1VAT Report No. SearchTax Report No.NormalCode20VAT Report No_nvarchar(40)
Key to join to the VAT Report Header table.

Show/hide example query

SELECT
	       [VAT Report Line].[VAT Report No_]
	       ,[VAT Report Header].[No_]
	FROM
	       [CRONUS UK Ltd_$VAT Report Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Report Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$VAT Report Header$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [VAT Report Header]
	              ON
	                     [VAT Report Line].[VAT Report No_] = [VAT Report Header].[No_]
2Line No. Primary Key SearchLine No.NormalInteger4Line No_int
3Gen. Prod. Posting Group Primary Key SearchGen. Prod. Posting GroupNormalCode20Gen_ Prod_ Posting Groupnvarchar(40)
Key to join to the Gen. Product Posting Group table.

Show/hide example query

SELECT
	       [VAT Report Line].[Gen_ Prod_ Posting Group]
	       ,[Gen. Product Posting Group].[Code]
	FROM
	       [CRONUS UK Ltd_$VAT Report Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Report Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Gen_ Product Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Product Posting Group]
	              ON
	                     [VAT Report Line].[Gen_ Prod_ Posting Group] = [Gen. Product Posting Group].[Code]
4Posting Date SearchPosting DateNormalDate4Posting Datedatetime
5Document No. SearchDocument No.NormalCode20Document No_nvarchar(40)
6Document Type SearchDocument TypeNormalOption4Document Typeint
Available options are:
  • ” “
  • “Payment”
  • “Invoice”
  • “Credit Memo”
  • “Finance Charge Memo”
  • “Reminder”
  • “Refund”
7Type SearchTypeNormalOption4Typeint
Available options are:
  • ” “
  • “Purchase”
  • “Sale”
  • “Settlement”
8Base SearchBaseNormalDecimal12Basedecimal(38,38)
9Amount SearchAmountNormalDecimal12Amountdecimal(38,38)
10VAT Calculation Type SearchVAT Calculation TypeNormalOption4VAT Calculation Typeint
Available options are:
  • “Normal VAT”
  • “Reverse Charge VAT”
  • “Full VAT”
  • “Sales Tax”
12Bill-to/Pay-to No. SearchBill-to/Pay-to No.NormalCode20Bill-to_Pay-to No_nvarchar(40)
13EU 3-Party Trade SearchEU 3-Party TradeNormalBoolean4EU 3-Party Tradetinyint
15Source Code SearchSource CodeNormalCode10Source Codenvarchar(20)
Key to join to the Source Code table.

Show/hide example query

SELECT
	       [VAT Report Line].[Source Code]
	       ,[Source Code].[Code]
	FROM
	       [CRONUS UK Ltd_$VAT Report Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Report Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
	              ON
	                     [VAT Report Line].[Source Code] = [Source Code].[Code]
16Reason Code SearchReason CodeNormalCode10Reason Codenvarchar(20)
Key to join to the Reason Code table.

Show/hide example query

SELECT
	       [VAT Report Line].[Reason Code]
	       ,[Reason Code].[Code]
	FROM
	       [CRONUS UK Ltd_$VAT Report Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Report Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Reason Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reason Code]
	              ON
	                     [VAT Report Line].[Reason Code] = [Reason Code].[Code]
19Country/Region Code SearchCountry/Region CodeNormalCode10Country_Region Codenvarchar(20)
20Internal Ref. No. SearchInternal Ref. No.NormalText30Internal Ref_ No_nvarchar(60)
22Unrealized Amount SearchUnrealized AmountNormalDecimal12Unrealized Amountdecimal(38,38)
23Unrealized Base SearchUnrealized BaseNormalDecimal12Unrealized Basedecimal(38,38)
26External Document No. SearchExternal Document No.NormalCode35External Document No_nvarchar(70)
39VAT Bus. Posting Group SearchVAT Bus. Posting GroupNormalCode20VAT Bus_ Posting Groupnvarchar(40)
Key to join to the VAT Business Posting Group table.

Show/hide example query

SELECT
	       [VAT Report Line].[VAT Bus_ Posting Group]
	       ,[VAT Business Posting Group].[Code]
	FROM
	       [CRONUS UK Ltd_$VAT Report Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Report Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$VAT Business Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Business Posting Group]
	              ON
	                     [VAT Report Line].[VAT Bus_ Posting Group] = [VAT Business Posting Group].[Code]
40VAT Prod. Posting Group SearchVAT Prod. Posting GroupNormalCode20VAT Prod_ Posting Groupnvarchar(40)
Key to join to the VAT Product Posting Group table.

Show/hide example query

SELECT
	       [VAT Report Line].[VAT Prod_ Posting Group]
	       ,[VAT Product Posting Group].[Code]
	FROM
	       [CRONUS UK Ltd_$VAT Report Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Report Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$VAT Product Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Product Posting Group]
	              ON
	                     [VAT Report Line].[VAT Prod_ Posting Group] = [VAT Product Posting Group].[Code]
55VAT Registration No. SearchTax Registration No.NormalText20VAT Registration No_nvarchar(40)
56Gen. Bus. Posting Group SearchGen. Bus. Posting GroupNormalCode20Gen_ Bus_ Posting Groupnvarchar(40)
Key to join to the Gen. Business Posting Group table.

Show/hide example query

SELECT
	       [VAT Report Line].[Gen_ Bus_ Posting Group]
	       ,[Gen. Business Posting Group].[Code]
	FROM
	       [CRONUS UK Ltd_$VAT Report Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Report Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Gen_ Business Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Business Posting Group]
	              ON
	                     [VAT Report Line].[Gen_ Bus_ Posting Group] = [Gen. Business Posting Group].[Code]
100Record Identifier SearchRecord IdentifierNormalCode30Record Identifiernvarchar(60)
2000000000$systemId SearchSystem IDNormalGUID16$systemIduniqueidentifier
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8$systemCreatedAtdatetime
2000000002SystemCreatedBy SearchCreated ByNormalGUID16$systemCreatedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
	       [VAT Report Line].[$systemCreatedBy]
	       ,[User].[User Security ID]
	FROM
	       [CRONUS UK Ltd_$VAT Report Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Report Line]
	LEFT JOIN
	       [User] AS [User]
	              ON
	                     [VAT Report Line].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier

Show/hide tables related from VAT Report Line table

Sales HeaderSales Header Archive
Dynamics 365 BC Table ReferenceTablesCompany TablesVVAT Report Line

Leave a Reply

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