Database Table: RMAIADJCRD

This table stores return merchandise authorization (RMA) item adjustment credits. These are the portion of an order item adjustment that is to be refunded to the buyer.

Column Name Column Type Column Description
AMOUNT DECIMAL (20,5)
NOT NULL, DEFAULT 0
Amount of the RMA item adjustment credit.
ORDADJUST_ID BIGINT
NOT NULL
The order adjustment that is being credited.
RMAIADJCRD_ID BIGINT
NOT NULL
Generated unique key.
RMAITEM_ID BIGINT
NOT NULL
The RMA item for which the credit applies.
Indexes:
Index Name Indexed Column Names Index Type
I0000214 RMAITEM_ID Non-Unique Index
SQL030416035054440 RMAIADJCRD_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_704 ORDADJUST_ID ORDADJUST ORDADJUST_ID Cascade
F_705 RMAITEM_ID RMAITEM RMAITEM_ID Cascade

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