ODBC Driver for Shopify

Build 24.0.9060

Orders

Retrieves a list of orders.

Table-Specific Information

Select

The driver uses the Shopify API to process WHERE clause conditions built with the following columns and operators. The driver processes other filters client-side within the driver.

  • Id supports the '=,IN' comparison operators.
  • Name supports the '=,!=' comparison operators.
  • Email supports the '=,!=' comparison operators.
  • Test supports the '=,!=' comparison operators.
  • ConfirmationNumber supports the '=,!=' comparison operators.
  • DiscountCode supports the '=,!=' comparison operators.
  • ProcessedAt supports the '=,!=,<,>,>=,<=' comparison operators.
  • RiskLevel supports the '=,!=' comparison operators.
  • CreatedAt supports the '=,!=,<,>,>=,<=' comparison operators.
  • UpdatedAt supports the '=,!=,<,>,>=,<=' comparison operators.
  • CustomerId supports the '=,!=' comparison operators.

For example, the following queries are processed server side:

	SELECT * FROM Orders WHERE Id = 'gid://shopify/Order/232220695'
	SELECT * FROM Orders WHERE Id IN ('gid://shopify/Order/232220695', 'gid://shopify/Order/23220695')
	SELECT * FROM Orders WHERE Name='VALUE'
	SELECT * FROM Orders WHERE CustomerId = 'gid://shopify/Customer/3514040471'
	SELECT * FROM Orders WHERE CustomerId != 'gid://shopify/Customer/3514040471'
	SELECT * FROM Orders WHERE CustomerId = 'gid://shopify/Customer/3514040471' AND Test = true
	SELECT * FROM Orders WHERE CustomerId = 'gid://shopify/Customer/3514040471' AND RiskLevel = 'LOW'
	SELECT * FROM Orders WHERE CustomerId = 'gid://shopify/Customer/3514040471' AND RiskLevel != 'LOW'
	SELECT * FROM Orders WHERE CustomerId = 'gid://shopify/Customer/3514040471' AND Email = '[email protected]'
	SELECT * FROM Orders WHERE CustomerId = 'gid://shopify/Customer/3514040471' AND Email != '[email protected]'
	SELECT * FROM Orders WHERE CustomerId = 'gid://shopify/Customer/3514040471' AND DiscountCode = 'BlackFriday'
	SELECT * FROM Orders WHERE CustomerId = 'gid://shopify/Customer/3514040471' AND DiscountCode != 'BlackFriday'
	SELECT * FROM Orders WHERE CustomerId = 'gid://shopify/Customer/3514040471' AND UpdatedAt = '2022-01-18 02:32:26.0'
	SELECT * FROM Orders WHERE CustomerId = 'gid://shopify/Customer/3514040471' AND UpdatedAt != '2022-01-18 02:32:26.0'
	SELECT * FROM Orders WHERE CustomerId = 'gid://shopify/Customer/3514040471' AND UpdatedAt <= '2022-01-18 02:32:26.0'
	SELECT * FROM Orders WHERE CustomerId = 'gid://shopify/Customer/3514040471' AND UpdatedAt >= '2022-01-18 02:32:26.0' AND UpdatedAt <= '2022-05-10 07:52:22.0'
	SELECT * FROM Orders WHERE CustomerId = 'gid://shopify/Customer/3514040471' AND ProcessedAt = '2017-09-19 06:10:39.0'
	SELECT * FROM Orders WHERE CustomerId = 'gid://shopify/Customer/3514040471' AND ProcessedAt != '2017-09-19 06:10:39.0'
	SELECT * FROM Orders WHERE CustomerId = 'gid://shopify/Customer/3514040471' AND ProcessedAt <= '2017-09-19 06:10:39.0'
	SELECT * FROM Orders WHERE CustomerId = 'gid://shopify/Customer/3514040471' AND ProcessedAt >= '2017-09-19 06:10:39.0' AND ProcessedAt <= '2021-10-07 23:45:38.0'
	SELECT * FROM Orders WHERE CustomerId = 'gid://shopify/Customer/3514040471' AND CreatedAt = '2017-09-19 06:10:39.0'
	SELECT * FROM Orders WHERE CustomerId = 'gid://shopify/Customer/3514040471' AND CreatedAt != '2017-09-19 06:10:39.0'
	SELECT * FROM Orders WHERE CustomerId = 'gid://shopify/Customer/3514040471' AND CreatedAt <= '2017-09-19 06:10:39.0'
	SELECT * FROM Orders WHERE CustomerId = 'gid://shopify/Customer/3514040471' AND CreatedAt >= '2017-09-19 06:10:39.0' AND CreatedAt <= '2021-10-07 23:45:38.0'
	SELECT * FROM Orders where ConfirmationNumber = 'TCIIRW5FL'

Update

The following columns can be updated:

Email, Note, ShippingAddressId, ShippingAddressFirstName, ShippingAddressLastName, ShippingAddressAddress1, ShippingAddressAddress2, ShippingAddressCity, ShippingAddressCompany, ShippingAddressCountry, ShippingAddressPhone, ShippingAddressProvince, ShippingAddressZip, ShippingAddressProvinceCode, ShippingAddressCountryCodeV2

Columns

Name Type ReadOnly References Description
Id [KEY] String True

A globally-unique ID.

Unpaid Bool True

Whether no payments have been made for the order.

FullyPaid Bool True

Whether the order has been paid in full.

SourceIdentifier String True

A unique POS or third party order identifier. For example, '1234-12-1000' or '111-98567-54'. The 'receipt_number' field is derived from this value for POS orders.

LegacyResourceId String True

The ID of the corresponding resource in the REST Admin API.

CanMarkAsPaid Bool True

Whether the order can be manually marked as paid.

Name String True

The unique identifier for the order that appears on the order page in the Shopify admin and the order status page. For example, '#1001', 'EN1001', or '1001-A'. This value isn't unique across multiple stores.

PaymentGatewayNames String True

A list of the names of all payment gateways used for the order. For example, 'Shopify Payments' and 'Cash on Delivery (COD)'.

Capturable Bool True

Whether payment for the order can be captured.

Closed Bool True

Whether the order is closed.

Confirmed Bool True

Whether inventory has been reserved for the order.

Edited Bool True

Whether the order has had any edits applied.

Email String False

The email address associated with the customer.

Fulfillable Bool True

Whether there are line items that can be fulfilled. This field returns 'false' when the order has no fulfillable line items. For a more granular view of the fulfillment status, refer to the object.

Note String False

The contents of the note associated with the order.

Phone String True

The phone number associated with the customer.

Refundable Bool True

Whether the order can be refunded.

Restockable Bool True

Whether any line item on the order can be restocked.

Tags String True

A comma separated list of tags associated with the order. Updating 'tags' overwrites any existing tags that were previously added to the order. To add new tags without overwriting existing tags, use the mutation.

Test Bool True

Whether the order is a test. Test orders are made using the Shopify Bogus Gateway or a payment provider with test mode enabled. A test order cannot be converted into a real order and vice versa.

CancelReason String True

The reason provided when the order was canceled. Returns 'null' if the order wasn't canceled.

CancelledAt Datetime True

The date and time when the order was canceled. Returns 'null' if the order wasn't canceled.

ClientIp String True

The IP address of the API client that created the order.

ClosedAt Datetime True

The date and time when the order was closed. Returns 'null' if the order is not closed.

ConfirmationNumber String True

A randomly generated alpha-numeric identifier for the order that may be shown to the customer instead of the sequential order name. For example, XPAV284CT, R50KELTJP or 35PKUN0UJ. This value isn't guaranteed to be unique.

CurrencyCode String True

The shop currency when the order was placed.

CustomerLocale String True

A two-letter or three-letter language code, optionally followed by a region modifier.

DiscountCode String True

The discount code used for the order.

DiscountCodes String True

The discount codes used for the order.

EstimatedTaxes Bool True

Whether taxes on the order are estimated. This field returns 'false' when taxes on the order are finalized and aren't subject to any changes.

MerchantEditable Bool True

Whether the order can be edited by the merchant. For example, canceled orders can't be edited.

ProcessedAt Datetime True

The date and time when the order was processed. This date and time might not match the date and time when the order was created.

RequiresShipping Bool True

Whether the order has shipping lines or at least one line item on the order that requires shipping.

ReturnStatus String True

The order's aggregated return status for display purposes.

RiskLevel String True

The fraud risk level of the order.

TaxesIncluded Bool True

Whether taxes are included in the subtotal price of the order.

TotalWeight String True

The total weight of the order before returns, in grams.

CanNotifyCustomer Bool True

Whether a customer email exists for the order.

CurrentTotalWeight String True

The total weight of the order after returns, in grams.

CustomerAcceptsMarketing Bool True

Whether the customer agreed to receive marketing materials.

DisplayFinancialStatus String True

The financial status of the order that can be shown to the merchant. This field does not capture all the details of an order's financial state. It should only be used for display summary purposes.

DisplayFulfillmentStatus String True

The fulfillment status for the order that can be shown to the merchant. This field does not capture all the details of an order's fulfillment state. It should only be used for display summary purposes. For a more granular view of the fulfillment status, refer to the object.

HasTimelineComment Bool True

Whether the merchant added a timeline comment to the order.

MerchantEditableErrors String True

A list of reasons why the order can't be edited. For example, 'Canceled orders can't be edited'.

PresentmentCurrencyCode String True

The payment 'CurrencyCode' of the customer for the order.

RegisteredSourceUrl String True

The URL of the source that the order originated from, if found in the domain registry.

SubtotalLineItemsQuantity Int True

The sum of the quantities for all line items that contribute to the order's subtotal price.

BillingAddressMatchesShippingAddress Bool True

Whether the billing address matches the shipping address.

CurrentSubtotalLineItemsQuantity Int True

The sum of the quantities for all line items that contribute to the order's current subtotal price.

CreatedAt Datetime True

Date and time when the order was created in Shopify.

UpdatedAt Datetime True

The date and time when the order was modified last.

AppId String True

The application ID.

MerchantOfRecordAppId String True

The application ID.

PhysicalLocationId String True

A globally-unique ID.

ChannelInformationId String True

A globally-unique ID.

ChannelInformationChannelId String True

The unique ID for the channel.

ChannelInformationAppId String True

A globally-unique ID.

PublicationId String True

A globally-unique ID.

PurchasingEntityCustomerId String True

A globally-unique ID.

PurchasingEntityCompanyId String True

A globally-unique ID.

CustomerId String True

A globally-unique ID.

CustomerFirstName String True

The customer's first name.

CustomerLastName String True

The customer's last name.

CustomerJourneySummaryReady Bool True

Whether the attributed sessions for the order have been created yet.

CustomerJourneySummaryMomentsCount Int True

The total number of customer moments associated with this order. Returns null if the order is still in the process of being attributed.

CustomerJourneySummaryCustomerOrderIndex Int True

The position of the current order within the customer's order history. Test orders aren't included.

CustomerJourneySummaryDaysToConversion Int True

The number of days between the first session and the order creation date. The first session represents the first session since the last order, or the first session within the 30 day attribution window, if more than 30 days have passed since the last order.

CustomerJourneySummaryFirstVisitId String True

A globally-unique ID.

CustomerJourneySummaryFirstVisitSource String True

Source from which the customer visited the store, such as a platform (Facebook, Google), email, direct, a website domain, QR code, or unknown.

CustomerJourneySummaryFirstVisitLandingPage String True

URL of the first page the customer landed on for the session.

CustomerJourneySummaryFirstVisitOccurredAt Datetime True

The date and time when the customer's session occurred.

CustomerJourneySummaryFirstVisitReferralCode String True

Marketing referral code from the link that the customer clicked to visit the store. Supports the following URL attributes: _ref_, _source_, or _r_. For example, if the URL is myshopifystore. com/products/slide?ref=j2tj1tn2, then this value is j2tj1tn2.

CustomerJourneySummaryFirstVisitReferrerUrl String True

Webpage where the customer clicked a link that sent them to the online store. For example, _https: //randomblog. com/page1_ or _android-app: //com. google. android. gm_.

CustomerJourneySummaryFirstVisitSourceDescription String True

Describes the source explicitly for first or last session.

CustomerJourneySummaryFirstVisitSourceType String True

Type of marketing tactic.

CustomerJourneySummaryFirstVisitLandingPageHtml String True

Landing page information with URL linked in HTML. For example, the first page the customer visited was store. myshopify. com/products/1.

CustomerJourneySummaryFirstVisitReferralInfoHtml String True

Referral information with URLs linked in HTML.

CustomerJourneySummaryLastVisitId String True

A globally-unique ID.

CustomerJourneySummaryLastVisitSource String True

Source from which the customer visited the store, such as a platform (Facebook, Google), email, direct, a website domain, QR code, or unknown.

CustomerJourneySummaryLastVisitLandingPage String True

URL of the first page the customer landed on for the session.

CustomerJourneySummaryLastVisitOccurredAt Datetime True

The date and time when the customer's session occurred.

CustomerJourneySummaryLastVisitReferralCode String True

Marketing referral code from the link that the customer clicked to visit the store. Supports the following URL attributes: _ref_, _source_, or _r_. For example, if the URL is myshopifystore. com/products/slide?ref=j2tj1tn2, then this value is j2tj1tn2.

CustomerJourneySummaryLastVisitReferrerUrl String True

Webpage where the customer clicked a link that sent them to the online store. For example, _https: //randomblog. com/page1_ or _android-app: //com. google. android. gm_.

CustomerJourneySummaryLastVisitSourceDescription String True

Describes the source explicitly for first or last session.

CustomerJourneySummaryLastVisitSourceType String True

Type of marketing tactic.

CustomerJourneySummaryLastVisitLandingPageHtml String True

Landing page information with URL linked in HTML. For example, the first page the customer visited was store. myshopify. com/products/1.

CustomerJourneySummaryLastVisitReferralInfoHtml String True

Referral information with URLs linked in HTML.

DisplayAddressId String True

A globally-unique ID.

DisplayAddressCoordinatesValidated Bool True

Whether the address coordinates are valid.

DisplayAddressName String True

The full name of the customer, based on firstName and lastName.

DisplayAddressFirstName String True

The first name of the customer.

DisplayAddressLastName String True

The last name of the customer.

DisplayAddressAddress1 String True

The first line of the address. Typically the street address or PO Box number.

DisplayAddressAddress2 String True

The second line of the address. Typically the number of the apartment, suite, or unit.

DisplayAddressCity String True

The name of the city, district, village, or town.

DisplayAddressCompany String True

The name of the customer's company or organization.

DisplayAddressCountry String True

The name of the country.

DisplayAddressLatitude Double True

The latitude coordinate of the customer address.

DisplayAddressLongitude Double True

The longitude coordinate of the customer address.

DisplayAddressPhone String True

A unique phone number for the customer. Formatted using E. 164 standard. For example, _+16135551111_.

DisplayAddressProvince String True

The region of the address, such as the province, state, or district.

DisplayAddressZip String True

The zip or postal code of the address.

DisplayAddressFormattedArea String True

A comma-separated list of the values for city, province, and country.

DisplayAddressProvinceCode String True

The two-letter code for the region. For example, ON.

DisplayAddressCountryCodeV2 String True

The two-letter code for the country of the address. For example, US.

BillingAddressId String True

A globally-unique ID.

BillingAddressCoordinatesValidated Bool True

Whether the address coordinates are valid.

BillingAddressName String True

The full name of the customer, based on firstName and lastName.

BillingAddressFirstName String True

The first name of the customer.

BillingAddressLastName String True

The last name of the customer.

BillingAddressAddress1 String True

The first line of the address. Typically the street address or PO Box number.

BillingAddressAddress2 String True

The second line of the address. Typically the number of the apartment, suite, or unit.

BillingAddressCity String True

The name of the city, district, village, or town.

BillingAddressCompany String True

The name of the customer's company or organization.

BillingAddressCountry String True

The name of the country.

BillingAddressLatitude Double True

The latitude coordinate of the customer address.

BillingAddressLongitude Double True

The longitude coordinate of the customer address.

BillingAddressPhone String True

A unique phone number for the customer. Formatted using E. 164 standard. For example, _+16135551111_.

BillingAddressProvince String True

The region of the address, such as the province, state, or district.

BillingAddressZip String True

The zip or postal code of the address.

BillingAddressFormattedArea String True

A comma-separated list of the values for city, province, and country.

BillingAddressProvinceCode String True

The two-letter code for the region. For example, ON.

BillingAddressCountryCodeV2 String True

The two-letter code for the country of the address. For example, US.

ShippingAddressId String False

A globally-unique ID.

ShippingAddressCoordinatesValidated Bool True

Whether the address coordinates are valid.

ShippingAddressName String True

The full name of the customer, based on firstName and lastName.

ShippingAddressFirstName String False

The first name of the customer.

ShippingAddressLastName String False

The last name of the customer.

ShippingAddressAddress1 String False

The first line of the address. Typically the street address or PO Box number.

ShippingAddressAddress2 String False

The second line of the address. Typically the number of the apartment, suite, or unit.

ShippingAddressCity String False

The name of the city, district, village, or town.

ShippingAddressCompany String False

The name of the customer's company or organization.

ShippingAddressCountry String False

The name of the country.

ShippingAddressLatitude Double True

The latitude coordinate of the customer address.

ShippingAddressLongitude Double True

The longitude coordinate of the customer address.

ShippingAddressPhone String False

A unique phone number for the customer. Formatted using E. 164 standard. For example, _+16135551111_.

ShippingAddressProvince String False

The region of the address, such as the province, state, or district.

ShippingAddressZip String False

The zip or postal code of the address.

ShippingAddressFormattedArea String True

A comma-separated list of the values for city, province, and country.

ShippingAddressProvinceCode String False

The two-letter code for the region. For example, ON.

ShippingAddressCountryCodeV2 String False

The two-letter code for the country of the address. For example, US.

ShippingLineId String True

A globally-unique ID.

ShippingLineCarrierIdentifier String True

A reference to the carrier service that provided the rate. Present when the rate was computed by a third-party carrier service.

ShippingLineTitle String True

Returns the title of the shipping line.

ShippingLineCode String True

A reference to the shipping method.

ShippingLineCustom Bool True

Whether the shipping line is custom or not.

ShippingLinePhone String True

The phone number at the shipping address.

ShippingLineSource String True

Returns the rate source for the shipping line.

ShippingLineDeliveryCategory String True

The general classification of the delivery method.

ShippingLineShippingRateHandle String True

A unique identifier for the shipping rate. The format can change without notice and is not meant to be shown to users.

ShippingLineRequestedFulfillmentServiceId String True

The ID of the fulfillment service.

PaymentTermsId String True

A globally-unique ID.

PaymentTermsTranslatedName String True

The payment terms name, translated into the shop admin's preferred language.

PaymentTermsPaymentTermsName String True

The name of the payment terms template used to create the payment terms.

PaymentTermsOverdue Bool True

Whether the payment terms have overdue payment schedules.

PaymentTermsDueInDays Int True

Duration of payment terms in days based on the payment terms template used to create the payment terms.

PaymentTermsPaymentTermsType String True

The payment terms template type used to create the payment terms.

PaymentTermsDraftOrderId String True

A globally-unique ID.

CartDiscountAmountSetPresentmentMoneyAmount Decimal True

Decimal money amount.

CartDiscountAmountSetPresentmentMoneyCurrencyCode String True

Currency of the money.

CartDiscountAmountSetShopMoneyAmount Decimal True

Decimal money amount.

CartDiscountAmountSetShopMoneyCurrencyCode String True

Currency of the money.

ChannelInformationChannelDefinitionId String True

The unique ID for the channel definition.

CurrentCartDiscountAmountSetPresentmentMoneyAmount Decimal True

Decimal money amount.

CurrentCartDiscountAmountSetPresentmentMoneyCurrencyCode String True

Currency of the money.

CurrentCartDiscountAmountSetShopMoneyAmount Decimal True

Decimal money amount.

CurrentCartDiscountAmountSetShopMoneyCurrencyCode String True

Currency of the money.

CurrentSubtotalPriceSetPresentmentMoneyAmount Decimal True

Decimal money amount.

CurrentSubtotalPriceSetPresentmentMoneyCurrencyCode String True

Currency of the money.

CurrentSubtotalPriceSetShopMoneyAmount Decimal True

Decimal money amount.

CurrentSubtotalPriceSetShopMoneyCurrencyCode String True

Currency of the money.

CurrentTotalAdditionalFeesSetPresentmentMoneyAmount Decimal True

Decimal money amount.

CurrentTotalAdditionalFeesSetPresentmentMoneyCurrencyCode String True

Currency of the money.

CurrentTotalAdditionalFeesSetShopMoneyAmount Decimal True

Decimal money amount.

CurrentTotalAdditionalFeesSetShopMoneyCurrencyCode String True

Currency of the money.

CurrentTotalDiscountsSetPresentmentMoneyAmount Decimal True

Decimal money amount.

CurrentTotalDiscountsSetPresentmentMoneyCurrencyCode String True

Currency of the money.

CurrentTotalDiscountsSetShopMoneyAmount Decimal True

Decimal money amount.

CurrentTotalDiscountsSetShopMoneyCurrencyCode String True

Currency of the money.

CurrentTotalDutiesSetPresentmentMoneyAmount Decimal True

Decimal money amount.

CurrentTotalDutiesSetPresentmentMoneyCurrencyCode String True

Currency of the money.

CurrentTotalDutiesSetShopMoneyAmount Decimal True

Decimal money amount.

CurrentTotalDutiesSetShopMoneyCurrencyCode String True

Currency of the money.

CurrentTotalPriceSetPresentmentMoneyAmount Decimal True

Decimal money amount.

CurrentTotalPriceSetPresentmentMoneyCurrencyCode String True

Currency of the money.

CurrentTotalPriceSetShopMoneyAmount Decimal True

Decimal money amount.

CurrentTotalPriceSetShopMoneyCurrencyCode String True

Currency of the money.

CurrentTotalTaxSetPresentmentMoneyAmount Decimal True

Decimal money amount.

CurrentTotalTaxSetPresentmentMoneyCurrencyCode String True

Currency of the money.

CurrentTotalTaxSetShopMoneyAmount Decimal True

Decimal money amount.

CurrentTotalTaxSetShopMoneyCurrencyCode String True

Currency of the money.

NetPaymentSetPresentmentMoneyAmount Decimal True

Decimal money amount.

NetPaymentSetPresentmentMoneyCurrencyCode String True

Currency of the money.

NetPaymentSetShopMoneyAmount Decimal True

Decimal money amount.

NetPaymentSetShopMoneyCurrencyCode String True

Currency of the money.

OriginalTotalAdditionalFeesSetPresentmentMoneyAmount Decimal True

Decimal money amount.

OriginalTotalAdditionalFeesSetPresentmentMoneyCurrencyCode String True

Currency of the money.

OriginalTotalAdditionalFeesSetShopMoneyAmount Decimal True

Decimal money amount.

OriginalTotalAdditionalFeesSetShopMoneyCurrencyCode String True

Currency of the money.

OriginalTotalDutiesSetPresentmentMoneyAmount Decimal True

Decimal money amount.

OriginalTotalDutiesSetPresentmentMoneyCurrencyCode String True

Currency of the money.

OriginalTotalDutiesSetShopMoneyAmount Decimal True

Decimal money amount.

OriginalTotalDutiesSetShopMoneyCurrencyCode String True

Currency of the money.

OriginalTotalPriceSetPresentmentMoneyAmount Decimal True

Decimal money amount.

OriginalTotalPriceSetPresentmentMoneyCurrencyCode String True

Currency of the money.

OriginalTotalPriceSetShopMoneyAmount Decimal True

Decimal money amount.

OriginalTotalPriceSetShopMoneyCurrencyCode String True

Currency of the money.

PaymentCollectionDetailsAdditionalPaymentCollectionUrl String True

The URL to use for collecting an additional payment on the order.

RefundDiscrepancySetPresentmentMoneyAmount Decimal True

Decimal money amount.

RefundDiscrepancySetPresentmentMoneyCurrencyCode String True

Currency of the money.

RefundDiscrepancySetShopMoneyAmount Decimal True

Decimal money amount.

RefundDiscrepancySetShopMoneyCurrencyCode String True

Currency of the money.

SubtotalPriceSetPresentmentMoneyAmount Decimal True

Decimal money amount.

SubtotalPriceSetPresentmentMoneyCurrencyCode String True

Currency of the money.

SubtotalPriceSetShopMoneyAmount Decimal True

Decimal money amount.

SubtotalPriceSetShopMoneyCurrencyCode String True

Currency of the money.

TotalCapturableSetPresentmentMoneyAmount Decimal True

Decimal money amount.

TotalCapturableSetPresentmentMoneyCurrencyCode String True

Currency of the money.

TotalCapturableSetShopMoneyAmount Decimal True

Decimal money amount.

TotalCapturableSetShopMoneyCurrencyCode String True

Currency of the money.

TotalDiscountsSetPresentmentMoneyAmount Decimal True

Decimal money amount.

TotalDiscountsSetPresentmentMoneyCurrencyCode String True

Currency of the money.

TotalDiscountsSetShopMoneyAmount Decimal True

Decimal money amount.

TotalDiscountsSetShopMoneyCurrencyCode String True

Currency of the money.

TotalOutstandingSetPresentmentMoneyAmount Decimal True

Decimal money amount.

TotalOutstandingSetPresentmentMoneyCurrencyCode String True

Currency of the money.

TotalOutstandingSetShopMoneyAmount Decimal True

Decimal money amount.

TotalOutstandingSetShopMoneyCurrencyCode String True

Currency of the money.

TotalPriceSetPresentmentMoneyAmount Decimal True

Decimal money amount.

TotalPriceSetPresentmentMoneyCurrencyCode String True

Currency of the money.

TotalPriceSetShopMoneyAmount Decimal True

Decimal money amount.

TotalPriceSetShopMoneyCurrencyCode String True

Currency of the money.

TotalReceivedSetPresentmentMoneyAmount Decimal True

Decimal money amount.

TotalReceivedSetPresentmentMoneyCurrencyCode String True

Currency of the money.

TotalReceivedSetShopMoneyAmount Decimal True

Decimal money amount.

TotalReceivedSetShopMoneyCurrencyCode String True

Currency of the money.

TotalRefundedSetPresentmentMoneyAmount Decimal True

Decimal money amount.

TotalRefundedSetPresentmentMoneyCurrencyCode String True

Currency of the money.

TotalRefundedSetShopMoneyAmount Decimal True

Decimal money amount.

TotalRefundedSetShopMoneyCurrencyCode String True

Currency of the money.

TotalRefundedShippingSetPresentmentMoneyAmount Decimal True

Decimal money amount.

TotalRefundedShippingSetPresentmentMoneyCurrencyCode String True

Currency of the money.

TotalRefundedShippingSetShopMoneyAmount Decimal True

Decimal money amount.

TotalRefundedShippingSetShopMoneyCurrencyCode String True

Currency of the money.

TotalShippingPriceSetPresentmentMoneyAmount Decimal True

Decimal money amount.

TotalShippingPriceSetPresentmentMoneyCurrencyCode String True

Currency of the money.

TotalShippingPriceSetShopMoneyAmount Decimal True

Decimal money amount.

TotalShippingPriceSetShopMoneyCurrencyCode String True

Currency of the money.

TotalTaxSetPresentmentMoneyAmount Decimal True

Decimal money amount.

TotalTaxSetPresentmentMoneyCurrencyCode String True

Currency of the money.

TotalTaxSetShopMoneyAmount Decimal True

Decimal money amount.

TotalTaxSetShopMoneyCurrencyCode String True

Currency of the money.

TotalTipReceivedSetPresentmentMoneyAmount Decimal True

Decimal money amount.

TotalTipReceivedSetPresentmentMoneyCurrencyCode String True

Currency of the money.

TotalTipReceivedSetShopMoneyAmount Decimal True

Decimal money amount.

TotalTipReceivedSetShopMoneyCurrencyCode String True

Currency of the money.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060