Shpfy Variant – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables SShpfy Variant

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

Table Type: Company

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

Table Number: 30129

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

Show/hide an example select of all columns

SELECT

   *

FROM

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

Show/hide an example select of all columns by name

SELECT

   [Id]
   ,[Product Id]
   ,[Created At]
   ,[Updated At]
   ,[Available For Sales]
   ,[Barcode]
   ,[Compare at Price]
   ,[Display Name]
   ,[Inventory Policy]
   ,[Position]
   ,[Price]
   ,[SKU]
   ,[Tax Code]
   ,[Taxable]
   ,[Title]
   ,[Weight]
   ,[Option 1 Name]
   ,[Option 1 Value]
   ,[Option 2 Name]
   ,[Option 2 Value]
   ,[Option 3 Name]
   ,[Option 3 Value]
   ,[Unit Cost]
   ,[Image Id]
   ,[Shop Code]
   ,[Last Updated by BC]
   ,[UoM Option Id]
   ,[Mapped By Item]
   ,[Image Hash]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Shpfy Variant$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 Variant$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Variant]
LEFT JOIN
   [CRONUS UK Ltd_$Shpfy Shop$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Shop]
      ON
         [Shpfy Variant].[Shop Code] = [Shpfy Shop].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
      ON
         [Shpfy Variant].[Variant Code] = [Item Variant].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Shpfy Variant].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Shpfy Variant].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Shpfy Variant table

Field No.	Field Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	Id	Id	Normal	BigInteger	8	Id	bigint
2	Product Id	ProductId	Normal	BigInteger	8	Product Id	bigint
3	Created At	CreatedAt	Normal	DateTime	8	Created At	datetime
4	Updated At	Updated At	Normal	DateTime	8	Updated At	datetime
5	Available For Sales	Available For Sales	Normal	Boolean	4	Available For Sales	tinyint
6	Barcode	Barcode	Normal	Text	50	Barcode	nvarchar(100)
7	Compare at Price	Compare at Price	Normal	Decimal	12	Compare at Price	decimal(38,38)
8	Display Name	Display Name	Normal	Text	250	Display Name	nvarchar(500)
9	Inventory Policy	Inventory Policy	Normal	Option	4	Inventory Policy	int
	Available options are: “DENY” “CONTINUE”
10	Position	Position	Normal	Integer	4	Position	int
11	Price	Price	Normal	Decimal	12	Price	decimal(38,38)
12	SKU	SKU	Normal	Text	50	SKU	nvarchar(100)
13	Tax Code	Tax Code	Normal	Code	20	Tax Code	nvarchar(40)
14	Taxable	Taxable	Normal	Boolean	4	Taxable	tinyint
15	Title	Title	Normal	Text	100	Title	nvarchar(200)
16	Weight	Weight	Normal	Decimal	12	Weight	decimal(38,38)
17	Option 1 Name	Option 1 Name	Normal	Text	50	Option 1 Name	nvarchar(100)
18	Option 1 Value	Option 1 Value	Normal	Text	50	Option 1 Value	nvarchar(100)
19	Option 2 Name	Option 2 Name	Normal	Text	50	Option 2 Name	nvarchar(100)
20	Option 2 Value	Option 2 Value	Normal	Text	50	Option 2 Value	nvarchar(100)
21	Option 3 Name	Option 3 Name	Normal	Text	50	Option 3 Name	nvarchar(100)
22	Option 3 Value	Option 3 Value	Normal	Text	50	Option 3 Value	nvarchar(100)
23	Unit Cost	Unit Cost	Normal	Decimal	12	Unit Cost	decimal(38,38)
24	Image Id	Image Id	Normal	BigInteger	8	Image Id	bigint
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 Variant].[Shop Code] ,[Shpfy Shop].[Code] FROM [CRONUS UK Ltd_$Shpfy Variant$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Variant] LEFT JOIN [CRONUS UK Ltd_$Shpfy Shop$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Shop] ON [Shpfy Variant].[Shop Code] = [Shpfy Shop].[Code]
101	Item SystemId	Item SystemId	Normal	GUID	16
102	Item Variant SystemId	Item Variant SystemId	Normal	GUID	16
103	Last Updated by BC	Last Updated by BC	Normal	DateTime	8	Last Updated by BC	datetime
104	Item No.	Item No.	FlowField	Code	20
105	Variant Code	Variant No.	FlowField	Code	10
106	UoM Option Id	UoM Option Id	Normal	Integer	4	UoM Option Id	int
107	Mapped By Item	Mapped By Item	Normal	Boolean	4	Mapped By Item	tinyint
108	Image Hash	Image Hash	Normal	Integer	4	Image 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 Variant].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$Shpfy Variant$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Variant] LEFT JOIN [User] AS [User] ON [Shpfy Variant].[$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 Variant].[$systemModifiedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$Shpfy Variant$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Variant] LEFT JOIN [User] AS [User] ON [Shpfy Variant].[$systemModifiedBy] = [User].[User Security ID]