ShippingConsignmentQuotes
Gets all shipping quotes persisted on an order for a shipping consignment.
Table Specific Information
Select
The connector 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 | References | Description |
| Id | Integer | ID of the shipping quote. | |
| OrderId | Integer |
Orders.Id | 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 | Integer | 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. |