Direct Trans. Header

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

Table Type: Company

Table Name: Direct Trans. Header
Database Table Name: CRONUS UK Ltd_$Direct Trans_ Header$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 5856

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 Direct Trans. Header can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Direct Trans_ Header$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [No_]
   ,[Transfer-from Code]
   ,[Transfer-from Name]
   ,[Transfer-from Name 2]
   ,[Transfer-from Address]
   ,[Transfer-from Address 2]
   ,[Transfer-from Post Code]
   ,[Transfer-from City]
   ,[Transfer-from County]
   ,[Trsf_-from Country_Region Code]
   ,[Transfer-to Code]
   ,[Transfer-to Name]
   ,[Transfer-to Name 2]
   ,[Transfer-to Address]
   ,[Transfer-to Address 2]
   ,[Transfer-to Post Code]
   ,[Transfer-to City]
   ,[Transfer-to County]
   ,[Trsf_-to Country_Region Code]
   ,[Transfer Order Date]
   ,[Posting Date]
   ,[Shortcut Dimension 1 Code]
   ,[Shortcut Dimension 2 Code]
   ,[Transfer Order No_]
   ,[No_ Series]
   ,[Transfer-from Contact]
   ,[Transfer-to Contact]
   ,[External Document No_]
   ,[Dimension Set ID]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Direct Trans_ Header$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns including those from all joined tables

SELECT
   *
FROM
   [CRONUS UK Ltd_$Direct Trans_ Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Direct Trans. Header]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Direct Trans. Header].[Transfer-from Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Direct Trans. Header].[Transfer-from Post Code] = [Post Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Direct Trans. Header].[Transfer-from City] = [Post Code].[City]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Direct Trans. Header].[Transfer-to Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Direct Trans. Header].[Transfer-to Post Code] = [Post Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Direct Trans. Header].[Transfer-to City] = [Post Code].[City]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Direct Trans. Header].[Shortcut Dimension 1 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Direct Trans. Header].[Shortcut Dimension 2 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
      ON
         [Direct Trans. Header].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Direct Trans. Header].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Direct Trans. Header].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Direct Trans. Header table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1No. Primary Key SearchNo.NormalCode20No_nvarchar(40)
2Transfer-from Code SearchTransfer-from CodeNormalCode10Transfer-from Codenvarchar(20)
Key to join to the Location table.

Show/hide example query

SELECT
       [Direct Trans. Header].[Transfer-from Code]
       ,[Location].[Code]
FROM
       [CRONUS UK Ltd_$Direct Trans_ Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Direct Trans. Header]
LEFT JOIN
       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
              ON
                     [Direct Trans. Header].[Transfer-from Code] = [Location].[Code]
3Transfer-from Name SearchTransfer-from NameNormalText100Transfer-from Namenvarchar(200)
4Transfer-from Name 2 SearchTransfer-from Name 2NormalText50Transfer-from Name 2nvarchar(100)
5Transfer-from Address SearchTransfer-from AddressNormalText100Transfer-from Addressnvarchar(200)
6Transfer-from Address 2 SearchTransfer-from Address 2NormalText50Transfer-from Address 2nvarchar(100)
7Transfer-from Post Code SearchTransfer-from ZIP CodeNormalCode20Transfer-from Post Codenvarchar(40)
Key to join to the Post Code table.

Show/hide example query

SELECT
       [Direct Trans. Header].[Transfer-from Post Code]
       ,[Post Code].[Code]
FROM
       [CRONUS UK Ltd_$Direct Trans_ Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Direct Trans. Header]
LEFT JOIN
       [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
              ON
                     [Direct Trans. Header].[Transfer-from Post Code] = [Post Code].[Code]
8Transfer-from City SearchTransfer-from CityNormalText30Transfer-from Citynvarchar(60)
Key to join to the Post Code table.

Show/hide example query

SELECT
       [Direct Trans. Header].[Transfer-from City]
       ,[Post Code].[City]
FROM
       [CRONUS UK Ltd_$Direct Trans_ Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Direct Trans. Header]
LEFT JOIN
       [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
              ON
                     [Direct Trans. Header].[Transfer-from City] = [Post Code].[City]
9Transfer-from County SearchTransfer-from StateNormalText30Transfer-from Countynvarchar(60)
10Trsf.-from Country/Region Code SearchTrsf.-from Country/Region CodeNormalCode10Trsf_-from Country_Region Codenvarchar(20)
Key to join to the Country/Region table.

Show/hide example query

SELECT
       [Direct Trans. Header].[Trsf_-from Country_Region Code]
       ,[Country/Region].[Code]
FROM
       [CRONUS UK Ltd_$Direct Trans_ Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Direct Trans. Header]
LEFT JOIN
       [CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country/Region]
              ON
                     [Direct Trans. Header].[Trsf_-from Country_Region Code] = [Country/Region].[Code]
11Transfer-to Code SearchTransfer-to CodeNormalCode10Transfer-to Codenvarchar(20)
Key to join to the Location table.

Show/hide example query

SELECT
       [Direct Trans. Header].[Transfer-to Code]
       ,[Location].[Code]
FROM
       [CRONUS UK Ltd_$Direct Trans_ Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Direct Trans. Header]
LEFT JOIN
       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
              ON
                     [Direct Trans. Header].[Transfer-to Code] = [Location].[Code]
12Transfer-to Name SearchTransfer-to NameNormalText100Transfer-to Namenvarchar(200)
13Transfer-to Name 2 SearchTransfer-to Name 2NormalText50Transfer-to Name 2nvarchar(100)
14Transfer-to Address SearchTransfer-to AddressNormalText100Transfer-to Addressnvarchar(200)
15Transfer-to Address 2 SearchTransfer-to Address 2NormalText50Transfer-to Address 2nvarchar(100)
16Transfer-to Post Code SearchTransfer-to ZIP CodeNormalCode20Transfer-to Post Codenvarchar(40)
Key to join to the Post Code table.

Show/hide example query

SELECT
       [Direct Trans. Header].[Transfer-to Post Code]
       ,[Post Code].[Code]
FROM
       [CRONUS UK Ltd_$Direct Trans_ Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Direct Trans. Header]
LEFT JOIN
       [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
              ON
                     [Direct Trans. Header].[Transfer-to Post Code] = [Post Code].[Code]
17Transfer-to City SearchTransfer-to CityNormalText30Transfer-to Citynvarchar(60)
Key to join to the Post Code table.

Show/hide example query

SELECT
       [Direct Trans. Header].[Transfer-to City]
       ,[Post Code].[City]
FROM
       [CRONUS UK Ltd_$Direct Trans_ Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Direct Trans. Header]
LEFT JOIN
       [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
              ON
                     [Direct Trans. Header].[Transfer-to City] = [Post Code].[City]
18Transfer-to County SearchTransfer-to StateNormalText30Transfer-to Countynvarchar(60)
19Trsf.-to Country/Region Code SearchTrsf.-to Country/Region CodeNormalCode10Trsf_-to Country_Region Codenvarchar(20)
Key to join to the Country/Region table.

Show/hide example query

SELECT
       [Direct Trans. Header].[Trsf_-to Country_Region Code]
       ,[Country/Region].[Code]
FROM
       [CRONUS UK Ltd_$Direct Trans_ Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Direct Trans. Header]
LEFT JOIN
       [CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country/Region]
              ON
                     [Direct Trans. Header].[Trsf_-to Country_Region Code] = [Country/Region].[Code]
20Transfer Order Date SearchTransfer Order DateNormalDate4Transfer Order Datedatetime
21Posting Date SearchPosting DateNormalDate4Posting Datedatetime
22Comment SearchCommentFlowFieldBoolean4
23Shortcut Dimension 1 Code SearchShortcut Dimension 1 CodeNormalCode20Shortcut Dimension 1 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
       [Direct Trans. Header].[Shortcut Dimension 1 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$Direct Trans_ Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Direct Trans. Header]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [Direct Trans. Header].[Shortcut Dimension 1 Code] = [Dimension].[Code]
24Shortcut Dimension 2 Code SearchShortcut Dimension 2 CodeNormalCode20Shortcut Dimension 2 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
       [Direct Trans. Header].[Shortcut Dimension 2 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$Direct Trans_ Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Direct Trans. Header]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [Direct Trans. Header].[Shortcut Dimension 2 Code] = [Dimension].[Code]
25Transfer Order No. SearchTransfer Order No.NormalCode20Transfer Order No_nvarchar(40)
Key to join to the Transfer Header table.

Show/hide example query

SELECT
       [Direct Trans. Header].[Transfer Order No_]
       ,[Transfer Header].[No_]
FROM
       [CRONUS UK Ltd_$Direct Trans_ Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Direct Trans. Header]
LEFT JOIN
       [CRONUS UK Ltd_$Transfer Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transfer Header]
              ON
                     [Direct Trans. Header].[Transfer Order No_] = [Transfer Header].[No_]
26No. Series SearchNo. SeriesNormalCode20No_ Seriesnvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Direct Trans. Header].[No_ Series]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Direct Trans_ Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Direct Trans. Header]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Direct Trans. Header].[No_ Series] = [No. Series].[Code]
30Transfer-from Contact SearchTransfer-from ContactNormalText100Transfer-from Contactnvarchar(200)
31Transfer-to Contact SearchTransfer-to ContactNormalText100Transfer-to Contactnvarchar(200)
32External Document No. SearchExternal Document No.NormalCode35External Document No_nvarchar(70)
480Dimension Set ID SearchDimension Set IDNormalInteger4Dimension Set IDint
Key to join to the Dimension Set Entry table.

Show/hide example query

SELECT
       [Direct Trans. Header].[Dimension Set ID]
       ,[Dimension Set Entry].[Dimension Set ID]
FROM
       [CRONUS UK Ltd_$Direct Trans_ Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Direct Trans. Header]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
              ON
                     [Direct Trans. Header].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
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
       [Direct Trans. Header].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Direct Trans_ Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Direct Trans. Header]
LEFT JOIN
       [User] AS [User]
              ON
                     [Direct Trans. Header].[$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
       [Direct Trans. Header].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Direct Trans_ Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Direct Trans. Header]
LEFT JOIN
       [User] AS [User]
              ON
                     [Direct Trans. Header].[$systemModifiedBy] = [User].[User Security ID]

Leave a Reply

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