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

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