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
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 ID | Column Name | Data Type | ||||
|---|---|---|---|---|---|---|
| 1 | timestamp  | timestamp | ||||
| 2 | Transfer-from Code  | nvarchar(20) | ||||
| 3 | Transfer-to Code | nvarchar(20) | ||||
| 4 | In-Transit Code | nvarchar(20) | ||||
| 5 | Shipping Agent Code | nvarchar(20) | ||||
Key to join to the Shipping Agent table.Show/hide example querySELECT
[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] | ||||||
| 6 | Shipping Agent Service Code | nvarchar(20) | ||||
Key to join to the Shipping Agent Services table.Show/hide example querySELECT
[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 | uniqueidentifier | ||||
| 8 | $systemCreatedAt | datetime | ||||
| 9 | $systemCreatedBy | uniqueidentifier | ||||
| 10 | $systemModifiedAt | datetime | ||||
| 11 | $systemModifiedBy | uniqueidentifier | ||||