Reference > Database > WebSphere Commerce database tables > T
WebSphere Commerce 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 Agreements with Right-to-Buy by Amount or Obligation-to-Buy by Amount Terms and Conditions.
Column Name Column Type Description TRDREFAMT_ID BIGINT NOT NULL No TRDREFAMT_ID external description assigned yet 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 Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type SQL100520030443570 TRDREFAMT_ID Primary Key I0000821 TRADING_ID Non-Unique Index I0000822 RMA_ID Non-Unique Index I0000823 ORDERS_ID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_880 ORDERS_ID ORDERS ORDERS_ID Cascade F_881 RMA_ID RMA RMA_ID Cascade F_879 SETCCURR SETCURR SETCCURR Cascade F_882 TRADING_ID TRADING TRADING_ID Cascade
Related reference
_vcc_freeselect_bottom_