Shpfy Fulfillment Line

Dynamics 365 BC Table ReferenceTablesCompany TablesSShpfy Fulfillment Line

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

Table Type: Company

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

Table Number: 30139

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

Show/hide an example select of all columns

SELECT

   *

FROM

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

Show/hide an example select of all columns by name

SELECT

   [Fulfillment Line Id]
   ,[Fulfillment Id]
   ,[Order Id]
   ,[Order Line Id]
   ,[Quantity]
   ,[Is Gift Card]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Shpfy Fulfillment Line$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 Fulfillment Line$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Fulfillment Line]
LEFT JOIN
   [CRONUS UK Ltd_$Shpfy Fulfillment Line$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Fulfillment Line]
      ON
         [Shpfy Fulfillment Line].[Fulfillment Line Id] = [Shpfy Fulfillment Line].[Fulfillment Line Id]
LEFT JOIN
   [CRONUS UK Ltd_$Shpfy Order Fulfillment$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Order Fulfillment]
      ON
         [Shpfy Fulfillment Line].[Fulfillment Id] = [Shpfy Order Fulfillment].[Shopify Fulfillment Id]
LEFT JOIN
   [CRONUS UK Ltd_$Shpfy Order Header$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Order Header]
      ON
         [Shpfy Fulfillment Line].[Order Id] = [Shpfy Order Header].[Shopify Order Id]
LEFT JOIN
   [CRONUS UK Ltd_$Shpfy Order Line$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Order Line]
      ON
         [Shpfy Fulfillment Line].[Order Line Id] = [Shpfy Order Line].[Line Id]
LEFT JOIN
   [User] AS [User]
      ON
         [Shpfy Fulfillment Line].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Shpfy Fulfillment Line].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Shpfy Fulfillment Line table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Fulfillment Line Id SearchFulfillment Line IdNormalBigInteger8Fulfillment Line Idbigint
2Fulfillment Id Primary Key SearchFulfillment IdNormalBigInteger8Fulfillment Idbigint
Key to join to the Shpfy Order Fulfillment table.

Show/hide example query

SELECT
	       [Shpfy Fulfillment Line].[Fulfillment Id]
	       ,[Shpfy Order Fulfillment].[Shopify Fulfillment Id]
	FROM
	       [CRONUS UK Ltd_$Shpfy Fulfillment Line$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Fulfillment Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Shpfy Order Fulfillment$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Order Fulfillment]
	              ON
	                     [Shpfy Fulfillment Line].[Fulfillment Id] = [Shpfy Order Fulfillment].[Shopify Fulfillment Id]
3Order Id SearchOrder IdNormalBigInteger8Order Idbigint
Key to join to the Shpfy Order Header table.

Show/hide example query

SELECT
	       [Shpfy Fulfillment Line].[Order Id]
	       ,[Shpfy Order Header].[Shopify Order Id]
	FROM
	       [CRONUS UK Ltd_$Shpfy Fulfillment Line$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Fulfillment Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Shpfy Order Header$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Order Header]
	              ON
	                     [Shpfy Fulfillment Line].[Order Id] = [Shpfy Order Header].[Shopify Order Id]
4Order Line Id SearchOrder Line IdNormalBigInteger8Order Line Idbigint
Key to join to the Shpfy Order Line table.

Show/hide example query

SELECT
	       [Shpfy Fulfillment Line].[Order Line Id]
	       ,[Shpfy Order Line].[Line Id]
	FROM
	       [CRONUS UK Ltd_$Shpfy Fulfillment Line$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Fulfillment Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Shpfy Order Line$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Order Line]
	              ON
	                     [Shpfy Fulfillment Line].[Order Line Id] = [Shpfy Order Line].[Line Id]
5Quantity SearchQuantityNormalInteger4Quantityint
6Is Gift Card SearchIs Gift CardNormalBoolean4Is Gift Cardtinyint
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 Fulfillment Line].[$systemCreatedBy]
	       ,[User].[User Security ID]
	FROM
	       [CRONUS UK Ltd_$Shpfy Fulfillment Line$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Fulfillment Line]
	LEFT JOIN
	       [User] AS [User]
	              ON
	                     [Shpfy Fulfillment Line].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Dynamics 365 BC Table ReferenceTablesCompany TablesSShpfy Fulfillment Line

Leave a Reply

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