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: 0

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
   [timestamp]
   ,[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]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$VAT Posting Setup$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in VAT Posting Setup table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2VAT Bus_ Posting Group Primary Key Searchnvarchar(40)
3VAT Prod_ Posting Group Primary Key Searchnvarchar(40)
4VAT Calculation Type Searchint
5VAT _ Searchdecimal(38,38)
6Unrealized VAT Type Searchint
7Adjust for Payment Discount Searchtinyint
8Sales VAT Account Searchnvarchar(40)
9Sales VAT Unreal_ Account Searchnvarchar(40)
10Purchase VAT Account Searchnvarchar(40)
11Purch_ VAT Unreal_ Account Searchnvarchar(40)
12Reverse Chrg_ VAT Acc_ Searchnvarchar(40)
13Reverse Chrg_ VAT Unreal_ Acc_ Searchnvarchar(40)
14VAT Identifier Searchnvarchar(40)
15EU Service Searchtinyint
16VAT Clause Code Searchnvarchar(40)
17Certificate of Supply Required Searchtinyint
18Tax Category Searchnvarchar(20)
19Description Searchnvarchar(200)
20Blocked Searchtinyint
21$systemId Searchuniqueidentifier
22$systemCreatedAt Searchdatetime
23$systemCreatedBy Searchuniqueidentifier
24$systemModifiedAt Searchdatetime
25$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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