SalesCreditmemo

SalesCreditmemo is an auto generated table

Columns

Name	Type	ReadOnly	Description
Adjustment	String	False	Credit memo adjustment.
AdjustmentNegative	String	False	Credit memo negative adjustment.
AdjustmentPositive	String	False	Credit memo positive adjustment.
BaseAdjustment	String	False	Credit memo base adjustment.
BaseAdjustmentNegative	String	False	Credit memo negative base adjustment.
BaseAdjustmentPositive	String	False	Credit memo positive base adjustment.
BaseCurrencyCode	String	False	Credit memo base currency code.
BaseDiscountAmount	String	False	Credit memo base discount amount.
BaseDiscountTaxCompensationAmount	String	False	Credit memo base discount tax compensation amount.
BaseGrandTotal	String	False	Credit memo base grand total.
BaseShippingAmount	String	False	Credit memo base shipping amount.
BaseShippingDiscountTaxCompensationAmnt	String	False	Credit memo base shipping discount tax compensation amount.
BaseShippingInclTax	String	False	Credit memo base shipping including tax.
BaseShippingTaxAmount	String	False	Credit memo base shipping tax amount.
BaseSubtotal	String	False	Credit memo base subtotal.
BaseSubtotalInclTax	String	False	Credit memo base subtotal including tax.
BaseTaxAmount	String	False	Credit memo base tax amount.
BaseToGlobalRate	String	False	Credit memo base-to-global rate.
BaseToOrderRate	String	False	Credit memo base-to-order rate.
BillingAddressId	Int	False	Credit memo billing address ID.
Comments	String	False	Array of any credit memo comments. Otherwise, null.
CreatedAt	Datetime	False	Credit memo created-at timestamp.
CreditmemoStatus	Int	False	Credit memo status.
DiscountAmount	String	False	Credit memo discount amount.
DiscountDescription	String	False	Credit memo discount description.
DiscountTaxCompensationAmount	String	False	Credit memo discount tax compensation amount.
EmailSent	Int	False	Credit memo email sent flag value.
EntityId [KEY]	Int	False	Credit memo ID.
ExtensionAttributes	String	False	This is an auto-generated column
GlobalCurrencyCode	String	False	Credit memo global currency code.
GrandTotal	String	False	Credit memo grand total.
IncrementId	String	False	Credit memo increment ID.
InvoiceId	Int	False	Credit memo invoice ID.
OrderCurrencyCode	String	False	Credit memo order currency code.
OrderId	Int	False	Credit memo order ID.
ShippingAddressId	Int	False	Credit memo shipping address ID.
ShippingAmount	String	False	Credit memo shipping amount.
ShippingDiscountTaxCompensationAmount	String	False	Credit memo shipping discount tax compensation amount.
ShippingInclTax	String	False	Credit memo shipping including tax.
ShippingTaxAmount	String	False	Credit memo shipping tax amount.
State	Int	False	Credit memo state.
StoreCurrencyCode	String	False	Credit memo store currency code.
StoreId	Int	False	Credit memo store ID.
StoreToBaseRate	String	False	Credit memo store-to-base rate.
StoreToOrderRate	String	False	Credit memo store-to-order rate.
Subtotal	String	False	Credit memo subtotal.
SubtotalInclTax	String	False	Credit memo subtotal including tax.
TaxAmount	String	False	Credit memo tax amount.
TransactionId	String	False	Credit memo transaction ID.
UpdatedAt	Datetime	False	Credit memo 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 credit memo ID.