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
Table Number: 30134Due 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.
SELECT
*
FROM
[CRONUS UK Ltd_$Shpfy Payment Method Mapping$ec255f57-31d0-4ca2-b751-f2fa7c745abb]
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]
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]
| 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.SELECT
[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.SELECT
[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.SELECT
[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.SELECT
[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.SELECT
[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 |
