Database Table: RMACHARGE

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.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416035054060 RMACHARGE_ID Primary Key
Constraints:
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

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable