Reference > Database > WebSphere Commerce database tables > T
WebSphere Commerce database table: TRDDEPAMT
This table is used to keep track of deposited amounts by TradingAgreements, by Orders or OrderItems.
Column Name Column 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 Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type I0000257 TRADING_ID+ORDERS_ID+ORDERITEMS_ID Unique Index SQL100520030442950 TRDDEPAMT_ID Primary Key I0000816 ORDERS_ID Non-Unique Index I0000817 ORDERITEMS_ID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_870 ORDERITEMS_ID ORDERITEMS ORDERITEMS_ID Cascade F_871 ORDERS_ID ORDERS ORDERS_ID Cascade F_869 SETCCURR SETCURR SETCCURR Cascade F_872 TRADING_ID TRADING TRADING_ID Cascade
Related reference
_vcc_freeselect_bottom_