Intrastat Jnl. Line – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables IIntrastat Jnl. Line

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

Table Type: Company

Table Name: Intrastat Jnl. Line
Database Table Name: CRONUS UK Ltd_$Intrastat Jnl_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 263

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 Jnl. Line can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Intrastat Jnl_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT

   [Journal Template Name]
   ,[Journal Batch Name]
   ,[Line No_]
   ,[Type]
   ,[Date]
   ,[Tariff No_]
   ,[Item Description]
   ,[Country_Region Code]
   ,[Transaction Type]
   ,[Transport Method]
   ,[Source Type]
   ,[Source Entry No_]
   ,[Net Weight]
   ,[Amount]
   ,[Quantity]
   ,[Cost Regulation _]
   ,[Indirect Cost]
   ,[Statistical Value]
   ,[Document No_]
   ,[Item No_]
   ,[Name]
   ,[Total Weight]
   ,[Supplementary Units]
   ,[Internal Ref_ No_]
   ,[Country_Region of Origin Code]
   ,[Entry_Exit Point]
   ,[Area]
   ,[Transaction Specification]
   ,[Shpt_ Method Code]
   ,[Partner VAT ID]
   ,[Location Code]
   ,[Counterparty]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Intrastat Jnl_ Line$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 Jnl_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Intrastat Jnl. Line]
LEFT JOIN
   [CRONUS UK Ltd_$Transaction Type$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transaction Type]
      ON
         [Intrastat Jnl. Line].[Transaction Type] = [Transaction Type].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Transport Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transport Method]
      ON
         [Intrastat Jnl. Line].[Transport Method] = [Transport Method].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Area]
      ON
         [Intrastat Jnl. Line].[Area] = [Area].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Transaction Specification$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transaction Specification]
      ON
         [Intrastat Jnl. Line].[Transaction Specification] = [Transaction Specification].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Intrastat Jnl. Line].[Location Code] = [Location].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Intrastat Jnl. Line].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Intrastat Jnl. Line].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Intrastat Jnl. Line table

Field No.	Field Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	Journal Template Name	Journal Template Name	Normal	Code	10	Journal Template Name	nvarchar(20)
2	Journal Batch Name	Journal Batch Name	Normal	Code	10	Journal Batch Name	nvarchar(20)
3	Line No.	Line No.	Normal	Integer	4	Line No_	int
4	Type	Type	Normal	Option	4	Type	int
	Available options are: “Receipt” “Shipment”
5	Date	Date	Normal	Date	4	Date	datetime
6	Tariff No.	Tariff No.	Normal	Code	20	Tariff No_	nvarchar(40)
	Key to join to the Tariff Number table. Show/hide example query SELECT [Intrastat Jnl. Line].[Tariff No_] ,[Tariff Number].[No_] FROM [CRONUS UK Ltd_$Intrastat Jnl_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Intrastat Jnl. Line] LEFT JOIN [CRONUS UK Ltd_$Tariff Number$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tariff Number] ON [Intrastat Jnl. Line].[Tariff No_] = [Tariff Number].[No_]
7	Item Description	Item Description	Normal	Text	100	Item Description	nvarchar(200)
8	Country/Region Code	Country/Region Code	Normal	Code	10	Country_Region Code	nvarchar(20)
9	Transaction Type	Transaction Type	Normal	Code	10	Transaction Type	nvarchar(20)
	Key to join to the Transaction Type table. Show/hide example query SELECT [Intrastat Jnl. Line].[Transaction Type] ,[Transaction Type].[Code] FROM [CRONUS UK Ltd_$Intrastat Jnl_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Intrastat Jnl. Line] LEFT JOIN [CRONUS UK Ltd_$Transaction Type$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transaction Type] ON [Intrastat Jnl. Line].[Transaction Type] = [Transaction Type].[Code]
10	Transport Method	Transport Method	Normal	Code	10	Transport Method	nvarchar(20)
	Key to join to the Transport Method table. Show/hide example query SELECT [Intrastat Jnl. Line].[Transport Method] ,[Transport Method].[Code] FROM [CRONUS UK Ltd_$Intrastat Jnl_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Intrastat Jnl. Line] LEFT JOIN [CRONUS UK Ltd_$Transport Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transport Method] ON [Intrastat Jnl. Line].[Transport Method] = [Transport Method].[Code]
11	Source Type	Source Type	Normal	Option	4	Source Type	int
	Available options are: “” “Item Entry” “Job Entry”
12	Source Entry No.	Source Entry No.	Normal	Integer	4	Source Entry No_	int
13	Net Weight	Net Weight	Normal	Decimal	12	Net Weight	decimal(38,38)
14	Amount	Amount	Normal	Decimal	12	Amount	decimal(38,38)
15	Quantity	Quantity	Normal	Decimal	12	Quantity	decimal(38,38)
16	Cost Regulation %	Cost Regulation %	Normal	Decimal	12	Cost Regulation _	decimal(38,38)
17	Indirect Cost	Indirect Cost	Normal	Decimal	12	Indirect Cost	decimal(38,38)
18	Statistical Value	Statistical Value	Normal	Decimal	12	Statistical Value	decimal(38,38)
19	Document No.	Document No.	Normal	Code	20	Document No_	nvarchar(40)
20	Item No.	Item No.	Normal	Code	20	Item No_	nvarchar(40)
	Key to join to the Item table. Show/hide example query SELECT [Intrastat Jnl. Line].[Item No_] ,[Item].[No_] FROM [CRONUS UK Ltd_$Intrastat Jnl_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Intrastat Jnl. Line] LEFT JOIN [CRONUS UK Ltd_$Item$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item] ON [Intrastat Jnl. Line].[Item No_] = [Item].[No_]
21	Name	Name	Normal	Text	100	Name	nvarchar(200)
22	Total Weight	Total Weight	Normal	Decimal	12	Total Weight	decimal(38,38)
23	Supplementary Units	Supplementary Units	Normal	Boolean	4	Supplementary Units	tinyint
24	Internal Ref. No.	Internal Ref. No.	Normal	Text	10	Internal Ref_ No_	nvarchar(20)
25	Country/Region of Origin Code	Country/Region of Origin Code	Normal	Code	10	Country_Region of Origin Code	nvarchar(20)
26	Entry/Exit Point	Entry/Exit Point	Normal	Code	10	Entry_Exit Point	nvarchar(20)
27	Area	Area	Normal	Code	10	Area	nvarchar(20)
	Key to join to the Area table. Show/hide example query SELECT [Intrastat Jnl. Line].[Area] ,[Area].[Code] FROM [CRONUS UK Ltd_$Intrastat Jnl_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Intrastat Jnl. Line] LEFT JOIN [CRONUS UK Ltd_$Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Area] ON [Intrastat Jnl. Line].[Area] = [Area].[Code]
28	Transaction Specification	Transaction Specification	Normal	Code	10	Transaction Specification	nvarchar(20)
	Key to join to the Transaction Specification table. Show/hide example query SELECT [Intrastat Jnl. Line].[Transaction Specification] ,[Transaction Specification].[Code] FROM [CRONUS UK Ltd_$Intrastat Jnl_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Intrastat Jnl. Line] LEFT JOIN [CRONUS UK Ltd_$Transaction Specification$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transaction Specification] ON [Intrastat Jnl. Line].[Transaction Specification] = [Transaction Specification].[Code]
29	Shpt. Method Code	Shpt. Method Code	Normal	Code	10	Shpt_ Method Code	nvarchar(20)
	Key to join to the Shipment Method table. Show/hide example query SELECT [Intrastat Jnl. Line].[Shpt_ Method Code] ,[Shipment Method].[Code] FROM [CRONUS UK Ltd_$Intrastat Jnl_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Intrastat Jnl. Line] LEFT JOIN [CRONUS UK Ltd_$Shipment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipment Method] ON [Intrastat Jnl. Line].[Shpt_ Method Code] = [Shipment Method].[Code]
30	Partner VAT ID	Partner Tax ID	Normal	Text	50	Partner VAT ID	nvarchar(100)
31	Location Code	Location Code	Normal	Code	10	Location Code	nvarchar(20)
	Key to join to the Location table. Show/hide example query SELECT [Intrastat Jnl. Line].[Location Code] ,[Location].[Code] FROM [CRONUS UK Ltd_$Intrastat Jnl_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Intrastat Jnl. Line] LEFT JOIN [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location] ON [Intrastat Jnl. Line].[Location Code] = [Location].[Code]
32	Counterparty	Counterparty	Normal	Boolean	4	Counterparty	tinyint
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 Jnl. Line].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$Intrastat Jnl_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Intrastat Jnl. Line] LEFT JOIN [User] AS [User] ON [Intrastat Jnl. Line].[$systemCreatedBy] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier

Show/hide tables related from Intrastat Jnl. Line table

Dynamics 365 BC Table Reference Tables Company Tables IIntrastat Jnl. Line

Leave a Reply Cancel reply