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:

Name	Type	Description
TRDREFAMT_ID	BIGINT NOT NULL	Primary key
ORDERS_ID	BIGINT NOT NULL	Order ID. Foreign key to the ORDERS table.
SETCCURR	CHAR (3)	Currency of the Amount field. This is a currency code as per ISO 4217 standards.
RMA_ID	BIGINT NOT NULL	ID for the Return Merchandise Authorization (RMA).
TRADING_ID	BIGINT NOT NULL	ID for the Trading Agreement. Foreign key to the TRADING table.
AMOUNT	DECIMAL (20,5) NOT NULL	Total 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.
OPTCOUNTER	SMALLINT NOT NULL DEFAULT 0	The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

Name	Column Names	Type
<SYSTEM-GENERATED>	TRDREFAMT_ID	Primary Key
I0000821	TRADING_ID	Non-Unique Index
I0000822	RMA_ID	Non-Unique Index
I0000823	ORDERS_ID	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_879	SETCCURR	SETCURR	SETCCURR	Cascade
F_880	ORDERS_ID	ORDERS	ORDERS_ID	Cascade
F_881	RMA_ID	RMA	RMA_ID	Cascade
F_882	TRADING_ID	TRADING	TRADING_ID	Cascade

Related reference
Order trading agreement data model