Database Table: 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 Agreement with Right-to-Buy by Amount or Obligation-to-Buy by Amount Terms and Conditions.

Column Name Column Type Column Description
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.
ORDERS_ID BIGINT
NOT NULL
Order ID. Foreign key to the ORDERS table.
RMA_ID BIGINT
NOT NULL
ID for the Return Merchandise Authorization (RMA).
SETCCURR CHARACTER (3)
NULL
Currency of the Amount field. This is a currency code as per ISO 4217 standards.
TRADING_ID BIGINT
NOT NULL
ID for the Trading Agreement. Foreign key to the TRADING table.
Indexes:
Index Name Indexed Column Names Index Type
Not Applicable
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint 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

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable