VAT Setup Posting Groups – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables VVAT Setup Posting Groups

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

Table Type: Company

Table Name: VAT Setup Posting Groups
Database Table Name: CRONUS UK Ltd_$VAT Setup Posting Groups$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 1877

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 Setup Posting Groups can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$VAT Setup Posting Groups$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT

   [VAT Prod_ Posting Group]
   ,[VAT _]
   ,[Sales VAT Account]
   ,[Purchase VAT Account]
   ,[Reverse Chrg_ VAT Acc_]
   ,[VAT Prod_ Posting Grp Desc_]
   ,[VAT Clause Desc]
   ,[Selected]
   ,[Application Type]
   ,[Default]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$VAT Setup Posting Groups$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 Setup Posting Groups$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Setup Posting Groups]
LEFT JOIN
   [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
      ON
         [VAT Setup Posting Groups].[Sales VAT Account] = [G/L Account].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
      ON
         [VAT Setup Posting Groups].[Purchase VAT Account] = [G/L Account].[No_]
LEFT JOIN
   [User] AS [User]
      ON
         [VAT Setup Posting Groups].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [VAT Setup Posting Groups].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in VAT Setup Posting Groups table

Field No.	Field Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
2	VAT Prod. Posting Group	VAT Prod. Posting Group	Normal	Code	20	VAT Prod_ Posting Group	nvarchar(40)
	Key to join to the VAT Product Posting Group table. Show/hide example query SELECT [VAT Setup Posting Groups].[VAT Prod_ Posting Group] ,[VAT Product Posting Group].[Code] FROM [CRONUS UK Ltd_$VAT Setup Posting Groups$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Setup Posting Groups] LEFT JOIN [CRONUS UK Ltd_$VAT Product Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Product Posting Group] ON [VAT Setup Posting Groups].[VAT Prod_ Posting Group] = [VAT Product Posting Group].[Code]
4	VAT %	Tax %	Normal	Decimal	12	VAT _	decimal(38,38)
7	Sales VAT Account	Sales Tax Account	Normal	Code	20	Sales VAT Account	nvarchar(40)
	Key to join to the G/L Account table. Show/hide example query SELECT [VAT Setup Posting Groups].[Sales VAT Account] ,[G/L Account].[No_] FROM [CRONUS UK Ltd_$VAT Setup Posting Groups$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Setup Posting Groups] LEFT JOIN [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account] ON [VAT Setup Posting Groups].[Sales VAT Account] = [G/L Account].[No_]
9	Purchase VAT Account	Purchase Tax Account	Normal	Code	20	Purchase VAT Account	nvarchar(40)
	Key to join to the G/L Account table. Show/hide example query SELECT [VAT Setup Posting Groups].[Purchase VAT Account] ,[G/L Account].[No_] FROM [CRONUS UK Ltd_$VAT Setup Posting Groups$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Setup Posting Groups] LEFT JOIN [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account] ON [VAT Setup Posting Groups].[Purchase VAT Account] = [G/L Account].[No_]
11	Reverse Chrg. VAT Acc.	Reverse Chrg. Tax Acc.	Normal	Code	20	Reverse Chrg_ VAT Acc_	nvarchar(40)
	Key to join to the G/L Account table. Show/hide example query SELECT [VAT Setup Posting Groups].[Reverse Chrg_ VAT Acc_] ,[G/L Account].[No_] FROM [CRONUS UK Ltd_$VAT Setup Posting Groups$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Setup Posting Groups] LEFT JOIN [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account] ON [VAT Setup Posting Groups].[Reverse Chrg_ VAT Acc_] = [G/L Account].[No_]
18	VAT Prod. Posting Grp Desc.	Tax Prod. Posting Grp Desc.	Normal	Text	100	VAT Prod_ Posting Grp Desc_	nvarchar(200)
19	VAT Clause Desc	Tax Clause Desc	Normal	Text	250	VAT Clause Desc	nvarchar(500)
22	Selected	Selected	Normal	Boolean	4	Selected	tinyint
23	Application Type	Application Type	Normal	Option	4	Application Type	int
	Available options are: “” “Items” “Services”
24	Default	Default	Normal	Boolean	4	Default	tinyint
2000000000	$systemId	System ID	Normal	GUID	16	$systemId	uniqueidentifier
2000000001	SystemCreatedAt	Created At	Normal	DateTime	8	$systemCreatedAt	datetime
2000000002	SystemCreatedBy	Created By	Normal	GUID	16	$systemCreatedBy	uniqueidentifier
	Key to join to the User table. Show/hide example query SELECT [VAT Setup Posting Groups].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$VAT Setup Posting Groups$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Setup Posting Groups] LEFT JOIN [User] AS [User] ON [VAT Setup Posting Groups].[$systemCreatedBy] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier
	Key to join to the User table. Show/hide example query SELECT [VAT Setup Posting Groups].[$systemModifiedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$VAT Setup Posting Groups$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Setup Posting Groups] LEFT JOIN [User] AS [User] ON [VAT Setup Posting Groups].[$systemModifiedBy] = [User].[User Security ID]

Dynamics 365 BC Table Reference Tables Company Tables VVAT Setup Posting Groups

Leave a Reply Cancel reply