Power BI Connector for Adobe Commerce

Build 23.0.8839


OrderItems is an auto generated table. The supported operations are Querying data from this table.

Table Specific Information


The 本製品 will use the AdobeCommerce API to filter the results by ItemId while the rest of the filter is executed client side within the 本製品.

The following examples demonstrate the types of queries processed on the server.

  • Retrieve information about all order items:
    SELECT * FROM OrderItems
  • Filter by ItemId to get detailed information about an order item:
    SELECT * FROM OrderItems WHERE ItemId = '3'


Name Type Description
AdditionalData String Additional data.
Id String id
AmountRefunded Double Amount refunded.
AppliedRuleIds String Applied rule IDs.
BaseAmountRefunded Double Base amount refunded.
BaseCost Double Base cost.
BaseDiscountAmount Double Base discount amount.
BaseDiscountInvoiced Double Base discount invoiced.
BaseDiscountRefunded Double Base discount refunded.
BaseDiscountTaxCompensationAmount Double Base discount tax compensation amount.
BaseDiscountTaxCompensationInvoiced Double Base discount tax compensation invoiced.
BaseDiscountTaxCompensationRefunded Double Base discount tax compensation refunded.
BaseOriginalPrice Double Base original price.
BasePrice Double Base price.
BasePriceInclTax Double Base price including tax.
BaseRowInvoiced Double Base row invoiced.
BaseRowTotal Double Base row total.
BaseRowTotalInclTax Double Base row total including tax.
BaseTaxAmount Double Base tax amount.
BaseTaxBeforeDiscount Double Base tax before discount.
BaseTaxInvoiced Double Base tax invoiced.
BaseTaxRefunded Double Base tax refunded.
BaseWeeeTaxAppliedAmount Double Base WEEE tax applied amount.
BaseWeeeTaxAppliedRowAmnt Double Base WEEE tax applied row amount.
BaseWeeeTaxDisposition Double Base WEEE tax disposition.
BaseWeeeTaxRowDisposition Double Base WEEE tax row disposition.
CreatedAt Datetime Created-at timestamp.
Description String Description.
DiscountAmount Double Discount amount.
DiscountInvoiced Double Discount invoiced.
DiscountPercent Double Discount percent.
DiscountRefunded Double Discount refunded.
DiscountTaxCompensationAmount Double Discount tax compensation amount.
DiscountTaxCompensationCanceled Double Discount tax compensation canceled.
DiscountTaxCompensationInvoiced Double Discount tax compensation invoiced.
DiscountTaxCompensationRefunded Double Discount tax compensation refunded.
ExtensionAttributes String This is an auto-generated column
ExtOrderItemId String External order item ID.
FreeShipping Int Free-shipping flag value.
IsQtyDecimal Int Is-quantity-decimal flag value.
IsVirtual Int Is-virtual flag value.
ItemId [KEY] Int Item ID.
LockedDoInvoice Int Locked DO invoice flag value.
LockedDoShip Int Locked DO ship flag value.
Name String Name.
NoDiscount Int No-discount flag value.
OrderId Int Order ID.
OriginalPrice Double Original price.
ParentItem String This is an auto-generated column
ParentItemId Int Parent item ID.
Price Double Price.
PriceInclTax Double Price including tax.
ProductId Int Product ID.
ProductOption String This is an auto-generated column
ProductType String Product type.
QtyBackordered Double Quantity backordered.
QtyCanceled Double Quantity canceled.
QtyInvoiced Double Quantity invoiced.
QtyOrdered Double Quantity ordered.
QtyRefunded Double Quantity refunded.
QtyShipped Double Quantity shipped.
QuoteItemId Int Quote item ID.
RowInvoiced Double Row invoiced.
RowTotal Double Row total.
RowTotalInclTax Double Row total including tax.
RowWeight Double Row weight.
SearchCriteria String This is an auto-generated column
Sku String SKU.
StoreId Int Store ID.
TaxAmount Double Tax amount.
TaxBeforeDiscount Double Tax before discount.
TaxCanceled Double Tax canceled.
TaxInvoiced Double Tax invoiced.
TaxPercent Double Tax percent.
TaxRefunded Double Tax refunded.
TotalCount Int Total count.
UpdatedAt Datetime Updated-at timestamp.
WeeeTaxApplied String WEEE tax applied.
WeeeTaxAppliedAmount Double WEEE tax applied amount.
WeeeTaxAppliedRowAmount Double WEEE tax applied row amount.
WeeeTaxDisposition Double WEEE tax disposition.
WeeeTaxRowDisposition Double WEEE tax row disposition.
Weight Double Weight.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839