Table 30118 Shpfy Order Header

Shopify Connector, Microsoft.Integration.Shopify
List17181920212223242526272829
Fields30112162654
Keys11
Procedures111

In 29 5 added

field(135; "Use Shopify Order No."; Boolean)new in 29
added
field(1070; "Tax Area Code"; Code[20])new in 29
added
field(1080; "Tax Liable"; Boolean)new in 29
added
field(1090; "Tax Exempt"; Boolean)new in 29
added
internal LookupContactForCustomer(CustomerNo: Code[20]; ContactNo: Code[20]; var Contact: Record Contact)new in 29
added

In 28 2 state changed, 4 added

field(21; "Risk Level"; Enum "Shpfy 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"; BigInteger)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"; BigInteger)new in 28
added
field(1024; "Retail Location Name"; Text[250])new in 28
added
field(1060; "Processed Currency Handling"; Enum "Shpfy Currency Handling")new in 28
added
internal IsPresentmentCurrencyOrder(): Booleannew in 28
added

In 27 7 added

field(130; "Pres. Payment Rounding Amount"; Decimal)new in 27
added
field(131; "Payment Rounding Amount"; Decimal)new in 27
added
field(132; "Pres. Refund Rounding Amount"; Decimal)new in 27
added
field(133; "Refund Rounding Amount"; Decimal)new in 27
added
field(134; "Channel Liable Taxes"; Boolean)new in 27
added
field(1050; "Salesperson Code"; Code[20])new in 27
added
key(Key3; "Created At")new in 27
added

In 26 2 added

field(128; "High Risk"; Boolean)new in 26
added
field(129; "Due Date"; Date)new in 26
added

In 25 9 state changed, 2 marked obsolete, 5 added

field(12; Token; Text[50])new in 20
Pending to Removed, tag 25.0: Not available in GraphQL data.
field(16; Currency; Code[10])new in 20
Pending to Removed, tag 25.0: Replaced with the fields "Currency Code" and "Presentment Currency Code".
field(17; "Cart Token"; Text[50])new in 20
Pending to Removed, tag 25.0: Not available in GraphQL data.
field(18; "Checkout Token"; Text[50])new in 20
Pending to Removed, tag 25.0: Not available in GraphQL data.
field(19; Reference; Text[50])new in 20
Pending to Removed, tag 25.0: Not available in GraphQL data.
field(21; "Risk Level"; Enum "Shpfy Risk Level")new in 20
marked Pending, tag 25.0: This field is not imported.
field(25; "Contact Email"; Text[100])new in 20
Pending to Removed, tag 25.0: Not available in GraphQL data.
field(27; "Session Hash"; Text[50])new in 20
Pending to Removed, tag 25.0: Not available in GraphQL data.
field(79; "Buyer Accepts Marketing"; Boolean)new in 20
Pending to Removed, tag 25.0: Not available in GraphQL data.
field(101; "Location Id"; BigInteger)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"; BigInteger)new in 25
added
field(501; "Customer Template Code"; Code[10])new in 20
Pending to Removed, tag 25.0: Replaced by Customer Templ. Code
field(1021; "Shipping Agent Code"; Code[10])new in 25
added
field(1022; "Shipping Agent Service Code"; Code[10])new in 25
added
field(1030; "Payment Terms Type"; Code[20])new in 25
added
field(1040; "Payment Terms Name"; Text[50])new in 25
added

In 24 1 changed, 11 added

field(2; Email; Text[80])new in 20changed in 24
changed, was field(2; Email; Text[50])
field(117; "Company Id"; BigInteger)new in 24
added
field(118; "Company Main Contact Id"; BigInteger)new in 24
added
field(119; "Company Main Contact Email"; Text[100])new in 24
added
field(120; "Company Main Contact Phone No."; Text[50])new in 24
added
field(121; "Company Main Contact Cust. Id"; BigInteger)new in 24
added
field(122; B2B; Boolean)new in 24
added
field(123; "Current Total Amount"; Decimal)new in 24
added
field(124; "Current Total Items Quantity"; Integer)new in 24
added
field(125; "Line Items Redundancy Code"; Integer)new in 24
added
field(126; "PO Number"; Text[512])new in 24
added
field(1020; "Has Order State Error"; Boolean)new in 24
added

In 23 1 added

field(116; "Return Status"; Enum "Shpfy Order Return Status")new in 23
added

In 22 9 marked obsolete, 23 added

field(12; Token; Text[50])new in 20
marked Pending, tag 22.0: Not available in GraphQL data.
field(16; Currency; Code[10])new in 20
marked Pending, tag 22.0: Replaced with the fields "Currency Code" and "Presentment Currency Code".
field(17; "Cart Token"; Text[50])new in 20
marked Pending, tag 22.0: Not available in GraphQL data.
field(18; "Checkout Token"; Text[50])new in 20
marked Pending, tag 22.0: Not available in GraphQL data.
field(19; Reference; Text[50])new in 20
marked Pending, tag 22.0: Not available in GraphQL data.
field(25; "Contact Email"; Text[100])new in 20
marked Pending, tag 22.0: Not available in GraphQL data.
field(27; "Session Hash"; Text[50])new in 20
marked Pending, tag 22.0: Not available in GraphQL data.
field(79; "Buyer Accepts Marketing"; Boolean)new in 20
marked Pending, tag 22.0: Not available in GraphQL data.
field(102; "Channel Name"; Text[100])new in 22
added
field(103; "App Name"; Text[100])new in 22
added
field(104; "Presentment Currency Code"; Code[10])new in 22
added
field(105; Unpaid; Boolean)new in 22
added
field(106; "Discount Code"; Code[20])new in 22
added
field(107; "Discount Codes"; Text[250])new in 22
added
field(108; Refundable; Boolean)new in 22
added
field(109; "Presentment Total Amount"; Decimal)new in 22
added
field(110; "Presentment Subtotal Amount"; Decimal)new in 22
added
field(111; "Presentment VAT Amount"; Decimal)new in 22
added
field(112; "Presentment Discount Amount"; Decimal)new in 22
added
field(113; "Presentment Total Tip Received"; Decimal)new in 22
added
field(114; "Pres. Shipping Charges Amount"; Decimal)new in 22
added
field(115; Edited; Boolean)new in 22
added
field(501; "Customer Template Code"; Code[10])new in 20
marked Pending, tag 22.0: Replaced by Customer Templ. Code
field(502; "Customer Templ. Code"; Code[20])new in 22
added
field(1014; "Sell-to Contact Name"; Text[100])new in 22
added
field(1015; "Bill-to Contact Name"; Text[100])new in 22
added
field(1016; "Ship-to Contact Name"; Text[100])new in 22
added
field(1017; "Sell-to Contact No."; Code[20])new in 22
added
field(1018; "Bill-to Contact No."; Code[20])new in 22
added
field(1019; "Ship-to Contact No."; Code[20])new in 22
added
key(Key2; "Shop Code", Processed)new in 22
added
internal IsProcessed(): Booleannew in 22
added