WebSphere Commerce 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 Descriptions
Column Name Column Type Description
RMAIADJCRD_ID BIGINT NOT NULL Generated unique key.
RMAITEM_ID BIGINT NOT NULL The RMA item for which the credit applies.
ORDADJUST_ID BIGINT NOT NULL The order adjustment that is being credited.
AMOUNT DECIMAL (20,5) NOT NULL DEFAULT 0 Amount of the RMA item adjustment credit.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL060903235244820 RMAIADJCRD_ID Primary Key
I0000214 RMAITEM_ID Non-Unique Index
I0000746 ORDADJUST_ID Non-Unique Index

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
Related reference