This table is used to keep track of Purchase Amounts by Trading Agreements, by Orders or OrderItems. 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 |
Expected purchase amounts for this Trading Agreement for this Order or OrderItem. The amount is in the same currency of the Right-to-Buy Amount and Obligation-to-Buy Amount. |
ORDERITEMS_ID | BIGINT NULL |
ID of the OrderItem. This is set to null if all the OrderItems of the Order specify the same Trading ID. Foreign key to the ORDERITEMS table. |
ORDERS_ID | BIGINT NOT NULL |
Order ID. Foreign key to the ORDERS table. |
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. |
TRDPURAMT_ID | BIGINT NOT NULL |
Generated unique key for this row. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
SQL030416035138560 | TRDPURAMT_ID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_875 | SETCCURR | SETCURR | SETCCURR | Cascade |
F_876 | ORDERITEMS_ID | ORDERITEMS | ORDERITEMS_ID | Cascade |
F_877 | ORDERS_ID | ORDERS | ORDERS_ID | Cascade |
F_878 | TRADING_ID | TRADING | TRADING_ID | Cascade |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|