MTD Return Details

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

Table Type: Company

Table Name: MTD Return Details
Database Table Name: CRONUS UK Ltd_$MTD Return Details$38fa97fa-ebd1-4862-af24-77c4cee2c6ca

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 MTD Return Details can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$MTD Return Details$38fa97fa-ebd1-4862-af24-77c4cee2c6ca]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Start Date]
   ,[End Date]
   ,[Period Key]
   ,[VAT Due Sales]
   ,[VAT Due Acquisitions]
   ,[Total VAT Due]
   ,[VAT Reclaimed Curr Period]
   ,[Net VAT Due]
   ,[Total Value Sales Excl_ VAT]
   ,[Total Value Purchases Excl_VAT]
   ,[Total Value Goods Suppl_ ExVAT]
   ,[Total Acquisitions Excl_ VAT]
   ,[Finalised]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$MTD Return Details$38fa97fa-ebd1-4862-af24-77c4cee2c6ca]

Show/hide columns in MTD Return Details table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Start Date Primary Key Searchdatetime
3End Date Primary Key Searchdatetime
4Period Key Searchnvarchar(20)
5VAT Due Sales Searchdecimal(38,38)
6VAT Due Acquisitions Searchdecimal(38,38)
7Total VAT Due Searchdecimal(38,38)
8VAT Reclaimed Curr Period Searchdecimal(38,38)
9Net VAT Due Searchdecimal(38,38)
10Total Value Sales Excl_ VAT Searchdecimal(38,38)
11Total Value Purchases Excl_VAT Searchdecimal(38,38)
12Total Value Goods Suppl_ ExVAT Searchdecimal(38,38)
13Total Acquisitions Excl_ VAT Searchdecimal(38,38)
14Finalised Searchtinyint
15$systemId Searchuniqueidentifier
16$systemCreatedAt Searchdatetime
17$systemCreatedBy Searchuniqueidentifier
18$systemModifiedAt Searchdatetime
19$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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