SalesInvoice

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

Columns


Name	Type	ReadOnly	Description
BaseCurrencyCode	String	False	Base currency code.
Id	String	False	id
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	State.
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	Subtotal.
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.

ODBC Driver for Adobe Commerce

SalesInvoice

Columns