Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/30131
Table Type: Company
Table Name: Shpfy Shipment Method Mapping
Database Table Name: CRONUS UK Ltd_$Shpfy Shipment Method Mapping$ec255f57-31d0-4ca2-b751-f2fa7c745abb
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 Shpfy Shipment Method Mapping can be queried.
Show/hide an example select of all columns
SELECT
*
FROM
[CRONUS UK Ltd_$Shpfy Shipment Method Mapping$ec255f57-31d0-4ca2-b751-f2fa7c745abb]Show/hide an example select of all columns by name
SELECT
[Shop Code]
,[Name]
,[Shipment Method Code]
,[$systemId]
,[$systemCreatedAt]
,[$systemCreatedBy]
,[$systemModifiedAt]
,[$systemModifiedBy]
FROM
[CRONUS UK Ltd_$Shpfy Shipment Method Mapping$ec255f57-31d0-4ca2-b751-f2fa7c745abb]Show/hide an example select of all columns including those from all joined tables
SELECT
*
FROM
[CRONUS UK Ltd_$Shpfy Shipment Method Mapping$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Shipment Method Mapping]
LEFT JOIN
[CRONUS UK Ltd_$Shpfy Shop$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Shop]
ON
[Shpfy Shipment Method Mapping].[Shop Code] = [Shpfy Shop].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Shipment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipment Method]
ON
[Shpfy Shipment Method Mapping].[Shipment Method Code] = [Shipment Method].[Code]
LEFT JOIN
[User] AS [User]
ON
[Shpfy Shipment Method Mapping].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
[User] AS [User]
ON
[Shpfy Shipment Method Mapping].[SystemModifiedBy] = [User].[User Security ID]Show/hide columns in Shpfy Shipment Method Mapping table
| Field No. | Field Name | Field Caption | Class | Type | Length | SQL Column Name | SQL DataType |
|---|---|---|---|---|---|---|---|
| 1 | Shop Code   | Shop Code | Normal | Code | 20 | Shop Code | nvarchar(40) |
Key to join to the Shpfy Shop table.Show/hide example querySELECT
[Shpfy Shipment Method Mapping].[Shop Code]
,[Shpfy Shop].[Code]
FROM
[CRONUS UK Ltd_$Shpfy Shipment Method Mapping$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Shipment Method Mapping]
LEFT JOIN
[CRONUS UK Ltd_$Shpfy Shop$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Shop]
ON
[Shpfy Shipment Method Mapping].[Shop Code] = [Shpfy Shop].[Code] | |||||||
| 2 | Name | Name | Normal | Text | 50 | Name | nvarchar(100) |
| 3 | Shipment Method Code | Shipment Method Code | Normal | Code | 10 | Shipment Method Code | nvarchar(20) |
Key to join to the Shipment Method table.Show/hide example querySELECT
[Shpfy Shipment Method Mapping].[Shipment Method Code]
,[Shipment Method].[Code]
FROM
[CRONUS UK Ltd_$Shpfy Shipment Method Mapping$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Shipment Method Mapping]
LEFT JOIN
[CRONUS UK Ltd_$Shipment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipment Method]
ON
[Shpfy Shipment Method Mapping].[Shipment Method Code] = [Shipment Method].[Code] | |||||||
| 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
[Shpfy Shipment Method Mapping].[$systemCreatedBy]
,[User].[User Security ID]
FROM
[CRONUS UK Ltd_$Shpfy Shipment Method Mapping$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Shipment Method Mapping]
LEFT JOIN
[User] AS [User]
ON
[Shpfy Shipment Method Mapping].[$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
[Shpfy Shipment Method Mapping].[$systemModifiedBy]
,[User].[User Security ID]
FROM
[CRONUS UK Ltd_$Shpfy Shipment Method Mapping$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Shipment Method Mapping]
LEFT JOIN
[User] AS [User]
ON
[Shpfy Shipment Method Mapping].[$systemModifiedBy] = [User].[User Security ID] | |||||||