VAT Posting Setup

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

Table Type: Company

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

Table Number: 325

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [VAT Bus_ Posting Group]
   ,[VAT Prod_ Posting Group]
   ,[VAT Calculation Type]
   ,[VAT _]
   ,[Unrealized VAT Type]
   ,[Adjust for Payment Discount]
   ,[Sales VAT Account]
   ,[Sales VAT Unreal_ Account]
   ,[Purchase VAT Account]
   ,[Purch_ VAT Unreal_ Account]
   ,[Reverse Chrg_ VAT Acc_]
   ,[Reverse Chrg_ VAT Unreal_ Acc_]
   ,[VAT Identifier]
   ,[EU Service]
   ,[VAT Clause Code]
   ,[Certificate of Supply Required]
   ,[Tax Category]
   ,[Description]
   ,[Blocked]
   ,[Sale VAT Reporting Code]
   ,[Purch_ VAT Reporting Code]
   ,[Non-Deductible VAT _]
   ,[Non-Ded_ Purchase VAT Account]
   ,[Allow Non-Deductible VAT]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$VAT Posting 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 Posting Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Posting Setup]
LEFT JOIN
   [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
      ON
         [VAT Posting Setup].[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 Posting Setup].[Purchase VAT Account] = [G/L Account].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$VAT Clause$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Clause]
      ON
         [VAT Posting Setup].[VAT Clause Code] = [VAT Clause].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$VAT Reporting Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Reporting Code]
      ON
         [VAT Posting Setup].[Sale VAT Reporting Code] = [VAT Reporting Code].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [VAT Posting Setup].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [VAT Posting Setup].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in VAT Posting Setup table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1VAT Bus. Posting Group Primary Key SearchVAT Bus. Posting GroupNormalCode20VAT Bus_ Posting Groupnvarchar(40)
Key to join to the VAT Business Posting Group table.

Show/hide example query

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

Show/hide example query

SELECT
       [VAT Posting Setup].[VAT Prod_ Posting Group]
       ,[VAT Product Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$VAT Posting Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Posting Setup]
LEFT JOIN
       [CRONUS UK Ltd_$VAT Product Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Product Posting Group]
              ON
                     [VAT Posting Setup].[VAT Prod_ Posting Group] = [VAT Product Posting Group].[Code]
3VAT Calculation Type SearchVAT Calculation TypeNormalOption4VAT Calculation Typeint
Available options are:
  • “Normal VAT”
  • “Reverse Charge VAT”
  • “Full VAT”
  • “Sales Tax”
4VAT % SearchTax %NormalDecimal12VAT _decimal(38,38)
5Unrealized VAT Type SearchUnrealized Tax TypeNormalOption4Unrealized VAT Typeint
Available options are:
  • ” “
  • “Percentage”
  • “First”
  • “Last”
  • “First (Fully Paid)”
  • “Last (Fully Paid)”
  • “Cash Basis”
6Adjust for Payment Discount SearchAdjust for Payment DiscountNormalBoolean4Adjust for Payment Discounttinyint
7Sales VAT Account SearchSales Tax AccountNormalCode20Sales VAT Accountnvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
       [VAT Posting Setup].[Sales VAT Account]
       ,[G/L Account].[No_]
FROM
       [CRONUS UK Ltd_$VAT Posting Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Posting Setup]
LEFT JOIN
       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
              ON
                     [VAT Posting Setup].[Sales VAT Account] = [G/L Account].[No_]
8Sales VAT Unreal. Account SearchSales Tax Unreal. AccountNormalCode20Sales VAT Unreal_ Accountnvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
       [VAT Posting Setup].[Sales VAT Unreal_ Account]
       ,[G/L Account].[No_]
FROM
       [CRONUS UK Ltd_$VAT Posting Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Posting Setup]
LEFT JOIN
       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
              ON
                     [VAT Posting Setup].[Sales VAT Unreal_ Account] = [G/L Account].[No_]
9Purchase VAT Account SearchPurchase Tax AccountNormalCode20Purchase VAT Accountnvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
       [VAT Posting Setup].[Purchase VAT Account]
       ,[G/L Account].[No_]
FROM
       [CRONUS UK Ltd_$VAT Posting Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Posting Setup]
LEFT JOIN
       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
              ON
                     [VAT Posting Setup].[Purchase VAT Account] = [G/L Account].[No_]
10Purch. VAT Unreal. Account SearchPurch. Tax Unreal. AccountNormalCode20Purch_ VAT Unreal_ Accountnvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
       [VAT Posting Setup].[Purch_ VAT Unreal_ Account]
       ,[G/L Account].[No_]
FROM
       [CRONUS UK Ltd_$VAT Posting Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Posting Setup]
LEFT JOIN
       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
              ON
                     [VAT Posting Setup].[Purch_ VAT Unreal_ Account] = [G/L Account].[No_]
11Reverse Chrg. VAT Acc. SearchReverse Chrg. Tax Acc.NormalCode20Reverse Chrg_ VAT Acc_nvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
       [VAT Posting Setup].[Reverse Chrg_ VAT Acc_]
       ,[G/L Account].[No_]
FROM
       [CRONUS UK Ltd_$VAT Posting Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Posting Setup]
LEFT JOIN
       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
              ON
                     [VAT Posting Setup].[Reverse Chrg_ VAT Acc_] = [G/L Account].[No_]
12Reverse Chrg. VAT Unreal. Acc. SearchReverse Chrg. Tax Unreal. Acc.NormalCode20Reverse Chrg_ VAT Unreal_ Acc_nvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
       [VAT Posting Setup].[Reverse Chrg_ VAT Unreal_ Acc_]
       ,[G/L Account].[No_]
FROM
       [CRONUS UK Ltd_$VAT Posting Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Posting Setup]
LEFT JOIN
       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
              ON
                     [VAT Posting Setup].[Reverse Chrg_ VAT Unreal_ Acc_] = [G/L Account].[No_]
13VAT Identifier SearchTax IdentifierNormalCode20VAT Identifiernvarchar(40)
14EU Service SearchEU ServiceNormalBoolean4EU Servicetinyint
15VAT Clause Code SearchTax Clause CodeNormalCode20VAT Clause Codenvarchar(40)
Key to join to the VAT Clause table.

Show/hide example query

SELECT
       [VAT Posting Setup].[VAT Clause Code]
       ,[VAT Clause].[Code]
FROM
       [CRONUS UK Ltd_$VAT Posting Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Posting Setup]
LEFT JOIN
       [CRONUS UK Ltd_$VAT Clause$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Clause]
              ON
                     [VAT Posting Setup].[VAT Clause Code] = [VAT Clause].[Code]
16Certificate of Supply Required SearchCertificate of Supply RequiredNormalBoolean4Certificate of Supply Requiredtinyint
17Tax Category SearchTax CategoryNormalCode10Tax Categorynvarchar(20)
20Description SearchDescriptionNormalText100Descriptionnvarchar(200)
21Blocked SearchBlockedNormalBoolean4Blockedtinyint
25Sale VAT Reporting Code SearchSale Tax Reporting CodeNormalCode20Sale VAT Reporting Codenvarchar(40)
Key to join to the VAT Reporting Code table.

Show/hide example query

SELECT
       [VAT Posting Setup].[Sale VAT Reporting Code]
       ,[VAT Reporting Code].[Code]
FROM
       [CRONUS UK Ltd_$VAT Posting Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Posting Setup]
LEFT JOIN
       [CRONUS UK Ltd_$VAT Reporting Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Reporting Code]
              ON
                     [VAT Posting Setup].[Sale VAT Reporting Code] = [VAT Reporting Code].[Code]
26Purch. VAT Reporting Code SearchPurchase Tax Reporting CodeNormalCode20Purch_ VAT Reporting Codenvarchar(40)
Key to join to the VAT Reporting Code table.

Show/hide example query

SELECT
       [VAT Posting Setup].[Purch_ VAT Reporting Code]
       ,[VAT Reporting Code].[Code]
FROM
       [CRONUS UK Ltd_$VAT Posting Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Posting Setup]
LEFT JOIN
       [CRONUS UK Ltd_$VAT Reporting Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Reporting Code]
              ON
                     [VAT Posting Setup].[Purch_ VAT Reporting Code] = [VAT Reporting Code].[Code]
6200Non-Deductible VAT % SearchNon-Deductible Tax %NormalDecimal12Non-Deductible VAT _decimal(38,38)
6201Non-Ded. Sales VAT Account SearchNon-Deductible Sales Tax AccountNormalCode20
6202Non-Ded. Purchase VAT Account SearchNon-Deductible Purchase Tax AccountNormalCode20Non-Ded_ Purchase VAT Accountnvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
       [VAT Posting Setup].[Non-Ded_ Purchase VAT Account]
       ,[G/L Account].[No_]
FROM
       [CRONUS UK Ltd_$VAT Posting Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Posting Setup]
LEFT JOIN
       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
              ON
                     [VAT Posting Setup].[Non-Ded_ Purchase VAT Account] = [G/L Account].[No_]
6203Allow Non-Deductible VAT SearchAllow Non-Deductible TaxNormalOption4Allow Non-Deductible VATint
Available options are:
  • “Do Not Allow”
  • “Allow”
10001CFDI VAT Exemption SearchCFDI Tax ExemptionNormalBoolean4
10002CFDI Non-Taxable SearchCFDI Non-TaxableNormalBoolean4
10003CFDI Subject to Tax SearchCFDI Subject to TaxNormalCode10
27000DIOT WHT % SearchDIOT WHT PercentNormalDecimal12
27010DIOT-WHT % SearchDIOT WHT PercentNormalDecimal12
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 Posting Setup].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$VAT Posting Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Posting Setup]
LEFT JOIN
       [User] AS [User]
              ON
                     [VAT Posting 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 Posting Setup].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$VAT Posting Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Posting Setup]
LEFT JOIN
       [User] AS [User]
              ON
                     [VAT Posting Setup].[$systemModifiedBy] = [User].[User Security ID]

Leave a Reply

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