Data field | Status | Allowed values | Explanation | Example value | Default value (if missing) |
security
Identifies the underlying instrument, whether security or currency. | Mandatory | Txn:LusidInstrumentId
| Returns the instrumentUid field on a transaction. | LUID_98ABCDJK
| The unknown instrument, LUID_ZZZZZZZZ |
Txn:TradeCurrency
| Returns the transactionCurrency field on a transaction. | CCY_USD
|
Txn:SettlementCurrency or Txn:SettleCcy
| Returns the totalConsideration.currency field on a transaction, for circumstances in which the settlement currency is different to the trade currency. | CCY_GBP
|
Txn:PortfolioCurrency
| Returns the baseCurrency field on a transaction portfolio. | CCY_JPY
|
A transaction property | Returns the value of a custom property added to a transaction using its 3-stage key, for example Transaction/Demo/BuyAmountCcy . The property must either use the built-in String data type or have a custom data type with a primitive valueType of String . The property value must contain a valid instrument LUID, currency LUID, or ISO 4217 currency code. | LUID_98ABCDJK or CCY_GBP or GBP
|
currency
Identifies the currency of the flow. | Mandatory | Txn:TradeCurrency
| Returns the transactionCurrency field on a transaction. | GBP
| The unknown currency, CCY_ZZZ |
Txn:SettlementCurrency or Txn:SettleCcy
| Returns the totalConsideration.currency field on a transaction, for circumstances in which the settlement currency is different to the trade currency. | USD
|
Txn:PortfolioCurrency
| Returns the baseCurrency field on a transaction portfolio. | EUR
|
A transaction property | Returns the value of a custom property added to a transaction using its 3-stage key, for example Transaction/Demo/BuyAmountCcy . The property must either use the built-in currency or iso4217Currency data type, or have a custom data type with a primitive valueType of String . The property value must contain a valid ISO 4217 currency code or currency LUID. | JPY or CCY_JPY
|
rate
Fixes the exchange rate between the currency of the flow and the portfolio's base currency, if different. | Mandatory | Txn:TradeToPortfolioRate
| Returns the value of the Transaction/default/TradeToPortfolioRate system property added to a transaction to represent the exchange rate between the transaction's trade currency and the portfolio's base currency. | 1.09
| 0
|
SettledToPortfolioRate
| This is a calculated field representing the rate from the settlement currency to the portfolio currency. It is calculated as TradeToPortfolioRate/ExchangeRate , where ExchangeRate is the rate from trade currency to settlement currency. | 1.78
|
A transaction property | Returns the value of a custom property added to a transaction using its 3-stage key, for example Transaction/Demo/FxRate . The property must either use the built-in number or currencyAndAmount data type, or have a custom data type with a primitive valueType of Decimal or Int . The property value must contain a parsable numeric value. | 1.17
|
A constant value | For example, 1.0 when using Txn:PortfolioCurrency as the currency. | 1.0
|
units , amount
Determines the number of units in the flow and their value respectively. The allowed values are the same. | Mandatory | Txn:Units
| Returns the units field on a transaction. | 100
| 0
|
Txn:TotalConsideration
| Returns the totalConsideration.amount field on a transaction. | 12678
|
Txn:TradeAmount
| This is a calculated field representing the value of the underlying instrument in the trade currency: If the underlying instrument is a currency, the number of units is returned. Otherwise the total consideration less bond interest (if any) is returned, converted at the exchange rate on the transaction. When the total consideration is zero (or not populated), the number of units multiplied by price is returned.
| 12678
|
Txn:TotalConsiderationInTradeCurrency
| This is the same as Txn:TradeAmount except it respects the sign of amount , in circumstances where it is different to units . See an example for FxForwards. | |
Txn:BondInterest
| Returns the value of the Transaction/default/BondInterest system property added to a transaction to represent the accrued interest in the settlement currency included in the purchase/sale of a bond. | 90000
|
BaseOnSeparateBondInterest
| This is a calculated field representing total consideration minus bond interest, where the latter is the value of the Transaction/default/BondInterest system property. | 82000
|
Txn:BondInterestPortfolio
| This is a calculated field representing bond interest converted to the portfolio's base currency, where the former is the value of the Transaction/default/BondInterest system property. | 75000
|
A transaction property | Returns the value of a custom property added to a transaction using its 3-stage key, for example Transaction/Demo/Commission . The property must either use the built-in number or currencyAndAmount data type, or have a custom data type with a primitive valueType of Decimal or Int . The property value must contain a parsable numeric value. | 3023450
|
A constant value | For example, 0 when the units are not updated ie. a cost adjustment. | 0
| |
notionalAmount
Determines the notional value of the flow, if applicable. | Optional | The allowed values for this field are the same as for the units and amount fields, above. However, it might be most useful to assign this field the Transaction/default/NotionalAmount system property, to return the notional amount of a buy or sell transaction in a Future or CFD instrument. | 0
|