ShippingConsignmentQuotes
Gets all shipping quotes persisted on an order for a shipping consignment.
Table Specific Information
Select
The server uses the BigCommerce API to process WHERE clause conditions built with the following columns and operators:
- OrderId supports the = comparison.
- ShippingConsignmentId supports the = comparison.
For example, the following queries are processed server-side:
SELECT * FROM ShippingConsignmentQuotes WHERE OrderId = 123 and ShippingConsignmentId = 234
Columns
| Name | Type | Description |
| Id | Integer | ID of the shipping quote. |
| OrderId | Integer | Identifier for the BigCommerce Order with which this transaction is associated. |
| ShippingConsignmentId | Integer | ID of the shipping consignment. |
| UUID | String | UUID of the shipping quote. |
| Timestamp | String | Time the order was created in RFC 2822 format. |
| ProviderCode | String | Code of the shipping provider. |
| CarrierCode | String | Code of the shipping carrier. |
| RateCode | String | Type of delivery. This can vary based on shipping quote. |
| RateId | String | This can vary based on shipping quote. |
| MethodId | Integer | Shipping method ID. |
| ProviderQuoteRateValue | Decimal | Provider quote's rate_value. |
| ProviderQuoteRateUnit | String | Provider quote's rate_unit. |
| ProviderQuoteName | String | Provider quote's name. |
| ProviderQuoteTransitTime | Integer | Provider quote's transitTime. |
| ProviderQuoteSignatureConfirmationFee | String | Provider quote's signatureConfirmationFee. |
| ProviderQuoteCarrierName | String | Provider quote's CarrierName. |
| ProviderQuoteDeliveryMessage | String | Provider quote's deliveryMessage. |
| ProviderQuoteLabelSizes | String | Provider quote's label sizes. |
| ProviderQuoteDates | String | Provider quote's dates. |
| ProviderQuoteInsuredMailFee | String | Provider quote's insuredMailFee. |
| ProviderQuoteRateId | String | Provider quote's rateId. |
| ProviderQuoteDescription | String | Provider quote's description. |
| ProviderQuoteAdditionalInfo | String | Provider quote's additionalInfo. |