Shpfy Shop Collection Map

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

Table Number: 30128

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 NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Id SearchIdNormalInteger4Idint
2Shop Code Primary Key SearchShop CodeNormalCode20Shop Codenvarchar(40)
Key to join to the Shpfy Shop table.

Show/hide example query

SELECT
	       [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]
3Product Collection SearchProduct CollectionNormalOption4Product Collectionint
Available options are:
  • ” “
  • “Tax Group”
  • “VAT Prod. Posting Group”
4Product Group Code SearchProduct Group CodeNormalCode20Product Group Codenvarchar(40)
5Collection Id SearchCollection IdNormalBigInteger8Collection Idbigint
6Collection Name SearchCollection NameNormalText250Collection Namenvarchar(500)
7Item Template Code SearchItem Template CodeNormalCode10Item Template Codenvarchar(20)
8Default for Export SearchDefault for ExportNormalBoolean4Default for Exporttinyint
9Version SearchVersionNormalBigInteger8
Key to join to the Guided Experience Item table.

Show/hide example query

SELECT
	       [Shpfy Shop Collection Map].[]
	       ,[Guided Experience Item].[Version]
	FROM
	       [CRONUS UK Ltd_$Shpfy Shop Collection Map$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Shop Collection Map]
	LEFT JOIN
	       [CRONUS UK Ltd_$Guided Experience Item$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Guided Experience Item]
	              ON
	                     [Shpfy Shop Collection Map].[] = [Guided Experience Item].[Version]
10Item Templ. Code SearchItem Template CodeNormalCode20Item Templ_ Codenvarchar(40)
Key to join to the Item Templ. table.

Show/hide example query

SELECT
	       [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 SearchSystem IDNormalGUID16$systemIduniqueidentifier
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8$systemCreatedAtdatetime
2000000002SystemCreatedBy SearchCreated ByNormalGUID16$systemCreatedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
	       [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]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier

Show/hide tables related from Shpfy Shop Collection Map table

Leave a Reply

Your email address will not be published. Required fields are marked *