Intrastat Setup – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables IIntrastat 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 Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	Code	Code	Normal	Code	10	Code	nvarchar(20)
2	Report Receipts	Report Receipts	Normal	Boolean	4	Report Receipts	tinyint
3	Report Shipments	Report Shipments	Normal	Boolean	4	Report Shipments	tinyint
4	Default Trans. – Purchase	Default Trans. Type	Normal	Code	10	Default Trans_ – Purchase	nvarchar(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]
5	Default Trans. – Return	Default Trans. Type – Returns	Normal	Code	10	Default Trans_ – Return	nvarchar(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]
6	Intrastat Contact Type	Intrastat Contact Type	Normal	Option	4	Intrastat Contact Type	int
	Available options are: ” “ “Contact” “Vendor”
7	Intrastat Contact No.	Intrastat Contact No.	Normal	Code	20	Intrastat Contact No_	nvarchar(40)
8	Use Advanced Checklist	Use Advanced Checklist	Normal	Boolean	4	Use Advanced Checklist	tinyint
9	Cust. VAT No. on File	Customer Tax No. on File	Normal	Option	4	Cust_ VAT No_ on File	int
	Available options are: “VAT Reg. No.” “EU Country Code + VAT Reg. No” “VAT Reg. No. Without EU Country Code”
10	Vend. VAT No. on File	Vendor Tax No. on File	Normal	Option	4	Vend_ VAT No_ on File	int
	Available options are: “VAT Reg. No.” “EU Country Code + VAT Reg. No” “VAT Reg. No. Without EU Country Code”
11	Company VAT No. on File	Company Tax No. on File	Normal	Option	4	Company VAT No_ on File	int
	Available options are: “VAT Reg. No.” “EU Country Code + VAT Reg. No” “VAT Reg. No. Without EU Country Code”
12	Default Trans. Spec. Code	Default Trans. Spec. Code	Normal	Code	10	Default Trans_ Spec_ Code	nvarchar(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]
13	Default Trans. Spec. Ret. Code	Default Trans. Spec. Returns Code	Normal	Code	10	Default Trans_ Spec_ Ret_ Code	nvarchar(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	System ID	Normal	GUID	16	$systemId	uniqueidentifier
2000000001	SystemCreatedAt	Created At	Normal	DateTime	8	$systemCreatedAt	datetime
2000000002	SystemCreatedBy	Created By	Normal	GUID	16	$systemCreatedBy	uniqueidentifier
	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]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier

Dynamics 365 BC Table Reference Tables Company Tables IIntrastat Setup

Leave a Reply Cancel reply