JDBC Driver for Adobe Commerce

Build 24.0.9060

SalesCreditmemo

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

Columns

Name Type ReadOnly Description
Adjustment Double False

Credit memo adjustment.

Id String False

id

AdjustmentNegative Double False

Credit memo negative adjustment.

AdjustmentPositive Double False

Credit memo positive adjustment.

BaseAdjustment Double False

Credit memo base adjustment.

BaseAdjustmentNegative Double False

Credit memo negative base adjustment.

BaseAdjustmentPositive Double False

Credit memo positive base adjustment.

BaseCurrencyCode String False

Credit memo base currency code.

BaseDiscountAmount Double False

Credit memo base discount amount.

BaseDiscountTaxCompensationAmount Double False

Credit memo base discount tax compensation amount.

BaseGrandTotal Double False

Credit memo base grand total.

BaseShippingAmount Double False

Credit memo base shipping amount.

BaseShippingDiscountTaxCompensationAmnt Double False

Credit memo base shipping discount tax compensation amount.

BaseShippingInclTax Double False

Credit memo base shipping including tax.

BaseShippingTaxAmount Double False

Credit memo base shipping tax amount.

BaseSubtotal Double False

Credit memo base subtotal.

BaseSubtotalInclTax Double False

Credit memo base subtotal including tax.

BaseTaxAmount Double False

Credit memo base tax amount.

BaseToGlobalRate Double False

Credit memo base-to-global rate.

BaseToOrderRate Double 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 Double False

Credit memo discount amount.

DiscountDescription String False

Credit memo discount description.

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

Credit memo grand total.

IncrementId String False

Credit memo increment ID.

InvoiceId Int False

Credit memo invoice ID.

Items String False

Array of credit memo items.

OrderCurrencyCode String False

Credit memo order currency code.

OrderId Int False

Credit memo order ID.

ShippingAddressId Int False

Credit memo shipping address ID.

ShippingAmount Double False

Credit memo shipping amount.

ShippingDiscountTaxCompensationAmount Double False

Credit memo shipping discount tax compensation amount.

ShippingInclTax Double False

Credit memo shipping including tax.

ShippingTaxAmount Double 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 Double False

Credit memo store-to-base rate.

StoreToOrderRate Double False

Credit memo store-to-order rate.

Subtotal Double False

Credit memo subtotal.

SubtotalInclTax Double False

Credit memo subtotal including tax.

TaxAmount Double False

Credit memo tax amount.

TransactionId String False

Credit memo transaction ID.

UpdatedAt Datetime False

Credit memo updated-at timestamp.

SearchCriteria String False

This is an auto-generated column

TotalCount Int False

Total count.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060