Statement of Investment Funds Transactions semt006 v Securities Transaction Posting Report semt017 17 September 2016 Structural Difference Funds Statements 2 Semt00600103 Message Identification 11 ID: 765509
Download Presentation The PPT/PDF document "Statement of Investment Funds Transactio..." is the property of its rightful owner. Permission is granted to download and print the materials on this web site for personal, non-commercial use only, and to display it on your personal computer provided you do not modify the materials and that you retain all copyright notices contained in the materials. By downloading content from our website, you accept the terms of this agreement.
Statement of Investment Funds Transactions (semt.006) v Securities Transaction Posting Report (semt.017) 17 September 2016
Structural DifferenceFunds Statements2 Semt.006.001.03 Message Identification [1.1] Previous Reference [0.n] Related Reference [0.n] Message Pagination [1.1]Statement General Details [1.1]Investment Account Details Identification [1.1] Name [0.1] Designation [0.1] Intermediary Information [0.10] Account Servicer [0.1]Transaction On Account [0.n] ISIN etc Transaction Details Price Details [0.1] Balance By Page [0.1]Sub Account Details [0.n]Extension [0.n] Pagination [1.1]Statement General Details [1.1]Account Owner [0.1]Safekeeping Account Identification [1.1] Type [0.1] Name [0.1]Financial Instrument Details [0.n] ISIN etc Price Details [0.1] Opening Balance, Closing Balance Transaction [1.n] Transaction Details [0.n] Supplementary Data [0.n]Sub Account Details [0.n] Semt.017.001.06 There are some structural differences
Main SequencesFunds Statements3 Semt.006.001.03 Message Identification [1.1] Previous Reference [0.n] Related Reference [0.n] Message Pagination [1.1]Statement General Details [1.1]Investment Account Details Identification [1.1] Name [0.1] Designation [0.1] Intermediary Information [0.10] Account Servicer [0.1]Transaction On Account [0.n]Sub Account Details [0.n]Extension [0.n]Pagination [1.1] Statement General Details [1.1]Account Owner [0.1]Safekeeping Account Identification [1.1] Type [0.1] Name [0.1]Financial Instrument Details [0.n]Sub Account Details [0.n]Semt.017.001.06Must be used with BAH Not included in semt.017 because semt.017 is designed for use with BAH specific element in Statement General Details (Query Reference) Semt.006 has an Account Servicer element but no Account Owner. Semt.017 has an Account Owner element but no Account Servicer
Statement General Details Funds Statements4 Semt.006.001.02 Report Number [0.1] Query Reference [0.1] Statement Identification [0.1] Statement Period[1.1] Frequency [1.1]Update Type [1.1]Statement Basis [1.1]Activity Indicator [1.1]Sub Account Indicator [1.1]Semt.017.001.08‘Related Reference’ in semt.006Reference [1.1]Statement Period[1.1] Creation Date Time [0.1]Frequency [1.1]Update Type [1.1]Activity Indictor [1.1]Report Number [0.1]
Transaction Details V TransactionFunds Statements5 Semt.006.001.03 Transaction Details [0.n] Identification [1.1] (ISIN etc) Name [0.1] Supplementary Identification [0.1] Securities Form [0.1] Class Type [0.1] Distribution Policy [0.1] Transaction Details [0.1] Balance By Page [0.1] Opening Balance [0.1] Closing Balance [0.1] Semt.017.001.06 Financial Instrument Details [0.n] Financial Instrument Identification [1.1] ISIN (etc) Description Price Details [0.1] Safekeeping Place [0.1] Opening Balance [0.1] Closing Balance [0.1] Transaction [0.1]
Transaction On Account/ Financial Instrument Details Funds Statements 6 Semt.006.001.03 Semt.017.001.06 Transaction [1n] Account Owner Transaction Identification [1.1] Account Servicer Transaction Identification [0.1] Market Infrastructure Transaction Identification [0.1] Processor Transaction Identification [0.1] Trade Identification [0.n] Pool Identification [0.1] Common Identification [0.1] Corporate Action Event Identification [0.1] Triparty Agent Collateral Identification [0.1] Client Collateral Instruction Identification [0.1] Triparty Collateral Instruction Identification [0.1] Transaction Details [0.1] see next slide Transaction Details [1.n] Event Type [1.1] (choice) Transaction Type Corporate Action Type Booking Status [0.1] Master Reference [0.1[ Order Reference [0.1[ Client Reference [0.1] Deal Reference [0.1] Leg Identification [0.1] Leg Execution Identification [0.1] Order Date Time [0.1] Settled Transaction Indicator [1.1] Registered Transaction Indicator [1.1] Units Quantity [1.1] Credit Debit [1.1] Reversal [0.1] Settlement Amount [0.1] Settlement Date [0.1] Trade Date Time [1.1] Cum Dividend Indicator [1.1] Partial Executed Indicator [1.1] Price Details [0.1]
Transaction On Account/ Financial Instrument Details Funds Statements 7 Semt.006.001.03 Semt.017.001.06 Transaction [1n] continued Transaction Details [0.1] Transaction Activity [1.1] codes Settle Transaction Or CA Event Type [0.1] (choice) Securities Transaction Type Corporate Action Event Type Securities Movement Type [1.1] Payment [1.1] Settlement Parameters [0.1] Place of Trade [0.1] Safekeeping Place [0.1] Place of Clearing [0.1] Posting Quantity [1.1] Number of Day Accrued [0.1] Posting Amount [0.1] Accrued Interest Amount [0.1] Trade Date [0.1] Effective Settlement Date [1.1] Settlement Date [0.1] Value Date [0.1] Delivering Settlement Parties [0.1] Receiving Settlement Parties [0.1] Reversal Indicator [0.1] Transaction Additional Details [0.1] Transaction Details [1.n] Event Type [1.1] (choice) Transaction Type Corporate Action Type Booking Status [0.1] Master Reference [0.1] Order Reference [0.1] Client Reference [0.1] Deal Reference [0.1] Leg Identification [0.1] Leg Execution Identification [0.1] Order Date Time [0.1] Settled Transaction Indicator [1.1] Registered Transaction Indicator [1.1] Units Quantity [1.1] Credit Debit [1.1][ Reversal [0.1] Settlement Amount [0.1] Settlement Date [0.1] Trade Date Time [1.1] Cum Dividend Indicator [1.1] Partial Executed Indicator [1.1] Price Details [0.1]
Example MXs - semt.006Funds Statements8 <StmtOfInvstmtFndTxs > <MsgId > <Id>123456</Id> <CreDtTm>2016-09-13T13:00:00</CreDtTm> </MsgId> <MsgPgntn> <PgNb>1</PgNb> <LastPgInd>true </LastPgInd> </MsgPgntn> <StmtGnlDtls> <Ref>Statement 1</Ref> <StmtPrd> <FrDt>2016-08-01</FrDt> <ToDt>2016-09-01</ToDt> </StmtPrd> <Frqcy> MNTH</Frqcy> <UpdTp>COMP</UpdTp> <ActvtyInd> true </ActvtyInd > </StmtGnlDtls > <InvstmtAcctDtls> <Id> 111111 </Id> <IntrmyInf> <BICOrBEI> PEFILULL </BICOrBEI> <Role> <Cd> DIST </Cd> </Role> </IntrmyInf> </InvstmtAcctDtls> <TxOnAcct > <Id> <ISIN> LU1234567890 </ISIN> </Id > <TxDtls > <EvtTp> <TxTp><Tp> SUBS </Tp></TxTp > </EvtTp > <OrdrRef> Order 1 </OrdrRef > <SttldTxInd> false </SttldTxInd > <RegdTxInd> true </RegdTxInd > <UnitsQty> 100 </UnitsQty> <CdtDbt>CRDT</CdtDbt> <SttlmAmt Ccy="EUR">1000</SttlmAmt> <TradDtTm>2016-08-30</TradDtTm> <CumDvddInd>true</CumDvddInd> <PrtlyExctdInd>false</PrtlyExctdInd> <PricDtls> <PricTp> <Cd>NAVL</Cd> </PricTp> <Amt Ccy="EUR">10</Amt> </PricDtls> </TxDtls> </TxOnAcct></StmtOfInvstmtFndTxs> Not an exact representation of the XML Will this message example map to the semt.017? - not exactly
Example MXs - semt.017Funds Statements9 <SctiesTxPstngRpt > <Pgntn > <PgNb>1</PgNb> <LastPgInd>true</LastPgInd> </Pgntn> <StmtGnlDtls> <StmtPrd> <FrDtToDt> <FrDt>2016-08-01</FrDt> <ToDt>2016-09-01</ToDt> </FrDtToDt> </StmtPrd> <Frqcy>MNTH</Frqcy> <UpdTp>COMP</UpdTp> <StmtBsis>SETT</StmtBsis> <ActvtyInd>true </ActvtyInd> <SubAcctInd> false </SubAcctInd > </StmtGnlDtls > <SfkpgAcct > <Id> 111111 </Id > </SfkpgAcct > <FinInstrmDtls > <FinInstrmId > <ISIN> LU1234567890 </ISIN > </FinInstrmId > Not an exact representation of the XML <PricDtls > <Tp>MRKT</Tp > <ValTp><Yldd>false</Yldd></ValTp > <Amt Ccy=" EUR "> 10 </Amt > </PricDtls > <Tx > <AcctOwnrTxId> Order 1 </AcctOwnrTxId > <TxDtls > <TxActvty>SETT</TxActvty> <SttlmTxOrCorpActnEvtTp> <SctiesTxTp>SUBS</SctiesTxTp> </SttlmTxOrCorpActnEvtTp> <SctiesMvmntTp>RECE</SctiesMvmntTp> <Pmt>FREE</Pmt> <PstngQty> <Qty> <Unit>1000</Unit> </Qty> </PstngQty> <FctvSttlmDt> <Dt>2990-12-31</Dt> </FctvSttlmDt> </TxDtls> </Tx> </FinInstrmDtls> </SctiesTxPstngRpt >
Example MXs - semt.006Funds Statements10 <StmtOfInvstmtFndTxs > <MsgId > <Id>123456</Id> <CreDtTm>2016-09-13T13:00:00</CreDtTm> </MsgId> <MsgPgntn> <PgNb>1</PgNb> <LastPgInd>true </LastPgInd> </MsgPgntn> <StmtGnlDtls> <Ref>Statement 1</Ref> <StmtPrd> <FrDt>2016-08-01</FrDt> <ToDt>2016-09-01</ToDt> </StmtPrd> <Frqcy> MNTH</Frqcy> <UpdTp>COMP</UpdTp> <ActvtyInd> true </ActvtyInd > </StmtGnlDtls > <InvstmtAcctDtls> <Id> 111111 </Id> <IntrmyInf> <BICOrBEI> PEFILULL </BICOrBEI> <Role> <Cd> DIST </Cd> </Role> </IntrmyInf> </InvstmtAcctDtls> <TxOnAcct > <Id> <ISIN> LU1234567890 </ISIN> </Id > <TxDtls > <EvtTp> <TxTp><Tp> SUBS </Tp></TxTp > </EvtTp> <OrdrRef> Order 1 </OrdrRef > <SttldTxInd>false</SttldTxInd > <RegdTxInd>true</RegdTxInd > <UnitsQty> 100 </UnitsQty > <CdtDbt> CRDT</CdtDbt> <SttlmAmt Ccy="EUR">1000</SttlmAmt> <TradDtTm>2016-08-30</TradDtTm> <CumDvddInd>true</CumDvddInd> <PrtlyExctdInd>false</PrtlyExctdInd> <PricDtls> <PricTp>NAVL</PricTp> <Amt Ccy="EUR">10</Amt> </PricDtls> </TxDtls> </TxOnAcct></StmtOfInvstmtFndTxs> Not an exact representation of the XML Shows some issues
Mismatches 1Funds Statements11 # Item Comment Account Owner Transaction Identification [1.1]Maybe Order Reference could populate this? However, Order Reference is optional in semt.006 Transaction Activity [1.1] , codes for borrowing, collateral, CA, market claim and SETTSETT is closest code, (Transaction relates to settlement and clearing.)Effective Settlement Date [1.1] (Date and time at which a transaction is completed and cleared, that is, payment is effected and securities are delivered.) Mandatory items in semt.017 (no equivalent in semt.006) but should be ‘easy’ to populate? # Item Comment Securities Movement Type [1.1] C odes DELI, RECE Payment [1.1], codes APMT, FREE Settlement Basis [1.1] ( Type of balance on which the statement is prepared. ) Codes: SETT, TRAD Mandatory Elements in semt.017 with no equivalent in semt.006
Mismatches 2Funds Statements12 # Item Comment Price Details [0.1] / Type – codes Indicative and MarketNeeds price types, eg, NAVL. If Price Details is used, mandatory to specify Value Type (Yielded indicator or codes for Discount, Par and Premium)Also a problem with semt.002.001.08Gaps in semt.017#Item Comment Settlement Transaction Or Corporate Action Event Type / Securities Transaction Type / Code SUBS, REDM present. Will need more, eg., switch, transfer. Intermediary : r ole & party identification Financial Instrument: Name, Supplementary Identification, Securities Form, Class Type, Distribution Policy Settled Transaction Indicator [1.1] ( I ndicates whether the cash payment with respect to the executed order is settled .) Registered Transaction Indicator [1.1] ( Indicates whether the executed order has a registered status on the books of the transfer agent. ) Settlement Amount Semt.017 has Posting Amount Optional elements in semt.017 that are problematical
Mismatches 3Funds Statements13 # Item Comment Trade Date ( Date and time at which a price is applied, according to the terms stated in the prospectus.)Present in semt.017 but definition is ‘date on which the trade was executed.’ Mandatory elements in semt.006 not directly present in semt.017 #Item Comment Price Details [0.1] / Price Method Other optional elements in semt.006 not present in semt.017