git.roojs.org Git - xtuple/blob - foundation-database/public/tables/report/InventoryAvailabilityBySalesOrder.xml

   1 <!DOCTYPE openRPTDef>
   2 <report>
   3  <title>Inventory Availability by Sales Order</title>
   4  <name>InventoryAvailabilityBySalesOrder</name>
   5  <description></description>
   6  <size>Letter</size>
   7  <portrait/>
   8  <topmargin>50</topmargin>
   9  <bottommargin>50</bottommargin>
  10  <rightmargin>50</rightmargin>
  11  <leftmargin>50</leftmargin>
  12  <querysource>
  13   <name>head</name>
  14   <sql>SELECT cohead_number,
  15        formatDate(cohead_orderdate) AS orderdate,
  16        cohead_custponumber,
  17        cust_name,
  18        cntct_phone AS cust_phone,
  19        &lt;? if exists("onlyShowShortages") ?>
  20          text('Only Showing Shortages')
  21        &lt;? else ?>
  22          text('')
  23        &lt;? endif ?>
  24        AS f_onlyShowShortages,
  25       &lt;? if exists("showWoSupply") ?>
  26          text('Show W/O Supply')
  27        &lt;? else ?>
  28          text('')
  29        &lt;? endif ?>
  30        AS f_showWoSupply
  31   FROM cohead, custinfo
  32   LEFT OUTER JOIN cntct ON (cust_cntct_id=cntct_id)
  33   LEFT OUTER JOIN addr ON (cntct_addr_id=addr_id)
  34  WHERE ((cohead_cust_id=cust_id)
  35    AND (cohead_id=&lt;? value("sohead_id") ?>) );</sql>
  36  </querysource>
  37  <querysource>
  38   <name>detail</name>
  39   <sql>SELECT itemsite_id, coitem_id,
  40                         item_number, item_description, uom_name, item_picklist,
  41                         qoh, formatQty(qoh) AS f_qoh,sobalance,
  42                         formatQty(sobalance) AS f_sobalance,
  43                         formatQty(allocated) AS f_allocated,
  44                         ordered, formatQty(ordered) AS f_ordered,
  45                         (qoh + ordered - sobalance) AS woavail,
  46                         formatQty(qoh + ordered - sobalance) AS f_soavail,
  47                         (qoh + ordered - allocated) AS totalavail,
  48                         formatQty(qoh + ordered - allocated) AS f_totalavail,
  49                         atshipping,formatQty(atshipping) AS f_atshipping,
  50                         reorderlevel
  51                  &lt;? if exists(showWoSupply) ?>,
  52                         wo_id,
  53                         wo_status,
  54                         wo_number,
  55                         wo_ordered,
  56                         CASE WHEN (wo_id = -1) THEN NULL ELSE formatQty(wo_ordered) END AS f_wo_ordered,
  57                         formatdate(wo_startdate) AS f_wo_startdate,
  58                         formatdate(wo_duedate) AS f_wo_duedate,
  59                         COALESCE(wo_latestart,false) AS wo_latestart,
  60                         COALESCE(wo_latedue,false) AS wo_latedue
  61                  &lt;? endif ?>
  62                  FROM ( SELECT itemsite_id, coitem_id,
  63                                item_number, (item_descrip1 || ' ' || item_descrip2) AS item_description,
  64                                uom_name, item_picklist,
  65                                noNeg(itemsite_qtyonhand) AS qoh,
  66                                noNeg(coitem_qtyord - coitem_qtyshipped + coitem_qtyreturned) AS sobalance,
  67                                qtyAllocated(itemsite_id, coitem_scheddate) AS allocated,
  68                                qtyOrdered(itemsite_id, coitem_scheddate) AS ordered,
  69                                qtyatshipping(coitem_id) AS atshipping,
  70                                CASE WHEN(itemsite_useparams) THEN itemsite_reorderlevel ELSE 0.0 END AS reorderlevel
  71                  &lt;? if exists(showWoSupply) ?>,
  72                                COALESCE(wo_id,-1) AS wo_id,
  73                                formatwonumber(wo_id) AS wo_number,
  74                                noNeg((wo_qtyord-wo_qtyrcv)) AS wo_ordered,
  75                                wo_status, wo_startdate, wo_duedate,
  76                                ((wo_startdate &lt;= CURRENT_DATE) AND (wo_status IN ('O','E','S','R'))) AS wo_latestart,
  77                                (wo_duedate&lt;=CURRENT_DATE) AS wo_latedue
  78                  &lt;? endif ?>
  79                         FROM cohead, itemsite, item, uom, coitem
  80                  &lt;? if exists(showWoSupply) ?>
  81                              LEFT OUTER JOIN wo
  82                               ON ((coitem_itemsite_id=wo_itemsite_id)
  83                               AND (wo_status IN ('E','R','I'))
  84                               AND (wo_qtyord-wo_qtyrcv > 0)
  85                               AND (noNeg(coitem_qtyord - coitem_qtyshipped + coitem_qtyreturned-qtyatshipping(coitem_id)) >
  86                                (SELECT itemsite_qtyonhand FROM itemsite WHERE (itemsite_id=coitem_itemsite_id))))
  87                  &lt;? endif ?>
  88                         WHERE ( (coitem_cohead_id=cohead_id)
  89                          AND (coitem_itemsite_id=itemsite_id)
  90                          AND (itemsite_item_id=item_id)
  91                          AND (item_inv_uom_id=uom_id)
  92                          AND (coitem_status NOT IN ('C', 'X'))
  93                          AND (cohead_id=&lt;? value(sohead_id) ?>))
  94                  ) AS data
  95                       &lt;? if exists(onlyShowShortages) ?>
  96                  WHERE ( ((qoh + ordered - allocated) &lt; 0)
  97                   OR ((qoh + ordered - sobalance) &lt; 0) )
  98                  &lt;? endif ?>
  99                  ORDER BY item_number
 100                  &lt;? if exists(showWoSupply) ?> ,
 101                  wo_duedate
 102                  &lt;? endif ?>
 103                  ;</sql>
 104  </querysource>
 105  <rpthead>
 106   <height>251</height>
 107   <label>
 108    <rect>
 109     <x>430</x>
 110     <y>230</y>
 111     <width>100</width>
 112     <height>15</height>
 113    </rect>
 114    <font>
 115     <face>Arial</face>
 116     <size>8</size>
 117     <weight>normal</weight>
 118    </font>
 119    <hcenter/>
 120    <vcenter/>
 121    <string>Qty Due</string>
 122   </label>
 123   <label>
 124    <rect>
 125     <x>432</x>
 126     <y>215</y>
 127     <width>100</width>
 128     <height>15</height>
 129    </rect>
 130    <font>
 131     <face>Arial</face>
 132     <size>8</size>
 133     <weight>normal</weight>
 134    </font>
 135    <hcenter/>
 136    <vcenter/>
 137    <string>Total Allocated</string>
 138   </label>
 139   <label>
 140    <rect>
 141     <x>185</x>
 142     <y>230</y>
 143     <width>65</width>
 144     <height>15</height>
 145    </rect>
 146    <font>
 147     <face>Arial</face>
 148     <size>8</size>
 149     <weight>normal</weight>
 150    </font>
 151    <hcenter/>
 152    <vcenter/>
 153    <string>Status</string>
 154   </label>
 155   <label>
 156    <rect>
 157     <x>275</x>
 158     <y>100</y>
 159     <width>102</width>
 160     <height>20</height>
 161    </rect>
 162    <font>
 163     <face>Arial</face>
 164     <size>10</size>
 165     <weight>normal</weight>
 166    </font>
 167    <right/>
 168    <vcenter/>
 169    <string>Customer:</string>
 170   </label>
 171   <label>
 172    <rect>
 173     <x>540</x>
 174     <y>230</y>
 175     <width>100</width>
 176     <height>15</height>
 177    </rect>
 178    <font>
 179     <face>Arial</face>
 180     <size>8</size>
 181     <weight>normal</weight>
 182    </font>
 183    <hcenter/>
 184    <vcenter/>
 185    <string>Start Date</string>
 186   </label>
 187   <label>
 188    <rect>
 189     <x>275</x>
 190     <y>120</y>
 191     <width>102</width>
 192     <height>20</height>
 193    </rect>
 194    <font>
 195     <face>Arial</face>
 196     <size>10</size>
 197     <weight>normal</weight>
 198    </font>
 199    <right/>
 200    <vcenter/>
 201    <string>Cust. Phone:</string>
 202   </label>
 203   <label>
 204    <rect>
 205     <x>645</x>
 206     <y>200</y>
 207     <width>100</width>
 208     <height>15</height>
 209    </rect>
 210    <font>
 211     <face>Arial</face>
 212     <size>8</size>
 213     <weight>normal</weight>
 214    </font>
 215    <hcenter/>
 216    <vcenter/>
 217    <string>This Available</string>
 218   </label>
 219   <label>
 220    <rect>
 221     <x>30</x>
 222     <y>100</y>
 223     <width>102</width>
 224     <height>20</height>
 225    </rect>
 226    <font>
 227     <face>Arial</face>
 228     <size>10</size>
 229     <weight>normal</weight>
 230    </font>
 231    <right/>
 232    <vcenter/>
 233    <string>Sales Order #:</string>
 234   </label>
 235   <field>
 236    <rect>
 237     <x>385</x>
 238     <y>140</y>
 239     <width>200</width>
 240     <height>20</height>
 241    </rect>
 242    <font>
 243     <face>Arial</face>
 244     <size>10</size>
 245     <weight>bold</weight>
 246    </font>
 247    <left/>
 248    <vcenter/>
 249    <data>
 250     <query>head</query>
 251     <column>cohead_custponumber</column>
 252    </data>
 253   </field>
 254   <label>
 255    <rect>
 256     <x>225</x>
 257     <y>10</y>
 258     <width>500</width>
 259     <height>37</height>
 260    </rect>
 261    <font>
 262     <face>Arial</face>
 263     <size>18</size>
 264     <weight>bold</weight>
 265    </font>
 266    <right/>
 267    <vcenter/>
 268    <string>Inventory Availability by Sales Order</string>
 269   </label>
 270   <label>
 271    <rect>
 272     <x>275</x>
 273     <y>140</y>
 274     <width>102</width>
 275     <height>20</height>
 276    </rect>
 277    <font>
 278     <face>Arial</face>
 279     <size>10</size>
 280     <weight>normal</weight>
 281    </font>
 282    <right/>
 283    <vcenter/>
 284    <string>P/O #:</string>
 285   </label>
 286   <label>
 287    <rect>
 288     <x>540</x>
 289     <y>200</y>
 290     <width>100</width>
 291     <height>15</height>
 292    </rect>
 293    <font>
 294     <face>Arial</face>
 295     <size>8</size>
 296     <weight>normal</weight>
 297    </font>
 298    <hcenter/>
 299    <vcenter/>
 300    <string>Orders</string>
 301   </label>
 302   <label>
 303    <rect>
 304     <x>20</x>
 305     <y>230</y>
 306     <width>125</width>
 307     <height>15</height>
 308    </rect>
 309    <font>
 310     <face>Arial</face>
 311     <size>8</size>
 312     <weight>normal</weight>
 313    </font>
 314    <left/>
 315    <vcenter/>
 316    <string>W/O Number</string>
 317   </label>
 318   <field>
 319    <rect>
 320     <x>360</x>
 321     <y>175</y>
 322     <width>380</width>
 323     <height>20</height>
 324    </rect>
 325    <font>
 326     <face>Arial</face>
 327     <size>10</size>
 328     <weight>bold</weight>
 329    </font>
 330    <left/>
 331    <vcenter/>
 332    <data>
 333     <query>head</query>
 334     <column>f_showWoSupply</column>
 335    </data>
 336   </field>
 337   <label>
 338    <rect>
 339     <x>10</x>
 340     <y>215</y>
 341     <width>125</width>
 342     <height>15</height>
 343    </rect>
 344    <font>
 345     <face>Arial</face>
 346     <size>8</size>
 347     <weight>normal</weight>
 348    </font>
 349    <left/>
 350    <vcenter/>
 351    <string>Description</string>
 352   </label>
 353   <label>
 354    <rect>
 355     <x>432</x>
 356     <y>200</y>
 357     <width>100</width>
 358     <height>15</height>
 359    </rect>
 360    <font>
 361     <face>Arial</face>
 362     <size>8</size>
 363     <weight>normal</weight>
 364    </font>
 365    <hcenter/>
 366    <vcenter/>
 367    <string>This Allocated</string>
 368   </label>
 369   <line>
 370    <xstart>10</xstart>
 371    <ystart>245</ystart>
 372    <xend>750</xend>
 373    <yend>245</yend>
 374    <weight>2</weight>
 375   </line>
 376   <field>
 377    <rect>
 378     <x>140</x>
 379     <y>100</y>
 380     <width>125</width>
 381     <height>20</height>
 382    </rect>
 383    <font>
 384     <face>Arial</face>
 385     <size>10</size>
 386     <weight>bold</weight>
 387    </font>
 388    <left/>
 389    <vcenter/>
 390    <data>
 391     <query>head</query>
 392     <column>cohead_number</column>
 393    </data>
 394   </field>
 395   <label>
 396    <rect>
 397     <x>30</x>
 398     <y>120</y>
 399     <width>102</width>
 400     <height>20</height>
 401    </rect>
 402    <font>
 403     <face>Arial</face>
 404     <size>10</size>
 405     <weight>normal</weight>
 406    </font>
 407    <right/>
 408    <vcenter/>
 409    <string>Order Date:</string>
 410   </label>
 411   <field>
 412    <rect>
 413     <x>385</x>
 414     <y>100</y>
 415     <width>350</width>
 416     <height>20</height>
 417    </rect>
 418    <font>
 419     <face>Arial</face>
 420     <size>10</size>
 421     <weight>bold</weight>
 422    </font>
 423    <left/>
 424    <vcenter/>
 425    <data>
 426     <query>head</query>
 427     <column>cust_name</column>
 428    </data>
 429   </field>
 430   <label>
 431    <rect>
 432     <x>645</x>
 433     <y>230</y>
 434     <width>100</width>
 435     <height>15</height>
 436    </rect>
 437    <font>
 438     <face>Arial</face>
 439     <size>8</size>
 440     <weight>normal</weight>
 441    </font>
 442    <hcenter/>
 443    <vcenter/>
 444    <string>Due Date</string>
 445   </label>
 446   <label>
 447    <rect>
 448     <x>10</x>
 449     <y>200</y>
 450     <width>125</width>
 451     <height>15</height>
 452    </rect>
 453    <font>
 454     <face>Arial</face>
 455     <size>8</size>
 456     <weight>normal</weight>
 457    </font>
 458    <left/>
 459    <vcenter/>
 460    <string>Item</string>
 461   </label>
 462   <field>
 463    <rect>
 464     <x>385</x>
 465     <y>120</y>
 466     <width>350</width>
 467     <height>20</height>
 468    </rect>
 469    <font>
 470     <face>Arial</face>
 471     <size>10</size>
 472     <weight>bold</weight>
 473    </font>
 474    <left/>
 475    <vcenter/>
 476    <data>
 477     <query>head</query>
 478     <column>cust_phone</column>
 479    </data>
 480   </field>
 481   <field>
 482    <rect>
 483     <x>360</x>
 484     <y>160</y>
 485     <width>380</width>
 486     <height>20</height>
 487    </rect>
 488    <font>
 489     <face>Arial</face>
 490     <size>10</size>
 491     <weight>bold</weight>
 492    </font>
 493    <left/>
 494    <vcenter/>
 495    <data>
 496     <query>head</query>
 497     <column>f_onlyShowShortages</column>
 498    </data>
 499   </field>
 500   <field>
 501    <rect>
 502     <x>140</x>
 503     <y>120</y>
 504     <width>125</width>
 505     <height>20</height>
 506    </rect>
 507    <font>
 508     <face>Arial</face>
 509     <size>10</size>
 510     <weight>bold</weight>
 511    </font>
 512    <left/>
 513    <vcenter/>
 514    <data>
 515     <query>head</query>
 516     <column>orderdate</column>
 517    </data>
 518   </field>
 519   <label>
 520    <rect>
 521     <x>180</x>
 522     <y>200</y>
 523     <width>75</width>
 524     <height>15</height>
 525    </rect>
 526    <font>
 527     <face>Arial</face>
 528     <size>8</size>
 529     <weight>normal</weight>
 530    </font>
 531    <hcenter/>
 532    <vcenter/>
 533    <string>UOM</string>
 534   </label>
 535   <label>
 536    <rect>
 537     <x>330</x>
 538     <y>200</y>
 539     <width>100</width>
 540     <height>15</height>
 541    </rect>
 542    <font>
 543     <face>Arial</face>
 544     <size>8</size>
 545     <weight>normal</weight>
 546    </font>
 547    <hcenter/>
 548    <vcenter/>
 549    <string>QOH</string>
 550   </label>
 551   <label>
 552    <rect>
 553     <x>645</x>
 554     <y>215</y>
 555     <width>100</width>
 556     <height>15</height>
 557    </rect>
 558    <font>
 559     <face>Arial</face>
 560     <size>8</size>
 561     <weight>normal</weight>
 562    </font>
 563    <hcenter/>
 564    <vcenter/>
 565    <string>Total Available</string>
 566   </label>
 567   <label>
 568    <rect>
 569     <x>540</x>
 570     <y>215</y>
 571     <width>100</width>
 572     <height>15</height>
 573    </rect>
 574    <font>
 575     <face>Arial</face>
 576     <size>8</size>
 577     <weight>normal</weight>
 578    </font>
 579    <hcenter/>
 580    <vcenter/>
 581    <string>At Shipping</string>
 582   </label>
 583  </rpthead>
 584  <pghead>
 585   <firstpage/>
 586   <height>6</height>
 587  </pghead>
 588  <pghead>
 589   <height>41</height>
 590   <label>
 591    <rect>
 592     <x>432</x>
 593     <y>5</y>
 594     <width>100</width>
 595     <height>15</height>
 596    </rect>
 597    <font>
 598     <face>Arial</face>
 599     <size>8</size>
 600     <weight>normal</weight>
 601    </font>
 602    <hcenter/>
 603    <vcenter/>
 604    <string>This Allocated</string>
 605   </label>
 606   <label>
 607    <rect>
 608     <x>180</x>
 609     <y>5</y>
 610     <width>75</width>
 611     <height>15</height>
 612    </rect>
 613    <font>
 614     <face>Arial</face>
 615     <size>8</size>
 616     <weight>normal</weight>
 617    </font>
 618    <hcenter/>
 619    <vcenter/>
 620    <string>UOM</string>
 621   </label>
 622   <label>
 623    <rect>
 624     <x>10</x>
 625     <y>20</y>
 626     <width>125</width>
 627     <height>15</height>
 628    </rect>
 629    <font>
 630     <face>Arial</face>
 631     <size>8</size>
 632     <weight>normal</weight>
 633    </font>
 634    <left/>
 635    <vcenter/>
 636    <string>Description</string>
 637   </label>
 638   <label>
 639    <rect>
 640     <x>540</x>
 641     <y>20</y>
 642     <width>100</width>
 643     <height>15</height>
 644    </rect>
 645    <font>
 646     <face>Arial</face>
 647     <size>8</size>
 648     <weight>normal</weight>
 649    </font>
 650    <hcenter/>
 651    <vcenter/>
 652    <string>At Shipping</string>
 653   </label>
 654   <label>
 655    <rect>
 656     <x>645</x>
 657     <y>20</y>
 658     <width>100</width>
 659     <height>15</height>
 660    </rect>
 661    <font>
 662     <face>Arial</face>
 663     <size>8</size>
 664     <weight>normal</weight>
 665    </font>
 666    <hcenter/>
 667    <vcenter/>
 668    <string>Total Available</string>
 669   </label>
 670   <label>
 671    <rect>
 672     <x>10</x>
 673     <y>5</y>
 674     <width>125</width>
 675     <height>15</height>
 676    </rect>
 677    <font>
 678     <face>Arial</face>
 679     <size>8</size>
 680     <weight>normal</weight>
 681    </font>
 682    <left/>
 683    <vcenter/>
 684    <string>Item</string>
 685   </label>
 686   <label>
 687    <rect>
 688     <x>645</x>
 689     <y>5</y>
 690     <width>100</width>
 691     <height>15</height>
 692    </rect>
 693    <font>
 694     <face>Arial</face>
 695     <size>8</size>
 696     <weight>normal</weight>
 697    </font>
 698    <hcenter/>
 699    <vcenter/>
 700    <string>This Available</string>
 701   </label>
 702   <line>
 703    <xstart>5</xstart>
 704    <ystart>35</ystart>
 705    <xend>745</xend>
 706    <yend>35</yend>
 707    <weight>2</weight>
 708   </line>
 709   <label>
 710    <rect>
 711     <x>432</x>
 712     <y>20</y>
 713     <width>100</width>
 714     <height>15</height>
 715    </rect>
 716    <font>
 717     <face>Arial</face>
 718     <size>8</size>
 719     <weight>normal</weight>
 720    </font>
 721    <hcenter/>
 722    <vcenter/>
 723    <string>Total Allocated</string>
 724   </label>
 725   <label>
 726    <rect>
 727     <x>330</x>
 728     <y>5</y>
 729     <width>100</width>
 730     <height>15</height>
 731    </rect>
 732    <font>
 733     <face>Arial</face>
 734     <size>8</size>
 735     <weight>normal</weight>
 736    </font>
 737    <hcenter/>
 738    <vcenter/>
 739    <string>QOH</string>
 740   </label>
 741   <label>
 742    <rect>
 743     <x>540</x>
 744     <y>5</y>
 745     <width>100</width>
 746     <height>15</height>
 747    </rect>
 748    <font>
 749     <face>Arial</face>
 750     <size>8</size>
 751     <weight>normal</weight>
 752    </font>
 753    <hcenter/>
 754    <vcenter/>
 755    <string>Orders</string>
 756   </label>
 757  </pghead>
 758  <section>
 759   <name>detail</name>
 760   <group>
 761    <name>coitem</name>
 762    <column>coitem_id</column>
 763    <head>
 764     <height>31</height>
 765     <field>
 766      <rect>
 767       <x>430</x>
 768       <y>15</y>
 769       <width>100</width>
 770       <height>15</height>
 771      </rect>
 772      <font>
 773       <face>Arial</face>
 774       <size>8</size>
 775       <weight>bold</weight>
 776      </font>
 777      <right/>
 778      <vcenter/>
 779      <data>
 780       <query>detail</query>
 781       <column>f_allocated</column>
 782      </data>
 783     </field>
 784     <field>
 785      <rect>
 786       <x>325</x>
 787       <y>0</y>
 788       <width>100</width>
 789       <height>15</height>
 790      </rect>
 791      <font>
 792       <face>Arial</face>
 793       <size>8</size>
 794       <weight>bold</weight>
 795      </font>
 796      <right/>
 797      <vcenter/>
 798      <data>
 799       <query>detail</query>
 800       <column>f_qoh</column>
 801      </data>
 802     </field>
 803     <field>
 804      <rect>
 805       <x>185</x>
 806       <y>0</y>
 807       <width>75</width>
 808       <height>15</height>
 809      </rect>
 810      <font>
 811       <face>Arial</face>
 812       <size>8</size>
 813       <weight>bold</weight>
 814      </font>
 815      <left/>
 816      <vcenter/>
 817      <data>
 818       <query>detail</query>
 819       <column>uom_name</column>
 820      </data>
 821     </field>
 822     <field>
 823      <rect>
 824       <x>640</x>
 825       <y>0</y>
 826       <width>100</width>
 827       <height>15</height>
 828      </rect>
 829      <font>
 830       <face>Arial</face>
 831       <size>8</size>
 832       <weight>bold</weight>
 833      </font>
 834      <right/>
 835      <vcenter/>
 836      <data>
 837       <query>detail</query>
 838       <column>f_soavail</column>
 839      </data>
 840     </field>
 841     <field>
 842      <rect>
 843       <x>535</x>
 844       <y>15</y>
 845       <width>100</width>
 846       <height>15</height>
 847      </rect>
 848      <font>
 849       <face>Arial</face>
 850       <size>8</size>
 851       <weight>bold</weight>
 852      </font>
 853      <right/>
 854      <vcenter/>
 855      <data>
 856       <query>detail</query>
 857       <column>f_atshipping</column>
 858      </data>
 859     </field>
 860     <field>
 861      <rect>
 862       <x>640</x>
 863       <y>15</y>
 864       <width>100</width>
 865       <height>15</height>
 866      </rect>
 867      <font>
 868       <face>Arial</face>
 869       <size>8</size>
 870       <weight>bold</weight>
 871      </font>
 872      <right/>
 873      <vcenter/>
 874      <data>
 875       <query>detail</query>
 876       <column>f_totalavail</column>
 877      </data>
 878     </field>
 879     <field>
 880      <rect>
 881       <x>535</x>
 882       <y>0</y>
 883       <width>100</width>
 884       <height>15</height>
 885      </rect>
 886      <font>
 887       <face>Arial</face>
 888       <size>8</size>
 889       <weight>bold</weight>
 890      </font>
 891      <right/>
 892      <vcenter/>
 893      <data>
 894       <query>detail</query>
 895       <column>f_ordered</column>
 896      </data>
 897     </field>
 898     <field>
 899      <rect>
 900       <x>10</x>
 901       <y>0</y>
 902       <width>150</width>
 903       <height>15</height>
 904      </rect>
 905      <font>
 906       <face>Arial</face>
 907       <size>8</size>
 908       <weight>bold</weight>
 909      </font>
 910      <left/>
 911      <vcenter/>
 912      <data>
 913       <query>detail</query>
 914       <column>Item_number</column>
 915      </data>
 916     </field>
 917     <field>
 918      <rect>
 919       <x>10</x>
 920       <y>15</y>
 921       <width>400</width>
 922       <height>15</height>
 923      </rect>
 924      <font>
 925       <face>Arial</face>
 926       <size>8</size>
 927       <weight>bold</weight>
 928      </font>
 929      <left/>
 930      <vcenter/>
 931      <data>
 932       <query>detail</query>
 933       <column>Item_description</column>
 934      </data>
 935     </field>
 936     <field>
 937      <rect>
 938       <x>430</x>
 939       <y>0</y>
 940       <width>100</width>
 941       <height>15</height>
 942      </rect>
 943      <font>
 944       <face>Arial</face>
 945       <size>8</size>
 946       <weight>bold</weight>
 947      </font>
 948      <right/>
 949      <vcenter/>
 950      <data>
 951       <query>detail</query>
 952       <column>f_sobalance</column>
 953      </data>
 954     </field>
 955    </head>
 956    <foot>
 957     <height>6</height>
 958     <line>
 959      <xstart>5</xstart>
 960      <ystart>0</ystart>
 961      <xend>745</xend>
 962      <yend>0</yend>
 963      <weight>0</weight>
 964     </line>
 965    </foot>
 966   </group>
 967   <detail>
 968    <key>
 969     <query>detail</query>
 970    </key>
 971    <height>16</height>
 972    <field>
 973     <rect>
 974      <x>535</x>
 975      <y>0</y>
 976      <width>100</width>
 977      <height>15</height>
 978     </rect>
 979     <font>
 980      <face>Arial</face>
 981      <size>8</size>
 982      <weight>bold</weight>
 983     </font>
 984     <right/>
 985     <vcenter/>
 986     <data>
 987      <query>detail</query>
 988      <column>f_wo_startdate</column>
 989     </data>
 990    </field>
 991    <field>
 992     <rect>
 993      <x>25</x>
 994      <y>0</y>
 995      <width>150</width>
 996      <height>15</height>
 997     </rect>
 998     <font>
 999      <face>Arial</face>
1000      <size>8</size>
1001      <weight>bold</weight>
1002     </font>
1003     <left/>
1004     <vcenter/>
1005     <data>
1006      <query>detail</query>
1007      <column>wo_number</column>
1008     </data>
1009    </field>
1010    <field>
1011     <rect>
1012      <x>430</x>
1013      <y>0</y>
1014      <width>100</width>
1015      <height>15</height>
1016     </rect>
1017     <font>
1018      <face>Arial</face>
1019      <size>8</size>
1020      <weight>bold</weight>
1021     </font>
1022     <right/>
1023     <vcenter/>
1024     <data>
1025      <query>detail</query>
1026      <column>f_wo_ordered</column>
1027     </data>
1028    </field>
1029    <field>
1030     <rect>
1031      <x>640</x>
1032      <y>0</y>
1033      <width>100</width>
1034      <height>15</height>
1035     </rect>
1036     <font>
1037      <face>Arial</face>
1038      <size>8</size>
1039      <weight>bold</weight>
1040     </font>
1041     <right/>
1042     <vcenter/>
1043     <data>
1044      <query>detail</query>
1045      <column>f_wo_duedate</column>
1046     </data>
1047    </field>
1048    <field>
1049     <rect>
1050      <x>185</x>
1051      <y>0</y>
1052      <width>75</width>
1053      <height>15</height>
1054     </rect>
1055     <font>
1056      <face>Arial</face>
1057      <size>8</size>
1058      <weight>bold</weight>
1059     </font>
1060     <left/>
1061     <vcenter/>
1062     <data>
1063      <query>detail</query>
1064      <column>wo_status</column>
1065     </data>
1066    </field>
1067   </detail>
1068  </section>
1069  <pgfoot>
1070   <height>17</height>
1071   <field>
1072    <rect>
1073     <x>90</x>
1074     <y>0</y>
1075     <width>100</width>
1076     <height>15</height>
1077    </rect>
1078    <font>
1079     <face>Arial</face>
1080     <size>8</size>
1081     <weight>bold</weight>
1082    </font>
1083    <left/>
1084    <vcenter/>
1085    <data>
1086     <query>Context Query</query>
1087     <column>report_date</column>
1088    </data>
1089   </field>
1090   <label>
1091    <rect>
1092     <x>0</x>
1093     <y>0</y>
1094     <width>85</width>
1095     <height>15</height>
1096    </rect>
1097    <font>
1098     <face>Arial</face>
1099     <size>8</size>
1100     <weight>normal</weight>
1101    </font>
1102    <right/>
1103    <vcenter/>
1104    <string>Report Date:</string>
1105   </label>
1106   <label>
1107    <rect>
1108     <x>615</x>
1109     <y>0</y>
1110     <width>85</width>
1111     <height>15</height>
1112    </rect>
1113    <font>
1114     <face>Arial</face>
1115     <size>8</size>
1116     <weight>normal</weight>
1117    </font>
1118    <right/>
1119    <vcenter/>
1120    <string>Page:</string>
1121   </label>
1122   <field>
1123    <rect>
1124     <x>705</x>
1125     <y>0</y>
1126     <width>40</width>
1127     <height>15</height>
1128    </rect>
1129    <font>
1130     <face>Arial</face>
1131     <size>8</size>
1132     <weight>bold</weight>
1133    </font>
1134    <left/>
1135    <vcenter/>
1136    <data>
1137     <query>Context Query</query>
1138     <column>page_number</column>
1139    </data>
1140   </field>
1141  </pgfoot>
1142 </report>