TRDREFAMT

This table is used to keep track of Refund Amounts by Trading Agreements, by Orders and by RMA ID. Entries are created only for Trading Agreements with Right-to-Buy by Amount or Obligation-to-Buy by Amount Terms and Conditions.

Column Descriptions:

NameTypeDescription
TRDREFAMT_IDBIGINT NOT NULLPrimary key
ORDERS_IDBIGINT NOT NULLOrder ID. Foreign key to the ORDERS table.
SETCCURRCHAR (3)Currency of the Amount field. This is a currency code as per ISO 4217 standards.
RMA_IDBIGINT NOT NULLID for the Return Merchandise Authorization (RMA).
TRADING_IDBIGINT NOT NULLID for the Trading Agreement. Foreign key to the TRADING table.
AMOUNTDECIMAL (20,5) NOT NULLTotal Refund Amount for this Trading Agreement for this RMA and Order. The amount is in the same currency of the Right-to-Buy Amount and Obligation-to-Buy Amount.
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>TRDREFAMT_IDPrimary Key
I0000821TRADING_IDNon-Unique Index
I0000822RMA_IDNon-Unique Index
I0000823ORDERS_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_879SETCCURRSETCURRSETCCURRCascade
F_880ORDERS_IDORDERSORDERS_IDCascade
F_881RMA_IDRMARMA_IDCascade
F_882TRADING_IDTRADINGTRADING_IDCascade