Returns consignments and their corresponding shipping orders.
Table Specific Information
The 本製品 uses the BigCommerce API to process WHERE clause conditions built with the following columns and operators:
- OrderId supports the '=' comparison.
For example, the following queries are processed server-side:
SELECT * FROM ShippingConsignments WHERE OrderId = 123
|ID of the shipping consignment.
|Identifier for the BigCommerce Order with which this transaction is associated.
|Street address (first line).
|Street address (second line).
|Recipient?s email address.
|Recipient?s telephone number.
|The total number of items in the order.
|The number of items that have been shipped.
|Text identifying the BigCommerce shipping module selected by the customer.
|The base shipping cost value.
|The shipping cost value excluding tax.
|The shipping cost value including tax.
|The tax amount on the shipping cost.
|The ID of the tax class applied to the shipping cost. Ignored if automatic tax is enabled.
|The base handling charge.
|The handling charge, excluding tax.
|The handling charge, including tax.
|The handling charge, including tax number.
|The ID of the tax class applied to the handling charge. Ignored if automatic tax is enabled.
|The numeric ID of the shipping zone.
|The name of the shipping zone.
|URL where you can use a GET request to get the shipping quotes for the order consignment.
|Path where you can use a GET request to get the shipping quotes for the order consignment.
|zip code of the shipping quotes.
|URL where you can use a GET request to get the shipping line items for the order consignment.
|Path where you can use a GET request to get the shipping line items for the order consignment.