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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
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 |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|