Database Table: 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 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.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416035138560 TRDPURAMT_ID Primary Key
Constraints:
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

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