TRADING

Each row in this table represents a TradingAgreement.

Column Descriptions:

NameTypeDescription
TRADING_IDBIGINT NOT NULLThe TradingAgreement ID. This is a primary key. A TradingAgreement object can be shared by more than one trading mechanism, such as between an RFQ and a contract.
TRDTYPE_IDINTEGER NOT NULLForeign key to the TRDTYPE table.
ACCOUNT_IDBIGINTAccount associated with this trading agreement. There is no foreign key to the account table to prevent deadlock for the Database Cleanup utility.
STATEINTEGER NOT NULL DEFAULT 0The status of the TradingAgreement as follows: 0 = inactive 1 = active During negotiation, this flag must be set to inactive. When a one-time order from an RFQ is completed, this flag should be marked inactive.
MARKFORDELETEINTEGER NOT NULL DEFAULT 0Indicates if this TradingAgreement has been marked for deletion: 0 = no 1 = yes and this TradingAgreement has been marked for deletion
REFERENCECOUNTINTEGER NOT NULL DEFAULT 0Number of trading mechanisms associated with this TradingAgreement.
STARTTIMETIMESTAMPStart time for the TradingAgreement. If null, the TradingAgreement starts immediately.
ENDTIMETIMESTAMPEnd time for the TradingAgreement. If null, the TradingAgreement has no end time.
CREDITALLOWEDINTEGER NOT NULL DEFAULT 0This column indicates whether or not credit is allowed: 0 = no 1 = yes
REFTRADING_IDBIGINTThis trading agreement refers to the contract identified by this trading ID. It should be identified by the FAMILY_ID of the contract.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The 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>TRADING_IDPrimary Key
I0000815TRDTYPE_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_866TRDTYPE_IDTRDTYPETRDTYPE_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_190TRADING_IDCATENCALCDTRADING_IDCascade
F_209TRADING_IDCATGPCALCDTRADING_IDCascade
F_22TRADING_IDACCOUNTACCOUNT_IDCascade
F_252TRADING_IDCONTRACTCONTRACT_IDCascade
F_3768TRADING_IDEXPRESSIONTRADING_IDCascade
F_498TRADING_IDORDERITEMSTRADING_IDCascade
F_530TRADING_IDORDITRDTRADING_IDCascade
F_539TRADING_IDORDPAYMTHDTRADING_IDCascade
F_559TRADING_IDPARTICIPNTTRADING_IDCascade
F_666TRADING_IDREFUNDMTHDACCOUNT_IDCascade
F_674TRADING_IDRFQRFQ_IDCascade
F_683TRADING_IDRFQRSPRFQRSP_IDCascade
F_696TRADING_IDRMATRADING_IDCascade
F_834TRADING_IDTERMCONDTRADING_IDCascade
F_867TRADING_IDTRDATTACHTRADING_IDCascade
F_872TRADING_IDTRDDEPAMTTRADING_IDCascade
F_874TRADING_IDTRDDESCTRADING_IDCascade
F_878TRADING_IDTRDPURAMTTRADING_IDCascade
F_882TRADING_IDTRDREFAMTTRADING_IDCascade
F_924TRADING_IDTCATTRTRADING_IDCascade
F_929TRADING_IDSHPMODCLCDTRADING_IDCascade
F_931TRADING_IDORDQUOTRELTRADING_IDCascade