Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/30128
Table Type: Company
Table Name: Shpfy Shop Collection Map
Database Table Name: CRONUS UK Ltd_$Shpfy Shop Collection Map$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 Shop Collection Map can be queried.
Show/hide an example select of all columns
SELECT
*
FROM
[CRONUS UK Ltd_$Shpfy Shop Collection Map$ec255f57-31d0-4ca2-b751-f2fa7c745abb]Show/hide an example select of all columns by name
SELECT
[Id]
,[Shop Code]
,[Product Collection]
,[Product Group Code]
,[Collection Id]
,[Collection Name]
,[Item Template Code]
,[Default for Export]
,[Item Templ_ Code]
,[$systemId]
,[$systemCreatedAt]
,[$systemCreatedBy]
,[$systemModifiedAt]
,[$systemModifiedBy]
FROM
[CRONUS UK Ltd_$Shpfy Shop Collection Map$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 Shop Collection Map$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Shop Collection Map]
LEFT JOIN
[CRONUS UK Ltd_$Shpfy Shop$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Shop]
ON
[Shpfy Shop Collection Map].[Shop Code] = [Shpfy Shop].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Guided Experience Item$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Guided Experience Item]
ON
[Shpfy Shop Collection Map].[Version] = [Guided Experience Item].[Version]
LEFT JOIN
[User] AS [User]
ON
[Shpfy Shop Collection Map].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
[User] AS [User]
ON
[Shpfy Shop Collection Map].[SystemModifiedBy] = [User].[User Security ID]Show/hide columns in Shpfy Shop Collection Map table
| Field No. | Field Name | Field Caption | Class | Type | Length | SQL Column Name | SQL DataType |
|---|---|---|---|---|---|---|---|
| 1 | Id   | Id | Normal | Integer | 4 | Id | int |
| 2 | Shop Code | Shop Code | Normal | Code | 20 | Shop Code | nvarchar(40) |
Key to join to the Shpfy Shop table.Show/hide example querySELECT
[Shpfy Shop Collection Map].[Shop Code]
,[Shpfy Shop].[Code]
FROM
[CRONUS UK Ltd_$Shpfy Shop Collection Map$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Shop Collection Map]
LEFT JOIN
[CRONUS UK Ltd_$Shpfy Shop$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Shop]
ON
[Shpfy Shop Collection Map].[Shop Code] = [Shpfy Shop].[Code] | |||||||
| 3 | Product Collection | Product Collection | Normal | Option | 4 | Product Collection | int |
Available options are:
| |||||||
| 4 | Product Group Code | Product Group Code | Normal | Code | 20 | Product Group Code | nvarchar(40) |
| 5 | Collection Id | Collection Id | Normal | BigInteger | 8 | Collection Id | bigint |
| 6 | Collection Name | Collection Name | Normal | Text | 250 | Collection Name | nvarchar(500) |
| 7 | Item Template Code | Item Template Code | Normal | Code | 10 | Item Template Code | nvarchar(20) |
| 8 | Default for Export | Default for Export | Normal | Boolean | 4 | Default for Export | tinyint |
| 9 | Version | Version | Normal | BigInteger | 8 | ||
| 10 | Item Templ. Code | Item Template Code | Normal | Code | 20 | Item Templ_ Code | nvarchar(40) |
Key to join to the Item Templ. table.Show/hide example querySELECT
[Shpfy Shop Collection Map].[Item Templ_ Code]
,[Item Templ.].[Code]
FROM
[CRONUS UK Ltd_$Shpfy Shop Collection Map$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Shop Collection Map]
LEFT JOIN
[CRONUS UK Ltd_$Item Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Templ.]
ON
[Shpfy Shop Collection Map].[Item Templ_ Code] = [Item Templ.].[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 Shop Collection Map].[$systemCreatedBy]
,[User].[User Security ID]
FROM
[CRONUS UK Ltd_$Shpfy Shop Collection Map$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Shop Collection Map]
LEFT JOIN
[User] AS [User]
ON
[Shpfy Shop Collection Map].[$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 Shop Collection Map].[$systemModifiedBy]
,[User].[User Security ID]
FROM
[CRONUS UK Ltd_$Shpfy Shop Collection Map$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Shop Collection Map]
LEFT JOIN
[User] AS [User]
ON
[Shpfy Shop Collection Map].[$systemModifiedBy] = [User].[User Security ID] | |||||||