TDV Adapter for Square

Build 22.0.8462

Orders

Orders specify products for purchase, along with discounts, taxes, and other settings to apply to the purchase.

Table Specific Information

Select

The adapter uses the Square API to process search criteria that refer to the Id column, while other filters are processed client side within the adapter.

Retrieve all the orders in your Square account. Only orders that have been successfully charged are included in the response.

SELECT * FROM Orders

Specify multiple Ids in the WHERE clause using the IN operator:

SELECT * FROM Orders WHERE Id IN ('XKKB7LD30TpfNyW3e843ziklKh4vWEvweQyL5l4ESJLH3N2XXNBN8yqnf11qTrg3W3AelXC1kB','pxICohrEXPDtoUitiZhG1um5uhp5WI7CRMHknbuKpaj53PXfWNBN8yqnf11qTrg3W3AelXC1kB','6j8avtXB5fIaPZ9H12beiZP7sCSiqguGhHpwmECsEaENswJnWNBN8yqnf11qTrg3W3AelXC1kB')

Columns

Name Type Description
Id [KEY] String The order's unique ID.
ReferenceId String A client specified identifier to associate an entity in another system with this order.
LocationId String The Id of the location.
TaxesCatalogObjectId String Only used for catalog taxes. The catalog object ID of an existing CatalogTax.
TaxesName String Only used for ad hoc taxes. The tax's name. Do not provide a value for this field if you set catalogobjectid.
TaxesPercentage String Only used for ad hoc taxes. The percentage of the tax, as a string representation of a decimal number.
TaxesMoneyAmount Integer Only used for ad hoc discounts. The monetary amount of the discount.
TaxesMoneyCurrency String Only used for ad hoc discounts. The currency of the discount monetary amount.
DiscountsCatalogObjectId String Only used for catalog taxes. The catalog object ID from exsiting CatalogDiscount.
DiscountsName String Only used for ad hoc discounts. The discount's name.
DiscountsPercentage String Only used for ad hoc discounts. The percentage of the discount, as a string representation of a decimal number.
DiscountsMoneyAmount Integer Only used for ad hoc discounts. The monetary amount of the discount.
DiscountsMoneyCurrency String Only used for ad hoc discounts. The currency of the discount monetary amount.
TotalTaxMoney Integer The total tax amount of money to collect for this order.
TotalTaxMoneyCurrency String The currency of the total tax amount of money to collect for this order.
TotalDiscountMoneyAmount Integer The total discount amount of money to collect for this order.
TotalDiscountMoneyCurrency String The currency of the total discount amount of money to collect for this order.
TotalMoneyAmount Integer The total amount of money to collect for this order.
TotalMoneyCurrency String The currency of the total amount of money to collect for this order.
CreatedAt Datetime The time when the location was created, in RFC 3339 format.
UpdatedAt Datetime The time when the location was updated, in RFC 3339 format.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462