Reference > Database > WebSphere Commerce database tables > R
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 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 SQL100520030423860 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
_vcc_freeselect_bottom_