Intrastat 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
   [timestamp]
   ,[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]
   ,[Shipment Method Code]
   ,[$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_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country_Region]
      ON
         [Intrastat Jnl_ Line].[Country_Region Code] = [Country_Region].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Item$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
      ON
         [Intrastat Jnl_ Line].[Item No_] = [Item].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country_Region]
      ON
         [Intrastat Jnl_ Line].[Country_Region of Origin Code] = [Country_Region].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Intrastat Jnl_ Line].[Location Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Shipment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipment Method]
      ON
         [Intrastat Jnl_ Line].[Shipment Method Code] = [Shipment Method].[Code]

Show/hide columns in Intrastat Jnl_ Line table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Journal Template Name Primary Key Searchnvarchar(20)
3Journal Batch Name Primary Key Searchnvarchar(20)
4Line No_ Primary Key Searchint
5Type Searchint
6Date Searchdatetime
7Tariff No_ Searchnvarchar(40)
8Item Description Searchnvarchar(200)
9Country_Region Code Searchnvarchar(20)
Key to join to the Country_Region table.

Show/hide example query

SELECT
       [Intrastat Jnl_ Line].[Country_Region Code]
       ,[Country_Region].[Code]
FROM
       [CRONUS UK Ltd_$Intrastat Jnl_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Intrastat Jnl_ Line]
LEFT JOIN
       [CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country_Region]
              ON
                     [Intrastat Jnl_ Line].[Country_Region Code] = [Country_Region].[Code]
10Transaction Type Searchnvarchar(20)
11Transport Method Searchnvarchar(20)
12Source Type Searchint
13Source Entry No_ Searchint
14Net Weight Searchdecimal(38,38)
15Amount Searchdecimal(38,38)
16Quantity Searchdecimal(38,38)
17Cost Regulation _ Searchdecimal(38,38)
18Indirect Cost Searchdecimal(38,38)
19Statistical Value Searchdecimal(38,38)
20Document No_ Searchnvarchar(40)
21Item No_ Searchnvarchar(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$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
              ON
                     [Intrastat Jnl_ Line].[Item No_] = [Item].[No_]
22Name Searchnvarchar(200)
23Total Weight Searchdecimal(38,38)
24Supplementary Units Searchtinyint
25Internal Ref_ No_ Searchnvarchar(20)
26Country_Region of Origin Code Searchnvarchar(20)
Key to join to the Country_Region table.

Show/hide example query

SELECT
       [Intrastat Jnl_ Line].[Country_Region of Origin Code]
       ,[Country_Region].[Code]
FROM
       [CRONUS UK Ltd_$Intrastat Jnl_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Intrastat Jnl_ Line]
LEFT JOIN
       [CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country_Region]
              ON
                     [Intrastat Jnl_ Line].[Country_Region of Origin Code] = [Country_Region].[Code]
27Entry_Exit Point Searchnvarchar(20)
28Area Searchnvarchar(20)
29Transaction Specification Searchnvarchar(20)
30Shpt_ Method Code Searchnvarchar(20)
31Partner VAT ID Searchnvarchar(100)
32Location Code Searchnvarchar(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]
33Counterparty Searchtinyint
34Shipment Method Code Searchnvarchar(20)
Key to join to the Shipment Method table.

Show/hide example query

SELECT
       [Intrastat Jnl_ Line].[Shipment 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].[Shipment Method Code] = [Shipment Method].[Code]
35$systemId Searchuniqueidentifier
36$systemCreatedAt Searchdatetime
37$systemCreatedBy Searchuniqueidentifier
38$systemModifiedAt Searchdatetime
39$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Intrastat Jnl_ Line table

Leave a Reply

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