OrderCustomsItems
Customs Items of the Orders.
Select
The add-in will use the ShipStation API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the add-in.
- OrderId supports the following operator: =.
Note: OrderId is required in order to query OrderCustomsItems. For example, the following query is processed server side:
SELECT * FROM OrderCustomsItems WHERE OrderId = 2810333
Columns
Name | Type | References | Description |
CustomsItemId [KEY] | Long | Id of the customs Item. | |
CountryOfOrigin | String | Origin country of the customs Item. | |
Description | String | Description of the customs Item. | |
HarmonizedTariffCode | String | Harmonized tariff code of the customers Item. | |
Quantity | Integer | Quantity of the customs Item. | |
Value | Double | Value of the customs Item. | |
OrderId [KEY] | Long | Id of the Order. |