Shpfy Return Header

Dynamics 365 BC Table ReferenceTablesCompany TablesSShpfy Return Header

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

Table Type: Company

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

Table Number: 30147

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

Show/hide an example select of all columns

SELECT

   *

FROM

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

Show/hide an example select of all columns by name

SELECT

   [Return Id]
   ,[Order Id]
   ,[Return No_]
   ,[Status]
   ,[Total Quantity]
   ,[Decline Reason]
   ,[Decline Note]
   ,[Shop Code]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

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

Show/hide columns in Shpfy Return Header table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Return Id SearchIdNormalBigInteger8Return Idbigint
2Order Id Primary Key SearchOrder IdNormalBigInteger8Order Idbigint
Key to join to the Shpfy Order Header table.

Show/hide example query

SELECT
	       [Shpfy Return Header].[Order Id]
	       ,[Shpfy Order Header].[Shopify Order Id]
	FROM
	       [CRONUS UK Ltd_$Shpfy Return Header$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Return Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$Shpfy Order Header$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Order Header]
	              ON
	                     [Shpfy Return Header].[Order Id] = [Shpfy Order Header].[Shopify Order Id]
3Return No. SearchReturn No.NormalText30Return No_nvarchar(60)
4Status SearchStatusNormalOption4Statusint
Available options are:
  • “Canceled”
  • “Closed”
  • “Declined”
  • “Open”
  • “Requested”
5Total Quantity SearchTotal QuantityNormalInteger4Total Quantityint
6Decline Reason SearchDecline ReasonNormalOption4Decline Reasonint
Available options are:
  • ” “
  • “Final Sale”
  • “Other”
  • “Return Period Ended”
7Decline Note SearchDecline NoteNormalBLOB8Decline Noteimage
8Shop Code SearchShop codeNormalCode20Shop Codenvarchar(40)
Key to join to the Shpfy Shop table.

Show/hide example query

SELECT
	       [Shpfy Return Header].[Shop Code]
	       ,[Shpfy Shop].[Code]
	FROM
	       [CRONUS UK Ltd_$Shpfy Return Header$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Return Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$Shpfy Shop$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Shop]
	              ON
	                     [Shpfy Return Header].[Shop Code] = [Shpfy Shop].[Code]
12Discounted Total Amount SearchDiscounted Total AmountFlowFieldDecimal12
13Presentment Disc. Total Amt. SearchPresentment Discounted Total AmountFlowFieldDecimal12
101Sell-to Customer No. SearchSell-to Customer No.FlowFieldCode20
Key to join to the Customer table.

Show/hide example query

SELECT
	       [Shpfy Return Header].[]
	       ,[Customer].[No_]
	FROM
	       [CRONUS UK Ltd_$Shpfy Return Header$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Return Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
	              ON
	                     [Shpfy Return Header].[] = [Customer].[No_]
102Bill-to Customer No. SearchBill-to Customer No.FlowFieldCode20
Key to join to the Customer table.

Show/hide example query

SELECT
	       [Shpfy Return Header].[]
	       ,[Customer].[No_]
	FROM
	       [CRONUS UK Ltd_$Shpfy Return Header$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Return Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
	              ON
	                     [Shpfy Return Header].[] = [Customer].[No_]
103Sell-to Customer Name SearchSell-to Customer NameFlowFieldText50
Key to join to the Customer table.

Show/hide example query

SELECT
	       [Shpfy Return Header].[]
	       ,[Customer].[Name]
	FROM
	       [CRONUS UK Ltd_$Shpfy Return Header$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Return Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
	              ON
	                     [Shpfy Return Header].[] = [Customer].[Name]
104Bill-to Customer Name SearchBill-to Customer NameFlowFieldText50
105Shopify Order No. SearchShopify Order No.FlowFieldText50
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 Return Header].[$systemCreatedBy]
	       ,[User].[User Security ID]
	FROM
	       [CRONUS UK Ltd_$Shpfy Return Header$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Return Header]
	LEFT JOIN
	       [User] AS [User]
	              ON
	                     [Shpfy Return Header].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Dynamics 365 BC Table ReferenceTablesCompany TablesSShpfy Return Header

Leave a Reply

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