Shpfy Order Header

Dynamics 365 BC Table ReferenceTablesCompany TablesSShpfy Order Header

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

Table Type: Company

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

Table Number: 30118

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

Show/hide an example select of all columns

SELECT

   *

FROM

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

Show/hide an example select of all columns by name

SELECT

   [Shopify Order Id]
   ,[Email]
   ,[Sell-to Address]
   ,[Sell-to Address 2]
   ,[Sell-to City]
   ,[Sell-to Post Code]
   ,[Sell-to Country_Region Code]
   ,[Sell-to Country_Region Name]
   ,[Phone No_]
   ,[Token]
   ,[Gateway]
   ,[Sell-to First Name]
   ,[Sell-to Last Name]
   ,[Currency]
   ,[Cart Token]
   ,[Checkout Token]
   ,[Reference]
   ,[Risk Level]
   ,[Fully Paid]
   ,[Processing Method]
   ,[Checkout Id]
   ,[Contact Email]
   ,[Total Tip Received]
   ,[Session Hash]
   ,[Ship-to First Name]
   ,[Ship-to Last Name]
   ,[Ship-to Name]
   ,[Ship-to Address]
   ,[Ship-to Address 2]
   ,[Ship-to City]
   ,[Ship-to Post Code]
   ,[Ship-to Country_Region Code]
   ,[Ship-to Country_Region Name]
   ,[Ship-to Latitude]
   ,[Ship-to Longitude]
   ,[Bill-to Name]
   ,[Bill-to Address]
   ,[Bill-to Address 2]
   ,[Bill-to City]
   ,[Bill-to Post Code]
   ,[Bill-to Country_Region Code]
   ,[Bill-to Country_Region Name]
   ,[Test]
   ,[Total Amount]
   ,[Subtotal Amount]
   ,[Total Weight]
   ,[VAT Amount]
   ,[VAT Included]
   ,[Currency Code]
   ,[Financial Status]
   ,[Confirmed]
   ,[Discount Amount]
   ,[Total Items Amount]
   ,[Fulfillment Status]
   ,[Buyer Accepts Marketing]
   ,[Cancelled At]
   ,[Cancel Reason]
   ,[Closed At]
   ,[Bill-to First Name]
   ,[Bill-to Lastname]
   ,[Processed At]
   ,[Shopify Order No_]
   ,[Order Status URL]
   ,[Created At]
   ,[Source Name]
   ,[Updated At]
   ,[Shipping Charges Amount]
   ,[Document Date]
   ,[Sell-to County]
   ,[Bill-to County]
   ,[Ship-to County]
   ,[Customer Id]
   ,[Closed]
   ,[Location Id]
   ,[Channel Name]
   ,[App Name]
   ,[Presentment Currency Code]
   ,[Unpaid]
   ,[Discount Code]
   ,[Discount Codes]
   ,[Refundable]
   ,[Presentment Total Amount]
   ,[Presentment Subtotal Amount]
   ,[Presentment VAT Amount]
   ,[Presentment Discount Amount]
   ,[Presentment Total Tip Received]
   ,[Pres_ Shipping Charges Amount]
   ,[Edited]
   ,[Return Status]
   ,[Shop Code]
   ,[Customer Template Code]
   ,[Customer Templ_ Code]
   ,[Sell-to Customer No_]
   ,[Sales Order No_]
   ,[Has Error]
   ,[Error Message]
   ,[Processed]
   ,[Sell-to Customer Name]
   ,[Sales Invoice No_]
   ,[Work Description]
   ,[Sell-to Customer Name 2]
   ,[Ship-to Name 2]
   ,[Bill-to Name 2]
   ,[Bill-to Customer No_]
   ,[Shipping Method Code]
   ,[Payment Method Code]
   ,[Sell-to Contact Name]
   ,[Bill-to Contact Name]
   ,[Ship-to Contact Name]
   ,[Sell-to Contact No_]
   ,[Bill-to Contact No_]
   ,[Ship-to Contact No_]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Shpfy 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 Order Header$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Order Header]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Shpfy Order Header].[Sell-to City] = [Post Code].[City]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Shpfy Order Header].[Sell-to Post Code] = [Post Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Shpfy Transaction Gateway$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Transaction Gateway]
      ON
         [Shpfy Order Header].[Gateway] = [Shpfy Transaction Gateway].[Name]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Shpfy Order Header].[Ship-to City] = [Post Code].[City]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Shpfy Order Header].[Ship-to Post Code] = [Post Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
      ON
         [Shpfy Order Header].[Bill-to Name] = [Customer].[Name]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Shpfy Order Header].[Bill-to City] = [Post Code].[City]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Shpfy Order Header].[Bill-to Post Code] = [Post Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Shpfy Order Header].[Currency Code] = [Currency].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
      ON
         [Shpfy Order Header].[Customer Id] = [Customer].[$systemId]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Shpfy Order Header].[Location Id] = [Location].[$systemId]
LEFT JOIN
   [CRONUS UK Ltd_$Shpfy Shop$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Shop]
      ON
         [Shpfy Order Header].[Shop Code] = [Shpfy Shop].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
      ON
         [Shpfy Order Header].[Sell-to Customer Name] = [Customer].[Name]
LEFT JOIN
   [CRONUS UK Ltd_$Shipment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipment Method]
      ON
         [Shpfy Order Header].[Shipping Method Code] = [Shipment Method].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Payment Method$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Payment Method]
      ON
         [Shpfy Order Header].[Payment Method Code] = [Payment Method].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Shpfy Order Header].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Shpfy Order Header].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Shpfy Order Header table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Shopify Order Id Primary Key SearchShopify Order IdNormalBigInteger8Shopify Order Idbigint
2Email SearchEmailNormalText50Emailnvarchar(100)
5Sell-to Address SearchSell-to AddressNormalText100Sell-to Addressnvarchar(200)
6Sell-to Address 2 SearchSell-to Address 2NormalText100Sell-to Address 2nvarchar(200)
7Sell-to City SearchSell-to CityNormalText50Sell-to Citynvarchar(100)
Key to join to the Post Code table.

Show/hide example query

SELECT
       [Shpfy Order Header].[Sell-to City]
       ,[Post Code].[City]
FROM
       [CRONUS UK Ltd_$Shpfy Order Header$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Order Header]
LEFT JOIN
       [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
              ON
                     [Shpfy Order Header].[Sell-to City] = [Post Code].[City]
8Sell-to Post Code SearchSell-to ZIP CodeNormalText50Sell-to Post Codenvarchar(100)
Key to join to the Post Code table.

Show/hide example query

SELECT
       [Shpfy Order Header].[Sell-to Post Code]
       ,[Post Code].[Code]
FROM
       [CRONUS UK Ltd_$Shpfy Order Header$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Order Header]
LEFT JOIN
       [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
              ON
                     [Shpfy Order Header].[Sell-to Post Code] = [Post Code].[Code]
9Sell-to Country/Region Code SearchSell-to Country/Region CodeNormalCode20Sell-to Country_Region Codenvarchar(40)
Key to join to the Country/Region table.

Show/hide example query

SELECT
       [Shpfy Order Header].[Sell-to Country_Region Code]
       ,[Country/Region].[Code]
FROM
       [CRONUS UK Ltd_$Shpfy Order Header$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Order Header]
LEFT JOIN
       [CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country/Region]
              ON
                     [Shpfy Order Header].[Sell-to Country_Region Code] = [Country/Region].[Code]
10Sell-to Country/Region Name SearchSell-to Country/Region NameNormalText50Sell-to Country_Region Namenvarchar(100)
11Phone No. SearchPhone No.NormalText50Phone No_nvarchar(100)
12Token SearchTokenNormalText50Tokennvarchar(100)
13Gateway SearchGatewayNormalText50Gatewaynvarchar(100)
Key to join to the Shpfy Transaction Gateway table.

Show/hide example query

SELECT
       [Shpfy Order Header].[Gateway]
       ,[Shpfy Transaction Gateway].[Name]
FROM
       [CRONUS UK Ltd_$Shpfy Order Header$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Order Header]
LEFT JOIN
       [CRONUS UK Ltd_$Shpfy Transaction Gateway$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Transaction Gateway]
              ON
                     [Shpfy Order Header].[Gateway] = [Shpfy Transaction Gateway].[Name]
14Sell-to First Name SearchSell-to First NameNormalText50Sell-to First Namenvarchar(100)
15Sell-to Last Name SearchSell-to Last NameNormalText50Sell-to Last Namenvarchar(100)
16Currency SearchCurrencyNormalCode10Currencynvarchar(20)
17Cart Token SearchCart TokenNormalText50Cart Tokennvarchar(100)
18Checkout Token SearchCheckout TokenNormalText50Checkout Tokennvarchar(100)
19Reference SearchReferenceNormalText50Referencenvarchar(100)
21Risk Level SearchRisk LevelNormalOption4Risk Levelint
Available options are:
  • ” “
  • “Low”
  • “Medium”
  • “High”
22Fully Paid SearchFully PaidNormalBoolean4Fully Paidtinyint
23Processing Method SearchProcessing MethodNormalOption4Processing Methodint
Available options are:
  • “Checkout”
  • “Direct”
  • “Manual”
  • “Offsite”
  • “Express”
  • “Free”
  • “Unknown”
24Checkout Id SearchCheckout IdNormalBigInteger8Checkout Idbigint
25Contact Email SearchContact EmailNormalText100Contact Emailnvarchar(200)
26Total Tip Received SearchTotal Tip ReceivedNormalDecimal12Total Tip Receiveddecimal(38,38)
27Session Hash SearchSession HashNormalText50Session Hashnvarchar(100)
48Ship-to First Name SearchShip-to First NameNormalText50Ship-to First Namenvarchar(100)
49Ship-to Last Name SearchShip-to Last NameNormalText50Ship-to Last Namenvarchar(100)
50Ship-to Name SearchShip-to NameNormalText50Ship-to Namenvarchar(100)
51Ship-to Address SearchShip-to AddressNormalText100Ship-to Addressnvarchar(200)
52Ship-to Address 2 SearchShip-to Address 2NormalText100Ship-to Address 2nvarchar(200)
53Ship-to City SearchShip-to CityNormalText50Ship-to Citynvarchar(100)
Key to join to the Post Code table.

Show/hide example query

SELECT
       [Shpfy Order Header].[Ship-to City]
       ,[Post Code].[City]
FROM
       [CRONUS UK Ltd_$Shpfy Order Header$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Order Header]
LEFT JOIN
       [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
              ON
                     [Shpfy Order Header].[Ship-to City] = [Post Code].[City]
54Ship-to Post Code SearchShip-to ZIP CodeNormalText50Ship-to Post Codenvarchar(100)
Key to join to the Post Code table.

Show/hide example query

SELECT
       [Shpfy Order Header].[Ship-to Post Code]
       ,[Post Code].[Code]
FROM
       [CRONUS UK Ltd_$Shpfy Order Header$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Order Header]
LEFT JOIN
       [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
              ON
                     [Shpfy Order Header].[Ship-to Post Code] = [Post Code].[Code]
55Ship-to Country/Region Code SearchShip-to Country/Region CodeNormalCode20Ship-to Country_Region Codenvarchar(40)
Key to join to the Country/Region table.

Show/hide example query

SELECT
       [Shpfy Order Header].[Ship-to Country_Region Code]
       ,[Country/Region].[Code]
FROM
       [CRONUS UK Ltd_$Shpfy Order Header$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Order Header]
LEFT JOIN
       [CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country/Region]
              ON
                     [Shpfy Order Header].[Ship-to Country_Region Code] = [Country/Region].[Code]
56Ship-to Country/Region Name SearchShip-to Country/Region NameNormalText50Ship-to Country_Region Namenvarchar(100)
57Ship-to Latitude SearchShip-to LatitudeNormalDecimal12Ship-to Latitudedecimal(38,38)
58Ship-to Longitude SearchShip-to LongitudeNormalDecimal12Ship-to Longitudedecimal(38,38)
60Bill-to Name SearchBill-to NameNormalText50Bill-to Namenvarchar(100)
Key to join to the Customer table.

Show/hide example query

SELECT
       [Shpfy Order Header].[Bill-to Name]
       ,[Customer].[Name]
FROM
       [CRONUS UK Ltd_$Shpfy Order Header$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Order Header]
LEFT JOIN
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
              ON
                     [Shpfy Order Header].[Bill-to Name] = [Customer].[Name]
61Bill-to Address SearchBill-to AddressNormalText100Bill-to Addressnvarchar(200)
62Bill-to Address 2 SearchBill-to Address 2NormalText100Bill-to Address 2nvarchar(200)
63Bill-to City SearchBill-to CityNormalText50Bill-to Citynvarchar(100)
Key to join to the Post Code table.

Show/hide example query

SELECT
       [Shpfy Order Header].[Bill-to City]
       ,[Post Code].[City]
FROM
       [CRONUS UK Ltd_$Shpfy Order Header$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Order Header]
LEFT JOIN
       [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
              ON
                     [Shpfy Order Header].[Bill-to City] = [Post Code].[City]
64Bill-to Post Code SearchBill-to ZIP CodeNormalText50Bill-to Post Codenvarchar(100)
Key to join to the Post Code table.

Show/hide example query

SELECT
       [Shpfy Order Header].[Bill-to Post Code]
       ,[Post Code].[Code]
FROM
       [CRONUS UK Ltd_$Shpfy Order Header$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Order Header]
LEFT JOIN
       [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
              ON
                     [Shpfy Order Header].[Bill-to Post Code] = [Post Code].[Code]
65Bill-to Country/Region Code SearchBill-to Country/Region CodeNormalCode20Bill-to Country_Region Codenvarchar(40)
Key to join to the Country/Region table.

Show/hide example query

SELECT
       [Shpfy Order Header].[Bill-to Country_Region Code]
       ,[Country/Region].[Code]
FROM
       [CRONUS UK Ltd_$Shpfy Order Header$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Order Header]
LEFT JOIN
       [CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country/Region]
              ON
                     [Shpfy Order Header].[Bill-to Country_Region Code] = [Country/Region].[Code]
66Bill-to Country/Region Name SearchBill-to Country/Region NameNormalText50Bill-to Country_Region Namenvarchar(100)
67Test SearchTestNormalBoolean4Testtinyint
68Total Amount SearchTotal AmountNormalDecimal12Total Amountdecimal(38,38)
69Subtotal Amount SearchSubtotal AmountNormalDecimal12Subtotal Amountdecimal(38,38)
70Total Weight SearchTotal WeightNormalDecimal12Total Weightdecimal(38,38)
71VAT Amount SearchTax AmountNormalDecimal12VAT Amountdecimal(38,38)
72VAT Included SearchTax IncludedNormalBoolean4VAT Includedtinyint
73Currency Code SearchCurrency CodeNormalCode10Currency Codenvarchar(20)
Key to join to the Currency table.

Show/hide example query

SELECT
       [Shpfy Order Header].[Currency Code]
       ,[Currency].[Code]
FROM
       [CRONUS UK Ltd_$Shpfy Order Header$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Order Header]
LEFT JOIN
       [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
              ON
                     [Shpfy Order Header].[Currency Code] = [Currency].[Code]
74Financial Status SearchFinancial StatusNormalOption4Financial Statusint
Available options are:
  • ” “
  • “Pending”
  • “Authorized”
  • “Partially Paid”
  • “Paid”
  • “Partially Refunded”
  • “Refunded”
  • “Voided”
  • “Unknown”
75Confirmed SearchConfirmedNormalBoolean4Confirmedtinyint
76Discount Amount SearchDiscount AmountNormalDecimal12Discount Amountdecimal(38,38)
77Total Items Amount SearchTotal Items AmountNormalDecimal12Total Items Amountdecimal(38,38)
78Fulfillment Status SearchFulfillment StatusNormalOption4Fulfillment Statusint
Available options are:
  • ” “
  • “Fulfilled”
  • “In Progress”
  • “Open”
  • “Pending Fulfillment”
  • “Restocked”
  • “Unfulfilled”
  • “Partially Fulfilled”
79Buyer Accepts Marketing SearchBuyer Accepts MarketingNormalBoolean4Buyer Accepts Marketingtinyint
80Cancelled At SearchCanceled AtNormalDateTime8Cancelled Atdatetime
81Cancel Reason SearchCancel ReasonNormalOption4Cancel Reasonint
Available options are:
  • ” “
  • “Customer”
  • “Fraud”
  • “Inventory”
  • “Other”
  • “Unknown”
82Closed At SearchClosed AtNormalDateTime8Closed Atdatetime
83Bill-to First Name SearchBill-to First NameNormalText50Bill-to First Namenvarchar(100)
84Bill-to Lastname SearchBill-to Last NameNormalText50Bill-to Lastnamenvarchar(100)
87Processed At SearchProcessed AtNormalDateTime8Processed Atdatetime
89Shopify Order No. SearchShopify Order No.NormalText50Shopify Order No_nvarchar(100)
90Order Status URL SearchOrder Status URLNormalText250Order Status URLnvarchar(500)
91Created At SearchCreated AtNormalDateTime8Created Atdatetime
92Source Name SearchSource NameNormalCode20Source Namenvarchar(40)
93Updated At SearchUpdated AtNormalDateTime8Updated Atdatetime
94Shipping Charges Amount SearchShipping Charges AmountNormalDecimal12Shipping Charges Amountdecimal(38,38)
95Document Date SearchDocument DateNormalDate4Document Datedatetime
96Sell-to County SearchSell-to StateNormalText30Sell-to Countynvarchar(60)
97Bill-to County SearchBill-to StateNormalText30Bill-to Countynvarchar(60)
98Ship-to County SearchShip-to StateNormalText30Ship-to Countynvarchar(60)
99Customer Id SearchCustomer IdNormalBigInteger8Customer Idbigint
Key to join to the Customer table.

Show/hide example query

SELECT
       [Shpfy Order Header].[Customer Id]
       ,[Customer].[$systemId]
FROM
       [CRONUS UK Ltd_$Shpfy Order Header$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Order Header]
LEFT JOIN
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
              ON
                     [Shpfy Order Header].[Customer Id] = [Customer].[$systemId]
100Closed SearchClosedNormalBoolean4Closedtinyint
101Location Id SearchLocation IdNormalBigInteger8Location Idbigint
Key to join to the Location table.

Show/hide example query

SELECT
       [Shpfy Order Header].[Location Id]
       ,[Location].[$systemId]
FROM
       [CRONUS UK Ltd_$Shpfy Order Header$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Order Header]
LEFT JOIN
       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
              ON
                     [Shpfy Order Header].[Location Id] = [Location].[$systemId]
102Channel Name SearchChannel NameNormalText100Channel Namenvarchar(200)
103App Name SearchApp NameNormalText100App Namenvarchar(200)
104Presentment Currency Code SearchPresentment Currency CodeNormalCode10Presentment Currency Codenvarchar(20)
105Unpaid SearchUnpaidNormalBoolean4Unpaidtinyint
106Discount Code SearchDiscount CodeNormalCode20Discount Codenvarchar(40)
107Discount Codes SearchDiscount CodesNormalText250Discount Codesnvarchar(500)
108Refundable SearchRefundableNormalBoolean4Refundabletinyint
109Presentment Total Amount SearchPresentment Total AmountNormalDecimal12Presentment Total Amountdecimal(38,38)
110Presentment Subtotal Amount SearchPresentment Subtotal AmountNormalDecimal12Presentment Subtotal Amountdecimal(38,38)
111Presentment VAT Amount SearchPresentment Tax AmountNormalDecimal12Presentment VAT Amountdecimal(38,38)
112Presentment Discount Amount SearchDiscount AmountNormalDecimal12Presentment Discount Amountdecimal(38,38)
113Presentment Total Tip Received SearchPresentment Total Tip ReceivedNormalDecimal12Presentment Total Tip Receiveddecimal(38,38)
114Pres. Shipping Charges Amount SearchPresentment Shipping Charges AmountNormalDecimal12Pres_ Shipping Charges Amountdecimal(38,38)
115Edited SearchEditedNormalBoolean4Editedtinyint
116Return Status SearchReturn StatusNormalOption4Return Statusint
Available options are:
  • ” “
  • “Inspection Complete”
  • “In Progress”
  • “No Return”
  • “Returned”
  • “Return Failed”
  • “Return Requested”
500Shop Code SearchShop CodeNormalCode20Shop Codenvarchar(40)
Key to join to the Shpfy Shop table.

Show/hide example query

SELECT
       [Shpfy Order Header].[Shop Code]
       ,[Shpfy Shop].[Code]
FROM
       [CRONUS UK Ltd_$Shpfy Order Header$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Order Header]
LEFT JOIN
       [CRONUS UK Ltd_$Shpfy Shop$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Shop]
              ON
                     [Shpfy Order Header].[Shop Code] = [Shpfy Shop].[Code]
501Customer Template Code SearchCustomer Template CodeNormalCode10Customer Template Codenvarchar(20)
502Customer Templ. Code SearchCustomer Template CodeNormalCode20Customer Templ_ Codenvarchar(40)
Key to join to the Customer Templ. table.

Show/hide example query

SELECT
       [Shpfy Order Header].[Customer Templ_ Code]
       ,[Customer Templ.].[Code]
FROM
       [CRONUS UK Ltd_$Shpfy Order Header$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Order Header]
LEFT JOIN
       [CRONUS UK Ltd_$Customer Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Templ.]
              ON
                     [Shpfy Order Header].[Customer Templ_ Code] = [Customer Templ.].[Code]
601Total Quantity of Items SearchTotal Quantity of ItemsFlowFieldDecimal12
602Number of Lines SearchNumber of LinesFlowFieldInteger4
1000Sell-to Customer No. SearchSell-to Customer No.NormalCode20Sell-to Customer No_nvarchar(40)
Key to join to the Customer table.

Show/hide example query

SELECT
       [Shpfy Order Header].[Sell-to Customer No_]
       ,[Customer].[No_]
FROM
       [CRONUS UK Ltd_$Shpfy Order Header$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Order Header]
LEFT JOIN
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
              ON
                     [Shpfy Order Header].[Sell-to Customer No_] = [Customer].[No_]
1001Sales Order No. SearchSales Order No.NormalCode20Sales Order No_nvarchar(40)
1002Has Error SearchHas ErrorNormalBoolean4Has Errortinyint
1003Error Message SearchError MessageNormalText2048Error Messagenvarchar(4096)
1004Processed SearchProcessedNormalBoolean4Processedtinyint
1005Sell-to Customer Name SearchSell-to Customer NameNormalText50Sell-to Customer Namenvarchar(100)
Key to join to the Customer table.

Show/hide example query

SELECT
       [Shpfy Order Header].[Sell-to Customer Name]
       ,[Customer].[Name]
FROM
       [CRONUS UK Ltd_$Shpfy Order Header$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Order Header]
LEFT JOIN
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
              ON
                     [Shpfy Order Header].[Sell-to Customer Name] = [Customer].[Name]
1006Sales Invoice No. SearchSales Invoice No.NormalCode20Sales Invoice No_nvarchar(40)
Key to join to the Sales Invoice Header table.

Show/hide example query

SELECT
       [Shpfy Order Header].[Sales Invoice No_]
       ,[Sales Invoice Header].[No_]
FROM
       [CRONUS UK Ltd_$Shpfy Order Header$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Order Header]
LEFT JOIN
       [CRONUS UK Ltd_$Sales Invoice Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Invoice Header]
              ON
                     [Shpfy Order Header].[Sales Invoice No_] = [Sales Invoice Header].[No_]
1007Work Description SearchWork DescriptionNormalBLOB8Work Descriptionimage
1008Sell-to Customer Name 2 SearchSell-to Customer Name 2NormalText50Sell-to Customer Name 2nvarchar(100)
1009Ship-to Name 2 SearchShip-to Name 2NormalText50Ship-to Name 2nvarchar(100)
1010Bill-to Name 2 SearchBill-to Name 2NormalText50Bill-to Name 2nvarchar(100)
1011Bill-to Customer No. SearchBill-to Customer No.NormalCode20Bill-to Customer No_nvarchar(40)
Key to join to the Customer table.

Show/hide example query

SELECT
       [Shpfy Order Header].[Bill-to Customer No_]
       ,[Customer].[No_]
FROM
       [CRONUS UK Ltd_$Shpfy Order Header$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Order Header]
LEFT JOIN
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
              ON
                     [Shpfy Order Header].[Bill-to Customer No_] = [Customer].[No_]
1012Shipping Method Code SearchShipping Method CodeNormalCode10Shipping Method Codenvarchar(20)
Key to join to the Shipment Method table.

Show/hide example query

SELECT
       [Shpfy Order Header].[Shipping Method Code]
       ,[Shipment Method].[Code]
FROM
       [CRONUS UK Ltd_$Shpfy Order Header$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Order Header]
LEFT JOIN
       [CRONUS UK Ltd_$Shipment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipment Method]
              ON
                     [Shpfy Order Header].[Shipping Method Code] = [Shipment Method].[Code]
1013Payment Method Code SearchPayment Method CodeNormalCode10Payment Method Codenvarchar(20)
Key to join to the Payment Method table.

Show/hide example query

SELECT
       [Shpfy Order Header].[Payment Method Code]
       ,[Payment Method].[Code]
FROM
       [CRONUS UK Ltd_$Shpfy Order Header$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Order Header]
LEFT JOIN
       [CRONUS UK Ltd_$Payment Method$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Payment Method]
              ON
                     [Shpfy Order Header].[Payment Method Code] = [Payment Method].[Code]
1014Sell-to Contact Name SearchSell-to Contact NameNormalText100Sell-to Contact Namenvarchar(200)
1015Bill-to Contact Name SearchBill-to Contact NameNormalText100Bill-to Contact Namenvarchar(200)
1016Ship-to Contact Name SearchShip-to Contact NameNormalText100Ship-to Contact Namenvarchar(200)
1017Sell-to Contact No. SearchSell-to Contact No.NormalCode20Sell-to Contact No_nvarchar(40)
Key to join to the Contact table.

Show/hide example query

SELECT
       [Shpfy Order Header].[Sell-to Contact No_]
       ,[Contact].[No_]
FROM
       [CRONUS UK Ltd_$Shpfy Order Header$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Order Header]
LEFT JOIN
       [CRONUS UK Ltd_$Contact$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Contact]
              ON
                     [Shpfy Order Header].[Sell-to Contact No_] = [Contact].[No_]
1018Bill-to Contact No. SearchBill-to Contact No.NormalCode20Bill-to Contact No_nvarchar(40)
Key to join to the Contact table.

Show/hide example query

SELECT
       [Shpfy Order Header].[Bill-to Contact No_]
       ,[Contact].[No_]
FROM
       [CRONUS UK Ltd_$Shpfy Order Header$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Order Header]
LEFT JOIN
       [CRONUS UK Ltd_$Contact$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Contact]
              ON
                     [Shpfy Order Header].[Bill-to Contact No_] = [Contact].[No_]
1019Ship-to Contact No. SearchShip-to Contact No.NormalCode20Ship-to Contact No_nvarchar(40)
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 Order Header].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Shpfy Order Header$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Order Header]
LEFT JOIN
       [User] AS [User]
              ON
                     [Shpfy Order Header].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Shpfy Order Header].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Shpfy Order Header$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Order Header]
LEFT JOIN
       [User] AS [User]
              ON
                     [Shpfy Order Header].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from Shpfy Order Header table

CurrencyPayment Method
Dynamics 365 BC Table ReferenceTablesCompany TablesSShpfy Order Header

Leave a Reply

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