Reference > Database > WebSphere Commerce database tables > R
WebSphere Commerce database table: RMAAUTHLOG
This table is a log of when each return merchandise authorization (RMA) was authorized. A single RMA may appear multiple times if changes were made and the RMA was re-authorized.
Column Name Column Type Description RMAAUTHLOG_ID BIGINT NOT NULL Generated unique key. AUTHNOTICEDATE TIMESTAMP NOT NULL The date on which an RMA was authorized or re-authorized. RMA_ID BIGINT NOT NULL The RMA which was authorized. OPTCOUNTER SMALLINT Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type SQL100520030423510 RMAAUTHLOG_ID Primary Key I0000743 RMA_ID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_700 RMA_ID RMA RMA_ID Cascade
Related reference
_vcc_freeselect_bottom_