Table 30118 "Shpfy Order Header"

Shopify · Microsoft.Integration.Shopify · captioned “Shopify Order Header” · BC29-30 · source at ea08af5e · facts from BC29

Learn documents this table through its pages: Page 30113 “Shpfy Order” (2 Learn pages), Page 30115 “Shpfy Orders” (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. via Page 30113 “Shpfy Order”	DataClassification CustomerContent
5	Sell-to Address	Text[100]	Specifies the street address of the buy address. via Page 30113 “Shpfy Order”	DataClassification CustomerContent
6	Sell-to Address 2	Text[100]	Specifies additional address information. via Page 30113 “Shpfy Order”	DataClassification CustomerContent
7	Sell-to City	Text[50]	Specifies the city, town, or village of the buy address. via Page 30113 “Shpfy Order”	DataClassification CustomerContent
8	Sell-to Post Code	Text[50]	Specifies the postal code of the buy address. via Page 30113 “Shpfy Order”	DataClassification CustomerContent
9	Sell-to Country/Region Code	Code[20]	Specifies country/region code of the buy address. via Page 30115 “Shpfy Orders”	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. via Page 30113 “Shpfy Order”	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”; not editable
22	Fully Paid	Boolean	—	not editable
23	Processing Method	Enum “Shpfy Processing Method”	—	enum Enum 30118 “Shpfy Processing Method”; 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. via Page 30113 “Shpfy Order”	DataClassification CustomerContent
51	Ship-to Address	Text[100]	Specifies the address that products on the sales order are shipped to. via Page 30113 “Shpfy Order”	DataClassification CustomerContent
52	Ship-to Address 2	Text[100]	Specifies additional address information. via Page 30113 “Shpfy Order”	DataClassification CustomerContent
53	Ship-to City	Text[50]	Specifies the city of the customer that the products are shipped to. via Page 30113 “Shpfy Order”	DataClassification CustomerContent
54	Ship-to Post Code	Text[50]	Specifies the ZIP code of the address that the products are shipped to. via Page 30113 “Shpfy Order”	DataClassification CustomerContent
55	Ship-to Country/Region Code	Code[20]	Specifies the country/region code of the address that the items are shipped to. via Page 30113 “Shpfy Order”	DataClassification CustomerContent
56	Ship-to Country/Region Name	Text[50]	Specifies the name of the customer’s country/region via Page 30113 “Shpfy Order”	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. via Page 30113 “Shpfy Order”	DataClassification CustomerContent
61	Bill-to Address	Text[100]	Specifies the address of the customer that you sent the invoice or credit memo to. via Page 30113 “Shpfy Order”	DataClassification CustomerContent
62	Bill-to Address 2	Text[100]	Specifies additional address information. via Page 30113 “Shpfy Order”	DataClassification CustomerContent
63	Bill-to City	Text[50]	Specifies the city of the customer that you sent the invoice or credit memo to. via Page 30113 “Shpfy Order”	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. via Page 30113 “Shpfy Order”	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. via Page 30113 “Shpfy Order”	DataClassification CustomerContent
66	Bill-to Country/Region Name	Text[50]	Specifies the name of the customer’s country/region. via Page 30113 “Shpfy Order”	DataClassification CustomerContent
67	Test	Boolean	Specifies whether this is a test order. via Page 30113 “Shpfy Order”
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. via Page 30113 “Shpfy Order”
69	Subtotal Amount	Decimal	Specifies the sum of the line amounts on all lines in the document minus any discount amounts. via Page 30113 “Shpfy Order”
70	Total Weight	Decimal	—
71	VAT Amount	Decimal	Specifies the sum of tax amounts on all lines in the document. via Page 30113 “Shpfy Order”
72	VAT Included	Boolean	Specifies if tax is included in the unit price. via Page 30113 “Shpfy Order”
73	Currency Code	Code[10]	Specifies the currency of amounts on the document. via Page 30113 “Shpfy Order”
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. via Page 30113 “Shpfy Order”	enum Enum 30117 “Shpfy Financial Status”; not editable
75	Confirmed	Boolean	Specifies whether the order has been confirmed. via Page 30113 “Shpfy Order”
76	Discount Amount	Decimal	Specifies the sum of all discount amount on all lines in the document. via Page 30113 “Shpfy Order”
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. via Page 30113 “Shpfy Order”	enum Enum 30113 “Shpfy Order Fulfill. Status”; 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. via Page 30113 “Shpfy Order”	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. via Page 30113 “Shpfy Order”	enum Enum 30116 “Shpfy Cancel Reason”; not editable
82	Closed At	DateTime	Closed At (Shopify) caption	not editable
83	Bill-to First Name	Text[50]	—	DataClassification CustomerContent
84	Bill-to Lastname	Text[50]	Bill-to Last Name caption	DataClassification CustomerContent
87	Processed At	DateTime	Processed At (Shopify) caption
89	Shopify Order No.	Text[50]	Specifies the order number from Shopify. via Page 30113 “Shpfy Order”
90	Order Status URL	Text[250]	—
91	Created At	DateTime	Specifies the autogenerated date and time when the order was created in Shopify. via Page 30113 “Shpfy Order”
92	Source Name	Code[20]	Specifies where the order is originated. Example values: web, pos, iphone, android. via Page 30113 “Shpfy Order”	not editable
93	Updated At	DateTime	Specifies the date and time when the order was last modified in Shopify. via Page 30113 “Shpfy Order”
94	Shipping Charges Amount	Decimal	Specifies the amount of the shipping cost. via Page 30113 “Shpfy Order”
95	Document Date	Date	Specifies the date when the related document was created. via Page 30113 “Shpfy Order”
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. via Page 30113 “Shpfy Order”	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. via Page 30113 “Shpfy Order”	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. via Page 30113 “Shpfy Order”	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. via Page 30113 “Shpfy Order”
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. via Page 30113 “Shpfy Order”	enum Enum 30145 “Shpfy Order Return Status”
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 caption
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. via Page 30113 “Shpfy Order”
127	Company Location Id	BigInteger	—
128	High Risk	Boolean	Specifies if the order is considered high risk. via Page 30113 “Shpfy Order”	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. via Page 30172 “Shpfy Order Totals FactBox”
131	Payment Rounding Amount	Decimal	Specifies the amount of rounding applied to the total amount of the document. via Page 30113 “Shpfy Order”
132	Pres. Refund Rounding Amount	Decimal	Presentment Refund Rounding Amount caption
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. via Page 30113 “Shpfy Order”	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. via Page 30113 “Shpfy Order”	TableRelation Table 30102 “Shpfy Shop” (Shpfy Shop)
501	Customer Template Code	Code[10]	—	obsolete Removed 25.0; #if not CLEANSCHEMA25; TableRelation Table 8618 “Config. Template Header” (“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. via Page 30113 “Shpfy Order”	TableRelation Table 1381 “Customer Templ.” (“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. via Page 30113 “Shpfy Order”	TableRelation Table 18 “Customer”
1001	Sales Order No.	Code[20]	Specifies the sales order number that has been created for the Shopify Order. via Page 30113 “Shpfy Order”	TableRelation Table 36 “Sales Header” (“Sales Header”.“No.” where(“Document Type” = const(Order)))
1002	Has Error	Boolean	Specifies whether there is an error when creating a sales document. via Page 30113 “Shpfy Order”
1003	Error Message	Text[2048]	Specifies the error message if an error has occurred. via Page 30113 “Shpfy Order”
1004	Processed	Boolean	Specifies whether a sales order has been created for the Shopify Order. via Page 30113 “Shpfy Order”
1005	Sell-to Customer Name	Text[50]	Specifies the name of the customer who will buy the products. via Page 30113 “Shpfy Order”	DataClassification CustomerContent
1006	Sales Invoice No.	Code[20]	Specifies the sales invoice number that has been created for the Shopify Order. via Page 30113 “Shpfy Order”	TableRelation Table 36 “Sales Header” (“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. via Page 30113 “Shpfy Order”	TableRelation Table 18 “Customer”; DataClassification CustomerContent
1012	Shipping Method Code	Code[10]	Specifies how items on the Shopify Order are shipped to the customer. via Page 30113 “Shpfy Order”	TableRelation Table 10 “Shipment Method” (Shipment Method); DataClassification CustomerContent
1013	Payment Method Code	Code[10]	Specifies how to make a payment, such as with bank transfer, cash, or check. via Page 30113 “Shpfy Order”	TableRelation Table 289 “Payment Method” (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. via Page 30113 “Shpfy Order”	DataClassification CustomerContent
1018	Bill-to Contact No.	Code[20]	Specifies the number of the contact person at the bill-to customer. via Page 30113 “Shpfy Order”	DataClassification CustomerContent
1019	Ship-to Contact No.	Code[20]	Specifies the number of the contact person at the ship-to address. via Page 30113 “Shpfy Order”	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. via Page 30113 “Shpfy Order”	TableRelation Table 291 “Shipping Agent” (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. via Page 30113 “Shpfy Order”	TableRelation Table 5790 “Shipping Agent Services” (“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. via Page 30113 “Shpfy Order”	DataClassification CustomerContent
1060	Processed Currency Handling	Enum “Shpfy Currency Handling”	Specifies how the currency was handled when processing the order. via Page 30113 “Shpfy Order”	enum Enum 30171 “Shpfy Currency Handling”; 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. via Page 30113 “Shpfy Order”	TableRelation Table 318 “Tax Area” (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. via Page 30113 “Shpfy Order”	DataClassification CustomerContent
1090	Tax Exempt	Boolean	Specifies whether this Shopify order is exempt from tax (e.g. tax was disabled at POS). via Page 30113 “Shpfy Order”	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”
lookup page Page 30115 “Shpfy Orders”
Shipping Method Code: TableRelation Table 10 “Shipment Method”
Customer Templ. Code: TableRelation Table 1381 “Customer Templ.”
Bill-to Customer No.: TableRelation Table 18 “Customer”
Sell-to Customer No.: TableRelation Table 18 “Customer”
Payment Method Code: TableRelation Table 289 “Payment Method”
Shipping Agent Code: TableRelation Table 291 “Shipping Agent”
Shop Code: TableRelation Table 30102 “Shpfy Shop”
Number of Lines: CalcFormula Table 30119 “Shpfy Order Line”
Total Quantity of Items: CalcFormula Table 30119 “Shpfy Order Line”
Channel Liable Taxes: CalcFormula Table 30122 “Shpfy Order Tax Line”
High Risk: CalcFormula Table 30123 “Shpfy Order Risk”
Tax Area Code: TableRelation Table 318 “Tax Area”
Sales Invoice No.: TableRelation Table 36 “Sales Header”
Sales Order No.: TableRelation Table 36 “Sales Header”
Shipping Agent Service Code: TableRelation Table 5790 “Shipping Agent Services”
Customer Template Code: TableRelation Table 8618 “Config. Template Header”

Referenced by

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

Table 30142 “Shpfy Refund Header”: 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”: 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”: Unprocessed Order Updates, Unprocessed Orders
Table 30133 “Shpfy Order Transaction”: Shop Code, Shpfy Order No.
Table 30139 “Shpfy Fulfillment Line”: Order Id
Table 30143 “Shpfy FulFillment Order Header”: Shopify Order No.
Table 30154 “Shpfy Suggest Payment”: Shpfy Order No.
Table 30155 “Shpfy Dispute”: Source Order Id
Table extension 30101 “Shpfy Sales Header”: Shpfy Risk Level

Pages and codeunits on this table

Page 30113 “Shpfy Order” (source table)
Page 30115 “Shpfy Orders” (source table)
Page 30160 “Shpfy Cancel Order” (source table)
Page 30172 “Shpfy Order Totals FactBox” (source table)
Codeunit 30166 “Shpfy Process Order” (codeunit runs on it)

Recent changes

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

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.