TRDDEPAMT

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

Column Descriptions:

NameTypeDescription
TRDDEPAMT_IDBIGINT NOT NULLGenerated unique key for this row.
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.)
ORDERS_IDBIGINT NOT NULLOrder ID. Foreign key to the ORDERS table.
TRADING_IDBIGINT NOT NULLID for the TradingAgreement. Foreign key to the TRADING table.
SETCCURRCHAR (3)Currency of the AMOUNT column. This is an alphabetic currency code as per ISO 4217.
AMOUNTDECIMAL (20,5) NOT NULLThe 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.
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>TRDDEPAMT_IDPrimary Key
I0000257TRADING_ID+ORDERS_ID+ORDERITEMS_IDUnique Index
I0000816ORDERS_IDNon-Unique Index
I0000817ORDERITEMS_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_869SETCCURRSETCURRSETCCURRCascade
F_870ORDERITEMS_IDORDERITEMSORDERITEMS_IDCascade
F_871ORDERS_IDORDERSORDERS_IDCascade
F_872TRADING_IDTRADINGTRADING_IDCascade