SalesInvoice

SalesInvoice is an auto generated table

Columns


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	State.
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	Subtotal.
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-Columns

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.

JDBC Driver for Magento

SalesInvoice

Columns

Pseudo-Columns