Orders
Orders specify products for purchase, along with discounts, taxes, and other settings to apply to the purchase.
Table Specific Information
Select
The 本製品 uses the Square API to process search criteria that refer to the Id column, while other filters are processed client side within the 本製品. You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria that refers to other columns will have an unfiltered response.
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. |