Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/30111
Table Type: Company
Table Name: Shpfy Order Fulfillment
Database Table Name: CRONUS UK Ltd_$Shpfy Order Fulfillment$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 Order Fulfillment can be queried.
Show/hide an example select of all columns
SELECT
*
FROM
[CRONUS UK Ltd_$Shpfy Order Fulfillment$ec255f57-31d0-4ca2-b751-f2fa7c745abb]Show/hide an example select of all columns by name
SELECT
[Shopify Fulfillment Id]
,[Shopify Order Id]
,[Created At]
,[Updated At]
,[Tracking Number]
,[Tracking URL]
,[Status]
,[Tracking Company]
,[Name]
,[Notify Customer]
,[Test Case]
,[Authorization]
,[Service]
,[Shipment Status]
,[Tracking Numbers]
,[Tracking URLs]
,[Tracking Companies]
,[$systemId]
,[$systemCreatedAt]
,[$systemCreatedBy]
,[$systemModifiedAt]
,[$systemModifiedBy]
FROM
[CRONUS UK Ltd_$Shpfy Order Fulfillment$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 Order Fulfillment$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Order Fulfillment]
LEFT JOIN
[User] AS [User]
ON
[Shpfy Order Fulfillment].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
[User] AS [User]
ON
[Shpfy Order Fulfillment].[SystemModifiedBy] = [User].[User Security ID]Show/hide columns in Shpfy Order Fulfillment table
| Field No. | Field Name | Field Caption | Class | Type | Length | SQL Column Name | SQL DataType |
|---|---|---|---|---|---|---|---|
| 1 | Shopify Fulfillment Id  | Shopify Fulfillment Id | Normal | BigInteger | 8 | Shopify Fulfillment Id | bigint |
| 2 | Shopify Order Id  | Shopify Order Id | Normal | BigInteger | 8 | Shopify Order Id | bigint |
| 3 | Created At | Created At | Normal | DateTime | 8 | Created At | datetime |
| 4 | Updated At | Updated At | Normal | DateTime | 8 | Updated At | datetime |
| 5 | Tracking Number | Tracking Number | Normal | Text | 30 | Tracking Number | nvarchar(60) |
| 6 | Tracking URL | Tracking URL | Normal | Text | 250 | Tracking URL | nvarchar(500) |
| 7 | Status | Status | Normal | Option | 4 | Status | int |
Available options are:
| |||||||
| 8 | Tracking Company | Tracking Company | Normal | Text | 50 | Tracking Company | nvarchar(100) |
| 9 | Name | Name | Normal | Code | 20 | Name | nvarchar(40) |
| 10 | Notify Customer | Notify Customer | Normal | Boolean | 4 | Notify Customer | tinyint |
| 11 | Test Case | Test Case | Normal | Boolean | 4 | Test Case | tinyint |
| 12 | Authorization | Authorization Code | Normal | Code | 20 | Authorization | nvarchar(40) |
| 13 | Service | Service | Normal | Text | 30 | Service | nvarchar(60) |
| 14 | Shipment Status | Shipment Status | Normal | Option | 4 | Shipment Status | int |
Available options are:
| |||||||
| 15 | Tracking Numbers | Tracking Numbers | Normal | Text | 250 | Tracking Numbers | nvarchar(500) |
| 16 | Tracking URLs | Tracking URLs | Normal | Text | 2048 | Tracking URLs | nvarchar(4096) |
| 17 | Tracking Companies | Tracking Companies | Normal | Text | 2048 | Tracking Companies | nvarchar(4096) |
| 18 | Contains Gift Cards | Contains Gift Cards | 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 Order Fulfillment].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$Shpfy Order Fulfillment$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Order Fulfillment] LEFT JOIN [User] AS [User] ON [Shpfy Order Fulfillment].[$systemCreatedBy] = [User].[User Security ID] | |||||||
| 2000000003 | SystemModifiedAt | Modified At | Normal | DateTime | 8 | $systemModifiedAt | datetime |
| 2000000004 | SystemModifiedBy | Modified By | Normal | GUID | 16 | $systemModifiedBy | uniqueidentifier |