Shpfy Refund Header

Dynamics 365 BC Table ReferenceTablesCompany TablesSShpfy Refund Header

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

Table Type: Company

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

Table Number: 30142

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

Show/hide an example select of all columns

SELECT

   *

FROM

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

Show/hide an example select of all columns by name

SELECT

   [Refund Id]
   ,[Order Id]
   ,[Created At]
   ,[Updated At]
   ,[Return Id]
   ,[Total Refunded Amount]
   ,[Pres_ Tot_ Refunded Amount]
   ,[Note]
   ,[Shop Code]
   ,[Has Processing Error]
   ,[Last Error Description]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

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

Show/hide columns in Shpfy Refund Header table

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

Show/hide example query

SELECT
	       [Shpfy Refund Header].[Order Id]
	       ,[Shpfy Order Header].[Shopify Order Id]
	FROM
	       [CRONUS UK Ltd_$Shpfy Refund Header$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Refund Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$Shpfy Order Header$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Order Header]
	              ON
	                     [Shpfy Refund Header].[Order Id] = [Shpfy Order Header].[Shopify Order Id]
3Created At SearchCreated AtNormalDateTime8Created Atdatetime
4Updated At SearchUpdated AtNormalDateTime8Updated Atdatetime
5Return Id SearchReturn IdNormalBigInteger8Return Idbigint
Key to join to the Shpfy Return Header table.

Show/hide example query

SELECT
	       [Shpfy Refund Header].[Return Id]
	       ,[Shpfy Return Header].[Return Id]
	FROM
	       [CRONUS UK Ltd_$Shpfy Refund Header$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Refund Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$Shpfy Return Header$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Return Header]
	              ON
	                     [Shpfy Refund Header].[Return Id] = [Shpfy Return Header].[Return Id]
6Total Refunded Amount SearchTotal Refunded AmountNormalDecimal12Total Refunded Amountdecimal(38,38)
7Pres. Tot. Refunded Amount SearchPresentment Total Refunded AmountNormalDecimal12Pres_ Tot_ Refunded Amountdecimal(38,38)
8Note SearchNoteNormalBLOB8Noteimage
9Shop Code SearchShop codeNormalCode20Shop Codenvarchar(40)
Key to join to the Shpfy Shop table.

Show/hide example query

SELECT
	       [Shpfy Refund Header].[Shop Code]
	       ,[Shpfy Shop].[Code]
	FROM
	       [CRONUS UK Ltd_$Shpfy Refund Header$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Refund Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$Shpfy Shop$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Shop]
	              ON
	                     [Shpfy Refund Header].[Shop Code] = [Shpfy Shop].[Code]
50Has Processing Error SearchHas Processing ErrorNormalBoolean4Has Processing Errortinyint
51Last Error Description SearchLast Error DescriptionNormalBLOB8Last Error Descriptionimage
101Sell-to Customer No. SearchSell-to Customer No.FlowFieldCode20
Key to join to the Customer table.

Show/hide example query

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

Show/hide example query

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

Leave a Reply

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