WebSphere Commerce 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 Descriptions
Column Name Column 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 Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL060903235304040 TRDPURAMT_ID Primary Key
I0000818 TRADING_ID Non-Unique Index
I0000819 ORDERS_ID Non-Unique Index
I0000820 ORDERITEMS_ID Non-Unique Index

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_876 ORDERITEMS_ID ORDERITEMS ORDERITEMS_ID Cascade
F_877 ORDERS_ID ORDERS ORDERS_ID Cascade
F_875 SETCCURR SETCURR SETCCURR Cascade
F_878 TRADING_ID TRADING TRADING_ID Cascade
Related reference