<?xml version="1.0" encoding="UTF-8"?>
<report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.22" id="1">
    <property name="comments">IBM Confidential

OCO Source Materials

5724-M19

(C) COPYRIGHT IBM CORP. 2006

The source code for this program is not published or otherwise
divested of its trade secrets, irrespective of what has been
deposited with the U.S. Copyright Office.

09-19764@000</property>
    <property name="createdBy">Eclipse BIRT Designer Version 3.7.1.v20110905 Build &lt;3.7.1.v20110913-1734></property>
    <html-property name="description">This template will create a report having a single header with multiple rows of data.</html-property>
    <property name="units">in</property>
    <method name="initialize"><![CDATA[importPackage(Packages.com.ibm.tivoli.maximo.report.script);

var mxReportScriptContext = MXReportScriptContext.initialize(reportContext);

mxReportScriptContext.setDefaultLogLevel("DEBUG");
mxReportScriptContext.setDefaultLogFile("D:/temp/birtlogs/consiapp.log");

scriptLogger = mxReportScriptContext.getReportScriptLogger();

//Variable where we stock the content of a table (table based on dataSetAddress)
var htmlTableAdress = "";
var cpVilleCli = "";
var contactFrss = "";

var htmlSiteId = "";

//Retrieve the userid from Maximo Context in order to retrieve the user name (in the database) 
var userid = null;
var userid = reportContext.getHttpServletRequest().getParameter("userName");

//Variable pour stocker le username
var htmlTableUserName = "";]]></method>
    <method name="beforeFactory"><![CDATA[// Remove page break intervals from PDF output
if ( (reportContext.getParameterValue("usepagebreaks") == "false")|| reportContext.getOutputFormat() == "pdf" ) {
	// Give each table in the report a name, and add the names to the list below, e.g. ["mainTable", "childTable1"]
	var tableListing = ["mainTable"];
	for each(var tableName in tableListing) {
		var table = reportContext.getReportRunnable().designHandle.getDesignHandle().findElement(tableName)
		if (table != null)
		{
			table.setProperty("pageBreakInterval", 0);
		}
	}
}]]></method>
    <method name="afterFactory"><![CDATA[MXReportScriptContext.close();]]></method>
    <property name="theme">MaximoSystemLibrary.maximoTheme</property>
    <text-property name="displayName">Tivoli Maximo Portrait List Template</text-property>
    <property name="layoutPreference">auto layout</property>
    <property name="bidiLayoutOrientation">ltr</property>
    <property name="imageDPI">96</property>
    <list-property name="libraries">
        <structure>
            <property name="fileName">MaximoSystemLibrary.rptlibrary</property>
            <property name="namespace">MaximoSystemLibrary</property>
        </structure>
    </list-property>
    <parameters>
        <scalar-parameter name="where" id="25">
            <property name="valueType">static</property>
            <property name="isRequired">false</property>
            <property name="dataType">string</property>
            <property name="distinct">true</property>
            <simple-property-list name="defaultValue">
                <value type="constant">po.ponum='AL15013314'</value>
            </simple-property-list>
            <list-property name="selectionList"/>
            <property name="paramType">simple</property>
            <property name="controlType">text-box</property>
            <structure name="format">
                <property name="category">Unformatted</property>
            </structure>
        </scalar-parameter>
        <scalar-parameter name="appname" id="200">
            <property name="valueType">static</property>
            <property name="isRequired">false</property>
            <property name="dataType">string</property>
            <property name="controlType">text-box</property>
            <structure name="format">
                <property name="category">Unformatted</property>
            </structure>
        </scalar-parameter>
        <scalar-parameter name="paramdelimiter" id="202">
            <property name="hidden">true</property>
            <property name="valueType">static</property>
            <property name="isRequired">false</property>
            <property name="dataType">string</property>
            <property name="controlType">text-box</property>
            <structure name="format">
                <property name="category">Unformatted</property>
            </structure>
        </scalar-parameter>
        <scalar-parameter name="paramstring" id="201">
            <property name="hidden">true</property>
            <property name="valueType">static</property>
            <property name="isRequired">false</property>
            <property name="dataType">string</property>
            <property name="controlType">text-box</property>
            <structure name="format">
                <property name="category">Unformatted</property>
            </structure>
        </scalar-parameter>
        <scalar-parameter name="usepagebreaks" id="342">
            <property name="hidden">true</property>
            <property name="valueType">static</property>
            <property name="isRequired">false</property>
            <property name="dataType">string</property>
            <property name="distinct">true</property>
            <simple-property-list name="defaultValue">
                <value type="constant">true</value>
            </simple-property-list>
            <property name="paramType">simple</property>
            <property name="controlType">text-box</property>
            <structure name="format">
                <property name="category">Unformatted</property>
            </structure>
        </scalar-parameter>
    </parameters>
    <data-sources>
        <script-data-source name="maximoDataSource" id="64" extends="MaximoSystemLibrary.maximoDataSource"/>
    </data-sources>
    <data-sets>
        <script-data-set name="PODataSet" id="5">
            <list-property name="resultSetHints">
                <structure>
                    <property name="position">1</property>
                    <property name="name">poid</property>
                    <property name="dataType">integer</property>
                </structure>
                <structure>
                    <property name="position">2</property>
                    <property name="name">CA_ponum</property>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="position">3</property>
                    <property name="name">CA_originalponum</property>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="position">4</property>
                    <property name="name">CA_potype</property>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="position">5</property>
                    <property name="name">CA_postatus</property>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="position">6</property>
                    <property name="name">billto</property>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="position">7</property>
                    <property name="name">revisionnum</property>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="position">8</property>
                    <property name="name">CA_siteid</property>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="position">9</property>
                    <property name="name">CA_orgid</property>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="position">10</property>
                    <property name="name">CA_purchaseagent</property>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="position">11</property>
                    <property name="name">CA_podescription</property>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="position">12</property>
                    <property name="name">CA_poldkey</property>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="position">13</property>
                    <property name="name">CA_paymentterms</property>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="position">14</property>
                    <property name="name">CA_freightterms</property>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="position">15</property>
                    <property name="name">CA_poclause</property>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="position">16</property>
                    <property name="name">CA_shipvia</property>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="position">17</property>
                    <property name="name">CA_billto</property>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="position">18</property>
                    <property name="name">CA_shipto</property>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="position">19</property>
                    <property name="name">CA_po8</property>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="position">20</property>
                    <property name="name">CA_totalcost</property>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="position">21</property>
                    <property name="name">CA_tax1</property>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="position">22</property>
                    <property name="name">CA_tax2</property>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="position">23</property>
                    <property name="name">CA_tax3</property>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="position">24</property>
                    <property name="name">CA_tax4</property>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="position">25</property>
                    <property name="name">CA_tax5</property>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="position">26</property>
                    <property name="name">CA_currencycode</property>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="position">27</property>
                    <property name="name">CA_bc_original</property>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="position">28</property>
                    <property name="name">CA_status</property>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="position">29</property>
                    <property name="name">CA_datebegin</property>
                    <property name="dataType">date-time</property>
                </structure>
                <structure>
                    <property name="position">30</property>
                    <property name="name">CA_dateend</property>
                    <property name="dataType">date-time</property>
                </structure>
                <structure>
                    <property name="position">31</property>
                    <property name="name">CA_statusdate</property>
                    <property name="dataType">date-time</property>
                </structure>
                <structure>
                    <property name="position">32</property>
                    <property name="name">CA_actdate</property>
                    <property name="dataType">date-time</property>
                </structure>
                <structure>
                    <property name="position">33</property>
                    <property name="name">CA_namesfour</property>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="position">34</property>
                    <property name="name">CA_contactfour</property>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="position">35</property>
                    <property name="name">CA_address1four</property>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="position">36</property>
                    <property name="name">CA_co10four</property>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="position">37</property>
                    <property name="name">CA_co11four</property>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="position">38</property>
                    <property name="name">CA_cpfour</property>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="position">39</property>
                    <property name="name">CA_villefour</property>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="position">40</property>
                    <property name="name">CA_paysnomfour</property>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="position">41</property>
                    <property name="name">CA_vendorfour</property>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="position">42</property>
                    <property name="name">CA_phonefour</property>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="position">43</property>
                    <property name="name">CA_faxfour</property>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="position">44</property>
                    <property name="name">CA_email</property>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="position">45</property>
                    <property name="name">CA_co14four</property>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="position">46</property>
                    <property name="name">CA_address3four</property>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="position">47</property>
                    <property name="name">CA_namesCli</property>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="position">48</property>
                    <property name="name">CA_address1Cli</property>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="position">49</property>
                    <property name="name">CA_co10Cli</property>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="position">50</property>
                    <property name="name">CA_co11Cli</property>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="position">51</property>
                    <property name="name">CA_cpCli</property>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="position">52</property>
                    <property name="name">CA_villeCli</property>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="position">53</property>
                    <property name="name">CA_paysCli</property>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="position">54</property>
                    <property name="name">CA_address2Cli</property>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="position">55</property>
                    <property name="name">CA_shippointdesc</property>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="position">56</property>
                    <property name="name">CA_maxvaluestatus</property>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="position">57</property>
                    <property name="name">descStatus</property>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="position">58</property>
                    <property name="name">potypeStatus</property>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="position">59</property>
                    <property name="name">CA_maxtype</property>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="position">60</property>
                    <property name="name">CA_maxtypedesc</property>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="position">61</property>
                    <property name="name">CA_originaltype</property>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="position">62</property>
                    <property name="name">nbLig</property>
                    <property name="dataType">integer</property>
                </structure>
                <structure>
                    <property name="position">63</property>
                    <property name="name">CA_shippointname</property>
                    <property name="dataType">string</property>
                </structure>
            </list-property>
            <list-property name="columnHints">
                <structure>
                    <property name="columnName">poid</property>
                </structure>
                <structure>
                    <property name="columnName">CA_ponum</property>
                </structure>
                <structure>
                    <property name="columnName">CA_originalponum</property>
                </structure>
                <structure>
                    <property name="columnName">CA_potype</property>
                </structure>
                <structure>
                    <property name="columnName">CA_postatus</property>
                </structure>
                <structure>
                    <property name="columnName">billto</property>
                </structure>
                <structure>
                    <property name="columnName">revisionnum</property>
                </structure>
                <structure>
                    <property name="columnName">CA_siteid</property>
                </structure>
                <structure>
                    <property name="columnName">CA_orgid</property>
                </structure>
                <structure>
                    <property name="columnName">CA_purchaseagent</property>
                </structure>
                <structure>
                    <property name="columnName">CA_podescription</property>
                </structure>
                <structure>
                    <property name="columnName">CA_poldkey</property>
                </structure>
                <structure>
                    <property name="columnName">CA_paymentterms</property>
                </structure>
                <structure>
                    <property name="columnName">CA_freightterms</property>
                </structure>
                <structure>
                    <property name="columnName">CA_poclause</property>
                </structure>
                <structure>
                    <property name="columnName">CA_shipvia</property>
                </structure>
                <structure>
                    <property name="columnName">CA_billto</property>
                </structure>
                <structure>
                    <property name="columnName">CA_shipto</property>
                </structure>
                <structure>
                    <property name="columnName">CA_po8</property>
                </structure>
                <structure>
                    <property name="columnName">CA_totalcost</property>
                </structure>
                <structure>
                    <property name="columnName">CA_tax1</property>
                </structure>
                <structure>
                    <property name="columnName">CA_tax2</property>
                </structure>
                <structure>
                    <property name="columnName">CA_tax3</property>
                </structure>
                <structure>
                    <property name="columnName">CA_tax4</property>
                </structure>
                <structure>
                    <property name="columnName">CA_tax5</property>
                </structure>
                <structure>
                    <property name="columnName">CA_currencycode</property>
                </structure>
                <structure>
                    <property name="columnName">CA_bc_original</property>
                </structure>
                <structure>
                    <property name="columnName">CA_status</property>
                </structure>
                <structure>
                    <property name="columnName">CA_datebegin</property>
                </structure>
                <structure>
                    <property name="columnName">CA_dateend</property>
                </structure>
                <structure>
                    <property name="columnName">CA_statusdate</property>
                </structure>
                <structure>
                    <property name="columnName">CA_actdate</property>
                </structure>
                <structure>
                    <property name="columnName">CA_namesfour</property>
                </structure>
                <structure>
                    <property name="columnName">CA_contactfour</property>
                </structure>
                <structure>
                    <property name="columnName">CA_address1four</property>
                </structure>
                <structure>
                    <property name="columnName">CA_co10four</property>
                </structure>
                <structure>
                    <property name="columnName">CA_co11four</property>
                </structure>
                <structure>
                    <property name="columnName">CA_cpfour</property>
                </structure>
                <structure>
                    <property name="columnName">CA_villefour</property>
                </structure>
                <structure>
                    <property name="columnName">CA_paysnomfour</property>
                </structure>
                <structure>
                    <property name="columnName">CA_vendorfour</property>
                </structure>
                <structure>
                    <property name="columnName">CA_phonefour</property>
                </structure>
                <structure>
                    <property name="columnName">CA_faxfour</property>
                </structure>
                <structure>
                    <property name="columnName">CA_email</property>
                </structure>
                <structure>
                    <property name="columnName">CA_co14four</property>
                </structure>
                <structure>
                    <property name="columnName">CA_address3four</property>
                </structure>
                <structure>
                    <property name="columnName">CA_namesCli</property>
                </structure>
                <structure>
                    <property name="columnName">CA_address1Cli</property>
                </structure>
                <structure>
                    <property name="columnName">CA_co10Cli</property>
                </structure>
                <structure>
                    <property name="columnName">CA_co11Cli</property>
                </structure>
                <structure>
                    <property name="columnName">CA_cpCli</property>
                </structure>
                <structure>
                    <property name="columnName">CA_villeCli</property>
                </structure>
                <structure>
                    <property name="columnName">CA_paysCli</property>
                </structure>
                <structure>
                    <property name="columnName">CA_address2Cli</property>
                </structure>
                <structure>
                    <property name="columnName">CA_shippointdesc</property>
                </structure>
                <structure>
                    <property name="columnName">CA_maxvaluestatus</property>
                </structure>
                <structure>
                    <property name="columnName">descStatus</property>
                </structure>
                <structure>
                    <property name="columnName">potypeStatus</property>
                </structure>
                <structure>
                    <property name="columnName">CA_maxtype</property>
                </structure>
                <structure>
                    <property name="columnName">CA_maxtypedesc</property>
                </structure>
                <structure>
                    <property name="columnName">CA_originaltype</property>
                </structure>
                <structure>
                    <property name="columnName">nbLig</property>
                </structure>
                <structure>
                    <property name="columnName">CA_shippointname</property>
                </structure>
            </list-property>
            <structure name="cachedMetaData">
                <list-property name="resultSet">
                    <structure>
                        <property name="position">1</property>
                        <property name="name">poid</property>
                        <property name="dataType">integer</property>
                    </structure>
                    <structure>
                        <property name="position">2</property>
                        <property name="name">CA_ponum</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">3</property>
                        <property name="name">CA_originalponum</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">4</property>
                        <property name="name">CA_potype</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">5</property>
                        <property name="name">CA_postatus</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">6</property>
                        <property name="name">billto</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">7</property>
                        <property name="name">revisionnum</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">8</property>
                        <property name="name">CA_siteid</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">9</property>
                        <property name="name">CA_orgid</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">10</property>
                        <property name="name">CA_purchaseagent</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">11</property>
                        <property name="name">CA_podescription</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">12</property>
                        <property name="name">CA_poldkey</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">13</property>
                        <property name="name">CA_paymentterms</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">14</property>
                        <property name="name">CA_freightterms</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">15</property>
                        <property name="name">CA_poclause</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">16</property>
                        <property name="name">CA_shipvia</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">17</property>
                        <property name="name">CA_billto</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">18</property>
                        <property name="name">CA_shipto</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">19</property>
                        <property name="name">CA_po8</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">20</property>
                        <property name="name">CA_totalcost</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">21</property>
                        <property name="name">CA_tax1</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">22</property>
                        <property name="name">CA_tax2</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">23</property>
                        <property name="name">CA_tax3</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">24</property>
                        <property name="name">CA_tax4</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">25</property>
                        <property name="name">CA_tax5</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">26</property>
                        <property name="name">CA_currencycode</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">27</property>
                        <property name="name">CA_bc_original</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">28</property>
                        <property name="name">CA_status</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">29</property>
                        <property name="name">CA_datebegin</property>
                        <property name="dataType">date-time</property>
                    </structure>
                    <structure>
                        <property name="position">30</property>
                        <property name="name">CA_dateend</property>
                        <property name="dataType">date-time</property>
                    </structure>
                    <structure>
                        <property name="position">31</property>
                        <property name="name">CA_statusdate</property>
                        <property name="dataType">date-time</property>
                    </structure>
                    <structure>
                        <property name="position">32</property>
                        <property name="name">CA_actdate</property>
                        <property name="dataType">date-time</property>
                    </structure>
                    <structure>
                        <property name="position">33</property>
                        <property name="name">CA_namesfour</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">34</property>
                        <property name="name">CA_contactfour</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">35</property>
                        <property name="name">CA_address1four</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">36</property>
                        <property name="name">CA_co10four</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">37</property>
                        <property name="name">CA_co11four</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">38</property>
                        <property name="name">CA_cpfour</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">39</property>
                        <property name="name">CA_villefour</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">40</property>
                        <property name="name">CA_paysnomfour</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">41</property>
                        <property name="name">CA_vendorfour</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">42</property>
                        <property name="name">CA_phonefour</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">43</property>
                        <property name="name">CA_faxfour</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">44</property>
                        <property name="name">CA_email</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">45</property>
                        <property name="name">CA_co14four</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">46</property>
                        <property name="name">CA_address3four</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">47</property>
                        <property name="name">CA_namesCli</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">48</property>
                        <property name="name">CA_address1Cli</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">49</property>
                        <property name="name">CA_co10Cli</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">50</property>
                        <property name="name">CA_co11Cli</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">51</property>
                        <property name="name">CA_cpCli</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">52</property>
                        <property name="name">CA_villeCli</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">53</property>
                        <property name="name">CA_paysCli</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">54</property>
                        <property name="name">CA_address2Cli</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">55</property>
                        <property name="name">CA_shippointdesc</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">56</property>
                        <property name="name">CA_maxvaluestatus</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">57</property>
                        <property name="name">descStatus</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">58</property>
                        <property name="name">potypeStatus</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">59</property>
                        <property name="name">CA_maxtype</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">60</property>
                        <property name="name">CA_maxtypedesc</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">61</property>
                        <property name="name">CA_originaltype</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">62</property>
                        <property name="name">nbLig</property>
                        <property name="dataType">integer</property>
                    </structure>
                    <structure>
                        <property name="position">63</property>
                        <property name="name">CA_shippointname</property>
                        <property name="dataType">string</property>
                    </structure>
                </list-property>
            </structure>
            <property name="dataSource">maximoDataSource</property>
            <method name="open"><![CDATA[scriptLogger = mxReportScriptContext.getReportScriptLogger();

maximoDataSet = MXReportDataSetProvider.create(this.getDataSource().getName(), this.getName());
maximoDataSet.open();

var sqlText = new String();

// Add query to sqlText variable.
sqlText = "select po.poid, "
        + " po.ponum  CA_ponum, "
        + " po.originalponum CA_originalponum, "
        + " po.potype CA_potype, "
	    + " po.status  CA_postatus, "
        + " po.billto billto, "
        + " po.revisionnum, "
        + " po.siteid CA_siteid, "
        + " po.orgid CA_orgid, " 
        + " po.purchaseagent            CA_purchaseagent, "
		+ " po.description              CA_podescription, "
		+ " po.ldkey                    CA_poldkey, "
		+ " po.paymentterms             CA_paymentterms, "
		+ " po.freightterms             CA_freightterms, "
		+ " po.po7                      CA_poclause , " 
		+ " po.shipvia                CA_shipvia, "
		+ " po.billto                   CA_billto, "
		+ " po.shipto                 CA_shipto, "       //CA_shippoint
		+ " po.po8                      CA_po8 , "      //CA_po8 == n° d'avenant
		+ " po.totalcost                CA_totalcost, "
        + " po.totaltax1                CA_tax1, "
		+ " po.totaltax2                CA_tax2, "
		+ " po.totaltax3                CA_tax3, "
		+ " po.totaltax4                CA_tax4, "
		+ " po.totaltax5                CA_tax5, "
		+ " po.currencycode             CA_currencycode, "
		+ " po.originalponum            CA_bc_original, "
		+ " po.status                   CA_status, " 
		+ " to_char(po.startdate,'DD/MM/YYYY hh:mm:ss')   CA_datebegin, " //CA_datebegin == date de validite debut
		+ " to_char(po.enddate,'DD/MM/YYYY hh:mm:ss') CA_dateend, "//date de validite fin
		+ " to_char(po.statusdate,'DD/MM/YYYY hh:mm:ss') CA_statusdate, "
		+ " to_char(sysdate,'DD/MM/YYYY hh:mm:ss') CA_actdate, "
		
		+ " co.name CA_namesfour, "
		+ " nvl(co.contact,' ')  CA_contactfour, "
		+ " co.address1 CA_address1four, "
		+ " substr(co.co10,0,35)        CA_co10four, " //address2,
		+ " substr(co.co11,0,35)        CA_co11four, " //address3,
		+ " substr(co.address4,0,10)    CA_cpfour, "    //co5,
		+ " substr(co.address2,0,30)    CA_villefour, " 
		+ " nvl(substr(co.ADDRESS5,0,25),'FRANCE')         CA_paysnomfour, "
		+ " co.company                  CA_vendorfour, " //code fournisseur
		+ " co.phone                    CA_phonefour, "
		+ " co.fax                      CA_faxfour, " 
		+ " co.co5                      CA_email, "
		+ " nvl(co.co14,' ')          CA_co14four, "
		+ " co.address3                 CA_address3four "
        + " from "  
		+ " po po, " 
		+ " companies co "  
		+ " where " + params["where"]
		+ " and po.vendor = co.company (+) "
		+ " and po.orgid = co.orgid (+) "
		+ " order by po.ponum, po.orgid, po.siteid ";

maximoDataSet.setQuery(sqlText);]]></method>
            <method name="fetch"><![CDATA[if (!maximoDataSet.fetch())
	return (false);
		
row["poid"]= maximoDataSet.getInteger("poid");	
row["CA_ponum"]= maximoDataSet.getString("CA_ponum");	
row["CA_originalponum"]= maximoDataSet.getString("CA_originalponum");
row["CA_potype"]= maximoDataSet.getString("CA_potype");
row["CA_postatus"]= maximoDataSet.getString("CA_postatus");
row["billto"]= maximoDataSet.getString("billto");
row["revisionnum"]= maximoDataSet.getString("revisionnum");
row["CA_siteid"] = maximoDataSet.getString("CA_siteid");
row["CA_orgid"] = maximoDataSet.getString("CA_orgid");

if (scriptLogger.isDebugEnabled()) {
	scriptLogger.debug("row[poid] == " + row["poid"]);
	scriptLogger.debug("row[CA_ponum] == " + row["CA_ponum"]);
}

htmlSiteId = (row["CA_siteid"] == null ? " " : row["CA_siteid"]);
if (scriptLogger.isDebugEnabled()) {
	scriptLogger.debug("htmlSiteId == " + htmlSiteId);
} 


//Retrieve the poStatus
dataSetPoStatus = MXReportDataSetProvider.create(this.getDataSource().getName(), "dataSetPoStatus");
dataSetPoStatus.open();
	
poStatusSQLString = new String();
poStatusSQLString = " select "
				  + " PO.POID, "
                  + " PO.PONUM CA_ponum, "
				  + " PO.POTYPE potypeStatus, "
				  + " SYNONYMDOMAIN.MAXVALUE CA_maxvaluestatus, "
				  + " SYNONYMDOMAIN.DESCRIPTION descStatus " 
                  + " from "
			      + " PO, SYNONYMDOMAIN "
				  + " where " + params["where"]
			      + " AND DOMAINID = 'POSTATUS' "
				  + " AND UPPER(SYNONYMDOMAIN.VALUE) = UPPER(PO.POTYPE) ";
				  
dataSetPoStatus.setQuery(poStatusSQLString);
	
if(dataSetPoStatus.fetch()) {
	row["CA_maxvaluestatus"]= dataSetPoStatus.getString("CA_maxvaluestatus");
	row["descStatus"]= dataSetPoStatus.getString("descStatus");
	row["potypeStatus"]= dataSetPoStatus.getString("potypeStatus");
}
	
dataSetPoStatus.close();

if (scriptLogger.isDebugEnabled()) {
	scriptLogger.debug("row[CA_maxvaluestatus] == " + row["CA_maxvaluestatus"]);
	scriptLogger.debug("row[descStatus] == " + row["descStatus"]);
}				  


row["CA_purchaseagent"] = maximoDataSet.getString("CA_purchaseagent");
row["CA_podescription"] = maximoDataSet.getString("CA_podescription");
row["CA_poldkey"] = maximoDataSet.getString("CA_poldkey");
row["CA_paymentterms"] = maximoDataSet.getString("CA_paymentterms");
row["CA_freightterms"] = maximoDataSet.getString("CA_freightterms");
row["CA_poclause"] = maximoDataSet.getString("CA_poclause");
row["CA_shipvia"] = maximoDataSet.getString("CA_shipvia");
row["CA_billto"] = maximoDataSet.getString("CA_billto");
row["CA_shipto"] = maximoDataSet.getString("CA_shipto");
row["CA_po8"]  = maximoDataSet.getString("CA_po8");
row["CA_totalcost"]  = maximoDataSet.getString("CA_totalcost");
row["CA_tax1"]  = maximoDataSet.getString("CA_tax1");
row["CA_tax2"]  = maximoDataSet.getString("CA_tax2");


/*row["CA_tax3"]  = maximoDataSet.getString("CA_tax3");

if (scriptLogger.isDebugEnabled()) {
	scriptLogger.debug(" 10 a ");
}*/

row["CA_tax4"]  = maximoDataSet.getString("CA_tax4");
row["CA_tax5"]  = maximoDataSet.getString("CA_tax5");
row["CA_currencycode"]  = maximoDataSet.getString("CA_currencycode");
row["CA_bc_original"]  = maximoDataSet.getString("CA_bc_original");
row["CA_status"]  = maximoDataSet.getString("CA_status");
row["CA_datebegin"]  = maximoDataSet.getString("CA_datebegin");
row["CA_dateend"]  = maximoDataSet.getString("CA_dateend");
row["CA_statusdate"]  = maximoDataSet.getString("CA_statusdate");
row["CA_actdate"]  = maximoDataSet.getString("CA_actdate");
row["CA_namesfour"]  = maximoDataSet.getString("CA_namesfour");
row["CA_contactfour"]  = maximoDataSet.getString("CA_contactfour");
row["CA_address1four"]  = maximoDataSet.getString("CA_address1four");
row["CA_co10four"]  = maximoDataSet.getString("CA_co10four");
row["CA_co11four"]  = maximoDataSet.getString("CA_co11four");
row["CA_cpfour"]  = maximoDataSet.getString("CA_cpfour");
row["CA_villefour"]  = maximoDataSet.getString("CA_villefour");
row["CA_paysnomfour"]  = maximoDataSet.getString("CA_paysnomfour");
row["CA_vendorfour"]  = maximoDataSet.getString("CA_vendorfour");
row["CA_phonefour"]  = maximoDataSet.getString("CA_phonefour");
row["CA_faxfour"]  = maximoDataSet.getString("CA_faxfour");
row["CA_email"]  = maximoDataSet.getString("CA_email");
row["CA_co14four"]  = maximoDataSet.getString("CA_co14four");
row["CA_address3four"]  = maximoDataSet.getString("CA_address3four");
contactFrss = row["CA_namesfour"] + " " + row["CA_co14four"];

//Retrieve the maxType
dataSetMaxType = MXReportDataSetProvider.create(this.getDataSource().getName(), "dataSetMaxType");
dataSetMaxType.open();
	
maxTypeSQLString = new String();

maxTypeSQLString = " select "
				 + " PO.POID, "
				 + " PO.PONUM CA_ponum, "
				 + " PO.POTYPE, "
				 + " SYNONYMDOMAIN.MAXVALUE CA_maxtype, "
				 + " SYNONYMDOMAIN.DESCRIPTION CA_maxtypedesc "
				 + " from " 
				 + " PO, SYNONYMDOMAIN " 
				 + " WHERE " + params["where"]
				 + " AND DOMAINID = 'POTYPE' "
				 + " AND UPPER(SYNONYMDOMAIN.VALUE) = UPPER(PO.POTYPE) ";

dataSetMaxType.setQuery(maxTypeSQLString);
	
if(dataSetMaxType.fetch()) {
	row["CA_maxtype"]= dataSetMaxType.getString("CA_maxtype");
	row["CA_maxtypedesc"]= dataSetMaxType.getString("CA_maxtypedesc");
}
	
dataSetMaxType.close();				 
				 
				 
//Retrie original PoType
if(row["CA_maxtype"] == "REL" || row["CA_maxtype"] == "CHG"){
	dataSetorigPonum = MXReportDataSetProvider.create(this.getDataSource().getName(), "dataSetorigPonum");
	dataSetorigPonum.open();
	
	origPonumSQLString = new String();
	
	origPonumSQLString = " select "
					   + " PO.POID, "
	+ " PO.PONUM CA_originalponum, "
	+ " PO.POTYPE CA_originaltype, "
	+ " SYNONYMDOMAIN.DESCRIPTION CA_originaltypedesc "
	+ " from "
	+ " PO, SYNONYMDOMAIN "
	+ " WHERE " 
	+ " PO.PONUM = '" + row["CA_originalponum"] + "'"
	+ " AND PO.ORGID = '" + row["CA_orgid"] + "'"
	+ " AND PO.SITEID =  '" + row["CA_siteid"] + "'"
	+ " AND DOMAINID = 'POTYPE' "
	+ " AND UPPER(SYNONYMDOMAIN.VALUE) = UPPER(PO.POTYPE) "
	+ " AND SYNONYMDOMAIN.orgid = po.orgid "
	+ " AND SYNONYMDOMAIN.siteid = po.siteid ";
	
	dataSetorigPonum.setQuery(origPonumSQLString);
	
	if(dataSetorigPonum.fetch()) {
		row["CA_originalponum"]= dataSetorigPonum.getString("CA_originalponum");
		row["CA_originaltype"]= dataSetorigPonum.getString("CA_originaltype");
	}
	
	dataSetorigPonum.close();	
}


//Retrieve data about shippoint
dataSetShippoint = MXReportDataSetProvider.create(this.getDataSource().getName(), "dataSetShippoint");
dataSetShippoint.open();

shippointSQLString = new String();

shippointSQLString = " select " 
					 + " (select description from locations where shiptoaddresscode = '" + row["CA_shipto"] + "' and isdefault = 1 and orgid = address.orgid) name, "
					 + " description CA_shippointdesc, "  
					 + " address1 CA_address1Cli, "  
					 + " address2 CA_address2Cli, "
					 + " address3  CA_villeCli, "
					 + " address4 CA_cpCli, "
					 + " address5 CA_paysCli "
					 + " from address where addresscode = '"
					 + row["CA_shipto"] + "'"
					 + " and address.orgid = '" + row["CA_orgid"] + "'";

dataSetShippoint.setQuery(shippointSQLString);
	
if(dataSetShippoint.fetch()) {
	row["CA_shippointname"]= dataSetShippoint.getString("name");
	row["CA_shippointdesc"]= dataSetShippoint.getString("CA_shippointdesc");
	row["CA_address1Cli"]= dataSetShippoint.getString("CA_address1Cli");
	row["CA_address2Cli"]= dataSetShippoint.getString("CA_address2Cli");
	row["CA_cpCli"] = dataSetShippoint.getString("CA_cpCli");
	row["CA_villeCli"]= dataSetShippoint.getString("CA_villeCli");
	row["CA_paysCli"] = dataSetShippoint.getString("CA_paysCli");
}
	
dataSetShippoint.close();

if(row["CA_cpCli"] == null) {
	row["CA_cpCli"] = " ";
}
if(row["CA_villeCli"] == null) {
	row["CA_villeCli"] = " ";
}
cpVilleCli = row["CA_cpCli"] + " " + row["CA_villeCli"]; 
if (scriptLogger.isDebugEnabled()) {
	scriptLogger.debug(" cpVilleCli == " + cpVilleCli);
}


//Retrieve the poStatus
dataSetPolcount = MXReportDataSetProvider.create(this.getDataSource().getName(), "dataSetPolcount");
dataSetPolcount.open();
	
var polCountSQLString = new String();
polCountSQLString  = "select count(*) nbLig "
                   + " from po, poline pol"  
				   + " where po.ponum = pol.ponum "
				   + " and po.siteid = pol.siteid "
				   + " and po.revisionnum = pol.revisionnum "
				   + " and po.ponum = '" + row["CA_ponum"] +"'"
				   + " and po.siteid =  '" + row["CA_siteid"] +"'"
				   + " and po.revisionnum =  '" + row["revisionnum"] +"'";
				   
dataSetPolcount.setQuery(polCountSQLString);				   
				   
if(dataSetPolcount.fetch()) {
	row["nbLig"]= dataSetPolcount.getInteger("nbLig");
}				   

dataSetPolcount.close();

return (true);]]></method>
        </script-data-set>
        <script-data-set name="dataSetAddress" id="1154">
            <list-property name="resultSetHints">
                <structure>
                    <property name="position">1</property>
                    <property name="name">address</property>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="position">2</property>
                    <property name="name">raisonSoc</property>
                    <property name="dataType">string</property>
                </structure>
            </list-property>
            <list-property name="columnHints">
                <structure>
                    <property name="columnName">address</property>
                </structure>
                <structure>
                    <property name="columnName">raisonSoc</property>
                </structure>
            </list-property>
            <structure name="cachedMetaData">
                <list-property name="resultSet">
                    <structure>
                        <property name="position">1</property>
                        <property name="name">address</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">2</property>
                        <property name="name">raisonSoc</property>
                        <property name="dataType">string</property>
                    </structure>
                </list-property>
            </structure>
            <property name="dataSource">maximoDataSource</property>
            <method name="open"><![CDATA[scriptLogger = mxReportScriptContext.getReportScriptLogger();

addressDataSet = MXReportDataSetProvider.create(this.getDataSource().getName(), this.getName());
addressDataSet.open();

var sqlText = new String();

// Add query to sqlText variable.
sqlText = "select "
+ " nvl(address.description || ' - ' || address2 || ', ' || address4 || ' ' || address3  || ' ' || decode(ADDRESS5,null,'FRANCE',ADDRESS5),' ') CA_old_bpdesc1, "
+ " nvl((select ldtext from longdescription where ldownertable = 'ADDRESS' and ldownercol = 'DESCRIPTION' " 
+ "                                     and ldkey = (select addressid from address where addresscode = po.billto and orgid = po.orgid)),' ') CA_old_bpdesc2 "
+ " from " 
+ " po, address "
//Here, the POID is the parameter 
+ " where " + params["where"]
+ " and po.billto = address.addresscode "
+ " and po.orgid = address.orgid "
+ " and po.revisionnum = (select max(p.revisionnum) "
                      + " from po p "
                      + " where p.ponum = po.ponum "
                      + " and p.siteid = po.siteid "
                      + " group by p.ponum) ";
                      
if (scriptLogger.isDebugEnabled()) {
	scriptLogger.debug("Query dataSetAddress == " + sqlText);
}

addressDataSet.setQuery(sqlText);
                      ]]></method>
            <method name="fetch"><![CDATA[if (!addressDataSet.fetch())
	return (false);
	
// Add a line for each output column
// The specific get method should match the data type of the output column.
row["address"] = addressDataSet.getString("CA_old_bpdesc1");
row["raisonSoc"] = addressDataSet.getHtmlString("CA_old_bpdesc2");


return (true);]]></method>
        </script-data-set>
        <script-data-set name="dataSetPoline" id="570">
            <list-property name="resultSetHints">
                <structure>
                    <property name="position">1</property>
                    <property name="name">CA_polinenum</property>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="position">2</property>
                    <property name="name">CA_refbp</property>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="position">3</property>
                    <property name="name">CA_linedesc</property>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="position">4</property>
                    <property name="name">CA_orderqty</property>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="position">5</property>
                    <property name="name">CA_unitcost</property>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="position">6</property>
                    <property name="name">CA_polineitemnum</property>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="position">7</property>
                    <property name="name">CA_orderunit</property>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="position">8</property>
                    <property name="name">CA_catalogcode</property>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="position">9</property>
                    <property name="name">CA_livraison</property>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="position">10</property>
                    <property name="name">CA_lineclause</property>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="position">11</property>
                    <property name="name">CA_itemdesc</property>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="position">12</property>
                    <property name="name">casier</property>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="position">13</property>
                    <property name="name">CA_itemlongdesc</property>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="position">14</property>
                    <property name="name">itemsetid</property>
                    <property name="dataType">string</property>
                </structure>
            </list-property>
            <list-property name="columnHints">
                <structure>
                    <property name="columnName">CA_polinenum</property>
                </structure>
                <structure>
                    <property name="columnName">CA_refbp</property>
                </structure>
                <structure>
                    <property name="columnName">CA_linedesc</property>
                </structure>
                <structure>
                    <property name="columnName">CA_orderqty</property>
                </structure>
                <structure>
                    <property name="columnName">CA_unitcost</property>
                </structure>
                <structure>
                    <property name="columnName">CA_polineitemnum</property>
                </structure>
                <structure>
                    <property name="columnName">CA_orderunit</property>
                </structure>
                <structure>
                    <property name="columnName">CA_catalogcode</property>
                </structure>
                <structure>
                    <property name="columnName">CA_livraison</property>
                </structure>
                <structure>
                    <property name="columnName">CA_lineclause</property>
                </structure>
                <structure>
                    <property name="columnName">CA_itemdesc</property>
                </structure>
                <structure>
                    <property name="columnName">casier</property>
                </structure>
                <structure>
                    <property name="columnName">CA_itemlongdesc</property>
                </structure>
                <structure>
                    <property name="columnName">itemsetid</property>
                </structure>
            </list-property>
            <structure name="cachedMetaData">
                <list-property name="resultSet">
                    <structure>
                        <property name="position">1</property>
                        <property name="name">CA_polinenum</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">2</property>
                        <property name="name">CA_refbp</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">3</property>
                        <property name="name">CA_linedesc</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">4</property>
                        <property name="name">CA_orderqty</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">5</property>
                        <property name="name">CA_unitcost</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">6</property>
                        <property name="name">CA_polineitemnum</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">7</property>
                        <property name="name">CA_orderunit</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">8</property>
                        <property name="name">CA_catalogcode</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">9</property>
                        <property name="name">CA_livraison</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">10</property>
                        <property name="name">CA_lineclause</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">11</property>
                        <property name="name">CA_itemdesc</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">12</property>
                        <property name="name">casier</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">13</property>
                        <property name="name">CA_itemlongdesc</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">14</property>
                        <property name="name">itemsetid</property>
                        <property name="dataType">string</property>
                    </structure>
                </list-property>
            </structure>
            <property name="dataSource">maximoDataSource</property>
            <method name="open"><![CDATA[scriptLogger = mxReportScriptContext.getReportScriptLogger();

polineDataSet = MXReportDataSetProvider.create(this.getDataSource().getName(), this.getName());
polineDataSet.open();

var sqlText = new String();

sqlText = "select "
		+ " pol.polinenum CA_polinenum, "
        //+ " NVL(pol.itemnum, pol.schargecode)    CA_refbp, "
		+ " pol.itemnum    						 CA_refbp, "
		+ " pol.itemsetid                                , "
		+ " substr(pol.description,1,40)         CA_linedesc, "
		+ " to_char(pol.orderqty,'b999999990.99') CA_orderqty, "
		+ " pol.unitcost                         CA_unitcost, "
		+ " pol.itemnum                          CA_polineitemnum, "
		+ " lpad(pol.orderunit,19)               CA_orderunit, "
		+ " pol.catalogcode                      CA_catalogcode, "
		+ " DECODE ( '"+ rows[0]["CA_potype"] + "' , 'REAPPRO', to_char(NVL(pol.vendeliverydate,pol.reqdeliverydate),'DD/MM/YYYY'), "
									  + " to_char(pol.reqdeliverydate,'DD/MM/YYYY'))    CA_livraison, "
		+ " pol.plin3                            CA_lineclause, "
		+ " ite.description                      CA_itemdesc, "
		//récupérer le casier
		+ " inv.binnum casier "    
		+ " from po, poline pol, item ite "
		+ " ,inventory inv "  
		+ " where po.ponum = pol.ponum "
		+ " and po.siteid = pol.siteid "
		+ " and po.revisionnum = pol.revisionnum "
		+ " and po.ponum = '" + rows[0]["CA_ponum"] +"'"
		+ " and po.siteid =  '" + rows[0]["CA_siteid"] +"'"
		+ " and po.revisionnum =  '" + rows[0]["revisionnum"] +"'"
		+ " and pol.itemnum = ite.itemnum (+) "
		+ " and pol.itemsetid = ite.itemsetid (+) "
		+ " and pol.storeloc = inv.location (+) "
		+ " and pol.itemnum = inv.itemnum (+) "
		+ " and pol.itemsetid = inv.itemsetid (+) "
		+ " and pol.siteid = inv.siteid (+) "
		+ " order by pol.polinenum ";	

if (scriptLogger.isDebugEnabled()) {
	scriptLogger.debug("Query dataSetPoline == " + sqlText);
}

polineDataSet.setQuery(sqlText);]]></method>
            <method name="fetch"><![CDATA[if (!polineDataSet.fetch())
	return (false);

row["CA_polinenum"] = polineDataSet.getString("CA_polinenum");
row["CA_refbp"] = polineDataSet.getString("CA_refbp");
row["CA_linedesc"] = polineDataSet.getString("CA_linedesc");	
row["CA_orderqty"] = polineDataSet.getString("CA_orderqty");
row["CA_unitcost"] = polineDataSet.getString("CA_unitcost");
row["CA_polineitemnum"] = polineDataSet.getString("CA_polineitemnum");
row["itemsetid"] = polineDataSet.getString("itemsetid");
row["CA_orderunit"] = polineDataSet.getString("CA_orderunit");
row["CA_catalogcode"] = polineDataSet.getString("CA_catalogcode");
row["CA_livraison"]= polineDataSet.getString("CA_livraison");
row["CA_lineclause"]= polineDataSet.getString("CA_lineclause");
row["CA_itemdesc"]= polineDataSet.getString("CA_itemdesc");
row["casier"]=polineDataSet.getString("casier");

if (scriptLogger.isDebugEnabled()) {
	scriptLogger.debug("row[CA_polinenum] == " + row["CA_polinenum"]);
}

var sqlLgd = new String();
			
//Test on itemnum not null
if(row["CA_polineitemnum"] != null) {

	//Retrieve inforations on the longdescription of the item 
	theLongdescDataSet = MXReportDataSetProvider.create(this.getDataSource().getName(), "theLongdescDataSet");

	sqlLgd = "select "
	+ "decode(hasld,1,(select ldtext from longdescription where ldkey = it.itemid "
	+ "and LDOWNERTABLE = 'ITEM' "
	+ "and LDOWNERCOL = 'DESCRIPTION')) CA_itemlongdesc "
	+ "from item it "
	+ "where itemnum = '"+ row["CA_polineitemnum"] + "' "
	+ "and itemsetid = '" + row["itemsetid"] + "' ";
	
	if (scriptLogger.isDebugEnabled()) {
		scriptLogger.debug("Query sqlLgd on itemnum == " + sqlLgd);
	}
	
	theLongdescDataSet.open();
	
	theLongdescDataSet.setQuery(sqlLgd);
	
	if(theLongdescDataSet.fetch()) {
		row["CA_itemlongdesc"] = theLongdescDataSet.getHtmlString("CA_itemlongdesc");

		if (scriptLogger.isDebugEnabled()) {
			scriptLogger.debug("row[CA_itemlongdesc] == " + row["CA_itemlongdesc"]);
		}
	}
	
	theLongdescDataSet.close();
}//End test on itemnum not null


return (true);]]></method>
        </script-data-set>
        <script-data-set name="dataSetUserName" id="1165">
            <list-property name="resultSetHints">
                <structure>
                    <property name="position">1</property>
                    <property name="name">username</property>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="position">2</property>
                    <property name="name">lastname</property>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="position">3</property>
                    <property name="name">firstname</property>
                    <property name="dataType">string</property>
                </structure>
            </list-property>
            <list-property name="columnHints">
                <structure>
                    <property name="columnName">username</property>
                </structure>
                <structure>
                    <property name="columnName">lastname</property>
                </structure>
                <structure>
                    <property name="columnName">firstname</property>
                </structure>
            </list-property>
            <structure name="cachedMetaData">
                <list-property name="resultSet">
                    <structure>
                        <property name="position">1</property>
                        <property name="name">username</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">2</property>
                        <property name="name">lastname</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">3</property>
                        <property name="name">firstname</property>
                        <property name="dataType">string</property>
                    </structure>
                </list-property>
            </structure>
            <property name="dataSource">maximoDataSource</property>
            <method name="open"><![CDATA[scriptLogger = mxReportScriptContext.getReportScriptLogger();

if (scriptLogger.isDebugEnabled()) {
	scriptLogger.debug("Query dataSetUser dans OPEN");
}
if (scriptLogger.isDebugEnabled()) {
	scriptLogger.debug("Query dataSetUser OPEN userid:"+userid);
}

userDataSet = MXReportDataSetProvider.create(this.getDataSource().getName(), this.getName());
userDataSet.open();

var sqlText = new String();

if (scriptLogger.isDebugEnabled()) {
	scriptLogger.debug("Query dataSetUser userid == " + userid);
}

// Add query to sqlText variable.
sqlText = " select "
//Remarque sur person.displaname : on peut aussi faire un sous-select 
//           avec userDataSet.getNullValueFunction("PERSON.DISPLAYNAME"," ")
//           mais cette fonction Maximo indépendante du type de SGBD contraint à passer par une sous-requête...
+ " nvl(PERSON.DISPLAYNAME,' ') username, "
+ " upper(nvl(PERSON.LASTNAME,' ')) lastname, "  
+ " nvl(PERSON.FIRSTNAME,' ') firstname "
+ " from " 
+ " PERSON,MAXUSER "
+ " WHERE " 
+ " UPPER(MAXUSER.USERID) = UPPER('" + userid + "')"
+ " AND MAXUSER.PERSONID = PERSON.PERSONID ";

if (scriptLogger.isDebugEnabled()) {
	scriptLogger.debug("Query dataSetUser == " + sqlText);
}

userDataSet.setQuery(sqlText);]]></method>
            <method name="fetch"><![CDATA[scriptLogger = mxReportScriptContext.getReportScriptLogger();

if (scriptLogger.isDebugEnabled()) {
	scriptLogger.debug("Query dataSetUser dans FETCH");
}
if (scriptLogger.isDebugEnabled()) {
	scriptLogger.debug("Query dataSetUser FETCH userid:"+userid);
}


if (!userDataSet.fetch())
	return (false);

// Add a line for each output column
// The specific get method should match the data type of the output column.
row["username"] = userDataSet.getString("username");
row["lastname"] = userDataSet.getString("lastname");
row["firstname"] = userDataSet.getString("firstname");

if (scriptLogger.isDebugEnabled()) {
	scriptLogger.debug("Query dataSetUser FETCH row[username] avnt :"+row["username"]);
	scriptLogger.debug("Query dataSetUser FETCH row[lastname]:"+row["lastname"]);
	scriptLogger.debug("Query dataSetUser FETCH row[firstname]:"+row["firstname"]);
}

if(!BirtComp.equalTo(row["lastname"]," ") &amp;&amp; !BirtComp.equalTo(row["firstname"]," ")){
	row["username"] = row["firstname"] + " " + row["lastname"];
}

if (scriptLogger.isDebugEnabled()) {
	scriptLogger.debug("Query dataSetUser FETCH row[username] aprs :"+row["username"]);
}




if(htmlTableUserName == ""){
	htmlTableUserName = row["username"]; 
	//htmlTableUserName = "<table border=\"0\" valign=\"top\"><tr valign=\"top\"><td valign=\"top\">" + row["username"] + "</td></tr></table>";
	if (scriptLogger.isDebugEnabled()) {
		scriptLogger.debug("Query dataSetUser htmlTableUserName:"+htmlTableUserName);
	}
}

return (true);]]></method>
        </script-data-set>
    </data-sets>
    <styles>
        <style name="crosstab-cell" id="370">
            <property name="borderBottomColor">#CCCCCC</property>
            <property name="borderBottomStyle">solid</property>
            <property name="borderBottomWidth">1pt</property>
            <property name="borderLeftColor">#CCCCCC</property>
            <property name="borderLeftStyle">solid</property>
            <property name="borderLeftWidth">1pt</property>
            <property name="borderRightColor">#CCCCCC</property>
            <property name="borderRightStyle">solid</property>
            <property name="borderRightWidth">1pt</property>
            <property name="borderTopColor">#CCCCCC</property>
            <property name="borderTopStyle">solid</property>
            <property name="borderTopWidth">1pt</property>
        </style>
        <style name="crosstab" id="371">
            <property name="borderBottomColor">#CCCCCC</property>
            <property name="borderBottomStyle">solid</property>
            <property name="borderBottomWidth">1pt</property>
            <property name="borderLeftColor">#CCCCCC</property>
            <property name="borderLeftStyle">solid</property>
            <property name="borderLeftWidth">1pt</property>
            <property name="borderRightColor">#CCCCCC</property>
            <property name="borderRightStyle">solid</property>
            <property name="borderRightWidth">1pt</property>
            <property name="borderTopColor">#CCCCCC</property>
            <property name="borderTopStyle">solid</property>
            <property name="borderTopWidth">1pt</property>
        </style>
    </styles>
    <page-setup>
        <simple-master-page name="conciappMasterPage" id="1155">
            <property name="type">a4</property>
            <property name="orientation">portrait</property>
            <page-footer>
                <grid id="1157">
                    <property name="marginTop">1cm</property>
                    <property name="marginBottom">0cm</property>
                    <property name="height">0.3541666666666667in</property>
                    <property name="dataSet">dataSetAddress</property>
                    <list-property name="boundDataColumns">
                        <structure>
                            <property name="name">address</property>
                            <text-property name="displayName">address</text-property>
                            <expression name="expression" type="javascript">dataSetRow["address"]</expression>
                            <property name="dataType">string</property>
                        </structure>
                        <structure>
                            <property name="name">raisonSoc</property>
                            <text-property name="displayName">raisonSoc</text-property>
                            <expression name="expression" type="javascript">dataSetRow["raisonSoc"]</expression>
                            <property name="dataType">string</property>
                        </structure>
                    </list-property>
                    <column id="1158">
                        <property name="width">33%</property>
                        <property name="textAlign">left</property>
                    </column>
                    <column id="1159">
                        <property name="width">33%</property>
                        <property name="textAlign">right</property>
                    </column>
                    <column id="2599">
                        <property name="width">33%</property>
                        <property name="textAlign">right</property>
                    </column>
                    <row id="1160">
                        <property name="height">0.3541666666666667in</property>
                        <cell id="1161">
                            <property name="colSpan">3</property>
                            <property name="rowSpan">1</property>
                            <property name="fontFamily">"Arial"</property>
                            <text-data id="2616">
                                <expression name="valueExpr">row["address"] + "&lt;br/>" +row["raisonSoc"]</expression>
                                <property name="contentType">html</property>
                            </text-data>
                        </cell>
                    </row>
                    <row id="2447">
                        <property name="borderBottomColor">#000000</property>
                        <property name="borderBottomStyle">solid</property>
                        <property name="borderBottomWidth">thin</property>
                        <property name="borderTopColor">#000000</property>
                        <property name="borderTopStyle">solid</property>
                        <property name="borderTopWidth">thin</property>
                        <property name="verticalAlign">middle</property>
                        <cell id="2448">
                            <label id="2486">
                                <property name="fontFamily">"Arial"</property>
                                <text-property name="text">CONSIAPP v1.1</text-property>
                            </label>
                        </cell>
                        <cell id="2449">
                            <property name="textAlign">right</property>
                            <grid id="2600">
                                <column id="2601"/>
                                <column id="2602"/>
                                <column id="2603">
                                    <property name="width">0.2in</property>
                                    <property name="textAlign">center</property>
                                </column>
                                <column id="2604">
                                    <property name="textAlign">left</property>
                                </column>
                                <row id="2605">
                                    <cell id="2606">
                                        <label id="2613">
                                            <text-property name="text">Page</text-property>
                                        </label>
                                    </cell>
                                    <cell id="2607">
                                        <auto-text id="2610">
                                            <property name="type">page-number</property>
                                        </auto-text>
                                    </cell>
                                    <cell id="2608">
                                        <label id="2614">
                                            <text-property name="text">/</text-property>
                                        </label>
                                    </cell>
                                    <cell id="2609">
                                        <auto-text id="2611">
                                            <property name="type">total-page</property>
                                        </auto-text>
                                    </cell>
                                </row>
                            </grid>
                        </cell>
                        <cell id="2598">
                            <property name="textAlign">right</property>
                        </cell>
                    </row>
                </grid>
            </page-footer>
        </simple-master-page>
    </page-setup>
    <body>
        <table name="mainTable" id="7">
            <property name="comments">09-19764@000</property>
            <property name="masterPage">conciappMasterPage</property>
            <property name="pageBreakAfter">always</property>
            <property name="pageBreakBefore">always</property>
            <property name="pageBreakInside">avoid</property>
            <property name="width">100%</property>
            <property name="dataSet">PODataSet</property>
            <list-property name="boundDataColumns">
                <structure>
                    <property name="name">total_rec</property>
                    <expression name="expression">Total.count()</expression>
                    <property name="dataType">any</property>
                </structure>
                <structure>
                    <property name="name">ponumTxt</property>
                    <text-property name="displayName">po</text-property>
                    <expression name="expression" type="javascript">dataSetRow["CA_ponum"]</expression>
                    <property name="dataType">string</property>
                    <property name="allowExport">true</property>
                </structure>
                <structure>
                    <property name="name">Column Binding</property>
                    <expression name="expression" type="javascript">dataSetRow["CA_shippointdesc"]</expression>
                    <property name="dataType">string</property>
                    <property name="allowExport">true</property>
                </structure>
                <structure>
                    <property name="name">CA_address1Cli</property>
                    <text-property name="displayName">cliAd1</text-property>
                    <expression name="expression" type="javascript">dataSetRow["CA_address1Cli"]</expression>
                    <property name="dataType">string</property>
                    <property name="allowExport">true</property>
                </structure>
                <structure>
                    <property name="name">CA_shippointdesc</property>
                    <text-property name="displayName">shpdsc</text-property>
                    <expression name="expression" type="javascript">dataSetRow["CA_shippointdesc"]</expression>
                    <property name="dataType">string</property>
                    <property name="allowExport">true</property>
                </structure>
                <structure>
                    <property name="name">CA_co10Cli</property>
                    <text-property name="displayName">cl10cli</text-property>
                    <expression name="expression" type="javascript">dataSetRow["CA_co10Cli"]</expression>
                    <property name="dataType">string</property>
                    <property name="allowExport">true</property>
                </structure>
                <structure>
                    <property name="name">CA_co11Cli</property>
                    <text-property name="displayName">cl11cli</text-property>
                    <expression name="expression" type="javascript">dataSetRow["CA_co11Cli"]</expression>
                    <property name="dataType">string</property>
                    <property name="allowExport">true</property>
                </structure>
                <structure>
                    <property name="name">CA_paysCli</property>
                    <text-property name="displayName">pyCli</text-property>
                    <expression name="expression" type="javascript">dataSetRow["CA_paysCli"]</expression>
                    <property name="dataType">string</property>
                    <property name="allowExport">true</property>
                </structure>
                <structure>
                    <property name="name">CA_contactfour</property>
                    <text-property name="displayName">cntct</text-property>
                    <expression name="expression" type="javascript">dataSetRow["CA_contactfour"]</expression>
                    <property name="dataType">string</property>
                    <property name="allowExport">true</property>
                </structure>
                <structure>
                    <property name="name">Column Binding_1</property>
                    <expression name="expression" type="javascript">dataSetRow["CA_address1four"]</expression>
                    <property name="dataType">string</property>
                    <property name="allowExport">true</property>
                </structure>
                <structure>
                    <property name="name">CA_address1four</property>
                    <text-property name="displayName">adfr1</text-property>
                    <expression name="expression" type="javascript">dataSetRow["CA_address1four"]</expression>
                    <property name="dataType">string</property>
                    <property name="allowExport">true</property>
                </structure>
                <structure>
                    <property name="name">CA_address3four</property>
                    <text-property name="displayName">adfr3</text-property>
                    <expression name="expression" type="javascript">dataSetRow["CA_address3four"]</expression>
                    <property name="dataType">string</property>
                    <property name="allowExport">true</property>
                </structure>
                <structure>
                    <property name="name">phonefourTxt</property>
                    <text-property name="displayName">phv</text-property>
                    <expression name="expression" type="javascript">dataSetRow["CA_phonefour"]</expression>
                    <property name="dataType">string</property>
                    <property name="allowExport">true</property>
                </structure>
                <structure>
                    <property name="name">faxfourTxt</property>
                    <text-property name="displayName">phf</text-property>
                    <expression name="expression" type="javascript">dataSetRow["CA_faxfour"]</expression>
                    <property name="dataType">string</property>
                    <property name="allowExport">true</property>
                </structure>
                <structure>
                    <property name="name">vendorfourTxt</property>
                    <text-property name="displayName">frs</text-property>
                    <expression name="expression" type="javascript">dataSetRow["CA_vendorfour"]</expression>
                    <property name="dataType">string</property>
                    <property name="allowExport">true</property>
                </structure>
                <structure>
                    <property name="name">statusdateTxt</property>
                    <text-property name="displayName">stsdt</text-property>
                    <expression name="expression" type="javascript">dataSetRow["CA_statusdate"]</expression>
                    <property name="dataType">date-time</property>
                    <property name="allowExport">true</property>
                </structure>
                <structure>
                    <property name="name">actdateTxt</property>
                    <text-property name="displayName">actdt</text-property>
                    <expression name="expression" type="javascript">dataSetRow["CA_actdate"]</expression>
                    <property name="dataType">date-time</property>
                    <property name="allowExport">true</property>
                </structure>
                <structure>
                    <property name="name">nbLigTxt</property>
                    <text-property name="displayName">nblig</text-property>
                    <expression name="expression" type="javascript">dataSetRow["nbLig"]</expression>
                    <property name="dataType">integer</property>
                    <property name="allowExport">true</property>
                </structure>
                <structure>
                    <property name="name">ponumTxtG</property>
                    <text-property name="displayName">po</text-property>
                    <expression name="expression" type="javascript">dataSetRow["CA_ponum"]</expression>
                    <property name="dataType">string</property>
                    <property name="allowExport">true</property>
                </structure>
                <structure>
                    <property name="name">cpFourTxt</property>
                    <text-property name="displayName">cpf</text-property>
                    <expression name="expression" type="javascript">dataSetRow["CA_cpfour"]</expression>
                    <property name="dataType">string</property>
                    <property name="allowExport">true</property>
                </structure>
                <structure>
                    <property name="name">villeFourTxt</property>
                    <text-property name="displayName">villeFour</text-property>
                    <expression name="expression" type="javascript">dataSetRow["CA_villefour"]</expression>
                    <property name="dataType">string</property>
                    <property name="allowExport">true</property>
                </structure>
                <structure>
                    <property name="name">paysFourTxt</property>
                    <text-property name="displayName">paysfrs</text-property>
                    <expression name="expression" type="javascript">dataSetRow["CA_paysnomfour"]</expression>
                    <property name="dataType">string</property>
                    <property name="allowExport">true</property>
                </structure>
                <structure>
                    <property name="name">siteIdTxt</property>
                    <text-property name="displayName">site</text-property>
                    <expression name="expression" type="javascript">dataSetRow["CA_siteid"]</expression>
                    <property name="dataType">string</property>
                    <property name="allowExport">true</property>
                </structure>
                <structure>
                    <property name="name">currentDateTxt</property>
                    <text-property name="displayName">cdt</text-property>
                    <expression name="expression" type="javascript">BirtDateTime.now()</expression>
                    <property name="dataType">date-time</property>
                    <property name="allowExport">true</property>
                </structure>
                <structure>
                    <property name="name">CA_co10four</property>
                    <text-property name="displayName">CA_co10four</text-property>
                    <expression name="expression" type="javascript">dataSetRow["CA_co10four"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">CA_namesfour</property>
                    <text-property name="displayName">CA_namesfour</text-property>
                    <expression name="expression" type="javascript">dataSetRow["CA_namesfour"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">CA_address2Cli</property>
                    <text-property name="displayName">CA_address2Cli</text-property>
                    <expression name="expression" type="javascript">dataSetRow["CA_address2Cli"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">poid</property>
                    <text-property name="displayName">poid</text-property>
                    <expression name="expression" type="javascript">dataSetRow["poid"]</expression>
                    <property name="dataType">integer</property>
                </structure>
                <structure>
                    <property name="name">CA_originalponum</property>
                    <text-property name="displayName">CA_originalponum</text-property>
                    <expression name="expression" type="javascript">dataSetRow["CA_originalponum"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">CA_potype</property>
                    <text-property name="displayName">CA_potype</text-property>
                    <expression name="expression" type="javascript">dataSetRow["CA_potype"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">CA_postatus</property>
                    <text-property name="displayName">CA_postatus</text-property>
                    <expression name="expression" type="javascript">dataSetRow["CA_postatus"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">billto</property>
                    <text-property name="displayName">billto</text-property>
                    <expression name="expression" type="javascript">dataSetRow["billto"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">revisionnum</property>
                    <text-property name="displayName">revisionnum</text-property>
                    <expression name="expression" type="javascript">dataSetRow["revisionnum"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">CA_orgid</property>
                    <text-property name="displayName">CA_orgid</text-property>
                    <expression name="expression" type="javascript">dataSetRow["CA_orgid"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">CA_purchaseagent</property>
                    <text-property name="displayName">CA_purchaseagent</text-property>
                    <expression name="expression" type="javascript">dataSetRow["CA_purchaseagent"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">CA_podescription</property>
                    <text-property name="displayName">CA_podescription</text-property>
                    <expression name="expression" type="javascript">dataSetRow["CA_podescription"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">CA_poldkey</property>
                    <text-property name="displayName">CA_poldkey</text-property>
                    <expression name="expression" type="javascript">dataSetRow["CA_poldkey"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">CA_paymentterms</property>
                    <text-property name="displayName">CA_paymentterms</text-property>
                    <expression name="expression" type="javascript">dataSetRow["CA_paymentterms"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">CA_freightterms</property>
                    <text-property name="displayName">CA_freightterms</text-property>
                    <expression name="expression" type="javascript">dataSetRow["CA_freightterms"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">CA_poclause</property>
                    <text-property name="displayName">CA_poclause</text-property>
                    <expression name="expression" type="javascript">dataSetRow["CA_poclause"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">CA_shipvia</property>
                    <text-property name="displayName">CA_shipvia</text-property>
                    <expression name="expression" type="javascript">dataSetRow["CA_shipvia"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">CA_billto</property>
                    <text-property name="displayName">CA_billto</text-property>
                    <expression name="expression" type="javascript">dataSetRow["CA_billto"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">CA_shipto</property>
                    <text-property name="displayName">CA_shipto</text-property>
                    <expression name="expression" type="javascript">dataSetRow["CA_shipto"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">CA_po8</property>
                    <text-property name="displayName">CA_po8</text-property>
                    <expression name="expression" type="javascript">dataSetRow["CA_po8"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">CA_totalcost</property>
                    <text-property name="displayName">CA_totalcost</text-property>
                    <expression name="expression" type="javascript">dataSetRow["CA_totalcost"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">CA_tax1</property>
                    <text-property name="displayName">CA_tax1</text-property>
                    <expression name="expression" type="javascript">dataSetRow["CA_tax1"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">CA_tax2</property>
                    <text-property name="displayName">CA_tax2</text-property>
                    <expression name="expression" type="javascript">dataSetRow["CA_tax2"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">CA_tax3</property>
                    <text-property name="displayName">CA_tax3</text-property>
                    <expression name="expression" type="javascript">dataSetRow["CA_tax3"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">CA_tax4</property>
                    <text-property name="displayName">CA_tax4</text-property>
                    <expression name="expression" type="javascript">dataSetRow["CA_tax4"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">CA_tax5</property>
                    <text-property name="displayName">CA_tax5</text-property>
                    <expression name="expression" type="javascript">dataSetRow["CA_tax5"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">CA_currencycode</property>
                    <text-property name="displayName">CA_currencycode</text-property>
                    <expression name="expression" type="javascript">dataSetRow["CA_currencycode"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">CA_bc_original</property>
                    <text-property name="displayName">CA_bc_original</text-property>
                    <expression name="expression" type="javascript">dataSetRow["CA_bc_original"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">CA_status</property>
                    <text-property name="displayName">CA_status</text-property>
                    <expression name="expression" type="javascript">dataSetRow["CA_status"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">CA_datebegin</property>
                    <text-property name="displayName">CA_datebegin</text-property>
                    <expression name="expression" type="javascript">dataSetRow["CA_datebegin"]</expression>
                    <property name="dataType">date-time</property>
                </structure>
                <structure>
                    <property name="name">CA_dateend</property>
                    <text-property name="displayName">CA_dateend</text-property>
                    <expression name="expression" type="javascript">dataSetRow["CA_dateend"]</expression>
                    <property name="dataType">date-time</property>
                </structure>
                <structure>
                    <property name="name">CA_co11four</property>
                    <text-property name="displayName">CA_co11four</text-property>
                    <expression name="expression" type="javascript">dataSetRow["CA_co11four"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">CA_email</property>
                    <text-property name="displayName">CA_email</text-property>
                    <expression name="expression" type="javascript">dataSetRow["CA_email"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">CA_co14four</property>
                    <text-property name="displayName">CA_co14four</text-property>
                    <expression name="expression" type="javascript">dataSetRow["CA_co14four"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">CA_namesCli</property>
                    <text-property name="displayName">CA_namesCli</text-property>
                    <expression name="expression" type="javascript">dataSetRow["CA_namesCli"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">CA_cpCli</property>
                    <text-property name="displayName">CA_cpCli</text-property>
                    <expression name="expression" type="javascript">dataSetRow["CA_cpCli"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">CA_villeCli</property>
                    <text-property name="displayName">CA_villeCli</text-property>
                    <expression name="expression" type="javascript">dataSetRow["CA_villeCli"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">CA_maxvaluestatus</property>
                    <text-property name="displayName">CA_maxvaluestatus</text-property>
                    <expression name="expression" type="javascript">dataSetRow["CA_maxvaluestatus"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">descStatus</property>
                    <text-property name="displayName">descStatus</text-property>
                    <expression name="expression" type="javascript">dataSetRow["descStatus"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">potypeStatus</property>
                    <text-property name="displayName">potypeStatus</text-property>
                    <expression name="expression" type="javascript">dataSetRow["potypeStatus"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">CA_maxtype</property>
                    <text-property name="displayName">CA_maxtype</text-property>
                    <expression name="expression" type="javascript">dataSetRow["CA_maxtype"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">CA_maxtypedesc</property>
                    <text-property name="displayName">CA_maxtypedesc</text-property>
                    <expression name="expression" type="javascript">dataSetRow["CA_maxtypedesc"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">CA_originaltype</property>
                    <text-property name="displayName">CA_originaltype</text-property>
                    <expression name="expression" type="javascript">dataSetRow["CA_originaltype"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">CA_shippointname</property>
                    <text-property name="displayName">CA_shippointname</text-property>
                    <expression name="expression" type="javascript">dataSetRow["CA_shippointname"]</expression>
                    <property name="dataType">string</property>
                </structure>
            </list-property>
            <property name="pageBreakInterval">0</property>
            <column id="83">
                <property name="width">1.2916666666666667in</property>
            </column>
            <column id="79">
                <property name="width">1.2916666666666667in</property>
            </column>
            <column id="91"/>
            <column id="87"/>
            <column id="17"/>
            <column id="18"/>
            <group id="1271">
                <property name="groupName">Gpo</property>
                <expression name="keyExpr" type="javascript">row["ponumTxt"]</expression>
                <structure name="toc">
                    <expression name="expressionValue" type="javascript">row["ponumTxt"]</expression>
                </structure>
                <property name="repeatHeader">true</property>
                <property name="hideDetail">false</property>
                <property name="pageBreakAfter">always-excluding-last</property>
                <header>
                    <row id="2074">
                        <cell id="2075">
                            <property name="colSpan">6</property>
                            <property name="rowSpan">1</property>
                            <grid id="2081">
                                <column id="2082">
                                    <property name="width">20%</property>
                                </column>
                                <column id="2083">
                                    <property name="width">60%</property>
                                </column>
                                <column id="2593">
                                    <property name="width">20%</property>
                                </column>
                                <row id="2084">
                                    <cell id="2085">
                                        <property name="width">30%</property>
                                        <property name="verticalAlign">middle</property>
                                        <data id="2423">
                                            <property name="fontFamily">"Arial"</property>
                                            <property name="fontSize">9pt</property>
                                            <property name="fontWeight">bold</property>
                                            <property name="textAlign">left</property>
                                            <property name="resultSetColumn">siteIdTxt</property>
                                        </data>
                                    </cell>
                                    <cell id="2087">
                                        <grid id="2428">
                                            <column id="2429">
                                                <property name="width">50%</property>
                                            </column>
                                            <column id="2430">
                                                <property name="width">20%</property>
                                            </column>
                                            <row id="2432">
                                                <cell id="2433">
                                                    <property name="textAlign">right</property>
                                                    <property name="verticalAlign">middle</property>
                                                    <label id="2093">
                                                        <property name="fontFamily">"Arial"</property>
                                                        <property name="fontSize">medium</property>
                                                        <property name="fontWeight">bold</property>
                                                        <property name="textUnderline">underline</property>
                                                        <text-property name="text">Appel à réapprovisionnement n°</text-property>
                                                    </label>
                                                </cell>
                                                <cell id="2434">
                                                    <property name="textAlign">left</property>
                                                    <property name="verticalAlign">middle</property>
                                                    <data id="2095">
                                                        <property name="fontFamily">"Arial"</property>
                                                        <property name="fontSize">medium</property>
                                                        <property name="fontWeight">bold</property>
                                                        <property name="textUnderline">none</property>
                                                        <property name="textAlign">left</property>
                                                        <property name="resultSetColumn">ponumTxt</property>
                                                    </data>
                                                </cell>
                                            </row>
                                        </grid>
                                    </cell>
                                    <cell id="2587">
                                        <property name="verticalAlign">middle</property>
                                        <data id="2374">
                                            <property name="fontFamily">"Arial"</property>
                                            <property name="fontWeight">bold</property>
                                            <structure name="dateTimeFormat">
                                                <property name="category">Custom</property>
                                                <property name="pattern">dd/MM/yyyy HH:mm:ss</property>
                                            </structure>
                                            <property name="textAlign">right</property>
                                            <property name="resultSetColumn">currentDateTxt</property>
                                        </data>
                                    </cell>
                                </row>
                                <row id="2468">
                                    <cell id="2469">
                                        <property name="width">30%</property>
                                        <property name="textAlign">left</property>
                                    </cell>
                                    <cell id="2470"/>
                                    <cell id="2588">
                                        <data id="2594">
                                            <property name="textAlign">right</property>
                                            <property name="dataSet">dataSetUserName</property>
                                            <list-property name="boundDataColumns">
                                                <structure>
                                                    <property name="name">username</property>
                                                    <expression name="expression" type="javascript">dataSetRow["username"]</expression>
                                                    <property name="dataType">string</property>
                                                </structure>
                                                <structure>
                                                    <property name="name">lastname</property>
                                                    <expression name="expression" type="javascript">dataSetRow["lastname"]</expression>
                                                    <property name="dataType">string</property>
                                                </structure>
                                                <structure>
                                                    <property name="name">firstname</property>
                                                    <expression name="expression" type="javascript">dataSetRow["firstname"]</expression>
                                                    <property name="dataType">string</property>
                                                </structure>
                                            </list-property>
                                            <property name="resultSetColumn">username</property>
                                        </data>
                                    </cell>
                                </row>
                                <row id="2096">
                                    <cell id="2097">
                                        <property name="width">30%</property>
                                        <property name="textAlign">left</property>
                                    </cell>
                                    <cell id="2098"/>
                                    <cell id="2589"/>
                                </row>
                                <row id="2576">
                                    <cell id="2577">
                                        <property name="width">30%</property>
                                        <property name="textAlign">left</property>
                                    </cell>
                                    <cell id="2578"/>
                                    <cell id="2590"/>
                                </row>
                                <row id="2579">
                                    <cell id="2580">
                                        <property name="width">30%</property>
                                        <property name="textAlign">left</property>
                                    </cell>
                                    <cell id="2581"/>
                                    <cell id="2591"/>
                                </row>
                                <row id="2582">
                                    <cell id="2583">
                                        <property name="width">30%</property>
                                        <property name="textAlign">left</property>
                                    </cell>
                                    <cell id="2584"/>
                                    <cell id="2592"/>
                                </row>
                            </grid>
                        </cell>
                    </row>
                </header>
            </group>
            <detail>
                <row id="2120">
                    <property name="style">tabledetailsdatarow</property>
                    <property name="pageBreakAfter">avoid</property>
                    <property name="pageBreakBefore">avoid</property>
                    <cell id="2121">
                        <property name="colSpan">3</property>
                        <property name="rowSpan">1</property>
                        <property name="width">50%</property>
                        <grid id="2236">
                            <column id="2237">
                                <property name="width">50%</property>
                            </column>
                            <row id="2238">
                                <property name="textAlign">left</property>
                                <cell id="2239">
                                    <label id="2244">
                                        <property name="fontFamily">"Arial"</property>
                                        <property name="fontSize">7pt</property>
                                        <property name="fontWeight">bold</property>
                                        <property name="textUnderline">underline</property>
                                        <text-property name="text">Point de livraison</text-property>
                                    </label>
                                </cell>
                            </row>
                            <row id="2622">
                                <property name="textAlign">left</property>
                                <cell id="2623">
                                    <data id="2624">
                                        <property name="fontWeight">bold</property>
                                        <property name="marginBottom">10pt</property>
                                        <structure name="stringFormat">
                                            <property name="category">></property>
                                            <property name="pattern">></property>
                                        </structure>
                                        <list-property name="visibility">
                                            <structure>
                                                <property name="format">all</property>
                                                <expression name="valueExpr" type="javascript">row["CA_shippointname"] == null || row["CA_shippointname"] == " "</expression>
                                            </structure>
                                        </list-property>
                                        <property name="resultSetColumn">CA_shippointname</property>
                                    </data>
                                </cell>
                            </row>
                            <row id="2245">
                                <property name="textAlign">left</property>
                                <cell id="2246">
                                    <data id="2251">
                                        <property name="fontFamily">"Arial"</property>
                                        <property name="fontSize">7pt</property>
                                        <property name="fontWeight">bold</property>
                                        <property name="resultSetColumn">CA_shippointdesc</property>
                                    </data>
                                </cell>
                            </row>
                            <row id="2252">
                                <property name="textAlign">left</property>
                                <cell id="2253">
                                    <data id="2258">
                                        <property name="fontFamily">"Arial"</property>
                                        <property name="fontSize">7pt</property>
                                        <property name="fontWeight">bold</property>
                                        <property name="resultSetColumn">CA_address1Cli</property>
                                    </data>
                                </cell>
                            </row>
                            <row id="2259">
                                <property name="textAlign">left</property>
                                <cell id="2260">
                                    <data id="2621">
                                        <property name="fontWeight">bold</property>
                                        <property name="resultSetColumn">CA_address2Cli</property>
                                    </data>
                                </cell>
                            </row>
                            <row id="2280">
                                <property name="textAlign">left</property>
                                <cell id="2281">
                                    <text id="2286">
                                        <property name="fontFamily">"Arial"</property>
                                        <property name="fontSize">7pt</property>
                                        <property name="fontWeight">bold</property>
                                        <property name="contentType">html</property>
                                        <text-property name="content"><![CDATA[<VALUE-OF format="HTML">cpVilleCli;</VALUE-OF>]]></text-property>
                                    </text>
                                </cell>
                            </row>
                            <row id="2287">
                                <property name="textAlign">left</property>
                                <cell id="2288">
                                    <data id="2293">
                                        <property name="fontFamily">"Arial"</property>
                                        <property name="fontSize">7pt</property>
                                        <property name="fontWeight">bold</property>
                                        <property name="resultSetColumn">CA_paysCli</property>
                                    </data>
                                </cell>
                            </row>
                        </grid>
                    </cell>
                    <cell id="2124">
                        <property name="colSpan">3</property>
                        <property name="rowSpan">1</property>
                        <property name="width">50%</property>
                        <property name="borderBottomColor">#000000</property>
                        <property name="borderBottomStyle">solid</property>
                        <property name="borderBottomWidth">thin</property>
                        <property name="borderLeftColor">#000000</property>
                        <property name="borderLeftStyle">solid</property>
                        <property name="borderLeftWidth">thin</property>
                        <property name="borderRightColor">#000000</property>
                        <property name="borderRightStyle">solid</property>
                        <property name="borderRightWidth">thin</property>
                        <property name="borderTopColor">#000000</property>
                        <property name="borderTopStyle">solid</property>
                        <property name="borderTopWidth">thin</property>
                        <property name="textAlign">left</property>
                        <grid id="2294">
                            <column id="2295"/>
                            <row id="2296">
                                <cell id="2297">
                                    <data id="2620">
                                        <property name="fontWeight">bold</property>
                                        <structure name="stringFormat">
                                            <property name="category">></property>
                                            <property name="pattern">></property>
                                        </structure>
                                        <property name="resultSetColumn">CA_namesfour</property>
                                    </data>
                                </cell>
                            </row>
                            <row id="2303">
                                <list-property name="visibility">
                                    <structure>
                                        <property name="format">all</property>
                                        <expression name="valueExpr" type="javascript">row["CA_contactfour"] == null || row["CA_contactfour"] == " "</expression>
                                    </structure>
                                </list-property>
                                <cell id="2304">
                                    <text-data id="2399">
                                        <expression name="valueExpr">"A l'attention de : " + (row["CA_contactfour"] == null ? " " : row["CA_contactfour"])</expression>
                                        <property name="contentType">html</property>
                                    </text-data>
                                </cell>
                            </row>
                            <row id="2313">
                                <list-property name="visibility">
                                    <structure>
                                        <property name="format">all</property>
                                        <expression name="valueExpr" type="javascript">row["CA_address1four"] == null || row["CA_address1four"] == " "</expression>
                                    </structure>
                                </list-property>
                                <cell id="2314">
                                    <data id="2319">
                                        <property name="fontFamily">"Arial"</property>
                                        <property name="fontSize">7pt</property>
                                        <property name="fontWeight">bold</property>
                                        <property name="resultSetColumn">CA_address1four</property>
                                    </data>
                                </cell>
                            </row>
                            <row id="2617">
                                <list-property name="visibility">
                                    <structure>
                                        <property name="format">all</property>
                                        <expression name="valueExpr" type="javascript">row["CA_address3four"] == null || row["CA_address3four"] == " "</expression>
                                    </structure>
                                </list-property>
                                <cell id="2618">
                                    <data id="2326">
                                        <property name="fontFamily">"Arial"</property>
                                        <property name="fontSize">7pt</property>
                                        <property name="fontWeight">bold</property>
                                        <property name="resultSetColumn">CA_address3four</property>
                                    </data>
                                </cell>
                            </row>
                            <row id="2320">
                                <cell id="2321">
                                    <data id="2619">
                                        <property name="fontWeight">bold</property>
                                        <property name="resultSetColumn">CA_co10four</property>
                                    </data>
                                </cell>
                            </row>
                            <row id="2625">
                                <list-property name="visibility">
                                    <structure>
                                        <property name="format">all</property>
                                        <expression name="valueExpr" type="javascript">row["CA_address3four"] == null || row["CA_address3four"] == " "</expression>
                                    </structure>
                                </list-property>
                                <cell id="2626">
                                    <data id="2627">
                                        <property name="fontWeight">bold</property>
                                        <property name="resultSetColumn">CA_co11four</property>
                                    </data>
                                </cell>
                            </row>
                            <row id="2327">
                                <cell id="2328">
                                    <text id="2421">
                                        <property name="fontFamily">"Arial"</property>
                                        <property name="fontWeight">bold</property>
                                        <property name="contentType">html</property>
                                        <text-property name="content"><![CDATA[<VALUE-OF format="HTML">(row["cpFourTxt"] == null ? " " : row["cpFourTxt"]) + " " + (row["villeFourTxt"] == null ? " " : row["villeFourTxt"]);</VALUE-OF>]]></text-property>
                                    </text>
                                </cell>
                            </row>
                            <row id="2330">
                                <cell id="2331">
                                    <data id="2420">
                                        <property name="fontFamily">"Arial"</property>
                                        <property name="fontWeight">bold</property>
                                        <property name="resultSetColumn">paysFourTxt</property>
                                    </data>
                                </cell>
                            </row>
                        </grid>
                    </cell>
                </row>
                <row id="2113">
                    <property name="style">tabledetailsdatarow</property>
                    <property name="pageBreakAfter">avoid</property>
                    <property name="pageBreakBefore">avoid</property>
                    <cell id="2114">
                        <property name="colSpan">3</property>
                        <property name="rowSpan">1</property>
                        <property name="width">50%</property>
                    </cell>
                    <cell id="2117">
                        <property name="colSpan">3</property>
                        <property name="rowSpan">1</property>
                        <property name="width">50%</property>
                        <grid id="2338">
                            <column id="2339">
                                <property name="width">0.3645833333333333in</property>
                            </column>
                            <column id="2340">
                                <property name="width">0.90625in</property>
                                <property name="textAlign">left</property>
                            </column>
                            <column id="2341"/>
                            <column id="2342">
                                <property name="width">0.365in</property>
                            </column>
                            <column id="2343">
                                <property name="width">0.8958333333333334in</property>
                                <property name="textAlign">left</property>
                            </column>
                            <column id="2344"/>
                            <row id="2345">
                                <cell id="2346">
                                    <property name="colSpan">2</property>
                                    <property name="rowSpan">1</property>
                                    <property name="fontFamily">"Arial"</property>
                                    <property name="textAlign">left</property>
                                    <text-data id="2347">
                                        <property name="textAlign">left</property>
                                        <expression name="valueExpr">"Tél : "+ (row["phonefourTxt"] == null ? " " : row["phonefourTxt"])</expression>
                                        <property name="contentType">html</property>
                                    </text-data>
                                </cell>
                                <cell id="2348"/>
                                <cell id="2349">
                                    <property name="colSpan">2</property>
                                    <property name="rowSpan">1</property>
                                    <property name="fontFamily">"Arial"</property>
                                    <property name="textAlign">left</property>
                                    <text-data id="2350">
                                        <property name="fontFamily">"Arial"</property>
                                        <expression name="valueExpr">"Fax : "+ (row["faxfourTxt"] == null ? " " : row["faxfourTxt"])</expression>
                                        <property name="contentType">html</property>
                                    </text-data>
                                </cell>
                                <cell id="2351"/>
                            </row>
                        </grid>
                    </cell>
                </row>
                <row id="2106">
                    <property name="style">tabledetailsdatarow</property>
                    <property name="pageBreakAfter">avoid</property>
                    <property name="pageBreakBefore">avoid</property>
                    <cell id="2107">
                        <property name="colSpan">3</property>
                        <property name="rowSpan">1</property>
                        <property name="width">50%</property>
                    </cell>
                    <cell id="2110">
                        <property name="colSpan">3</property>
                        <property name="rowSpan">1</property>
                        <property name="width">50%</property>
                        <grid id="2353">
                            <column id="2354">
                                <property name="width">1.03125in</property>
                            </column>
                            <column id="2355">
                                <property name="width">1.5104166666666667in</property>
                                <property name="textAlign">left</property>
                            </column>
                            <column id="2356"/>
                            <row id="2357">
                                <cell id="2358">
                                    <property name="colSpan">2</property>
                                    <property name="rowSpan">1</property>
                                    <property name="textAlign">left</property>
                                    <text-data id="2359">
                                        <expression name="valueExpr">"Code fournisseur : " + (row["vendorfourTxt"] == null ? " "  : row["vendorfourTxt"] )</expression>
                                        <property name="contentType">html</property>
                                    </text-data>
                                </cell>
                                <cell id="2360"/>
                            </row>
                        </grid>
                    </cell>
                </row>
                <row id="2368">
                    <property name="style">tabledetailsdatarow</property>
                    <property name="pageBreakAfter">avoid</property>
                    <property name="pageBreakBefore">avoid</property>
                    <cell id="2369">
                        <property name="colSpan">3</property>
                        <property name="rowSpan">1</property>
                        <property name="width">50%</property>
                    </cell>
                    <cell id="2372">
                        <property name="colSpan">3</property>
                        <property name="rowSpan">1</property>
                    </cell>
                </row>
                <row id="2361">
                    <property name="style">tabledetailsdatarow</property>
                    <property name="pageBreakAfter">avoid</property>
                    <property name="pageBreakBefore">avoid</property>
                    <cell id="2362">
                        <property name="colSpan">3</property>
                        <property name="rowSpan">1</property>
                        <property name="width">50%</property>
                        <property name="textAlign">left</property>
                        <grid id="2375">
                            <column id="2376">
                                <property name="width">29%</property>
                            </column>
                            <column id="2377">
                                <property name="width">71%</property>
                                <property name="textAlign">left</property>
                            </column>
                            <row id="2378">
                                <cell id="2379">
                                    <property name="textAlign">left</property>
                                    <label id="2380">
                                        <property name="fontFamily">"Arial"</property>
                                        <property name="fontWeight">bold</property>
                                        <property name="textAlign">left</property>
                                        <text-property name="text">Date de génération :</text-property>
                                    </label>
                                </cell>
                                <cell id="2381">
                                    <data id="2382">
                                        <property name="fontFamily">"Arial"</property>
                                        <property name="fontWeight">bold</property>
                                        <structure name="dateTimeFormat">
                                            <property name="category">Custom</property>
                                            <property name="pattern">dd/MM/yyyy HH:mm:ss</property>
                                        </structure>
                                        <property name="resultSetColumn">statusdateTxt</property>
                                    </data>
                                </cell>
                            </row>
                        </grid>
                    </cell>
                    <cell id="2365">
                        <property name="colSpan">3</property>
                        <property name="rowSpan">1</property>
                        <property name="width">50%</property>
                        <property name="textAlign">left</property>
                        <data id="2390">
                            <property name="fontWeight">bold</property>
                            <property name="color">blue</property>
                            <list-property name="visibility">
                                <structure>
                                    <property name="format">all</property>
                                    <expression name="valueExpr" type="javascript">true</expression>
                                </structure>
                            </list-property>
                            <property name="resultSetColumn">nbLigTxt</property>
                        </data>
                    </cell>
                </row>
                <row id="2383">
                    <property name="style">tabledetailsdatarow</property>
                    <property name="pageBreakAfter">avoid</property>
                    <property name="pageBreakBefore">avoid</property>
                    <cell id="2384">
                        <property name="colSpan">3</property>
                        <property name="rowSpan">1</property>
                        <property name="width">50%</property>
                        <property name="textAlign">left</property>
                        <grid id="2391">
                            <column id="2392">
                                <property name="width">29%</property>
                                <property name="fontFamily">"Arial Baltic"</property>
                            </column>
                            <column id="2393">
                                <property name="width">71%</property>
                                <property name="textAlign">left</property>
                            </column>
                            <row id="2394">
                                <cell id="2395">
                                    <property name="textAlign">left</property>
                                    <label id="2396">
                                        <property name="fontFamily">"Arial"</property>
                                        <property name="fontWeight">bold</property>
                                        <text-property name="text">Date d'édition : </text-property>
                                    </label>
                                </cell>
                                <cell id="2397">
                                    <data id="2398">
                                        <property name="fontFamily">"Arial"</property>
                                        <property name="fontWeight">bold</property>
                                        <structure name="dateTimeFormat">
                                            <property name="category">Custom</property>
                                            <property name="pattern">dd/MM/yyyy HH:mm:ss</property>
                                        </structure>
                                        <property name="textAlign">left</property>
                                        <property name="resultSetColumn">actdateTxt</property>
                                    </data>
                                </cell>
                            </row>
                        </grid>
                    </cell>
                    <cell id="2387">
                        <property name="colSpan">3</property>
                        <property name="rowSpan">1</property>
                        <property name="width">50%</property>
                    </cell>
                </row>
                <row id="2099">
                    <property name="style">tabledetailsdatarow</property>
                    <property name="pageBreakAfter">avoid</property>
                    <property name="pageBreakBefore">avoid</property>
                    <cell id="2100">
                        <property name="colSpan">3</property>
                        <property name="rowSpan">1</property>
                        <property name="width">50%</property>
                    </cell>
                    <cell id="2103">
                        <property name="colSpan">3</property>
                        <property name="rowSpan">1</property>
                        <property name="width">50%</property>
                    </cell>
                </row>
                <row id="11">
                    <property name="style">tabledetailsdatarow</property>
                    <property name="pageBreakAfter">auto</property>
                    <property name="pageBreakBefore">auto</property>
                    <property name="pageBreakInside">auto</property>
                    <cell id="81">
                        <property name="colSpan">6</property>
                        <property name="rowSpan">1</property>
                        <property name="width">100%</property>
                        <grid id="1437">
                            <column id="1438"/>
                            <row id="1439">
                                <list-property name="visibility">
                                    <structure>
                                        <property name="format">all</property>
                                        <expression name="valueExpr" type="javascript">row["nbLigTxt"] == 0</expression>
                                    </structure>
                                </list-property>
                                <cell id="1440">
                                    <table id="1441">
                                        <property name="pageBreakInside">auto</property>
                                        <property name="dataSet">dataSetPoline</property>
                                        <list-property name="visibility">
                                            <structure>
                                                <property name="format">all</property>
                                                <expression name="valueExpr" type="javascript">row._outer["nbLigTxt"] == 0</expression>
                                            </structure>
                                        </list-property>
                                        <list-property name="boundDataColumns">
                                            <structure>
                                                <property name="name">CA_polinenum</property>
                                                <text-property name="displayName">CA_polinenum</text-property>
                                                <expression name="expression" type="javascript">dataSetRow["CA_polinenum"]</expression>
                                                <property name="dataType">string</property>
                                            </structure>
                                            <structure>
                                                <property name="name">CA_refbp</property>
                                                <text-property name="displayName">CA_refbp</text-property>
                                                <expression name="expression" type="javascript">dataSetRow["CA_refbp"]</expression>
                                                <property name="dataType">string</property>
                                            </structure>
                                            <structure>
                                                <property name="name">CA_linedesc</property>
                                                <text-property name="displayName">CA_linedesc</text-property>
                                                <expression name="expression" type="javascript">dataSetRow["CA_linedesc"]</expression>
                                                <property name="dataType">string</property>
                                            </structure>
                                            <structure>
                                                <property name="name">CA_orderqty</property>
                                                <text-property name="displayName">CA_orderqty</text-property>
                                                <expression name="expression" type="javascript">dataSetRow["CA_orderqty"]</expression>
                                                <property name="dataType">string</property>
                                            </structure>
                                            <structure>
                                                <property name="name">CA_unitcost</property>
                                                <text-property name="displayName">CA_unitcost</text-property>
                                                <expression name="expression" type="javascript">dataSetRow["CA_unitcost"]</expression>
                                                <property name="dataType">string</property>
                                            </structure>
                                            <structure>
                                                <property name="name">CA_polineitemnum</property>
                                                <text-property name="displayName">CA_polineitemnum</text-property>
                                                <expression name="expression" type="javascript">dataSetRow["CA_polineitemnum"]</expression>
                                                <property name="dataType">string</property>
                                            </structure>
                                            <structure>
                                                <property name="name">CA_orderunit</property>
                                                <text-property name="displayName">CA_orderunit</text-property>
                                                <expression name="expression" type="javascript">dataSetRow["CA_orderunit"]</expression>
                                                <property name="dataType">string</property>
                                            </structure>
                                            <structure>
                                                <property name="name">CA_catalogcode</property>
                                                <text-property name="displayName">CA_catalogcode</text-property>
                                                <expression name="expression" type="javascript">dataSetRow["CA_catalogcode"]</expression>
                                                <property name="dataType">string</property>
                                            </structure>
                                            <structure>
                                                <property name="name">CA_livraison</property>
                                                <text-property name="displayName">CA_livraison</text-property>
                                                <expression name="expression" type="javascript">dataSetRow["CA_livraison"]</expression>
                                                <property name="dataType">string</property>
                                            </structure>
                                            <structure>
                                                <property name="name">CA_lineclause</property>
                                                <text-property name="displayName">CA_lineclause</text-property>
                                                <expression name="expression" type="javascript">dataSetRow["CA_lineclause"]</expression>
                                                <property name="dataType">string</property>
                                            </structure>
                                            <structure>
                                                <property name="name">CA_itemdesc</property>
                                                <text-property name="displayName">CA_itemdesc</text-property>
                                                <expression name="expression" type="javascript">dataSetRow["CA_itemdesc"]</expression>
                                                <property name="dataType">string</property>
                                            </structure>
                                            <structure>
                                                <property name="name">polinenumTxt</property>
                                                <text-property name="displayName">lg</text-property>
                                                <expression name="expression" type="javascript">dataSetRow["CA_polinenum"]</expression>
                                                <property name="dataType">string</property>
                                                <property name="allowExport">true</property>
                                            </structure>
                                            <structure>
                                                <property name="name">itemTxt</property>
                                                <text-property name="displayName">itm</text-property>
                                                <expression name="expression" type="javascript">dataSetRow["CA_polineitemnum"]</expression>
                                                <property name="dataType">string</property>
                                                <property name="allowExport">true</property>
                                            </structure>
                                            <structure>
                                                <property name="name">itemRefbpTxt</property>
                                                <text-property name="displayName">itmrf</text-property>
                                                <expression name="expression" type="javascript">dataSetRow["CA_refbp"]</expression>
                                                <property name="dataType">string</property>
                                                <property name="allowExport">true</property>
                                            </structure>
                                            <structure>
                                                <property name="name">casierTxt</property>
                                                <text-property name="displayName">csr</text-property>
                                                <expression name="expression" type="javascript">dataSetRow["casier"]</expression>
                                                <property name="dataType">string</property>
                                                <property name="allowExport">true</property>
                                            </structure>
                                            <structure>
                                                <property name="name">orderQteTxt</property>
                                                <text-property name="displayName">qte</text-property>
                                                <expression name="expression" type="javascript">dataSetRow["CA_orderqty"]</expression>
                                                <property name="dataType">string</property>
                                                <property name="allowExport">true</property>
                                            </structure>
                                            <structure>
                                                <property name="name">orderUnitTxt</property>
                                                <text-property name="displayName">unt</text-property>
                                                <expression name="expression" type="javascript">dataSetRow["CA_orderunit"]</expression>
                                                <property name="dataType">string</property>
                                                <property name="allowExport">true</property>
                                            </structure>
                                            <structure>
                                                <property name="name">itemDescTxt</property>
                                                <text-property name="displayName">dsc</text-property>
                                                <expression name="expression" type="javascript">dataSetRow["CA_itemdesc"]</expression>
                                                <property name="dataType">string</property>
                                                <property name="allowExport">true</property>
                                            </structure>
                                            <structure>
                                                <property name="name">itemLongdescTxt</property>
                                                <text-property name="displayName">itmlgdscTxt</text-property>
                                                <expression name="expression" type="javascript">dataSetRow["CA_itemlongdesc"]</expression>
                                                <property name="dataType">string</property>
                                                <property name="allowExport">true</property>
                                            </structure>
                                        </list-property>
                                        <property name="pageBreakInterval">0</property>
                                        <column id="1462">
                                            <property name="width">5%</property>
                                            <property name="textAlign">left</property>
                                        </column>
                                        <column id="1463">
                                            <property name="width">20%</property>
                                            <property name="textAlign">left</property>
                                        </column>
                                        <column id="1464">
                                            <property name="width">60%</property>
                                            <property name="textAlign">left</property>
                                        </column>
                                        <column id="1465">
                                            <property name="width">15%</property>
                                            <property name="textAlign">left</property>
                                        </column>
                                        <header>
                                            <row id="1442">
                                                <property name="backgroundColor">#C0C0C0</property>
                                                <property name="fontFamily">"Arial"</property>
                                                <property name="pageBreakAfter">avoid</property>
                                                <property name="pageBreakBefore">avoid</property>
                                                <cell id="1443">
                                                    <property name="borderBottomColor">#000000</property>
                                                    <property name="borderBottomStyle">solid</property>
                                                    <property name="borderBottomWidth">1px</property>
                                                    <property name="borderLeftColor">#000000</property>
                                                    <property name="borderLeftStyle">solid</property>
                                                    <property name="borderLeftWidth">1px</property>
                                                    <property name="borderRightColor">#000000</property>
                                                    <property name="borderRightStyle">solid</property>
                                                    <property name="borderRightWidth">1px</property>
                                                    <property name="borderTopColor">#000000</property>
                                                    <property name="borderTopStyle">solid</property>
                                                    <property name="borderTopWidth">1px</property>
                                                    <property name="textAlign">left</property>
                                                    <grid id="1502">
                                                        <property name="textAlign">left</property>
                                                        <column id="1503"/>
                                                        <row id="1504">
                                                            <cell id="1505">
                                                                <label id="1466">
                                                                    <property name="fontFamily">"Arial"</property>
                                                                    <property name="fontWeight">bold</property>
                                                                    <property name="textAlign">left</property>
                                                                    <text-property name="text">ligne</text-property>
                                                                </label>
                                                            </cell>
                                                        </row>
                                                    </grid>
                                                </cell>
                                                <cell id="1444">
                                                    <property name="borderBottomColor">#000000</property>
                                                    <property name="borderBottomStyle">solid</property>
                                                    <property name="borderBottomWidth">1px</property>
                                                    <property name="borderLeftColor">#000000</property>
                                                    <property name="borderLeftStyle">solid</property>
                                                    <property name="borderLeftWidth">1px</property>
                                                    <property name="borderRightColor">#000000</property>
                                                    <property name="borderRightStyle">solid</property>
                                                    <property name="borderRightWidth">1px</property>
                                                    <property name="borderTopColor">#000000</property>
                                                    <property name="borderTopStyle">solid</property>
                                                    <property name="borderTopWidth">1px</property>
                                                    <property name="textAlign">left</property>
                                                    <grid id="1506">
                                                        <column id="1507"/>
                                                        <row id="1508">
                                                            <cell id="1509">
                                                                <property name="textAlign">left</property>
                                                                <label id="1467">
                                                                    <property name="fontFamily">"Arial"</property>
                                                                    <property name="fontWeight">bold</property>
                                                                    <property name="textAlign">left</property>
                                                                    <text-property name="text">Réf. Article / Casier</text-property>
                                                                </label>
                                                            </cell>
                                                        </row>
                                                    </grid>
                                                </cell>
                                                <cell id="1445">
                                                    <property name="borderBottomColor">#000000</property>
                                                    <property name="borderBottomStyle">solid</property>
                                                    <property name="borderBottomWidth">1px</property>
                                                    <property name="borderLeftColor">#000000</property>
                                                    <property name="borderLeftStyle">solid</property>
                                                    <property name="borderLeftWidth">1px</property>
                                                    <property name="borderRightColor">#000000</property>
                                                    <property name="borderRightStyle">solid</property>
                                                    <property name="borderRightWidth">1px</property>
                                                    <property name="borderTopColor">#000000</property>
                                                    <property name="borderTopStyle">solid</property>
                                                    <property name="borderTopWidth">1px</property>
                                                    <property name="textAlign">left</property>
                                                    <grid id="1510">
                                                        <column id="1511"/>
                                                        <row id="1512">
                                                            <cell id="1513">
                                                                <property name="textAlign">left</property>
                                                                <label id="1468">
                                                                    <property name="fontFamily">"Arial"</property>
                                                                    <property name="fontWeight">bold</property>
                                                                    <property name="textAlign">left</property>
                                                                    <text-property name="text">Désignation</text-property>
                                                                </label>
                                                            </cell>
                                                        </row>
                                                    </grid>
                                                </cell>
                                                <cell id="1446">
                                                    <property name="borderBottomColor">#000000</property>
                                                    <property name="borderBottomStyle">solid</property>
                                                    <property name="borderBottomWidth">1px</property>
                                                    <property name="borderLeftColor">#000000</property>
                                                    <property name="borderLeftStyle">solid</property>
                                                    <property name="borderLeftWidth">1px</property>
                                                    <property name="borderRightColor">#000000</property>
                                                    <property name="borderRightStyle">solid</property>
                                                    <property name="borderRightWidth">1px</property>
                                                    <property name="borderTopColor">#000000</property>
                                                    <property name="borderTopStyle">solid</property>
                                                    <property name="borderTopWidth">1px</property>
                                                    <property name="textAlign">left</property>
                                                    <grid id="1514">
                                                        <property name="textAlign">left</property>
                                                        <column id="1515"/>
                                                        <row id="1516">
                                                            <cell id="1517">
                                                                <label id="1469">
                                                                    <property name="fontFamily">"Arial"</property>
                                                                    <property name="fontWeight">bold</property>
                                                                    <property name="textAlign">left</property>
                                                                    <text-property name="text">Quantité</text-property>
                                                                </label>
                                                            </cell>
                                                        </row>
                                                    </grid>
                                                </cell>
                                            </row>
                                        </header>
                                        <detail>
                                            <row id="1447">
                                                <cell id="1448">
                                                    <property name="borderBottomColor">#000000</property>
                                                    <property name="borderBottomStyle">solid</property>
                                                    <property name="borderBottomWidth">1px</property>
                                                    <property name="borderLeftColor">#000000</property>
                                                    <property name="borderLeftStyle">solid</property>
                                                    <property name="borderLeftWidth">1px</property>
                                                    <property name="borderRightColor">#000000</property>
                                                    <property name="borderRightStyle">solid</property>
                                                    <property name="borderRightWidth">1px</property>
                                                    <property name="borderTopColor">#000000</property>
                                                    <property name="borderTopStyle">solid</property>
                                                    <property name="borderTopWidth">1px</property>
                                                    <property name="textAlign">left</property>
                                                    <grid id="1498">
                                                        <property name="textAlign">left</property>
                                                        <column id="1499"/>
                                                        <row id="1500">
                                                            <cell id="1501">
                                                                <data id="1470">
                                                                    <property name="fontFamily">"Arial"</property>
                                                                    <property name="fontWeight">bold</property>
                                                                    <property name="textAlign">left</property>
                                                                    <property name="resultSetColumn">polinenumTxt</property>
                                                                </data>
                                                            </cell>
                                                        </row>
                                                    </grid>
                                                </cell>
                                                <cell id="1449">
                                                    <property name="borderBottomColor">#000000</property>
                                                    <property name="borderBottomStyle">solid</property>
                                                    <property name="borderBottomWidth">1px</property>
                                                    <property name="borderLeftColor">#000000</property>
                                                    <property name="borderLeftStyle">solid</property>
                                                    <property name="borderLeftWidth">1px</property>
                                                    <property name="borderRightColor">#000000</property>
                                                    <property name="borderRightStyle">solid</property>
                                                    <property name="borderRightWidth">1px</property>
                                                    <property name="borderTopColor">#000000</property>
                                                    <property name="borderTopStyle">solid</property>
                                                    <property name="borderTopWidth">1px</property>
                                                    <property name="textAlign">left</property>
                                                    <grid id="1518">
                                                        <column id="1519"/>
                                                        <row id="1520">
                                                            <cell id="1521">
                                                                <text-data id="1490">
                                                                    <property name="fontFamily">"Arial"</property>
                                                                    <property name="fontWeight">bold</property>
                                                                    <property name="textAlign">left</property>
                                                                    <expression name="valueExpr">(row["itemRefbpTxt"] == null ? " " : row["itemRefbpTxt"] ) + (row["casierTxt"] == null ? "  " : " / ["+row["casierTxt"]+"]")</expression>
                                                                    <property name="contentType">html</property>
                                                                </text-data>
                                                            </cell>
                                                        </row>
                                                    </grid>
                                                </cell>
                                                <cell id="1450">
                                                    <property name="fontFamily">"Arial"</property>
                                                    <property name="borderBottomColor">#000000</property>
                                                    <property name="borderBottomStyle">solid</property>
                                                    <property name="borderBottomWidth">1px</property>
                                                    <property name="borderLeftColor">#000000</property>
                                                    <property name="borderLeftStyle">solid</property>
                                                    <property name="borderLeftWidth">1px</property>
                                                    <property name="borderRightColor">#000000</property>
                                                    <property name="borderRightStyle">solid</property>
                                                    <property name="borderRightWidth">1px</property>
                                                    <property name="borderTopColor">#000000</property>
                                                    <property name="borderTopStyle">solid</property>
                                                    <property name="borderTopWidth">1px</property>
                                                    <property name="textAlign">left</property>
                                                    <grid id="1533">
                                                        <column id="1534"/>
                                                        <row id="1535">
                                                            <cell id="1536">
                                                                <data id="1497">
                                                                    <property name="fontWeight">bold</property>
                                                                    <property name="resultSetColumn">itemDescTxt</property>
                                                                </data>
                                                            </cell>
                                                        </row>
                                                        <row id="1537">
                                                            <cell id="1538">
                                                                <text-data id="1982">
                                                                    <expression name="valueExpr">row["itemLongdescTxt"]</expression>
                                                                    <property name="contentType">html</property>
                                                                </text-data>
                                                            </cell>
                                                        </row>
                                                    </grid>
                                                </cell>
                                                <cell id="1451">
                                                    <property name="borderBottomColor">#000000</property>
                                                    <property name="borderBottomStyle">solid</property>
                                                    <property name="borderBottomWidth">1px</property>
                                                    <property name="borderLeftColor">#000000</property>
                                                    <property name="borderLeftStyle">solid</property>
                                                    <property name="borderLeftWidth">1px</property>
                                                    <property name="borderRightColor">#000000</property>
                                                    <property name="borderRightStyle">solid</property>
                                                    <property name="borderRightWidth">1px</property>
                                                    <property name="borderTopColor">#000000</property>
                                                    <property name="borderTopStyle">solid</property>
                                                    <property name="borderTopWidth">1px</property>
                                                    <grid id="1526">
                                                        <column id="1527"/>
                                                        <row id="1528">
                                                            <cell id="1529">
                                                                <data id="1493">
                                                                    <property name="fontFamily">"Arial"</property>
                                                                    <property name="fontWeight">bold</property>
                                                                    <structure name="numberFormat">
                                                                        <property name="category">Unformatted</property>
                                                                    </structure>
                                                                    <property name="textAlign">center</property>
                                                                    <property name="resultSetColumn">orderQteTxt</property>
                                                                </data>
                                                            </cell>
                                                        </row>
                                                        <row id="1530">
                                                            <cell id="1531">
                                                                <data id="1494">
                                                                    <property name="fontFamily">"Arial"</property>
                                                                    <property name="fontWeight">bold</property>
                                                                    <property name="textAlign">center</property>
                                                                    <property name="resultSetColumn">orderUnitTxt</property>
                                                                </data>
                                                            </cell>
                                                        </row>
                                                    </grid>
                                                </cell>
                                            </row>
                                        </detail>
                                    </table>
                                </cell>
                            </row>
                        </grid>
                    </cell>
                </row>
            </detail>
        </table>
    </body>
</report>
