> ## Documentation Index
> Fetch the complete documentation index at: https://docs.activeviam.com/llms.txt
> Use this file to discover all available pages before exploring further.

# TRADE_ATTRIBUTES

The TRADE\_ATTRIBUTES table contains the fields describing attributes of the trades.

<table><thead><tr><th>Column Name</th><th>Type</th><th>Not Null</th><th>Cube Field</th><th>Default Value<sup id="fnref:1"><a class="footnote-ref" href="#fn:1" role="doc-noteref">1</a></sup></th><th>Description</th></tr></thead><tbody><tr><td>AS\_OF\_DATE</td><td>DATE</td><td>Y</td><td /><td /><td>Timestamp (at close of business) for the data.</td></tr><tr><td>TRADE\_KEY</td><td>STRING</td><td>Y</td><td /><td>N/A</td><td>Unique Trade (or Position) ID.</td></tr><tr><td>BOOK</td><td>STRING</td><td>Y</td><td><a href="../cube/dimensions/booking">Books</a></td><td>N/A</td><td>The book to map the trade to (must match the node in the Book Hierarchy).</td></tr><tr><td>LEGAL\_ENTITY</td><td>STRING</td><td>Y</td><td><a href="../cube/dimensions/organization">Legal Entities</a></td><td>N/A</td><td>Legal Entity to map the trade to (must match the node in the Legal Entity Hierarchy).</td></tr><tr><td>COUNTERPARTY\_ID</td><td>STRING</td><td>Y</td><td><a href="../cube/dimensions/counterparties">CounterpartyIds</a></td><td>N/A</td><td>Counterparty to map the trade to (must match the node in the Counterparty Hierarchy).</td></tr><tr><td>NOTIONAL</td><td>DOUBLE</td><td /><td /><td /><td>Notional of the trade/position.</td></tr><tr><td>NOTIONAL\_CCY</td><td>STRING</td><td>Y</td><td><a href="../cube/dimensions/currencies">NotionalCurrencies</a></td><td>N/A</td><td>Currency of the notional trade.</td></tr><tr><td>TRADER</td><td>STRING</td><td>Y</td><td><a href="../cube/dimensions/tradeattributes">Traders</a></td><td>N/A</td><td>Trader who performed the trade.</td></tr><tr><td>SALES</td><td>STRING</td><td>Y</td><td><a href="../cube/dimensions/tradeattributes">Sales</a></td><td>N/A</td><td>Salesperson who performed the sale of the trade (if applicable).</td></tr><tr><td>INSTRUMENT\_CLASS</td><td>STRING</td><td>Y</td><td><a href="../cube/dimensions/instruments">InstrumentClasses</a></td><td>N/A</td><td>Highest level of instrument classification.</td></tr><tr><td>INSTRUMENT\_TYPE</td><td>STRING</td><td>Y</td><td><a href="../cube/dimensions/instruments">InstrumentTypes</a></td><td>N/A</td><td>Main instrument classification.</td></tr><tr><td>INSTRUMENT\_SUB\_TYPE</td><td>STRING</td><td>Y</td><td><a href="../cube/dimensions/instruments">InstrumentTypes</a></td><td>N/A</td><td>Sub-level of instrument classification.</td></tr><tr><td>TRADE\_DATE</td><td>DATE</td><td>Y</td><td><a href="../cube/dimensions/tradeattributes">TradeDates</a></td><td>1970-01-01</td><td>Date of the execution of the trade.</td></tr><tr><td>TRADE\_MATURITY\_DATE</td><td>DATE</td><td>Y</td><td><a href="../cube/dimensions/tradeattributes">TradeMaturityDates</a></td><td>1970-01-01</td><td>Maturity date of the trade.</td></tr><tr><td>VAR\_INCLUSION\_TYPE</td><td>STRING</td><td>Y</td><td /><td>R</td><td>Defines on what basis to include the VaR of this trade: <ul><li>‘R’ for repricing</li><li>‘S’ for sensitivity,</li></ul></td></tr><tr><td>TRADE\_SOURCE</td><td>STRING</td><td>Y</td><td>TradeSources</td><td>N/A</td><td>Identifier of the source system the trade was executed in.</td></tr><tr><td>TRADE\_STATUS</td><td>STRING</td><td>Y</td><td>TradeStatuses</td><td>LIVE</td><td>Status representing the step in the trade lifecycle.</td></tr><tr><td>ORIGINAL\_NOTIONAL</td><td>DOUBLE</td><td>Y</td><td>OriginalNotional</td><td /><td>Represents the notional at trade date.</td></tr></tbody></table>

## Unique Key

<table><thead><tr><th>Columns</th></tr></thead><tbody><tr><td>AS\_OF\_DATE</td></tr><tr><td>TRADE\_KEY</td></tr></tbody></table>

## Incoming Joins

<table><thead><tr><th>Source Table</th><th>Source Columns</th><th>Target Columns</th></tr></thead><tbody><tr><td><a href="./tradepnls">TRADEPNLS</a></td><td>AS\_OF\_DATE<br />TRADE\_KEY</td><td>AS\_OF\_DATE<br />TRADE\_KEY</td></tr><tr><td><a href="./trade_sensitivities">TRADE\_SENSITIVITIES</a></td><td>AS\_OF\_DATE<br />TRADE\_KEY</td><td>AS\_OF\_DATE<br />TRADE\_KEY</td></tr><tr><td><a href="./pnl">PNL</a></td><td>AS\_OF\_DATE<br />TRADE\_KEY</td><td>AS\_OF\_DATE<br />TRADE\_KEY</td></tr></tbody></table>

## Outgoing Joins

<table><thead><tr><th>Target Table</th><th>Source Columns</th><th>Target Columns</th></tr></thead><tbody><tr><td><a href="./legal_entity_hierarchy">LEGAL\_ENTITY\_HIERARCHY</a></td><td>AS\_OF\_DATE<br />LEGAL\_ENTITY</td><td>AS\_OF\_DATE<br />LEGAL\_ENTITY</td></tr><tr><td><a href="./counterparty_hierarchy">COUNTERPARTY\_HIERARCHY</a></td><td>AS\_OF\_DATE<br />COUNTERPARTY\_ID</td><td>AS\_OF\_DATE<br />COUNTERPARTY\_ID</td></tr><tr><td><a href="./book_hierarchy">BOOK\_HIERARCHY</a></td><td>AS\_OF\_DATE<br />BOOK</td><td>AS\_OF\_DATE<br />BOOK</td></tr><tr><td><a href="./counterparties">COUNTERPARTIES</a></td><td>AS\_OF\_DATE<br />COUNTERPARTY\_ID</td><td>AS\_OF\_DATE<br />COUNTERPARTY\_ID</td></tr></tbody></table>

***

1. If the default value is marked as empty, it means that the default value is 'null' for nullable fields, and that a value needs to be explicitly set for non-nullable fields.
    [↩︎](#fnref:1)