> ## 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.

# Profit & Loss without Product Control summary fields

Download sample file: [SummaryPL.csv](../assets/csv/SummaryPL.csv)

This file is intended to load PnL data at book level for trend analysis.

This Profit & Loss without Product Control summary fields file type is identified using the pattern: **\*\*SummaryPL\*.csv** (as specified by `mr.pnl.file-patterns.summary`).
This file is loaded using the **PnLBaseStore** topic. See the [Topic Aliases table](../dev/dev-mr-application/dev-dlc/dlc-mr-config#topic-aliases) for an understanding of the topic aliases associated with each topic.

For information on the glob patterns used and how to customize them, see note on [File name patterns](.#file-name-patterns)

<table><tr><th>Field</th><th>Key</th><th>Null</th><th>FieldType</th><th>Description</th><th>Example</th></tr><tr><td>AsOfDate</td><td>Y</td><td>N</td><td>String with format ‘YYYY-MM-DD’</td><td>Indicates value date.</td><td>2019-01-01</td></tr><tr><td>Book</td><td>N</td><td>Y</td><td>String</td><td>Book to map the trade to (must match the node in the Book Hierarchy).</td><td>CM\_OILGAS</td></tr><tr><td>Daily</td><td>N</td><td>N</td><td>Double</td><td>P\&L</td><td /></tr><tr><td>Monthly</td><td>N</td><td>N</td><td>Double</td><td>Monthly (MTD) P\&L.</td><td /></tr><tr><td>Yearly</td><td>N</td><td>N</td><td>Double</td><td>Yearly (YTD) P\&L.</td><td /></tr><tr><td>Lifetime</td><td>N</td><td>N</td><td>Double</td><td>Lifetime (LTD) P\&L.</td><td /></tr><tr><td>Type</td><td>Y</td><td>N</td><td>String</td><td>Type of P\&L.</td><td>‘Actual PL’</td></tr><tr><td>PLDriver</td><td>N</td><td>Y</td><td>String</td><td>Driver for the P\&L value.</td><td>‘Market moves’</td></tr><tr><td>IsFullReval</td><td>N</td><td>Y</td><td>String</td><td>Flag to indicate whether the P\&L comes from a full revaluation in the risk engine. ‘Y’ or ‘N’.</td><td /></tr><tr><td>Ccy</td><td>N</td><td>N</td><td>String</td><td>Currency of the P\&L value.</td><td>EUR</td></tr><tr><td>MarketDataSet</td><td>Y</td><td>N</td><td>String</td><td>The market data set that should be used when retrieving rates for FX conversion.</td><td>Official EOD</td></tr><tr><td>VaR inclusion type</td><td>Y</td><td>Y</td><td>String</td><td>Defines if a trade is included in the VaR by repricing (R) from the VaR-ES cube or by sensitivity (S) from the Taylor VaR formula.</td><td /></tr><tr><td>Adjustment Source</td><td>Y</td><td>Y</td><td>String</td><td>Sign-off adjustment source tagging.</td><td /></tr><tr><td>Input type</td><td>Y</td><td>Y</td><td>String</td><td>The type of input for the row (e.g Data load, User input).</td><td /></tr></table>