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 Descriptions:
| Name | Type | Description |
| RMACHARGE_ID | BIGINT NOT NULL | Generated unique key. |
| RMAITEM_ID | BIGINT | 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. |
| 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. |
| RMA_ID | BIGINT NOT NULL | The RMA to which this charge or credit
applies. |
| AMOUNT | DECIMAL (20,5) NOT NULL | Amount of the charge or credit. |
| CURRENCY | CHAR (3) NOT NULL | Currency used for the charge or credit. This is a
currency code as per ISO 4217 standards. |
| OPTCOUNTER | SMALLINT | The optimistic concurrency control counter for
the table. Every time there is an update to the table, the counter
is incremented. |
Indexes:
| Name | Column Names | Type |
| <SYSTEM-GENERATED> | RMACHARGE_ID | Primary Key |
| I0000744 | RMAITEM_ID | Non-Unique Index |
| I0000745 | RMA_ID | Non-Unique Index |
| I0001280 | CHARGETYPE_ID | Non-Unique Index |
Constrained By Parent Tables:
| Constraint | Columns | Parent Table | Parent Columns | 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 |