ShippingConsignmentQuotes
Gets all shipping quotes persisted on an order for a shipping consignment.
Table Specific Information
Select
The 本製品 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. |