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.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The 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