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:

NameTypeDescription
TRADING_IDBIGINT NOT NULLID for the Trading Agreement. Foreign key to the TRADING table.
TRDPURAMT_IDBIGINT NOT NULLGenerated unique key for this row.
SETCCURRCHAR (3)Currency of the Amount field. This is a currency code as per ISO 4217 standards.
ORDERITEMS_IDBIGINTID 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.
AMOUNTDECIMAL (20,5) NOT NULLExpected 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_IDBIGINT NOT NULLOrder ID. Foreign key to the ORDERS table.
OPTCOUNTERSMALLINTThe optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>TRDPURAMT_IDPrimary Key
I0000818TRADING_IDNon-Unique Index
I0000819ORDERS_IDNon-Unique Index
I0000820ORDERITEMS_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_875SETCCURRSETCURRSETCCURRCascade
F_876ORDERITEMS_IDORDERITEMSORDERITEMS_IDCascade
F_877ORDERS_IDORDERSORDERS_IDCascade
F_878TRADING_IDTRADINGTRADING_IDCascade