XPT / Schema / Shpfy Order Header

Shpfy Order Header #30118

Other table in Microsoft Dynamics 365 Business Central. 134 fields, 0 records in Cronus demo.

134
Fields
0
Records
1
Primary key
4
FlowFields
12
Relations
Open in Data Explorer →

Primary key

The primary key uniquely identifies each record in this table. It consists of: Shopify Order Id.

All fields (134)

Shpfy Order Header — FIELDS
NO.FIELDTYPECLASSRELATION
1 Shopify Order Id PK BigInteger Normal
2 Email Text Normal
5 Sell-to Address Text Normal
6 Sell-to Address 2 Text Normal
7 Sell-to City Text Normal
8 Sell-to ZIP Code Text Normal
9 Sell-to Country/Region Code Code Normal
10 Sell-to Country/Region Name Text Normal
11 Phone No. Text Normal
13 Gateway Text Normal
14 Sell-to First Name Text Normal
15 Sell-to Last Name Text Normal
21 Risk Level Option Normal
22 Fully Paid Boolean Normal
23 Processing Method Option Normal
24 Checkout Id BigInteger Normal
26 Total Tip Received Decimal Normal
48 Ship-to First Name Text Normal
49 Ship-to Last Name Text Normal
50 Ship-to Name Text Normal
51 Ship-to Address Text Normal
52 Ship-to Address 2 Text Normal
53 Ship-to City Text Normal
54 Ship-to ZIP Code Text Normal
55 Ship-to Country/Region Code Code Normal
56 Ship-to Country/Region Name Text Normal
57 Ship-to Latitude Decimal Normal
58 Ship-to Longitude Decimal Normal
60 Bill-to Name Text Normal
61 Bill-to Address Text Normal
62 Bill-to Address 2 Text Normal
63 Bill-to City Text Normal
64 Bill-to ZIP Code Text Normal
65 Bill-to Country/Region Code Code Normal
66 Bill-to Country/Region Name Text Normal
67 Test Boolean Normal
68 Total Amount Decimal Normal
69 Subtotal Amount Decimal Normal
70 Total Weight Decimal Normal
71 Tax Amount Decimal Normal
72 Tax Included Boolean Normal
73 Currency Code Code Normal
74 Financial Status Option Normal
75 Confirmed Boolean Normal
76 Discount Amount Decimal Normal
77 Total Items Amount Decimal Normal
78 Fulfillment Status Option Normal
80 Canceled At DateTime Normal
81 Cancel Reason Option Normal
82 Closed At DateTime Normal
83 Bill-to First Name Text Normal
84 Bill-to Last Name Text Normal
87 Processed At DateTime Normal
89 Shopify Order No. Text Normal
90 Order Status URL Text Normal
91 Created At DateTime Normal
92 Source Name Code Normal
93 Updated At DateTime Normal
94 Shipping Charges Amount Decimal Normal
95 Document Date Date Normal
96 Sell-to State Text Normal
97 Bill-to State Text Normal
98 Ship-to State Text Normal
99 Customer Id BigInteger Normal
100 Closed Boolean Normal
101 Location Id BigInteger Normal
102 Channel Name Text Normal
103 App Name Text Normal
104 Presentment Currency Code Code Normal
105 Unpaid Boolean Normal
106 Discount Code Code Normal
107 Discount Codes Text Normal
108 Refundable Boolean Normal
109 Presentment Total Amount Decimal Normal
110 Presentment Subtotal Amount Decimal Normal
111 Presentment Tax Amount Decimal Normal
112 Discount Amount Decimal Normal
113 Presentment Total Tip Received Decimal Normal
114 Presentment Shipping Charges Amount Decimal Normal
115 Edited Boolean Normal
116 Return Status Option Normal
117 Company Id BigInteger Normal
118 Company Main Contact Id BigInteger Normal
119 Company Main Contact Email Text Normal
120 Company Main Contact Phone No. Text Normal
121 Company Main Contact Customer Id BigInteger Normal
122 B2B Boolean Normal
123 Current Total Amount Decimal Normal
124 Current Total Items Quantity Integer Normal
125 Line Items Redundancy Code Integer Normal
126 PO Number Text Normal
127 Company Location Id BigInteger Normal
128 High Risk ⚡ FLOW Boolean FlowField
129 Due Date Date Normal
130 Presentment Payment Rounding Amount Decimal Normal
131 Payment Rounding Amount Decimal Normal
132 Presentment Refund Rounding Amount Decimal Normal
133 Refund Rounding Amount Decimal Normal
134 Channel Liable Taxes ⚡ FLOW Boolean FlowField
500 Shop Code Code Normal → Shpfy Shop #30102
502 Customer Template Code Code Normal → Customer Templ. #1381
601 Total Quantity of Items ⚡ FLOW Decimal FlowField
602 Number of Lines ⚡ FLOW Integer FlowField
1000 Sell-to Customer No. Code Normal → Customer #18
1001 Sales Order No. Code Normal → Sales Header #36
1002 Has Error Boolean Normal
1003 Error Message Text Normal
1004 Processed Boolean Normal
1005 Sell-to Customer Name Text Normal
1006 Sales Invoice No. Code Normal → Sales Header #36
1007 Work Description BLOB Normal
1008 Sell-to Customer Name 2 Text Normal
1009 Ship-to Name 2 Text Normal
1010 Bill-to Name 2 Text Normal
1011 Bill-to Customer No. Code Normal → Customer #18
1012 Shipping Method Code Code Normal → Shipment Method #10
1013 Payment Method Code Code Normal → Payment Method #289
1014 Sell-to Contact Name Text Normal
1015 Bill-to Contact Name Text Normal
1016 Ship-to Contact Name Text Normal
1017 Sell-to Contact No. Code Normal
1018 Bill-to Contact No. Code Normal
1019 Ship-to Contact No. Code Normal
1020 Has Order State Error Boolean Normal
1021 Shipping Agent Code Code Normal → Shipping Agent #291
1022 Shipping Agent Service Code Code Normal → Shipping Agent Services #5790
1030 Payment Terms Type Code Normal
1040 Payment Terms Name Text Normal
1050 Salesperson Code Code Normal
2000000000 System ID GUID Normal
2000000001 Created At DateTime Normal
2000000002 Created By GUID Normal
2000000003 Modified At DateTime Normal
2000000004 Modified By GUID Normal

Related tables (9)

Tables referenced by fields on the Shpfy Order Header table through TableRelation properties.

Shpfy Shop
#30102 · Other · via Shop Code
Customer Templ.
#1381 · Other · via Customer Template Code
Customer
#18 · Sales · via Sell-to Customer No., Bill-to Customer No.
Sales Header
#36 · Sales Documents · via Sales Order No., Sales Invoice No.
Shipment Method
#10 · General Ledger · via Shipping Method Code
Payment Method
#289 · Other · via Payment Method Code
Shipping Agent
#291 · Other · via Shipping Agent Code
Shipping Agent Services
#5790 · Other · via Shipping Agent Service Code

© 2026 Xpertly Ltd · Company No. 14753894 · VAT No. 452840787

HomeData ExplorerPricingPrivacyTerms