Shpfy Shop Collection Map – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables SShpfy 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 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 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]
3	Product Collection	Product Collection	Normal	Option	4	Product Collection	int
	Available options are: ” “ “Tax Group” “VAT Prod. Posting Group”
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
	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]
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 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	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 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]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier

Show/hide tables related from Shpfy Shop Collection Map table

Dynamics 365 BC Table Reference Tables Company Tables SShpfy Shop Collection Map

Leave a Reply Cancel reply