🛒 Magento_Sales · engine innodb

sales_creditmemo_item

Sales Flat Creditmemo Item

Neighbourhood (1-hop foreign-key graph — showing 1 of 1)

flowchart LR
  c["sales_creditmemo_item"]:::center
  n0["sales_creditmemo"]
  click n0 "/schema/table/sales_creditmemo"
  n0 -- parent_id --> c
  click c "/schema/table/sales_creditmemo_item"
  classDef center fill:#eef2ff,stroke:#6366f1,color:#3730a3,stroke-width:1.5px

Click a node to jump to that table.

Related tables (1)

parent_id → sales_creditmemo

Columns (34)

Name	Type	Null	Comment
entity_id PK	int unsigned	no	Entity ID
parent_id	int unsigned	no	Parent ID
base_price	decimal	yes	Base Price
tax_amount	decimal	yes	Tax Amount
base_row_total	decimal	yes	Base Row Total
discount_amount	decimal	yes	Discount Amount
row_total	decimal	yes	Row Total
base_discount_amount	decimal	yes	Base Discount Amount
price_incl_tax	decimal	yes	Price Incl Tax
base_tax_amount	decimal	yes	Base Tax Amount
base_price_incl_tax	decimal	yes	Base Price Incl Tax
qty	decimal	yes	Qty
base_cost	decimal	yes	Base Cost
price	decimal	yes	Price
base_row_total_incl_tax	decimal	yes	Base Row Total Incl Tax
row_total_incl_tax	decimal	yes	Row Total Incl Tax
product_id	int	yes	Product ID
order_item_id	int	yes	Order Item ID
additional_data	text	yes	Additional Data
description	text	yes	Description
sku	varchar(255)	yes	Sku
name	varchar(255)	yes	Name
discount_tax_compensation_amount	decimal	yes	Discount Tax Compensation Amount
base_discount_tax_compensation_amount	decimal	yes	Base Discount Tax Compensation Amount
tax_ratio	text	yes	Ratio of tax in the creditmemo item over tax of the order item
weee_tax_applied	text	yes	Weee Tax Applied
weee_tax_applied_amount	decimal	yes	Weee Tax Applied Amount
weee_tax_applied_row_amount	decimal	yes	Weee Tax Applied Row Amount
weee_tax_disposition	decimal	yes	Weee Tax Disposition
weee_tax_row_disposition	decimal	yes	Weee Tax Row Disposition
base_weee_tax_applied_amount	decimal	yes	Base Weee Tax Applied Amount
base_weee_tax_applied_row_amnt	decimal	yes	Base Weee Tax Applied Row Amnt
base_weee_tax_disposition	decimal	yes	Base Weee Tax Disposition
base_weee_tax_row_disposition	decimal	yes	Base Weee Tax Row Disposition

Keys & indexes

Primary key: entity_id

Indexes

SALES_CREDITMEMO_ITEM_PARENT_ID (parent_id) btree

References (1)

parent_id → sales_creditmemo .entity_id (on delete CASCADE)