| key |
id |
string(100)* |
= |
The id field uniquely identifies the entity record. |
| timeline |
tradingDateTime |
dateTime* |
=< >= |
Date and time when the transaction was executed. |
| query_stats |
sequenceNumber |
long(10000000000000)* |
|
This is an identifier of message |
|
activeIndicator |
boolean* |
|
Indicates if this is the most recent (active) record within the same tradeId group. TRUE=Most recent, FALSE=Superseded |
|
cfiCode |
string(6) |
|
CFI Code (ISO 10962). |
|
consideration |
decimal{23,5} |
|
The total monetary value (or consideration) of the trade. |
|
countryOfIncorporation |
string(3) |
|
Country of Incorporation (ISO 3166). |
|
countryOfIssue |
string(3) |
|
Country of Issue (ISO 3166). |
|
coupon |
decimal{23,5} |
|
Coupon. |
|
deferredFlagPair |
string(20) |
|
Deferral flag pair. "VOLO-FULV", "LMTF-FULF", "FWAF-FULJ", "DATF-FULA", "VOLW-COAF", "OMIS-FULO", "AGFW-FULG" |
|
deferredFlagType |
string(4) |
|
Deferral flag type. "INIT", "FULL" |
|
duplicateCode |
string(20) |
|
Duplicate code. |
|
duplicateFlag |
boolean* |
|
TRUE=Report is a duplicate; FALSE=not a duplicate. |
|
duplicateReason |
string(200) |
|
Duplicate reason. |
|
duplicateReferenceId |
string(16) |
|
Links amendments/cancellations/duplicates to the original trade reports MessageId. |
|
esmaBondType |
string(20) |
|
ESMA FITRS Bond Type. |
|
evaluationFlags |
EvaluationFlags[50] |
|
Array of evaluation flags. |
|
fisn |
string(35) |
|
FISN (ISO 18774). |
|
groupId |
string(16) |
|
Unique ID for a family of trades to link flag pairs to the original trades Trade ID. Populated for: LTMF/FULF, DAFT/FULA, VOLO/FULV, FWAF/FULJ, VOLW/COAF |
|
industrySector |
string(100) |
|
Industry Sector (e.g., Banks, Media). |
|
instrumentClass |
InstrumentClass |
|
Classification (Sovereign, Agency, etc.). |
|
instrumentConditions |
string(4)[100] |
|
Placeholder for unknown additional values/flags. |
| filter_list |
instrumentId |
string(12)* |
= |
Code used to identify the financial instrument (e.g., ISIN AA1234567890). |
|
instrumentIdSource |
string(20)* |
|
Source of instrument ID. "ISIN" |
|
instrumentRatingCategory |
InstrumentRatingCategory |
|
Rating Category (IG, HY, Split, Unrated). |
|
instrumentStatus |
string(20) |
|
Instrument Status (Active, Inactive). |
|
instrumentSymbol |
string(35) |
|
Instrument Short Name. |
|
instrumentTier |
string(100) |
|
Instrument Tier (e.g., Sr Sec, Jr Sub). |
|
issueCurrency |
string(3) |
|
Issue Currency (ISO 4217). |
|
issueType |
string(200) |
|
Issue Type (e.g., Bond). |
|
issuerLegalName |
string(255) |
|
Legal name of the issuer. |
|
issuerLei |
string(20) |
|
Legal Entity Identifier (ISO 17442). |
|
issuerTicker |
string(22) |
|
Issuer ticker. |
|
jurisdiction |
Jurisdiction |
|
Venue Jurisdiction. "EU", "UK" |
|
maturityDate |
date |
|
Maturity Date. |
|
maxEvaluationSeverity |
long(0,5)* |
|
maxEvaluationSeverity 0-5 |
|
notionalAmount |
decimal{23,5} |
|
The face (or par) value of the trade. |
|
notionalConditions |
string(4)[20] |
|
Placeholder field for future use. |
|
notionalCurrency |
string(3) |
|
Currency in which the notional is denominated (ISO 4217). |
|
onVenueFlag |
boolean* |
|
TRUE=Traded on a venue, FALSE=Bilateral (XOFF/SINT) |
|
priceCurrency |
string(3) |
|
Currency in which the price is expressed (ISO 4217). |
|
prices |
Price[50] |
|
Economics/prices component (array of price objects). |
|
publicationDateTime |
dateTime |
|
Date and time when the transaction was published by a trading venue or APA. |
|
recordId |
string(16)* |
|
Unique ID for a trade report assigned by ETS. |
|
recordStatus |
string(1)* |
|
Status of the record. I=Inserted, U=Updated, D=Deleted |
|
recordType |
string(3)* |
|
Type of record. NEW=New, AMD=Updated, CXL=Cancelled, UNK=Unknown |
|
settlementDate |
date |
|
Placeholder field for future use |
|
sourcePublicationDateTime |
dateTime |
|
Post-Trade Source Record. Date/time published by CTP. |
|
sourceReceptionDateTime |
dateTime |
|
Post-Trade Source Record. Date/time received by CTP. |
|
sourceRecordCtPublicationDateTime |
dateTime |
|
Post-Trade Source Record. Publication date and time at CTP. |
|
sourceRecordCtReceptionDateTime |
dateTime |
|
Post-Trade Source Record. Reception date and time at CTP. |
|
sourceRecordCtSuspiciousDataFlag |
boolean |
|
Post-Trade Source Record. Suspicious data flag from CTP. |
|
sourceRecordEffectiveDateOfTheContract |
dateTime |
|
Post-Trade Source Record. Effective date of the contract. |
|
sourceRecordFlags |
string(4)[50] |
|
Post-Trade Source Record. The flags reported by data contributors for a trade report. |
|
sourceRecordId |
string(16) |
|
Post-Trade Source Record.The id field uniquely identifies the entity record. |
|
sourceRecordInstrumentIdentificationCode |
string(12) |
|
Post-Trade Source Record. Instrument identification code. |
|
sourceRecordInstrumentIdentificationCodeType |
string(20) |
|
Post-Trade Source Record. Instrument identification code type. |
|
sourceRecordLeiOfClearingHouse |
string(4) |
|
Post-Trade Source Record. LEI Of Clearing House. |
|
sourceRecordMaturityDateOfTheContract |
dateTime |
|
Post-Trade Source Record. Maturity date of the contract. |
|
sourceRecordMissingPrice |
string(20) |
|
Post-Trade Source Record. Missing price indicator. |
|
sourceRecordNotationOfTheQuantityInMeasurementUnit |
string(25) |
|
Post-Trade Source Record. Notation of the quantity in measurement unit. |
|
sourceRecordNumberOfTransactions |
decimal{34,17} |
|
Post-Trade Source Record. Number of transactions. |
|
sourceRecordPrice |
decimal{34,17} |
|
Post-Trade Source Record.Price of the transaction. |
|
sourceRecordPriceCurrency |
string(3) |
|
Post-Trade Source Record. Currency in which the price is expressed (ISO 4217). |
|
sourceRecordPriceNotation |
string(20) |
|
Post-Trade Source Record. Price notation. |
|
sourceRecordPublicationDateAndTime |
dateTime |
|
Post-Trade Source Record. Publication date and time. |
|
sourceRecordQuantity |
decimal{34,17} |
|
Post-Trade Source Record. Quantity. |
|
sourceRecordQuantityInMeasurementUnit |
decimal{34,17} |
|
Post-Trade Source Record.Quantity In Measurement Unit. |
|
sourceRecordReceivedDateTime |
dateTime |
|
Post-Trade Source Record. Date and time received by ETS. |
|
sourceRecordSpread |
decimal{21,10} |
|
Post-Trade Source Record. Spread. |
|
sourceRecordThirdCountryTradingVenueOfExecution |
string(4) |
|
Post-Trade Source Record. Third-country trading venue of execution. |
|
sourceRecordTradingDateAndTime |
dateTime |
|
Post-Trade Source Record. Trading date and time. |
|
sourceRecordTradingSystem |
string(20) |
|
Post-Trade Source Record. Trading system. |
|
sourceRecordTransactionIdentificationCode |
string(52) |
|
Post-Trade Source Record. Transaction identification code. |
|
sourceRecordTransactionToBeCleared |
boolean |
|
Post-Trade Source Record. Indicates whether transaction is to be cleared. |
|
sourceRecordType |
string(20) |
|
Post-Trade Source Record. Type. |
|
sourceRecordUpfrontPayment |
decimal{31,13} |
|
Post-Trade Source Record. Upfront Payment. |
|
sourceSuspiciousDataFlag |
boolean |
|
Post-Trade Source Record. CTP identified as possible data quality issue. |
|
sourceTransactionId |
string(52) |
|
Post-Trade Source Record. Alphanumerical code assigned by trading venues and APAs. |
|
suspiciousDataFlag |
boolean |
|
TRUE=considered likely to be erroneous; FALSE=not considered likely to be erroneous. |
|
tradeConditions |
string(20)[20] |
|
All EU and UK flags (see Appendix 1). |
|
tradeId |
string(16)* |
|
Unique ID for a family of trades to link amendments and cancellations to the original trade. |
|
tradingSystemType |
string(4) |
|
Trading system type. "CLOB", "QDTS", "PATS", "RFQT", "VOIC", "HYBR", "OTHR" |
|
venueOfExecution |
string(4) |
|
Venue MIC or "SINT" for systematic internaliser. |
|
venueOfPublication |
string(4) |
|
Trading venue MIC or APA code. |
|
venueOfPublicationName |
string(255) |
|
Name of Venue of Publication MIC from ISO list. |
|
venueType |
string(3) |
|
Venue of Publication Type. "APA", "OTF", "MTF", "RM", "XEU", "OTH" |