CData JDBC Driver for Magento 2019 - Online Help
Questions / Feedback?


CData JDBC Driver for Magento 2019 - Build 19.0.7354

SalesInvoice is an auto generated table


Name Type ReadOnly Description
BaseCurrencyCode String False

Base currency code.

BaseDiscountAmount String False

Base discount amount.

BaseDiscountTaxCompensationAmount String False

Base discount tax compensation amount.

BaseGrandTotal String False

Base grand total.

BaseShippingAmount String False

Base shipping amount.

BaseShippingDiscountTaxCompensationAmnt String False

Base shipping discount tax compensation amount.

BaseShippingInclTax String False

Base shipping including tax.

BaseShippingTaxAmount String False

Base shipping tax amount.

BaseSubtotal String False

Base subtotal.

BaseSubtotalInclTax String False

Base subtotal including tax.

BaseTaxAmount String False

Base tax amount.

BaseToGlobalRate String False

Base-to-global rate.

BaseToOrderRate String False

Base-to-order rate.

BaseTotalRefunded String 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 String False

Discount amount.

DiscountDescription String False

Discount description.

DiscountTaxCompensationAmount String 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 String False

Grand total.

IncrementId String False

Increment ID.

IsUsedForRefund Int False

Is-used-for-refund flag value.

OrderCurrencyCode String False

Order currency code.

OrderId Int False

Order ID.

ShippingAddressId Int False

Shipping address ID.

ShippingAmount String False

Shipping amount.

ShippingDiscountTaxCompensationAmount String False

Shipping discount tax compensation amount.

ShippingInclTax String False

Shipping including tax.

ShippingTaxAmount String False

Shipping tax amount.

State Int False


StoreCurrencyCode String False

Store currency code.

StoreId Int False

Store ID.

StoreToBaseRate String False

Store-to-base rate.

StoreToOrderRate String False

Store-to-order rate.

Subtotal String False


SubtotalInclTax String False

Subtotal including tax.

TaxAmount String False

Tax amount.

TotalQty String False

Total quantity.

TransactionId String False

Transaction ID.

UpdatedAt Datetime False

Updated-at timestamp.


Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
Id_p Int

The invoice ID.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 19.0.7354.0