Transfer 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
   [timestamp]
   ,[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_$Shipping Agent$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipping Agent]
      ON
         [Transfer Route].[Shipping Agent Code] = [Shipping Agent].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Shipping Agent Services$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipping Agent Services]
      ON
         [Transfer Route].[Shipping Agent Service Code] = [Shipping Agent Services].[Code]

Show/hide columns in Transfer Route table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Transfer-from Code Primary Key Searchnvarchar(20)
3Transfer-to Code Primary Key Searchnvarchar(20)
4In-Transit Code Searchnvarchar(20)
5Shipping Agent Code Searchnvarchar(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] AS [Shipping Agent]
              ON
                     [Transfer Route].[Shipping Agent Code] = [Shipping Agent].[Code]
6Shipping Agent Service Code Searchnvarchar(20)
Key to join to the Shipping Agent Services table.

Show/hide example query

SELECT
       [Transfer Route].[Shipping Agent Service Code]
       ,[Shipping Agent Services].[Code]
FROM
       [CRONUS UK Ltd_$Transfer Route$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transfer Route]
LEFT JOIN
       [CRONUS UK Ltd_$Shipping Agent Services$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipping Agent Services]
              ON
                     [Transfer Route].[Shipping Agent Service Code] = [Shipping Agent Services].[Code]
7$systemId Searchuniqueidentifier
8$systemCreatedAt Searchdatetime
9$systemCreatedBy Searchuniqueidentifier
10$systemModifiedAt Searchdatetime
11$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Transfer Route table

Leave a Reply

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