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 Column Description
AUTHNOTICEDATE TIMESTAMP
NOT NULL
The date on which an RMA was authorized or re-authorized.
RMAAUTHLOG_ID BIGINT
NOT NULL
Generated unique key.
RMA_ID BIGINT
NOT NULL
The RMA which was authorized.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416035053750 RMAAUTHLOG_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_700 RMA_ID RMA RMA_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable