---
title: "Table 30118 Shpfy Order Header"
author: "JOP-AL"
url: https://jonas-paprotka.de/ref/table/30118-shpfy-order-header/
type: table
id: 30118
name: "Shpfy Order Header"
app: "Shopify Connector"
namespace: Microsoft.Integration.Shopify
versions: "20-29"
build: 29.0.54011.55644
countries: "W1, DE, US"
source: "https://jonas-paprotka.de/ref/table/30118-shpfy-order-header/source/?v=27 https://jonas-paprotka.de/ref/table/30118-shpfy-order-header/source/?v=28 https://jonas-paprotka.de/ref/table/30118-shpfy-order-header/source/"
checked: 2026-11-20
changed: 2026-10-05
subject: "Microsoft Dynamics 365 Business Central"
license: "Metadata from Microsoft's symbol packages. AL source MIT, Copyright (c) Microsoft Corporation. Selection and wording © 2026 JOP-AL. https://jonas-paprotka.de/licenses/"
---

# Table 30118 Shpfy Order Header

JOP-AL, https://jonas-paprotka.de/ref/table/30118-shpfy-order-header/

| | |
| --- | --- |
| App | Shopify Connector |
| Namespace | Microsoft.Integration.Shopify |
| Versions | 20-29 |
| Minors | W1 20.1-29.0; DE 20.1-29.0; US 20.1-29.0, [every minor](https://jonas-paprotka.de/ref/table/30118-shpfy-order-header/editions.json) |
| Source file | src/Order handling/Tables/ShpfyOrderHeader.Table.al |

## Fields

| Id | Name | Type | Versions | Obsolete | Reason |
| --- | --- | --- | --- | --- | --- |
| 1 | Shopify Order Id | BigInteger | 20-29 | - | - |
| 2 | Email | Text[80] | 20-29 | - | - |
| 5 | Sell-to Address | Text[100] | 20-29 | - | - |
| 6 | Sell-to Address 2 | Text[100] | 20-29 | - | - |
| 7 | Sell-to City | Text[50] | 20-29 | - | - |
| 8 | Sell-to Post Code | Text[50] | 20-29 | - | - |
| 9 | Sell-to Country/Region Code | Code[20] | 20-29 | - | - |
| 10 | Sell-to Country/Region Name | Text[50] | 20-29 | - | - |
| 11 | Phone No. | Text[50] | 20-29 | - | - |
| 12 | Token | Text[50] | 20-29 | Removed 25.0 | Not available in GraphQL data. |
| 13 | Gateway | Text[50] | 20-29 | - | - |
| 14 | Sell-to First Name | Text[50] | 20-29 | - | - |
| 15 | Sell-to Last Name | Text[50] | 20-29 | - | - |
| 16 | Currency | Code[10] | 20-29 | Removed 25.0 | Replaced with the fields "Currency Code" and "Presentment Currency Code". |
| 17 | Cart Token | Text[50] | 20-29 | Removed 25.0 | Not available in GraphQL data. |
| 18 | Checkout Token | Text[50] | 20-29 | Removed 25.0 | Not available in GraphQL data. |
| 19 | Reference | Text[50] | 20-29 | Removed 25.0 | Not available in GraphQL data. |
| 21 | Risk Level | Enum Shpfy Risk Level | 20-29 | Removed 28.0 | This field is not imported. Use field "High Risk" field. |
| 22 | Fully Paid | Boolean | 20-29 | - | - |
| 23 | Processing Method | Enum Shpfy Processing Method | 20-29 | - | - |
| 24 | Checkout Id | BigInteger | 20-29 | - | - |
| 25 | Contact Email | Text[100] | 20-29 | Removed 25.0 | Not available in GraphQL data. |
| 26 | Total Tip Received | Decimal | 20-29 | - | - |
| 27 | Session Hash | Text[50] | 20-29 | Removed 25.0 | Not available in GraphQL data. |
| 48 | Ship-to First Name | Text[50] | 20-29 | - | - |
| 49 | Ship-to Last Name | Text[50] | 20-29 | - | - |
| 50 | Ship-to Name | Text[50] | 20-29 | - | - |
| 51 | Ship-to Address | Text[100] | 20-29 | - | - |
| 52 | Ship-to Address 2 | Text[100] | 20-29 | - | - |
| 53 | Ship-to City | Text[50] | 20-29 | - | - |
| 54 | Ship-to Post Code | Text[50] | 20-29 | - | - |
| 55 | Ship-to Country/Region Code | Code[20] | 20-29 | - | - |
| 56 | Ship-to Country/Region Name | Text[50] | 20-29 | - | - |
| 57 | Ship-to Latitude | Decimal | 20-29 | - | - |
| 58 | Ship-to Longitude | Decimal | 20-29 | - | - |
| 60 | Bill-to Name | Text[50] | 20-29 | - | - |
| 61 | Bill-to Address | Text[100] | 20-29 | - | - |
| 62 | Bill-to Address 2 | Text[100] | 20-29 | - | - |
| 63 | Bill-to City | Text[50] | 20-29 | - | - |
| 64 | Bill-to Post Code | Text[50] | 20-29 | - | - |
| 65 | Bill-to Country/Region Code | Code[20] | 20-29 | - | - |
| 66 | Bill-to Country/Region Name | Text[50] | 20-29 | - | - |
| 67 | Test | Boolean | 20-29 | - | - |
| 68 | Total Amount | Decimal | 20-29 | - | - |
| 69 | Subtotal Amount | Decimal | 20-29 | - | - |
| 70 | Total Weight | Decimal | 20-29 | - | - |
| 71 | VAT Amount | Decimal | 20-29 | - | - |
| 72 | VAT Included | Boolean | 20-29 | - | - |
| 73 | Currency Code | Code[10] | 20-29 | - | - |
| 74 | Financial Status | Enum Shpfy Financial Status | 20-29 | - | - |
| 75 | Confirmed | Boolean | 20-29 | - | - |
| 76 | Discount Amount | Decimal | 20-29 | - | - |
| 77 | Total Items Amount | Decimal | 20-29 | - | - |
| 78 | Fulfillment Status | Enum Shpfy Order Fulfill. Status | 20-29 | - | - |
| 79 | Buyer Accepts Marketing | Boolean | 20-29 | Removed 25.0 | Not available in GraphQL data. |
| 80 | Cancelled At | DateTime | 20-29 | - | - |
| 81 | Cancel Reason | Enum Shpfy Cancel Reason | 20-29 | - | - |
| 82 | Closed At | DateTime | 20-29 | - | - |
| 83 | Bill-to First Name | Text[50] | 20-29 | - | - |
| 84 | Bill-to Lastname | Text[50] | 20-29 | - | - |
| 87 | Processed At | DateTime | 20-29 | - | - |
| 89 | Shopify Order No. | Text[50] | 20-29 | - | - |
| 90 | Order Status URL | Text[250] | 20-29 | - | - |
| 91 | Created At | DateTime | 20-29 | - | - |
| 92 | Source Name | Code[20] | 20-29 | - | - |
| 93 | Updated At | DateTime | 20-29 | - | - |
| 94 | Shipping Charges Amount | Decimal | 20-29 | - | - |
| 95 | Document Date | Date | 20-29 | - | - |
| 96 | Sell-to County | Text[30] | 20-29 | - | - |
| 97 | Bill-to County | Text[30] | 20-29 | - | - |
| 98 | Ship-to County | Text[30] | 20-29 | - | - |
| 99 | Customer Id | BigInteger | 20-29 | - | - |
| 100 | Closed | Boolean | 20-29 | - | - |
| 101 | Location Id | BigInteger | 20-29 | Removed 28.0 | Location Id on Order Header is not used. Instead use Location Id on Order Lines. |
| 102 | Channel Name | Text[100] | 22-29 | - | - |
| 103 | App Name | Text[100] | 22-29 | - | - |
| 104 | Presentment Currency Code | Code[10] | 22-29 | - | - |
| 105 | Unpaid | Boolean | 22-29 | - | - |
| 106 | Discount Code | Code[20] | 22-29 | - | - |
| 107 | Discount Codes | Text[250] | 22-29 | - | - |
| 108 | Refundable | Boolean | 22-29 | - | - |
| 109 | Presentment Total Amount | Decimal | 22-29 | - | - |
| 110 | Presentment Subtotal Amount | Decimal | 22-29 | - | - |
| 111 | Presentment VAT Amount | Decimal | 22-29 | - | - |
| 112 | Presentment Discount Amount | Decimal | 22-29 | - | - |
| 113 | Presentment Total Tip Received | Decimal | 22-29 | - | - |
| 114 | Pres. Shipping Charges Amount | Decimal | 22-29 | - | - |
| 115 | Edited | Boolean | 22-29 | - | - |
| 116 | Return Status | Enum Shpfy Order Return Status | 23-29 | - | - |
| 117 | Company Id | BigInteger | 24-29 | - | - |
| 118 | Company Main Contact Id | BigInteger | 24-29 | - | - |
| 119 | Company Main Contact Email | Text[100] | 24-29 | - | - |
| 120 | Company Main Contact Phone No. | Text[50] | 24-29 | - | - |
| 121 | Company Main Contact Cust. Id | BigInteger | 24-29 | - | - |
| 122 | B2B | Boolean | 24-29 | - | - |
| 123 | Current Total Amount | Decimal | 24-29 | - | - |
| 124 | Current Total Items Quantity | Integer | 24-29 | - | - |
| 125 | Line Items Redundancy Code | Integer | 24-29 | - | - |
| 126 | PO Number | Text[512] | 24-29 | - | - |
| 127 | Company Location Id | BigInteger | 25-29 | - | - |
| 128 | High Risk | Boolean | 26-29 | - | - |
| 129 | Due Date | Date | 26-29 | - | - |
| 130 | Pres. Payment Rounding Amount | Decimal | 27-29 | - | - |
| 131 | Payment Rounding Amount | Decimal | 27-29 | - | - |
| 132 | Pres. Refund Rounding Amount | Decimal | 27-29 | - | - |
| 133 | Refund Rounding Amount | Decimal | 27-29 | - | - |
| 134 | Channel Liable Taxes | Boolean | 27-29 | - | - |
| 135 | Use Shopify Order No. | Boolean | 29 | - | - |
| 500 | Shop Code | Code[20] | 20-29 | - | - |
| 501 | Customer Template Code | Code[10] | 20-29 | Removed 25.0 | Replaced by Customer Templ. Code |
| 502 | Customer Templ. Code | Code[20] | 22-29 | - | - |
| 601 | Total Quantity of Items | Decimal | 20-29 | - | - |
| 602 | Number of Lines | Integer | 20-29 | - | - |
| 1000 | Sell-to Customer No. | Code[20] | 20-29 | - | - |
| 1001 | Sales Order No. | Code[20] | 20-29 | - | - |
| 1002 | Has Error | Boolean | 20-29 | - | - |
| 1003 | Error Message | Text[2048] | 20-29 | - | - |
| 1004 | Processed | Boolean | 20-29 | - | - |
| 1005 | Sell-to Customer Name | Text[50] | 20-29 | - | - |
| 1006 | Sales Invoice No. | Code[20] | 20-29 | - | - |
| 1007 | Work Description | Blob | 20-29 | - | - |
| 1008 | Sell-to Customer Name 2 | Text[50] | 20-29 | - | - |
| 1009 | Ship-to Name 2 | Text[50] | 20-29 | - | - |
| 1010 | Bill-to Name 2 | Text[50] | 20-29 | - | - |
| 1011 | Bill-to Customer No. | Code[20] | 20-29 | - | - |
| 1012 | Shipping Method Code | Code[10] | 20-29 | - | - |
| 1013 | Payment Method Code | Code[10] | 20-29 | - | - |
| 1014 | Sell-to Contact Name | Text[100] | 22-29 | - | - |
| 1015 | Bill-to Contact Name | Text[100] | 22-29 | - | - |
| 1016 | Ship-to Contact Name | Text[100] | 22-29 | - | - |
| 1017 | Sell-to Contact No. | Code[20] | 22-29 | - | - |
| 1018 | Bill-to Contact No. | Code[20] | 22-29 | - | - |
| 1019 | Ship-to Contact No. | Code[20] | 22-29 | - | - |
| 1020 | Has Order State Error | Boolean | 24-29 | - | - |
| 1021 | Shipping Agent Code | Code[10] | 25-29 | - | - |
| 1022 | Shipping Agent Service Code | Code[10] | 25-29 | - | - |
| 1023 | Retail Location Id | BigInteger | 28-29 | - | - |
| 1024 | Retail Location Name | Text[250] | 28-29 | - | - |
| 1030 | Payment Terms Type | Code[20] | 25-29 | - | - |
| 1040 | Payment Terms Name | Text[50] | 25-29 | - | - |
| 1050 | Salesperson Code | Code[20] | 27-29 | - | - |
| 1060 | Processed Currency Handling | Enum Shpfy Currency Handling | 28-29 | - | - |
| 1070 | Tax Area Code | Code[20] | 29 | - | - |
| 1080 | Tax Liable | Boolean | 29 | - | - |
| 1090 | Tax Exempt | Boolean | 29 | - | - |

## Keys

| Name | Fields | Sum fields | Versions |
| --- | --- | --- | --- |
| Key1, clustered | Shopify Order Id | - | 20-29 |
| Key2 | Shop Code, Processed | - | 22-29 |
| Key3 | Created At | - | 27-29 |

## Procedures

| Name | Parameters | Returns | Access | Versions | Obsolete | Reason |
| --- | --- | --- | --- | --- | --- | --- |
| GetWorkDescription | () | Text | internal | 20-29 | - | - |
| SetWorkDescription | (NewWorkDescription: Text) | - | internal | 20-29 | - | - |
| UpdateTags | (CommaSeperatedTags: Text) | - | internal | 20-29 | - | - |
| IsProcessed | () | Boolean | internal | 22-29 | - | - |
| IsPresentmentCurrencyOrder | () | Boolean | internal | 28-29 | - | - |
| LookupContactForCustomer | (CustomerNo: Code[20]; ContactNo: Code[20]; var Contact: Record Contact) | - | internal | 29 | - | - |

## Trigger events

| Name | Parameters | ElementName | Docs |
| --- | --- | --- | --- |
| OnBeforeInsertEvent | (var Rec: Record "Shpfy Order Header"; RunTrigger: Boolean) | '' | https://jonas-paprotka.de/docs/dev-itpro/developer/triggers-auto/events/table/devenv-onbeforeinsertevent-table-trigger/ |
| OnAfterInsertEvent | (var Rec: Record "Shpfy Order Header"; RunTrigger: Boolean) | '' | https://jonas-paprotka.de/docs/dev-itpro/developer/triggers-auto/events/table/devenv-onafterinsertevent-table-trigger/ |
| OnBeforeModifyEvent | (var Rec: Record "Shpfy Order Header"; var xRec: Record "Shpfy Order Header"; RunTrigger: Boolean) | '' | https://jonas-paprotka.de/docs/dev-itpro/developer/triggers-auto/events/table/devenv-onbeforemodifyevent-table-trigger/ |
| OnAfterModifyEvent | (var Rec: Record "Shpfy Order Header"; var xRec: Record "Shpfy Order Header"; RunTrigger: Boolean) | '' | https://jonas-paprotka.de/docs/dev-itpro/developer/triggers-auto/events/table/devenv-onaftermodifyevent-table-trigger/ |
| OnBeforeDeleteEvent | (var Rec: Record "Shpfy Order Header"; RunTrigger: Boolean) | '' | https://jonas-paprotka.de/docs/dev-itpro/developer/triggers-auto/events/table/devenv-onbeforedeleteevent-table-trigger/ |
| OnAfterDeleteEvent | (var Rec: Record "Shpfy Order Header"; RunTrigger: Boolean) | '' | https://jonas-paprotka.de/docs/dev-itpro/developer/triggers-auto/events/table/devenv-onafterdeleteevent-table-trigger/ |
| OnBeforeRenameEvent | (var Rec: Record "Shpfy Order Header"; var xRec: Record "Shpfy Order Header"; RunTrigger: Boolean) | '' | https://jonas-paprotka.de/docs/dev-itpro/developer/triggers-auto/events/table/devenv-onbeforerenameevent-table-trigger/ |
| OnAfterRenameEvent | (var Rec: Record "Shpfy Order Header"; var xRec: Record "Shpfy Order Header"; RunTrigger: Boolean) | '' | https://jonas-paprotka.de/docs/dev-itpro/developer/triggers-auto/events/table/devenv-onafterrenameevent-table-trigger/ |
| OnBeforeValidateEvent | (var Rec: Record "Shpfy Order Header"; var xRec: Record "Shpfy Order Header"; CurrFieldNo: Integer) | per field, ElementName: field name | https://jonas-paprotka.de/docs/dev-itpro/developer/triggers-auto/events/table/devenv-onbeforevalidateevent-table-trigger/ |
| OnAfterValidateEvent | (var Rec: Record "Shpfy Order Header"; var xRec: Record "Shpfy Order Header"; CurrFieldNo: Integer) | per field, ElementName: field name | https://jonas-paprotka.de/docs/dev-itpro/developer/triggers-auto/events/table/devenv-onaftervalidateevent-table-trigger/ |

## Source

Symbols: Microsoft.ShopifyConnector.symbols.ec255f57-31d0-4ca2-b751-f2fa7c745abb, https://dynamicssmb2.pkgs.visualstudio.com/DynamicsBCPublicFeeds/_packaging/MSSymbols/nuget/v3/index.json, highest build per major on 2026-11-20.
AL source 27: https://github.com/microsoft/BCApps, MIT, releases/27.x at ad459712441b2fe6cb0cf1c560563f8ec7188a93.
AL source 28: https://github.com/microsoft/BCApps, MIT, releases/28.x at 408a4cc8d3a4c54b60464cc14c964479facb9ba0.
AL source 29: https://github.com/microsoft/BCApps, MIT, releases/29.x at 4303e5e584d3aa5d9e98cbc615525a5396ad6ed7.

JOP-AL, 2026-11-20.
