Each row in this table represents a TradingAgreement.
Column Descriptions
| Column Name
| Column Type
| Description |
| TRADING_ID
| BIGINT NOT NULL
| The 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_ID
| INTEGER NOT NULL
| Foreign key to the TRDTYPE table.
|
| ACCOUNT_ID
| BIGINT
| Account associated with this trading agreement. There is no foreign key to the account table to prevent deadlock for the Database Cleanup utility.
|
| STATE
| INTEGER NOT NULL DEFAULT 0
| The 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.
|
| MARKFORDELETE
| INTEGER NOT NULL DEFAULT 0
| Indicates if this TradingAgreement has been marked for deletion:
0 = no
1 = yes and this TradingAgreement has been marked for deletion
|
| REFERENCECOUNT
| INTEGER NOT NULL DEFAULT 0
| Number of trading mechanisms associated with this TradingAgreement.
|
| STARTTIME
| TIMESTAMP
| Start time for the TradingAgreement. If null, the TradingAgreement starts immediately.
|
| ENDTIME
| TIMESTAMP
| End time for the TradingAgreement. If null, the TradingAgreement has no end time.
|
| CREDITALLOWED
| INTEGER NOT NULL DEFAULT 0
| This column indicates whether or not credit is allowed:
0 = no
1 = yes
|
| REFTRADING_ID
| BIGINT
| This trading agreement refers to the contract identified by this trading ID. It should be identified by the FAMILY_ID of the contract.
|
| OPTCOUNTER
| SMALLINT
| Reserved for IBM internal use.
|