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:

NameTypeDescription
RMAAUTHLOG_IDBIGINT NOT NULLGenerated unique key.
AUTHNOTICEDATETIMESTAMP NOT NULLThe date on which an RMA was authorized or re-authorized.
RMA_IDBIGINT NOT NULLThe RMA which was authorized.
OPTCOUNTERSMALLINTThe optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>RMAAUTHLOG_IDPrimary Key
I0000743RMA_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_700RMA_IDRMARMA_IDCascade