TRDDEPAMT

This table is used to keep track of deposited amounts by TradingAgreements, by Orders or OrderItems.

Column Descriptions:

Name	Type	Description
TRDDEPAMT_ID	BIGINT NOT NULL	Generated unique key for this row.
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.)
ORDERS_ID	BIGINT NOT NULL	Order ID. Foreign key to the ORDERS table.
TRADING_ID	BIGINT NOT NULL	ID for the TradingAgreement. Foreign key to the TRADING table.
SETCCURR	CHAR (3)	Currency of the AMOUNT column. This is an alphabetic currency code as per ISO 4217.
AMOUNT	DECIMAL (20,5) NOT NULL	The deposited amount for the Order or OrderItem for this TradingAgreement. The amount is in the default currency of the Store to which the Order belongs.
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>	TRDDEPAMT_ID	Primary Key
I0000257	TRADING_ID+ORDERS_ID+ORDERITEMS_ID	Unique Index
I0000816	ORDERS_ID	Non-Unique Index
I0000817	ORDERITEMS_ID	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_869	SETCCURR	SETCURR	SETCCURR	Cascade
F_870	ORDERITEMS_ID	ORDERITEMS	ORDERITEMS_ID	Cascade
F_871	ORDERS_ID	ORDERS	ORDERS_ID	Cascade
F_872	TRADING_ID	TRADING	TRADING_ID	Cascade

Related reference
Order trading agreement data model