QuoteCartTotal
QuoteCartTotal is an auto generated table. The supported operations are Querying data from this table.
Table Specific Information
Select
The add-in uses the AdobeCommerce API to filter the results by CartId while the rest of the filter is executed client side within the add-in.
The CartId column must be specified in the WHERE clause to retrieve results from QuoteCartTotal. CartId can be used only with the equals (=) operator.
For example:
SELECT * FROM [QuoteCartTotal] WHERE CartId = '123'
Columns
| Name | Type | Description |
| BaseCurrencyCode | String | Base currency code |
| CartId | String | cartId |
| BaseDiscountAmount | Double | Discount amount in base currency |
| BaseGrandTotal | Double | Grand total in base currency |
| BaseShippingAmount | Double | Shipping amount in base currency |
| BaseShippingDiscountAmount | Double | Shipping discount amount in base currency |
| BaseShippingInclTax | Double | Shipping including tax in base currency |
| BaseShippingTaxAmount | Double | Shipping tax amount in base currency |
| BaseSubtotal | Double | Subtotal in base currency |
| BaseSubtotalInclTax | Double | Subtotal including tax in base currency |
| BaseSubtotalWithDiscount | Double | Subtotal in base currency with applied discount |
| BaseTaxAmount | Double | Tax amount in base currency |
| CouponCode | String | Applied coupon code |
| DiscountAmount | Double | Discount amount in quote currency |
| ExtensionAttributes | String | This is an auto-generated column |
| GrandTotal | Double | Grand total in quote currency |
| Items | String | Totals by items |
| ItemsQty | Int | Items qty |
| QuoteCurrencyCode | String | Quote currency code |
| ShippingAmount | Double | Shipping amount in quote currency |
| ShippingDiscountAmount | Double | Shipping discount amount in quote currency |
| ShippingInclTax | Double | Shipping including tax in quote currency |
| ShippingTaxAmount | Double | Shipping tax amount in quote currency |
| Subtotal | Double | Subtotal in quote currency |
| SubtotalInclTax | Double | Subtotal including tax in quote currency |
| SubtotalWithDiscount | Double | Subtotal in quote currency with applied discount |
| TaxAmount | Double | Tax amount in quote currency |
| TotalSegments | String | Dynamically calculated totals |
| WeeeTaxAppliedAmount | Double | Item weee tax applied amount in quote currency. |