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
[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 Name | Field Caption | Class | Type | Length | SQL Column Name | SQL DataType |
|---|---|---|---|---|---|---|---|
| 1 | Transfer-from Code   | Transfer-from Code | Normal | Code | 10 | Transfer-from Code | nvarchar(20) |
Key to join to the Location table.Show/hide example querySELECT
[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] | |||||||
| 2 | Transfer-to Code | Transfer-to Code | Normal | Code | 10 | Transfer-to Code | nvarchar(20) |
Key to join to the Location table.Show/hide example querySELECT
[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] | |||||||
| 4 | In-Transit Code | In-Transit Code | Normal | Code | 10 | In-Transit Code | nvarchar(20) |
| 5 | Shipping Agent Code | Shipping Agent Code | Normal | Code | 10 | 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$ext] AS [Shipping Agent]
ON
[Transfer Route].[Shipping Agent Code] = [Shipping Agent].[Code] | |||||||
| 6 | Shipping Agent Service Code | Shipping Agent Service Code | Normal | Code | 10 | Shipping Agent Service Code | nvarchar(20) |
| 2000000000 | $systemId | System ID | Normal | GUID | 16 | $systemId | uniqueidentifier |
| 2000000001 | SystemCreatedAt | Created At | Normal | DateTime | 8 | $systemCreatedAt | datetime |
| 2000000002 | SystemCreatedBy | Created By | Normal | GUID | 16 | $systemCreatedBy | uniqueidentifier |
Key to join to the User table.Show/hide example querySELECT
[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] | |||||||
| 2000000003 | SystemModifiedAt | Modified At | Normal | DateTime | 8 | $systemModifiedAt | datetime |
| 2000000004 | SystemModifiedBy | Modified By | Normal | GUID | 16 | $systemModifiedBy | uniqueidentifier |
Key to join to the User table.Show/hide example querySELECT
[Transfer Route].[$systemModifiedBy]
,[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].[$systemModifiedBy] = [User].[User Security ID] | |||||||