JDBC Driver for Magento

Build 22.0.8462

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.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462