VAT Return Period

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

Table Type: Company

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

Table Number: 737

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[No_]
   ,[No_ Series]
   ,[Period Key]
   ,[Start Date]
   ,[End Date]
   ,[Due Date]
   ,[Status]
   ,[Received Date]
   ,[VAT Return No_]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$VAT Return Period$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in VAT Return Period table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2No_ Primary Key Searchnvarchar(40)
3No_ Series Searchnvarchar(40)
4Period Key Searchnvarchar(20)
5Start Date Searchdatetime
6End Date Searchdatetime
7Due Date Searchdatetime
8Status Searchint
9Received Date Searchdatetime
10VAT Return No_ Searchnvarchar(40)
11$systemId Searchuniqueidentifier
12$systemCreatedAt Searchdatetime
13$systemCreatedBy Searchuniqueidentifier
14$systemModifiedAt Searchdatetime
15$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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