hari krishna
asked on
I have convert the XML file data into CSV with | separator and to generate the CSV out file
Hi Team,
I have multiple XML file in a txt file in same format with attributes and the data . I have convert the XML file data into CSV with | separator and to generate the CSV out file
I need generate the data in csv file as below format
SystemCodes|LastApprovedVe rsion|Loca lId|Effect iveDate|Da taStatus|I nternalIde ntifier|Lo calId
Y37F40|2|0171375670|2018-0 6-24T06:38 :47.093-04 :00|Active |00000000- 0000-0000- 0000-00000 8180d98|01 71375670.
could you please help me in this .
PFA sample txt file
Many thanks in Advance,
Hari.
sample file:-
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<StandingSettlementInstruc tion xmlns="http://www.service.cdds.cs.com/ssiData_2">
<StableChangeVersion>2</St ableChange Version>
<Core>
<LocalId>0171375670</Local Id>
<EffectiveDate>2018-06-24T 06:38:47.0 93-04:00</ EffectiveD ate>
<DataStatus>Active</DataSt atus>
<InternalIdentifier>000000 00-0000-00 00-0000-00 0008180d98 </Internal Identifier >
</Core>
<Change>
<LastApprovedVersion>2</La stApproved Version>
<LatestReviewTime>2018-06- 24T06:38:4 7.013-04:0 0</LatestR eviewTime>
</Change>
<SystemCodes>
<SystemCodeType>
<Id>NTPA</Id>
</SystemCodeType>
<Value>Y37F40</Value>
<ValueStatus>Active</Value Status>
</SystemCodes>
<LatestReviewers>
<userName>msiepra</userNam e>
</LatestReviewers>
<TradingAccount>
<Core>
<LocalId>0170485038</Local Id>
</Core>
<SystemCodes>
<SystemCodeType>
<Id>TradingAccountGSID</Id >
</SystemCodeType>
<Value>4973662</Value>
<ValueStatus>Active</Value Status>
</SystemCodes>
<SystemCodes>
<SystemCodeType>
<Id>NTPA</Id>
</SystemCodeType>
<Value>Y37F40</Value>
<ValueStatus>Active</Value Status>
</SystemCodes>
<SystemCodes>
<SystemCodeType>
<Id>FXOPs</Id>
</SystemCodeType>
<Value>L61774</Value>
<ValueStatus>Active</Value Status>
</SystemCodes>
<SystemCodes>
<SystemCodeType>
<Id>SDSFB</Id>
</SystemCodeType>
<Value>MARSH38LONGB</Value >
<ValueStatus>Active</Value Status>
</SystemCodes>
</TradingAccount>
<Country>
<IsoCode>DE</IsoCode>
</Country>
<Security>
<Id>COB</Id>
</Security>
<SettlementMethod>
<Id>EURO_CLEAR</Id>
</SettlementMethod>
<Currency>
<IsoCode>EUR</IsoCode>
</Currency>
<DefaultSsi>true</DefaultS si>
<TermsOfDelivery>
<Id>FOP</Id>
</TermsOfDelivery>
<SettlementType>NON_CASH</ Settlement Type>
<ClassOfAccount>BOTH</Clas sOfAccount >
<SettlementChainEntries>
<StepType>NonCashDeagReag< /StepType>
<IdentifierType>
<Id>SWIFT_BIC</Id>
</IdentifierType>
</SettlementChainEntries>
<SettlementChainEntries>
<StepType>NonCashDecuRecu< /StepType>
<IdentifierType>
<Id>SWIFT_BIC</Id>
</IdentifierType>
</SettlementChainEntries>
<SettlementChainEntries>
<StepType>NonCashPset</Ste pType>
<Bic>MGTCBEBEECL</Bic>
<AccountNumber>47950</Acco untNumber>
<IdentifierType>
<Id>SWIFT_BIC</Id>
</IdentifierType>
</SettlementChainEntries>
<RecDel>BOTH</RecDel>
<CptyFirm>CPTY</CptyFirm>
<CountryOfSettlement/>
<SettleTypeOverride>
<Id>EE</Id>
</SettleTypeOverride>
</StandingSettlementInstru ction>
</SettlementMethod>
<AlertIndex>1</AlertIndex>
<Currency>
<IsoCode>EUR</IsoCode>
</Currency>
<DefaultSsi>true</DefaultS si>
<TermsOfDelivery>
<Id>DVP</Id>
</TermsOfDelivery>
<SettlementType>NON_CASH</ Settlement Type>
<ClassOfAccount>BOTH</Clas sOfAccount >
<SettlementChainEntries>
<StepType>NonCashPset</Ste pType>
<Bic>MOTIITMMXXX</Bic>
<AccountNumber>2808</Accou ntNumber>
<IdentifierType>
<Id>SWIFT_BIC</Id>
</IdentifierType>
</SettlementChainEntries>
<SettlementChainEntries>
<StepType>NonCashDeagReag< /StepType> ^Z
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<StandingSettlementInstruc tion xmlns="http://www.service.cdds.cs.com/ssiData_2">
<StableChangeVersion>5</St ableChange Version>
<Core>
<LocalId>0159515092</Local Id>
<EffectiveDate>2015-04-27T 00:00:00.0 00-04:00</ EffectiveD ate>
<ClosingDate>2018-07-11T18 :00:56.487 -04:00</Cl osingDate>
<DataStatus>Closed</DataSt atus>
<InternalIdentifier>000000 00-0000-00 00-0000-00 000302953a </Internal Identifier >
</Core>
<Change>
<LastApprovedVersion>5</La stApproved Version>
<LatestReviewTime>2018-07- 11T18:00:5 6.487-04:0 0</LatestR eviewTime>
</Change>
<SystemCodes>
<SystemCodeType>
<Id>NTPANY</Id>
</SystemCodeType>
<Value>2YVED0</Value>
<ValueStatus>Active</Value Status>
</SystemCodes>
<SystemCodes>
<SystemCodeType>
<Id>NTPA</Id>
</SystemCodeType>
<Value>YXWZS0</Value>
<ValueStatus>Active</Value Status>
</SystemCodes>
<LatestReviewers>
<userName>AlertDownloader< /userName>
</LatestReviewers>
<TradingAccount>
<Core>
<LocalId>0159514367</Local Id>
</Core>
<SystemCodes>
<SystemCodeType>
<Id>TradingAccountGSID</Id >
</SystemCodeType>
<Value>4770729</Value>
<ValueStatus>Active</Value Status>
</SystemCodes>
<SystemCodes>
<SystemCodeType>
<Id>NTPANY</Id>
</SystemCodeType>
<Value>2YVED0</Value>
<ValueStatus>Active</Value Status>
</SystemCodes>
<SystemCodes>
<SystemCodeType>
<Id>NTPA</Id>
</SystemCodeType>
<Value>YXWZS0</Value>
<ValueStatus>Active</Value Status>
</SystemCodes>
</TradingAccount>
<Country>
<IsoCode>MX</IsoCode>
</Country>
<Security>
<Id>EQU</Id>
</Security>
<SettlementMethod>
<Id>INDEVAL</Id>
</SettlementMethod>
<AlertIndex>1</AlertIndex>
<Currency>
<IsoCode>MXN</IsoCode>
</Currency>
<DefaultSsi>true</DefaultS si>
<TermsOfDelivery>
<Id>DVP</Id>
</TermsOfDelivery>
<SettlementType>NON_CASH</ Settlement Type>
<ClassOfAccount>BOTH</Clas sOfAccount >
<SettlementChainEntries>
<StepType>NonCashPset</Ste pType>
<Bic>INDEMXMMXXX</Bic>
<IdentifierType>
<Id>SWIFT_BIC</Id>
</IdentifierType>
</SettlementChainEntries>
<SettlementChainEntries>
<StepType>NonCashDeagReag< /StepType>
<SettlementAgentName>CITIB ANK, MEXICO</SettlementAgentNam e>
<Bic>CITIUS33MER</Bic>
<AccountNumber>229347</Acc ountNumber >
<IdentifierType>
<Id>SWIFT_BIC</Id>
</IdentifierType>
</SettlementChainEntries>
<SettlementChainEntries>
<StepType>NonCashDecuRecu< /StepType>
<SettlementAgentName>STATE STREET BANK AND TRUST COMPANY</SettlementAgentNa me>
<Bic>SBOSUS3CXXX</Bic>
<IdentifierType>
<Id>SWIFT_BIC</Id>
</IdentifierType>
</SettlementChainEntries>
<RecDel>BOTH</RecDel>
<CptyFirm>CPTY</CptyFirm>
</StandingSettlementInstru ction>
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<StandingSettlementInstruc tion xmlns="http://www.service.cdds.cs.com/ssiData_2">
<StableChangeVersion>2</St ableChange Version>
<Core>
<LocalId>0164568752</Local Id>
<EffectiveDate>2013-05-31T 00:00:00.0 00-04:00</ EffectiveD ate>
<ClosingDate>2018-07-11T18 :01:04.183 -04:00</Cl osingDate>
<DataStatus>Closed</DataSt atus>
<InternalIdentifier>000000 00-0000-00 00-0000-00 00041af159 </Internal Identifier >
</Core>
<Change>
<LastApprovedVersion>2</La stApproved Version>
<LatestReviewTime>2018-07- 11T18:01:0 4.183-04:0 0</LatestR eviewTime>
</Change>
<LatestReviewers>
<userName>AlertDownloader< /userName>
</LatestReviewers>
<TradingAccount>
<Core>
<LocalId>0159514369</Local Id>
</Core>
<SystemCodes>
<SystemCodeType>
<Id>TradingAccountGSID</Id >
</SystemCodeType>
<Value>4770730</Value>
<ValueStatus>Active</Value Status>
</SystemCodes>
<SystemCodes>
<SystemCodeType>
<Id>NTPANY</Id>
</SystemCodeType>
<Value>2YVEE0</Value>
<ValueStatus>Active</Value Status>
</SystemCodes>
<SystemCodes>
<SystemCodeType>
<Id>NTPA</Id>
</SystemCodeType>
<Value>YXWZU0</Value>
<ValueStatus>Active</Value Status>
</SystemCodes>
</TradingAccount>
<Country>
<IsoCode>AU</IsoCode>
</Country>
<Security>
<Id>FX</Id>
</Security>
<SettlementMethod>
<Id>CASH</Id>
</SettlementMethod>
<AlertIndex>1</AlertIndex>
<Currency>
<IsoCode>AUD</IsoCode>
</Currency>
<DefaultSsi>true</DefaultS si>
<TermsOfDelivery>
<Id>FOP</Id>
</TermsOfDelivery>
<SettlementType>CASH</Sett lementType >
<ClassOfAccount>NOSTRO</Cl assOfAccou nt>
<SettlementChainEntries>
<StepType>CashBeneficiary< /StepType>
<SettlementAgentName>MSFIB </Settleme ntAgentNam e>
<IdentifierType>
<Id>FREE_FORMAT</Id>
</IdentifierType>
</SettlementChainEntries>
<SettlementChainEntries>
<StepType>CashLocalAgent</ StepType>
<SettlementAgentName>STATE STREET BANK AND TRUST COMPANY</SettlementAgentNa me>
<SettlementAgentName2>, SYDNEY BRANCH</SettlementAgentNam e2>
<Bic>SBOSAU2XXXX</Bic>
<AccountNumber>BOSTAUD01</ AccountNum ber>
<SubAccountNumber>AU913001 </SubAccou ntNumber>
<AssociatedBankCodeType>OT HER</Assoc iatedBankC odeType>
<IdentifierType>
<Id>SWIFT_BIC</Id>
</IdentifierType>
</SettlementChainEntries>
<SettlementChainEntries>
<StepType>CashCustodian</S tepType>
<SettlementAgentName>STATE STREET BANK AND TRUST CO.</SettlementAgentName>
<Bic>SBOSUS3FXXX</Bic>
<AccountNumber>5BB3</Accou ntNumber>
<IdentifierType>
<Id>SWIFT_BIC</Id>
</IdentifierType>
</SettlementChainEntries>
<InstructionEventType>
<Id>NC</Id>
</InstructionEventType>
<RecDel>BOTH</RecDel>
<CptyFirm>CPTY</CptyFirm>
<MTO>true</MTO>
</StandingSettlementInstru ction>
</SettlementMethod>
<AlertIndex>1</AlertIndex>
<Currency>
<IsoCode>EUR</IsoCode>
</Currency>
<DefaultSsi>true</DefaultS si>
<TermsOfDelivery>
<Id>DVP</Id>
</TermsOfDelivery>
<SettlementType>NON_CASH</ Settlement Type>
<ClassOfAccount>BOTH</Clas sOfAccount >
<SettlementChainEntries>
<StepType>NonCashPset</Ste pType>
<Bic>MOTIITMMXXX</Bic>
<AccountNumber>2808</Accou ntNumber>
<IdentifierType>
<Id>SWIFT_BIC</Id>
</IdentifierType>
</SettlementChainEntries>
<SettlementChainEntries>
<StepType>NonCashDeagReag< /StepType>
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<StandingSettlementInstruc tion xmlns="http://www.service.cdds.cs.com/ssiData_2">
<StableChangeVersion>5</St ableChange Version>
<Core>
<LocalId>0159515083</Local Id>
<EffectiveDate>2016-09-11T 00:00:00.0 00-04:00</ EffectiveD ate>
<ClosingDate>2018-07-11T18 :00:54.092 -04:00</Cl osingDate>
<DataStatus>Closed</DataSt atus>
<InternalIdentifier>000000 00-0000-00 00-0000-00 0003029531 </Internal Identifier >
</Core>
<Change>
<LastApprovedVersion>5</La stApproved Version>
<LatestReviewTime>2018-07- 11T18:00:5 4.092-04:0 0</LatestR eviewTime>
</Change>
<SystemCodes>
<SystemCodeType>
<Id>NTPANY</Id>
</SystemCodeType>
<Value>2YVED0</Value>
<ValueStatus>Active</Value Status>
</SystemCodes>
<SystemCodes>
<SystemCodeType>
<Id>NTPA</Id>
</SystemCodeType>
<Value>YXWZS0</Value>
<ValueStatus>Active</Value Status>
</SystemCodes>
<LatestReviewers>
<userName>AlertDownloader< /userName>
</LatestReviewers>
<TradingAccount>
<Core>
<LocalId>0159514367</Local Id>
</Core>
<SystemCodes>
<SystemCodeType>
<Id>TradingAccountGSID</Id >
</SystemCodeType>
<Value>4770729</Value>
<ValueStatus>Active</Value Status>
</SystemCodes>
<SystemCodes>
<SystemCodeType>
<Id>NTPANY</Id>
</SystemCodeType>
<Value>2YVED0</Value>
<ValueStatus>Active</Value Status>
</SystemCodes>
<SystemCodes>
<SystemCodeType>
<Id>NTPA</Id>
</SystemCodeType>
<Value>YXWZS0</Value>
<ValueStatus>Active</Value Status>
</SystemCodes>
</TradingAccount>
<Country>
<IsoCode>DK</IsoCode>
</Country>
<Security>
<Id>EQU</Id>
</Security>
<SettlementMethod>
<Id>VP</Id>
</SettlementMethod>
<AlertIndex>1</AlertIndex>
<Currency>
<IsoCode>DKK</IsoCode>
</Currency>
<DefaultSsi>true</DefaultS si>
<TermsOfDelivery>
<Id>DVP</Id>
</TermsOfDelivery>
<SettlementType>NON_CASH</ Settlement Type>
<ClassOfAccount>BOTH</Clas sOfAccount >
<SettlementChainEntries>
<StepType>NonCashPset</Ste pType>
<Bic>VPDKDKKKXXX</Bic>
<AccountNumber>05295</Acco untNumber>
<IdentifierType>
<Id>SWIFT_BIC</Id>
</IdentifierType>
</SettlementChainEntries>
<SettlementChainEntries>
<StepType>NonCashDeagReag< /StepType>
<SettlementAgentName>SKAND INAVISKA ENSKILDA BANKEN</SettlementAgentNam e>
<Bic>ESSEDKKKXXX</Bic>
<AccountNumber>5295061911< /AccountNu mber>
<IdentifierType>
<Id>SWIFT_BIC</Id>
</IdentifierType>
</SettlementChainEntries>
<SettlementChainEntries>
<StepType>NonCashDecuRecu< /StepType>
<SettlementAgentName>STATE STREET BANK AND TRUST COMPANY</SettlementAgentNa me>
<Bic>SBOSUS3CXXX</Bic>
<IdentifierType>
<Id>SWIFT_BIC</Id>
</IdentifierType>
</SettlementChainEntries>
<RecDel>BOTH</RecDel>
<CptyFirm>CPTY</CptyFirm>
</StandingSettlementInstru ction>
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<StandingSettlementInstruc tion xmlns="http://www.service.cdds.cs.com/ssiData_2">
<StableChangeVersion>5</St ableChange Version>
<Core>
<LocalId>0159515092</Local Id>
<EffectiveDate>2015-04-27T 00:00:00.0 00-04:00</ EffectiveD ate>
<ClosingDate>2018-07-11T18 :00:56.487 -04:00</Cl osingDate>
<DataStatus>Closed</DataSt atus>
<InternalIdentifier>000000 00-0000-00 00-0000-00 000302953a </Internal Identifier >
</Core>
<Change>
<LastApprovedVersion>5</La stApproved Version>
<LatestReviewTime>2018-07- 11T18:00:5 6.487-04:0 0</LatestR eviewTime>
</Change>
<SystemCodes>
<SystemCodeType>
<Id>NTPANY</Id>
</SystemCodeType>
<Value>2YVED0</Value>
<ValueStatus>Active</Value Status>
</SystemCodes>
<SystemCodes>
<SystemCodeType>
<Id>NTPA</Id>
</SystemCodeType>
<Value>YXWZS0</Value>
<ValueStatus>Active</Value Status>
</SystemCodes>
<LatestReviewers>
<userName>AlertDownloader< /userName>
</LatestReviewers>
<TradingAccount>
<Core>
<LocalId>0159514367</Local Id>
</Core>
<SystemCodes>
<SystemCodeType>
<Id>TradingAccountGSID</Id >
</SystemCodeType>
<Value>4770729</Value>
<ValueStatus>Active</Value Status>
</SystemCodes>
<SystemCodes>
<SystemCodeType>
<Id>NTPANY</Id>
</SystemCodeType>
<Value>2YVED0</Value>
<ValueStatus>Active</Value Status>
</SystemCodes>
<SystemCodes>
<SystemCodeType>
<Id>NTPA</Id>
</SystemCodeType>
<Value>YXWZS0</Value>
<ValueStatus>Active</Value Status>
</SystemCodes>
</TradingAccount>
<Country>
<IsoCode>MX</IsoCode>
</Country>
<Security>
<Id>EQU</Id>
</Security>
<SettlementMethod>
<Id>INDEVAL</Id>
</SettlementMethod>
<AlertIndex>1</AlertIndex>
<Currency>
<IsoCode>MXN</IsoCode>
</Currency>
<DefaultSsi>true</DefaultS si>
<TermsOfDelivery>
<Id>DVP</Id>
</TermsOfDelivery>
<SettlementType>NON_CASH</ Settlement Type>
<ClassOfAccount>BOTH</Clas sOfAccount >
<SettlementChainEntries>
<StepType>NonCashPset</Ste pType>
<Bic>INDEMXMMXXX</Bic>
<IdentifierType>
<Id>SWIFT_BIC</Id>
</IdentifierType>
</SettlementChainEntries>
<SettlementChainEntries>
<StepType>NonCashDeagReag< /StepType>
<SettlementAgentName>CITIB ANK, MEXICO</SettlementAgentNam e>
<Bic>CITIUS33MER</Bic>
<AccountNumber>229347</Acc ountNumber >
<IdentifierType>
<Id>SWIFT_BIC</Id>
</IdentifierType>
</SettlementChainEntries>
<SettlementChainEntries>
<StepType>NonCashDecuRecu< /StepType>
<SettlementAgentName>STATE STREET BANK AND TRUST COMPANY</SettlementAgentNa me>
<Bic>SBOSUS3CXXX</Bic>
<IdentifierType>
<Id>SWIFT_BIC</Id>
</IdentifierType>
</SettlementChainEntries>
<RecDel>BOTH</RecDel>
<CptyFirm>CPTY</CptyFirm>
</StandingSettlementInstru ction>
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<StandingSettlementInstruc tion xmlns="http://www.service.cdds.cs.com/ssiData_2">
<StableChangeVersion>2</St ableChange Version>
<Core>
<LocalId>0164568752</Local Id>
<EffectiveDate>2013-05-31T 00:00:00.0 00-04:00</ EffectiveD ate>
<ClosingDate>2018-07-11T18 :01:04.183 -04:00</Cl osingDate>
<DataStatus>Closed</DataSt atus>
<InternalIdentifier>000000 00-0000-00 00-0000-00 00041af159 </Internal Identifier >
</Core>
<Change>
<LastApprovedVersion>2</La stApproved Version>
<LatestReviewTime>2018-07- 11T18:01:0 4.183-04:0 0</LatestR eviewTime>
</Change>
<LatestReviewers>
<userName>AlertDownloader< /userName>
</LatestReviewers>
<TradingAccount>
<Core>
<LocalId>0159514369</Local Id>
</Core>
<SystemCodes>
<SystemCodeType>
<Id>TradingAccountGSID</Id >
</SystemCodeType>
<Value>4770730</Value>
<ValueStatus>Active</Value Status>
</SystemCodes>
<SystemCodes>
<SystemCodeType>
<Id>NTPANY</Id>
</SystemCodeType>
<Value>2YVEE0</Value>
<ValueStatus>Active</Value Status>
</SystemCodes>
<SystemCodes>
<SystemCodeType>
<Id>NTPA</Id>
</SystemCodeType>
<Value>YXWZU0</Value>
<ValueStatus>Active</Value Status>
</SystemCodes>
</TradingAccount>
<Country>
<IsoCode>AU</IsoCode>
</Country>
<Security>
<Id>FX</Id>
</Security>
<SettlementMethod>
<Id>CASH</Id>
</SettlementMethod>
<AlertIndex>1</AlertIndex>
<Currency>
<IsoCode>AUD</IsoCode>
</Currency>
<DefaultSsi>true</DefaultS si>
<TermsOfDelivery>
<Id>FOP</Id>
</TermsOfDelivery>
<SettlementType>CASH</Sett lementType >
<ClassOfAccount>NOSTRO</Cl assOfAccou nt>
<SettlementChainEntries>
<StepType>CashBeneficiary< /StepType>
<SettlementAgentName>MSFIB </Settleme ntAgentNam e>
<IdentifierType>
<Id>FREE_FORMAT</Id>
</IdentifierType>
</SettlementChainEntries>
<SettlementChainEntries>
<StepType>CashLocalAgent</ StepType>
<SettlementAgentName>STATE STREET BANK AND TRUST COMPANY</SettlementAgentNa me>
<SettlementAgentName2>, SYDNEY BRANCH</SettlementAgentNam e2>
<Bic>SBOSAU2XXXX</Bic>
<AccountNumber>BOSTAUD01</ AccountNum ber>
<SubAccountNumber>AU913001 </SubAccou ntNumber>
<AssociatedBankCodeType>OT HER</Assoc iatedBankC odeType>
<IdentifierType>
<Id>SWIFT_BIC</Id>
</IdentifierType>
</SettlementChainEntries>
<SettlementChainEntries>
<StepType>CashCustodian</S tepType>
<SettlementAgentName>STATE STREET BANK AND TRUST CO.</SettlementAgentName>
<Bic>SBOSUS3FXXX</Bic>
<AccountNumber>5BB3</Accou ntNumber>
<IdentifierType>
<Id>SWIFT_BIC</Id>
</IdentifierType>
</SettlementChainEntries>
<InstructionEventType>
<Id>NC</Id>
</InstructionEventType>
<RecDel>BOTH</RecDel>
<CptyFirm>CPTY</CptyFirm>
<MTO>true</MTO>
</StandingSettlementInstru ction>
SSI_sample.txt
I have multiple XML file in a txt file in same format with attributes and the data . I have convert the XML file data into CSV with | separator and to generate the CSV out file
I need generate the data in csv file as below format
SystemCodes|LastApprovedVe
Y37F40|2|0171375670|2018-0
could you please help me in this .
PFA sample txt file
Many thanks in Advance,
Hari.
sample file:-
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<StandingSettlementInstruc
<StableChangeVersion>2</St
<Core>
<LocalId>0171375670</Local
<EffectiveDate>2018-06-24T
<DataStatus>Active</DataSt
<InternalIdentifier>000000
</Core>
<Change>
<LastApprovedVersion>2</La
<LatestReviewTime>2018-06-
</Change>
<SystemCodes>
<SystemCodeType>
<Id>NTPA</Id>
</SystemCodeType>
<Value>Y37F40</Value>
<ValueStatus>Active</Value
</SystemCodes>
<LatestReviewers>
<userName>msiepra</userNam
</LatestReviewers>
<TradingAccount>
<Core>
<LocalId>0170485038</Local
</Core>
<SystemCodes>
<SystemCodeType>
<Id>TradingAccountGSID</Id
</SystemCodeType>
<Value>4973662</Value>
<ValueStatus>Active</Value
</SystemCodes>
<SystemCodes>
<SystemCodeType>
<Id>NTPA</Id>
</SystemCodeType>
<Value>Y37F40</Value>
<ValueStatus>Active</Value
</SystemCodes>
<SystemCodes>
<SystemCodeType>
<Id>FXOPs</Id>
</SystemCodeType>
<Value>L61774</Value>
<ValueStatus>Active</Value
</SystemCodes>
<SystemCodes>
<SystemCodeType>
<Id>SDSFB</Id>
</SystemCodeType>
<Value>MARSH38LONGB</Value
<ValueStatus>Active</Value
</SystemCodes>
</TradingAccount>
<Country>
<IsoCode>DE</IsoCode>
</Country>
<Security>
<Id>COB</Id>
</Security>
<SettlementMethod>
<Id>EURO_CLEAR</Id>
</SettlementMethod>
<Currency>
<IsoCode>EUR</IsoCode>
</Currency>
<DefaultSsi>true</DefaultS
<TermsOfDelivery>
<Id>FOP</Id>
</TermsOfDelivery>
<SettlementType>NON_CASH</
<ClassOfAccount>BOTH</Clas
<SettlementChainEntries>
<StepType>NonCashDeagReag<
<IdentifierType>
<Id>SWIFT_BIC</Id>
</IdentifierType>
</SettlementChainEntries>
<SettlementChainEntries>
<StepType>NonCashDecuRecu<
<IdentifierType>
<Id>SWIFT_BIC</Id>
</IdentifierType>
</SettlementChainEntries>
<SettlementChainEntries>
<StepType>NonCashPset</Ste
<Bic>MGTCBEBEECL</Bic>
<AccountNumber>47950</Acco
<IdentifierType>
<Id>SWIFT_BIC</Id>
</IdentifierType>
</SettlementChainEntries>
<RecDel>BOTH</RecDel>
<CptyFirm>CPTY</CptyFirm>
<CountryOfSettlement/>
<SettleTypeOverride>
<Id>EE</Id>
</SettleTypeOverride>
</StandingSettlementInstru
</SettlementMethod>
<AlertIndex>1</AlertIndex>
<Currency>
<IsoCode>EUR</IsoCode>
</Currency>
<DefaultSsi>true</DefaultS
<TermsOfDelivery>
<Id>DVP</Id>
</TermsOfDelivery>
<SettlementType>NON_CASH</
<ClassOfAccount>BOTH</Clas
<SettlementChainEntries>
<StepType>NonCashPset</Ste
<Bic>MOTIITMMXXX</Bic>
<AccountNumber>2808</Accou
<IdentifierType>
<Id>SWIFT_BIC</Id>
</IdentifierType>
</SettlementChainEntries>
<SettlementChainEntries>
<StepType>NonCashDeagReag<
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<StandingSettlementInstruc
<StableChangeVersion>5</St
<Core>
<LocalId>0159515092</Local
<EffectiveDate>2015-04-27T
<ClosingDate>2018-07-11T18
<DataStatus>Closed</DataSt
<InternalIdentifier>000000
</Core>
<Change>
<LastApprovedVersion>5</La
<LatestReviewTime>2018-07-
</Change>
<SystemCodes>
<SystemCodeType>
<Id>NTPANY</Id>
</SystemCodeType>
<Value>2YVED0</Value>
<ValueStatus>Active</Value
</SystemCodes>
<SystemCodes>
<SystemCodeType>
<Id>NTPA</Id>
</SystemCodeType>
<Value>YXWZS0</Value>
<ValueStatus>Active</Value
</SystemCodes>
<LatestReviewers>
<userName>AlertDownloader<
</LatestReviewers>
<TradingAccount>
<Core>
<LocalId>0159514367</Local
</Core>
<SystemCodes>
<SystemCodeType>
<Id>TradingAccountGSID</Id
</SystemCodeType>
<Value>4770729</Value>
<ValueStatus>Active</Value
</SystemCodes>
<SystemCodes>
<SystemCodeType>
<Id>NTPANY</Id>
</SystemCodeType>
<Value>2YVED0</Value>
<ValueStatus>Active</Value
</SystemCodes>
<SystemCodes>
<SystemCodeType>
<Id>NTPA</Id>
</SystemCodeType>
<Value>YXWZS0</Value>
<ValueStatus>Active</Value
</SystemCodes>
</TradingAccount>
<Country>
<IsoCode>MX</IsoCode>
</Country>
<Security>
<Id>EQU</Id>
</Security>
<SettlementMethod>
<Id>INDEVAL</Id>
</SettlementMethod>
<AlertIndex>1</AlertIndex>
<Currency>
<IsoCode>MXN</IsoCode>
</Currency>
<DefaultSsi>true</DefaultS
<TermsOfDelivery>
<Id>DVP</Id>
</TermsOfDelivery>
<SettlementType>NON_CASH</
<ClassOfAccount>BOTH</Clas
<SettlementChainEntries>
<StepType>NonCashPset</Ste
<Bic>INDEMXMMXXX</Bic>
<IdentifierType>
<Id>SWIFT_BIC</Id>
</IdentifierType>
</SettlementChainEntries>
<SettlementChainEntries>
<StepType>NonCashDeagReag<
<SettlementAgentName>CITIB
<Bic>CITIUS33MER</Bic>
<AccountNumber>229347</Acc
<IdentifierType>
<Id>SWIFT_BIC</Id>
</IdentifierType>
</SettlementChainEntries>
<SettlementChainEntries>
<StepType>NonCashDecuRecu<
<SettlementAgentName>STATE
<Bic>SBOSUS3CXXX</Bic>
<IdentifierType>
<Id>SWIFT_BIC</Id>
</IdentifierType>
</SettlementChainEntries>
<RecDel>BOTH</RecDel>
<CptyFirm>CPTY</CptyFirm>
</StandingSettlementInstru
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<StandingSettlementInstruc
<StableChangeVersion>2</St
<Core>
<LocalId>0164568752</Local
<EffectiveDate>2013-05-31T
<ClosingDate>2018-07-11T18
<DataStatus>Closed</DataSt
<InternalIdentifier>000000
</Core>
<Change>
<LastApprovedVersion>2</La
<LatestReviewTime>2018-07-
</Change>
<LatestReviewers>
<userName>AlertDownloader<
</LatestReviewers>
<TradingAccount>
<Core>
<LocalId>0159514369</Local
</Core>
<SystemCodes>
<SystemCodeType>
<Id>TradingAccountGSID</Id
</SystemCodeType>
<Value>4770730</Value>
<ValueStatus>Active</Value
</SystemCodes>
<SystemCodes>
<SystemCodeType>
<Id>NTPANY</Id>
</SystemCodeType>
<Value>2YVEE0</Value>
<ValueStatus>Active</Value
</SystemCodes>
<SystemCodes>
<SystemCodeType>
<Id>NTPA</Id>
</SystemCodeType>
<Value>YXWZU0</Value>
<ValueStatus>Active</Value
</SystemCodes>
</TradingAccount>
<Country>
<IsoCode>AU</IsoCode>
</Country>
<Security>
<Id>FX</Id>
</Security>
<SettlementMethod>
<Id>CASH</Id>
</SettlementMethod>
<AlertIndex>1</AlertIndex>
<Currency>
<IsoCode>AUD</IsoCode>
</Currency>
<DefaultSsi>true</DefaultS
<TermsOfDelivery>
<Id>FOP</Id>
</TermsOfDelivery>
<SettlementType>CASH</Sett
<ClassOfAccount>NOSTRO</Cl
<SettlementChainEntries>
<StepType>CashBeneficiary<
<SettlementAgentName>MSFIB
<IdentifierType>
<Id>FREE_FORMAT</Id>
</IdentifierType>
</SettlementChainEntries>
<SettlementChainEntries>
<StepType>CashLocalAgent</
<SettlementAgentName>STATE
<SettlementAgentName2>, SYDNEY BRANCH</SettlementAgentNam
<Bic>SBOSAU2XXXX</Bic>
<AccountNumber>BOSTAUD01</
<SubAccountNumber>AU913001
<AssociatedBankCodeType>OT
<IdentifierType>
<Id>SWIFT_BIC</Id>
</IdentifierType>
</SettlementChainEntries>
<SettlementChainEntries>
<StepType>CashCustodian</S
<SettlementAgentName>STATE
<Bic>SBOSUS3FXXX</Bic>
<AccountNumber>5BB3</Accou
<IdentifierType>
<Id>SWIFT_BIC</Id>
</IdentifierType>
</SettlementChainEntries>
<InstructionEventType>
<Id>NC</Id>
</InstructionEventType>
<RecDel>BOTH</RecDel>
<CptyFirm>CPTY</CptyFirm>
<MTO>true</MTO>
</StandingSettlementInstru
</SettlementMethod>
<AlertIndex>1</AlertIndex>
<Currency>
<IsoCode>EUR</IsoCode>
</Currency>
<DefaultSsi>true</DefaultS
<TermsOfDelivery>
<Id>DVP</Id>
</TermsOfDelivery>
<SettlementType>NON_CASH</
<ClassOfAccount>BOTH</Clas
<SettlementChainEntries>
<StepType>NonCashPset</Ste
<Bic>MOTIITMMXXX</Bic>
<AccountNumber>2808</Accou
<IdentifierType>
<Id>SWIFT_BIC</Id>
</IdentifierType>
</SettlementChainEntries>
<SettlementChainEntries>
<StepType>NonCashDeagReag<
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<StandingSettlementInstruc
<StableChangeVersion>5</St
<Core>
<LocalId>0159515083</Local
<EffectiveDate>2016-09-11T
<ClosingDate>2018-07-11T18
<DataStatus>Closed</DataSt
<InternalIdentifier>000000
</Core>
<Change>
<LastApprovedVersion>5</La
<LatestReviewTime>2018-07-
</Change>
<SystemCodes>
<SystemCodeType>
<Id>NTPANY</Id>
</SystemCodeType>
<Value>2YVED0</Value>
<ValueStatus>Active</Value
</SystemCodes>
<SystemCodes>
<SystemCodeType>
<Id>NTPA</Id>
</SystemCodeType>
<Value>YXWZS0</Value>
<ValueStatus>Active</Value
</SystemCodes>
<LatestReviewers>
<userName>AlertDownloader<
</LatestReviewers>
<TradingAccount>
<Core>
<LocalId>0159514367</Local
</Core>
<SystemCodes>
<SystemCodeType>
<Id>TradingAccountGSID</Id
</SystemCodeType>
<Value>4770729</Value>
<ValueStatus>Active</Value
</SystemCodes>
<SystemCodes>
<SystemCodeType>
<Id>NTPANY</Id>
</SystemCodeType>
<Value>2YVED0</Value>
<ValueStatus>Active</Value
</SystemCodes>
<SystemCodes>
<SystemCodeType>
<Id>NTPA</Id>
</SystemCodeType>
<Value>YXWZS0</Value>
<ValueStatus>Active</Value
</SystemCodes>
</TradingAccount>
<Country>
<IsoCode>DK</IsoCode>
</Country>
<Security>
<Id>EQU</Id>
</Security>
<SettlementMethod>
<Id>VP</Id>
</SettlementMethod>
<AlertIndex>1</AlertIndex>
<Currency>
<IsoCode>DKK</IsoCode>
</Currency>
<DefaultSsi>true</DefaultS
<TermsOfDelivery>
<Id>DVP</Id>
</TermsOfDelivery>
<SettlementType>NON_CASH</
<ClassOfAccount>BOTH</Clas
<SettlementChainEntries>
<StepType>NonCashPset</Ste
<Bic>VPDKDKKKXXX</Bic>
<AccountNumber>05295</Acco
<IdentifierType>
<Id>SWIFT_BIC</Id>
</IdentifierType>
</SettlementChainEntries>
<SettlementChainEntries>
<StepType>NonCashDeagReag<
<SettlementAgentName>SKAND
<Bic>ESSEDKKKXXX</Bic>
<AccountNumber>5295061911<
<IdentifierType>
<Id>SWIFT_BIC</Id>
</IdentifierType>
</SettlementChainEntries>
<SettlementChainEntries>
<StepType>NonCashDecuRecu<
<SettlementAgentName>STATE
<Bic>SBOSUS3CXXX</Bic>
<IdentifierType>
<Id>SWIFT_BIC</Id>
</IdentifierType>
</SettlementChainEntries>
<RecDel>BOTH</RecDel>
<CptyFirm>CPTY</CptyFirm>
</StandingSettlementInstru
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<StandingSettlementInstruc
<StableChangeVersion>5</St
<Core>
<LocalId>0159515092</Local
<EffectiveDate>2015-04-27T
<ClosingDate>2018-07-11T18
<DataStatus>Closed</DataSt
<InternalIdentifier>000000
</Core>
<Change>
<LastApprovedVersion>5</La
<LatestReviewTime>2018-07-
</Change>
<SystemCodes>
<SystemCodeType>
<Id>NTPANY</Id>
</SystemCodeType>
<Value>2YVED0</Value>
<ValueStatus>Active</Value
</SystemCodes>
<SystemCodes>
<SystemCodeType>
<Id>NTPA</Id>
</SystemCodeType>
<Value>YXWZS0</Value>
<ValueStatus>Active</Value
</SystemCodes>
<LatestReviewers>
<userName>AlertDownloader<
</LatestReviewers>
<TradingAccount>
<Core>
<LocalId>0159514367</Local
</Core>
<SystemCodes>
<SystemCodeType>
<Id>TradingAccountGSID</Id
</SystemCodeType>
<Value>4770729</Value>
<ValueStatus>Active</Value
</SystemCodes>
<SystemCodes>
<SystemCodeType>
<Id>NTPANY</Id>
</SystemCodeType>
<Value>2YVED0</Value>
<ValueStatus>Active</Value
</SystemCodes>
<SystemCodes>
<SystemCodeType>
<Id>NTPA</Id>
</SystemCodeType>
<Value>YXWZS0</Value>
<ValueStatus>Active</Value
</SystemCodes>
</TradingAccount>
<Country>
<IsoCode>MX</IsoCode>
</Country>
<Security>
<Id>EQU</Id>
</Security>
<SettlementMethod>
<Id>INDEVAL</Id>
</SettlementMethod>
<AlertIndex>1</AlertIndex>
<Currency>
<IsoCode>MXN</IsoCode>
</Currency>
<DefaultSsi>true</DefaultS
<TermsOfDelivery>
<Id>DVP</Id>
</TermsOfDelivery>
<SettlementType>NON_CASH</
<ClassOfAccount>BOTH</Clas
<SettlementChainEntries>
<StepType>NonCashPset</Ste
<Bic>INDEMXMMXXX</Bic>
<IdentifierType>
<Id>SWIFT_BIC</Id>
</IdentifierType>
</SettlementChainEntries>
<SettlementChainEntries>
<StepType>NonCashDeagReag<
<SettlementAgentName>CITIB
<Bic>CITIUS33MER</Bic>
<AccountNumber>229347</Acc
<IdentifierType>
<Id>SWIFT_BIC</Id>
</IdentifierType>
</SettlementChainEntries>
<SettlementChainEntries>
<StepType>NonCashDecuRecu<
<SettlementAgentName>STATE
<Bic>SBOSUS3CXXX</Bic>
<IdentifierType>
<Id>SWIFT_BIC</Id>
</IdentifierType>
</SettlementChainEntries>
<RecDel>BOTH</RecDel>
<CptyFirm>CPTY</CptyFirm>
</StandingSettlementInstru
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<StandingSettlementInstruc
<StableChangeVersion>2</St
<Core>
<LocalId>0164568752</Local
<EffectiveDate>2013-05-31T
<ClosingDate>2018-07-11T18
<DataStatus>Closed</DataSt
<InternalIdentifier>000000
</Core>
<Change>
<LastApprovedVersion>2</La
<LatestReviewTime>2018-07-
</Change>
<LatestReviewers>
<userName>AlertDownloader<
</LatestReviewers>
<TradingAccount>
<Core>
<LocalId>0159514369</Local
</Core>
<SystemCodes>
<SystemCodeType>
<Id>TradingAccountGSID</Id
</SystemCodeType>
<Value>4770730</Value>
<ValueStatus>Active</Value
</SystemCodes>
<SystemCodes>
<SystemCodeType>
<Id>NTPANY</Id>
</SystemCodeType>
<Value>2YVEE0</Value>
<ValueStatus>Active</Value
</SystemCodes>
<SystemCodes>
<SystemCodeType>
<Id>NTPA</Id>
</SystemCodeType>
<Value>YXWZU0</Value>
<ValueStatus>Active</Value
</SystemCodes>
</TradingAccount>
<Country>
<IsoCode>AU</IsoCode>
</Country>
<Security>
<Id>FX</Id>
</Security>
<SettlementMethod>
<Id>CASH</Id>
</SettlementMethod>
<AlertIndex>1</AlertIndex>
<Currency>
<IsoCode>AUD</IsoCode>
</Currency>
<DefaultSsi>true</DefaultS
<TermsOfDelivery>
<Id>FOP</Id>
</TermsOfDelivery>
<SettlementType>CASH</Sett
<ClassOfAccount>NOSTRO</Cl
<SettlementChainEntries>
<StepType>CashBeneficiary<
<SettlementAgentName>MSFIB
<IdentifierType>
<Id>FREE_FORMAT</Id>
</IdentifierType>
</SettlementChainEntries>
<SettlementChainEntries>
<StepType>CashLocalAgent</
<SettlementAgentName>STATE
<SettlementAgentName2>, SYDNEY BRANCH</SettlementAgentNam
<Bic>SBOSAU2XXXX</Bic>
<AccountNumber>BOSTAUD01</
<SubAccountNumber>AU913001
<AssociatedBankCodeType>OT
<IdentifierType>
<Id>SWIFT_BIC</Id>
</IdentifierType>
</SettlementChainEntries>
<SettlementChainEntries>
<StepType>CashCustodian</S
<SettlementAgentName>STATE
<Bic>SBOSUS3FXXX</Bic>
<AccountNumber>5BB3</Accou
<IdentifierType>
<Id>SWIFT_BIC</Id>
</IdentifierType>
</SettlementChainEntries>
<InstructionEventType>
<Id>NC</Id>
</InstructionEventType>
<RecDel>BOTH</RecDel>
<CptyFirm>CPTY</CptyFirm>
<MTO>true</MTO>
</StandingSettlementInstru
SSI_sample.txt
ASKER
Hi Bhargava,
I have multiple XML files I have to covert the XML data into CSV file and to generate the into CSV output file.
Could you please help me in this.
Many thanks for reply.
sample file :-
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<StandingSettlementInstruc tion xmlns="http://www.service.cdds.cs.com/ssiData_2">
<StableChangeVersion>2</St ableChange Version>
<Core>
<LocalId>0171375670</Local Id>
<EffectiveDate>2018-06-24T 06:38:47.0 93-04:00</ EffectiveD ate>
<DataStatus>Active</DataSt atus>
<InternalIdentifier>000000 00-0000-00 00-0000-00 0008180d98 </Internal Identifier >
</Core>
<Change>
<LastApprovedVersion>2</La stApproved Version>
<LatestReviewTime>2018-06- 24T06:38:4 7.013-04:0 0</LatestR eviewTime>
</Change>
<SystemCodes>
<SystemCodeType>
<Id>NTPA</Id>
</SystemCodeType>
<Value>Y37F40</Value>
<ValueStatus>Active</Value Status>
</SystemCodes>
<LatestReviewers>
<userName>msiepra</userNam e>
</LatestReviewers>
<TradingAccount>
<Core>
<LocalId>0170485038</Local Id>
</Core>
<SystemCodes>
<SystemCodeType>
<Id>TradingAccountGSID</Id >
</SystemCodeType>
<Value>4973662</Value>
<ValueStatus>Active</Value Status>
</SystemCodes>
<SystemCodes>
<SystemCodeType>
<Id>NTPA</Id>
</SystemCodeType>
<Value>Y37F40</Value>
<ValueStatus>Active</Value Status>
</SystemCodes>
<SystemCodes>
<SystemCodeType>
<Id>FXOPs</Id>
</SystemCodeType>
<Value>L61774</Value>
<ValueStatus>Active</Value Status>
</SystemCodes>
<SystemCodes>
<SystemCodeType>
<Id>SDSFB</Id>
</SystemCodeType>
<Value>MARSH38LONGB</Value >
<ValueStatus>Active</Value Status>
</SystemCodes>
</TradingAccount>
<Country>
<IsoCode>DE</IsoCode>
</Country>
<Security>
<Id>COB</Id>
</Security>
<SettlementMethod>
<Id>EURO_CLEAR</Id>
</SettlementMethod>
<Currency>
<IsoCode>EUR</IsoCode>
</Currency>
<DefaultSsi>true</DefaultS si>
<TermsOfDelivery>
<Id>FOP</Id>
</TermsOfDelivery>
<SettlementType>NON_CASH</ Settlement Type>
<ClassOfAccount>BOTH</Clas sOfAccount >
<SettlementChainEntries>
<StepType>NonCashDeagReag< /StepType>
<IdentifierType>
<Id>SWIFT_BIC</Id>
</IdentifierType>
</SettlementChainEntries>
<SettlementChainEntries>
<StepType>NonCashDecuRecu< /StepType>
<IdentifierType>
<Id>SWIFT_BIC</Id>
</IdentifierType>
</SettlementChainEntries>
<SettlementChainEntries>
<StepType>NonCashPset</Ste pType>
<Bic>MGTCBEBEECL</Bic>
<AccountNumber>47950</Acco untNumber>
<IdentifierType>
<Id>SWIFT_BIC</Id>
</IdentifierType>
</SettlementChainEntries>
<RecDel>BOTH</RecDel>
<CptyFirm>CPTY</CptyFirm>
<CountryOfSettlement/>
<SettleTypeOverride>
<Id>EE</Id>
</SettleTypeOverride>
</StandingSettlementInstru ction>
</SettlementMethod>
<AlertIndex>1</AlertIndex>
<Currency>
<IsoCode>EUR</IsoCode>
</Currency>
<DefaultSsi>true</DefaultS si>
<TermsOfDelivery>
<Id>DVP</Id>
</TermsOfDelivery>
<SettlementType>NON_CASH</ Settlement Type>
<ClassOfAccount>BOTH</Clas sOfAccount >
<SettlementChainEntries>
<StepType>NonCashPset</Ste pType>
<Bic>MOTIITMMXXX</Bic>
<AccountNumber>2808</Accou ntNumber>
<IdentifierType>
<Id>SWIFT_BIC</Id>
</IdentifierType>
</SettlementChainEntries>
<SettlementChainEntries>
<StepType>NonCashDeagReag< /StepType> ^Z
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<StandingSettlementInstruc tion xmlns="http://www.service.cdds.cs.com/ssiData_2">
<StableChangeVersion>5</St ableChange Version>
<Core>
<LocalId>0159515092</Local Id>
<EffectiveDate>2015-04-27T 00:00:00.0 00-04:00</ EffectiveD ate>
<ClosingDate>2018-07-11T18 :00:56.487 -04:00</Cl osingDate>
<DataStatus>Closed</DataSt atus>
<InternalIdentifier>000000 00-0000-00 00-0000-00 000302953a </Internal Identifier >
</Core>
<Change>
<LastApprovedVersion>5</La stApproved Version>
<LatestReviewTime>2018-07- 11T18:00:5 6.487-04:0 0</LatestR eviewTime>
</Change>
<SystemCodes>
<SystemCodeType>
<Id>NTPANY</Id>
</SystemCodeType>
<Value>2YVED0</Value>
<ValueStatus>Active</Value Status>
</SystemCodes>
<SystemCodes>
<SystemCodeType>
<Id>NTPA</Id>
</SystemCodeType>
<Value>YXWZS0</Value>
<ValueStatus>Active</Value Status>
</SystemCodes>
<LatestReviewers>
<userName>AlertDownloader< /userName>
</LatestReviewers>
<TradingAccount>
<Core>
<LocalId>0159514367</Local Id>
</Core>
<SystemCodes>
<SystemCodeType>
<Id>TradingAccountGSID</Id >
</SystemCodeType>
<Value>4770729</Value>
<ValueStatus>Active</Value Status>
</SystemCodes>
<SystemCodes>
<SystemCodeType>
<Id>NTPANY</Id>
</SystemCodeType>
<Value>2YVED0</Value>
<ValueStatus>Active</Value Status>
</SystemCodes>
<SystemCodes>
<SystemCodeType>
<Id>NTPA</Id>
</SystemCodeType>
<Value>YXWZS0</Value>
<ValueStatus>Active</Value Status>
</SystemCodes>
</TradingAccount>
<Country>
<IsoCode>MX</IsoCode>
</Country>
<Security>
<Id>EQU</Id>
</Security>
<SettlementMethod>
<Id>INDEVAL</Id>
</SettlementMethod>
<AlertIndex>1</AlertIndex>
<Currency>
<IsoCode>MXN</IsoCode>
</Currency>
<DefaultSsi>true</DefaultS si>
<TermsOfDelivery>
<Id>DVP</Id>
</TermsOfDelivery>
<SettlementType>NON_CASH</ Settlement Type>
<ClassOfAccount>BOTH</Clas sOfAccount >
<SettlementChainEntries>
<StepType>NonCashPset</Ste pType>
<Bic>INDEMXMMXXX</Bic>
<IdentifierType>
<Id>SWIFT_BIC</Id>
</IdentifierType>
</SettlementChainEntries>
<SettlementChainEntries>
<StepType>NonCashDeagReag< /StepType>
<SettlementAgentName>CITIB ANK, MEXICO</SettlementAgentNam e>
<Bic>CITIUS33MER</Bic>
<AccountNumber>229347</Acc ountNumber >
<IdentifierType>
<Id>SWIFT_BIC</Id>
</IdentifierType>
</SettlementChainEntries>
<SettlementChainEntries>
<StepType>NonCashDecuRecu< /StepType>
<SettlementAgentName>STATE STREET BANK AND TRUST COMPANY</SettlementAgentNa me>
<Bic>SBOSUS3CXXX</Bic>
<IdentifierType>
<Id>SWIFT_BIC</Id>
</IdentifierType>
</SettlementChainEntries>
<RecDel>BOTH</RecDel>
<CptyFirm>CPTY</CptyFirm>
</StandingSettlementInstru ction>
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<StandingSettlementInstruc tion xmlns="http://www.service.cdds.cs.com/ssiData_2">
<StableChangeVersion>2</St ableChange Version>
<Core>
<LocalId>0164568752</Local Id>
<EffectiveDate>2013-05-31T 00:00:00.0 00-04:00</ EffectiveD ate>
<ClosingDate>2018-07-11T18 :01:04.183 -04:00</Cl osingDate>
<DataStatus>Closed</DataSt atus>
<InternalIdentifier>000000 00-0000-00 00-0000-00 00041af159 </Internal Identifier >
</Core>
<Change>
<LastApprovedVersion>2</La stApproved Version>
<LatestReviewTime>2018-07- 11T18:01:0 4.183-04:0 0</LatestR eviewTime>
</Change>
<LatestReviewers>
<userName>AlertDownloader< /userName>
</LatestReviewers>
<TradingAccount>
<Core>
<LocalId>0159514369</Local Id>
</Core>
<SystemCodes>
<SystemCodeType>
<Id>TradingAccountGSID</Id >
</SystemCodeType>
<Value>4770730</Value>
<ValueStatus>Active</Value Status>
</SystemCodes>
<SystemCodes>
<SystemCodeType>
<Id>NTPANY</Id>
</SystemCodeType>
<Value>2YVEE0</Value>
<ValueStatus>Active</Value Status>
</SystemCodes>
<SystemCodes>
<SystemCodeType>
<Id>NTPA</Id>
</SystemCodeType>
<Value>YXWZU0</Value>
<ValueStatus>Active</Value Status>
</SystemCodes>
</TradingAccount>
<Country>
<IsoCode>AU</IsoCode>
</Country>
<Security>
<Id>FX</Id>
</Security>
<SettlementMethod>
<Id>CASH</Id>
</SettlementMethod>
<AlertIndex>1</AlertIndex>
<Currency>
<IsoCode>AUD</IsoCode>
</Currency>
<DefaultSsi>true</DefaultS si>
<TermsOfDelivery>
<Id>FOP</Id>
</TermsOfDelivery>
<SettlementType>CASH</Sett lementType >
<ClassOfAccount>NOSTRO</Cl assOfAccou nt>
<SettlementChainEntries>
<StepType>CashBeneficiary< /StepType>
<SettlementAgentName>MSFIB </Settleme ntAgentNam e>
<IdentifierType>
<Id>FREE_FORMAT</Id>
</IdentifierType>
</SettlementChainEntries>
<SettlementChainEntries>
<StepType>CashLocalAgent</ StepType>
<SettlementAgentName>STATE STREET BANK AND TRUST COMPANY</SettlementAgentNa me>
<SettlementAgentName2>, SYDNEY BRANCH</SettlementAgentNam e2>
<Bic>SBOSAU2XXXX</Bic>
<AccountNumber>BOSTAUD01</ AccountNum ber>
<SubAccountNumber>AU913001 </SubAccou ntNumber>
<AssociatedBankCodeType>OT HER</Assoc iatedBankC odeType>
<IdentifierType>
<Id>SWIFT_BIC</Id>
</IdentifierType>
</SettlementChainEntries>
<SettlementChainEntries>
<StepType>CashCustodian</S tepType>
<SettlementAgentName>STATE STREET BANK AND TRUST CO.</SettlementAgentName>
<Bic>SBOSUS3FXXX</Bic>
<AccountNumber>5BB3</Accou ntNumber>
<IdentifierType>
<Id>SWIFT_BIC</Id>
</IdentifierType>
</SettlementChainEntries>
<InstructionEventType>
<Id>NC</Id>
</InstructionEventType>
<RecDel>BOTH</RecDel>
<CptyFirm>CPTY</CptyFirm>
<MTO>true</MTO>
</StandingSettlementInstru ction>
</SettlementMethod>
<AlertIndex>1</AlertIndex>
<Currency>
<IsoCode>EUR</IsoCode>
</Currency>
<DefaultSsi>true</DefaultS si>
<TermsOfDelivery>
<Id>DVP</Id>
</TermsOfDelivery>
<SettlementType>NON_CASH</ Settlement Type>
<ClassOfAccount>BOTH</Clas sOfAccount >
<SettlementChainEntries>
<StepType>NonCashPset</Ste pType>
<Bic>MOTIITMMXXX</Bic>
<AccountNumber>2808</Accou ntNumber>
<IdentifierType>
<Id>SWIFT_BIC</Id>
</IdentifierType>
</SettlementChainEntries>
<SettlementChainEntries>
<StepType>NonCashDeagReag< /StepType>
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<StandingSettlementInstruc tion xmlns="http://www.service.cdds.cs.com/ssiData_2">
<StableChangeVersion>5</St ableChange Version>
<Core>
<LocalId>0159515083</Local Id>
<EffectiveDate>2016-09-11T 00:00:00.0 00-04:00</ EffectiveD ate>
<ClosingDate>2018-07-11T18 :00:54.092 -04:00</Cl osingDate>
<DataStatus>Closed</DataSt atus>
<InternalIdentifier>000000 00-0000-00 00-0000-00 0003029531 </Internal Identifier >
</Core>
<Change>
<LastApprovedVersion>5</La stApproved Version>
<LatestReviewTime>2018-07- 11T18:00:5 4.092-04:0 0</LatestR eviewTime>
</Change>
<SystemCodes>
<SystemCodeType>
<Id>NTPANY</Id>
</SystemCodeType>
<Value>2YVED0</Value>
<ValueStatus>Active</Value Status>
</SystemCodes>
<SystemCodes>
<SystemCodeType>
<Id>NTPA</Id>
</SystemCodeType>
<Value>YXWZS0</Value>
<ValueStatus>Active</Value Status>
</SystemCodes>
<LatestReviewers>
<userName>AlertDownloader< /userName>
</LatestReviewers>
<TradingAccount>
<Core>
<LocalId>0159514367</Local Id>
</Core>
<SystemCodes>
<SystemCodeType>
<Id>TradingAccountGSID</Id >
</SystemCodeType>
<Value>4770729</Value>
<ValueStatus>Active</Value Status>
</SystemCodes>
<SystemCodes>
<SystemCodeType>
<Id>NTPANY</Id>
</SystemCodeType>
<Value>2YVED0</Value>
<ValueStatus>Active</Value Status>
</SystemCodes>
<SystemCodes>
<SystemCodeType>
<Id>NTPA</Id>
</SystemCodeType>
<Value>YXWZS0</Value>
<ValueStatus>Active</Value Status>
</SystemCodes>
</TradingAccount>
<Country>
<IsoCode>DK</IsoCode>
</Country>
<Security>
<Id>EQU</Id>
</Security>
<SettlementMethod>
<Id>VP</Id>
</SettlementMethod>
<AlertIndex>1</AlertIndex>
<Currency>
<IsoCode>DKK</IsoCode>
</Currency>
<DefaultSsi>true</DefaultS si>
<TermsOfDelivery>
<Id>DVP</Id>
</TermsOfDelivery>
<SettlementType>NON_CASH</ Settlement Type>
<ClassOfAccount>BOTH</Clas sOfAccount >
<SettlementChainEntries>
<StepType>NonCashPset</Ste pType>
<Bic>VPDKDKKKXXX</Bic>
<AccountNumber>05295</Acco untNumber>
<IdentifierType>
<Id>SWIFT_BIC</Id>
</IdentifierType>
</SettlementChainEntries>
<SettlementChainEntries>
<StepType>NonCashDeagReag< /StepType>
<SettlementAgentName>SKAND INAVISKA ENSKILDA BANKEN</SettlementAgentNam e>
<Bic>ESSEDKKKXXX</Bic>
<AccountNumber>5295061911< /AccountNu mber>
<IdentifierType>
<Id>SWIFT_BIC</Id>
</IdentifierType>
</SettlementChainEntries>
<SettlementChainEntries>
<StepType>NonCashDecuRecu< /StepType>
<SettlementAgentName>STATE STREET BANK AND TRUST COMPANY</SettlementAgentNa me>
<Bic>SBOSUS3CXXX</Bic>
<IdentifierType>
<Id>SWIFT_BIC</Id>
</IdentifierType>
</SettlementChainEntries>
<RecDel>BOTH</RecDel>
<CptyFirm>CPTY</CptyFirm>
</StandingSettlementInstru ction>
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<StandingSettlementInstruc tion xmlns="http://www.service.cdds.cs.com/ssiData_2">
<StableChangeVersion>5</St ableChange Version>
<Core>
<LocalId>0159515092</Local Id>
<EffectiveDate>2015-04-27T 00:00:00.0 00-04:00</ EffectiveD ate>
<ClosingDate>2018-07-11T18 :00:56.487 -04:00</Cl osingDate>
<DataStatus>Closed</DataSt atus>
<InternalIdentifier>000000 00-0000-00 00-0000-00 000302953a </Internal Identifier >
</Core>
<Change>
<LastApprovedVersion>5</La stApproved Version>
<LatestReviewTime>2018-07- 11T18:00:5 6.487-04:0 0</LatestR eviewTime>
</Change>
<SystemCodes>
<SystemCodeType>
<Id>NTPANY</Id>
</SystemCodeType>
<Value>2YVED0</Value>
<ValueStatus>Active</Value Status>
</SystemCodes>
<SystemCodes>
<SystemCodeType>
<Id>NTPA</Id>
</SystemCodeType>
<Value>YXWZS0</Value>
<ValueStatus>Active</Value Status>
</SystemCodes>
<LatestReviewers>
<userName>AlertDownloader< /userName>
</LatestReviewers>
<TradingAccount>
<Core>
<LocalId>0159514367</Local Id>
</Core>
<SystemCodes>
<SystemCodeType>
<Id>TradingAccountGSID</Id >
</SystemCodeType>
<Value>4770729</Value>
<ValueStatus>Active</Value Status>
</SystemCodes>
<SystemCodes>
<SystemCodeType>
<Id>NTPANY</Id>
</SystemCodeType>
<Value>2YVED0</Value>
<ValueStatus>Active</Value Status>
</SystemCodes>
<SystemCodes>
<SystemCodeType>
<Id>NTPA</Id>
</SystemCodeType>
<Value>YXWZS0</Value>
<ValueStatus>Active</Value Status>
</SystemCodes>
</TradingAccount>
<Country>
<IsoCode>MX</IsoCode>
</Country>
<Security>
<Id>EQU</Id>
</Security>
<SettlementMethod>
<Id>INDEVAL</Id>
</SettlementMethod>
<AlertIndex>1</AlertIndex>
<Currency>
<IsoCode>MXN</IsoCode>
</Currency>
<DefaultSsi>true</DefaultS si>
<TermsOfDelivery>
<Id>DVP</Id>
</TermsOfDelivery>
<SettlementType>NON_CASH</ Settlement Type>
<ClassOfAccount>BOTH</Clas sOfAccount >
<SettlementChainEntries>
<StepType>NonCashPset</Ste pType>
<Bic>INDEMXMMXXX</Bic>
<IdentifierType>
<Id>SWIFT_BIC</Id>
</IdentifierType>
</SettlementChainEntries>
<SettlementChainEntries>
<StepType>NonCashDeagReag< /StepType>
<SettlementAgentName>CITIB ANK, MEXICO</SettlementAgentNam e>
<Bic>CITIUS33MER</Bic>
<AccountNumber>229347</Acc ountNumber >
<IdentifierType>
<Id>SWIFT_BIC</Id>
</IdentifierType>
</SettlementChainEntries>
<SettlementChainEntries>
<StepType>NonCashDecuRecu< /StepType>
<SettlementAgentName>STATE STREET BANK AND TRUST COMPANY</SettlementAgentNa me>
<Bic>SBOSUS3CXXX</Bic>
<IdentifierType>
<Id>SWIFT_BIC</Id>
</IdentifierType>
</SettlementChainEntries>
<RecDel>BOTH</RecDel>
<CptyFirm>CPTY</CptyFirm>
</StandingSettlementInstru ction>
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<StandingSettlementInstruc tion xmlns="http://www.service.cdds.cs.com/ssiData_2">
<StableChangeVersion>2</St ableChange Version>
<Core>
<LocalId>0164568752</Local Id>
<EffectiveDate>2013-05-31T 00:00:00.0 00-04:00</ EffectiveD ate>
<ClosingDate>2018-07-11T18 :01:04.183 -04:00</Cl osingDate>
<DataStatus>Closed</DataSt atus>
<InternalIdentifier>000000 00-0000-00 00-0000-00 00041af159 </Internal Identifier >
</Core>
<Change>
<LastApprovedVersion>2</La stApproved Version>
<LatestReviewTime>2018-07- 11T18:01:0 4.183-04:0 0</LatestR eviewTime>
</Change>
<LatestReviewers>
<userName>AlertDownloader< /userName>
</LatestReviewers>
<TradingAccount>
<Core>
<LocalId>0159514369</Local Id>
</Core>
<SystemCodes>
<SystemCodeType>
<Id>TradingAccountGSID</Id >
</SystemCodeType>
<Value>4770730</Value>
<ValueStatus>Active</Value Status>
</SystemCodes>
<SystemCodes>
<SystemCodeType>
<Id>NTPANY</Id>
</SystemCodeType>
<Value>2YVEE0</Value>
<ValueStatus>Active</Value Status>
</SystemCodes>
<SystemCodes>
<SystemCodeType>
<Id>NTPA</Id>
</SystemCodeType>
<Value>YXWZU0</Value>
<ValueStatus>Active</Value Status>
</SystemCodes>
</TradingAccount>
<Country>
<IsoCode>AU</IsoCode>
</Country>
<Security>
<Id>FX</Id>
</Security>
<SettlementMethod>
<Id>CASH</Id>
</SettlementMethod>
<AlertIndex>1</AlertIndex>
<Currency>
<IsoCode>AUD</IsoCode>
</Currency>
<DefaultSsi>true</DefaultS si>
<TermsOfDelivery>
<Id>FOP</Id>
</TermsOfDelivery>
<SettlementType>CASH</Sett lementType >
<ClassOfAccount>NOSTRO</Cl assOfAccou nt>
<SettlementChainEntries>
<StepType>CashBeneficiary< /StepType>
<SettlementAgentName>MSFIB </Settleme ntAgentNam e>
<IdentifierType>
<Id>FREE_FORMAT</Id>
</IdentifierType>
</SettlementChainEntries>
<SettlementChainEntries>
<StepType>CashLocalAgent</ StepType>
<SettlementAgentName>STATE STREET BANK AND TRUST COMPANY</SettlementAgentNa me>
<SettlementAgentName2>, SYDNEY BRANCH</SettlementAgentNam e2>
<Bic>SBOSAU2XXXX</Bic>
<AccountNumber>BOSTAUD01</ AccountNum ber>
<SubAccountNumber>AU913001 </SubAccou ntNumber>
<AssociatedBankCodeType>OT HER</Assoc iatedBankC odeType>
<IdentifierType>
<Id>SWIFT_BIC</Id>
</IdentifierType>
</SettlementChainEntries>
<SettlementChainEntries>
<StepType>CashCustodian</S tepType>
<SettlementAgentName>STATE STREET BANK AND TRUST CO.</SettlementAgentName>
<Bic>SBOSUS3FXXX</Bic>
<AccountNumber>5BB3</Accou ntNumber>
<IdentifierType>
<Id>SWIFT_BIC</Id>
</IdentifierType>
</SettlementChainEntries>
<InstructionEventType>
<Id>NC</Id>
</InstructionEventType>
<RecDel>BOTH</RecDel>
<CptyFirm>CPTY</CptyFirm>
<MTO>true</MTO>
</StandingSettlementInstru ction>
SSI_sample.txt
I have multiple XML files I have to covert the XML data into CSV file and to generate the into CSV output file.
Could you please help me in this.
Many thanks for reply.
sample file :-
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<StandingSettlementInstruc
<StableChangeVersion>2</St
<Core>
<LocalId>0171375670</Local
<EffectiveDate>2018-06-24T
<DataStatus>Active</DataSt
<InternalIdentifier>000000
</Core>
<Change>
<LastApprovedVersion>2</La
<LatestReviewTime>2018-06-
</Change>
<SystemCodes>
<SystemCodeType>
<Id>NTPA</Id>
</SystemCodeType>
<Value>Y37F40</Value>
<ValueStatus>Active</Value
</SystemCodes>
<LatestReviewers>
<userName>msiepra</userNam
</LatestReviewers>
<TradingAccount>
<Core>
<LocalId>0170485038</Local
</Core>
<SystemCodes>
<SystemCodeType>
<Id>TradingAccountGSID</Id
</SystemCodeType>
<Value>4973662</Value>
<ValueStatus>Active</Value
</SystemCodes>
<SystemCodes>
<SystemCodeType>
<Id>NTPA</Id>
</SystemCodeType>
<Value>Y37F40</Value>
<ValueStatus>Active</Value
</SystemCodes>
<SystemCodes>
<SystemCodeType>
<Id>FXOPs</Id>
</SystemCodeType>
<Value>L61774</Value>
<ValueStatus>Active</Value
</SystemCodes>
<SystemCodes>
<SystemCodeType>
<Id>SDSFB</Id>
</SystemCodeType>
<Value>MARSH38LONGB</Value
<ValueStatus>Active</Value
</SystemCodes>
</TradingAccount>
<Country>
<IsoCode>DE</IsoCode>
</Country>
<Security>
<Id>COB</Id>
</Security>
<SettlementMethod>
<Id>EURO_CLEAR</Id>
</SettlementMethod>
<Currency>
<IsoCode>EUR</IsoCode>
</Currency>
<DefaultSsi>true</DefaultS
<TermsOfDelivery>
<Id>FOP</Id>
</TermsOfDelivery>
<SettlementType>NON_CASH</
<ClassOfAccount>BOTH</Clas
<SettlementChainEntries>
<StepType>NonCashDeagReag<
<IdentifierType>
<Id>SWIFT_BIC</Id>
</IdentifierType>
</SettlementChainEntries>
<SettlementChainEntries>
<StepType>NonCashDecuRecu<
<IdentifierType>
<Id>SWIFT_BIC</Id>
</IdentifierType>
</SettlementChainEntries>
<SettlementChainEntries>
<StepType>NonCashPset</Ste
<Bic>MGTCBEBEECL</Bic>
<AccountNumber>47950</Acco
<IdentifierType>
<Id>SWIFT_BIC</Id>
</IdentifierType>
</SettlementChainEntries>
<RecDel>BOTH</RecDel>
<CptyFirm>CPTY</CptyFirm>
<CountryOfSettlement/>
<SettleTypeOverride>
<Id>EE</Id>
</SettleTypeOverride>
</StandingSettlementInstru
</SettlementMethod>
<AlertIndex>1</AlertIndex>
<Currency>
<IsoCode>EUR</IsoCode>
</Currency>
<DefaultSsi>true</DefaultS
<TermsOfDelivery>
<Id>DVP</Id>
</TermsOfDelivery>
<SettlementType>NON_CASH</
<ClassOfAccount>BOTH</Clas
<SettlementChainEntries>
<StepType>NonCashPset</Ste
<Bic>MOTIITMMXXX</Bic>
<AccountNumber>2808</Accou
<IdentifierType>
<Id>SWIFT_BIC</Id>
</IdentifierType>
</SettlementChainEntries>
<SettlementChainEntries>
<StepType>NonCashDeagReag<
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<StandingSettlementInstruc
<StableChangeVersion>5</St
<Core>
<LocalId>0159515092</Local
<EffectiveDate>2015-04-27T
<ClosingDate>2018-07-11T18
<DataStatus>Closed</DataSt
<InternalIdentifier>000000
</Core>
<Change>
<LastApprovedVersion>5</La
<LatestReviewTime>2018-07-
</Change>
<SystemCodes>
<SystemCodeType>
<Id>NTPANY</Id>
</SystemCodeType>
<Value>2YVED0</Value>
<ValueStatus>Active</Value
</SystemCodes>
<SystemCodes>
<SystemCodeType>
<Id>NTPA</Id>
</SystemCodeType>
<Value>YXWZS0</Value>
<ValueStatus>Active</Value
</SystemCodes>
<LatestReviewers>
<userName>AlertDownloader<
</LatestReviewers>
<TradingAccount>
<Core>
<LocalId>0159514367</Local
</Core>
<SystemCodes>
<SystemCodeType>
<Id>TradingAccountGSID</Id
</SystemCodeType>
<Value>4770729</Value>
<ValueStatus>Active</Value
</SystemCodes>
<SystemCodes>
<SystemCodeType>
<Id>NTPANY</Id>
</SystemCodeType>
<Value>2YVED0</Value>
<ValueStatus>Active</Value
</SystemCodes>
<SystemCodes>
<SystemCodeType>
<Id>NTPA</Id>
</SystemCodeType>
<Value>YXWZS0</Value>
<ValueStatus>Active</Value
</SystemCodes>
</TradingAccount>
<Country>
<IsoCode>MX</IsoCode>
</Country>
<Security>
<Id>EQU</Id>
</Security>
<SettlementMethod>
<Id>INDEVAL</Id>
</SettlementMethod>
<AlertIndex>1</AlertIndex>
<Currency>
<IsoCode>MXN</IsoCode>
</Currency>
<DefaultSsi>true</DefaultS
<TermsOfDelivery>
<Id>DVP</Id>
</TermsOfDelivery>
<SettlementType>NON_CASH</
<ClassOfAccount>BOTH</Clas
<SettlementChainEntries>
<StepType>NonCashPset</Ste
<Bic>INDEMXMMXXX</Bic>
<IdentifierType>
<Id>SWIFT_BIC</Id>
</IdentifierType>
</SettlementChainEntries>
<SettlementChainEntries>
<StepType>NonCashDeagReag<
<SettlementAgentName>CITIB
<Bic>CITIUS33MER</Bic>
<AccountNumber>229347</Acc
<IdentifierType>
<Id>SWIFT_BIC</Id>
</IdentifierType>
</SettlementChainEntries>
<SettlementChainEntries>
<StepType>NonCashDecuRecu<
<SettlementAgentName>STATE
<Bic>SBOSUS3CXXX</Bic>
<IdentifierType>
<Id>SWIFT_BIC</Id>
</IdentifierType>
</SettlementChainEntries>
<RecDel>BOTH</RecDel>
<CptyFirm>CPTY</CptyFirm>
</StandingSettlementInstru
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<StandingSettlementInstruc
<StableChangeVersion>2</St
<Core>
<LocalId>0164568752</Local
<EffectiveDate>2013-05-31T
<ClosingDate>2018-07-11T18
<DataStatus>Closed</DataSt
<InternalIdentifier>000000
</Core>
<Change>
<LastApprovedVersion>2</La
<LatestReviewTime>2018-07-
</Change>
<LatestReviewers>
<userName>AlertDownloader<
</LatestReviewers>
<TradingAccount>
<Core>
<LocalId>0159514369</Local
</Core>
<SystemCodes>
<SystemCodeType>
<Id>TradingAccountGSID</Id
</SystemCodeType>
<Value>4770730</Value>
<ValueStatus>Active</Value
</SystemCodes>
<SystemCodes>
<SystemCodeType>
<Id>NTPANY</Id>
</SystemCodeType>
<Value>2YVEE0</Value>
<ValueStatus>Active</Value
</SystemCodes>
<SystemCodes>
<SystemCodeType>
<Id>NTPA</Id>
</SystemCodeType>
<Value>YXWZU0</Value>
<ValueStatus>Active</Value
</SystemCodes>
</TradingAccount>
<Country>
<IsoCode>AU</IsoCode>
</Country>
<Security>
<Id>FX</Id>
</Security>
<SettlementMethod>
<Id>CASH</Id>
</SettlementMethod>
<AlertIndex>1</AlertIndex>
<Currency>
<IsoCode>AUD</IsoCode>
</Currency>
<DefaultSsi>true</DefaultS
<TermsOfDelivery>
<Id>FOP</Id>
</TermsOfDelivery>
<SettlementType>CASH</Sett
<ClassOfAccount>NOSTRO</Cl
<SettlementChainEntries>
<StepType>CashBeneficiary<
<SettlementAgentName>MSFIB
<IdentifierType>
<Id>FREE_FORMAT</Id>
</IdentifierType>
</SettlementChainEntries>
<SettlementChainEntries>
<StepType>CashLocalAgent</
<SettlementAgentName>STATE
<SettlementAgentName2>, SYDNEY BRANCH</SettlementAgentNam
<Bic>SBOSAU2XXXX</Bic>
<AccountNumber>BOSTAUD01</
<SubAccountNumber>AU913001
<AssociatedBankCodeType>OT
<IdentifierType>
<Id>SWIFT_BIC</Id>
</IdentifierType>
</SettlementChainEntries>
<SettlementChainEntries>
<StepType>CashCustodian</S
<SettlementAgentName>STATE
<Bic>SBOSUS3FXXX</Bic>
<AccountNumber>5BB3</Accou
<IdentifierType>
<Id>SWIFT_BIC</Id>
</IdentifierType>
</SettlementChainEntries>
<InstructionEventType>
<Id>NC</Id>
</InstructionEventType>
<RecDel>BOTH</RecDel>
<CptyFirm>CPTY</CptyFirm>
<MTO>true</MTO>
</StandingSettlementInstru
</SettlementMethod>
<AlertIndex>1</AlertIndex>
<Currency>
<IsoCode>EUR</IsoCode>
</Currency>
<DefaultSsi>true</DefaultS
<TermsOfDelivery>
<Id>DVP</Id>
</TermsOfDelivery>
<SettlementType>NON_CASH</
<ClassOfAccount>BOTH</Clas
<SettlementChainEntries>
<StepType>NonCashPset</Ste
<Bic>MOTIITMMXXX</Bic>
<AccountNumber>2808</Accou
<IdentifierType>
<Id>SWIFT_BIC</Id>
</IdentifierType>
</SettlementChainEntries>
<SettlementChainEntries>
<StepType>NonCashDeagReag<
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<StandingSettlementInstruc
<StableChangeVersion>5</St
<Core>
<LocalId>0159515083</Local
<EffectiveDate>2016-09-11T
<ClosingDate>2018-07-11T18
<DataStatus>Closed</DataSt
<InternalIdentifier>000000
</Core>
<Change>
<LastApprovedVersion>5</La
<LatestReviewTime>2018-07-
</Change>
<SystemCodes>
<SystemCodeType>
<Id>NTPANY</Id>
</SystemCodeType>
<Value>2YVED0</Value>
<ValueStatus>Active</Value
</SystemCodes>
<SystemCodes>
<SystemCodeType>
<Id>NTPA</Id>
</SystemCodeType>
<Value>YXWZS0</Value>
<ValueStatus>Active</Value
</SystemCodes>
<LatestReviewers>
<userName>AlertDownloader<
</LatestReviewers>
<TradingAccount>
<Core>
<LocalId>0159514367</Local
</Core>
<SystemCodes>
<SystemCodeType>
<Id>TradingAccountGSID</Id
</SystemCodeType>
<Value>4770729</Value>
<ValueStatus>Active</Value
</SystemCodes>
<SystemCodes>
<SystemCodeType>
<Id>NTPANY</Id>
</SystemCodeType>
<Value>2YVED0</Value>
<ValueStatus>Active</Value
</SystemCodes>
<SystemCodes>
<SystemCodeType>
<Id>NTPA</Id>
</SystemCodeType>
<Value>YXWZS0</Value>
<ValueStatus>Active</Value
</SystemCodes>
</TradingAccount>
<Country>
<IsoCode>DK</IsoCode>
</Country>
<Security>
<Id>EQU</Id>
</Security>
<SettlementMethod>
<Id>VP</Id>
</SettlementMethod>
<AlertIndex>1</AlertIndex>
<Currency>
<IsoCode>DKK</IsoCode>
</Currency>
<DefaultSsi>true</DefaultS
<TermsOfDelivery>
<Id>DVP</Id>
</TermsOfDelivery>
<SettlementType>NON_CASH</
<ClassOfAccount>BOTH</Clas
<SettlementChainEntries>
<StepType>NonCashPset</Ste
<Bic>VPDKDKKKXXX</Bic>
<AccountNumber>05295</Acco
<IdentifierType>
<Id>SWIFT_BIC</Id>
</IdentifierType>
</SettlementChainEntries>
<SettlementChainEntries>
<StepType>NonCashDeagReag<
<SettlementAgentName>SKAND
<Bic>ESSEDKKKXXX</Bic>
<AccountNumber>5295061911<
<IdentifierType>
<Id>SWIFT_BIC</Id>
</IdentifierType>
</SettlementChainEntries>
<SettlementChainEntries>
<StepType>NonCashDecuRecu<
<SettlementAgentName>STATE
<Bic>SBOSUS3CXXX</Bic>
<IdentifierType>
<Id>SWIFT_BIC</Id>
</IdentifierType>
</SettlementChainEntries>
<RecDel>BOTH</RecDel>
<CptyFirm>CPTY</CptyFirm>
</StandingSettlementInstru
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<StandingSettlementInstruc
<StableChangeVersion>5</St
<Core>
<LocalId>0159515092</Local
<EffectiveDate>2015-04-27T
<ClosingDate>2018-07-11T18
<DataStatus>Closed</DataSt
<InternalIdentifier>000000
</Core>
<Change>
<LastApprovedVersion>5</La
<LatestReviewTime>2018-07-
</Change>
<SystemCodes>
<SystemCodeType>
<Id>NTPANY</Id>
</SystemCodeType>
<Value>2YVED0</Value>
<ValueStatus>Active</Value
</SystemCodes>
<SystemCodes>
<SystemCodeType>
<Id>NTPA</Id>
</SystemCodeType>
<Value>YXWZS0</Value>
<ValueStatus>Active</Value
</SystemCodes>
<LatestReviewers>
<userName>AlertDownloader<
</LatestReviewers>
<TradingAccount>
<Core>
<LocalId>0159514367</Local
</Core>
<SystemCodes>
<SystemCodeType>
<Id>TradingAccountGSID</Id
</SystemCodeType>
<Value>4770729</Value>
<ValueStatus>Active</Value
</SystemCodes>
<SystemCodes>
<SystemCodeType>
<Id>NTPANY</Id>
</SystemCodeType>
<Value>2YVED0</Value>
<ValueStatus>Active</Value
</SystemCodes>
<SystemCodes>
<SystemCodeType>
<Id>NTPA</Id>
</SystemCodeType>
<Value>YXWZS0</Value>
<ValueStatus>Active</Value
</SystemCodes>
</TradingAccount>
<Country>
<IsoCode>MX</IsoCode>
</Country>
<Security>
<Id>EQU</Id>
</Security>
<SettlementMethod>
<Id>INDEVAL</Id>
</SettlementMethod>
<AlertIndex>1</AlertIndex>
<Currency>
<IsoCode>MXN</IsoCode>
</Currency>
<DefaultSsi>true</DefaultS
<TermsOfDelivery>
<Id>DVP</Id>
</TermsOfDelivery>
<SettlementType>NON_CASH</
<ClassOfAccount>BOTH</Clas
<SettlementChainEntries>
<StepType>NonCashPset</Ste
<Bic>INDEMXMMXXX</Bic>
<IdentifierType>
<Id>SWIFT_BIC</Id>
</IdentifierType>
</SettlementChainEntries>
<SettlementChainEntries>
<StepType>NonCashDeagReag<
<SettlementAgentName>CITIB
<Bic>CITIUS33MER</Bic>
<AccountNumber>229347</Acc
<IdentifierType>
<Id>SWIFT_BIC</Id>
</IdentifierType>
</SettlementChainEntries>
<SettlementChainEntries>
<StepType>NonCashDecuRecu<
<SettlementAgentName>STATE
<Bic>SBOSUS3CXXX</Bic>
<IdentifierType>
<Id>SWIFT_BIC</Id>
</IdentifierType>
</SettlementChainEntries>
<RecDel>BOTH</RecDel>
<CptyFirm>CPTY</CptyFirm>
</StandingSettlementInstru
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<StandingSettlementInstruc
<StableChangeVersion>2</St
<Core>
<LocalId>0164568752</Local
<EffectiveDate>2013-05-31T
<ClosingDate>2018-07-11T18
<DataStatus>Closed</DataSt
<InternalIdentifier>000000
</Core>
<Change>
<LastApprovedVersion>2</La
<LatestReviewTime>2018-07-
</Change>
<LatestReviewers>
<userName>AlertDownloader<
</LatestReviewers>
<TradingAccount>
<Core>
<LocalId>0159514369</Local
</Core>
<SystemCodes>
<SystemCodeType>
<Id>TradingAccountGSID</Id
</SystemCodeType>
<Value>4770730</Value>
<ValueStatus>Active</Value
</SystemCodes>
<SystemCodes>
<SystemCodeType>
<Id>NTPANY</Id>
</SystemCodeType>
<Value>2YVEE0</Value>
<ValueStatus>Active</Value
</SystemCodes>
<SystemCodes>
<SystemCodeType>
<Id>NTPA</Id>
</SystemCodeType>
<Value>YXWZU0</Value>
<ValueStatus>Active</Value
</SystemCodes>
</TradingAccount>
<Country>
<IsoCode>AU</IsoCode>
</Country>
<Security>
<Id>FX</Id>
</Security>
<SettlementMethod>
<Id>CASH</Id>
</SettlementMethod>
<AlertIndex>1</AlertIndex>
<Currency>
<IsoCode>AUD</IsoCode>
</Currency>
<DefaultSsi>true</DefaultS
<TermsOfDelivery>
<Id>FOP</Id>
</TermsOfDelivery>
<SettlementType>CASH</Sett
<ClassOfAccount>NOSTRO</Cl
<SettlementChainEntries>
<StepType>CashBeneficiary<
<SettlementAgentName>MSFIB
<IdentifierType>
<Id>FREE_FORMAT</Id>
</IdentifierType>
</SettlementChainEntries>
<SettlementChainEntries>
<StepType>CashLocalAgent</
<SettlementAgentName>STATE
<SettlementAgentName2>, SYDNEY BRANCH</SettlementAgentNam
<Bic>SBOSAU2XXXX</Bic>
<AccountNumber>BOSTAUD01</
<SubAccountNumber>AU913001
<AssociatedBankCodeType>OT
<IdentifierType>
<Id>SWIFT_BIC</Id>
</IdentifierType>
</SettlementChainEntries>
<SettlementChainEntries>
<StepType>CashCustodian</S
<SettlementAgentName>STATE
<Bic>SBOSUS3FXXX</Bic>
<AccountNumber>5BB3</Accou
<IdentifierType>
<Id>SWIFT_BIC</Id>
</IdentifierType>
</SettlementChainEntries>
<InstructionEventType>
<Id>NC</Id>
</InstructionEventType>
<RecDel>BOTH</RecDel>
<CptyFirm>CPTY</CptyFirm>
<MTO>true</MTO>
</StandingSettlementInstru
SSI_sample.txt
This question needs an answer!
Become an EE member today
7 DAY FREE TRIALMembers can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Attachment is missing.