Database Table: TRDDEPAMT

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

Column Name Column Type Column Description
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.
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 column. This is an alphabetic currency code as per ISO 4217.
TRADING_ID BIGINT
NOT NULL
ID for the TradingAgreement. Foreign key to the TRADING table.
TRDDEPAMT_ID BIGINT
NOT NULL
Generated unique key for this row.
Indexes:
Index Name Indexed Column Names Index Type
I0000257 TRADING_ID, ORDERS_ID, ORDERITEMS_ID Unique Index
SQL030416035137400 TRDDEPAMT_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint 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

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