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 Description(s):
Column NameColumn TypeDescription
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.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031306110 RMAAUTHLOG_ID Primary Key
I0000743 RMA_ID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_700 RMA_ID RMA RMA_ID Cascade

Feedback