Power BI Connector for Adobe Commerce

Build 23.0.8839


SalesInvoice is an auto generated table. The supported operations are Insert, and Querying data from this table.


Name Type ReadOnly Description
BaseCurrencyCode String False

Base currency code.

Id String False


BaseDiscountAmount Double False

Base discount amount.

BaseDiscountTaxCompensationAmount Double False

Base discount tax compensation amount.

BaseGrandTotal Double False

Base grand total.

BaseShippingAmount Double False

Base shipping amount.

BaseShippingDiscountTaxCompensationAmnt Double False

Base shipping discount tax compensation amount.

BaseShippingInclTax Double False

Base shipping including tax.

BaseShippingTaxAmount Double False

Base shipping tax amount.

BaseSubtotal Double False

Base subtotal.

BaseSubtotalInclTax Double False

Base subtotal including tax.

BaseTaxAmount Double False

Base tax amount.

BaseToGlobalRate Double False

Base-to-global rate.

BaseToOrderRate Double False

Base-to-order rate.

BaseTotalRefunded Double False

Base total refunded.

BillingAddressId Int False

Billing address ID.

CanVoidFlag Int False

Can void flag value.

Comments String False

Array of any invoice comments. Otherwise, null.

CreatedAt Datetime False

Created-at timestamp.

DiscountAmount Double False

Discount amount.

DiscountDescription String False

Discount description.

DiscountTaxCompensationAmount Double False

Discount tax compensation amount.

EmailSent Int False

Email-sent flag value.

EntityId [KEY] Int False

Invoice ID.

ExtensionAttributes String False

This is an auto-generated column

GlobalCurrencyCode String False

Global currency code.

GrandTotal Double False

Grand total.

IncrementId String False

Increment ID.

IsUsedForRefund Int False

Is-used-for-refund flag value.

Items String False

Array of invoice items.

OrderCurrencyCode String False

Order currency code.

OrderId Int False

Order ID.

SearchCriteria String False

This is an auto-generated column

ShippingAddressId Int False

Shipping address ID.

ShippingAmount Double False

Shipping amount.

ShippingDiscountTaxCompensationAmount Double False

Shipping discount tax compensation amount.

ShippingInclTax Double False

Shipping including tax.

ShippingTaxAmount Double False

Shipping tax amount.

State Int False


StoreCurrencyCode String False

Store currency code.

StoreId Int False

Store ID.

StoreToBaseRate Double False

Store-to-base rate.

StoreToOrderRate Double False

Store-to-order rate.

Subtotal Double False


SubtotalInclTax Double False

Subtotal including tax.

TaxAmount Double False

Tax amount.

TotalCount Int False

Total count.

TotalQty Double False

Total quantity.

TransactionId String False

Transaction ID.

UpdatedAt Datetime False

Updated-at timestamp.

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