File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes XML and Related Technologies and the fly likes Help Needed !! Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Engineering » XML and Related Technologies
Bookmark "Help Needed !! " Watch "Help Needed !! " New topic
Author

Help Needed !!

Lakshmi Nadaduru
Greenhorn

Joined: Sep 04, 2013
Posts: 1
I am a new bee in the XSL world and need to transform an XML ( A set of records in a table with hierarchical relation ship among the rows ) each element provides the info of its parent . Apologies for posting a big XML

PS : The root element is -1 ( Document Request ) and all elements with parentBlockiD -1 are children of the root element (DocumentRequest).

Relation ship definition :
1. <ns0:blockId>1</ns0:blockId> and <ns0:parentBlockId>-1</ns0:parentBlockId> define the parent Child relation ship #
2. If the Body ID is more than 1 . this means that the parent element has multiple instances of the child element .

I was able to generate it using DOM . but the solution is not scalable and has dependency on the target XSD .if there is any addition or deletion of an element I have to change the java code to absorb the change.

Input XML :

<arg0>
<ns0:OcsBatchView>
<ns0:batchId>1</ns0:batchId>
<ns0:headerId>1</ns0:headerId>
<ns0:blockId>1</ns0:blockId>
<ns0:parentBlockId>-1</ns0:parentBlockId>
<ns0:parentBlock>DocumentRequest</ns0:parentBlock>
<ns0:blockName>ChargesSummary</ns0:blockName>
<ns0:bodyId>1</ns0:bodyId>
<ns0:columnId>1</ns0:columnId>
<ns0:columnName>AccountNumber</ns0:columnName>
<ns0:columnType>STRING</ns0:columnType>
<ns0:columnData>12345678</ns0:columnData>
</ns0:OcsBatchView>
<ns0:OcsBatchView>
<ns0:batchId>1</ns0:batchId>
<ns0:headerId>1</ns0:headerId>
<ns0:blockId>1</ns0:blockId>
<ns0:parentBlockId>-1</ns0:parentBlockId>
<ns0:parentBlock>DocumentRequest</ns0:parentBlock>
<ns0:blockName>ChargesSummary</ns0:blockName>
<ns0:bodyId>1</ns0:bodyId>
<ns0:columnId>2</ns0:columnId>
<ns0:columnName>BranchID</ns0:columnName>
<ns0:columnType>STRING</ns0:columnType>
<ns0:columnData>00-00-00</ns0:columnData>
</ns0:OcsBatchView>
<ns0:OcsBatchView>
<ns0:batchId>1</ns0:batchId>
<ns0:headerId>1</ns0:headerId>
<ns0:blockId>1</ns0:blockId>
<ns0:parentBlockId>-1</ns0:parentBlockId>
<ns0:parentBlock>DocumentRequest</ns0:parentBlock>
<ns0:blockName>ChargesSummary</ns0:blockName>
<ns0:bodyId>1</ns0:bodyId>
<ns0:columnId>3</ns0:columnId>
<ns0:columnName>ChargeDate-DDMonthYear</ns0:columnName>
<ns0:columnType>STRING</ns0:columnType>
<ns0:columnData>18 August 2010</ns0:columnData>
</ns0:OcsBatchView>
<ns0:OcsBatchView>
<ns0:batchId>1</ns0:batchId>
<ns0:headerId>1</ns0:headerId>
<ns0:blockId>1</ns0:blockId>
<ns0:parentBlockId>-1</ns0:parentBlockId>
<ns0:parentBlock>DocumentRequest</ns0:parentBlock>
<ns0:blockName>ChargesSummary</ns0:blockName>
<ns0:bodyId>1</ns0:bodyId>
<ns0:columnId>4</ns0:columnId>
<ns0:columnName>TransactionCharges-CardsAcquiredByUS</ns0:columnName>
<ns0:columnType>STRING</ns0:columnType>
<ns0:columnData>451.29</ns0:columnData>
</ns0:OcsBatchView>
<ns0:OcsBatchView>
<ns0:batchId>1</ns0:batchId>
<ns0:headerId>1</ns0:headerId>
<ns0:blockId>1</ns0:blockId>
<ns0:parentBlockId>-1</ns0:parentBlockId>
<ns0:parentBlock>DocumentRequest</ns0:parentBlock>
<ns0:blockName>ChargesSummary</ns0:blockName>
<ns0:bodyId>1</ns0:bodyId>
<ns0:columnId>5</ns0:columnId>
<ns0:columnName>TransactionCharges-CardsAcquiredByOtherAcquirers</ns0:columnName>
<ns0:columnType>STRING</ns0:columnType>
<ns0:columnData>0.0</ns0:columnData>
</ns0:OcsBatchView>
<ns0:OcsBatchView>
<ns0:batchId>1</ns0:batchId>
<ns0:headerId>1</ns0:headerId>
<ns0:blockId>1</ns0:blockId>
<ns0:parentBlockId>-1</ns0:parentBlockId>
<ns0:parentBlock>DocumentRequest</ns0:parentBlock>
<ns0:blockName>ChargesSummary</ns0:blockName>
<ns0:bodyId>1</ns0:bodyId>
<ns0:columnId>6</ns0:columnId>
<ns0:columnName>PremiumChargesSummary</ns0:columnName>
<ns0:columnType>STRING</ns0:columnType>
<ns0:columnData>47.32</ns0:columnData>
</ns0:OcsBatchView>
<ns0:OcsBatchView>
<ns0:batchId>1</ns0:batchId>
<ns0:headerId>1</ns0:headerId>
<ns0:blockId>1</ns0:blockId>
<ns0:parentBlockId>-1</ns0:parentBlockId>
<ns0:parentBlock>DocumentRequest</ns0:parentBlock>
<ns0:blockName>ChargesSummary</ns0:blockName>
<ns0:bodyId>1</ns0:bodyId>
<ns0:columnId>7</ns0:columnId>
<ns0:columnName>MiscellaneousChargesSummary</ns0:columnName>
<ns0:columnType>STRING</ns0:columnType>
<ns0:columnData>37.90</ns0:columnData>
</ns0:OcsBatchView>
<ns0:OcsBatchView>
<ns0:batchId>1</ns0:batchId>
<ns0:headerId>1</ns0:headerId>
<ns0:blockId>1</ns0:blockId>
<ns0:parentBlockId>-1</ns0:parentBlockId>
<ns0:parentBlock>DocumentRequest</ns0:parentBlock>
<ns0:blockName>ChargesSummary</ns0:blockName>
<ns0:bodyId>1</ns0:bodyId>
<ns0:columnId>8</ns0:columnId>
<ns0:columnName>ChargesSummaryTotalCharges</ns0:columnName>
<ns0:columnType>STRING</ns0:columnType>
<ns0:columnData>489.19</ns0:columnData>
</ns0:OcsBatchView>
<ns0:OcsBatchView>
<ns0:batchId>1</ns0:batchId>
<ns0:headerId>1</ns0:headerId>
<ns0:blockId>1</ns0:blockId>
<ns0:parentBlockId>-1</ns0:parentBlockId>
<ns0:parentBlock>DocumentRequest</ns0:parentBlock>
<ns0:blockName>ChargesSummary</ns0:blockName>
<ns0:bodyId>1</ns0:bodyId>
<ns0:columnId>9</ns0:columnId>
<ns0:columnName>VATAmount</ns0:columnName>
<ns0:columnType>STRING</ns0:columnType>
<ns0:columnData>6.63</ns0:columnData>
</ns0:OcsBatchView>
<ns0:OcsBatchView>
<ns0:batchId>1</ns0:batchId>
<ns0:headerId>1</ns0:headerId>
<ns0:blockId>1</ns0:blockId>
<ns0:parentBlockId>-1</ns0:parentBlockId>
<ns0:parentBlock>DocumentRequest</ns0:parentBlock>
<ns0:blockName>ChargesSummary</ns0:blockName>
<ns0:bodyId>1</ns0:bodyId>
<ns0:columnId>10</ns0:columnId>
<ns0:columnName>TotalDue</ns0:columnName>
<ns0:columnType>STRING</ns0:columnType>
<ns0:columnData>495.82</ns0:columnData>
</ns0:OcsBatchView>
<ns0:OcsBatchView>
<ns0:batchId>1</ns0:batchId>
<ns0:headerId>1</ns0:headerId>
<ns0:blockId>2</ns0:blockId>
<ns0:parentBlockId>1</ns0:parentBlockId>
<ns0:parentBlock>ChargesSummary</ns0:parentBlock>
<ns0:blockName>BatchTotals</ns0:blockName>
<ns0:bodyId>1</ns0:bodyId>
<ns0:columnId>1</ns0:columnId>
<ns0:columnName/>
<ns0:columnType>STRING</ns0:columnType>
<ns0:columnData/>
</ns0:OcsBatchView>
<ns0:OcsBatchView>
<ns0:batchId>1</ns0:batchId>
<ns0:headerId>1</ns0:headerId>
<ns0:blockId>3</ns0:blockId>
<ns0:parentBlockId>2</ns0:parentBlockId>
<ns0:parentBlock>BatchTotals</ns0:parentBlock>
<ns0:blockName>BatchDateLineItem</ns0:blockName>
<ns0:bodyId>1</ns0:bodyId>
<ns0:columnId>1</ns0:columnId>
<ns0:columnName>BatchDate</ns0:columnName>
<ns0:columnType>STRING</ns0:columnType>
<ns0:columnData>01 August 2010</ns0:columnData>
</ns0:OcsBatchView>
<ns0:OcsBatchView>
<ns0:batchId>1</ns0:batchId>
<ns0:headerId>1</ns0:headerId>
<ns0:blockId>3</ns0:blockId>
<ns0:parentBlockId>2</ns0:parentBlockId>
<ns0:parentBlock>BatchTotals</ns0:parentBlock>
<ns0:blockName>BatchDateLineItem</ns0:blockName>
<ns0:bodyId>1</ns0:bodyId>
<ns0:columnId>2</ns0:columnId>
<ns0:columnName>BatchStartReference</ns0:columnName>
<ns0:columnType>STRING</ns0:columnType>
<ns0:columnData>001665</ns0:columnData>
</ns0:OcsBatchView>
<ns0:OcsBatchView>
<ns0:batchId>1</ns0:batchId>
<ns0:headerId>1</ns0:headerId>
<ns0:blockId>3</ns0:blockId>
<ns0:parentBlockId>2</ns0:parentBlockId>
<ns0:parentBlock>BatchTotals</ns0:parentBlock>
<ns0:blockName>BatchDateLineItem</ns0:blockName>
<ns0:bodyId>1</ns0:bodyId>
<ns0:columnId>3</ns0:columnId>
<ns0:columnName>GrossValue</ns0:columnName>
<ns0:columnType>STRING</ns0:columnType>
<ns0:columnData>12.00</ns0:columnData>
</ns0:OcsBatchView>
<ns0:OcsBatchView>
<ns0:batchId>1</ns0:batchId>
<ns0:headerId>1</ns0:headerId>
<ns0:blockId>3</ns0:blockId>
<ns0:parentBlockId>2</ns0:parentBlockId>
<ns0:parentBlock>BatchTotals</ns0:parentBlock>
<ns0:blockName>BatchDateLineItem</ns0:blockName>
<ns0:bodyId>1</ns0:bodyId>
<ns0:columnId>4</ns0:columnId>
<ns0:columnName>Adjustment</ns0:columnName>
<ns0:columnType>STRING</ns0:columnType>
<ns0:columnData>0.00</ns0:columnData>
</ns0:OcsBatchView>
<ns0:OcsBatchView>
<ns0:batchId>1</ns0:batchId>
<ns0:headerId>1</ns0:headerId>
<ns0:blockId>3</ns0:blockId>
<ns0:parentBlockId>2</ns0:parentBlockId>
<ns0:parentBlock>BatchTotals</ns0:parentBlock>
<ns0:blockName>BatchDateLineItem</ns0:blockName>
<ns0:bodyId>1</ns0:bodyId>
<ns0:columnId>5</ns0:columnId>
<ns0:columnName>NetValue</ns0:columnName>
<ns0:columnType>STRING</ns0:columnType>
<ns0:columnData>12.00</ns0:columnData>
</ns0:OcsBatchView>
<ns0:OcsBatchView>
<ns0:batchId>1</ns0:batchId>
<ns0:headerId>1</ns0:headerId>
<ns0:blockId>3</ns0:blockId>
<ns0:parentBlockId>2</ns0:parentBlockId>
<ns0:parentBlock>BatchTotals</ns0:parentBlock>
<ns0:blockName>BatchDateLineItem</ns0:blockName>
<ns0:bodyId>2</ns0:bodyId>
<ns0:columnId>1</ns0:columnId>
<ns0:columnName>BatchDate</ns0:columnName>
<ns0:columnType>STRING</ns0:columnType>
<ns0:columnData>02 August 2010</ns0:columnData>
</ns0:OcsBatchView>
<ns0:OcsBatchView>
<ns0:batchId>1</ns0:batchId>
<ns0:headerId>1</ns0:headerId>
<ns0:blockId>3</ns0:blockId>
<ns0:parentBlockId>2</ns0:parentBlockId>
<ns0:parentBlock>BatchTotals</ns0:parentBlock>
<ns0:blockName>BatchDateLineItem</ns0:blockName>
<ns0:bodyId>2</ns0:bodyId>
<ns0:columnId>2</ns0:columnId>
<ns0:columnName>BatchStartReference</ns0:columnName>
<ns0:columnType>STRING</ns0:columnType>
<ns0:columnData>001666</ns0:columnData>
</ns0:OcsBatchView>
<ns0:OcsBatchView>
<ns0:batchId>1</ns0:batchId>
<ns0:headerId>1</ns0:headerId>
<ns0:blockId>3</ns0:blockId>
<ns0:parentBlockId>2</ns0:parentBlockId>
<ns0:parentBlock>BatchTotals</ns0:parentBlock>
<ns0:blockName>BatchDateLineItem</ns0:blockName>
<ns0:bodyId>2</ns0:bodyId>
<ns0:columnId>3</ns0:columnId>
<ns0:columnName>GrossValue</ns0:columnName>
<ns0:columnType>STRING</ns0:columnType>
<ns0:columnData>67.50</ns0:columnData>
</ns0:OcsBatchView>
<ns0:OcsBatchView>
<ns0:batchId>1</ns0:batchId>
<ns0:headerId>1</ns0:headerId>
<ns0:blockId>3</ns0:blockId>
<ns0:parentBlockId>2</ns0:parentBlockId>
<ns0:parentBlock>BatchTotals</ns0:parentBlock>
<ns0:blockName>BatchDateLineItem</ns0:blockName>
<ns0:bodyId>2</ns0:bodyId>
<ns0:columnId>4</ns0:columnId>
<ns0:columnName>Adjustment</ns0:columnName>
<ns0:columnType>STRING</ns0:columnType>
<ns0:columnData>0.00</ns0:columnData>
</ns0:OcsBatchView>
<ns0:OcsBatchView>
<ns0:batchId>1</ns0:batchId>
<ns0:headerId>1</ns0:headerId>
<ns0:blockId>3</ns0:blockId>
<ns0:parentBlockId>2</ns0:parentBlockId>
<ns0:parentBlock>BatchTotals</ns0:parentBlock>
<ns0:blockName>BatchDateLineItem</ns0:blockName>
<ns0:bodyId>2</ns0:bodyId>
<ns0:columnId>5</ns0:columnId>
<ns0:columnName>NetValue</ns0:columnName>
<ns0:columnType>STRING</ns0:columnType>
<ns0:columnData>67.50</ns0:columnData>
</ns0:OcsBatchView>
<ns0:OcsBatchView>
<ns0:batchId>1</ns0:batchId>
<ns0:headerId>1</ns0:headerId>
<ns0:blockId>4</ns0:blockId>
<ns0:parentBlockId>1</ns0:parentBlockId>
<ns0:parentBlock>ChargesSummary</ns0:parentBlock>
<ns0:blockName>CardsAcquiredByOtherAcquirer</ns0:blockName>
<ns0:bodyId>1</ns0:bodyId>
<ns0:columnId>1</ns0:columnId>
<ns0:columnName/>
<ns0:columnType>STRING</ns0:columnType>
<ns0:columnData/>
</ns0:OcsBatchView>
<ns0:OcsBatchView>
<ns0:batchId>1</ns0:batchId>
<ns0:headerId>1</ns0:headerId>
<ns0:blockId>4</ns0:blockId>
<ns0:parentBlockId>1</ns0:parentBlockId>
<ns0:parentBlock>ChargesSummary</ns0:parentBlock>
<ns0:blockName>CardsAcquiredByOtherAcquirer</ns0:blockName>
<ns0:bodyId>1</ns0:bodyId>
<ns0:columnId>2</ns0:columnId>
<ns0:columnName>TotalCount</ns0:columnName>
<ns0:columnType>STRING</ns0:columnType>
<ns0:columnData>860</ns0:columnData>
</ns0:OcsBatchView>
<ns0:OcsBatchView>
<ns0:batchId>1</ns0:batchId>
<ns0:headerId>1</ns0:headerId>
<ns0:blockId>4</ns0:blockId>
<ns0:parentBlockId>1</ns0:parentBlockId>
<ns0:parentBlock>ChargesSummary</ns0:parentBlock>
<ns0:blockName>CardsAcquiredByOtherAcquirer</ns0:blockName>
<ns0:bodyId>1</ns0:bodyId>
<ns0:columnId>3</ns0:columnId>
<ns0:columnName>TotalCharges</ns0:columnName>
<ns0:columnType>STRING</ns0:columnType>
<ns0:columnData>3016.94</ns0:columnData>
</ns0:OcsBatchView>
<ns0:OcsBatchView>
<ns0:batchId>1</ns0:batchId>
<ns0:headerId>1</ns0:headerId>
<ns0:blockId>4</ns0:blockId>
<ns0:parentBlockId>1</ns0:parentBlockId>
<ns0:parentBlock>ChargesSummary</ns0:parentBlock>
<ns0:blockName>CardsAcquiredByOtherAcquirer</ns0:blockName>
<ns0:bodyId>1</ns0:bodyId>
<ns0:columnId>4</ns0:columnId>
<ns0:columnName>TotalValue</ns0:columnName>
<ns0:columnType>STRING</ns0:columnType>
<ns0:columnData>36818.95</ns0:columnData>
</ns0:OcsBatchView>
<ns0:OcsBatchView>
<ns0:batchId>1</ns0:batchId>
<ns0:headerId>1</ns0:headerId>
<ns0:blockId>5</ns0:blockId>
<ns0:parentBlockId>4</ns0:parentBlockId>
<ns0:parentBlock>CardsAcquiredByOtherAcquirer</ns0:parentBlock>
<ns0:blockName>CardType</ns0:blockName>
<ns0:bodyId>1</ns0:bodyId>
<ns0:columnId>1</ns0:columnId>
<ns0:columnName>CardTypeName</ns0:columnName>
<ns0:columnType>STRING</ns0:columnType>
<ns0:columnData>Other Acquirer1</ns0:columnData>
</ns0:OcsBatchView>
<ns0:OcsBatchView>
<ns0:batchId>1</ns0:batchId>
<ns0:headerId>1</ns0:headerId>
<ns0:blockId>6</ns0:blockId>
<ns0:parentBlockId>5</ns0:parentBlockId>
<ns0:parentBlock>CardType</ns0:parentBlock>
<ns0:blockName>CardTypeTotal</ns0:blockName>
<ns0:bodyId>1</ns0:bodyId>
<ns0:columnId>1</ns0:columnId>
<ns0:columnName>CardTypeCount</ns0:columnName>
<ns0:columnType>STRING</ns0:columnType>
<ns0:columnData>19</ns0:columnData>
</ns0:OcsBatchView>
<ns0:OcsBatchView>
<ns0:batchId>1</ns0:batchId>
<ns0:headerId>1</ns0:headerId>
<ns0:blockId>6</ns0:blockId>
<ns0:parentBlockId>5</ns0:parentBlockId>
<ns0:parentBlock>CardType</ns0:parentBlock>
<ns0:blockName>CardTypeTotal</ns0:blockName>
<ns0:bodyId>1</ns0:bodyId>
<ns0:columnId>2</ns0:columnId>
<ns0:columnName>ChargePerTransaction</ns0:columnName>
<ns0:columnType>STRING</ns0:columnType>
<ns0:columnData/>
</ns0:OcsBatchView>
<ns0:OcsBatchView>
<ns0:batchId>1</ns0:batchId>
<ns0:headerId>1</ns0:headerId>
<ns0:blockId>6</ns0:blockId>
<ns0:parentBlockId>5</ns0:parentBlockId>
<ns0:parentBlock>CardType</ns0:parentBlock>
<ns0:blockName>CardTypeTotal</ns0:blockName>
<ns0:bodyId>1</ns0:bodyId>
<ns0:columnId>3</ns0:columnId>
<ns0:columnName>ValueOfTransactions</ns0:columnName>
<ns0:columnType>STRING</ns0:columnType>
<ns0:columnData/>
</ns0:OcsBatchView>
<ns0:OcsBatchView>
<ns0:batchId>1</ns0:batchId>
<ns0:headerId>1</ns0:headerId>
<ns0:blockId>6</ns0:blockId>
<ns0:parentBlockId>5</ns0:parentBlockId>
<ns0:parentBlock>CardType</ns0:parentBlock>
<ns0:blockName>CardTypeTotal</ns0:blockName>
<ns0:bodyId>1</ns0:bodyId>
<ns0:columnId>4</ns0:columnId>
<ns0:columnName>TransactionChargeRate</ns0:columnName>
<ns0:columnType>STRING</ns0:columnType>
<ns0:columnData/>
</ns0:OcsBatchView>
<ns0:OcsBatchView>
<ns0:batchId>1</ns0:batchId>
<ns0:headerId>1</ns0:headerId>
<ns0:blockId>6</ns0:blockId>
<ns0:parentBlockId>5</ns0:parentBlockId>
<ns0:parentBlock>CardType</ns0:parentBlock>
<ns0:blockName>CardTypeTotal</ns0:blockName>
<ns0:bodyId>1</ns0:bodyId>
<ns0:columnId>5</ns0:columnId>
<ns0:columnName>CardTypeTotalCharges</ns0:columnName>
<ns0:columnType>STRING</ns0:columnType>
<ns0:columnData>64.20</ns0:columnData>
</ns0:OcsBatchView>
<ns0:OcsBatchView>
<ns0:batchId>1</ns0:batchId>
<ns0:headerId>1</ns0:headerId>
<ns0:blockId>6</ns0:blockId>
<ns0:parentBlockId>5</ns0:parentBlockId>
<ns0:parentBlock>CardType</ns0:parentBlock>
<ns0:blockName>CardTypeTotal</ns0:blockName>
<ns0:bodyId>1</ns0:bodyId>
<ns0:columnId>6</ns0:columnId>
<ns0:columnName>VATCode</ns0:columnName>
<ns0:columnType>STRING</ns0:columnType>
<ns0:columnData/>
</ns0:OcsBatchView>
<ns0:OcsBatchView>
<ns0:batchId>1</ns0:batchId>
<ns0:headerId>1</ns0:headerId>
<ns0:blockId>7</ns0:blockId>
<ns0:parentBlockId>5</ns0:parentBlockId>
<ns0:parentBlock>CardType</ns0:parentBlock>
<ns0:blockName>Transaction</ns0:blockName>
<ns0:bodyId>1</ns0:bodyId>
<ns0:columnId>1</ns0:columnId>
<ns0:columnName>TransactionCategory</ns0:columnName>
<ns0:columnType>STRING</ns0:columnType>
<ns0:columnData>Purchases</ns0:columnData>
</ns0:OcsBatchView>
<ns0:OcsBatchView>
<ns0:batchId>1</ns0:batchId>
<ns0:headerId>1</ns0:headerId>
<ns0:blockId>7</ns0:blockId>
<ns0:parentBlockId>5</ns0:parentBlockId>
<ns0:parentBlock>CardType</ns0:parentBlock>
<ns0:blockName>Transaction</ns0:blockName>
<ns0:bodyId>1</ns0:bodyId>
<ns0:columnId>2</ns0:columnId>
<ns0:columnName>NumberOfTransactions</ns0:columnName>
<ns0:columnType>STRING</ns0:columnType>
<ns0:columnData>7</ns0:columnData>
</ns0:OcsBatchView>
<ns0:OcsBatchView>
<ns0:batchId>1</ns0:batchId>
<ns0:headerId>1</ns0:headerId>
<ns0:blockId>7</ns0:blockId>
<ns0:parentBlockId>5</ns0:parentBlockId>
<ns0:parentBlock>CardType</ns0:parentBlock>
<ns0:blockName>Transaction</ns0:blockName>
<ns0:bodyId>1</ns0:bodyId>
<ns0:columnId>3</ns0:columnId>
<ns0:columnName>ChargePerTransaction</ns0:columnName>
<ns0:columnType>STRING</ns0:columnType>
<ns0:columnData/>
</ns0:OcsBatchView>
<ns0:OcsBatchView>
<ns0:batchId>1</ns0:batchId>
<ns0:headerId>1</ns0:headerId>
<ns0:blockId>7</ns0:blockId>
<ns0:parentBlockId>5</ns0:parentBlockId>
<ns0:parentBlock>CardType</ns0:parentBlock>
<ns0:blockName>Transaction</ns0:blockName>
<ns0:bodyId>1</ns0:bodyId>
<ns0:columnId>4</ns0:columnId>
<ns0:columnName>ValueOfTransactions</ns0:columnName>
<ns0:columnType>STRING</ns0:columnType>
<ns0:columnData>1205.54</ns0:columnData>
</ns0:OcsBatchView>
<ns0:OcsBatchView>
<ns0:batchId>1</ns0:batchId>
<ns0:headerId>1</ns0:headerId>
<ns0:blockId>7</ns0:blockId>
<ns0:parentBlockId>5</ns0:parentBlockId>
<ns0:parentBlock>CardType</ns0:parentBlock>
<ns0:blockName>Transaction</ns0:blockName>
<ns0:bodyId>1</ns0:bodyId>
<ns0:columnId>5</ns0:columnId>
<ns0:columnName>TransactionChargeRate</ns0:columnName>
<ns0:columnType>STRING</ns0:columnType>
<ns0:columnData>3.00%</ns0:columnData>
</ns0:OcsBatchView>
<ns0:OcsBatchView>
<ns0:batchId>1</ns0:batchId>
<ns0:headerId>1</ns0:headerId>
<ns0:blockId>7</ns0:blockId>
<ns0:parentBlockId>5</ns0:parentBlockId>
<ns0:parentBlock>CardType</ns0:parentBlock>
<ns0:blockName>Transaction</ns0:blockName>
<ns0:bodyId>1</ns0:bodyId>
<ns0:columnId>6</ns0:columnId>
<ns0:columnName>TransactionCharges</ns0:columnName>
<ns0:columnType>STRING</ns0:columnType>
<ns0:columnData>36.17</ns0:columnData>
</ns0:OcsBatchView>
<ns0:OcsBatchView>
<ns0:batchId>1</ns0:batchId>
<ns0:headerId>1</ns0:headerId>
<ns0:blockId>7</ns0:blockId>
<ns0:parentBlockId>5</ns0:parentBlockId>
<ns0:parentBlock>CardType</ns0:parentBlock>
<ns0:blockName>Transaction</ns0:blockName>
<ns0:bodyId>1</ns0:bodyId>
<ns0:columnId>7</ns0:columnId>
<ns0:columnName>VATCode</ns0:columnName>
<ns0:columnType>STRING</ns0:columnType>
<ns0:columnData>E</ns0:columnData>
</ns0:OcsBatchView>
<ns0:OcsBatchView>
<ns0:batchId>1</ns0:batchId>
<ns0:headerId>1</ns0:headerId>
<ns0:blockId>7</ns0:blockId>
<ns0:parentBlockId>5</ns0:parentBlockId>
<ns0:parentBlock>CardType</ns0:parentBlock>
<ns0:blockName>Transaction</ns0:blockName>
<ns0:bodyId>2</ns0:bodyId>
<ns0:columnId>1</ns0:columnId>
<ns0:columnName>TransactionCategory</ns0:columnName>
<ns0:columnType>STRING</ns0:columnType>
<ns0:columnData>Premium Charges</ns0:columnData>
</ns0:OcsBatchView>
<ns0:OcsBatchView>
<ns0:batchId>1</ns0:batchId>
<ns0:headerId>1</ns0:headerId>
<ns0:blockId>7</ns0:blockId>
<ns0:parentBlockId>5</ns0:parentBlockId>
<ns0:parentBlock>CardType</ns0:parentBlock>
<ns0:blockName>Transaction</ns0:blockName>
<ns0:bodyId>2</ns0:bodyId>
<ns0:columnId>2</ns0:columnId>
<ns0:columnName>NumberOfTransactions</ns0:columnName>
<ns0:columnType>STRING</ns0:columnType>
<ns0:columnData/>
</ns0:OcsBatchView>
<ns0:OcsBatchView>
<ns0:batchId>1</ns0:batchId>
<ns0:headerId>1</ns0:headerId>
<ns0:blockId>7</ns0:blockId>
<ns0:parentBlockId>5</ns0:parentBlockId>
<ns0:parentBlock>CardType</ns0:parentBlock>
<ns0:blockName>Transaction</ns0:blockName>
<ns0:bodyId>2</ns0:bodyId>
<ns0:columnId>3</ns0:columnId>
<ns0:columnName>ChargePerTransaction</ns0:columnName>
<ns0:columnType>STRING</ns0:columnType>
<ns0:columnData/>
</ns0:OcsBatchView>
<ns0:OcsBatchView>
<ns0:batchId>1</ns0:batchId>
<ns0:headerId>1</ns0:headerId>
<ns0:blockId>7</ns0:blockId>
<ns0:parentBlockId>5</ns0:parentBlockId>
<ns0:parentBlock>CardType</ns0:parentBlock>
<ns0:blockName>Transaction</ns0:blockName>
<ns0:bodyId>2</ns0:bodyId>
<ns0:columnId>4</ns0:columnId>
<ns0:columnName>ValueOfTransactions</ns0:columnName>
<ns0:columnType>STRING</ns0:columnType>
<ns0:columnData/>
</ns0:OcsBatchView>
<ns0:OcsBatchView>
<ns0:batchId>1</ns0:batchId>
<ns0:headerId>1</ns0:headerId>
<ns0:blockId>7</ns0:blockId>
<ns0:parentBlockId>5</ns0:parentBlockId>
<ns0:parentBlock>CardType</ns0:parentBlock>
<ns0:blockName>Transaction</ns0:blockName>
<ns0:bodyId>2</ns0:bodyId>
<ns0:columnId>5</ns0:columnId>
<ns0:columnName>TransactionChargeRate</ns0:columnName>
<ns0:columnType>STRING</ns0:columnType>
<ns0:columnData/>
</ns0:OcsBatchView>
<ns0:OcsBatchView>
<ns0:batchId>1</ns0:batchId>
<ns0:headerId>1</ns0:headerId>
<ns0:blockId>7</ns0:blockId>
<ns0:parentBlockId>5</ns0:parentBlockId>
<ns0:parentBlock>CardType</ns0:parentBlock>
<ns0:blockName>Transaction</ns0:blockName>
<ns0:bodyId>2</ns0:bodyId>
<ns0:columnId>6</ns0:columnId>
<ns0:columnName>TransactionCharges</ns0:columnName>
<ns0:columnType>STRING</ns0:columnType>
<ns0:columnData>9.64</ns0:columnData>
</ns0:OcsBatchView>
<ns0:OcsBatchView>
<ns0:batchId>1</ns0:batchId>
<ns0:headerId>1</ns0:headerId>
<ns0:blockId>7</ns0:blockId>
<ns0:parentBlockId>5</ns0:parentBlockId>
<ns0:parentBlock>CardType</ns0:parentBlock>
<ns0:blockName>Transaction</ns0:blockName>
<ns0:bodyId>2</ns0:bodyId>
<ns0:columnId>7</ns0:columnId>
<ns0:columnName>VATCode</ns0:columnName>
<ns0:columnType>STRING</ns0:columnType>
<ns0:columnData/>
</ns0:OcsBatchView>
<ns0:OcsBatchView>
<ns0:batchId>1</ns0:batchId>
<ns0:headerId>1</ns0:headerId>
<ns0:blockId>8</ns0:blockId>
<ns0:parentBlockId>1</ns0:parentBlockId>
<ns0:parentBlock>ChargesSummary</ns0:parentBlock>
<ns0:blockName>CardsAcquiredByUS</ns0:blockName>
<ns0:bodyId>1</ns0:bodyId>
<ns0:columnId>1</ns0:columnId>
<ns0:columnName/>
<ns0:columnType>STRING</ns0:columnType>
<ns0:columnData/>
</ns0:OcsBatchView>
<ns0:OcsBatchView>
<ns0:batchId>1</ns0:batchId>
<ns0:headerId>1</ns0:headerId>
<ns0:blockId>8</ns0:blockId>
<ns0:parentBlockId>1</ns0:parentBlockId>
<ns0:parentBlock>ChargesSummary</ns0:parentBlock>
<ns0:blockName>CardsAcquiredByUS</ns0:blockName>
<ns0:bodyId>1</ns0:bodyId>
<ns0:columnId>2</ns0:columnId>
<ns0:columnName>TotalCount</ns0:columnName>
<ns0:columnType>STRING</ns0:columnType>
<ns0:columnData>860</ns0:columnData>
</ns0:OcsBatchView>
<ns0:OcsBatchView>
<ns0:batchId>1</ns0:batchId>
<ns0:headerId>1</ns0:headerId>
<ns0:blockId>8</ns0:blockId>
<ns0:parentBlockId>1</ns0:parentBlockId>
<ns0:parentBlock>ChargesSummary</ns0:parentBlock>
<ns0:blockName>CardsAcquiredByUS</ns0:blockName>
<ns0:bodyId>1</ns0:bodyId>
<ns0:columnId>3</ns0:columnId>
<ns0:columnName>TotalCharges</ns0:columnName>
<ns0:columnType>STRING</ns0:columnType>
<ns0:columnData>3016.94</ns0:columnData>
</ns0:OcsBatchView>
<ns0:OcsBatchView>
<ns0:batchId>1</ns0:batchId>
<ns0:headerId>1</ns0:headerId>
<ns0:blockId>8</ns0:blockId>
<ns0:parentBlockId>1</ns0:parentBlockId>
<ns0:parentBlock>ChargesSummary</ns0:parentBlock>
<ns0:blockName>CardsAcquiredByUS</ns0:blockName>
<ns0:bodyId>1</ns0:bodyId>
<ns0:columnId>4</ns0:columnId>
<ns0:columnName>TotalValue</ns0:columnName>
<ns0:columnType>STRING</ns0:columnType>
<ns0:columnData>36818.95</ns0:columnData>
</ns0:OcsBatchView>
<ns0:OcsBatchView>
<ns0:batchId>1</ns0:batchId>
<ns0:headerId>1</ns0:headerId>
<ns0:blockId>9</ns0:blockId>
<ns0:parentBlockId>8</ns0:parentBlockId>
<ns0:parentBlock>CardsAcquiredByUS</ns0:parentBlock>
<ns0:blockName>CardType</ns0:blockName>
<ns0:bodyId>1</ns0:bodyId>
<ns0:columnId>1</ns0:columnId>
<ns0:columnName>CardTypeName</ns0:columnName>
<ns0:columnType>STRING</ns0:columnType>
<ns0:columnData>MasterCard Credit</ns0:columnData>
</ns0:OcsBatchView>
<ns0:OcsBatchView>
<ns0:batchId>1</ns0:batchId>
<ns0:headerId>1</ns0:headerId>
<ns0:blockId>10</ns0:blockId>
<ns0:parentBlockId>9</ns0:parentBlockId>
<ns0:parentBlock>CardType</ns0:parentBlock>
<ns0:blockName>CardTypeTotal</ns0:blockName>
<ns0:bodyId>1</ns0:bodyId>
<ns0:columnId>1</ns0:columnId>
<ns0:columnName>CardTypeCount</ns0:columnName>
<ns0:columnType>STRING</ns0:columnType>
<ns0:columnData>25</ns0:columnData>
</ns0:OcsBatchView>
<ns0:OcsBatchView>
<ns0:batchId>1</ns0:batchId>
<ns0:headerId>1</ns0:headerId>
<ns0:blockId>10</ns0:blockId>
<ns0:parentBlockId>9</ns0:parentBlockId>
<ns0:parentBlock>CardType</ns0:parentBlock>
<ns0:blockName>CardTypeTotal</ns0:blockName>
<ns0:bodyId>1</ns0:bodyId>
<ns0:columnId>2</ns0:columnId>
<ns0:columnName>ChargePerTransaction</ns0:columnName>
<ns0:columnType>STRING</ns0:columnType>
<ns0:columnData/>
</ns0:OcsBatchView>
<ns0:OcsBatchView>
<ns0:batchId>1</ns0:batchId>
<ns0:headerId>1</ns0:headerId>
<ns0:blockId>10</ns0:blockId>
<ns0:parentBlockId>9</ns0:parentBlockId>
<ns0:parentBlock>CardType</ns0:parentBlock>
<ns0:blockName>CardTypeTotal</ns0:blockName>
<ns0:bodyId>1</ns0:bodyId>
<ns0:columnId>3</ns0:columnId>
<ns0:columnName>CardTypeTotalValue</ns0:columnName>
<ns0:columnType>STRING</ns0:columnType>
<ns0:columnData>124.76</ns0:columnData>
</ns0:OcsBatchView>
<ns0:OcsBatchView>
<ns0:batchId>1</ns0:batchId>
<ns0:headerId>1</ns0:headerId>
<ns0:blockId>10</ns0:blockId>
<ns0:parentBlockId>9</ns0:parentBlockId>
<ns0:parentBlock>CardType</ns0:parentBlock>
<ns0:blockName>CardTypeTotal</ns0:blockName>
<ns0:bodyId>1</ns0:bodyId>
<ns0:columnId>4</ns0:columnId>
<ns0:columnName>TransactionChargeRate</ns0:columnName>
<ns0:columnType>STRING</ns0:columnType>
<ns0:columnData>3.00%</ns0:columnData>
</ns0:OcsBatchView>
<ns0:OcsBatchView>
<ns0:batchId>1</ns0:batchId>
<ns0:headerId>1</ns0:headerId>
<ns0:blockId>10</ns0:blockId>
<ns0:parentBlockId>9</ns0:parentBlockId>
<ns0:parentBlock>CardType</ns0:parentBlock>
<ns0:blockName>CardTypeTotal</ns0:blockName>
<ns0:bodyId>1</ns0:bodyId>
<ns0:columnId>5</ns0:columnId>
<ns0:columnName>CardTypeTotalCharges</ns0:columnName>
<ns0:columnType>STRING</ns0:columnType>
<ns0:columnData>99,999,999.00</ns0:columnData>
</ns0:OcsBatchView>
<ns0:OcsBatchView>
<ns0:batchId>1</ns0:batchId>
<ns0:headerId>1</ns0:headerId>
<ns0:blockId>10</ns0:blockId>
<ns0:parentBlockId>9</ns0:parentBlockId>
<ns0:parentBlock>CardType</ns0:parentBlock>
<ns0:blockName>CardTypeTotal</ns0:blockName>
<ns0:bodyId>1</ns0:bodyId>
<ns0:columnId>7</ns0:columnId>
<ns0:columnName>VATCode</ns0:columnName>
<ns0:columnType>STRING</ns0:columnType>
<ns0:columnData/>
</ns0:OcsBatchView>
<ns0:OcsBatchView>
<ns0:batchId>1</ns0:batchId>
<ns0:headerId>1</ns0:headerId>
<ns0:blockId>11</ns0:blockId>
<ns0:parentBlockId>9</ns0:parentBlockId>
<ns0:parentBlock>CardType</ns0:parentBlock>
<ns0:blockName>Transaction</ns0:blockName>
<ns0:bodyId>1</ns0:bodyId>
<ns0:columnId>1</ns0:columnId>
<ns0:columnName>TransactionCategory</ns0:columnName>
<ns0:columnType>STRING</ns0:columnType>
<ns0:columnData>Purchases</ns0:columnData>
</ns0:OcsBatchView>
<ns0:OcsBatchView>
<ns0:batchId>1</ns0:batchId>
<ns0:headerId>1</ns0:headerId>
<ns0:blockId>11</ns0:blockId>
<ns0:parentBlockId>9</ns0:parentBlockId>
<ns0:parentBlock>CardType</ns0:parentBlock>
<ns0:blockName>Transaction</ns0:blockName>
<ns0:bodyId>1</ns0:bodyId>
<ns0:columnId>2</ns0:columnId>
<ns0:columnName>NumberOfTransactions</ns0:columnName>
<ns0:columnType>STRING</ns0:columnType>
<ns0:columnData>7</ns0:columnData>
</ns0:OcsBatchView>
<ns0:OcsBatchView>
<ns0:batchId>1</ns0:batchId>
<ns0:headerId>1</ns0:headerId>
<ns0:blockId>11</ns0:blockId>
<ns0:parentBlockId>9</ns0:parentBlockId>
<ns0:parentBlock>CardType</ns0:parentBlock>
<ns0:blockName>Transaction</ns0:blockName>
<ns0:bodyId>1</ns0:bodyId>
<ns0:columnId>3</ns0:columnId>
<ns0:columnName>ChargePerTransaction</ns0:columnName>
<ns0:columnType>STRING</ns0:columnType>
<ns0:columnData/>
</ns0:OcsBatchView>
<ns0:OcsBatchView>
<ns0:batchId>1</ns0:batchId>
<ns0:headerId>1</ns0:headerId>
<ns0:blockId>11</ns0:blockId>
<ns0:parentBlockId>9</ns0:parentBlockId>
<ns0:parentBlock>CardType</ns0:parentBlock>
<ns0:blockName>Transaction</ns0:blockName>
<ns0:bodyId>1</ns0:bodyId>
<ns0:columnId>4</ns0:columnId>
<ns0:columnName>ValueOfTransactions</ns0:columnName>
<ns0:columnType>STRING</ns0:columnType>
<ns0:columnData>1205.54</ns0:columnData>
</ns0:OcsBatchView>
<ns0:OcsBatchView>
<ns0:batchId>1</ns0:batchId>
<ns0:headerId>1</ns0:headerId>
<ns0:blockId>11</ns0:blockId>
<ns0:parentBlockId>9</ns0:parentBlockId>
<ns0:parentBlock>CardType</ns0:parentBlock>
<ns0:blockName>Transaction</ns0:blockName>
<ns0:bodyId>1</ns0:bodyId>
<ns0:columnId>5</ns0:columnId>
<ns0:columnName>TransactionChargeRate</ns0:columnName>
<ns0:columnType>STRING</ns0:columnType>
<ns0:columnData>3.00%</ns0:columnData>
</ns0:OcsBatchView>
<ns0:OcsBatchView>
<ns0:batchId>1</ns0:batchId>
<ns0:headerId>1</ns0:headerId>
<ns0:blockId>11</ns0:blockId>
<ns0:parentBlockId>9</ns0:parentBlockId>
<ns0:parentBlock>CardType</ns0:parentBlock>
<ns0:blockName>Transaction</ns0:blockName>
<ns0:bodyId>1</ns0:bodyId>
<ns0:columnId>6</ns0:columnId>
<ns0:columnName>TransactionsCharges</ns0:columnName>
<ns0:columnType>STRING</ns0:columnType>
<ns0:columnData>36.17</ns0:columnData>
</ns0:OcsBatchView>
<ns0:OcsBatchView>
<ns0:batchId>1</ns0:batchId>
<ns0:headerId>1</ns0:headerId>
<ns0:blockId>11</ns0:blockId>
<ns0:parentBlockId>9</ns0:parentBlockId>
<ns0:parentBlock>CardType</ns0:parentBlock>
<ns0:blockName>Transaction</ns0:blockName>
<ns0:bodyId>1</ns0:bodyId>
<ns0:columnId>7</ns0:columnId>
<ns0:columnName>VATCode</ns0:columnName>
<ns0:columnType>STRING</ns0:columnType>
<ns0:columnData>E</ns0:columnData>
</ns0:OcsBatchView>
<ns0:OcsBatchView>
<ns0:batchId>1</ns0:batchId>
<ns0:headerId>1</ns0:headerId>
<ns0:blockId>11</ns0:blockId>
<ns0:parentBlockId>9</ns0:parentBlockId>
<ns0:parentBlock>CardType</ns0:parentBlock>
<ns0:blockName>Transaction</ns0:blockName>
<ns0:bodyId>2</ns0:bodyId>
<ns0:columnId>1</ns0:columnId>
<ns0:columnName>TransactionCategory</ns0:columnName>
<ns0:columnType>STRING</ns0:columnType>
<ns0:columnData>Premium Charges</ns0:columnData>
</ns0:OcsBatchView>
<ns0:OcsBatchView>
<ns0:batchId>1</ns0:batchId>
<ns0:headerId>1</ns0:headerId>
<ns0:blockId>11</ns0:blockId>
<ns0:parentBlockId>9</ns0:parentBlockId>
<ns0:parentBlock>CardType</ns0:parentBlock>
<ns0:blockName>Transaction</ns0:blockName>
<ns0:bodyId>2</ns0:bodyId>
<ns0:columnId>2</ns0:columnId>
<ns0:columnName>NumberOfTransactions</ns0:columnName>
<ns0:columnType>STRING</ns0:columnType>
<ns0:columnData/>
</ns0:OcsBatchView>
<ns0:OcsBatchView>
<ns0:batchId>1</ns0:batchId>
<ns0:headerId>1</ns0:headerId>
<ns0:blockId>11</ns0:blockId>
<ns0:parentBlockId>9</ns0:parentBlockId>
<ns0:parentBlock>CardType</ns0:parentBlock>
<ns0:blockName>Transaction</ns0:blockName>
<ns0:bodyId>2</ns0:bodyId>
<ns0:columnId>3</ns0:columnId>
<ns0:columnName>ChargePerTransaction</ns0:columnName>
<ns0:columnType>STRING</ns0:columnType>
<ns0:columnData/>
</ns0:OcsBatchView>
<ns0:OcsBatchView>
<ns0:batchId>1</ns0:batchId>
<ns0:headerId>1</ns0:headerId>
<ns0:blockId>11</ns0:blockId>
<ns0:parentBlockId>9</ns0:parentBlockId>
<ns0:parentBlock>CardType</ns0:parentBlock>
<ns0:blockName>Transaction</ns0:blockName>
<ns0:bodyId>2</ns0:bodyId>
<ns0:columnId>4</ns0:columnId>
<ns0:columnName>ValueOfTransactions</ns0:columnName>
<ns0:columnType>STRING</ns0:columnType>
<ns0:columnData/>
</ns0:OcsBatchView>
<ns0:OcsBatchView>
<ns0:batchId>1</ns0:batchId>
<ns0:headerId>1</ns0:headerId>
<ns0:blockId>11</ns0:blockId>
<ns0:parentBlockId>9</ns0:parentBlockId>
<ns0:parentBlock>CardType</ns0:parentBlock>
<ns0:blockName>Transaction</ns0:blockName>
<ns0:bodyId>2</ns0:bodyId>
<ns0:columnId>5</ns0:columnId>
<ns0:columnName>TransactionChargeRate</ns0:columnName>
<ns0:columnType>STRING</ns0:columnType>
<ns0:columnData/>
</ns0:OcsBatchView>
<ns0:OcsBatchView>
<ns0:batchId>1</ns0:batchId>
<ns0:headerId>1</ns0:headerId>
<ns0:blockId>11</ns0:blockId>
<ns0:parentBlockId>9</ns0:parentBlockId>
<ns0:parentBlock>CardType</ns0:parentBlock>
<ns0:blockName>Transaction</ns0:blockName>
<ns0:bodyId>2</ns0:bodyId>
<ns0:columnId>6</ns0:columnId>
<ns0:columnName>TransactionsCharges</ns0:columnName>
<ns0:columnType>STRING</ns0:columnType>
<ns0:columnData>9.64</ns0:columnData>
</ns0:OcsBatchView>
<ns0:OcsBatchView>
<ns0:batchId>1</ns0:batchId>
<ns0:headerId>1</ns0:headerId>
<ns0:blockId>11</ns0:blockId>
<ns0:parentBlockId>9</ns0:parentBlockId>
<ns0:parentBlock>CardType</ns0:parentBlock>
<ns0:blockName>Transaction</ns0:blockName>
<ns0:bodyId>2</ns0:bodyId>
<ns0:columnId>7</ns0:columnId>
<ns0:columnName>VATCode</ns0:columnName>
<ns0:columnType>STRING</ns0:columnType>
<ns0:columnData/>
</ns0:OcsBatchView>
<ns0:OcsBatchView>
<ns0:batchId>1</ns0:batchId>
<ns0:headerId>1</ns0:headerId>
<ns0:blockId>12</ns0:blockId>
<ns0:parentBlockId>1</ns0:parentBlockId>
<ns0:parentBlock>ChargesSummary</ns0:parentBlock>
<ns0:blockName>MiscellaneousCharges</ns0:blockName>
<ns0:bodyId>1</ns0:bodyId>
<ns0:columnId>1</ns0:columnId>
<ns0:columnName/>
<ns0:columnType>STRING</ns0:columnType>
<ns0:columnData/>
</ns0:OcsBatchView>
<ns0:OcsBatchView>
<ns0:batchId>1</ns0:batchId>
<ns0:headerId>1</ns0:headerId>
<ns0:blockId>13</ns0:blockId>
<ns0:parentBlockId>12</ns0:parentBlockId>
<ns0:parentBlock>MiscellaneousCharges</ns0:parentBlock>
<ns0:blockName>MiscellaneousChargesLineItem</ns0:blockName>
<ns0:bodyId>1</ns0:bodyId>
<ns0:columnId>1</ns0:columnId>
<ns0:columnName>ChargeCategory</ns0:columnName>
<ns0:columnType>STRING</ns0:columnType>
<ns0:columnData>Terminal Rental</ns0:columnData>
</ns0:OcsBatchView>
<ns0:OcsBatchView>
<ns0:batchId>1</ns0:batchId>
<ns0:headerId>1</ns0:headerId>
<ns0:blockId>13</ns0:blockId>
<ns0:parentBlockId>12</ns0:parentBlockId>
<ns0:parentBlock>MiscellaneousCharges</ns0:parentBlock>
<ns0:blockName>MiscellaneousChargesLineItem</ns0:blockName>
<ns0:bodyId>1</ns0:bodyId>
<ns0:columnId>2</ns0:columnId>
<ns0:columnName>QuantityOrValue</ns0:columnName>
<ns0:columnType>STRING</ns0:columnType>
<ns0:columnData>45.00</ns0:columnData>
</ns0:OcsBatchView>
<ns0:OcsBatchView>
<ns0:batchId>1</ns0:batchId>
<ns0:headerId>1</ns0:headerId>
<ns0:blockId>13</ns0:blockId>
<ns0:parentBlockId>12</ns0:parentBlockId>
<ns0:parentBlock>MiscellaneousCharges</ns0:parentBlock>
<ns0:blockName>MiscellaneousChargesLineItem</ns0:blockName>
<ns0:bodyId>1</ns0:bodyId>
<ns0:columnId>3</ns0:columnId>
<ns0:columnName>ChargeRate</ns0:columnName>
<ns0:columnType>STRING</ns0:columnType>
<ns0:columnData>Per Quarter</ns0:columnData>
</ns0:OcsBatchView>
<ns0:OcsBatchView>
<ns0:batchId>1</ns0:batchId>
<ns0:headerId>1</ns0:headerId>
<ns0:blockId>13</ns0:blockId>
<ns0:parentBlockId>12</ns0:parentBlockId>
<ns0:parentBlock>MiscellaneousCharges</ns0:parentBlock>
<ns0:blockName>MiscellaneousChargesLineItem</ns0:blockName>
<ns0:bodyId>1</ns0:bodyId>
<ns0:columnId>4</ns0:columnId>
<ns0:columnName>ChargeAmount</ns0:columnName>
<ns0:columnType>STRING</ns0:columnType>
<ns0:columnData>45.0</ns0:columnData>
</ns0:OcsBatchView>
<ns0:OcsBatchView>
<ns0:batchId>1</ns0:batchId>
<ns0:headerId>1</ns0:headerId>
<ns0:blockId>13</ns0:blockId>
<ns0:parentBlockId>12</ns0:parentBlockId>
<ns0:parentBlock>MiscellaneousCharges</ns0:parentBlock>
<ns0:blockName>MiscellaneousChargesLineItem</ns0:blockName>
<ns0:bodyId>1</ns0:bodyId>
<ns0:columnId>5</ns0:columnId>
<ns0:columnName>VATCode</ns0:columnName>
<ns0:columnType>STRING</ns0:columnType>
<ns0:columnData>E</ns0:columnData>
</ns0:OcsBatchView>
<ns0:OcsBatchView>
<ns0:batchId>1</ns0:batchId>
<ns0:headerId>1</ns0:headerId>
<ns0:blockId>14</ns0:blockId>
<ns0:parentBlockId>1</ns0:parentBlockId>
<ns0:parentBlock>ChargesSummary</ns0:parentBlock>
<ns0:blockName>PremiumCharges</ns0:blockName>
<ns0:bodyId>1</ns0:bodyId>
<ns0:columnId>1</ns0:columnId>
<ns0:columnName/>
<ns0:columnType>STRING</ns0:columnType>
<ns0:columnData/>
</ns0:OcsBatchView>
<ns0:OcsBatchView>
<ns0:batchId>1</ns0:batchId>
<ns0:headerId>1</ns0:headerId>
<ns0:blockId>15</ns0:blockId>
<ns0:parentBlockId>14</ns0:parentBlockId>
<ns0:parentBlock>PremiumCharges</ns0:parentBlock>
<ns0:blockName>ChargeCategoryLineItem</ns0:blockName>
<ns0:bodyId>1</ns0:bodyId>
<ns0:columnId>1</ns0:columnId>
<ns0:columnName>ChargeCategory</ns0:columnName>
<ns0:columnType>STRING</ns0:columnType>
<ns0:columnData>Premium Cat1</ns0:columnData>
</ns0:OcsBatchView>
<ns0:OcsBatchView>
<ns0:batchId>1</ns0:batchId>
<ns0:headerId>1</ns0:headerId>
<ns0:blockId>15</ns0:blockId>
<ns0:parentBlockId>14</ns0:parentBlockId>
<ns0:parentBlock>PremiumCharges</ns0:parentBlock>
<ns0:blockName>ChargeCategoryLineItem</ns0:blockName>
<ns0:bodyId>1</ns0:bodyId>
<ns0:columnId>2</ns0:columnId>
<ns0:columnName>NumberOfTransactions</ns0:columnName>
<ns0:columnType>STRING</ns0:columnType>
<ns0:columnData>7</ns0:columnData>
</ns0:OcsBatchView>
<ns0:OcsBatchView>
<ns0:batchId>1</ns0:batchId>
<ns0:headerId>1</ns0:headerId>
<ns0:blockId>15</ns0:blockId>
<ns0:parentBlockId>14</ns0:parentBlockId>
<ns0:parentBlock>PremiumCharges</ns0:parentBlock>
<ns0:blockName>ChargeCategoryLineItem</ns0:blockName>
<ns0:bodyId>1</ns0:bodyId>
<ns0:columnId>3</ns0:columnId>
<ns0:columnName>ChargePerTransaction</ns0:columnName>
<ns0:columnType>STRING</ns0:columnType>
<ns0:columnData/>
</ns0:OcsBatchView>
<ns0:OcsBatchView>
<ns0:batchId>1</ns0:batchId>
<ns0:headerId>1</ns0:headerId>
<ns0:blockId>15</ns0:blockId>
<ns0:parentBlockId>14</ns0:parentBlockId>
<ns0:parentBlock>PremiumCharges</ns0:parentBlock>
<ns0:blockName>ChargeCategoryLineItem</ns0:blockName>
<ns0:bodyId>1</ns0:bodyId>
<ns0:columnId>4</ns0:columnId>
<ns0:columnName>ValueOfTransactions</ns0:columnName>
<ns0:columnType>STRING</ns0:columnType>
<ns0:columnData>1205.54</ns0:columnData>
</ns0:OcsBatchView>
<ns0:OcsBatchView>
<ns0:batchId>1</ns0:batchId>
<ns0:headerId>1</ns0:headerId>
<ns0:blockId>15</ns0:blockId>
<ns0:parentBlockId>14</ns0:parentBlockId>
<ns0:parentBlock>PremiumCharges</ns0:parentBlock>
<ns0:blockName>ChargeCategoryLineItem</ns0:blockName>
<ns0:bodyId>1</ns0:bodyId>
<ns0:columnId>5</ns0:columnId>
<ns0:columnName>TransactionChargeRate</ns0:columnName>
<ns0:columnType>STRING</ns0:columnType>
<ns0:columnData>3.00%</ns0:columnData>
</ns0:OcsBatchView>
<ns0:OcsBatchView>
<ns0:batchId>1</ns0:batchId>
<ns0:headerId>1</ns0:headerId>
<ns0:blockId>15</ns0:blockId>
<ns0:parentBlockId>14</ns0:parentBlockId>
<ns0:parentBlock>PremiumCharges</ns0:parentBlock>
<ns0:blockName>ChargeCategoryLineItem</ns0:blockName>
<ns0:bodyId>1</ns0:bodyId>
<ns0:columnId>6</ns0:columnId>
<ns0:columnName>TransactionsCharges</ns0:columnName>
<ns0:columnType>STRING</ns0:columnType>
<ns0:columnData>36.17</ns0:columnData>
</ns0:OcsBatchView>
<ns0:OcsBatchView>
<ns0:batchId>1</ns0:batchId>
<ns0:headerId>1</ns0:headerId>
<ns0:blockId>15</ns0:blockId>
<ns0:parentBlockId>14</ns0:parentBlockId>
<ns0:parentBlock>PremiumCharges</ns0:parentBlock>
<ns0:blockName>ChargeCategoryLineItem</ns0:blockName>
<ns0:bodyId>1</ns0:bodyId>
<ns0:columnId>7</ns0:columnId>
<ns0:columnName>VATCode</ns0:columnName>
<ns0:columnType>STRING</ns0:columnType>
<ns0:columnData>E</ns0:columnData>
</ns0:OcsBatchView>
<ns0:OcsBatchView>
<ns0:batchId>1</ns0:batchId>
<ns0:headerId>1</ns0:headerId>
<ns0:blockId>16</ns0:blockId>
<ns0:parentBlockId>1</ns0:parentBlockId>
<ns0:parentBlock>ChargesSummary</ns0:parentBlock>
<ns0:blockName>VATAnalysis</ns0:blockName>
<ns0:bodyId>1</ns0:bodyId>
<ns0:columnId>1</ns0:columnId>
<ns0:columnName>NetAmount</ns0:columnName>
<ns0:columnType>STRING</ns0:columnType>
<ns0:columnData>37.90</ns0:columnData>
</ns0:OcsBatchView>
<ns0:OcsBatchView>
<ns0:batchId>1</ns0:batchId>
<ns0:headerId>1</ns0:headerId>
<ns0:blockId>16</ns0:blockId>
<ns0:parentBlockId>1</ns0:parentBlockId>
<ns0:parentBlock>ChargesSummary</ns0:parentBlock>
<ns0:blockName>VATAnalysis</ns0:blockName>
<ns0:bodyId>1</ns0:bodyId>
<ns0:columnId>2</ns0:columnId>
<ns0:columnName>VATRate</ns0:columnName>
<ns0:columnType>STRING</ns0:columnType>
<ns0:columnData>17.5%</ns0:columnData>
</ns0:OcsBatchView>
<ns0:OcsBatchView>
<ns0:batchId>1</ns0:batchId>
<ns0:headerId>1</ns0:headerId>
<ns0:blockId>16</ns0:blockId>
<ns0:parentBlockId>1</ns0:parentBlockId>
<ns0:parentBlock>ChargesSummary</ns0:parentBlock>
<ns0:blockName>VATAnalysis</ns0:blockName>
<ns0:bodyId>1</ns0:bodyId>
<ns0:columnId>3</ns0:columnId>
<ns0:columnName>VATAmount</ns0:columnName>
<ns0:columnType>STRING</ns0:columnType>
<ns0:columnData>6.63</ns0:columnData>
</ns0:OcsBatchView>
<ns0:OcsBatchView>
<ns0:batchId>1</ns0:batchId>
<ns0:headerId>1</ns0:headerId>
<ns0:blockId>16</ns0:blockId>
<ns0:parentBlockId>1</ns0:parentBlockId>
<ns0:parentBlock>ChargesSummary</ns0:parentBlock>
<ns0:blockName>VATAnalysis</ns0:blockName>
<ns0:bodyId>1</ns0:bodyId>
<ns0:columnId>4</ns0:columnId>
<ns0:columnName>VATCode</ns0:columnName>
<ns0:columnType>STRING</ns0:columnType>
<ns0:columnData>S</ns0:columnData>
</ns0:OcsBatchView>
</arg0>


Output XML :

<generateResponse>
<return xsi:type="ns1:DocumentRequestType">
<ns1:ChargesSummary>
<ns1:TransactionCharges-CardsAcquiredByUS>451.29</ns1:TransactionCharges-CardsAcquiredByUS>
<ns1:TransactionCharges-CardsAcquiredByOtherAcquirers>0.0</ns1:TransactionCharges-CardsAcquiredByOtherAcquirers>
<ns1:PremiumChargesSummary>47.32</ns1:PremiumChargesSummary>
<ns1:MiscellaneousChargesSummary>37.90</ns1:MiscellaneousChargesSummary>
<ns1:ChargesSummaryTotalCharges>489.19</ns1:ChargesSummaryTotalCharges>
<ns1:VATAmount>6.63</ns1:VATAmount>
<ns1:TotalDue>495.82</ns1:TotalDue>
<ns1:AccountNumber>12345678</ns1:AccountNumber>
<ns1:BranchID>00-00-00</ns1:BranchID>
<ns1:ChargeDate-DDMonthYear>18 August 2010</ns1:ChargeDate-DDMonthYear>
<ns1:VATAnalysis>
<ns1:VATCode>S</ns1:VATCode>
<ns1:NetAmount>37.90</ns1:NetAmount>
<ns1:VATRate>17.5%</ns1:VATRate>
<ns1:VATAmount>6.63</ns1:VATAmount>
</ns1:VATAnalysis>
<ns1:CardsAcquiredByUS>
<ns1:CardType>
<ns1:CardTypeName>MasterCard Credit</ns1:CardTypeName>
<ns1:Transaction>
<ns1:TransactionCategory>Purchases</ns1:TransactionCategory>
<ns1:NumberOfTransactions>7</ns1:NumberOfTransactions>
<ns1:ValueOfTransactions>1205.54</ns1:ValueOfTransactions>
<ns1:TransactionChargeRate>3.00%</ns1:TransactionChargeRate>
<ns1:VATCode>E</ns1:VATCode>
</ns1:Transaction>
<ns1:Transaction>
<ns1:TransactionCategory>Premium Charges</ns1:TransactionCategory>
</ns1:Transaction>
<ns1:CardTypeTotal>
<ns1:CardTypeCount>25</ns1:CardTypeCount>
<ns1:CardTypeTotalValue>124.76</ns1:CardTypeTotalValue>
<ns1:CardTypeTotalCharges>99,999,999.00</ns1:CardTypeTotalCharges>
</ns1:CardTypeTotal>
</ns1:CardType>
<ns1:TotalCount>860</ns1:TotalCount>
<ns1:TotalValue>36818.95</ns1:TotalValue>
<ns1:TotalCharges>3016.94</ns1:TotalCharges>
</ns1:CardsAcquiredByUS>
<ns1:MiscellaneousCharges>
<ns1:MiscellaneousChargesLineItem>
<ns1:ChargeCategory>Terminal Rental</ns1:ChargeCategory>
<ns1:QuantityOrValue>45.00</ns1:QuantityOrValue>
<ns1:ChargeRate>Per Quarter</ns1:ChargeRate>
<ns1:ChargeAmount>45.0</ns1:ChargeAmount>
<ns1:VATCode>E</ns1:VATCode>
</ns1:MiscellaneousChargesLineItem>
</ns1:MiscellaneousCharges>
<ns1:BatchTotals>
<ns1:BatchDateLineItem>
<ns1:BatchDate>01 August 2010</ns1:BatchDate>
<ns1:BatchStartReference>001665</ns1:BatchStartReference>
<ns1:GrossValue>12.00</ns1:GrossValue>
<ns1:Adjustment>0.00</ns1:Adjustment>
<ns1:NetValue>12.00</ns1:NetValue>
</ns1:BatchDateLineItem>
<ns1:BatchDateLineItem>
<ns1:BatchDate>02 August 2010</ns1:BatchDate>
<ns1:BatchStartReference>001666</ns1:BatchStartReference>
<ns1:GrossValue>67.50</ns1:GrossValue>
<ns1:Adjustment>0.00</ns1:Adjustment>
<ns1:NetValue>67.50</ns1:NetValue>
</ns1:BatchDateLineItem>
</ns1:BatchTotals>
<ns1:PremiumCharges>
<ns1:ChargeCategoryLineItem>
<ns1:ChargeCategory>Premium Cat1</ns1:ChargeCategory>
<ns1:NumberOfTransactions>7</ns1:NumberOfTransactions>
<ns1:ValueOfTransactions>1205.54</ns1:ValueOfTransactions>
<ns1:TransactionChargeRate>3.00%</ns1:TransactionChargeRate>
<ns1:TransactionsCharges>36.17</ns1:TransactionsCharges>
<ns1:VATCode>E</ns1:VATCode>
</ns1:ChargeCategoryLineItem>
</ns1:PremiumCharges>
</ns1:ChargesSummary>
</return>
</generateResponse>

Any help is appreciated .

Thanks in advance.

Lakshmi


 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Help Needed !!