Shpfy Product – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables SShpfy Product

Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/30127

Table Type: Company

Table Name: Shpfy Product
Database Table Name: CRONUS UK Ltd_$Shpfy Product$ec255f57-31d0-4ca2-b751-f2fa7c745abb

Table Number: 30127

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 Product can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Shpfy Product$ec255f57-31d0-4ca2-b751-f2fa7c745abb]

Show/hide an example select of all columns by name

SELECT

   [Id]
   ,[Created At]
   ,[Updated At]
   ,[Has Variants]
   ,[Description]
   ,[Description as HTML]
   ,[Preview URL]
   ,[URL]
   ,[Product Type]
   ,[SEO Description]
   ,[SEO Title]
   ,[Title]
   ,[Vendor]
   ,[Image Id]
   ,[Status]
   ,[Shop Code]
   ,[Last Updated by BC]
   ,[Image Hash]
   ,[Tags Hash]
   ,[Description Html Hash]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Shpfy Product$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 Product$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Product]
LEFT JOIN
   [CRONUS UK Ltd_$Shpfy Shop$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Shop]
      ON
         [Shpfy Product].[Shop Code] = [Shpfy Shop].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Shpfy Product].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Shpfy Product].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Shpfy Product table

Field No.	Field Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	Id	Id	Normal	BigInteger	8	Id	bigint
2	Created At	Created At	Normal	DateTime	8	Created At	datetime
3	Updated At	Updated At	Normal	DateTime	8	Updated At	datetime
4	Has Variants	Has Variants	Normal	Boolean	4	Has Variants	tinyint
5	Description	Description	Normal	Text	250	Description	nvarchar(500)
6	Description as HTML	Description as HTML	Normal	BLOB	8	Description as HTML	image
7	Preview URL	Preview URL	Normal	Text	250	Preview URL	nvarchar(500)
8	URL	URL	Normal	Text	250	URL	nvarchar(500)
9	Product Type	Product Type	Normal	Text	50	Product Type	nvarchar(100)
10	SEO Description	SEO Description	Normal	Text	250	SEO Description	nvarchar(500)
11	SEO Title	SEO Title	Normal	Text	100	SEO Title	nvarchar(200)
12	Title	Title	Normal	Text	100	Title	nvarchar(200)
13	Vendor	Vendor	Normal	Text	100	Vendor	nvarchar(200)
14	Image Id	Image Id	Normal	BigInteger	8	Image Id	bigint
15	Status	Status	Normal	Option	4	Status	int
	Available options are: “Active” “Archived” “Draft”
100	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 Product].[Shop Code] ,[Shpfy Shop].[Code] FROM [CRONUS UK Ltd_$Shpfy Product$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Product] LEFT JOIN [CRONUS UK Ltd_$Shpfy Shop$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Shop] ON [Shpfy Product].[Shop Code] = [Shpfy Shop].[Code]
101	Item SystemId	Item SystemId	Normal	GUID	16
102	Last Updated by BC	Last Updated by BC	Normal	DateTime	8	Last Updated by BC	datetime
103	Item No.	Item No.	FlowField	Code	20
104	Image Hash	Image Hash	Normal	Integer	4	Image Hash	int
105	Tags Hash	Tags Hash	Normal	Integer	4	Tags Hash	int
106	Description Html Hash	Description Html Hash	Normal	Integer	4	Description Html Hash	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 query SELECT [Shpfy Product].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$Shpfy Product$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Product] LEFT JOIN [User] AS [User] ON [Shpfy Product].[$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 query SELECT [Shpfy Product].[$systemModifiedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$Shpfy Product$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Product] LEFT JOIN [User] AS [User] ON [Shpfy Product].[$systemModifiedBy] = [User].[User Security ID]