<!--                                                                  -->
<!--  Copyright (C) 2006 RoyaltyShare, Inc.   All Rights Reserved     -->
<!--  $Id$  -->
<!--                                                                  -->
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0" xmlns:dyn="http://exslt.org/dynamic" extension-element-prefixes="dyn">
    <xsl:output method="text" indent="no" />

    <xsl:variable name="allItems" select="/Root/Statement/MechanicalStatement/MechanicalStatementPublisherList/MechanicalStatementPublisher/MechanicalStatementTrackList/MechanicalStatementTrack/MechanicalStatementLicenseList/MechanicalStatementLicense/MechanicalStatementItemList/MechanicalStatementItem" />
    <xsl:variable name="lcletters">abcdefghijklmnopqrstuvwxyz</xsl:variable>
    <xsl:variable name="ucletters">ABCDEFGHIJKLMNOPQRSTUVWXYZ</xsl:variable>

    <xsl:template match="Root">
        LINE COUNT<xsl:text>&#009;</xsl:text><xsl:value-of select="Statement/MechanicalStatement/NumLines" /><xsl:text>&#009;</xsl:text>PHYSICAL SALES<xsl:text>&#009;</xsl:text><xsl:value-of select="Statement/MechanicalStatement/PhysicalSubtotal" /><xsl:text>&#009;</xsl:text>DIGITAL SALES<xsl:text>&#009;</xsl:text><xsl:value-of select="Statement/MechanicalStatement/DigitalSubtotal" /><xsl:text>&#xA;</xsl:text>
        M #<xsl:text>&#009;</xsl:text>TRANSACTION DATE<xsl:text>&#009;</xsl:text>PAY PERIOD<xsl:text>&#009;</xsl:text>HFA LICENSE<xsl:text>&#009;</xsl:text>CAT #<xsl:text>&#009;</xsl:text>ISRC<xsl:text>&#009;</xsl:text>UPC<xsl:text>&#009;</xsl:text>DIGITAL/PHYSICAL FLAG<xsl:text>&#009;</xsl:text>CONFIGURATION CODE<xsl:text>&#009;</xsl:text>SALES CHANNEL<xsl:text>&#009;</xsl:text>SONG TITLE<xsl:text>&#009;</xsl:text>PUB NAME<xsl:text>&#009;</xsl:text>SPLIT<xsl:text>&#009;</xsl:text>UNITS<xsl:text>&#009;</xsl:text>UNITS TO DATE<xsl:text>&#009;</xsl:text>RATE<xsl:text>&#009;</xsl:text>AMOUNT<xsl:text>&#009;</xsl:text>AMOUNT TO DATE<xsl:text>&#009;</xsl:text>ADVANCE<xsl:text>&#009;</xsl:text>BALANCE FORWARD<xsl:text>&#009;</xsl:text>SERVICE<xsl:text>&#xA;</xsl:text>
        <xsl:for-each select="$allItems">
            <xsl:value-of select="/Root/Statement/MechanicalStatement/ManufacturerNumber" /><xsl:text>&#009;</xsl:text><xsl:value-of select="/Root/Statement/MechanicalStatement/TransactionDate" /><xsl:text>&#009;</xsl:text><xsl:value-of select="ReportingPeriod" /><xsl:text>&#009;</xsl:text><xsl:value-of select="TrackLicense/IssuerLicenseID" /><xsl:text>&#009;</xsl:text><xsl:value-of select="../../../../CatalogNumber" /><xsl:text>&#009;</xsl:text><xsl:value-of select="../../../../ISRC" /><xsl:text>&#009;</xsl:text><xsl:value-of select="UPC" /><xsl:text>&#009;</xsl:text><xsl:variable name="productTypeID" select="ProductTypeID" /><xsl:variable name="productDescription" select="/Root/Statement/TypeList/Type[ProductTypeID = $productTypeID]/Description" /><xsl:choose><xsl:when test="$productDescription = 'D' or $productDescription = 'DT'">D</xsl:when><xsl:otherwise>P</xsl:otherwise></xsl:choose><xsl:text>&#009;</xsl:text><xsl:value-of select="$productDescription" /><xsl:text>&#009;</xsl:text><xsl:text>&#009;</xsl:text><xsl:value-of select="translate(../../../../SongTitle,$lcletters,$ucletters)" /><xsl:text>&#009;</xsl:text><xsl:value-of select="../../../../../../Publisher/PublisherName" /><xsl:text>&#009;</xsl:text><xsl:value-of select="TrackLicense/Share" /><xsl:text>&#009;</xsl:text><xsl:value-of select="NetUnits" /><xsl:text>&#009;</xsl:text><xsl:text>&#009;</xsl:text><xsl:value-of select="NetRate" /><xsl:text>&#009;</xsl:text><xsl:value-of select="AmountPaid" /><xsl:text>&#009;</xsl:text><xsl:text>&#009;</xsl:text><xsl:value-of select="../../PreviousAdvanceBalance" /><xsl:text>&#009;</xsl:text><xsl:value-of select="../../AdvanceBalance" /><xsl:text>&#009;</xsl:text><xsl:text>&#xA;</xsl:text>
        </xsl:for-each>
    </xsl:template>

</xsl:stylesheet>