Intrastat Setup

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

Table Type: Company

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

Table Number: 247

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [Code]
   ,[Report Receipts]
   ,[Report Shipments]
   ,[Default Trans_ - Purchase]
   ,[Default Trans_ - Return]
   ,[Intrastat Contact Type]
   ,[Intrastat Contact No_]
   ,[Use Advanced Checklist]
   ,[Cust_ VAT No_ on File]
   ,[Vend_ VAT No_ on File]
   ,[Company VAT No_ on File]
   ,[Default Trans_ Spec_ Code]
   ,[Default Trans_ Spec_ Ret_ Code]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Intrastat 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_$Intrastat Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Intrastat Setup]
LEFT JOIN
   [User] AS [User]
      ON
         [Intrastat Setup].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Intrastat Setup].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Intrastat Setup table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Code Primary Key SearchCodeNormalCode10Codenvarchar(20)
2Report Receipts SearchReport ReceiptsNormalBoolean4Report Receiptstinyint
3Report Shipments SearchReport ShipmentsNormalBoolean4Report Shipmentstinyint
4Default Trans. – Purchase SearchDefault Trans. TypeNormalCode10Default Trans_ – Purchasenvarchar(20)
Key to join to the Transaction Type table.

Show/hide example query

SELECT
       [Intrastat Setup].[Default Trans_ - Purchase]
       ,[Transaction Type].[Code]
FROM
       [CRONUS UK Ltd_$Intrastat Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Intrastat Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Transaction Type$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transaction Type]
              ON
                     [Intrastat Setup].[Default Trans_ - Purchase] = [Transaction Type].[Code]
5Default Trans. – Return SearchDefault Trans. Type – ReturnsNormalCode10Default Trans_ – Returnnvarchar(20)
Key to join to the Transaction Type table.

Show/hide example query

SELECT
       [Intrastat Setup].[Default Trans_ - Return]
       ,[Transaction Type].[Code]
FROM
       [CRONUS UK Ltd_$Intrastat Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Intrastat Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Transaction Type$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transaction Type]
              ON
                     [Intrastat Setup].[Default Trans_ - Return] = [Transaction Type].[Code]
6Intrastat Contact Type SearchIntrastat Contact TypeNormalOption4Intrastat Contact Typeint
Available options are:
  • ” “
  • “Contact”
  • “Vendor”
7Intrastat Contact No. SearchIntrastat Contact No.NormalCode20Intrastat Contact No_nvarchar(40)
8Use Advanced Checklist SearchUse Advanced ChecklistNormalBoolean4Use Advanced Checklisttinyint
9Cust. VAT No. on File SearchCustomer Tax No. on FileNormalOption4Cust_ VAT No_ on Fileint
Available options are:
  • “VAT Reg. No.”
  • “EU Country Code + VAT Reg. No”
  • “VAT Reg. No. Without EU Country Code”
10Vend. VAT No. on File SearchVendor Tax No. on FileNormalOption4Vend_ VAT No_ on Fileint
Available options are:
  • “VAT Reg. No.”
  • “EU Country Code + VAT Reg. No”
  • “VAT Reg. No. Without EU Country Code”
11Company VAT No. on File SearchCompany Tax No. on FileNormalOption4Company VAT No_ on Fileint
Available options are:
  • “VAT Reg. No.”
  • “EU Country Code + VAT Reg. No”
  • “VAT Reg. No. Without EU Country Code”
12Default Trans. Spec. Code SearchDefault Trans. Spec. CodeNormalCode10Default Trans_ Spec_ Codenvarchar(20)
Key to join to the Transaction Specification table.

Show/hide example query

SELECT
       [Intrastat Setup].[Default Trans_ Spec_ Code]
       ,[Transaction Specification].[Code]
FROM
       [CRONUS UK Ltd_$Intrastat Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Intrastat Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Transaction Specification$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transaction Specification]
              ON
                     [Intrastat Setup].[Default Trans_ Spec_ Code] = [Transaction Specification].[Code]
13Default Trans. Spec. Ret. Code SearchDefault Trans. Spec. Returns CodeNormalCode10Default Trans_ Spec_ Ret_ Codenvarchar(20)
Key to join to the Transaction Specification table.

Show/hide example query

SELECT
       [Intrastat Setup].[Default Trans_ Spec_ Ret_ Code]
       ,[Transaction Specification].[Code]
FROM
       [CRONUS UK Ltd_$Intrastat Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Intrastat Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Transaction Specification$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transaction Specification]
              ON
                     [Intrastat Setup].[Default Trans_ Spec_ Ret_ Code] = [Transaction Specification].[Code]
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
       [Intrastat Setup].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Intrastat Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Intrastat Setup]
LEFT JOIN
       [User] AS [User]
              ON
                     [Intrastat 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
       [Intrastat Setup].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Intrastat Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Intrastat Setup]
LEFT JOIN
       [User] AS [User]
              ON
                     [Intrastat Setup].[$systemModifiedBy] = [User].[User Security ID]

Leave a Reply

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