Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/30143
Table Type: Company
Table Name: Shpfy FulFillment Order Header
Database Table Name: CRONUS UK Ltd_$Shpfy FulFillment Order 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 FulFillment Order Header can be queried.
Show/hide an example select of all columns
SELECT
*
FROM
[CRONUS UK Ltd_$Shpfy FulFillment Order Header$ec255f57-31d0-4ca2-b751-f2fa7c745abb]Show/hide an example select of all columns by name
SELECT
[Shopify Fulfillment Order Id]
,[Shopify Order Id]
,[Status]
,[Shop Id]
,[Shop Code]
,[Shopify Location Id]
,[Updated At]
,[$systemId]
,[$systemCreatedAt]
,[$systemCreatedBy]
,[$systemModifiedAt]
,[$systemModifiedBy]
FROM
[CRONUS UK Ltd_$Shpfy FulFillment Order 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 FulFillment Order Header$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy FulFillment Order Header]
LEFT JOIN
[CRONUS UK Ltd_$Shpfy Shop$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Shop]
ON
[Shpfy FulFillment Order Header].[Shop Code] = [Shpfy Shop].[Code]
LEFT JOIN
[User] AS [User]
ON
[Shpfy FulFillment Order Header].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
[User] AS [User]
ON
[Shpfy FulFillment Order Header].[SystemModifiedBy] = [User].[User Security ID]Show/hide columns in Shpfy FulFillment Order Header table
| Field No. | Field Name | Field Caption | Class | Type | Length | SQL Column Name | SQL DataType |
|---|---|---|---|---|---|---|---|
| 1 | Shopify Fulfillment Order Id   | Shopify Fulfillment Order Id | Normal | BigInteger | 8 | Shopify Fulfillment Order Id | bigint |
| 2 | Shopify Order Id | Shopify Order Id | Normal | BigInteger | 8 | Shopify Order Id | bigint |
| 3 | Status | Status | Normal | Text | 50 | Status | nvarchar(100) |
| 4 | Shop Id | Shop Id | Normal | Integer | 4 | Shop Id | int |
| 5 | Shop Code | Shop Code | Normal | Code | 20 | Shop Code | nvarchar(40) |
Key to join to the Shpfy Shop table.Show/hide example querySELECT
[Shpfy FulFillment Order Header].[Shop Code]
,[Shpfy Shop].[Code]
FROM
[CRONUS UK Ltd_$Shpfy FulFillment Order Header$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy FulFillment Order Header]
LEFT JOIN
[CRONUS UK Ltd_$Shpfy Shop$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Shop]
ON
[Shpfy FulFillment Order Header].[Shop Code] = [Shpfy Shop].[Code] | |||||||
| 6 | Shopify Location Id | Shopify Location Id | Normal | BigInteger | 8 | Shopify Location Id | bigint |
| 7 | Updated At | Updated At | Normal | DateTime | 8 | Updated At | datetime |
| 8 | Shopify Order No. | Shopify Order No. | FlowField | Text | 50 | ||
| 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 FulFillment Order Header].[$systemCreatedBy]
,[User].[User Security ID]
FROM
[CRONUS UK Ltd_$Shpfy FulFillment Order Header$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy FulFillment Order Header]
LEFT JOIN
[User] AS [User]
ON
[Shpfy FulFillment Order 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 FulFillment Order Header].[$systemModifiedBy]
,[User].[User Security ID]
FROM
[CRONUS UK Ltd_$Shpfy FulFillment Order Header$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy FulFillment Order Header]
LEFT JOIN
[User] AS [User]
ON
[Shpfy FulFillment Order Header].[$systemModifiedBy] = [User].[User Security ID] | |||||||