TRDPURAMT

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 Descriptions:

Name	Type	Description
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.
SETCCURR	CHAR (3)	Currency of the Amount field. This is a currency code as per ISO 4217 standards.
ORDERITEMS_ID	BIGINT	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.
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.
ORDERS_ID	BIGINT NOT NULL	Order ID. Foreign key to the ORDERS table.
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>	TRDPURAMT_ID	Primary Key
I0000818	TRADING_ID	Non-Unique Index
I0000819	ORDERS_ID	Non-Unique Index
I0000820	ORDERITEMS_ID	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	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