camt.042.001.03
Scope A report provider, such as a transfer agent, sends the FundDetailedEstimatedCashForecastReport message to the report user, such as an investment manager, to report the estimated cash incomings and outgoings, sorted by country, institution name or other criteria defined by the user of one or more investment funds on one or more trade dates. The cash movements may result from, for example, redemption, subscription, switch transactions or reinvestment of dividends. Usage The FundDetailedEstimatedCashForecastReport is used to provide estimated cash movements, i.e., it is sent prior to the cut-off time and/or the price valuation of the fund. If the price is definitive, then the FundDetailedConfirmedCashForecastReport message must be used. The FundDetailedEstimatedCashForecastReport message is used to report cash movements in or out of a fund, organised by party, such as fund management company, country, currency or by some other criteria defined by the report provider. If the report is used to give the cash-in and cash-out for a party, then additional criteria, such as currency and country, can be specified. In addition, the underlying transaction type for the cash-in or cash-out movement can be specified, as well as information about the cash movement’s underlying orders, such as commission and charges.
Message Construction
Every ISO20022 message has at the highest level what we call ‘building blocks’. Because the message is constructed as immutable records, the association is by composition. Below you can see the relationship between the message and its constituent building blocks: For comparison, see the ISO20022 official specification
classDiagram
direction LR
%% FundDetailedEstimatedCashForecastReportV03 recursion level 0 with max 0
FundDetailedEstimatedCashForecastReportV03 *-- "1..1" MessageIdentification1 : MessageIdentification
FundDetailedEstimatedCashForecastReportV03 *-- "0..1" AdditionalReference3 : PoolReference
FundDetailedEstimatedCashForecastReportV03 *-- "0..1" AdditionalReference3 : PreviousReference
FundDetailedEstimatedCashForecastReportV03 *-- "0..1" AdditionalReference3 : RelatedReference
FundDetailedEstimatedCashForecastReportV03 *-- "1..1" Pagination : MessagePagination
FundDetailedEstimatedCashForecastReportV03 *-- "1..1" EstimatedFundCashForecast4 : EstimatedFundCashForecastDetails
FundDetailedEstimatedCashForecastReportV03 *-- "0..1" NetCashForecast3 : ConsolidatedNetCashForecast
FundDetailedEstimatedCashForecastReportV03 *-- "0..1" Extension1 : Extension
Now, we will zero-in one-by-one on each of these building blocks.
MessageIdentification building block
Identifies the message. Identifies a message by a unique identifier and the date and time when the message was created by the sender. For comparison, see the ISO20022 official specification
classDiagram
direction tb
%% MessageIdentification1 recursion level 0 with max 1
class MessageIdentification1{
Identification IsoMax35Text
CreationDateTime IsoISODateTime
}
MessageIdentification1 members
| Member name | Description | Data Type / Multiplicity |
|---|---|---|
| Identification | Identification of the message. | IsoMax35Text - Required 1..1 |
| CreationDateTime | Date of creation of the message. | IsoISODateTime - Required 1..1 |
PoolReference building block
Collective reference identifying a set of messages. References a related message or provides another reference, such as a pool reference, linking a set of messages. The party which issued the related reference may be the Sender of the referenced message or a party other than the Sender. For comparison, see the ISO20022 official specification
classDiagram
direction tb
%% AdditionalReference3 recursion level 0 with max 1
class AdditionalReference3{
Reference IsoMax35Text
MessageName IsoMax35Text
}
AdditionalReference3 *-- "0..1" IPartyIdentification2Choice : ReferenceIssuer
%% IPartyIdentification2Choice recursion level 1 with max 1
AdditionalReference3 members
| Member name | Description | Data Type / Multiplicity |
|---|---|---|
| Reference | Business reference of a message assigned by the party issuing the message. This reference must be unique amongst all messages of the same name sent by the same party. | IsoMax35Text - Required 1..1 |
| ReferenceIssuer | Issuer of the reference. | IPartyIdentification2Choice - Optional 0..1 |
| MessageName | Name of a message. | IsoMax35Text - Optional 0..1 |
PreviousReference building block
Reference to a linked message that was previously sent. References a related message or provides another reference, such as a pool reference, linking a set of messages. The party which issued the related reference may be the Sender of the referenced message or a party other than the Sender. For comparison, see the ISO20022 official specification
classDiagram
direction tb
%% AdditionalReference3 recursion level 0 with max 1
class AdditionalReference3{
Reference IsoMax35Text
MessageName IsoMax35Text
}
AdditionalReference3 *-- "0..1" IPartyIdentification2Choice : ReferenceIssuer
%% IPartyIdentification2Choice recursion level 1 with max 1
AdditionalReference3 members
| Member name | Description | Data Type / Multiplicity |
|---|---|---|
| Reference | Business reference of a message assigned by the party issuing the message. This reference must be unique amongst all messages of the same name sent by the same party. | IsoMax35Text - Required 1..1 |
| ReferenceIssuer | Issuer of the reference. | IPartyIdentification2Choice - Optional 0..1 |
| MessageName | Name of a message. | IsoMax35Text - Optional 0..1 |
RelatedReference building block
Reference to a linked message that was previously received. References a related message or provides another reference, such as a pool reference, linking a set of messages. The party which issued the related reference may be the Sender of the referenced message or a party other than the Sender. For comparison, see the ISO20022 official specification
classDiagram
direction tb
%% AdditionalReference3 recursion level 0 with max 1
class AdditionalReference3{
Reference IsoMax35Text
MessageName IsoMax35Text
}
AdditionalReference3 *-- "0..1" IPartyIdentification2Choice : ReferenceIssuer
%% IPartyIdentification2Choice recursion level 1 with max 1
AdditionalReference3 members
| Member name | Description | Data Type / Multiplicity |
|---|---|---|
| Reference | Business reference of a message assigned by the party issuing the message. This reference must be unique amongst all messages of the same name sent by the same party. | IsoMax35Text - Required 1..1 |
| ReferenceIssuer | Issuer of the reference. | IPartyIdentification2Choice - Optional 0..1 |
| MessageName | Name of a message. | IsoMax35Text - Optional 0..1 |
MessagePagination building block
Pagination of the message. Number used to sequence pages when it is not possible for data to be conveyed in a single message and the data has to be split across several pages (messages). For comparison, see the ISO20022 official specification
classDiagram
direction tb
%% Pagination recursion level 0 with max 1
class Pagination{
PageNumber IsoMax5NumericText
LastPageIndicator IsoYesNoIndicator
}
Pagination members
| Member name | Description | Data Type / Multiplicity |
|---|---|---|
| PageNumber | Page number. | IsoMax5NumericText - Required 1..1 |
| LastPageIndicator | Indicates the last page. | IsoYesNoIndicator - Required 1..1 |
EstimatedFundCashForecastDetails building block
Information related to the estimated cash-in and cash-out flows for a specific trade date as a result of investment fund transactions, for example, subscriptions, redemptions or switches to/from a specified investment fund. The information provided is sorted by pre-defined criteria such as country, institution, currency or user defined criteria. Cash movements from or to a fund as a result of investment funds transactions, eg, subscriptions or redemptions. For comparison, see the ISO20022 official specification
classDiagram
direction tb
%% EstimatedFundCashForecast4 recursion level 0 with max 1
class EstimatedFundCashForecast4{
Identification IsoMax35Text
EstimatedTotalNAV IsoActiveOrHistoricCurrencyAndAmount
PreviousTotalNAV IsoActiveOrHistoricCurrencyAndAmount
EstimatedTotalNAVChangeRate IsoPercentageRate
InvestmentCurrency ActiveOrHistoricCurrencyCode
ExceptionalNetCashFlowIndicator IsoYesNoIndicator
}
EstimatedFundCashForecast4 *-- "1..1" IDateAndDateTimeChoice : TradeDateTime
EstimatedFundCashForecast4 *-- "1..1" IDateAndDateTimeChoice : PreviousTradeDateTime
EstimatedFundCashForecast4 *-- "1..1" FinancialInstrument9 : FinancialInstrumentDetails
EstimatedFundCashForecast4 *-- "0..1" FinancialInstrumentQuantity1 : EstimatedTotalUnitsNumber
EstimatedFundCashForecast4 *-- "0..1" FinancialInstrumentQuantity1 : PreviousTotalUnitsNumber
EstimatedFundCashForecast4 *-- "0..0" BreakdownByParty1 : BreakdownByParty
EstimatedFundCashForecast4 *-- "0..0" BreakdownByCountry1 : BreakdownByCountry
EstimatedFundCashForecast4 *-- "0..0" BreakdownByCurrency1 : BreakdownByCurrency
EstimatedFundCashForecast4 *-- "0..0" BreakdownByUserDefinedParameter1 : BreakdownByUserDefinedParameter
EstimatedFundCashForecast4 *-- "0..0" NetCashForecast2 : EstimatedNetCashForecastDetails
%% IDateAndDateTimeChoice recursion level 1 with max 1
%% IDateAndDateTimeChoice recursion level 1 with max 1
%% FinancialInstrument9 recursion level 1 with max 1
class FinancialInstrument9{
Name IsoMax350Text
SupplementaryIdentification IsoMax35Text
RequestedNAVCurrency ActiveOrHistoricCurrencyCode
ClassType IsoMax35Text
SecuritiesForm FormOfSecurity1Code
DistributionPolicy DistributionPolicy1Code
DualFundIndicator IsoYesNoIndicator
}
FinancialInstrument9 *-- "1..1" ISecurityIdentification3Choice : Identification
%% FinancialInstrumentQuantity1 recursion level 1 with max 1
class FinancialInstrumentQuantity1{
Unit IsoDecimalNumber
}
%% FinancialInstrumentQuantity1 recursion level 1 with max 1
class FinancialInstrumentQuantity1{
Unit IsoDecimalNumber
}
%% BreakdownByParty1 recursion level 1 with max 1
BreakdownByParty1 *-- "1..1" IPartyIdentification2Choice : Party
BreakdownByParty1 *-- "0..1" AdditionalParameters1 : AdditionalParameters
BreakdownByParty1 *-- "0..0" CashInForecast3 : CashInForecast
BreakdownByParty1 *-- "0..0" CashOutForecast3 : CashOutForecast
BreakdownByParty1 *-- "0..0" NetCashForecast2 : NetCashForecast
%% BreakdownByCountry1 recursion level 1 with max 1
class BreakdownByCountry1{
Country CountryCode
}
BreakdownByCountry1 *-- "0..0" CashInForecast3 : CashInForecast
BreakdownByCountry1 *-- "0..0" CashOutForecast3 : CashOutForecast
BreakdownByCountry1 *-- "0..0" NetCashForecast2 : NetCashForecast
%% BreakdownByCurrency1 recursion level 1 with max 1
class BreakdownByCurrency1{
Currency ActiveOrHistoricCurrencyCode
}
BreakdownByCurrency1 *-- "0..0" CashOutForecast3 : CashOutForecast
BreakdownByCurrency1 *-- "0..0" CashInForecast3 : CashInForecast
BreakdownByCurrency1 *-- "0..0" NetCashForecast2 : NetCashForecast
%% BreakdownByUserDefinedParameter1 recursion level 1 with max 1
class BreakdownByUserDefinedParameter1{
Country CountryCode
Currency ActiveOrHistoricCurrencyCode
}
BreakdownByUserDefinedParameter1 *-- "0..1" IPartyIdentification2Choice : Party
BreakdownByUserDefinedParameter1 *-- "0..1" IDataFormat2Choice : UserDefined
BreakdownByUserDefinedParameter1 *-- "0..0" CashInForecast3 : CashInForecast
BreakdownByUserDefinedParameter1 *-- "0..0" CashOutForecast3 : CashOutForecast
BreakdownByUserDefinedParameter1 *-- "0..0" NetCashForecast2 : NetCashForecast
%% NetCashForecast2 recursion level 1 with max 1
class NetCashForecast2{
CashSettlementDate IsoISODate
NetAmount IsoActiveOrHistoricCurrencyAndAmount
FlowDirection FlowDirectionType1Code
}
NetCashForecast2 *-- "0..1" FinancialInstrumentQuantity1 : NetUnitsNumber
EstimatedFundCashForecast4 members
| Member name | Description | Data Type / Multiplicity |
|---|---|---|
| Identification | Unique technical identifier for an instance of a fund cash forecast within a fund cash forecast report as assigned by the issuer of the report. | IsoMax35Text - Required 1..1 |
| TradeDateTime | Date and, if required, the time, at which the price has been applied. | IDateAndDateTimeChoice - Required 1..1 |
| PreviousTradeDateTime | Previous date and time at which a price was applied. | IDateAndDateTimeChoice - Required 1..1 |
| FinancialInstrumentDetails | Investment fund class to which the cash flow is related. | FinancialInstrument9 - Required 1..1 |
| EstimatedTotalNAV | Estimated total value of all the holdings, less the fund’s liabilities, attributable to a specific investment fund class. | IsoActiveOrHistoricCurrencyAndAmount - Optional 0..1 |
| PreviousTotalNAV | Previous value of all the holdings, less the fund’s liabilities, attributable to a specific investment fund class. | IsoActiveOrHistoricCurrencyAndAmount - Optional 0..1 |
| EstimatedTotalUnitsNumber | Estimated total number of investment fund class units that have been issued. | FinancialInstrumentQuantity1 - Optional 0..1 |
| PreviousTotalUnitsNumber | Previous value of all the holdings, less the fund’s liabilities, attributable to a specific investment fund class. | FinancialInstrumentQuantity1 - Optional 0..1 |
| BreakdownByParty | Estimated cash flow by party. | BreakdownByParty1 - Unknown 0..0 |
| BreakdownByCountry | Estimated cash flow by country. | BreakdownByCountry1 - Unknown 0..0 |
| BreakdownByCurrency | Estimated cash flow by currency. | BreakdownByCurrency1 - Unknown 0..0 |
| BreakdownByUserDefinedParameter | Estimated cash flow by a user defined parameter/s. | BreakdownByUserDefinedParameter1 - Unknown 0..0 |
| EstimatedTotalNAVChangeRate | Rate of change of the net asset value. | IsoPercentageRate - Optional 0..1 |
| InvestmentCurrency | Currency of the investment fund class. | ActiveOrHistoricCurrencyCode - Unknown 0..0 |
| ExceptionalNetCashFlowIndicator | Indicates whether the estimated net cash flow is exceptional. | IsoYesNoIndicator - Required 1..1 |
| EstimatedNetCashForecastDetails | Estimated net cash movements per financial instrument. | NetCashForecast2 - Unknown 0..0 |
ConsolidatedNetCashForecast building block
Estimated net cash as a result of the cash-in and cash-out flows specified in the fund cash forecast details. Net cash movement to a fund as a result of investment funds transactions. For comparison, see the ISO20022 official specification
classDiagram
direction tb
%% NetCashForecast3 recursion level 0 with max 1
class NetCashForecast3{
NetAmount IsoActiveOrHistoricCurrencyAndAmount
FlowDirection FlowDirectionType1Code
}
NetCashForecast3 *-- "0..1" FinancialInstrumentQuantity1 : NetUnitsNumber
%% FinancialInstrumentQuantity1 recursion level 1 with max 1
class FinancialInstrumentQuantity1{
Unit IsoDecimalNumber
}
NetCashForecast3 members
| Member name | Description | Data Type / Multiplicity |
|---|---|---|
| NetAmount | Net amount of the cash flow, expressed as an amount of money. | IsoActiveOrHistoricCurrencyAndAmount - Optional 0..1 |
| NetUnitsNumber | Net amount, expressed as a number of units. | FinancialInstrumentQuantity1 - Optional 0..1 |
| FlowDirection | Specifies the direction of the cash flow from the perspective of the fund. | FlowDirectionType1Code - Required 1..1 |
Extension building block
Additional information that can not be captured in the structured fields and/or any other specific block. Additional information that can not be captured in the structured fields and/or any other specific block. For comparison, see the ISO20022 official specification
classDiagram
direction tb
%% Extension1 recursion level 0 with max 1
class Extension1{
PlaceAndName IsoMax350Text
Text IsoMax350Text
}
Extension1 members
| Member name | Description | Data Type / Multiplicity |
|---|---|---|
| PlaceAndName | Name qualifying the information provided in the Text field, and place where this information should be inserted. | IsoMax350Text - Required 1..1 |
| Text | Text of the extension. | IsoMax350Text - Required 1..1 |
Extensibility and generalization considerations
To facilitate generalized design patterns in the system, the FundDetailedEstimatedCashForecastReportV03 implementation follows a specific implementaiton pattern. First of all, FundDetailedEstimatedCashForecastReportV03 impleemnts IOuterRecord indicating it is the outermost logical part of the message definition. Like all message wrappers, FundDetailedEstimatedCashForecastReportV03Document implements IOuterDocument. Because FundDetailedEstimatedCashForecastReportV03 implements IOuterDocument, it is a suitable template parameter for IOuterDocument, and causes the internal ‘Message’ to be of type FundDetailedEstimatedCashForecastReportV03.
classDiagram
class IOuterRecord
FundDetailedEstimatedCashForecastReportV03 --|> IOuterRecord : Implements
FundDetailedEstimatedCashForecastReportV03Document --|> IOuterDocument~FundDetailedEstimatedCashForecastReportV03~ : Implements
class IOuterDocument~FundDetailedEstimatedCashForecastReportV03~ {
FundDetailedEstimatedCashForecastReportV03 Message
}
Document wrapper for serialization
The only real purpose FundDetailedEstimatedCashForecastReportV03Document serves is to cause the document to be serialized into the ‘urn:iso:std:iso:20022:tech:xsd:camt.042.001.03’ namespace. Therefore, it will probably be the usual practice to build the message and construct this wrapper at the last minute using FundDetailedEstimatedCashForecastReportV03.ToDocument() method. The returned FundDetailedEstimatedCashForecastReportV03Document value will serialize correctly according to ISO 20022 standards.
classDiagram
FundDetailedEstimatedCashForecastReportV03Document *-- FundDetailedEstimatedCashForecastReportV03 : Document
Sample of message format
This is an abbreviated version of what the message should look like.
<Document xmlns="urn:iso:std:iso:20022:tech:xsd:camt.042.001.03">
<FndDtldEstmtdCshFcstRptV03>
<MsgId>
<!-- MessageIdentification inner content -->
</MsgId>
<PoolRef>
<!-- PoolReference inner content -->
</PoolRef>
<PrvsRef>
<!-- PreviousReference inner content -->
</PrvsRef>
<RltdRef>
<!-- RelatedReference inner content -->
</RltdRef>
<MsgPgntn>
<!-- MessagePagination inner content -->
</MsgPgntn>
<EstmtdFndCshFcstDtls>
<!-- EstimatedFundCashForecastDetails inner content -->
</EstmtdFndCshFcstDtls>
<CnsltdNetCshFcst>
<!-- ConsolidatedNetCashForecast inner content -->
</CnsltdNetCshFcst>
<Xtnsn>
<!-- Extension inner content -->
</Xtnsn>
</FndDtldEstmtdCshFcstRptV03>
</Document>
Data from ISO specification
This is the technical data from the specification document.
<messageDefinition
xmi:id="_dYVFEtE-Ed-BzquC8wXy7w_890369762"
nextVersions="_IaBCkQasEeSrXeb3pHPmbg"
previousVersion="_c0afsNE-Ed-BzquC8wXy7w_1725865409"
name="FundDetailedEstimatedCashForecastReportV03"
definition="Scope
A report provider, such as a transfer agent, sends the FundDetailedEstimatedCashForecastReport message to the report user, such as an investment manager, to report the estimated cash incomings and outgoings, sorted by country, institution name or other criteria defined by the user of one or more investment funds on one or more trade dates.
The cash movements may result from, for example, redemption, subscription, switch transactions or reinvestment of dividends.
Usage
The FundDetailedEstimatedCashForecastReport is used to provide estimated cash movements, i.e., it is sent prior to the cut-off time and/or the price valuation of the fund. If the price is definitive, then the FundDetailedConfirmedCashForecastReport message must be used.
The FundDetailedEstimatedCashForecastReport message is used to report cash movements in or out of a fund, organised by party, such as fund management company, country, currency or by some other criteria defined by the report provider. If the report is used to give the cash-in and cash-out for a party, then additional criteria, such as currency and country, can be specified.
In addition, the underlying transaction type for the cash-in or cash-out movement can be specified, as well as information about the cash movement's underlying orders, such as commission and charges."
registrationStatus="Registered"
messageSet="_wFQdsE2rEeG_I4xRYCA_7g _urpIICeJEeOCeO5e7islRQ"
xmlTag="FndDtldEstmtdCshFcstRptV03"
rootElement="Document"
xmlns:xmi="http://www.omg.org/XMI">
<messageBuildingBlock
xmi:id="_dYVFE9E-Ed-BzquC8wXy7w_1477333674"
nextVersions="_IaBClQasEeSrXeb3pHPmbg"
name="MessageIdentification"
definition="Identifies the message."
registrationStatus="Provisionally Registered"
maxOccurs="1"
minOccurs="1"
xmlTag="MsgId"
complexType="_Q7pG5Np-Ed-ak6NoX_4Aeg_-967008570" />
<messageBuildingBlock
xmi:id="_dYVFFNE-Ed-BzquC8wXy7w_1323500831"
nextVersions="_IaBClwasEeSrXeb3pHPmbg"
name="PoolReference"
definition="Collective reference identifying a set of messages."
registrationStatus="Provisionally Registered"
maxOccurs="1"
minOccurs="0"
xmlTag="PoolRef"
complexType="_Q6vvAdp-Ed-ak6NoX_4Aeg_2101402955" />
<messageBuildingBlock
xmi:id="_dYVFFdE-Ed-BzquC8wXy7w_1332733556"
nextVersions="_IaBCmQasEeSrXeb3pHPmbg"
name="PreviousReference"
definition="Reference to a linked message that was previously sent."
registrationStatus="Provisionally Registered"
minOccurs="0"
xmlTag="PrvsRef"
complexType="_Q6vvAdp-Ed-ak6NoX_4Aeg_2101402955" />
<messageBuildingBlock
xmi:id="_dYVFFtE-Ed-BzquC8wXy7w_1334582479"
nextVersions="_IaBCmwasEeSrXeb3pHPmbg"
name="RelatedReference"
definition="Reference to a linked message that was previously received."
registrationStatus="Provisionally Registered"
minOccurs="0"
xmlTag="RltdRef"
complexType="_Q6vvAdp-Ed-ak6NoX_4Aeg_2101402955" />
<messageBuildingBlock
xmi:id="_dYVFF9E-Ed-BzquC8wXy7w_256000331"
nextVersions="_IaBCnQasEeSrXeb3pHPmbg"
name="MessagePagination"
definition="Pagination of the message."
registrationStatus="Provisionally Registered"
maxOccurs="1"
minOccurs="1"
xmlTag="MsgPgntn"
complexType="_Q65gBdp-Ed-ak6NoX_4Aeg_-21330104" />
<messageBuildingBlock
xmi:id="_dYePANE-Ed-BzquC8wXy7w_82163480"
nextVersions="_IaBCnwasEeSrXeb3pHPmbg"
name="EstimatedFundCashForecastDetails"
definition="Information related to the estimated cash-in and cash-out flows for a specific trade date as a result of investment fund transactions, for example, subscriptions, redemptions or switches to/from a specified investment fund. The information provided is sorted by pre-defined criteria such as country, institution, currency or user defined criteria."
registrationStatus="Provisionally Registered"
minOccurs="1"
xmlTag="EstmtdFndCshFcstDtls"
complexType="_Sj8hedp-Ed-ak6NoX_4Aeg_-271542988" />
<messageBuildingBlock
xmi:id="_dYePAdE-Ed-BzquC8wXy7w_928675024"
nextVersions="_IaBCoQasEeSrXeb3pHPmbg"
name="ConsolidatedNetCashForecast"
definition="Estimated net cash as a result of the cash-in and cash-out flows specified in the fund cash forecast details."
registrationStatus="Provisionally Registered"
maxOccurs="1"
minOccurs="0"
xmlTag="CnsltdNetCshFcst"
complexType="_Si5_pdp-Ed-ak6NoX_4Aeg_1538517625" />
<messageBuildingBlock
xmi:id="_dYePAtE-Ed-BzquC8wXy7w_-1975912921"
nextVersions="_IaBCowasEeSrXeb3pHPmbg"
name="Extension"
definition="Additional information that can not be captured in the structured fields and/or any other specific block."
registrationStatus="Provisionally Registered"
minOccurs="0"
xmlTag="Xtnsn"
complexType="_Q6vvCNp-Ed-ak6NoX_4Aeg_1503007069" />
<messageDefinitionIdentifier
businessArea="camt"
messageFunctionality="042"
flavour="001"
version="03" />
</messageDefinition>
ISO Building Blocks
The following items are used as building blocks to construct this message.