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