VAT Rate Change Setup

Dynamics 365 BC Table ReferenceTablesCompany TablesVVAT 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 NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Primary Key Primary Key SearchPrimary KeyNormalCode10Primary Keynvarchar(20)
10Update Gen. Prod. Post. Groups SearchUpdate Gen. Prod. Post. GroupsNormalOption4Update Gen_ Prod_ Post_ Groupsint
Available options are:
  • “VAT Prod. Posting Group”
  • “No”
15Update G/L Accounts SearchUpdate G/L AccountsNormalOption4Update G_L Accountsint
Available options are:
  • “VAT Prod. Posting Group”
  • “Gen. Prod. Posting Group”
  • “Both”
  • “No”
17Update Items SearchUpdate ItemsNormalOption4Update Itemsint
Available options are:
  • “VAT Prod. Posting Group”
  • “Gen. Prod. Posting Group”
  • “Both”
  • “No”
18Update Item Templates SearchUpdate Item TemplatesNormalOption4Update Item Templatesint
Available options are:
  • “VAT Prod. Posting Group”
  • “Gen. Prod. Posting Group”
  • “Both”
  • “No”
19Update Item Charges SearchUpdate Item ChargesNormalOption4Update Item Chargesint
Available options are:
  • “VAT Prod. Posting Group”
  • “Gen. Prod. Posting Group”
  • “Both”
  • “No”
21Update Resources SearchUpdate ResourcesNormalOption4Update Resourcesint
Available options are:
  • “VAT Prod. Posting Group”
  • “Gen. Prod. Posting Group”
  • “Both”
  • “No”
30Update Gen. Journal Lines SearchUpdate Gen. Journal LinesNormalOption4Update Gen_ Journal Linesint
Available options are:
  • “VAT Prod. Posting Group”
  • “Gen. Prod. Posting Group”
  • “Both”
  • “No”
31Update Gen. Journal Allocation SearchUpdate Gen. Journal AllocationNormalOption4Update Gen_ Journal Allocationint
Available options are:
  • “VAT Prod. Posting Group”
  • “Gen. Prod. Posting Group”
  • “Both”
  • “No”
32Update Std. Gen. Jnl. Lines SearchUpdate Std. Gen. Jnl. LinesNormalOption4Update Std_ Gen_ Jnl_ Linesint
Available options are:
  • “VAT Prod. Posting Group”
  • “Gen. Prod. Posting Group”
  • “Both”
  • “No”
33Update Res. Journal Lines SearchUpdate Res. Journal LinesNormalOption4Update Res_ Journal Linesint
Available options are:
  • “”
  • “Gen. Prod. Posting GroupNo”
35Update Job Journal Lines SearchUpdate Job Journal LinesNormalOption4Update Job Journal Linesint
Available options are:
  • “”
  • “Gen. Prod. Posting GroupNo”
37Update Requisition Lines SearchUpdate Requisition LinesNormalOption4Update Requisition Linesint
Available options are:
  • “”
  • “Gen. Prod. Posting GroupNo”
39Update Std. Item Jnl. Lines SearchUpdate Std. Item Jnl. LinesNormalOption4Update Std_ Item Jnl_ Linesint
Available options are:
  • “”
  • “Gen. Prod. Posting GroupNo”
41Update Service Docs. SearchUpdate Service Docs.NormalOption4Update Service Docs_int
Available options are:
  • “VAT Prod. Posting Group”
  • “Gen. Prod. Posting Group”
  • “Both”
  • “No”
43Update Serv. Price Adj. Detail SearchUpdate Serv. Price Adj. DetailNormalOption4Update Serv_ Price Adj_ Detailint
Available options are:
  • “”
  • “Gen. Prod. Posting GroupNo”
50Update Sales Documents SearchUpdate Sales DocumentsNormalOption4Update Sales Documentsint
Available options are:
  • “VAT Prod. Posting Group”
  • “Gen. Prod. Posting Group”
  • “Both”
  • “No”
55Update Purchase Documents SearchUpdate Purchase DocumentsNormalOption4Update Purchase Documentsint
Available options are:
  • “VAT Prod. Posting Group”
  • “Gen. Prod. Posting Group”
  • “Both”
  • “No”
60Update Production Orders SearchUpdate Production OrdersNormalOption4Update Production Ordersint
Available options are:
  • “”
  • “Gen. Prod. Posting GroupNo”
62Update Work Centers SearchUpdate Work CentersNormalOption4Update Work Centersint
Available options are:
  • “”
  • “Gen. Prod. Posting GroupNo”
64Update Machine Centers SearchUpdate Machine CentersNormalOption4Update Machine Centersint
Available options are:
  • “”
  • “Gen. Prod. Posting GroupNo”
70Update Reminders SearchUpdate RemindersNormalOption4Update Remindersint
Available options are:
  • “VAT Prod. Posting Group”
  • “No”
75Update Finance Charge Memos SearchUpdate Finance Charge MemosNormalOption4Update Finance Charge Memosint
Available options are:
  • “VAT Prod. Posting Group”
  • “No”
90VAT Rate Change Tool Completed SearchTax Rate Change Tool CompletedNormalBoolean4VAT Rate Change Tool Completedtinyint
91Ignore Status on Sales Docs. SearchIgnore Status on Sales Docs.NormalBoolean4Ignore Status on Sales Docs_tinyint
92Ignore Status on Purch. Docs. SearchIgnore Status on Purch. Docs.NormalBoolean4Ignore Status on Purch_ Docs_tinyint
93Perform Conversion SearchPerform ConversionNormalBoolean4Perform Conversiontinyint
100Item Filter SearchItem FilterNormalText250Item Filternvarchar(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_]
101Account Filter SearchAccount FilterNormalText250Account Filternvarchar(500)
102Resource Filter SearchResource FilterNormalText250Resource Filternvarchar(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_]
103Ignore Status on Service Docs. SearchIgnore Status on Service Docs.NormalBoolean4Ignore Status on Service Docs_tinyint
110Update Unit Price For G/L Acc. SearchUpdate Unit Prices for G/L AccountsNormalBoolean4Update Unit Price For G_L Acc_tinyint
111Upd. Unit Price For Item Chrg. SearchUpdate Unit Prices for Item ChargesNormalBoolean4Upd_ Unit Price For Item Chrg_tinyint
112Upd. Unit Price For FA SearchUpdate Unit Prices for Fixed AssetsNormalBoolean4Upd_ Unit Price For FAtinyint
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 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]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [VAT Rate Change Setup].[$systemModifiedBy]
       ,[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].[$systemModifiedBy] = [User].[User Security ID]
Dynamics 365 BC Table ReferenceTablesCompany TablesVVAT Rate Change Setup

Leave a Reply

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