Intrastat Jnl. Line

Dynamics 365 BC Table ReferenceTablesCompany TablesIIntrastat 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 NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Journal Template Name Primary Key SearchJournal Template NameNormalCode10Journal Template Namenvarchar(20)
2Journal Batch Name Primary Key SearchJournal Batch NameNormalCode10Journal Batch Namenvarchar(20)
3Line No. Primary Key SearchLine No.NormalInteger4Line No_int
4Type SearchTypeNormalOption4Typeint
Available options are:
  • “Receipt”
  • “Shipment”
5Date SearchDateNormalDate4Datedatetime
6Tariff No. SearchTariff No.NormalCode20Tariff 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_]
7Item Description SearchItem DescriptionNormalText100Item Descriptionnvarchar(200)
8Country/Region Code SearchCountry/Region CodeNormalCode10Country_Region Codenvarchar(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]
9Transaction Type SearchTransaction TypeNormalCode10Transaction Typenvarchar(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]
10Transport Method SearchTransport MethodNormalCode10Transport Methodnvarchar(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]
11Source Type SearchSource TypeNormalOption4Source Typeint
Available options are:
  • “”
  • “Item Entry”
  • “Job Entry”
12Source Entry No. SearchSource Entry No.NormalInteger4Source Entry No_int
13Net Weight SearchNet WeightNormalDecimal12Net Weightdecimal(38,38)
14Amount SearchAmountNormalDecimal12Amountdecimal(38,38)
15Quantity SearchQuantityNormalDecimal12Quantitydecimal(38,38)
16Cost Regulation % SearchCost Regulation %NormalDecimal12Cost Regulation _decimal(38,38)
17Indirect Cost SearchIndirect CostNormalDecimal12Indirect Costdecimal(38,38)
18Statistical Value SearchStatistical ValueNormalDecimal12Statistical Valuedecimal(38,38)
19Document No. SearchDocument No.NormalCode20Document No_nvarchar(40)
20Item No. SearchItem No.NormalCode20Item 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_]
21Name SearchNameNormalText100Namenvarchar(200)
22Total Weight SearchTotal WeightNormalDecimal12Total Weightdecimal(38,38)
23Supplementary Units SearchSupplementary UnitsNormalBoolean4Supplementary Unitstinyint
24Internal Ref. No. SearchInternal Ref. No.NormalText10Internal Ref_ No_nvarchar(20)
25Country/Region of Origin Code SearchCountry/Region of Origin CodeNormalCode10Country_Region of Origin Codenvarchar(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]
26Entry/Exit Point SearchEntry/Exit PointNormalCode10Entry_Exit Pointnvarchar(20)
Key to join to the Entry/Exit Point table.

Show/hide example query

SELECT
       [Intrastat Jnl. Line].[Entry_Exit Point]
       ,[Entry/Exit Point].[Code]
FROM
       [CRONUS UK Ltd_$Intrastat Jnl_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Intrastat Jnl. Line]
LEFT JOIN
       [CRONUS UK Ltd_$Entry_Exit Point$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Entry/Exit Point]
              ON
                     [Intrastat Jnl. Line].[Entry_Exit Point] = [Entry/Exit Point].[Code]
27Area SearchAreaNormalCode10Areanvarchar(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]
28Transaction Specification SearchTransaction SpecificationNormalCode10Transaction Specificationnvarchar(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]
29Shpt. Method Code SearchShpt. Method CodeNormalCode10Shpt_ Method Codenvarchar(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]
30Partner VAT ID SearchPartner Tax IDNormalText50Partner VAT IDnvarchar(100)
31Location Code SearchLocation CodeNormalCode10Location Codenvarchar(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]
32Counterparty SearchCounterpartyNormalBoolean4Counterpartytinyint
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 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]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Intrastat Jnl. Line].[$systemModifiedBy]
       ,[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].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from Intrastat Jnl. Line table

Location
Dynamics 365 BC Table ReferenceTablesCompany TablesIIntrastat Jnl. Line

Leave a Reply

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