This table stores charges or credits, applied to a return merchandise authorization (RMA), which are not for sellable products or services. This can be applicable to the entire RMA or to a specific RMA item, such as restocking fees or shipping credits.
Column Name | Column Type | Column Description |
---|---|---|
AMOUNT | DECIMAL (20,5) NOT NULL |
Amount of the charge or credit. |
CHARGETYPE_ID | INTEGER NOT NULL |
The type of charge or credit. The CHARGETYPE_ID column is a foreign key to the CHARGETYPE table. A return policy uses the charge type of a restocking fee for returned items. |
CURRENCY | CHARACTER (3) NOT NULL |
Currency used for the charge or credit. This is a currency code as per ISO 4217 standards. |
RMACHARGE_ID | BIGINT NOT NULL |
Generated unique key. |
RMAITEM_ID | BIGINT NULL |
The RMA item to which this charge applies. If this field is NULL, then the charge does not apply to a specific RMA item but against the whole RMA. |
RMA_ID | BIGINT NOT NULL |
The RMA to which this charge or credit applies. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
SQL030416035054060 | RMACHARGE_ID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_701 | CHARGETYPE_ID | CHARGETYPE | CHARGETYPE_ID | Cascade |
F_702 | RMA_ID | RMA | RMA_ID | Cascade |
F_703 | RMAITEM_ID | RMAITEM | RMAITEM_ID | Cascade |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|