VAT Rate Change Setup – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables VVAT Rate Change Setup

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

Table Type: Company

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

Table Number: 550

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

Show/hide an example select of all columns

SELECT

   *

FROM

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

Show/hide an example select of all columns by name

SELECT

   [Primary Key]
   ,[Update Gen_ Prod_ Post_ Groups]
   ,[Update G_L Accounts]
   ,[Update Items]
   ,[Update Item Templates]
   ,[Update Item Charges]
   ,[Update Resources]
   ,[Update Gen_ Journal Lines]
   ,[Update Gen_ Journal Allocation]
   ,[Update Std_ Gen_ Jnl_ Lines]
   ,[Update Res_ Journal Lines]
   ,[Update Job Journal Lines]
   ,[Update Requisition Lines]
   ,[Update Std_ Item Jnl_ Lines]
   ,[Update Service Docs_]
   ,[Update Serv_ Price Adj_ Detail]
   ,[Update Sales Documents]
   ,[Update Purchase Documents]
   ,[Update Production Orders]
   ,[Update Work Centers]
   ,[Update Machine Centers]
   ,[Update Reminders]
   ,[Update Finance Charge Memos]
   ,[VAT Rate Change Tool Completed]
   ,[Ignore Status on Sales Docs_]
   ,[Ignore Status on Purch_ Docs_]
   ,[Perform Conversion]
   ,[Item Filter]
   ,[Account Filter]
   ,[Resource Filter]
   ,[Ignore Status on Service Docs_]
   ,[Update Unit Price For G_L Acc_]
   ,[Upd_ Unit Price For Item Chrg_]
   ,[Upd_ Unit Price For FA]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$VAT Rate Change Setup$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 Rate Change Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Rate Change Setup]
LEFT JOIN
   [CRONUS UK Ltd_$Item$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item]
      ON
         [VAT Rate Change Setup].[Item Filter] = [Item].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Resource$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Resource]
      ON
         [VAT Rate Change Setup].[Resource Filter] = [Resource].[No_]
LEFT JOIN
   [User] AS [User]
      ON
         [VAT Rate Change Setup].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [VAT Rate Change Setup].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in VAT Rate Change Setup table

Field No.	Field Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	Primary Key	Primary Key	Normal	Code	10	Primary Key	nvarchar(20)
10	Update Gen. Prod. Post. Groups	Update Gen. Prod. Post. Groups	Normal	Option	4	Update Gen_ Prod_ Post_ Groups	int
	Available options are: “VAT Prod. Posting Group” “No”
15	Update G/L Accounts	Update G/L Accounts	Normal	Option	4	Update G_L Accounts	int
17	Update Items	Update Items	Normal	Option	4	Update Items	int
	Available options are: “VAT Prod. Posting Group” “Gen. Prod. Posting Group” “Both” “No”
18	Update Item Templates	Update Item Templates	Normal	Option	4	Update Item Templates	int
	Available options are: “VAT Prod. Posting Group” “Gen. Prod. Posting Group” “Both” “No”
19	Update Item Charges	Update Item Charges	Normal	Option	4	Update Item Charges	int
	Available options are: “VAT Prod. Posting Group” “Gen. Prod. Posting Group” “Both” “No”
21	Update Resources	Update Resources	Normal	Option	4	Update Resources	int
	Available options are: “VAT Prod. Posting Group” “Gen. Prod. Posting Group” “Both” “No”
30	Update Gen. Journal Lines	Update Gen. Journal Lines	Normal	Option	4	Update Gen_ Journal Lines	int
	Available options are: “VAT Prod. Posting Group” “Gen. Prod. Posting Group” “Both” “No”
31	Update Gen. Journal Allocation	Update Gen. Journal Allocation	Normal	Option	4	Update Gen_ Journal Allocation	int
	Available options are: “VAT Prod. Posting Group” “Gen. Prod. Posting Group” “Both” “No”
32	Update Std. Gen. Jnl. Lines	Update Std. Gen. Jnl. Lines	Normal	Option	4	Update Std_ Gen_ Jnl_ Lines	int
	Available options are: “VAT Prod. Posting Group” “Gen. Prod. Posting Group” “Both” “No”
33	Update Res. Journal Lines	Update Res. Journal Lines	Normal	Option	4	Update Res_ Journal Lines	int
	Available options are: “” “Gen. Prod. Posting GroupNo”
35	Update Job Journal Lines	Update Job Journal Lines	Normal	Option	4	Update Job Journal Lines	int
	Available options are: “” “Gen. Prod. Posting GroupNo”
37	Update Requisition Lines	Update Requisition Lines	Normal	Option	4	Update Requisition Lines	int
	Available options are: “” “Gen. Prod. Posting GroupNo”
39	Update Std. Item Jnl. Lines	Update Std. Item Jnl. Lines	Normal	Option	4	Update Std_ Item Jnl_ Lines	int
	Available options are: “” “Gen. Prod. Posting GroupNo”
41	Update Service Docs.	Update Service Docs.	Normal	Option	4	Update Service Docs_	int
	Available options are: “VAT Prod. Posting Group” “Gen. Prod. Posting Group” “Both” “No”
43	Update Serv. Price Adj. Detail	Update Serv. Price Adj. Detail	Normal	Option	4	Update Serv_ Price Adj_ Detail	int
	Available options are: “” “Gen. Prod. Posting GroupNo”
50	Update Sales Documents	Update Sales Documents	Normal	Option	4	Update Sales Documents	int
	Available options are: “VAT Prod. Posting Group” “Gen. Prod. Posting Group” “Both” “No”
55	Update Purchase Documents	Update Purchase Documents	Normal	Option	4	Update Purchase Documents	int
	Available options are: “VAT Prod. Posting Group” “Gen. Prod. Posting Group” “Both” “No”
60	Update Production Orders	Update Production Orders	Normal	Option	4	Update Production Orders	int
	Available options are: “” “Gen. Prod. Posting GroupNo”
62	Update Work Centers	Update Work Centers	Normal	Option	4	Update Work Centers	int
	Available options are: “” “Gen. Prod. Posting GroupNo”
64	Update Machine Centers	Update Machine Centers	Normal	Option	4	Update Machine Centers	int
	Available options are: “” “Gen. Prod. Posting GroupNo”
70	Update Reminders	Update Reminders	Normal	Option	4	Update Reminders	int
	Available options are: “VAT Prod. Posting Group” “No”
75	Update Finance Charge Memos	Update Finance Charge Memos	Normal	Option	4	Update Finance Charge Memos	int
	Available options are: “VAT Prod. Posting Group” “No”
90	VAT Rate Change Tool Completed	Tax Rate Change Tool Completed	Normal	Boolean	4	VAT Rate Change Tool Completed	tinyint
91	Ignore Status on Sales Docs.	Ignore Status on Sales Docs.	Normal	Boolean	4	Ignore Status on Sales Docs_	tinyint
92	Ignore Status on Purch. Docs.	Ignore Status on Purch. Docs.	Normal	Boolean	4	Ignore Status on Purch_ Docs_	tinyint
93	Perform Conversion	Perform Conversion	Normal	Boolean	4	Perform Conversion	tinyint
100	Item Filter	Item Filter	Normal	Text	250	Item Filter	nvarchar(500)
	Key to join to the Item table. Show/hide example query SELECT [VAT Rate Change Setup].[Item Filter] ,[Item].[No_] FROM [CRONUS UK Ltd_$VAT Rate Change Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Rate Change Setup] LEFT JOIN [CRONUS UK Ltd_$Item$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item] ON [VAT Rate Change Setup].[Item Filter] = [Item].[No_]
101	Account Filter	Account Filter	Normal	Text	250	Account Filter	nvarchar(500)
102	Resource Filter	Resource Filter	Normal	Text	250	Resource Filter	nvarchar(500)
	Key to join to the Resource table. Show/hide example query SELECT [VAT Rate Change Setup].[Resource Filter] ,[Resource].[No_] FROM [CRONUS UK Ltd_$VAT Rate Change Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Rate Change Setup] LEFT JOIN [CRONUS UK Ltd_$Resource$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Resource] ON [VAT Rate Change Setup].[Resource Filter] = [Resource].[No_]
103	Ignore Status on Service Docs.	Ignore Status on Service Docs.	Normal	Boolean	4	Ignore Status on Service Docs_	tinyint
110	Update Unit Price For G/L Acc.	Update Unit Prices for G/L Accounts	Normal	Boolean	4	Update Unit Price For G_L Acc_	tinyint
111	Upd. Unit Price For Item Chrg.	Update Unit Prices for Item Charges	Normal	Boolean	4	Upd_ Unit Price For Item Chrg_	tinyint
112	Upd. Unit Price For FA	Update Unit Prices for Fixed Assets	Normal	Boolean	4	Upd_ Unit Price For FA	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 Rate Change Setup].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$VAT Rate Change Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Rate Change Setup] LEFT JOIN [User] AS [User] ON [VAT Rate Change Setup].[$systemCreatedBy] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier