Table 30118 Shpfy Order Header
| List | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Fields | 30 | 1 | 12 | 16 | 2 | 6 | 5 | 4 | |||||
| Keys | 1 | 1 | |||||||||||
| Procedures | 1 | 1 | 1 |
In 29 5 added
| field(135; "Use Shopify Order No." | new in 29 |
| added | |
| field(1070; "Tax Area Code" | new in 29 |
| added | |
| field(1080; "Tax Liable" | new in 29 |
| added | |
| field(1090; "Tax Exempt" | new in 29 |
| added | |
| internal Lookup | new in 29 |
| added | |
In 28 2 state changed, 4 added
| field(21; "Risk Level" | new in 20 |
| Pending to Removed, tag 28.0: This field is not imported. Use field "High Risk" field. | |
| field(101; "Location Id" | new in 20 |
| Pending to Removed, tag 28.0: Location Id on Order Header is not used. Instead use Location Id on Order Lines. | |
| field(1023; "Retail Location Id" | new in 28 |
| added | |
| field(1024; "Retail Location Name" | new in 28 |
| added | |
| field(1060; "Processed Currency Handling" | new in 28 |
| added | |
| internal Is | new in 28 |
| added | |
In 27 7 added
| field(130; "Pres. Payment Rounding Amount" | new in 27 |
| added | |
| field(131; "Payment Rounding Amount" | new in 27 |
| added | |
| field(132; "Pres. Refund Rounding Amount" | new in 27 |
| added | |
| field(133; "Refund Rounding Amount" | new in 27 |
| added | |
| field(134; "Channel Liable Taxes" | new in 27 |
| added | |
| field(1050; "Salesperson Code" | new in 27 |
| added | |
| key(Key3 | new in 27 |
| added | |
In 26 2 added
| field(128; "High Risk" | new in 26 |
| added | |
| field(129; "Due Date" | new in 26 |
| added | |
In 25 9 state changed, 2 marked obsolete, 5 added
| field(12; Token | new in 20 |
| Pending to Removed, tag 25.0: Not available in GraphQL data. | |
| field(16; Currency | new in 20 |
| Pending to Removed, tag 25.0: Replaced with the fields "Currency Code" and "Presentment Currency Code". | |
| field(17; "Cart Token" | new in 20 |
| Pending to Removed, tag 25.0: Not available in GraphQL data. | |
| field(18; "Checkout Token" | new in 20 |
| Pending to Removed, tag 25.0: Not available in GraphQL data. | |
| field(19; Reference | new in 20 |
| Pending to Removed, tag 25.0: Not available in GraphQL data. | |
| field(21; "Risk Level" | new in 20 |
| marked Pending, tag 25.0: This field is not imported. | |
| field(25; "Contact Email" | new in 20 |
| Pending to Removed, tag 25.0: Not available in GraphQL data. | |
| field(27; "Session Hash" | new in 20 |
| Pending to Removed, tag 25.0: Not available in GraphQL data. | |
| field(79; "Buyer Accepts Marketing" | new in 20 |
| Pending to Removed, tag 25.0: Not available in GraphQL data. | |
| field(101; "Location Id" | new in 20 |
| marked Pending, tag 25.0: Location Id on Order Header is not used. Instead use Location Id on Order Lines. | |
| field(127; "Company Location Id" | new in 25 |
| added | |
| field(501; "Customer Template Code" | new in 20 |
| Pending to Removed, tag 25.0: Replaced by Customer Templ. Code | |
| field(1021; "Shipping Agent Code" | new in 25 |
| added | |
| field(1022; "Shipping Agent Service Code" | new in 25 |
| added | |
| field(1030; "Payment Terms Type" | new in 25 |
| added | |
| field(1040; "Payment Terms Name" | new in 25 |
| added | |
In 24 1 changed, 11 added
| field(2; Email | new in 20changed in 24 |
| changed, was field(2; Email | |
| field(117; "Company Id" | new in 24 |
| added | |
| field(118; "Company Main Contact Id" | new in 24 |
| added | |
| field(119; "Company Main Contact Email" | new in 24 |
| added | |
| field(120; "Company Main Contact Phone No." | new in 24 |
| added | |
| field(121; "Company Main Contact Cust. Id" | new in 24 |
| added | |
| field(122; B2 | new in 24 |
| added | |
| field(123; "Current Total Amount" | new in 24 |
| added | |
| field(124; "Current Total Items Quantity" | new in 24 |
| added | |
| field(125; "Line Items Redundancy Code" | new in 24 |
| added | |
| field(126; "PO Number" | new in 24 |
| added | |
| field(1020; "Has Order State Error" | new in 24 |
| added | |
In 23 1 added
| field(116; "Return Status" | new in 23 |
| added | |
In 22 9 marked obsolete, 23 added
| field(12; Token | new in 20 |
| marked Pending, tag 22.0: Not available in GraphQL data. | |
| field(16; Currency | new in 20 |
| marked Pending, tag 22.0: Replaced with the fields "Currency Code" and "Presentment Currency Code". | |
| field(17; "Cart Token" | new in 20 |
| marked Pending, tag 22.0: Not available in GraphQL data. | |
| field(18; "Checkout Token" | new in 20 |
| marked Pending, tag 22.0: Not available in GraphQL data. | |
| field(19; Reference | new in 20 |
| marked Pending, tag 22.0: Not available in GraphQL data. | |
| field(25; "Contact Email" | new in 20 |
| marked Pending, tag 22.0: Not available in GraphQL data. | |
| field(27; "Session Hash" | new in 20 |
| marked Pending, tag 22.0: Not available in GraphQL data. | |
| field(79; "Buyer Accepts Marketing" | new in 20 |
| marked Pending, tag 22.0: Not available in GraphQL data. | |
| field(102; "Channel Name" | new in 22 |
| added | |
| field(103; "App Name" | new in 22 |
| added | |
| field(104; "Presentment Currency Code" | new in 22 |
| added | |
| field(105; Unpaid | new in 22 |
| added | |
| field(106; "Discount Code" | new in 22 |
| added | |
| field(107; "Discount Codes" | new in 22 |
| added | |
| field(108; Refundable | new in 22 |
| added | |
| field(109; "Presentment Total Amount" | new in 22 |
| added | |
| field(110; "Presentment Subtotal Amount" | new in 22 |
| added | |
| field(111; "Presentment VAT Amount" | new in 22 |
| added | |
| field(112; "Presentment Discount Amount" | new in 22 |
| added | |
| field(113; "Presentment Total Tip Received" | new in 22 |
| added | |
| field(114; "Pres. Shipping Charges Amount" | new in 22 |
| added | |
| field(115; Edited | new in 22 |
| added | |
| field(501; "Customer Template Code" | new in 20 |
| marked Pending, tag 22.0: Replaced by Customer Templ. Code | |
| field(502; "Customer Templ. Code" | new in 22 |
| added | |
| field(1014; "Sell-to Contact Name" | new in 22 |
| added | |
| field(1015; "Bill-to Contact Name" | new in 22 |
| added | |
| field(1016; "Ship-to Contact Name" | new in 22 |
| added | |
| field(1017; "Sell-to Contact No." | new in 22 |
| added | |
| field(1018; "Bill-to Contact No." | new in 22 |
| added | |
| field(1019; "Ship-to Contact No." | new in 22 |
| added | |
| key(Key2 | new in 22 |
| added | |
| internal Is | new in 22 |
| added | |