Table 30118 Shpfy Order Header

Shopify Connector, Microsoft.Integration.Shopify

145 fields

IdNameTypeVersions
1Shopify Order IdBigIntegernew in 20
2EmailText[80]new in 20changed in 24
5Sell-to AddressText[100]new in 20
6Sell-to Address 2Text[100]new in 20
7Sell-to CityText[50]new in 20
8Sell-to Post CodeText[50]new in 20
9Sell-to Country/Region CodeCode[20]new in 20
10Sell-to Country/Region NameText[50]new in 20
11Phone No.Text[50]new in 20
12TokenText[50]new in 20
Removed, tag 25.0, obsolete since 22.0: Not available in GraphQL data.
13GatewayText[50]new in 20
14Sell-to First NameText[50]new in 20
15Sell-to Last NameText[50]new in 20
16CurrencyCode[10]new in 20
Removed, tag 25.0, obsolete since 22.0: Replaced with the fields "Currency Code" and "Presentment Currency Code".
17Cart TokenText[50]new in 20
Removed, tag 25.0, obsolete since 22.0: Not available in GraphQL data.
18Checkout TokenText[50]new in 20
Removed, tag 25.0, obsolete since 22.0: Not available in GraphQL data.
19ReferenceText[50]new in 20
Removed, tag 25.0, obsolete since 22.0: Not available in GraphQL data.
21Risk LevelEnum "Shpfy Risk Level"new in 20
Removed, tag 28.0, obsolete since 25.0: This field is not imported. Use field "High Risk" field.
22Fully PaidBooleannew in 20
23Processing MethodEnum "Shpfy Processing Method"new in 20
24Checkout IdBigIntegernew in 20
25Contact EmailText[100]new in 20
Removed, tag 25.0, obsolete since 22.0: Not available in GraphQL data.
26Total Tip ReceivedDecimalnew in 20
27Session HashText[50]new in 20
Removed, tag 25.0, obsolete since 22.0: Not available in GraphQL data.
48Ship-to First NameText[50]new in 20
49Ship-to Last NameText[50]new in 20
50Ship-to NameText[50]new in 20
51Ship-to AddressText[100]new in 20
52Ship-to Address 2Text[100]new in 20
53Ship-to CityText[50]new in 20
54Ship-to Post CodeText[50]new in 20
55Ship-to Country/Region CodeCode[20]new in 20
56Ship-to Country/Region NameText[50]new in 20
57Ship-to LatitudeDecimalnew in 20
58Ship-to LongitudeDecimalnew in 20
60Bill-to NameText[50]new in 20
61Bill-to AddressText[100]new in 20
62Bill-to Address 2Text[100]new in 20
63Bill-to CityText[50]new in 20
64Bill-to Post CodeText[50]new in 20
65Bill-to Country/Region CodeCode[20]new in 20
66Bill-to Country/Region NameText[50]new in 20
67TestBooleannew in 20
68Total AmountDecimalnew in 20
69Subtotal AmountDecimalnew in 20
70Total WeightDecimalnew in 20
71VAT AmountDecimalnew in 20
72VAT IncludedBooleannew in 20
73Currency CodeCode[10]new in 20
74Financial StatusEnum "Shpfy Financial Status"new in 20
75ConfirmedBooleannew in 20
76Discount AmountDecimalnew in 20
77Total Items AmountDecimalnew in 20
78Fulfillment StatusEnum "Shpfy Order Fulfill. Status"new in 20
79Buyer Accepts MarketingBooleannew in 20
Removed, tag 25.0, obsolete since 22.0: Not available in GraphQL data.
80Cancelled AtDateTimenew in 20
81Cancel ReasonEnum "Shpfy Cancel Reason"new in 20
82Closed AtDateTimenew in 20
83Bill-to First NameText[50]new in 20
84Bill-to LastnameText[50]new in 20
87Processed AtDateTimenew in 20
89Shopify Order No.Text[50]new in 20
90Order Status URLText[250]new in 20
91Created AtDateTimenew in 20
92Source NameCode[20]new in 20
93Updated AtDateTimenew in 20
94Shipping Charges AmountDecimalnew in 20
95Document DateDatenew in 20
96Sell-to CountyText[30]new in 20
97Bill-to CountyText[30]new in 20
98Ship-to CountyText[30]new in 20
99Customer IdBigIntegernew in 20
100ClosedBooleannew in 20
101Location IdBigIntegernew in 20
Removed, tag 28.0, obsolete since 25.0: Location Id on Order Header is not used. Instead use Location Id on Order Lines.
102Channel NameText[100]new in 22
103App NameText[100]new in 22
104Presentment Currency CodeCode[10]new in 22
105UnpaidBooleannew in 22
106Discount CodeCode[20]new in 22
107Discount CodesText[250]new in 22
108RefundableBooleannew in 22
109Presentment Total AmountDecimalnew in 22
110Presentment Subtotal AmountDecimalnew in 22
111Presentment VAT AmountDecimalnew in 22
112Presentment Discount AmountDecimalnew in 22
113Presentment Total Tip ReceivedDecimalnew in 22
114Pres. Shipping Charges AmountDecimalnew in 22
115EditedBooleannew in 22
116Return StatusEnum "Shpfy Order Return Status"new in 23
117Company IdBigIntegernew in 24
118Company Main Contact IdBigIntegernew in 24
119Company Main Contact EmailText[100]new in 24
120Company Main Contact Phone No.Text[50]new in 24
121Company Main Contact Cust. IdBigIntegernew in 24
122B2BBooleannew in 24
123Current Total AmountDecimalnew in 24
124Current Total Items QuantityIntegernew in 24
125Line Items Redundancy CodeIntegernew in 24
126PO NumberText[512]new in 24
127Company Location IdBigIntegernew in 25
128High RiskBooleannew in 26
129Due DateDatenew in 26
130Pres. Payment Rounding AmountDecimalnew in 27
131Payment Rounding AmountDecimalnew in 27
132Pres. Refund Rounding AmountDecimalnew in 27
133Refund Rounding AmountDecimalnew in 27
134Channel Liable TaxesBooleannew in 27
135Use Shopify Order No.Booleannew in 29
500Shop CodeCode[20]new in 20
501Customer Template CodeCode[10]new in 20
Removed, tag 25.0, obsolete since 22.0: Replaced by Customer Templ. Code
502Customer Templ. CodeCode[20]new in 22
601Total Quantity of ItemsDecimalnew in 20
602Number of LinesIntegernew in 20
1000Sell-to Customer No.Code[20]new in 20
1001Sales Order No.Code[20]new in 20
1002Has ErrorBooleannew in 20
1003Error MessageText[2048]new in 20
1004ProcessedBooleannew in 20
1005Sell-to Customer NameText[50]new in 20
1006Sales Invoice No.Code[20]new in 20
1007Work DescriptionBlobnew in 20
1008Sell-to Customer Name 2Text[50]new in 20
1009Ship-to Name 2Text[50]new in 20
1010Bill-to Name 2Text[50]new in 20
1011Bill-to Customer No.Code[20]new in 20
1012Shipping Method CodeCode[10]new in 20
1013Payment Method CodeCode[10]new in 20
1014Sell-to Contact NameText[100]new in 22
1015Bill-to Contact NameText[100]new in 22
1016Ship-to Contact NameText[100]new in 22
1017Sell-to Contact No.Code[20]new in 22
1018Bill-to Contact No.Code[20]new in 22
1019Ship-to Contact No.Code[20]new in 22
1020Has Order State ErrorBooleannew in 24
1021Shipping Agent CodeCode[10]new in 25
1022Shipping Agent Service CodeCode[10]new in 25
1023Retail Location IdBigIntegernew in 28
1024Retail Location NameText[250]new in 28
1030Payment Terms TypeCode[20]new in 25
1040Payment Terms NameText[50]new in 25
1050Salesperson CodeCode[20]new in 27
1060Processed Currency HandlingEnum "Shpfy Currency Handling"new in 28
1070Tax Area CodeCode[20]new in 29
1080Tax LiableBooleannew in 29
1090Tax ExemptBooleannew in 29