QuoteCartTotal
QuoteCartTotal is an auto generated table. The supported operations are Querying data from this table.
Table Specific Information
Select
The connector uses the AdobeCommerce API to filter the results by CartId while the rest of the filter is executed client side within the connector.
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. |