---
id: object/table/30118
type: object
title: Table 30118 "Shpfy Order Header"
summary: Table 30118 "Shpfy Order Header" in Shopify (Microsoft.Integration.Shopify). 145 fields, 6 public procedures. Introduced in BC29, still in BC30.
tier: official
language: en
tags:
  - table
  - shopify
versions:
  introduced: "29"
  last_changed: null
  deprecated: null
review:
  state: derived
  by: null
  at: null
  flags: []
generated:
  at: "2026-10-11T00:31:51.816Z"
  pipeline: 0.2.0
  prompts: {}
  input_hash: 3c03e94763965d92af5cb32f9d5feec7e818dbaf906a91b733bc4c8e9f6ae409
evidence:
  - kind: code
    url: https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Apps/W1/Shopify/app/src/Order%20handling/Tables/ShpfyOrderHeader.Table.al
    title: src/Apps/W1/Shopify/app/src/Order handling/Tables/ShpfyOrderHeader.Table.al (releases/29.x)
    date: null
    commit: ea08af5ef2d6a9b5c5af4a029288abbe2c883220
    t: null
    quote: null
links:
  learn:
    - https://learn.microsoft.com/dynamics365/business-central/shopify/synchronize-orders
    - https://learn.microsoft.com/dynamics365/business-central/shopify/walkthrough-setting-up-and-using-shopify
  objects: []
  features: []
  topics:
    - topic/business-central/business-functionality/online-store-with-shopify
    - topic/business-central/get-started/learn/business-process-walkthroughs
    - topic/dev-itpro/integration/integrating-with-shopify
  localizations: []
  videos: []
  posts: []
  guidelines: []
  changes:
    - change/bcapps/10619
    - change/bcapps/10407
    - change/bcapps/9253
object_type: table
object_id: 30118
name: Shpfy Order Header
caption: Shopify Order Header
namespace: Microsoft.Integration.Shopify
app: Shopify
extends: null
first_version: "29"
last_version: "30"
present_in:
  - "29"
  - "30"
changed_in: []
source_major: "29"
obsolete: null
countries: []
ms_search_form_ids: []
counts:
  fields: 145
  procedures: 9
  events: 0
  subscribers: 0
relations:
  out: 18
  referenced_by: 23
  pages: 4
  extended_by: 0
  event_subscribers: 0
  calls: 0
  called_by: 0
  implements: 0
---

# Table 30118 "Shpfy Order Header"

> Table 30118 "Shpfy Order Header" in Shopify (Microsoft.Integration.Shopify). 145 fields, 6 public procedures. Introduced in BC29, still in BC30.

Shopify · Microsoft.Integration.Shopify · captioned "Shopify Order Header" · BC29-30 · [source at ea08af5e](https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Apps/W1/Shopify/app/src/Order%20handling/Tables/ShpfyOrderHeader.Table.al) · facts from BC29

Learn documents this table through its pages: [Page 30113 "Shpfy Order"](../page/30113.md) (2 Learn pages), [Page 30115 "Shpfy Orders"](../page/30115.md) (2).

## Properties

| Property | Value |
|---|---|
| Caption | Shopify Order Header |
| DataClassification | SystemMetadata |

## Fields

Explanation: the field's ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.

| No. | Name | Type | Explanation | Notes |
|---|---|---|---|---|
| 1 | Shopify Order Id | BigInteger | — |  |
| 2 | Email | Text[80] | Specifies the customer's e-mail address. <small>via [Page 30113 "Shpfy Order"](../page/30113.md)</small> | DataClassification CustomerContent |
| 5 | Sell-to Address | Text[100] | Specifies the street address of the buy address. <small>via [Page 30113 "Shpfy Order"](../page/30113.md)</small> | DataClassification CustomerContent |
| 6 | Sell-to Address 2 | Text[100] | Specifies additional address information. <small>via [Page 30113 "Shpfy Order"](../page/30113.md)</small> | DataClassification CustomerContent |
| 7 | Sell-to City | Text[50] | Specifies the city, town, or village of the buy address. <small>via [Page 30113 "Shpfy Order"](../page/30113.md)</small> | DataClassification CustomerContent |
| 8 | Sell-to Post Code | Text[50] | Specifies the postal code of the buy address. <small>via [Page 30113 "Shpfy Order"](../page/30113.md)</small> | DataClassification CustomerContent |
| 9 | Sell-to Country/Region Code | Code[20] | Specifies country/region code of the buy address. <small>via [Page 30115 "Shpfy Orders"](../page/30115.md)</small> | DataClassification CustomerContent |
| 10 | Sell-to Country/Region Name | Text[50] | — | DataClassification CustomerContent |
| 11 | Phone No. | Text[50] | Specifies the phone number at the buy address. <small>via [Page 30113 "Shpfy Order"](../page/30113.md)</small> | DataClassification CustomerContent |
| 12 | Token | Text[50] | — | obsolete Removed 25.0; #if not CLEANSCHEMA25; not editable; DataClassification CustomerContent |
| 13 | Gateway | Text[50] | — | not editable; DataClassification CustomerContent |
| 14 | Sell-to First Name | Text[50] | — | DataClassification CustomerContent |
| 15 | Sell-to Last Name | Text[50] | — | DataClassification CustomerContent |
| 16 | Currency | Code[10] | — | obsolete Removed 25.0; #if not CLEANSCHEMA25; not editable; DataClassification Customercontent |
| 17 | Cart Token | Text[50] | — | obsolete Removed 25.0; #if not CLEANSCHEMA25; not editable; DataClassification CustomerContent |
| 18 | Checkout Token | Text[50] | — | obsolete Removed 25.0; #if not CLEANSCHEMA25; not editable; DataClassification CustomerContent |
| 19 | Reference | Text[50] | — | obsolete Removed 25.0; #if not CLEANSCHEMA25; not editable; DataClassification CustomerContent |
| 21 | Risk Level | Enum "Shpfy Risk Level" | — | obsolete Removed 28.0; #if not CLEANSCHEMA28; enum [Enum 30126 "Shpfy Risk Level"](../enum/30126.md); not editable |
| 22 | Fully Paid | Boolean | — | not editable |
| 23 | Processing Method | Enum "Shpfy Processing Method" | — | enum [Enum 30118 "Shpfy Processing Method"](../enum/30118.md); not editable |
| 24 | Checkout Id | BigInteger | — | not editable |
| 25 | Contact Email | Text[100] | — | obsolete Removed 25.0; #if not CLEANSCHEMA25; not editable; DataClassification CustomerContent |
| 26 | Total Tip Received | Decimal | — | not editable |
| 27 | Session Hash | Text[50] | — | obsolete Removed 25.0; #if not CLEANSCHEMA25; not editable |
| 48 | Ship-to First Name | Text[50] | — | DataClassification CustomerContent |
| 49 | Ship-to Last Name | Text[50] | — | DataClassification CustomerContent |
| 50 | Ship-to Name | Text[50] | Specifies the name that products on the sales order are shipped to. <small>via [Page 30113 "Shpfy Order"](../page/30113.md)</small> | DataClassification CustomerContent |
| 51 | Ship-to Address | Text[100] | Specifies the address that products on the sales order are shipped to. <small>via [Page 30113 "Shpfy Order"](../page/30113.md)</small> | DataClassification CustomerContent |
| 52 | Ship-to Address 2 | Text[100] | Specifies additional address information. <small>via [Page 30113 "Shpfy Order"](../page/30113.md)</small> | DataClassification CustomerContent |
| 53 | Ship-to City | Text[50] | Specifies the city of the customer that the products are shipped to. <small>via [Page 30113 "Shpfy Order"](../page/30113.md)</small> | DataClassification CustomerContent |
| 54 | Ship-to Post Code | Text[50] | Specifies the ZIP code of the address that the products are shipped to. <small>via [Page 30113 "Shpfy Order"](../page/30113.md)</small> | DataClassification CustomerContent |
| 55 | Ship-to Country/Region Code | Code[20] | Specifies the country/region code of the address that the items are shipped to. <small>via [Page 30113 "Shpfy Order"](../page/30113.md)</small> | DataClassification CustomerContent |
| 56 | Ship-to Country/Region Name | Text[50] | Specifies the name of the customer's country/region <small>via [Page 30113 "Shpfy Order"](../page/30113.md)</small> | DataClassification CustomerContent |
| 57 | Ship-to Latitude | Decimal | — | not editable; DataClassification CustomerContent |
| 58 | Ship-to Longitude | Decimal | — | not editable; DataClassification CustomerContent |
| 60 | Bill-to Name | Text[50] | Specifies the name of the customer that you sent the invoice or credit memo to. <small>via [Page 30113 "Shpfy Order"](../page/30113.md)</small> | DataClassification CustomerContent |
| 61 | Bill-to Address | Text[100] | Specifies the address of the customer that you sent the invoice or credit memo to. <small>via [Page 30113 "Shpfy Order"](../page/30113.md)</small> | DataClassification CustomerContent |
| 62 | Bill-to Address 2 | Text[100] | Specifies additional address information. <small>via [Page 30113 "Shpfy Order"](../page/30113.md)</small> | DataClassification CustomerContent |
| 63 | Bill-to City | Text[50] | Specifies the city of the customer that you sent the invoice or credit memo to. <small>via [Page 30113 "Shpfy Order"](../page/30113.md)</small> | DataClassification CustomerContent |
| 64 | Bill-to Post Code | Text[50] | Specifies the post code of the customer that you sent the invoice or credit memo to. <small>via [Page 30113 "Shpfy Order"](../page/30113.md)</small> | DataClassification CustomerContent |
| 65 | Bill-to Country/Region Code | Code[20] | Specifies the country/region code of the customer that you sent the invoice or credit memo to. <small>via [Page 30113 "Shpfy Order"](../page/30113.md)</small> | DataClassification CustomerContent |
| 66 | Bill-to Country/Region Name | Text[50] | Specifies the name of the customer's country/region. <small>via [Page 30113 "Shpfy Order"](../page/30113.md)</small> | DataClassification CustomerContent |
| 67 | Test | Boolean | Specifies whether this is a test order. <small>via [Page 30113 "Shpfy Order"](../page/30113.md)</small> |  |
| 68 | Total Amount | Decimal | Specifies the sum of the line amounts on all lines in the document minus any discount amounts plus the shipping costs. <small>via [Page 30113 "Shpfy Order"](../page/30113.md)</small> |  |
| 69 | Subtotal Amount | Decimal | Specifies the sum of the line amounts on all lines in the document minus any discount amounts. <small>via [Page 30113 "Shpfy Order"](../page/30113.md)</small> |  |
| 70 | Total Weight | Decimal | — |  |
| 71 | VAT Amount | Decimal | Specifies the sum of tax amounts on all lines in the document. <small>via [Page 30113 "Shpfy Order"](../page/30113.md)</small> |  |
| 72 | VAT Included | Boolean | Specifies if tax is included in the unit price. <small>via [Page 30113 "Shpfy Order"](../page/30113.md)</small> |  |
| 73 | Currency Code | Code[10] | Specifies the currency of amounts on the document. <small>via [Page 30113 "Shpfy Order"](../page/30113.md)</small> |  |
| 74 | Financial Status | Enum "Shpfy Financial Status" | Specifies the status of payments associated with the order. Valid values are: pending, authorized, partially paid, paid, partially refunded, refunded, voided. <small>via [Page 30113 "Shpfy Order"](../page/30113.md)</small> | enum [Enum 30117 "Shpfy Financial Status"](../enum/30117.md); not editable |
| 75 | Confirmed | Boolean | Specifies whether the order has been confirmed. <small>via [Page 30113 "Shpfy Order"](../page/30113.md)</small> |  |
| 76 | Discount Amount | Decimal | Specifies the sum of all discount amount on all lines in the document. <small>via [Page 30113 "Shpfy Order"](../page/30113.md)</small> |  |
| 77 | Total Items Amount | Decimal | — |  |
| 78 | Fulfillment Status | Enum "Shpfy Order Fulfill. Status" | Specifies the order's status in terms of fulfilled line items. Valid values are: fulfilled, in progress, open, pending fulfillment, restocked, unfulfilled, partially fulfilled, on hold. <small>via [Page 30113 "Shpfy Order"](../page/30113.md)</small> | enum [Enum 30113 "Shpfy Order Fulfill. Status"](../enum/30113.md); not editable |
| 79 | Buyer Accepts Marketing | Boolean | — | obsolete Removed 25.0; #if not CLEANSCHEMA25 |
| 80 | Cancelled At | DateTime | Specifies the date and time when the order was cancelled. <small>via [Page 30113 "Shpfy Order"](../page/30113.md)</small> | not editable |
| 81 | Cancel Reason | Enum "Shpfy Cancel Reason" | Specifies the reason why the order was cancelled. Valid values are: customer, fraud, inventory, declined, other. <small>via [Page 30113 "Shpfy Order"](../page/30113.md)</small> | enum [Enum 30116 "Shpfy Cancel Reason"](../enum/30116.md); not editable |
| 82 | Closed At | DateTime | Closed At (Shopify) <small>caption</small> | not editable |
| 83 | Bill-to First Name | Text[50] | — | DataClassification CustomerContent |
| 84 | Bill-to Lastname | Text[50] | Bill-to Last Name <small>caption</small> | DataClassification CustomerContent |
| 87 | Processed At | DateTime | Processed At (Shopify) <small>caption</small> |  |
| 89 | Shopify Order No. | Text[50] | Specifies the order number from Shopify. <small>via [Page 30113 "Shpfy Order"](../page/30113.md)</small> |  |
| 90 | Order Status URL | Text[250] | — |  |
| 91 | Created At | DateTime | Specifies the autogenerated date and time when the order was created in Shopify. <small>via [Page 30113 "Shpfy Order"](../page/30113.md)</small> |  |
| 92 | Source Name | Code[20] | Specifies where the order is originated. Example values: web, pos, iphone, android. <small>via [Page 30113 "Shpfy Order"](../page/30113.md)</small> | not editable |
| 93 | Updated At | DateTime | Specifies the date and time when the order was last modified in Shopify. <small>via [Page 30113 "Shpfy Order"](../page/30113.md)</small> |  |
| 94 | Shipping Charges Amount | Decimal | Specifies the amount of the shipping cost. <small>via [Page 30113 "Shpfy Order"](../page/30113.md)</small> |  |
| 95 | Document Date | Date | Specifies the date when the related document was created. <small>via [Page 30113 "Shpfy Order"](../page/30113.md)</small> |  |
| 96 | Sell-to County | Text[30] | — | DataClassification CustomerContent |
| 97 | Bill-to County | Text[30] | — | DataClassification CustomerContent |
| 98 | Ship-to County | Text[30] | — | DataClassification CustomerContent |
| 99 | Customer Id | BigInteger | — | DataClassification CustomerContent |
| 100 | Closed | Boolean | Specifies if the Shopify order is archived by D365BC. <small>via [Page 30113 "Shpfy Order"](../page/30113.md)</small> | not editable |
| 101 | Location Id | BigInteger | — | obsolete Removed 28.0; #if not CLEANSCHEMA28; not editable; DataClassification CustomerContent |
| 102 | Channel Name | Text[100] | Specifies the name of the channel where you sell your products. A channel can be a platform or a marketplace such as an online store or POS. <small>via [Page 30113 "Shpfy Order"](../page/30113.md)</small> | not editable |
| 103 | App Name | Text[100] | Specifies the name of the app used by the channel where you sell your products. A channel can be a platform or a marketplace such as an online store or POS. <small>via [Page 30113 "Shpfy Order"](../page/30113.md)</small> | not editable |
| 104 | Presentment Currency Code | Code[10] | Specifies the presentment currency of amounts on the document. | not editable |
| 105 | Unpaid | Boolean | — | not editable |
| 106 | Discount Code | Code[20] | — | not editable |
| 107 | Discount Codes | Text[250] | — | not editable |
| 108 | Refundable | Boolean | — | not editable |
| 109 | Presentment Total Amount | Decimal | Specifies the sum of the line amounts on all lines in the document minus any discount amounts plus the shipping costs in presentment currency. |  |
| 110 | Presentment Subtotal Amount | Decimal | Specifies the sum of the line amounts on all lines in the document minus any discount amounts in presentment currency. |  |
| 111 | Presentment VAT Amount | Decimal | Specifies the sum of the line amounts on all lines in the document minus any discount amounts plus the shipping costs in presentment currency. |  |
| 112 | Presentment Discount Amount | Decimal | Specifies the sum of all discount amount on all lines in the document in presentment currency. |  |
| 113 | Presentment Total Tip Received | Decimal | — |  |
| 114 | Pres. Shipping Charges Amount | Decimal | Specifies the amount of the shipping cost in presentment currency. |  |
| 115 | Edited | Boolean | Specifies whether the order has had any edits applied. <small>via [Page 30113 "Shpfy Order"](../page/30113.md)</small> |  |
| 116 | Return Status | Enum "Shpfy Order Return Status" | Specifies the status or returns assocuated with the order. Valid values are: inspection complete, in progress, no return, returned, return failed, return requested. <small>via [Page 30113 "Shpfy Order"](../page/30113.md)</small> | enum [Enum 30145 "Shpfy Order Return Status"](../enum/30145.md) |
| 117 | Company Id | BigInteger | — |  |
| 118 | Company Main Contact Id | BigInteger | — |  |
| 119 | Company Main Contact Email | Text[100] | — |  |
| 120 | Company Main Contact Phone No. | Text[50] | — |  |
| 121 | Company Main Contact Cust. Id | BigInteger | Company Main Contact Customer Id <small>caption</small> |  |
| 122 | B2B | Boolean | — |  |
| 123 | Current Total Amount | Decimal | — |  |
| 124 | Current Total Items Quantity | Integer | — |  |
| 125 | Line Items Redundancy Code | Integer | — |  |
| 126 | PO Number | Text[512] | Specifies the purchase order number that is associated with the Shopify order. <small>via [Page 30113 "Shpfy Order"](../page/30113.md)</small> |  |
| 127 | Company Location Id | BigInteger | — |  |
| 128 | High Risk | Boolean | Specifies if the order is considered high risk. <small>via [Page 30113 "Shpfy Order"](../page/30113.md)</small> | FlowField: exist("Shpfy Order Risk" where("Order Id" = field("Shopify Order Id"), Level = const(High))) |
| 129 | Due Date | Date | — | DataClassification CustomerContent |
| 130 | Pres. Payment Rounding Amount | Decimal | Specifies the amount of presentment rounding applied to the total amount of the document. <small>via [Page 30172 "Shpfy Order Totals FactBox"](../page/30172.md)</small> |  |
| 131 | Payment Rounding Amount | Decimal | Specifies the amount of rounding applied to the total amount of the document. <small>via [Page 30113 "Shpfy Order"](../page/30113.md)</small> |  |
| 132 | Pres. Refund Rounding Amount | Decimal | Presentment Refund Rounding Amount <small>caption</small> |  |
| 133 | Refund Rounding Amount | Decimal | — |  |
| 134 | Channel Liable Taxes | Boolean | Specifies if any tax line on the order is liable to be charged by the sales channel. <small>via [Page 30113 "Shpfy Order"](../page/30113.md)</small> | FlowField: exist("Shpfy Order Tax Line" where("Parent Id" = field("Shopify Order Id"), "Channel Liable" = const(true))); not editable |
| 135 | Use Shopify Order No. | Boolean | Specifies whether the Shopify order number is used as the document number for this specific order. |  |
| 500 | Shop Code | Code[20] | Specifies the Shopify Shop from which the order originated. <small>via [Page 30113 "Shpfy Order"](../page/30113.md)</small> | TableRelation [Table 30102 "Shpfy Shop"](../table/30102.md) (Shpfy Shop) |
| 501 | Customer Template Code | Code[10] | — | obsolete Removed 25.0; #if not CLEANSCHEMA25; TableRelation [Table 8618 "Config. Template Header"](../table/8618.md) ("Config. Template Header".Code where("Table Id" = const(18))) |
| 502 | Customer Templ. Code | Code[20] | Specifies the code for the template to create a new customer. <small>via [Page 30113 "Shpfy Order"](../page/30113.md)</small> | TableRelation [Table 1381 "Customer Templ."](../table/1381.md) ("Customer Templ.".Code) |
| 601 | Total Quantity of Items | Decimal | — | FlowField: sum("Shpfy Order Line".Quantity where("Shopify Order Id" = field("Shopify Order Id"), "Gift Card" = const(false), Tip = const(false))) |
| 602 | Number of Lines | Integer | — | FlowField: count("Shpfy Order Line" where("Shopify Order Id" = field("Shopify Order Id"))) |
| 1000 | Sell-to Customer No. | Code[20] | Specifies the number of the customer who will buy the products. <small>via [Page 30113 "Shpfy Order"](../page/30113.md)</small> | TableRelation [Table 18 "Customer"](../table/18.md) |
| 1001 | Sales Order No. | Code[20] | Specifies the sales order number that has been created for the Shopify Order. <small>via [Page 30113 "Shpfy Order"](../page/30113.md)</small> | TableRelation [Table 36 "Sales Header"](../table/36.md) ("Sales Header"."No." where("Document Type" = const(Order))) |
| 1002 | Has Error | Boolean | Specifies whether there is an error when creating a sales document. <small>via [Page 30113 "Shpfy Order"](../page/30113.md)</small> |  |
| 1003 | Error Message | Text[2048] | Specifies the error message if an error has occurred. <small>via [Page 30113 "Shpfy Order"](../page/30113.md)</small> |  |
| 1004 | Processed | Boolean | Specifies whether a sales order has been created for the Shopify Order. <small>via [Page 30113 "Shpfy Order"](../page/30113.md)</small> |  |
| 1005 | Sell-to Customer Name | Text[50] | Specifies the name of the customer who will buy the products. <small>via [Page 30113 "Shpfy Order"](../page/30113.md)</small> | DataClassification CustomerContent |
| 1006 | Sales Invoice No. | Code[20] | Specifies the sales invoice number that has been created for the Shopify Order. <small>via [Page 30113 "Shpfy Order"](../page/30113.md)</small> | TableRelation [Table 36 "Sales Header"](../table/36.md) ("Sales Header"."No." where("Document Type" = const(Invoice))) |
| 1007 | Work Description | Blob | — |  |
| 1008 | Sell-to Customer Name 2 | Text[50] | — | DataClassification CustomerContent |
| 1009 | Ship-to Name 2 | Text[50] | — | DataClassification CustomerContent |
| 1010 | Bill-to Name 2 | Text[50] | — | DataClassification CustomerContent |
| 1011 | Bill-to Customer No. | Code[20] | Specifies the number of the customer that you sent the invoice or credit memo to. <small>via [Page 30113 "Shpfy Order"](../page/30113.md)</small> | TableRelation [Table 18 "Customer"](../table/18.md); DataClassification CustomerContent |
| 1012 | Shipping Method Code | Code[10] | Specifies how items on the Shopify Order are shipped to the customer. <small>via [Page 30113 "Shpfy Order"](../page/30113.md)</small> | TableRelation [Table 10 "Shipment Method"](../table/10.md) (Shipment Method); DataClassification CustomerContent |
| 1013 | Payment Method Code | Code[10] | Specifies how to make a payment, such as with bank transfer, cash, or check. <small>via [Page 30113 "Shpfy Order"](../page/30113.md)</small> | TableRelation [Table 289 "Payment Method"](../table/289.md) (Payment Method); DataClassification CustomerContent |
| 1014 | Sell-to Contact Name | Text[100] | — | DataClassification CustomerContent |
| 1015 | Bill-to Contact Name | Text[100] | — | DataClassification CustomerContent |
| 1016 | Ship-to Contact Name | Text[100] | — | DataClassification CustomerContent |
| 1017 | Sell-to Contact No. | Code[20] | Specifies the number of the contact person at the sell-to customer. <small>via [Page 30113 "Shpfy Order"](../page/30113.md)</small> | DataClassification CustomerContent |
| 1018 | Bill-to Contact No. | Code[20] | Specifies the number of the contact person at the bill-to customer. <small>via [Page 30113 "Shpfy Order"](../page/30113.md)</small> | DataClassification CustomerContent |
| 1019 | Ship-to Contact No. | Code[20] | Specifies the number of the contact person at the ship-to address. <small>via [Page 30113 "Shpfy Order"](../page/30113.md)</small> | DataClassification CustomerContent |
| 1020 | Has Order State Error | Boolean | — |  |
| 1021 | Shipping Agent Code | Code[10] | Specifies which shipping agent is used to transport the items on the Shopify Order to the customer. <small>via [Page 30113 "Shpfy Order"](../page/30113.md)</small> | TableRelation [Table 291 "Shipping Agent"](../table/291.md) (Shipping Agent) |
| 1022 | Shipping Agent Service Code | Code[10] | Specifies the code that represents the default shipping agent service you are using for this Shopify Order. <small>via [Page 30113 "Shpfy Order"](../page/30113.md)</small> | TableRelation [Table 5790 "Shipping Agent Services"](../table/5790.md) ("Shipping Agent Services".Code where("Shipping Agent Code" = field("Shipping Agent Code"))) |
| 1023 | Retail Location Id | BigInteger | — | not editable |
| 1024 | Retail Location Name | Text[250] | — | not editable |
| 1030 | Payment Terms Type | Code[20] | — | DataClassification CustomerContent |
| 1040 | Payment Terms Name | Text[50] | — | DataClassification CustomerContent |
| 1050 | Salesperson Code | Code[20] | Specifies the name of the salesperson who is assigned to the customer. <small>via [Page 30113 "Shpfy Order"](../page/30113.md)</small> | DataClassification CustomerContent |
| 1060 | Processed Currency Handling | Enum "Shpfy Currency Handling" | Specifies how the currency was handled when processing the order. <small>via [Page 30113 "Shpfy Order"](../page/30113.md)</small> | enum [Enum 30171 "Shpfy Currency Handling"](../enum/30171.md); not editable |
| 1070 | Tax Area Code | Code[20] | Specifies the tax area code for the order. This determines which tax jurisdictions apply when creating the sales document. <small>via [Page 30113 "Shpfy Order"](../page/30113.md)</small> | TableRelation [Table 318 "Tax Area"](../table/318.md) (Tax Area); DataClassification CustomerContent |
| 1080 | Tax Liable | Boolean | Specifies whether the order is liable for sales tax. When set, this value is carried to the sales document. <small>via [Page 30113 "Shpfy Order"](../page/30113.md)</small> | DataClassification CustomerContent |
| 1090 | Tax Exempt | Boolean | Specifies whether this Shopify order is exempt from tax (e.g. tax was disabled at POS). <small>via [Page 30113 "Shpfy Order"](../page/30113.md)</small> | not editable; DataClassification CustomerContent |

## Keys

- Key1: Shopify Order Id (clustered)
- Key2: Shop Code, Processed
- Key3: Created At
- Key4: Has Order State Error

## Procedures

- `GetWorkDescription(): Text` (internal): Get Work Description.
- `SetWorkDescription(NewWorkDescription: Text)` (internal): Set Work Description.
- `UpdateTags(CommaSeperatedTags: Text)` (internal): Update Tags.
- `IsProcessed(): Boolean` (internal)
- `IsPresentmentCurrencyOrder(): Boolean` (internal)
- `LookupContactForCustomer(CustomerNo: Code[20]; ContactNo: Code[20]; var Contact: Record Contact)` (internal)

Plus 3 local procedures.

## Triggers

OnDelete

## Relations

- drill-down page [Page 30115 "Shpfy Orders"](../page/30115.md)
- lookup page [Page 30115 "Shpfy Orders"](../page/30115.md)
- Shipping Method Code: TableRelation [Table 10 "Shipment Method"](../table/10.md)
- Customer Templ. Code: TableRelation [Table 1381 "Customer Templ."](../table/1381.md)
- Bill-to Customer No.: TableRelation [Table 18 "Customer"](../table/18.md)
- Sell-to Customer No.: TableRelation [Table 18 "Customer"](../table/18.md)
- Payment Method Code: TableRelation [Table 289 "Payment Method"](../table/289.md)
- Shipping Agent Code: TableRelation [Table 291 "Shipping Agent"](../table/291.md)
- Shop Code: TableRelation [Table 30102 "Shpfy Shop"](../table/30102.md)
- Number of Lines: CalcFormula [Table 30119 "Shpfy Order Line"](../table/30119.md)
- Total Quantity of Items: CalcFormula [Table 30119 "Shpfy Order Line"](../table/30119.md)
- Channel Liable Taxes: CalcFormula [Table 30122 "Shpfy Order Tax Line"](../table/30122.md)
- High Risk: CalcFormula [Table 30123 "Shpfy Order Risk"](../table/30123.md)
- Tax Area Code: TableRelation [Table 318 "Tax Area"](../table/318.md)
- Sales Invoice No.: TableRelation [Table 36 "Sales Header"](../table/36.md)
- Sales Order No.: TableRelation [Table 36 "Sales Header"](../table/36.md)
- Shipping Agent Service Code: TableRelation [Table 5790 "Shipping Agent Services"](../table/5790.md)
- Customer Template Code: TableRelation [Table 8618 "Config. Template Header"](../table/8618.md)

## Referenced by

23 fields in 9 objects relate to this table (TableRelation or CalcFormula).

- [Table 30142 "Shpfy Refund Header"](../table/30142.md): Bill-to Customer Name, Bill-to Customer No., Sell-to Customer Name, Sell-to Customer No., Shopify Order No., Tax Area Code, Tax Exempt, Tax Liable
- [Table 30147 "Shpfy Return Header"](../table/30147.md): Bill-to Customer Name, Bill-to Customer No., Sell-to Customer Name, Sell-to Customer No., Shopify Order No., Order Id
- [Table 30100 "Shpfy Cue"](../table/30100.md): Unprocessed Order Updates, Unprocessed Orders
- [Table 30133 "Shpfy Order Transaction"](../table/30133.md): Shop Code, Shpfy Order No.
- [Table 30139 "Shpfy Fulfillment Line"](../table/30139.md): Order Id
- [Table 30143 "Shpfy FulFillment Order Header"](../table/30143.md): Shopify Order No.
- [Table 30154 "Shpfy Suggest Payment"](../table/30154.md): Shpfy Order No.
- [Table 30155 "Shpfy Dispute"](../table/30155.md): Source Order Id
- [Table extension 30101 "Shpfy Sales Header"](../tableextension/30101.md): Shpfy Risk Level

## Pages and codeunits on this table

- [Page 30113 "Shpfy Order"](../page/30113.md) (source table)
- [Page 30115 "Shpfy Orders"](../page/30115.md) (source table)
- [Page 30160 "Shpfy Cancel Order"](../page/30160.md) (source table)
- [Page 30172 "Shpfy Order Totals FactBox"](../page/30172.md) (source table)
- [Codeunit 30166 "Shpfy Process Order"](../codeunit/30166.md) (codeunit runs on it)

## Recent changes

- 2026-08-28 [#10619 [Shopify] Index Has Order State Error to fix slow Shopify Activities cue](../../changes/bcapps/10619.md) (main, BC30, performance)
- 2026-08-20 [#10407 Shopify connector: persist order Tax Area Code, Tax Liable, and Tax Exempt (stack 1/3)](../../changes/bcapps/10407.md) (main, BC30, feature)
- 2026-07-09 [#9253 [Shopify] Disambiguate Shopify timestamp field captions and tooltips](../../changes/bcapps/9253.md) (main, BC30, fix)

## Across versions

- Present in: BC29-30
- Changed (declaration) in: none

## Deprecations

- field Buyer Accepts Marketing: Removed 25.0 (#if not CLEANSCHEMA25), "Not available in GraphQL data."
- field Cart Token: Removed 25.0 (#if not CLEANSCHEMA25), "Not available in GraphQL data."
- field Checkout Token: Removed 25.0 (#if not CLEANSCHEMA25), "Not available in GraphQL data."
- field Contact Email: Removed 25.0 (#if not CLEANSCHEMA25), "Not available in GraphQL data."
- field Currency: Removed 25.0 (#if not CLEANSCHEMA25), "Replaced with the fields "Currency Code" and "Presentment Currency Code"."
- field Customer Template Code: Removed 25.0 (#if not CLEANSCHEMA25), "Replaced by Customer Templ. Code"
- field Reference: Removed 25.0 (#if not CLEANSCHEMA25), "Not available in GraphQL data."
- field Session Hash: Removed 25.0 (#if not CLEANSCHEMA25), "Not available in GraphQL data."
- field Token: Removed 25.0 (#if not CLEANSCHEMA25), "Not available in GraphQL data."
- field Location Id: Removed 28.0 (#if not CLEANSCHEMA28), "Location Id on Order Header is not used. Instead use Location Id on Order Lines."
- field Risk Level: Removed 28.0 (#if not CLEANSCHEMA28), "This field is not imported. Use field "High Risk" field."

Source: AL metadata extracted from the code (names, ids, signatures, properties); no code bodies (D10).

## Ask your agent

Procedure bodies are not stored here (D10). For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: `bcatlas_resolve_node(object_type: "table", object_name: "Shpfy Order Header")`, then `bcatlas_get_procedure_body` or `bcatlas_get_neighbors` on the returned id.