<?xml version="1.0"?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:template match="/">

<xsl:for-each select="/STATE/STATEHDR/RECORD">
<table border="0" width="100%" style="border-style: none; background-color:white; margin-left: 000">
  <tr bgcolor="#000099">-
  </tr>
  <tr bgcolor="#FFFFFF">
    
    <td style="border-style:none; text-align:left"><font face="Arial, Helvetica, sans-serif" size="4" color="#990000"><b>Customer Totals for <xsl:value-of select="TEXT" />&#160;</b></font> </td>
  </tr>
  <tr bgcolor="#FFFFFF">
    
    <td style="text-align:left; border-style:none"><font face="Arial, Helvetica, sans-serif" size="2" color="#000000"><i>As of <xsl:value-of select="RUNDATE" />  <xsl:value-of select="RUNTIME" />&#160;</i></font> </td>
  </tr>
</table><br/>

<table border="0" width="550" style="border-style:none; background-color:white; margin-left: 025"  cellpadding="8" cellspacing="0">
<tr bgcolor="#FFFFFF">
<font face="Arial, Helvetica, sans-serif" size="2" color="#000000">Now you can present your iSeries data on the Web almost any way you can imagine using the <b>SEQUEL Web Interface's</b> Extensible Markup Language (<b>XML</b>) and Extensible Stylesheet Language (<b>XSL</b>) support features.  With a single XSL (style sheet), it's possible to include XML data results from multiple SEQUEL views, graphics, hyperlinks and text on a results page.</font></tr>
</table><br/>

<xsl:for-each select="/STATE/STATETTL/RECORD">
<table border="0" style="border-style:none; background-color:white; margin-left: 025" width="550" cellpadding="4" cellspacing="0" bordercolordark="#ffffff" bordercolorlight="#FFFFFF">
  <tr bgcolor="#990000"> 
    <th colspan="2" style="border-style:none; text-align:left"><font face="Arial, Helvetica, sans-serif" size="2" color="#ffffff"><b><xsl:value-of select="/STATE/STATEHDR/RECORD/text" /> - Summary 
      Totals</b></font></th>
    <th style="border-style:none; text-align:right" bgcolor="#FFFFFF" colspan="1" rowspan="6"><xsl:element name="image"> <xsl:attribute name="src"><xsl:value-of select="/STATE/STATEHDR/RECORD/MAPFILE" /></xsl:attribute></xsl:element>
    </th>
  </tr>
  <tr bgcolor="#FFFFCC"> 
    <td width="120" style="border-style:none; text-align:left"><font face="Arial, Helvetica, sans-serif" size="2" color="#000000">Total Customers</font></td>
    <td width="90" style="border-style:none; text-align:right"><font face="Arial, Helvetica, sans-serif" size="2" color="#000000"><xsl:value-of select="TOTAL" /></font> 
    </td>
  </tr>
  <tr bgcolor="#FFFFCC"> 
    <td style="border-style:none; text-align:left"><font face="Arial, Helvetica, sans-serif" size="2" color="#000000">Average Credit Limit</font> </td>
    <td style="border-style:none; text-align:right"><font face="Arial, Helvetica, sans-serif" size="2" color="#000000"><xsl:eval>STATETTLavgcrlim(this)</xsl:eval></font></td>
  </tr>
  <tr bgcolor="#FFFFCC"> 
    <td style="border-style:none; text-align:left"><font face="Arial, Helvetica, sans-serif" size="2" color="#000000">Total 
      Amount Due</font></td>
    <td style="border-style:none; text-align:right"><font face="Arial, Helvetica, sans-serif" size="2" color="#000000"><xsl:eval>STATETTLsumamtdu(this)</xsl:eval></font> 
    </td>
  </tr>
  <tr bgcolor="#FFFFCC"> 
    <td style="border-style:none; text-align:left"><font face="Arial, Helvetica, sans-serif" size="2" color="#000000">Total 
      Open Order Amount</font> </td>
    <td style="border-style:none; text-align:right"><font face="Arial, Helvetica, sans-serif" size="2" color="#000000"><xsl:eval>STATETTLsumoropn(this)</xsl:eval></font> 
    </td>
  </tr>
  <tr bgcolor="#FFFFCC"> 
    <td style="border-style:none; text-align:left"><font face="Arial, Helvetica, sans-serif" size="2" color="#000000">Total 
      High Balance Amount</font> </td>
    <td style="border-style:none; text-align:right"><font face="Arial, Helvetica, sans-serif" size="2" color="#000000"><xsl:eval>STATETTLsumhighb(this)</xsl:eval></font> 
    </td>
  </tr>
</table><br/>



<table border="0" style="border-style:none; background-color:#990000; margin-left:025" cellpadding="6" cellspacing="0" bordercolorlight="#FFFFFF" bordercolordark="#990000">
  <tr bgcolor="#990000" colspan="9">
<th colspan="2" style="border-style:none; text-align:left"><font face="Arial, Helvetica, sans-serif" size="2" color="#ffffff"><b><xsl:value-of select="/STATE/STATEHDR/RECORD/text" /> - Detail by Customer</b></font></th> 
  </tr>
<tr bgcolor="#990000" valign="bottom"> 
    <th style="border-style:none; text-align:left"><font face="Arial, Helvetica, sans-serif" size="1" color="#FFFFFF">Customer<br/>Number</font></th>
    <th style="border-style:none; text-align:left"><font face="Arial, Helvetica, sans-serif" size="1" color="#FFFFFF">Name</font></th>
    <th style="border-style:none; text-align:left"><font face="Arial, Helvetica, sans-serif" size="1" color="#FFFFFF">City</font></th>
    <th style="border-style:none; text-align:left"><font face="Arial, Helvetica, sans-serif" size="1" color="#FFFFFF">State</font></th>
    <th style="border-style:none; text-align:right"><font face="Arial, Helvetica, sans-serif" size="1" color="#FFFFFF">Telephone</font></th>
    <th style="border-style:none; text-align:right"><font face="Arial, Helvetica, sans-serif" size="1" color="#FFFFFF">Credit<br/>Limit</font></th>
    <th style="border-style:none; text-align:right"><font face="Arial, Helvetica, sans-serif" size="1" color="#FFFFFF">Current<br/>Balance<br/>Due</font></th>
    <th style="border-style:none; text-align:right"><font face="Arial, Helvetica, sans-serif" size="1" color="#FFFFFF">Open<br/>Order<br/>Amount</font></th>
    <th style="border-style:none; text-align:right"><font face="Arial, Helvetica, sans-serif" size="1" color="#FFFFFF">Highest<br/>A/R<br/>Amount</font></th>
  </tr>
  <xsl:for-each select="/STATE/STATEDTL/RECORD"> 
  <tr bgcolor="#FFFFCC"> 
    <td style="border-style:none; text-align:left"><font face="Arial, Helvetica, sans-serif" size="1"><xsl:eval>STATEDTLcusno(this)</xsl:eval> 
      </font></td>
    <td style="border-style:none; text-align:left"><font face="Arial, Helvetica, sans-serif" size="1"><xsl:value-of select="CNAME" />&#160; 
      </font></td>
    <td style="border-style:none; text-align:left"><font face="Arial, Helvetica, sans-serif" size="1"><xsl:value-of select="CADD3" />&#160; 
      </font></td>
    <td style="border-style:none; text-align:left"><font face="Arial, Helvetica, sans-serif" size="1"><xsl:value-of select="CSTTE" />&#160; 
      </font></td>
    <td style="border-style:none; text-align:right"><font face="Arial, Helvetica, sans-serif" size="1"><xsl:eval>STATEDTLcphon(this)</xsl:eval> 
      </font></td>
    <td style="border-style:none; text-align:right"><font face="Arial, Helvetica, sans-serif" size="1"><xsl:eval>STATEDTLcrlim(this)</xsl:eval> 
      </font></td>
    <td style="border-style:none; text-align:right"><font face="Arial, Helvetica, sans-serif" size="1"><xsl:eval>STATEDTLamtdu(this)</xsl:eval> 
      </font></td>
    <td style="border-style:none; text-align:right"><font face="Arial, Helvetica, sans-serif" size="1"><xsl:eval>STATEDTLoropn(this)</xsl:eval> 
      </font></td>
    <td style="border-style:none; text-align:right"><font face="Arial, Helvetica, sans-serif" size="1"><xsl:eval>STATEDTLhighb(this)</xsl:eval> 
      </font></td>
  </tr>
  </xsl:for-each> 
</table><br/>
<table width="600" style="background-color:white; margin-left:025"  border="0" cellspacing="0" cellpadding="0">
  <tr> 
    <td> 
      
    </td>
  </tr>
</table>





</xsl:for-each>
</xsl:for-each>
</xsl:template>
<xsl:script><![CDATA[
function STATETTLavgcrlim(record)
{
var x = record.selectSingleNode("AVGCRLIM").nodeTypedValue;
return formatNumber(x,"###,##0;-###,##0");
}
function STATETTLsumamtdu(record)
{
var x = record.selectSingleNode("SUMAMTDU").nodeTypedValue;
return formatNumber(x,"###,##0;-###,##0");
}
function STATETTLsumoropn(record)
{
var x = record.selectSingleNode("SUMOROPN").nodeTypedValue;
return formatNumber(x,"###,##0;-###,##0");
}
function STATETTLsumhighb(record)
{
var x = record.selectSingleNode("SUMHIGHB").nodeTypedValue;
return formatNumber(x,"###,##0;-###,##0");
}
function STATEDTLcusno(record)
{
var x = record.selectSingleNode("CUSNO").nodeTypedValue;
return formatNumber(x,"#####0;#####0");
}
function STATEDTLcphon(record)
{
var x = record.selectSingleNode("CPHON").nodeTypedValue;
return formatNumber(x,"###/###-####");
}
function STATEDTLcrlim(record)
{
var x = record.selectSingleNode("CRLIM").nodeTypedValue;
return formatNumber(x,"###,###,##0;-###,###,##0");
}
function STATEDTLamtdu(record)
{
var x = record.selectSingleNode("AMTDU").nodeTypedValue;
return formatNumber(x,"###,###,##0;-###,###,##0");
}
function STATEDTLoropn(record)
{
var x = record.selectSingleNode("OROPN").nodeTypedValue;
return formatNumber(x,"#,###,##0;-#,###,##0");
}
function STATEDTLhighb(record)
{
var x = record.selectSingleNode("HIGHB").nodeTypedValue;
return formatNumber(x,"###,###,##0;-###,###,##0");
}
]]></xsl:script>
</xsl:stylesheet><!-- Stylus Studio meta-information - (c)1998-2004. Sonic Software Corporation. All rights reserved.
<metaInformation>
<scenarios ><scenario default="yes" name="Scenario1" userelativepaths="yes" externalpreview="no" url="state.xml" htmlbaseurl="" outputurl="" processortype="internal" profilemode="0" profiledepth="" profilelength="" urlprofilexml="" commandline="" additionalpath="" additionalclasspath="" postprocessortype="none" postprocesscommandline="" postprocessadditionalpath="" postprocessgeneratedext=""/></scenarios><MapperMetaTag><MapperInfo srcSchemaPathIsRelative="yes" srcSchemaInterpretAsXML="no" destSchemaPath="" destSchemaRoot="" destSchemaPathIsRelative="yes" destSchemaInterpretAsXML="no"/><MapperBlockPosition></MapperBlockPosition></MapperMetaTag>
</metaInformation>
-->