Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/30134
Table Type: Company
Table Name: Shpfy Payment Method Mapping
Database Table Name: CRONUS UK Ltd_$Shpfy Payment 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 Payment Method Mapping can be queried.
Show/hide an example select of all columns
SELECT
*
FROM
[CRONUS UK Ltd_$Shpfy Payment Method Mapping$ec255f57-31d0-4ca2-b751-f2fa7c745abb]Show/hide an example select of all columns by name
SELECT
[Shop Code]
,[Gateway]
,[Credit Card Company]
,[Payment Method Code]
,[Priority]
,[$systemId]
,[$systemCreatedAt]
,[$systemCreatedBy]
,[$systemModifiedAt]
,[$systemModifiedBy]
FROM
[CRONUS UK Ltd_$Shpfy Payment 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 Payment Method Mapping$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Payment Method Mapping]
LEFT JOIN
[CRONUS UK Ltd_$Shpfy Shop$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Shop]
ON
[Shpfy Payment Method Mapping].[Shop Code] = [Shpfy Shop].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Shpfy Transaction Gateway$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Transaction Gateway]
ON
[Shpfy Payment Method Mapping].[Gateway] = [Shpfy Transaction Gateway].[Name]
LEFT JOIN
[CRONUS UK Ltd_$Shpfy Credit Card Company$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Credit Card Company]
ON
[Shpfy Payment Method Mapping].[Credit Card Company] = [Shpfy Credit Card Company].[Name]
LEFT JOIN
[CRONUS UK Ltd_$Payment Method$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Payment Method]
ON
[Shpfy Payment Method Mapping].[Payment Method Code] = [Payment Method].[Code]
LEFT JOIN
[User] AS [User]
ON
[Shpfy Payment Method Mapping].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
[User] AS [User]
ON
[Shpfy Payment Method Mapping].[SystemModifiedBy] = [User].[User Security ID]Show/hide columns in Shpfy Payment 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 Payment Method Mapping].[Shop Code]
,[Shpfy Shop].[Code]
FROM
[CRONUS UK Ltd_$Shpfy Payment Method Mapping$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Payment Method Mapping]
LEFT JOIN
[CRONUS UK Ltd_$Shpfy Shop$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Shop]
ON
[Shpfy Payment Method Mapping].[Shop Code] = [Shpfy Shop].[Code] | |||||||
| 2 | Gateway | Gateway | Normal | Text | 30 | Gateway | nvarchar(60) |
Key to join to the Shpfy Transaction Gateway table.Show/hide example querySELECT
[Shpfy Payment Method Mapping].[Gateway]
,[Shpfy Transaction Gateway].[Name]
FROM
[CRONUS UK Ltd_$Shpfy Payment Method Mapping$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Payment Method Mapping]
LEFT JOIN
[CRONUS UK Ltd_$Shpfy Transaction Gateway$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Transaction Gateway]
ON
[Shpfy Payment Method Mapping].[Gateway] = [Shpfy Transaction Gateway].[Name] | |||||||
| 3 | Credit Card Company | Credit Card Company | Normal | Text | 30 | Credit Card Company | nvarchar(60) |
Key to join to the Shpfy Credit Card Company table.Show/hide example querySELECT
[Shpfy Payment Method Mapping].[Credit Card Company]
,[Shpfy Credit Card Company].[Name]
FROM
[CRONUS UK Ltd_$Shpfy Payment Method Mapping$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Payment Method Mapping]
LEFT JOIN
[CRONUS UK Ltd_$Shpfy Credit Card Company$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Credit Card Company]
ON
[Shpfy Payment Method Mapping].[Credit Card Company] = [Shpfy Credit Card Company].[Name] | |||||||
| 4 | Payment Method Code | Payment Method Code | Normal | Code | 10 | Payment Method Code | nvarchar(20) |
Key to join to the Payment Method table.Show/hide example querySELECT
[Shpfy Payment Method Mapping].[Payment Method Code]
,[Payment Method].[Code]
FROM
[CRONUS UK Ltd_$Shpfy Payment Method Mapping$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Payment Method Mapping]
LEFT JOIN
[CRONUS UK Ltd_$Payment Method$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Payment Method]
ON
[Shpfy Payment Method Mapping].[Payment Method Code] = [Payment Method].[Code] | |||||||
| 5 | Priority | Priority | Normal | Integer | 4 | Priority | int |
| 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 Payment Method Mapping].[$systemCreatedBy]
,[User].[User Security ID]
FROM
[CRONUS UK Ltd_$Shpfy Payment Method Mapping$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Payment Method Mapping]
LEFT JOIN
[User] AS [User]
ON
[Shpfy Payment 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 Payment Method Mapping].[$systemModifiedBy]
,[User].[User Security ID]
FROM
[CRONUS UK Ltd_$Shpfy Payment Method Mapping$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Payment Method Mapping]
LEFT JOIN
[User] AS [User]
ON
[Shpfy Payment Method Mapping].[$systemModifiedBy] = [User].[User Security ID] | |||||||