Views
Views are similar to tables in the way that data is represented; however, views are read-only.
Queries can be executed against a view as if it were a normal table.
CData ODBC Driver for BigCommerce Views
| Name | Description |
| BlogTags | Returns a list of Blog Tags. |
| CartCoupons | Returns the coupons applied to a cart. This table is read-only; coupons are redeemed through checkout, not the Carts management API. |
| CartDiscounts | Returns the cart-level discounts applied to a cart. This table is read-only; discounts are computed automatically from active promotions. |
| DownloadConsignments | Returns consignments and their corresponding downloads. |
| EmailConsignments | Returns consignments and their corresponding emails. |
| GiftCertificates | Lists all gift certificates. |
| InventoryItems | Returns a list of catalog items that have inventory tracked, along with their identifying information. |
| OrderCoupons | Lists all order coupons. |
| OrderItemOptionValues | Returns data from OrderItems table. |
| OrderMessages | Gets the messages associated with an order. |
| OrderRefunds | Returns a list of refunds. |
| OrderRefundsItems | List of Items refunded. |
| OrderRefundsPayments | Refund payments made to payment providers. |
| OrderShippingAddresses | Returns shipping addresses and their corresponding orders. |
| OrderStatuses | Returns order statuses. |
| OrderTaxes | Gets all order taxes related to an order. |
| PaymentMethods | Returns available payment methods for a given order or checkout. |
| PickupConsignments | Returns consignments and their corresponding pickups. |
| PriceListAssignments | Returns an array of Price List Assignments matching a particular Customer Group and Price List and Channel. |
| ProductCustomFields | Returns a list of product Custom Fields. |
| ProductRuleConditions | Returns conditions associated with product complex rules. |
| ProductVariantValues | Returns data from Products table. |
| ProductVariantValuesForLocale | List of product option values with locale overrides. |
| ProductVideos | Returns Embedded videos displayed on product listings. |
| SharedVariantOptionsLocale | List of shared product options with locale overrides. |
| ShipmentItems | Returns data from Items within a shipment. |
| ShippingConsignmentQuotes | Gets all shipping quotes persisted on an order for a shipping consignment. |
| ShippingConsignments | Returns consignments and their corresponding shipping orders. |
| ShippingSettings | Retrieves global-level shipping settings. |
| ShippingZoneLocations | Lists all shipping zone locations |
| Stores | Lists all Stores. |
| TaxSettings | Retrieves global-level tax settings. |
| Transactions | Lists all transactions. |