 |
| XSLT General questions and answers about XSLT. For issues strictly specific to the book XSLT 1.1 Programmers Reference, please post to that forum instead. |
Welcome to the p2p.wrox.com Forums.
You are currently viewing the XSLT section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
|
|
|
|
November 12th, 2009, 08:32 AM
|
|
Friend of Wrox
|
|
Join Date: Feb 2009
Posts: 119
Thanks: 25
Thanked 3 Times in 3 Posts
|
|
XSLT 1.0 distinct values
<xsl:for-each select="InsuranceObject/Guarantee/CounterIntermediary[not(Intermediary/IntermediaryIdentifier = preceding-sibling::CounterIntermediary/Intermediary/IntermediaryIdentifier )]">
that is the path expression I have. It doesn't quite work. I am after distinct Intermediary/IntermediaryIdentifier
Code:
<InsuranceObject>
<Guarantee>
<CounterIntermediary>
<Commission>
<CommissionAmount>55</CommissionAmount>
<CommissionTypeCode>215</CommissionTypeCode>
</Commission>
<Intermediary>
<CompanyIdentifier></CompanyIdentifier>
<PartyName></PartyName>
<PartyTypeCode>1</PartyTypeCode>
<IntermediaryIdentifier>11111</IntermediaryIdentifier>
<IntermediaryTypeCode>1</IntermediaryTypeCode>
<PrincipalIntermediaryIdentifier>11111</PrincipalIntermediaryIdentifier>
</Intermediary>
</CounterIntermediary>
<CounterIntermediary>
<Commission>
<CommissionAmount>66</CommissionAmount>
<CommissionTypeCode>215</CommissionTypeCode>
</Commission>
<Intermediary>
<CompanyIdentifier></CompanyIdentifier>
<PartyName></PartyName>
<PartyTypeCode>1</PartyTypeCode>
<IntermediaryIdentifier>33333</IntermediaryIdentifier>
<IntermediaryTypeCode>1</IntermediaryTypeCode>
<PrincipalIntermediaryIdentifier>22222</PrincipalIntermediaryIdentifier>
</Intermediary>
</CounterIntermediary>
<GuaranteeTypeCode>999</GuaranteeTypeCode>
</Guarantee>
<Guarantee>
<CounterIntermediary>
<Commission>
<CommissionAmount>77</CommissionAmount>
<CommissionTypeCode>215</CommissionTypeCode>
</Commission>
<Intermediary>
<CompanyIdentifier></CompanyIdentifier>
<PartyName></PartyName>
<PartyTypeCode>1</PartyTypeCode>
<IntermediaryIdentifier>33333</IntermediaryIdentifier>
<IntermediaryTypeCode>1</IntermediaryTypeCode>
<PrincipalIntermediaryIdentifier>33333</PrincipalIntermediaryIdentifier>
</Intermediary>
</CounterIntermediary>
<CounterIntermediary>
<Commission>
<CommissionAmount>88</CommissionAmount>
<CommissionTypeCode>215</CommissionTypeCode>
</Commission>
<Intermediary>
<CompanyIdentifier></CompanyIdentifier>
<PartyName></PartyName>
<PartyTypeCode>1</PartyTypeCode>
<IntermediaryIdentifier>44444</IntermediaryIdentifier>
<IntermediaryTypeCode>1</IntermediaryTypeCode>
<PrincipalIntermediaryIdentifier>44444</PrincipalIntermediaryIdentifier>
</Intermediary>
</CounterIntermediary>
<GuaranteeTypeCode>888</GuaranteeTypeCode>
</Guarantee>
<Guarantee>
<CounterIntermediary>
<Commission>
<CommissionAmount>123</CommissionAmount>
<CommissionTypeCode>215</CommissionTypeCode>
</Commission>
<Intermediary>
<CompanyIdentifier></CompanyIdentifier>
<PartyName></PartyName>
<PartyTypeCode>1</PartyTypeCode>
<IntermediaryIdentifier>33333</IntermediaryIdentifier>
<IntermediaryTypeCode>1</IntermediaryTypeCode>
<PrincipalIntermediaryIdentifier>33333</PrincipalIntermediaryIdentifier>
</Intermediary>
</CounterIntermediary>
<CounterIntermediary>
<Commission>
<CommissionAmount>99999999</CommissionAmount>
<CommissionTypeCode>215</CommissionTypeCode>
</Commission>
<Intermediary>
<CompanyIdentifier></CompanyIdentifier>
<PartyName></PartyName>
<PartyTypeCode>1</PartyTypeCode>
<IntermediaryIdentifier>44444</IntermediaryIdentifier>
<IntermediaryTypeCode>1</IntermediaryTypeCode>
<PrincipalIntermediaryIdentifier>44444</PrincipalIntermediaryIdentifier>
</Intermediary>
</CounterIntermediary>
<CounterIntermediary>
<Commission>
<CommissionAmount>77777777777777777777</CommissionAmount>
<CommissionTypeCode>215</CommissionTypeCode>
</Commission>
<Intermediary>
<CompanyIdentifier></CompanyIdentifier>
<PartyName></PartyName>
<PartyTypeCode>1</PartyTypeCode>
<IntermediaryIdentifier>44444</IntermediaryIdentifier>
<IntermediaryTypeCode>1</IntermediaryTypeCode>
<PrincipalIntermediaryIdentifier>44444</PrincipalIntermediaryIdentifier>
</Intermediary>
</CounterIntermediary>
<GuaranteeTypeCode>666</GuaranteeTypeCode>
</Guarantee>
<Guarantee>
<CounterIntermediary>
<Commission>
<CommissionAmount>55</CommissionAmount>
<CommissionTypeCode>215</CommissionTypeCode>
</Commission>
<Intermediary>
<CompanyIdentifier></CompanyIdentifier>
<PartyName></PartyName>
<PartyTypeCode>1</PartyTypeCode>
<IntermediaryIdentifier>77777</IntermediaryIdentifier>
<IntermediaryTypeCode>1</IntermediaryTypeCode>
<PrincipalIntermediaryIdentifier>11111</PrincipalIntermediaryIdentifier>
</Intermediary>
</CounterIntermediary>
<GuaranteeTypeCode>999</GuaranteeTypeCode>
</Guarantee>
</InsuranceObject>
|
|
November 12th, 2009, 09:12 AM
|
|
Friend of Wrox
|
|
Join Date: Feb 2009
Posts: 119
Thanks: 25
Thanked 3 Times in 3 Posts
|
|
Can someone please help me?
|
|
November 12th, 2009, 09:17 AM
|
|
Friend of Wrox
|
|
Join Date: Nov 2007
Posts: 1,243
Thanks: 0
Thanked 245 Times in 244 Posts
|
|
Your for-each will process the CounterIntermediary elements with distinct Intermediary/IntermediaryIdentifier elements. If you want to process those Intermediary/IntermediaryIdentifier instead then you can simply add
Code:
<xsl:for-each select="InsuranceObject/Guarantee/CounterIntermediary[not(Intermediary/IntermediaryIdentifier = preceding-sibling::CounterIntermediary/Intermediary/IntermediaryIdentifier )]/Intermediary/IntermediaryIdentifier">
If that does not do what you want then you might show us the output you want to create from the input sample you posted.
It might also be more efficient to use Muenchian grouping to find the distinct items.
__________________
Martin Honnen
Microsoft MVP (XML, Data Platform Development) 2005/04 - 2013/03
My blog
|
|
November 12th, 2009, 09:21 AM
|
 |
Wrox Author
|
|
Join Date: Apr 2004
Posts: 4,962
Thanks: 0
Thanked 292 Times in 287 Posts
|
|
>Can someone please help me?
For goodness sake, you posted that 40 minutes after the original message, when half the world is in bed and another half is having lunch. We're not all sitting here 24 hours a day twiddling our thumbs and waiting for people to post questions, you know.
__________________
Michael Kay
http://www.saxonica.com/
Author, XSLT 2.0 and XPath 2.0 Programmer\'s Reference
|
|
November 12th, 2009, 09:28 AM
|
|
Friend of Wrox
|
|
Join Date: Feb 2009
Posts: 119
Thanks: 25
Thanked 3 Times in 3 Posts
|
|
Hi Martin.
No that doesn't work. I wanted distinct IntermediaryIdentifier.
You just copied what I had
Thanks anyway.
|
|
November 12th, 2009, 09:47 AM
|
|
Friend of Wrox
|
|
Join Date: Nov 2007
Posts: 1,243
Thanks: 0
Thanked 245 Times in 244 Posts
|
|
No, I did not copy what you had, I added two steps. But both solutions don't work as the CounterIntermediary elements have different parents, so the preceding-sibling check does not suffice.
The following Muechnian grouping based solution should work:
Code:
<xsl:stylesheet
xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
version="1.0">
<xsl:output method="text"/>
<xsl:key name="k1" match="IntermediaryIdentifier" use="."/>
<xsl:template match="/">
<xsl:for-each select="InsuranceObject/Guarantee/CounterIntermediary/Intermediary/IntermediaryIdentifier[generate-id() = generate-id(key('k1', .)[1])]">
<xsl:value-of select="."/>
<xsl:value-of select="'
'"/>
</xsl:for-each>
</xsl:template>
</xsl:stylesheet>
Output for your sample XML is
11111
33333
44444
77777
__________________
Martin Honnen
Microsoft MVP (XML, Data Platform Development) 2005/04 - 2013/03
My blog
|
|
November 12th, 2009, 09:51 AM
|
|
Friend of Wrox
|
|
Join Date: Nov 2007
Posts: 1,243
Thanks: 0
Thanked 245 Times in 244 Posts
|
|
If you want to do it without Muenchian grouping then one way is
Code:
<xsl:template match="/">
<xsl:for-each select="InsuranceObject/Guarantee/CounterIntermediary/Intermediary/IntermediaryIdentifier[not(. = preceding::IntermediaryIdentifier)]">
<xsl:value-of select="."/>
<xsl:value-of select="'
'"/>
</xsl:for-each>
</xsl:template>
__________________
Martin Honnen
Microsoft MVP (XML, Data Platform Development) 2005/04 - 2013/03
My blog
|
|
November 12th, 2009, 10:23 AM
|
|
Friend of Wrox
|
|
Join Date: Feb 2009
Posts: 119
Thanks: 25
Thanked 3 Times in 3 Posts
|
|
Hi Martin,
I have to work with xml in this form and the simplistic example i gave you doesn't work. there can be multiple premiumnotification/insurance objects in the document, one for each Invoice/contract. And the <IntermediaryIdentifier>33333</IntermediaryIdentifier> has to be distinct for each contract
I tried doing it my own way but the following doesn't get picked up
<xsl:for-each select="//ns6:InvoiceSave">
Code:
<xsl:for-each select="msxsl:node-set($newids)/newids/newid">
<xsl:variable name="currentid" select="."></xsl:variable>
<W_PRET112_TAB_TEGENPROD>
<W_PRET112_TEGENPROD><xsl:value-of select="."/></W_PRET112_TEGENPROD>
<W_PRET112_TAB_TP>
<xsl:for-each select="//ns6:InvoiceSave">
<W_PRET112_TAB_TP>
<W_PRET112_TP_KODE_WB><xsl:value-of select="GuaranteeTypeCode"/></W_PRET112_TP_KODE_WB>
<W_PRET112_TP_KOMISSIE><xsl:value-of select="Commission/CommissionAmount"/></W_PRET112_TP_KOMISSIE>
</W_PRET112_TAB_TP>
</xsl:for-each>
</W_PRET112_TAB_TP>
</W_PRET112_TAB_TEGENPROD>
</xsl:for-each>
Code:
<?xml version="1.0" encoding="UTF-8"?>
<ns6:InvoiceSave xmlns:ns1="http://cdm.mercator.be/types/basetypes/insuranceobject/1.0"
xmlns:ns2="http://cdm.mercator.be/types/basetypes/contract/1.0"
xmlns:ns3="http://cdm.mercator.be/types/party/1.0"
xmlns:ns4="http://cdm.mercator.be/types/basetypes/technicalaccounting/1.0"
xmlns:ns5="http://cdm.mercator.be/types/technicalaccounting/1.0"
xmlns:ns6="http://technicalaccounting.mercator.be/1.0"
xmlns:ns7="http://cdm.mercator.be/types/insuranceobject/1.0"
xmlns:ns8="http://cdm.mercator.be/types/contract/1.0"
xmlns:ns9="http://cdm.mercator.be/types/basetypes/party/1.0"
xmlns:ns10="http://cdm.mercator.be/types/basetypes/general/1.0"
xmlns:ns11="http://Mercator.Esb.Schema"
xmlns:ns12="http://cdm.mercator.be/types/general/1.0"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://technicalaccounting.mercator.be/1.0 file:/C:/Users/Beastmaster/Documents/WP213%20Batch.TechnicalAccounting.Invoice.Save/3%20CDM/Mercator.Esb.Async.TechnicalAccounting.Invoice.Batch.Save.Messaging.TechnicalAccounting_Invoice_Save_Esb.xsd">
<Invoice>
<Contract>
<CompanyIdentifier>Compa</CompanyIdentifier>
<ContractAsIntermediated>
<BrokerPolicyIndentifier>BrokerPolicyInd</BrokerPolicyIndentifier>
<Intermediary>
<Account>
<AccountTypeCode>01</AccountTypeCode>
<BankAccountNumberChoice>
<DomiciliationNumber>000000000000</DomiciliationNumber>
</BankAccountNumberChoice>
</Account>
<Account>
<AccountTypeCode>01</AccountTypeCode>
<BankAccountNumberChoice>
<FinancialAccountIdentifier>BE00000000000000</FinancialAccountIdentifier>
</BankAccountNumberChoice>
</Account>
<Address>
<AddresseeName>John Bampton</AddresseeName>
<AddressTypeCode>01</AddressTypeCode>
<PhysicalAddress>
<BoxNumberIdentifier>11</BoxNumberIdentifier>
<CityName>Brisbane</CityName>
<CountryCode>AD</CountryCode>
<HouseNumberIdentifier></HouseNumberIdentifier>
<PostalCodeChoice>
<PostalCode>4010</PostalCode>
</PostalCodeChoice>
<StreetName>Toorak</StreetName>
</PhysicalAddress>
</Address>
<Address>
<AddressTypeCode>01</AddressTypeCode>
</Address>
<CommentLine>CommentLine0</CommentLine>
<CommunicationLanguageCode>DEU</CommunicationLanguageCode>
<CompanyIdentifier>Compa</CompanyIdentifier>
<ContactInformation>
</ContactInformation>
<EmployeeRelationCode>P</EmployeeRelationCode>
<IdentificationDocument>
<DocumentIdentifier>DocumentIdentifier0</DocumentIdentifier>
<DocumentTypeCode>3</DocumentTypeCode>
</IdentificationDocument>
<IdentificationDocument>
<DocumentIdentifier>DocumentIdentifier1</DocumentIdentifier>
<DocumentTypeCode>3</DocumentTypeCode>
</IdentificationDocument>
<LanguageCode>DEU</LanguageCode>
<LastModificationDate>2006-05-04T18:13:51.0Z</LastModificationDate>
<LegalPerson>
</LegalPerson>
<PartyName>PartyName0</PartyName>
<PartyRelation>
<PartyRelationCode>B</PartyRelationCode>
<PartyRelationIdentifier>0</PartyRelationIdentifier>
</PartyRelation>
<PartyRelation>
<PartyRelationCode>B</PartyRelationCode>
<PartyRelationIdentifier>0</PartyRelationIdentifier>
</PartyRelation>
<PartyTypeCode>0</PartyTypeCode>
<PhysicalPerson>
</PhysicalPerson>
<ArrondissementCode>000</ArrondissementCode>
<Authorization>2</Authorization>
<CollectionProcessProductGroup>
<CollectionMethodCode>01</CollectionMethodCode>
<CollectionProcessTypeCode>1</CollectionProcessTypeCode>
</CollectionProcessProductGroup>
<CollectionProcessProductGroup>
<CollectionMethodCode>01</CollectionMethodCode>
<CollectionProcessTypeCode>1</CollectionProcessTypeCode>
</CollectionProcessProductGroup>
<CorrespondenceCode>1</CorrespondenceCode>
<DamagesPaymentMethodCode>1</DamagesPaymentMethodCode>
<HandlingGreenCardCode>1</HandlingGreenCardCode>
<HandlingTerminalFamilyCode>1</HandlingTerminalFamilyCode>
<HandlingVignetCode>1</HandlingVignetCode>
<IcbIdentifier>000000</IcbIdentifier>
<IntermediaryIdentifier>00000</IntermediaryIdentifier>
<IntermediaryNetworkCode>000</IntermediaryNetworkCode>
<IntermediaryReference>A0</IntermediaryReference>
<IntermediaryTypeCode>1</IntermediaryTypeCode>
<MailingPreferenceCode>A</MailingPreferenceCode>
<PeriodInvoiceTransferRequestCode>1</PeriodInvoiceTransferRequestCode>
<PrincipalCollectionChannel>0</PrincipalCollectionChannel>
<PrincipalIntermediaryIdentifier>00000</PrincipalIntermediaryIdentifier>
<ReturnPaymentCode>1</ReturnPaymentCode>
<SegmentationInformation>
</SegmentationInformation>
<StartersAgreementType>A</StartersAgreementType>
<TechnicalInformation>
</TechnicalInformation>
</Intermediary>
</ContractAsIntermediated>
<ContractCurrencyCode>AUD</ContractCurrencyCode>
<ContractIdentifier>0000000</ContractIdentifier>
<ContractSettlementTypeCode>0</ContractSettlementTypeCode>
<ContractTypeCode>00</ContractTypeCode>
<DoubtfulDebtorsEmployeeIdentifier>0000</DoubtfulDebtorsEmployeeIdentifier>
<FirstPremiumCollectionCode>0</FirstPremiumCollectionCode>
<ImmediateDocumentGeneration>1</ImmediateDocumentGeneration>
<InsuranceObject>
<Guarantee>
<Commission>
<CommissionTypeCode>000</CommissionTypeCode>
</Commission>
<Commission>
<CommissionAmount>0</CommissionAmount>
<CommissionTypeCode>000</CommissionTypeCode>
</Commission>
<CostOrCharge>
<CostAmount>0</CostAmount>
<CostTypeCode>000</CostTypeCode>
</CostOrCharge>
<CostOrCharge>
<CostTypeCode>000</CostTypeCode>
</CostOrCharge>
<CounterIntermediary>
</CounterIntermediary>
<CounterIntermediary>
</CounterIntermediary>
<GuaranteeEndDate>2006-05-04T18:13:51.0Z</GuaranteeEndDate>
<GuaranteeTypeCode>000</GuaranteeTypeCode>
<InceptionDateAndTime>2006-05-04T18:13:51.0Z</InceptionDateAndTime>
<Premium>
<PremiumAmount>0</PremiumAmount>
<PremiumTypeCode>000</PremiumTypeCode>
<Tax>
<TaxAmount>0</TaxAmount>
<TaxPercentage>0</TaxPercentage>
<TaxTypeCode>001</TaxTypeCode>
</Tax>
</Premium>
<Premium>
<PremiumTypeCode>000</PremiumTypeCode>
</Premium>
</Guarantee>
<Guarantee>
<Commission>
<CommissionTypeCode>000</CommissionTypeCode>
</Commission>
<Commission>
<CommissionTypeCode>000</CommissionTypeCode>
</Commission>
<CostOrCharge>
<CostTypeCode>000</CostTypeCode>
</CostOrCharge>
<CostOrCharge>
<CostTypeCode>000</CostTypeCode>
</CostOrCharge>
<CounterIntermediary>
</CounterIntermediary>
<CounterIntermediary>
</CounterIntermediary>
<GuaranteeEndDate>2006-05-04T18:13:51.0Z</GuaranteeEndDate>
<GuaranteeTypeCode>000</GuaranteeTypeCode>
<InceptionDateAndTime>2006-05-04T18:13:51.0Z</InceptionDateAndTime>
<Premium>
<PremiumTypeCode>000</PremiumTypeCode>
</Premium>
<Premium>
<PremiumTypeCode>000</PremiumTypeCode>
</Premium>
</Guarantee>
</InsuranceObject>
<InsuranceObject>
<Guarantee>
<Commission>
<CommissionTypeCode>000</CommissionTypeCode>
</Commission>
<Commission>
<CommissionTypeCode>000</CommissionTypeCode>
</Commission>
<CostOrCharge>
<CostTypeCode>000</CostTypeCode>
</CostOrCharge>
<CostOrCharge>
<CostTypeCode>000</CostTypeCode>
</CostOrCharge>
<CounterIntermediary>
</CounterIntermediary>
<CounterIntermediary>
</CounterIntermediary>
<GuaranteeEndDate>2006-05-04T18:13:51.0Z</GuaranteeEndDate>
<GuaranteeTypeCode>000</GuaranteeTypeCode>
<InceptionDateAndTime>2006-05-04T18:13:51.0Z</InceptionDateAndTime>
<Premium>
<PremiumTypeCode>000</PremiumTypeCode>
</Premium>
<Premium>
<PremiumTypeCode>000</PremiumTypeCode>
</Premium>
</Guarantee>
<Guarantee>
<Commission>
<CommissionTypeCode>000</CommissionTypeCode>
</Commission>
<Commission>
<CommissionTypeCode>000</CommissionTypeCode>
</Commission>
<CostOrCharge>
<CostTypeCode>000</CostTypeCode>
</CostOrCharge>
<CostOrCharge>
<CostTypeCode>000</CostTypeCode>
</CostOrCharge>
<CounterIntermediary>
</CounterIntermediary>
<CounterIntermediary>
</CounterIntermediary>
<GuaranteeEndDate>2006-05-04T18:13:51.0Z</GuaranteeEndDate>
<GuaranteeTypeCode>000</GuaranteeTypeCode>
<InceptionDateAndTime>2006-05-04T18:13:51.0Z</InceptionDateAndTime>
<Premium>
<PremiumTypeCode>000</PremiumTypeCode>
</Premium>
<Premium>
<PremiumTypeCode>000</PremiumTypeCode>
</Premium>
</Guarantee>
</InsuranceObject>
<InsuranceProductTypeCode>000</InsuranceProductTypeCode>
<LastChangeEmployeeIdentifier>0000</LastChangeEmployeeIdentifier>
<ManagingEmployeeIdentifier>0000</ManagingEmployeeIdentifier>
<PaymentFrequencyCode>1</PaymentFrequencyCode>
<PolicyHolder>
<BankAccountNumberChoice>
<FinancialAccountIdentifier>BE00000000000000</FinancialAccountIdentifier>
</BankAccountNumberChoice>
<BankAccountNumberChoiceType>
<FinancialAccountIdentifier>BE00000000000000</FinancialAccountIdentifier>
</BankAccountNumberChoiceType>
<Customer>
<Account>
<AccountTypeCode>01</AccountTypeCode>
<BankAccountNumberChoice>
<DomiciliationNumber>000000000000</DomiciliationNumber>
</BankAccountNumberChoice>
</Account>
<Account>
<AccountTypeCode>01</AccountTypeCode>
<BankAccountNumberChoice>
<FinancialAccountIdentifier>BE00000000000000</FinancialAccountIdentifier>
</BankAccountNumberChoice>
</Account>
<Address>
<AddressTypeCode>01</AddressTypeCode>
</Address>
<Address>
<AddressTypeCode>01</AddressTypeCode>
</Address>
<CommentLine>CommentLine1</CommentLine>
<CommunicationLanguageCode>DEU</CommunicationLanguageCode>
<CompanyIdentifier>Compa</CompanyIdentifier>
<ContactInformation>
</ContactInformation>
<EmployeeRelationCode>P</EmployeeRelationCode>
<IdentificationDocument>
<DocumentIdentifier>DocumentIdentifier2</DocumentIdentifier>
<DocumentTypeCode>3</DocumentTypeCode>
</IdentificationDocument>
<IdentificationDocument>
<DocumentIdentifier>DocumentIdentifier3</DocumentIdentifier>
<DocumentTypeCode>3</DocumentTypeCode>
</IdentificationDocument>
<LanguageCode>DEU</LanguageCode>
<LastModificationDate>2006-05-04T18:13:51.0Z</LastModificationDate>
<LegalPerson>
</LegalPerson>
<PartyName>PartyName1</PartyName>
<PartyRelation>
<PartyRelationCode>B</PartyRelationCode>
<PartyRelationIdentifier>0</PartyRelationIdentifier>
</PartyRelation>
<PartyRelation>
<PartyRelationCode>B</PartyRelationCode>
<PartyRelationIdentifier>0</PartyRelationIdentifier>
</PartyRelation>
<PartyTypeCode>0</PartyTypeCode>
<PhysicalPerson>
</PhysicalPerson>
<CustomerIdentifier>000000</CustomerIdentifier>
<CustomerMercatorNetReference>00000000-0000-0000-0000-000000000000</CustomerMercatorNetReference>
<CustomerPartner>
</CustomerPartner>
<CustomerProduct>
</CustomerProduct>
<CustomerReference>A0</CustomerReference>
<CustomerSituationDate>2006-05-04T18:13:51.0Z</CustomerSituationDate>
<EmployeeIdentifier>0000</EmployeeIdentifier>
<EmployeeReductionIndicator>1</EmployeeReductionIndicator>
<NewCustomerIdentifier>000000</NewCustomerIdentifier>
<ProtectedClientIndicator>8</ProtectedClientIndicator>
<SpecialCustomerCode>9</SpecialCustomerCode>
</Customer>
<FamilyCardNumber>00000000</FamilyCardNumber>
</PolicyHolder>
<PremiumNotification>
<CampaignNumber>000</CampaignNumber>
<CreationMonth>01</CreationMonth>
<CreationYear>0000</CreationYear>
<InsuranceObject>
<Guarantee>
<CounterIntermediary>
<Commission>
<CommissionAmount>55</CommissionAmount>
<CommissionTypeCode>215</CommissionTypeCode>
</Commission>
<Intermediary>
<CompanyIdentifier></CompanyIdentifier>
<PartyName></PartyName>
<PartyTypeCode>1</PartyTypeCode>
<IntermediaryIdentifier>11111</IntermediaryIdentifier>
<IntermediaryTypeCode>1</IntermediaryTypeCode>
<PrincipalIntermediaryIdentifier>11111</PrincipalIntermediaryIdentifier>
</Intermediary>
</CounterIntermediary>
<CounterIntermediary>
<Commission>
<CommissionAmount>66</CommissionAmount>
<CommissionTypeCode>215</CommissionTypeCode>
</Commission>
<Intermediary>
<CompanyIdentifier></CompanyIdentifier>
<PartyName></PartyName>
<PartyTypeCode>1</PartyTypeCode>
<IntermediaryIdentifier>33333</IntermediaryIdentifier>
<IntermediaryTypeCode>1</IntermediaryTypeCode>
<PrincipalIntermediaryIdentifier>22222</PrincipalIntermediaryIdentifier>
</Intermediary>
</CounterIntermediary>
<GuaranteeTypeCode>999</GuaranteeTypeCode>
</Guarantee>
<Guarantee>
<CounterIntermediary>
<Commission>
<CommissionAmount>77</CommissionAmount>
<CommissionTypeCode>215</CommissionTypeCode>
</Commission>
<Intermediary>
<CompanyIdentifier></CompanyIdentifier>
<PartyName></PartyName>
<PartyTypeCode>1</PartyTypeCode>
<IntermediaryIdentifier>33333</IntermediaryIdentifier>
<IntermediaryTypeCode>1</IntermediaryTypeCode>
<PrincipalIntermediaryIdentifier>33333</PrincipalIntermediaryIdentifier>
</Intermediary>
</CounterIntermediary>
<CounterIntermediary>
<Commission>
<CommissionAmount>88</CommissionAmount>
<CommissionTypeCode>215</CommissionTypeCode>
</Commission>
<Intermediary>
<CompanyIdentifier></CompanyIdentifier>
<PartyName></PartyName>
<PartyTypeCode>1</PartyTypeCode>
<IntermediaryIdentifier>44444</IntermediaryIdentifier>
<IntermediaryTypeCode>1</IntermediaryTypeCode>
<PrincipalIntermediaryIdentifier>44444</PrincipalIntermediaryIdentifier>
</Intermediary>
</CounterIntermediary>
<GuaranteeTypeCode>888</GuaranteeTypeCode>
</Guarantee>
<Guarantee>
<CounterIntermediary>
<Commission>
<CommissionAmount>123</CommissionAmount>
<CommissionTypeCode>215</CommissionTypeCode>
</Commission>
<Intermediary>
<CompanyIdentifier></CompanyIdentifier>
<PartyName></PartyName>
<PartyTypeCode>1</PartyTypeCode>
<IntermediaryIdentifier>33333</IntermediaryIdentifier>
<IntermediaryTypeCode>1</IntermediaryTypeCode>
<PrincipalIntermediaryIdentifier>33333</PrincipalIntermediaryIdentifier>
</Intermediary>
</CounterIntermediary>
<CounterIntermediary>
<Commission>
<CommissionAmount>99999999</CommissionAmount>
<CommissionTypeCode>215</CommissionTypeCode>
</Commission>
<Intermediary>
<CompanyIdentifier></CompanyIdentifier>
<PartyName></PartyName>
<PartyTypeCode>1</PartyTypeCode>
<IntermediaryIdentifier>44444</IntermediaryIdentifier>
<IntermediaryTypeCode>1</IntermediaryTypeCode>
<PrincipalIntermediaryIdentifier>44444</PrincipalIntermediaryIdentifier>
</Intermediary>
</CounterIntermediary>
<CounterIntermediary>
<Commission>
<CommissionAmount>77777777777777777777</CommissionAmount>
<CommissionTypeCode>215</CommissionTypeCode>
</Commission>
<Intermediary>
<CompanyIdentifier></CompanyIdentifier>
<PartyName></PartyName>
<PartyTypeCode>1</PartyTypeCode>
<IntermediaryIdentifier>44444</IntermediaryIdentifier>
<IntermediaryTypeCode>1</IntermediaryTypeCode>
<PrincipalIntermediaryIdentifier>44444</PrincipalIntermediaryIdentifier>
</Intermediary>
</CounterIntermediary>
<GuaranteeTypeCode>666</GuaranteeTypeCode>
</Guarantee>
<Guarantee>
<CounterIntermediary>
<Commission>
<CommissionAmount>55</CommissionAmount>
<CommissionTypeCode>215</CommissionTypeCode>
</Commission>
<Intermediary>
<CompanyIdentifier></CompanyIdentifier>
<PartyName></PartyName>
<PartyTypeCode>1</PartyTypeCode>
<IntermediaryIdentifier>77777</IntermediaryIdentifier>
<IntermediaryTypeCode>1</IntermediaryTypeCode>
<PrincipalIntermediaryIdentifier>11111</PrincipalIntermediaryIdentifier>
</Intermediary>
</CounterIntermediary>
<GuaranteeTypeCode>999</GuaranteeTypeCode>
</Guarantee>
</InsuranceObject>
<InsuranceYear>0000</InsuranceYear>
<LastCollectionLetterDate>2006-05-04T18:13:51.0Z</LastCollectionLetterDate>
<LastPaymentDate>2006-05-04T18:13:51.0Z</LastPaymentDate>
<PaidTotalAmount>0</PaidTotalAmount>
<PeriodEndDate>2006-05-04T18:13:51.0Z</PeriodEndDate>
<PeriodStartDate>2006-05-04T18:13:51.0Z</PeriodStartDate>
<PremiumCollectionCostAmount>0</PremiumCollectionCostAmount>
<PremiumInvoiceCollectionProcessCode>00</PremiumInvoiceCollectionProcessCode>
<PremiumInvoiceCollectionStatusCode>00</PremiumInvoiceCollectionStatusCode>
<PremiumInvoiceIdentifier>000000</PremiumInvoiceIdentifier>
<PremiumInvoicePaymentStatusCode>0</PremiumInvoicePaymentStatusCode>
<PremiumInvoicePaymentStatusDate>2006-05-04T18:13:51.0Z</PremiumInvoicePaymentStatusDate>
<PremiumInvoiceTypeCode>0</PremiumInvoiceTypeCode>
<RelatedUndoCreationMonth>01</RelatedUndoCreationMonth>
<RelatedUndoCreationYear>0000</RelatedUndoCreationYear>
<RelatedUndoPremiumInvoiceIdentifier>000000</RelatedUndoPremiumInvoiceIdentifier>
<ToBePaidTotalAmount>0</ToBePaidTotalAmount>
</PremiumNotification>
<PremiumNotification>
<CampaignNumber>000</CampaignNumber>
<CreationMonth>01</CreationMonth>
<CreationYear>0000</CreationYear>
<InsuranceObject>
<Guarantee>
<GuaranteeTypeCode>111</GuaranteeTypeCode>
</Guarantee>
<Guarantee>
<GuaranteeTypeCode>111</GuaranteeTypeCode>
</Guarantee>
</InsuranceObject>
<InsuranceObject>
<Guarantee>
<GuaranteeTypeCode>111</GuaranteeTypeCode>
</Guarantee>
<Guarantee>
<GuaranteeTypeCode>111</GuaranteeTypeCode>
</Guarantee>
</InsuranceObject>
<InsuranceYear>0000</InsuranceYear>
<LastCollectionLetterDate>2006-05-04T18:13:51.0Z</LastCollectionLetterDate>
<LastPaymentDate>2006-05-04T18:13:51.0Z</LastPaymentDate>
<PaidTotalAmount>0</PaidTotalAmount>
<PeriodEndDate>2006-05-04T18:13:51.0Z</PeriodEndDate>
<PeriodStartDate>2006-05-04T18:13:51.0Z</PeriodStartDate>
<PremiumCollectionCostAmount>0</PremiumCollectionCostAmount>
<PremiumInvoiceCollectionProcessCode>00</PremiumInvoiceCollectionProcessCode>
<PremiumInvoiceCollectionStatusCode>00</PremiumInvoiceCollectionStatusCode>
<PremiumInvoiceIdentifier>000000</PremiumInvoiceIdentifier>
<PremiumInvoicePaymentStatusCode>0</PremiumInvoicePaymentStatusCode>
<PremiumInvoicePaymentStatusDate>2006-05-04T18:13:51.0Z</PremiumInvoicePaymentStatusDate>
<PremiumInvoiceTypeCode>0</PremiumInvoiceTypeCode>
<RelatedUndoCreationMonth>01</RelatedUndoCreationMonth>
<RelatedUndoCreationYear>0000</RelatedUndoCreationYear>
<RelatedUndoPremiumInvoiceIdentifier>000000</RelatedUndoPremiumInvoiceIdentifier>
<ToBePaidTotalAmount>0</ToBePaidTotalAmount>
</PremiumNotification>
<RenewalPremiumCollectionCode>0</RenewalPremiumCollectionCode>
<ReplacementContractIdentifier>0000000</ReplacementContractIdentifier>
</Contract>
<ServiceAction>Check</ServiceAction>
</Invoice>
<Invoice>
<Contract>
<CompanyIdentifier>Compa</CompanyIdentifier>
<ContractAsIntermediated>
<BrokerPolicyIndentifier>BrokerPolicyInd</BrokerPolicyIndentifier>
<Intermediary>
<Account>
<AccountTypeCode>01</AccountTypeCode>
<BankAccountNumberChoice>
<DomiciliationNumber>000000000000</DomiciliationNumber>
</BankAccountNumberChoice>
</Account>
<Account>
<AccountTypeCode>01</AccountTypeCode>
<BankAccountNumberChoice>
<DomiciliationNumber>000000000000</DomiciliationNumber>
</BankAccountNumberChoice>
</Account>
<Address>
<AddressTypeCode>01</AddressTypeCode>
</Address>
<Address>
<AddressTypeCode>01</AddressTypeCode>
</Address>
<CommentLine>CommentLine2</CommentLine>
<CommunicationLanguageCode>DEU</CommunicationLanguageCode>
<CompanyIdentifier>Compa</CompanyIdentifier>
<ContactInformation>
</ContactInformation>
<EmployeeRelationCode>P</EmployeeRelationCode>
<IdentificationDocument>
<DocumentIdentifier>DocumentIdentifier4</DocumentIdentifier>
<DocumentTypeCode>3</DocumentTypeCode>
</IdentificationDocument>
<IdentificationDocument>
<DocumentIdentifier>DocumentIdentifier5</DocumentIdentifier>
<DocumentTypeCode>3</DocumentTypeCode>
</IdentificationDocument>
<LanguageCode>DEU</LanguageCode>
<LastModificationDate>2006-05-04T18:13:51.0Z</LastModificationDate>
<LegalPerson>
</LegalPerson>
<PartyName>PartyName2</PartyName>
<PartyRelation>
<PartyRelationCode>B</PartyRelationCode>
<PartyRelationIdentifier>0</PartyRelationIdentifier>
</PartyRelation>
<PartyRelation>
<PartyRelationCode>B</PartyRelationCode>
<PartyRelationIdentifier>0</PartyRelationIdentifier>
</PartyRelation>
<PartyTypeCode>0</PartyTypeCode>
<PhysicalPerson>
</PhysicalPerson>
<ArrondissementCode>000</ArrondissementCode>
<Authorization>2</Authorization>
<CollectionProcessProductGroup>
<CollectionMethodCode>01</CollectionMethodCode>
<CollectionProcessTypeCode>1</CollectionProcessTypeCode>
</CollectionProcessProductGroup>
<CollectionProcessProductGroup>
<CollectionMethodCode>01</CollectionMethodCode>
<CollectionProcessTypeCode>1</CollectionProcessTypeCode>
</CollectionProcessProductGroup>
<CorrespondenceCode>1</CorrespondenceCode>
<DamagesPaymentMethodCode>1</DamagesPaymentMethodCode>
<HandlingGreenCardCode>1</HandlingGreenCardCode>
<HandlingTerminalFamilyCode>1</HandlingTerminalFamilyCode>
<HandlingVignetCode>1</HandlingVignetCode>
<IcbIdentifier>000000</IcbIdentifier>
<IntermediaryIdentifier>00000</IntermediaryIdentifier>
<IntermediaryNetworkCode>000</IntermediaryNetworkCode>
<IntermediaryReference>A0</IntermediaryReference>
<IntermediaryTypeCode>1</IntermediaryTypeCode>
<MailingPreferenceCode>A</MailingPreferenceCode>
<PeriodInvoiceTransferRequestCode>1</PeriodInvoiceTransferRequestCode>
<PrincipalCollectionChannel>0</PrincipalCollectionChannel>
<PrincipalIntermediaryIdentifier>00000</PrincipalIntermediaryIdentifier>
<ReturnPaymentCode>1</ReturnPaymentCode>
<SegmentationInformation>
</SegmentationInformation>
<StartersAgreementType>A</StartersAgreementType>
<TechnicalInformation>
</TechnicalInformation>
</Intermediary>
</ContractAsIntermediated>
<ContractCurrencyCode>AUD</ContractCurrencyCode>
<ContractIdentifier>0000000</ContractIdentifier>
<ContractSettlementTypeCode>0</ContractSettlementTypeCode>
<ContractTypeCode>00</ContractTypeCode>
<DoubtfulDebtorsEmployeeIdentifier>0000</DoubtfulDebtorsEmployeeIdentifier>
<FirstPremiumCollectionCode>0</FirstPremiumCollectionCode>
<ImmediateDocumentGeneration>1</ImmediateDocumentGeneration>
<InsuranceObject>
<Guarantee>
<Commission>
<CommissionTypeCode>000</CommissionTypeCode>
</Commission>
<Commission>
<CommissionTypeCode>000</CommissionTypeCode>
</Commission>
<CostOrCharge>
<CostTypeCode>000</CostTypeCode>
</CostOrCharge>
<CostOrCharge>
<CostTypeCode>000</CostTypeCode>
</CostOrCharge>
<CounterIntermediary>
</CounterIntermediary>
<CounterIntermediary>
</CounterIntermediary>
<GuaranteeEndDate>2006-05-04T18:13:51.0Z</GuaranteeEndDate>
<GuaranteeTypeCode>000</GuaranteeTypeCode>
<InceptionDateAndTime>2006-05-04T18:13:51.0Z</InceptionDateAndTime>
<Premium>
<PremiumTypeCode>000</PremiumTypeCode>
</Premium>
<Premium>
<PremiumTypeCode>000</PremiumTypeCode>
</Premium>
</Guarantee>
<Guarantee>
<Commission>
<CommissionTypeCode>000</CommissionTypeCode>
</Commission>
<Commission>
<CommissionTypeCode>000</CommissionTypeCode>
</Commission>
<CostOrCharge>
<CostTypeCode>000</CostTypeCode>
</CostOrCharge>
<CostOrCharge>
<CostTypeCode>000</CostTypeCode>
</CostOrCharge>
<CounterIntermediary>
</CounterIntermediary>
<CounterIntermediary>
</CounterIntermediary>
<GuaranteeEndDate>2006-05-04T18:13:51.0Z</GuaranteeEndDate>
<GuaranteeTypeCode>000</GuaranteeTypeCode>
<InceptionDateAndTime>2006-05-04T18:13:51.0Z</InceptionDateAndTime>
<Premium>
<PremiumTypeCode>000</PremiumTypeCode>
</Premium>
<Premium>
<PremiumTypeCode>000</PremiumTypeCode>
</Premium>
</Guarantee>
</InsuranceObject>
<InsuranceObject>
<Guarantee>
<Commission>
<CommissionTypeCode>000</CommissionTypeCode>
</Commission>
<Commission>
<CommissionTypeCode>000</CommissionTypeCode>
</Commission>
<CostOrCharge>
<CostTypeCode>000</CostTypeCode>
</CostOrCharge>
<CostOrCharge>
<CostTypeCode>000</CostTypeCode>
</CostOrCharge>
<CounterIntermediary>
</CounterIntermediary>
<CounterIntermediary>
</CounterIntermediary>
<GuaranteeEndDate>2006-05-04T18:13:51.0Z</GuaranteeEndDate>
<GuaranteeTypeCode>000</GuaranteeTypeCode>
<InceptionDateAndTime>2006-05-04T18:13:51.0Z</InceptionDateAndTime>
<Premium>
<PremiumTypeCode>000</PremiumTypeCode>
</Premium>
<Premium>
<PremiumTypeCode>000</PremiumTypeCode>
</Premium>
</Guarantee>
<Guarantee>
<Commission>
<CommissionTypeCode>000</CommissionTypeCode>
</Commission>
<Commission>
<CommissionTypeCode>000</CommissionTypeCode>
</Commission>
<CostOrCharge>
<CostTypeCode>000</CostTypeCode>
</CostOrCharge>
<CostOrCharge>
<CostTypeCode>000</CostTypeCode>
</CostOrCharge>
<CounterIntermediary>
</CounterIntermediary>
<CounterIntermediary>
</CounterIntermediary>
<GuaranteeEndDate>2006-05-04T18:13:51.0Z</GuaranteeEndDate>
<GuaranteeTypeCode>000</GuaranteeTypeCode>
<InceptionDateAndTime>2006-05-04T18:13:51.0Z</InceptionDateAndTime>
<Premium>
<PremiumTypeCode>000</PremiumTypeCode>
</Premium>
<Premium>
<PremiumTypeCode>000</PremiumTypeCode>
</Premium>
</Guarantee>
</InsuranceObject>
<InsuranceProductTypeCode>000</InsuranceProductTypeCode>
<LastChangeEmployeeIdentifier>0000</LastChangeEmployeeIdentifier>
<ManagingEmployeeIdentifier>0000</ManagingEmployeeIdentifier>
<PaymentFrequencyCode>1</PaymentFrequencyCode>
<PolicyHolder>
<BankAccountNumberChoice>
<FinancialAccountIdentifier>BE00000000000000</FinancialAccountIdentifier>
</BankAccountNumberChoice>
<BankAccountNumberChoiceType>
<DomiciliationNumber>000000000000</DomiciliationNumber>
</BankAccountNumberChoiceType>
<Customer>
<Account>
<AccountTypeCode>01</AccountTypeCode>
<BankAccountNumberChoice>
<FinancialAccountIdentifier>BE00000000000000</FinancialAccountIdentifier>
</BankAccountNumberChoice>
</Account>
<Account>
<AccountTypeCode>01</AccountTypeCode>
<BankAccountNumberChoice>
<FinancialAccountIdentifier>BE00000000000000</FinancialAccountIdentifier>
</BankAccountNumberChoice>
</Account>
<Address>
<AddressTypeCode>01</AddressTypeCode>
</Address>
<Address>
<AddressTypeCode>01</AddressTypeCode>
</Address>
<CommentLine>CommentLine3</CommentLine>
<CommunicationLanguageCode>DEU</CommunicationLanguageCode>
<CompanyIdentifier>Compa</CompanyIdentifier>
<ContactInformation>
</ContactInformation>
<EmployeeRelationCode>P</EmployeeRelationCode>
<IdentificationDocument>
<DocumentIdentifier>DocumentIdentifier6</DocumentIdentifier>
<DocumentTypeCode>3</DocumentTypeCode>
</IdentificationDocument>
<IdentificationDocument>
<DocumentIdentifier>DocumentIdentifier7</DocumentIdentifier>
<DocumentTypeCode>3</DocumentTypeCode>
</IdentificationDocument>
<LanguageCode>DEU</LanguageCode>
<LastModificationDate>2006-05-04T18:13:51.0Z</LastModificationDate>
<LegalPerson>
</LegalPerson>
<PartyName>PartyName3</PartyName>
<PartyRelation>
<PartyRelationCode>B</PartyRelationCode>
<PartyRelationIdentifier>0</PartyRelationIdentifier>
</PartyRelation>
<PartyRelation>
<PartyRelationCode>B</PartyRelationCode>
<PartyRelationIdentifier>0</PartyRelationIdentifier>
</PartyRelation>
<PartyTypeCode>0</PartyTypeCode>
<PhysicalPerson>
</PhysicalPerson>
<CustomerIdentifier>000000</CustomerIdentifier>
<CustomerMercatorNetReference>00000000-0000-0000-0000-000000000000</CustomerMercatorNetReference>
<CustomerPartner>
</CustomerPartner>
<CustomerProduct>
</CustomerProduct>
<CustomerReference>A0</CustomerReference>
<CustomerSituationDate>2006-05-04T18:13:51.0Z</CustomerSituationDate>
<EmployeeIdentifier>0000</EmployeeIdentifier>
<EmployeeReductionIndicator>1</EmployeeReductionIndicator>
<NewCustomerIdentifier>000000</NewCustomerIdentifier>
<ProtectedClientIndicator>8</ProtectedClientIndicator>
<SpecialCustomerCode>9</SpecialCustomerCode>
</Customer>
<FamilyCardNumber>00000000</FamilyCardNumber>
</PolicyHolder>
<PremiumNotification>
<CampaignNumber>000</CampaignNumber>
<CreationMonth>01</CreationMonth>
<CreationYear>0000</CreationYear>
<InsuranceObject>
<Guarantee>
<CounterIntermediary>
<Commission>
<CommissionAmount>55</CommissionAmount>
<CommissionTypeCode>215</CommissionTypeCode>
</Commission>
<Intermediary>
<CompanyIdentifier></CompanyIdentifier>
<PartyName></PartyName>
<PartyTypeCode>1</PartyTypeCode>
<IntermediaryIdentifier>11111</IntermediaryIdentifier>
<IntermediaryTypeCode>1</IntermediaryTypeCode>
<PrincipalIntermediaryIdentifier>11111</PrincipalIntermediaryIdentifier>
</Intermediary>
</CounterIntermediary>
<CounterIntermediary>
<Commission>
<CommissionAmount>66</CommissionAmount>
<CommissionTypeCode>215</CommissionTypeCode>
</Commission>
<Intermediary>
<CompanyIdentifier></CompanyIdentifier>
<PartyName></PartyName>
<PartyTypeCode>1</PartyTypeCode>
<IntermediaryIdentifier>33333</IntermediaryIdentifier>
<IntermediaryTypeCode>1</IntermediaryTypeCode>
<PrincipalIntermediaryIdentifier>22222</PrincipalIntermediaryIdentifier>
</Intermediary>
</CounterIntermediary>
<GuaranteeTypeCode>999</GuaranteeTypeCode>
</Guarantee>
<Guarantee>
<CounterIntermediary>
<Commission>
<CommissionAmount>77</CommissionAmount>
<CommissionTypeCode>215</CommissionTypeCode>
</Commission>
<Intermediary>
<CompanyIdentifier></CompanyIdentifier>
<PartyName></PartyName>
<PartyTypeCode>1</PartyTypeCode>
<IntermediaryIdentifier>33333</IntermediaryIdentifier>
<IntermediaryTypeCode>1</IntermediaryTypeCode>
<PrincipalIntermediaryIdentifier>33333</PrincipalIntermediaryIdentifier>
</Intermediary>
</CounterIntermediary>
<CounterIntermediary>
<Commission>
<CommissionAmount>88</CommissionAmount>
<CommissionTypeCode>215</CommissionTypeCode>
</Commission>
<Intermediary>
<CompanyIdentifier></CompanyIdentifier>
<PartyName></PartyName>
<PartyTypeCode>1</PartyTypeCode>
<IntermediaryIdentifier>44444</IntermediaryIdentifier>
<IntermediaryTypeCode>1</IntermediaryTypeCode>
<PrincipalIntermediaryIdentifier>44444</PrincipalIntermediaryIdentifier>
</Intermediary>
</CounterIntermediary>
<GuaranteeTypeCode>888</GuaranteeTypeCode>
</Guarantee>
<Guarantee>
<CounterIntermediary>
<Commission>
<CommissionAmount>123</CommissionAmount>
<CommissionTypeCode>215</CommissionTypeCode>
</Commission>
<Intermediary>
<CompanyIdentifier></CompanyIdentifier>
<PartyName></PartyName>
<PartyTypeCode>1</PartyTypeCode>
<IntermediaryIdentifier>33333</IntermediaryIdentifier>
<IntermediaryTypeCode>1</IntermediaryTypeCode>
<PrincipalIntermediaryIdentifier>33333</PrincipalIntermediaryIdentifier>
</Intermediary>
</CounterIntermediary>
<CounterIntermediary>
<Commission>
<CommissionAmount>99999999</CommissionAmount>
<CommissionTypeCode>215</CommissionTypeCode>
</Commission>
<Intermediary>
<CompanyIdentifier></CompanyIdentifier>
<PartyName></PartyName>
<PartyTypeCode>1</PartyTypeCode>
<IntermediaryIdentifier>44444</IntermediaryIdentifier>
<IntermediaryTypeCode>1</IntermediaryTypeCode>
<PrincipalIntermediaryIdentifier>44444</PrincipalIntermediaryIdentifier>
</Intermediary>
</CounterIntermediary>
<CounterIntermediary>
<Commission>
<CommissionAmount>77777777777777777777</CommissionAmount>
<CommissionTypeCode>215</CommissionTypeCode>
</Commission>
<Intermediary>
<CompanyIdentifier></CompanyIdentifier>
<PartyName></PartyName>
<PartyTypeCode>1</PartyTypeCode>
<IntermediaryIdentifier>44444</IntermediaryIdentifier>
<IntermediaryTypeCode>1</IntermediaryTypeCode>
<PrincipalIntermediaryIdentifier>44444</PrincipalIntermediaryIdentifier>
</Intermediary>
</CounterIntermediary>
<GuaranteeTypeCode>666</GuaranteeTypeCode>
</Guarantee>
</InsuranceObject>
<InsuranceYear>0000</InsuranceYear>
<LastCollectionLetterDate>2006-05-04T18:13:51.0Z</LastCollectionLetterDate>
<LastPaymentDate>2006-05-04T18:13:51.0Z</LastPaymentDate>
<PaidTotalAmount>0</PaidTotalAmount>
<PeriodEndDate>2006-05-04T18:13:51.0Z</PeriodEndDate>
<PeriodStartDate>2006-05-04T18:13:51.0Z</PeriodStartDate>
<PremiumCollectionCostAmount>0</PremiumCollectionCostAmount>
<PremiumInvoiceCollectionProcessCode>00</PremiumInvoiceCollectionProcessCode>
<PremiumInvoiceCollectionStatusCode>00</PremiumInvoiceCollectionStatusCode>
<PremiumInvoiceIdentifier>000000</PremiumInvoiceIdentifier>
<PremiumInvoicePaymentStatusCode>0</PremiumInvoicePaymentStatusCode>
<PremiumInvoicePaymentStatusDate>2006-05-04T18:13:51.0Z</PremiumInvoicePaymentStatusDate>
<PremiumInvoiceTypeCode>0</PremiumInvoiceTypeCode>
<RelatedUndoCreationMonth>01</RelatedUndoCreationMonth>
<RelatedUndoCreationYear>0000</RelatedUndoCreationYear>
<RelatedUndoPremiumInvoiceIdentifier>000000</RelatedUndoPremiumInvoiceIdentifier>
<ToBePaidTotalAmount>0</ToBePaidTotalAmount>
</PremiumNotification>
<PremiumNotification>
<CampaignNumber>000</CampaignNumber>
<CreationMonth>01</CreationMonth>
<CreationYear>0000</CreationYear>
<InsuranceObject>
<Guarantee>
<GuaranteeTypeCode>000</GuaranteeTypeCode>
</Guarantee>
<Guarantee>
<GuaranteeTypeCode>000</GuaranteeTypeCode>
</Guarantee>
</InsuranceObject>
<InsuranceObject>
<Guarantee>
<GuaranteeTypeCode>000</GuaranteeTypeCode>
</Guarantee>
<Guarantee>
<GuaranteeTypeCode>000</GuaranteeTypeCode>
</Guarantee>
</InsuranceObject>
<InsuranceYear>0000</InsuranceYear>
<LastCollectionLetterDate>2006-05-04T18:13:51.0Z</LastCollectionLetterDate>
<LastPaymentDate>2006-05-04T18:13:51.0Z</LastPaymentDate>
<PaidTotalAmount>0</PaidTotalAmount>
<PeriodEndDate>2006-05-04T18:13:51.0Z</PeriodEndDate>
<PeriodStartDate>2006-05-04T18:13:51.0Z</PeriodStartDate>
<PremiumCollectionCostAmount>0</PremiumCollectionCostAmount>
<PremiumInvoiceCollectionProcessCode>00</PremiumInvoiceCollectionProcessCode>
<PremiumInvoiceCollectionStatusCode>00</PremiumInvoiceCollectionStatusCode>
<PremiumInvoiceIdentifier>000000</PremiumInvoiceIdentifier>
<PremiumInvoicePaymentStatusCode>0</PremiumInvoicePaymentStatusCode>
<PremiumInvoicePaymentStatusDate>2006-05-04T18:13:51.0Z</PremiumInvoicePaymentStatusDate>
<PremiumInvoiceTypeCode>0</PremiumInvoiceTypeCode>
<RelatedUndoCreationMonth>01</RelatedUndoCreationMonth>
<RelatedUndoCreationYear>0000</RelatedUndoCreationYear>
<RelatedUndoPremiumInvoiceIdentifier>000000</RelatedUndoPremiumInvoiceIdentifier>
<ToBePaidTotalAmount>0</ToBePaidTotalAmount>
</PremiumNotification>
<RenewalPremiumCollectionCode>0</RenewalPremiumCollectionCode>
<ReplacementContractIdentifier>0000000</ReplacementContractIdentifier>
</Contract>
<ServiceAction>Check</ServiceAction>
</Invoice>
</ns6:InvoiceSave>
Last edited by JohnBampton; November 12th, 2009 at 10:26 AM..
|
|
November 12th, 2009, 10:55 AM
|
|
Friend of Wrox
|
|
Join Date: Nov 2007
Posts: 1,243
Thanks: 0
Thanked 245 Times in 244 Posts
|
|
The <xsl:for-each select="msxsl:node-set($newids)/newids/newid"> makes a 'newid' element inside the node-set created with msxsl:node-set the context node. Then inside of the for-each you try <xsl:for-each select="//ns6:InvoiceSave"> which means /descendant-or-self::node()/ns6:InvoiceSave where / selects the root node the 'newid' element is contained in. If that inner for-each does not find anything then the document (fragment) the newid is contained in does not have any ns6:InvoiceSave elements, probably because these are inside of a different document. So you will need to store the other document in a variable before the outer for-each e.g.
Code:
<xsl:variable name="primary-input-doc" select="/"/>
<xsl:for-each select="msxsl:node-set($newids)/newids/newid">
...
<xsl:for-each select="$primary-input-doc//ns6:InvoiceSave">
...
</xsl:for-each>
</xsl:for-each>
__________________
Martin Honnen
Microsoft MVP (XML, Data Platform Development) 2005/04 - 2013/03
My blog
|
|
November 12th, 2009, 11:02 AM
|
|
Friend of Wrox
|
|
Join Date: Feb 2009
Posts: 119
Thanks: 25
Thanked 3 Times in 3 Posts
|
|
Thanks martin your the best. It works now
|
|
|
