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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000257 | TRADING_ID, ORDERS_ID, ORDERITEMS_ID | Unique Index |
SQL030416035137400 | TRDDEPAMT_ID | Primary Key |
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 |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|