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 Descriptions
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
SQL060903235244500 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