Transfer Route

Dynamics 365 BC Table ReferenceTablesCompany TablesTTransfer Route

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

Table Type: Company

Table Name: Transfer Route
Database Table Name: CRONUS UK Ltd_$Transfer Route$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 5742

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 Transfer Route can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Transfer Route$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT

   [Transfer-from Code]
   ,[Transfer-to Code]
   ,[In-Transit Code]
   ,[Shipping Agent Code]
   ,[Shipping Agent Service Code]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Transfer Route$437dbf0e-84ff-417a-965d-ed2bb9650972]

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$Transfer Route$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transfer Route]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Transfer Route].[Transfer-from Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Transfer Route].[Transfer-to Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Shipping Agent$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Shipping Agent]
      ON
         [Transfer Route].[Shipping Agent Code] = [Shipping Agent].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Transfer Route].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Transfer Route].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Transfer Route table

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

Show/hide example query

SELECT
	       [Transfer Route].[Transfer-from Code]
	       ,[Location].[Code]
	FROM
	       [CRONUS UK Ltd_$Transfer Route$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transfer Route]
	LEFT JOIN
	       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
	              ON
	                     [Transfer Route].[Transfer-from Code] = [Location].[Code]
2Transfer-to Code Primary Key SearchTransfer-to CodeNormalCode10Transfer-to Codenvarchar(20)
Key to join to the Location table.

Show/hide example query

SELECT
	       [Transfer Route].[Transfer-to Code]
	       ,[Location].[Code]
	FROM
	       [CRONUS UK Ltd_$Transfer Route$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transfer Route]
	LEFT JOIN
	       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
	              ON
	                     [Transfer Route].[Transfer-to Code] = [Location].[Code]
4In-Transit Code Primary Key SearchIn-Transit CodeNormalCode10In-Transit Codenvarchar(20)
5Shipping Agent Code SearchShipping Agent CodeNormalCode10Shipping Agent Codenvarchar(20)
Key to join to the Shipping Agent table.

Show/hide example query

SELECT
	       [Transfer Route].[Shipping Agent Code]
	       ,[Shipping Agent].[Code]
	FROM
	       [CRONUS UK Ltd_$Transfer Route$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transfer Route]
	LEFT JOIN
	       [CRONUS UK Ltd_$Shipping Agent$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Shipping Agent]
	              ON
	                     [Transfer Route].[Shipping Agent Code] = [Shipping Agent].[Code]
6Shipping Agent Service Code SearchShipping Agent Service CodeNormalCode10Shipping Agent Service Codenvarchar(20)
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
	       [Transfer Route].[$systemCreatedBy]
	       ,[User].[User Security ID]
	FROM
	       [CRONUS UK Ltd_$Transfer Route$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transfer Route]
	LEFT JOIN
	       [User] AS [User]
	              ON
	                     [Transfer Route].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier

Show/hide tables related from Transfer Route table

Shipping AgentShipping Agent Services
Dynamics 365 BC Table ReferenceTablesCompany TablesTTransfer Route

Leave a Reply

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