<!--                                                                  -->
<!--  Copyright (C) 2006 RoyaltyShare, Inc.   All Rights Reserved     -->
<!--  $Id$  -->
<!--                                                                  -->
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0">

    <xsl:variable name="currencyCode" select="/Root/Client/Locale/CurrencyFormat/CurrencyCode" />
    <xsl:variable name="currencySymbol" select="/Root/Client/Locale/CurrencyFormat/Symbol" />
    <xsl:variable name="thousands" select="/Root/Client/Locale/NumericFormat/Thousands" />

    <xsl:template name="showLayout">
        <xsl:call-template name="showHeader" />
        <xsl:for-each select="ArtistRoyaltyRun/ArtistRoyaltyStatementList/ArtistStatement">
            <xsl:call-template name="showLine" />
        </xsl:for-each>
    </xsl:template>

    <xsl:template name="showHeader">
        <xsl:text>Payee</xsl:text>
        <xsl:value-of select="$tab" />

        <xsl:text>Client #</xsl:text>
        <xsl:value-of select="$tab" />

        <xsl:if test="/Root/CustomReport = 1">
            <xsl:text>Account ID (Abacus)</xsl:text>
            <xsl:value-of select="$tab" />

            <xsl:text>Contract ID (Abacus)</xsl:text>
            <xsl:value-of select="$tab" />
        </xsl:if>

        <xsl:text>RS Payee ID</xsl:text>
        <xsl:value-of select="$tab" />

        <xsl:text>Previous Balance (</xsl:text><xsl:value-of select="$currencyCode" /><xsl:text>)</xsl:text>
        <xsl:value-of select="$tab" />

        <xsl:text>Transaction Total (</xsl:text><xsl:value-of select="$currencyCode" /><xsl:text>)</xsl:text>
        <xsl:value-of select="$tab" />

        <xsl:if test="/Root/CustomReport = 1">

            <xsl:text>Net Sales Total (</xsl:text><xsl:value-of select="$currencyCode" /><xsl:text>)</xsl:text>
            <xsl:value-of select="$tab" />

            <xsl:text>Total (</xsl:text><xsl:value-of select="$currencyCode" /><xsl:text>)</xsl:text>
            <xsl:value-of select="$tab" />

            <xsl:text>License Income Sales Total (</xsl:text><xsl:value-of select="$currencyCode" /><xsl:text>)</xsl:text>
            <xsl:value-of select="$tab" />

            <xsl:text>License Income Total (</xsl:text><xsl:value-of select="$currencyCode" /><xsl:text>)</xsl:text>
            <xsl:value-of select="$tab" />

            <xsl:text>Expense Amount Total (</xsl:text><xsl:value-of select="$currencyCode" /><xsl:text>)</xsl:text>
            <xsl:value-of select="$tab" />

            <xsl:text>Expense Effective Amount Total (</xsl:text><xsl:value-of select="$currencyCode" /><xsl:text>)</xsl:text>
            <xsl:value-of select="$tab" />

        </xsl:if>

        <xsl:text>Unrecouped Crossed Album Total (</xsl:text><xsl:value-of select="$currencyCode" /><xsl:text>)</xsl:text>
        <xsl:value-of select="$tab" />

        <xsl:text>Payable Crossed Album Total (</xsl:text><xsl:value-of select="$currencyCode" /><xsl:text>)</xsl:text>
        <xsl:value-of select="$tab" />

        <xsl:text>Unrecouped Uncrossed Album Total (</xsl:text><xsl:value-of select="$currencyCode" /><xsl:text>)</xsl:text>
        <xsl:value-of select="$tab" />

        <xsl:text>Payable Uncrossed Album Royalties (</xsl:text><xsl:value-of select="$currencyCode" /><xsl:text>)</xsl:text>
        <xsl:value-of select="$tab" />

        <xsl:text>Payable Period Royalties (</xsl:text><xsl:value-of select="$currencyCode" /><xsl:text>)</xsl:text>
        <xsl:value-of select="$tab" />

        <xsl:text>Ending Balance (</xsl:text><xsl:value-of select="$currencyCode" /><xsl:text>)</xsl:text>
        <xsl:value-of select="$tab" />

        <xsl:text>Minimum Payment (</xsl:text><xsl:value-of select="$currencyCode" /><xsl:text>)</xsl:text>
        <xsl:value-of select="$tab" />

        <xsl:text>Total Amount Payable (</xsl:text><xsl:value-of select="$currencyCode" /><xsl:text>)</xsl:text>
        <xsl:value-of select="$newLine" />
    </xsl:template>

    <xsl:template name="showLine">
        <xsl:value-of select="ArtistPayee/Name" />
        <xsl:value-of select="$tab" />

        <xsl:value-of select="ArtistPayee/ClientAccountID" />
        <xsl:value-of select="$tab" />

        <xsl:if test="/Root/CustomReport = 1">
            <xsl:value-of select="ArtistPayee/AbacusAccountID" />
            <xsl:value-of select="$tab" />

            <xsl:value-of select="ArtistPayee/AbacusContractID" />
            <xsl:value-of select="$tab" />
        </xsl:if>

        <xsl:value-of select="ArtistPayee/ArtistPayeeID" />
        <xsl:value-of select="$tab" />

        <xsl:call-template name="cleanNumber">
            <xsl:with-param name="number" select="PreviousBalance" />
        </xsl:call-template>
        <xsl:value-of select="$tab" />

        <xsl:call-template name="cleanNumber">
            <xsl:with-param name="number" select="TransactionSubtotal" />
        </xsl:call-template>
        <xsl:value-of select="$tab" />

        <xsl:if test="/Root/CustomReport = 1">

            <xsl:call-template name="cleanNumber">
                <xsl:with-param name="number" select="NetSalesTotal" />
            </xsl:call-template>
            <xsl:value-of select="$tab" />

            <xsl:call-template name="cleanNumber">
                <xsl:with-param name="number" select="SalesTotal" />
            </xsl:call-template>
            <xsl:value-of select="$tab" />

            <xsl:call-template name="cleanNumber">
                <xsl:with-param name="number" select="LicenseIncomeSalesTotal" />
            </xsl:call-template>
            <xsl:value-of select="$tab" />

            <xsl:call-template name="cleanNumber">
                <xsl:with-param name="number" select="LicenseIncomeTotal" />
            </xsl:call-template>
            <xsl:value-of select="$tab" />

            <xsl:call-template name="cleanNumber">
                <xsl:with-param name="number" select="ExpenseAmountTotal" />
            </xsl:call-template>
            <xsl:value-of select="$tab" />

            <xsl:call-template name="cleanNumber">
                <xsl:with-param name="number" select="ExpenseEffectiveAmountTotal" />
            </xsl:call-template>
            <xsl:value-of select="$tab" />

        </xsl:if>

        <!-- unrecouped crossed album total -->
        <xsl:call-template name="cleanNumber">
            <xsl:with-param name="number" select="UnrecoupedCrossedSubTotal" />
        </xsl:call-template>
        <xsl:value-of select="$tab" />

        <!-- payable crossed album royalties -->
        <xsl:call-template name="cleanNumber">
            <xsl:with-param name="number" select="PayableCrossedSubTotal" />
        </xsl:call-template>
        <xsl:value-of select="$tab" />

        <!-- unrecouped uncrossed album total -->
        <xsl:call-template name="cleanNumber">
            <xsl:with-param name="number" select="UnrecoupedUncrossedSubTotal" />
        </xsl:call-template>
        <xsl:value-of select="$tab" />

        <!-- payable uncrossed album royalties -->
        <xsl:call-template name="cleanNumber">
            <xsl:with-param name="number" select="PayableUncrossedSubTotal" />
        </xsl:call-template>
        <xsl:value-of select="$tab" />

        <xsl:call-template name="cleanNumber">
            <xsl:with-param name="number" select="Total" />
        </xsl:call-template>
        <xsl:value-of select="$tab" />

        <xsl:choose>
            <xsl:when test="translate(Balance, translate(Balance,'0123456789', ''), '') = 0 and translate(AmountDue, translate(AmountDue,'0123456789', ''), '') &gt; 0">
                <xsl:call-template name="cleanNumber">
                    <xsl:with-param name="number" select="AmountDue" />
                </xsl:call-template>
            </xsl:when>
            <xsl:otherwise>
                <xsl:call-template name="cleanNumber">
                    <xsl:with-param name="number" select="Balance" />
                </xsl:call-template>
            </xsl:otherwise>
        </xsl:choose>
        <xsl:value-of select="$tab" />

        <xsl:call-template name="cleanNumber">
            <xsl:with-param name="number" select="MinPayment" />
        </xsl:call-template>
        <xsl:value-of select="$tab" />

        <xsl:choose>
            <xsl:when test="OnHold = 1">ON-HOLD</xsl:when>
            <xsl:otherwise>
                <xsl:call-template name="cleanNumber">
                    <xsl:with-param name="number" select="AmountDue" />
                </xsl:call-template>
            </xsl:otherwise>
        </xsl:choose>
        <xsl:value-of select="$newLine" />
    </xsl:template>

    <xsl:template name="cleanNumber">
        <xsl:param name="number" />
        <xsl:value-of select="translate(translate($number,$currencySymbol,''),$thousands,'')" />
    </xsl:template>


</xsl:stylesheet>