Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/30145
Table Type: Company
Table Name: Shpfy Refund Line
Database Table Name: CRONUS UK Ltd_$Shpfy Refund Line$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 Line can be queried.
Show/hide an example select of all columns
SELECT
*
FROM
[CRONUS UK Ltd_$Shpfy Refund Line$ec255f57-31d0-4ca2-b751-f2fa7c745abb]Show/hide an example select of all columns by name
SELECT
[Refund Line Id]
,[Refund Id]
,[Order Line Id]
,[Quantity]
,[Restock Type]
,[Restocked]
,[Amount]
,[Presentment Amount]
,[Subtotal Amount]
,[Presentment Subtotal Amount]
,[Total Tax Amount]
,[Presentment Total Tax Amount]
,[$systemId]
,[$systemCreatedAt]
,[$systemCreatedBy]
,[$systemModifiedAt]
,[$systemModifiedBy]
FROM
[CRONUS UK Ltd_$Shpfy Refund 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 Refund Line$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Refund Line]
LEFT JOIN
[CRONUS UK Ltd_$Shpfy Refund Header$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Refund Header]
ON
[Shpfy Refund Line].[Refund Id] = [Shpfy Refund Header].[Refund Id]
LEFT JOIN
[CRONUS UK Ltd_$Shpfy Order Line$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Order Line]
ON
[Shpfy Refund Line].[Order Line Id] = [Shpfy Order Line].[Line Id]
LEFT JOIN
[CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
ON
[Shpfy Refund Line].[Variant Code] = [Item Variant].[Code]
LEFT JOIN
[User] AS [User]
ON
[Shpfy Refund Line].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
[User] AS [User]
ON
[Shpfy Refund Line].[SystemModifiedBy] = [User].[User Security ID]Show/hide columns in Shpfy Refund Line table
| Field No. | Field Name | Field Caption | Class | Type | Length | SQL Column Name | SQL DataType |
|---|---|---|---|---|---|---|---|
| 1 | Refund Line Id   | Refund Line Id | Normal | BigInteger | 8 | Refund Line Id | bigint |
| 2 | Refund Id | Refund Id | Normal | BigInteger | 8 | Refund Id | bigint |
Key to join to the Shpfy Refund Header table.Show/hide example querySELECT
[Shpfy Refund Line].[Refund Id]
,[Shpfy Refund Header].[Refund Id]
FROM
[CRONUS UK Ltd_$Shpfy Refund Line$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Refund Line]
LEFT JOIN
[CRONUS UK Ltd_$Shpfy Refund Header$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Refund Header]
ON
[Shpfy Refund Line].[Refund Id] = [Shpfy Refund Header].[Refund Id] | |||||||
| 3 | Order Line Id | Order Line Id | Normal | BigInteger | 8 | Order Line Id | bigint |
Key to join to the Shpfy Order Line table.Show/hide example querySELECT
[Shpfy Refund Line].[Order Line Id]
,[Shpfy Order Line].[Line Id]
FROM
[CRONUS UK Ltd_$Shpfy Refund Line$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Refund Line]
LEFT JOIN
[CRONUS UK Ltd_$Shpfy Order Line$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Order Line]
ON
[Shpfy Refund Line].[Order Line Id] = [Shpfy Order Line].[Line Id] | |||||||
| 4 | Quantity | Quantity | Normal | Integer | 4 | Quantity | int |
| 5 | Restock Type | Restock Type | Normal | Option | 4 | Restock Type | int |
Available options are:
| |||||||
| 6 | Restocked | Restocked | Normal | Boolean | 4 | Restocked | tinyint |
| 7 | Amount | Amount | Normal | Decimal | 12 | Amount | decimal(38,38) |
| 8 | Presentment Amount | Presentment Amount | Normal | Decimal | 12 | Presentment Amount | decimal(38,38) |
| 9 | Subtotal Amount | Subtotal Amount | Normal | Decimal | 12 | Subtotal Amount | decimal(38,38) |
| 10 | Presentment Subtotal Amount | Presentment Subtotal Amount | Normal | Decimal | 12 | Presentment Subtotal Amount | decimal(38,38) |
| 11 | Total Tax Amount | Total Tax Amount | Normal | Decimal | 12 | Total Tax Amount | decimal(38,38) |
| 12 | Presentment Total Tax Amount | Presentment Total Tax Amount | Normal | Decimal | 12 | Presentment Total Tax Amount | decimal(38,38) |
| 101 | Item No. | Item No. | FlowField | Code | 20 | ||
| 102 | Description | Description | FlowField | Text | 100 | ||
| 103 | Variant Code | Variant Code | FlowField | Code | 10 | ||
| 104 | Gift Card | Gift Card | 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 Line].[$systemCreatedBy]
,[User].[User Security ID]
FROM
[CRONUS UK Ltd_$Shpfy Refund Line$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Refund Line]
LEFT JOIN
[User] AS [User]
ON
[Shpfy Refund Line].[$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 Line].[$systemModifiedBy]
,[User].[User Security ID]
FROM
[CRONUS UK Ltd_$Shpfy Refund Line$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Refund Line]
LEFT JOIN
[User] AS [User]
ON
[Shpfy Refund Line].[$systemModifiedBy] = [User].[User Security ID] | |||||||