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
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 Name | Field Caption | Class | Type | Length | SQL Column Name | SQL DataType |
|---|---|---|---|---|---|---|---|
| 1 | Refund Id   | Refund Id | Normal | BigInteger | 8 | Refund Id | bigint |
| 2 | Order Id | Order Id | Normal | BigInteger | 8 | Order Id | bigint |
Key to join to the Shpfy Order Header table.Show/hide example querySELECT
[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] | |||||||
| 3 | Created At | Created At | Normal | DateTime | 8 | Created At | datetime |
| 4 | Updated At | Updated At | Normal | DateTime | 8 | Updated At | datetime |
| 5 | Return Id | Return Id | Normal | BigInteger | 8 | Return Id | bigint |
Key to join to the Shpfy Return Header table.Show/hide example querySELECT
[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] | |||||||
| 6 | Total Refunded Amount | Total Refunded Amount | Normal | Decimal | 12 | Total Refunded Amount | decimal(38,38) |
| 7 | Pres. Tot. Refunded Amount | Presentment Total Refunded Amount | Normal | Decimal | 12 | Pres_ Tot_ Refunded Amount | decimal(38,38) |
| 8 | Note | Note | Normal | BLOB | 8 | Note | image |
| 9 | Shop Code | Shop code | Normal | Code | 20 | Shop Code | nvarchar(40) |
Key to join to the Shpfy Shop table.Show/hide example querySELECT
[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] | |||||||
| 50 | Has Processing Error | Has Processing Error | Normal | Boolean | 4 | Has Processing Error | tinyint |
| 51 | Last Error Description | Last Error Description | Normal | BLOB | 8 | Last Error Description | image |
| 101 | Sell-to Customer No. | Sell-to Customer No. | FlowField | Code | 20 | ||
| 102 | Bill-to Customer No. | Bill-to Customer No. | FlowField | Code | 20 | ||
| 103 | Sell-to Customer Name | Sell-to Customer Name | FlowField | Text | 50 | ||
| 104 | Bill-to Customer Name | Bill-to Customer Name | FlowField | Text | 50 | ||
| 105 | Shopify Order No. | Shopify Order No. | FlowField | Text | 50 | ||
| 106 | Return No. | Return No. | FlowField | Text | 30 | ||
| 107 | Is Processed | Is Processed | FlowField | Boolean | 4 | ||
| 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 querySELECT
[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] | |||||||
| 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 querySELECT
[Shpfy Refund Header].[$systemModifiedBy]
,[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].[$systemModifiedBy] = [User].[User Security ID] | |||||||