TRADE The table contains information about trades. Prefix: T_ Column Name Data Type Constraints Relations Description T_ID TRADE_T Not Null PK Trade identifier. T_DTS DATETIME Not Null Date and time of trade. Status type identifier; identifies the T_ST_ID CHAR(4) Not Null FK (ST_) status of this trade. Trade type identifier; identifies the type T_TT_ID CHAR(3) Not Null FK (TT_) of his trade. Not Null Is this trade a cash (1) or margin (0) T_IS_CASH BOOLEAN trade? in 0, 1 Security symbol of the security that was T_S_SYMB CHAR(15) Not Null FK (S_) traded. Not Null T_QTY S_QTY_T Quantity of securities traded. >0 Not Null T_BID_PRICE S_PRICE_T The requested unit price. > 0 T_CA_ID IDENT_T Not Null FK (CA_) Customer account identifier. T_EXEC_NAME CHAR(49) Not Null Name of the person executing the trade. Unit price at which the security was T_TRADE_PRICE S_PRICE_T traded. Not Null Fee charged for placing this trade T_CHRG VALUE_T request. >= 0 Not Null Commission earned on this trade; may T_COMM VALUE_T be zero. >= 0 Amount of tax due on this trade; can be Not Null zero. Whether the tax is withheld from T_TAX VALUE_T the settlement amount depends on the >= 0 customer account tax status. If this trade is closing an existing position, is it executed against the Not Null T_LIFO BOOLEAN oldest account holdings of this security in 0, 1 (1=LIFO) or against the oldest-to-newest account holdings (0=FIFO). TRADE_HISTORY The contains the history of each trade transaction through the various states. Table Prefix: TH_ Column Name Data Type Constraints Relations Description identifier. This value will be used for the corresponding T_ID in the PK+ TH_T_ID TRADE_T Not Null TRADE and SE_T_ID in the FK (T_) SETTLEMENT table if this trade request results in a trade.
TRADE The table contains information about trades. Prefix: T_ Column Name Data Type Constraints Relations Description T_ID TRADE_T Not Null PK Trade identifier. T_DTS DATETIME Not Null Date and time of trade. T_ST_ID CHAR(4) Not Null FK (ST_) Status type identifier; identifies the status of this trade. T_TT_ID CHAR(3) Not Null FK (TT_) Trade type identifier; identifies the type of his trade. T_IS_CASH BOOLEAN Not Null in 0, 1 Is this trade a cash (1) or margin (0) trade? T_S_SYMB CHAR(15) Not Null FK (S_) Security symbol of the security that was traded. T_QTY S_QTY_T Not Null >0 Quantity of securities traded. T_BID_PRICE S_PRICE_T Not Null > 0 The requested unit price. T_CA_ID IDENT_T Not Null FK (CA_) Customer account identifier. T_EXEC_NAME CHAR(49) Not Null Name of the person executing the trade. T_TRADE_PRICE S_PRICE_T Unit price at which the security was traded. T_CHRG VALUE_T Not Null >= 0 Fee charged for placing this trade request. T_COMM VALUE_T Not Null >= 0 Commission earned on this trade; may be zero. T_TAX VALUE_T Not Null >= 0 Amount of tax due on this trade; can be zero. Whether the tax is withheld from the settlement amount depends on the customer account tax status. T_LIFO BOOLEAN Not Null in 0, 1 If this trade is closing an existing position, is it executed against the account holdings of this security (1=LIFO) or against the oldest-to-newest account holdings (0=FIFO). TRADE_HISTORY The contains the history of each trade transaction through the various states. Table Prefix: TH_ Column Name Data Type Constraints Relations Description TH_T_ID TRADE_T Not Null PK+ FK (T_) identifier. This value will be used for the corresponding T_ID in the TRADE and SE_T_ID in the SETTLEMENT table if this trade request results in a trade. oldest
tpcx-v_v2.1.0.docx