RMAIADJCRD

This table stores return merchandise authorization (RMA) item adjustment credits. These are the portion of an order item adjustment that is to be refunded to the buyer.

Column Descriptions:

NameTypeDescription
RMAIADJCRD_IDBIGINT NOT NULLGenerated unique key.
RMAITEM_IDBIGINT NOT NULLThe RMA item for which the credit applies.
ORDADJUST_IDBIGINT NOT NULLThe order adjustment that is being credited.
AMOUNTDECIMAL (20,5) NOT NULL DEFAULT 0Amount of the RMA item adjustment credit.
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>RMAIADJCRD_IDPrimary Key
I0000214RMAITEM_IDNon-Unique Index
I0000746ORDADJUST_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_704ORDADJUST_IDORDADJUSTORDADJUST_IDCascade
F_705RMAITEM_IDRMAITEMRMAITEM_IDCascade