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

   1 <!DOCTYPE openRPTDef>
   2 <report>
   3  <title>Inventory Availability by Source Vendor</title>
   4  <name>InventoryAvailabilityBySourceVendor</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 &lt;? if exists("byDays") ?>
  21          (text('Look ahead ') || text(&lt;? value("byDays") ?>) || text(' days'))
  22        &lt;? elseif exists("byDate") ?>
  23          (text('Cutoff date ') || formatDate(&lt;? value("byDate") ?>))
  24        &lt;? elseif exists("byDates") ?>
  25          (text('Dates from ') || formatDate(&lt;? value("startDate") ?>) || text(' to ') || formatDate(&lt;? value("endDate") ?>))
  26        &lt;? else ?>
  27          text('Item Site Lead Time')
  28        &lt;? endif ?>
  29        AS ltcriteria</sql>
  30  </querysource>
  31  <querysource>
  32   <name>detail</name>
  33   <sql>SELECT item_number,
  34        item_descrip1,
  35        item_descrip2,
  36        warehous_code,
  37        vend_number,
  38        itemsite_leadtime,
  39        formatQty(qtyonhand) AS f_qtyonhand,
  40        formatQty(noNeg(qtyonhand - allocated)) AS f_unallocated,
  41        formatQty(noNeg(allocated)) AS f_allocated,
  42        formatQty(ordered) AS f_ordered,
  43        formatQty(reorderlevel) AS f_reorderlevel,
  44        formatQty(outlevel) AS f_outlevel,
  45        (qtyonhand - allocated + ordered) AS available,
  46        formatQty(qtyonhand - allocated + ordered) AS f_available
  47   FROM (SELECT
  48            &lt;? if reExists("[vV]end") ?>
  49              DISTINCT
  50            &lt;? endif ?>
  51              itemsite_id,
  52              CASE WHEN (item_type IN ('P', 'O')) THEN 1
  53                   WHEN (item_type IN ('M')) THEN 2
  54                   ELSE 0
  55              END AS altId,
  56              item_number, item_descrip1, item_descrip2, item_inv_uom_id,
  57              warehous_id, warehous_code, itemsite_leadtime,
  58              qtyAvailable(itemsite_id) AS qtyonhand,
  59              CASE WHEN itemsite_useparams THEN itemsite_reorderlevel
  60                   ELSE 0.0
  61              END AS reorderlevel,
  62              CASE WHEN itemsite_useparams THEN itemsite_ordertoqty
  63                   ELSE 0.0
  64              END AS outlevel,
  65              &lt;? if exists("byVend") ?>
  66                vend_number,
  67              &lt;? else ?>
  68                NULL AS vend_number,
  69              &lt;? endif ?>
  70              &lt;? if exists("byLeadTime") ?>
  71                qtyAllocated(itemsite_id, itemsite_leadtime) AS allocated,
  72                qtyOrdered(itemsite_id,   itemsite_leadtime) AS ordered,
  73                qtypr(itemsite_id,   itemsite_leadtime) AS requests
  74              &lt;? elseif exists("byDays") ?>
  75                qtyAllocated(itemsite_id, CAST(&lt;? value("byDays") ?> AS INTEGER)) AS allocated,
  76                qtyOrdered(itemsite_id,   CAST(&lt;? value("byDays") ?> AS INTEGER)) AS ordered,
  77                qtypr(itemsite_id,   CAST(&lt;? value("byDays") ?> AS INTEGER)) AS requests
  78              &lt;? elseif exists("byDate") ?>
  79                qtyAllocated(itemsite_id, (&lt;? value("byDate") ?> - CURRENT_DATE)) AS allocated,
  80                qtyOrdered(itemsite_id,   (&lt;? value("byDate") ?> - CURRENT_DATE)) AS ordered,
  81                qtypr(itemsite_id,   (&lt;? value("byDate") ?> - CURRENT_DATE)) AS requests
  82              &lt;? elseif exists("byDates") ?>
  83                qtyAllocated(itemsite_id, &lt;? value("startDate") ?>, &lt;? value("endDate") ?>) AS allocated,
  84                qtyOrdered(itemsite_id,   &lt;? value("startDate") ?>, &lt;? value("endDate") ?>) AS ordered,
  85                qtypr(itemsite_id,   &lt;? value("startDate") ?>, &lt;? value("endDate") ?>) AS requests
  86              &lt;? endif ?>
  87       FROM item, itemsite, whsinfo
  88            &lt;? if reExists("[vV]end") ?>
  89              , vendinfo JOIN itemsrc ON (itemsrc_vend_id=vend_id)
  90            &lt;? endif ?>
  91       WHERE ( (itemsite_active)
  92           AND (itemsite_item_id=item_id)
  93           AND (itemsite_warehous_id=warehous_id)
  94           &lt;? if exists("warehous_id") ?>
  95             AND (warehous_id=&lt;? value("warehous_id") ?>)
  96           &lt;? endif ?>
  97           &lt;? if exists("item_id") ?>
  98             AND (item_id=&lt;? value("item_id") ?>)
  99           &lt;? elseif exists("classcode_id") ?>
 100             AND (item_classcode_id=&lt;? value("classcode_id") ?>)
 101           &lt;? elseif exists("classcode_pattern") ?>
 102             AND (item_classcode_id IN (SELECT classcode_id
 103                                        FROM classcode
 104                                        WHERE (classcode_code ~ &lt;? value("classcode_pattern") ?>)))
 105           &lt;? elseif exists("plancode_id") ?>
 106             AND (itemsite_plancode_id=&lt;? value("plancode_id") ?>)
 107           &lt;? elseif exists("plancode_pattern") ?>
 108             AND (itemsite_plancode_id IN (SELECT plancode_id
 109                                           FROM plancode
 110                                           WHERE (plancode_code ~ &lt;? value("plancode_pattern") ?>)))
 111           &lt;? elseif exists("itemgrp_id") ?>
 112             AND (item_id IN (SELECT itemgrpitem_item_id
 113                              FROM itemgrpitem
 114                              WHERE (itemgrpitem_itemgrp_id=&lt;? value("itemgrp_id") ?>)))
 115           &lt;? elseif exists("itemgrp_pattern") ?>
 116             AND (item_id IN (SELECT itemgrpitem_item_id
 117                              FROM itemgrpitem, itemgrp
 118                              WHERE ( (itemgrpitem_itemgrp_id=itemgrp_id)
 119                                     AND (itemgrp_name ~ &lt;? value("itemgrp_pattern") ?>) ) ))
 120           &lt;? elseif exists("itemgrp") ?>
 121             AND (item_id IN (SELECT DISTINCT itemgrpitem_item_id FROM itemgrpitem))
 122           &lt;? endif ?>
 123           &lt;? if reExists("[vV]end") ?>
 124             AND (itemsrc_item_id=item_id)
 125           &lt;? endif ?>
 126           &lt;? if exists("vend_id") ?>
 127             AND (vend_id=&lt;? value("vend_id") ?>)
 128           &lt;? elseif exists("vendtype_id") ?>
 129             AND (vend_vendtype_id=&lt;? value("vendtype_id") ?>)
 130           &lt;? elseif exists("vendtype_pattern") ?>
 131             AND (vend_vendtype_id IN (SELECT vendtype_id
 132                                       FROM vendtype
 133                                       WHERE (vendtype_code ~ &lt;? value("vendtype_pattern") ?>)))
 134           &lt;? endif ?>
 135       ) ) AS data
 136 &lt;? if exists("showReorder") ?>
 137  WHERE ( ((qtyonhand - allocated + ordered) &lt;= reorderlevel)
 138   &lt;? if exists("ignoreReorderAtZero") ?>
 139    AND (NOT ( ((qtyonhand - allocated + ordered) = 0) AND (reorderlevel = 0)))
 140   &lt;? endif ?>
 141   )
 142 &lt;? elseif exists("showShortages") ?>
 143  WHERE ((qtyonhand - allocated + ordered) &lt; 0)
 144 &lt;? endif ?>
 145 ORDER BY vend_number, item_number, warehous_code DESC;</sql>
 146  </querysource>
 147  <rpthead>
 148   <height>221</height>
 149   <label>
 150    <rect>
 151     <x>330</x>
 152     <y>185</y>
 153     <width>100</width>
 154     <height>15</height>
 155    </rect>
 156    <font>
 157     <face>Arial</face>
 158     <size>8</size>
 159     <weight>normal</weight>
 160    </font>
 161    <hcenter/>
 162    <vcenter/>
 163    <string>QOH</string>
 164   </label>
 165   <label>
 166    <rect>
 167     <x>5</x>
 168     <y>185</y>
 169     <width>45</width>
 170     <height>15</height>
 171    </rect>
 172    <font>
 173     <face>Arial</face>
 174     <size>8</size>
 175     <weight>normal</weight>
 176    </font>
 177    <hcenter/>
 178    <vcenter/>
 179    <string>Site</string>
 180   </label>
 181   <label>
 182    <rect>
 183     <x>434</x>
 184     <y>185</y>
 185     <width>100</width>
 186     <height>15</height>
 187    </rect>
 188    <font>
 189     <face>Arial</face>
 190     <size>8</size>
 191     <weight>normal</weight>
 192    </font>
 193    <hcenter/>
 194    <vcenter/>
 195    <string>Allocated</string>
 196   </label>
 197   <label>
 198    <rect>
 199     <x>540</x>
 200     <y>185</y>
 201     <width>100</width>
 202     <height>15</height>
 203    </rect>
 204    <font>
 205     <face>Arial</face>
 206     <size>8</size>
 207     <weight>normal</weight>
 208    </font>
 209    <hcenter/>
 210    <vcenter/>
 211    <string>On Order</string>
 212   </label>
 213   <line>
 214    <xstart>5</xstart>
 215    <ystart>215</ystart>
 216    <xend>745</xend>
 217    <yend>215</yend>
 218    <weight>2</weight>
 219   </line>
 220   <label>
 221    <rect>
 222     <x>645</x>
 223     <y>185</y>
 224     <width>100</width>
 225     <height>15</height>
 226    </rect>
 227    <font>
 228     <face>Arial</face>
 229     <size>8</size>
 230     <weight>normal</weight>
 231    </font>
 232    <hcenter/>
 233    <vcenter/>
 234    <string>Available</string>
 235   </label>
 236   <label>
 237    <rect>
 238     <x>195</x>
 239     <y>10</y>
 240     <width>530</width>
 241     <height>38</height>
 242    </rect>
 243    <font>
 244     <face>Arial</face>
 245     <size>18</size>
 246     <weight>bold</weight>
 247    </font>
 248    <right/>
 249    <vcenter/>
 250    <string>Inventory Availability by Source Vendor</string>
 251   </label>
 252   <field>
 253    <rect>
 254     <x>135</x>
 255     <y>43</y>
 256     <width>280</width>
 257     <height>20</height>
 258    </rect>
 259    <font>
 260     <face>Arial</face>
 261     <size>10</size>
 262     <weight>bold</weight>
 263    </font>
 264    <left/>
 265    <vcenter/>
 266    <data>
 267     <query>head</query>
 268     <column>ltcriteria</column>
 269    </data>
 270   </field>
 271   <label>
 272    <rect>
 273     <x>5</x>
 274     <y>200</y>
 275     <width>45</width>
 276     <height>15</height>
 277    </rect>
 278    <font>
 279     <face>Arial</face>
 280     <size>8</size>
 281     <weight>normal</weight>
 282    </font>
 283    <hcenter/>
 284    <vcenter/>
 285    <string>LT</string>
 286   </label>
 287   <label>
 288    <rect>
 289     <x>645</x>
 290     <y>200</y>
 291     <width>100</width>
 292     <height>15</height>
 293    </rect>
 294    <font>
 295     <face>Arial</face>
 296     <size>8</size>
 297     <weight>normal</weight>
 298    </font>
 299    <hcenter/>
 300    <vcenter/>
 301    <string>OUT Level</string>
 302   </label>
 303   <label>
 304    <rect>
 305     <x>434</x>
 306     <y>200</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>Unallocated</string>
 318   </label>
 319   <label>
 320    <rect>
 321     <x>540</x>
 322     <y>200</y>
 323     <width>100</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>Reorder Level</string>
 334   </label>
 335   <label>
 336    <rect>
 337     <x>55</x>
 338     <y>185</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    <left/>
 348    <vcenter/>
 349    <string>Vendor #</string>
 350   </label>
 351   <label>
 352    <rect>
 353     <x>160</x>
 354     <y>185</y>
 355     <width>106</width>
 356     <height>15</height>
 357    </rect>
 358    <font>
 359     <face>Arial</face>
 360     <size>8</size>
 361     <weight>normal</weight>
 362    </font>
 363    <left/>
 364    <vcenter/>
 365    <string>Item Number</string>
 366   </label>
 367   <label>
 368    <rect>
 369     <x>0</x>
 370     <y>43</y>
 371     <width>130</width>
 372     <height>20</height>
 373    </rect>
 374    <font>
 375     <face>Arial</face>
 376     <size>10</size>
 377     <weight>normal</weight>
 378    </font>
 379    <right/>
 380    <vcenter/>
 381    <string>Availability as of: </string>
 382   </label>
 383   <label>
 384    <rect>
 385     <x>160</x>
 386     <y>200</y>
 387     <width>106</width>
 388     <height>15</height>
 389    </rect>
 390    <font>
 391     <face>Arial</face>
 392     <size>8</size>
 393     <weight>normal</weight>
 394    </font>
 395    <left/>
 396    <vcenter/>
 397    <string>Description</string>
 398   </label>
 399   <text>
 400    <rect>
 401     <x>10</x>
 402     <y>63</y>
 403     <width>725</width>
 404     <height>15</height>
 405    </rect>
 406    <bottompad>12</bottompad>
 407    <font>
 408     <face>Arial</face>
 409     <size>10</size>
 410     <weight>bold</weight>
 411    </font>
 412    <left/>
 413    <top/>
 414    <data>
 415     <query>Parameter Query</query>
 416     <column>filter</column>
 417    </data>
 418   </text>
 419  </rpthead>
 420  <pghead>
 421   <firstpage/>
 422   <height>6</height>
 423  </pghead>
 424  <pghead>
 425   <height>36</height>
 426   <label>
 427    <rect>
 428     <x>540</x>
 429     <y>0</y>
 430     <width>100</width>
 431     <height>15</height>
 432    </rect>
 433    <font>
 434     <face>Arial</face>
 435     <size>8</size>
 436     <weight>normal</weight>
 437    </font>
 438    <hcenter/>
 439    <vcenter/>
 440    <string>On Order</string>
 441   </label>
 442   <label>
 443    <rect>
 444     <x>160</x>
 445     <y>0</y>
 446     <width>106</width>
 447     <height>15</height>
 448    </rect>
 449    <font>
 450     <face>Arial</face>
 451     <size>8</size>
 452     <weight>normal</weight>
 453    </font>
 454    <left/>
 455    <vcenter/>
 456    <string>Item Number</string>
 457   </label>
 458   <label>
 459    <rect>
 460     <x>5</x>
 461     <y>15</y>
 462     <width>45</width>
 463     <height>15</height>
 464    </rect>
 465    <font>
 466     <face>Arial</face>
 467     <size>8</size>
 468     <weight>normal</weight>
 469    </font>
 470    <hcenter/>
 471    <vcenter/>
 472    <string>LT</string>
 473   </label>
 474   <label>
 475    <rect>
 476     <x>330</x>
 477     <y>0</y>
 478     <width>100</width>
 479     <height>15</height>
 480    </rect>
 481    <font>
 482     <face>Arial</face>
 483     <size>8</size>
 484     <weight>normal</weight>
 485    </font>
 486    <hcenter/>
 487    <vcenter/>
 488    <string>QOH</string>
 489   </label>
 490   <label>
 491    <rect>
 492     <x>645</x>
 493     <y>15</y>
 494     <width>100</width>
 495     <height>15</height>
 496    </rect>
 497    <font>
 498     <face>Arial</face>
 499     <size>8</size>
 500     <weight>normal</weight>
 501    </font>
 502    <hcenter/>
 503    <vcenter/>
 504    <string>OUT Level</string>
 505   </label>
 506   <label>
 507    <rect>
 508     <x>434</x>
 509     <y>0</y>
 510     <width>100</width>
 511     <height>15</height>
 512    </rect>
 513    <font>
 514     <face>Arial</face>
 515     <size>8</size>
 516     <weight>normal</weight>
 517    </font>
 518    <hcenter/>
 519    <vcenter/>
 520    <string>Allocated</string>
 521   </label>
 522   <label>
 523    <rect>
 524     <x>434</x>
 525     <y>15</y>
 526     <width>100</width>
 527     <height>15</height>
 528    </rect>
 529    <font>
 530     <face>Arial</face>
 531     <size>8</size>
 532     <weight>normal</weight>
 533    </font>
 534    <hcenter/>
 535    <vcenter/>
 536    <string>Unallocated</string>
 537   </label>
 538   <label>
 539    <rect>
 540     <x>540</x>
 541     <y>15</y>
 542     <width>100</width>
 543     <height>15</height>
 544    </rect>
 545    <font>
 546     <face>Arial</face>
 547     <size>8</size>
 548     <weight>normal</weight>
 549    </font>
 550    <hcenter/>
 551    <vcenter/>
 552    <string>Reorder Level</string>
 553   </label>
 554   <line>
 555    <xstart>5</xstart>
 556    <ystart>30</ystart>
 557    <xend>745</xend>
 558    <yend>30</yend>
 559    <weight>2</weight>
 560   </line>
 561   <label>
 562    <rect>
 563     <x>5</x>
 564     <y>0</y>
 565     <width>45</width>
 566     <height>15</height>
 567    </rect>
 568    <font>
 569     <face>Arial</face>
 570     <size>8</size>
 571     <weight>normal</weight>
 572    </font>
 573    <hcenter/>
 574    <vcenter/>
 575    <string>Site</string>
 576   </label>
 577   <label>
 578    <rect>
 579     <x>160</x>
 580     <y>15</y>
 581     <width>106</width>
 582     <height>15</height>
 583    </rect>
 584    <font>
 585     <face>Arial</face>
 586     <size>8</size>
 587     <weight>normal</weight>
 588    </font>
 589    <left/>
 590    <vcenter/>
 591    <string>Description</string>
 592   </label>
 593   <label>
 594    <rect>
 595     <x>55</x>
 596     <y>0</y>
 597     <width>100</width>
 598     <height>15</height>
 599    </rect>
 600    <font>
 601     <face>Arial</face>
 602     <size>8</size>
 603     <weight>normal</weight>
 604    </font>
 605    <left/>
 606    <vcenter/>
 607    <string>Vendor #</string>
 608   </label>
 609   <label>
 610    <rect>
 611     <x>645</x>
 612     <y>0</y>
 613     <width>100</width>
 614     <height>15</height>
 615    </rect>
 616    <font>
 617     <face>Arial</face>
 618     <size>8</size>
 619     <weight>normal</weight>
 620    </font>
 621    <hcenter/>
 622    <vcenter/>
 623    <string>Available</string>
 624   </label>
 625  </pghead>
 626  <section>
 627   <name>detail</name>
 628   <detail>
 629    <key>
 630     <query>detail</query>
 631    </key>
 632    <height>56</height>
 633    <field>
 634     <rect>
 635      <x>645</x>
 636      <y>0</y>
 637      <width>100</width>
 638      <height>15</height>
 639     </rect>
 640     <font>
 641      <face>Arial</face>
 642      <size>8</size>
 643      <weight>bold</weight>
 644     </font>
 645     <right/>
 646     <vcenter/>
 647     <data>
 648      <query>detail</query>
 649      <column>f_available</column>
 650     </data>
 651    </field>
 652    <field>
 653     <rect>
 654      <x>330</x>
 655      <y>0</y>
 656      <width>100</width>
 657      <height>15</height>
 658     </rect>
 659     <font>
 660      <face>Arial</face>
 661      <size>8</size>
 662      <weight>bold</weight>
 663     </font>
 664     <right/>
 665     <vcenter/>
 666     <data>
 667      <query>detail</query>
 668      <column>f_qtyonhand</column>
 669     </data>
 670    </field>
 671    <field>
 672     <rect>
 673      <x>160</x>
 674      <y>0</y>
 675      <width>150</width>
 676      <height>15</height>
 677     </rect>
 678     <font>
 679      <face>Arial</face>
 680      <size>8</size>
 681      <weight>bold</weight>
 682     </font>
 683     <left/>
 684     <vcenter/>
 685     <data>
 686      <query>detail</query>
 687      <column>item_number</column>
 688     </data>
 689    </field>
 690    <field>
 691     <rect>
 692      <x>55</x>
 693      <y>0</y>
 694      <width>100</width>
 695      <height>15</height>
 696     </rect>
 697     <font>
 698      <face>Arial</face>
 699      <size>8</size>
 700      <weight>bold</weight>
 701     </font>
 702     <left/>
 703     <vcenter/>
 704     <data>
 705      <query>detail</query>
 706      <column>vend_number</column>
 707     </data>
 708    </field>
 709    <field>
 710     <rect>
 711      <x>540</x>
 712      <y>15</y>
 713      <width>100</width>
 714      <height>15</height>
 715     </rect>
 716     <font>
 717      <face>Arial</face>
 718      <size>8</size>
 719      <weight>bold</weight>
 720     </font>
 721     <right/>
 722     <vcenter/>
 723     <data>
 724      <query>detail</query>
 725      <column>f_reorderlevel</column>
 726     </data>
 727    </field>
 728    <field>
 729     <rect>
 730      <x>645</x>
 731      <y>15</y>
 732      <width>100</width>
 733      <height>15</height>
 734     </rect>
 735     <font>
 736      <face>Arial</face>
 737      <size>8</size>
 738      <weight>bold</weight>
 739     </font>
 740     <right/>
 741     <vcenter/>
 742     <data>
 743      <query>detail</query>
 744      <column>f_outlevel</column>
 745     </data>
 746    </field>
 747    <field>
 748     <rect>
 749      <x>5</x>
 750      <y>15</y>
 751      <width>45</width>
 752      <height>15</height>
 753     </rect>
 754     <font>
 755      <face>Arial</face>
 756      <size>8</size>
 757      <weight>bold</weight>
 758     </font>
 759     <hcenter/>
 760     <vcenter/>
 761     <data>
 762      <query>detail</query>
 763      <column>itemsite_leadtime</column>
 764     </data>
 765    </field>
 766    <field>
 767     <rect>
 768      <x>434</x>
 769      <y>0</y>
 770      <width>100</width>
 771      <height>15</height>
 772     </rect>
 773     <font>
 774      <face>Arial</face>
 775      <size>8</size>
 776      <weight>bold</weight>
 777     </font>
 778     <right/>
 779     <vcenter/>
 780     <data>
 781      <query>detail</query>
 782      <column>f_allocated</column>
 783     </data>
 784    </field>
 785    <field>
 786     <rect>
 787      <x>540</x>
 788      <y>0</y>
 789      <width>100</width>
 790      <height>15</height>
 791     </rect>
 792     <font>
 793      <face>Arial</face>
 794      <size>8</size>
 795      <weight>bold</weight>
 796     </font>
 797     <right/>
 798     <vcenter/>
 799     <data>
 800      <query>detail</query>
 801      <column>f_ordered</column>
 802     </data>
 803    </field>
 804    <field>
 805     <rect>
 806      <x>160</x>
 807      <y>15</y>
 808      <width>250</width>
 809      <height>15</height>
 810     </rect>
 811     <font>
 812      <face>Arial</face>
 813      <size>8</size>
 814      <weight>bold</weight>
 815     </font>
 816     <left/>
 817     <vcenter/>
 818     <data>
 819      <query>detail</query>
 820      <column>item_descrip1</column>
 821     </data>
 822    </field>
 823    <field>
 824     <rect>
 825      <x>160</x>
 826      <y>30</y>
 827      <width>250</width>
 828      <height>15</height>
 829     </rect>
 830     <font>
 831      <face>Arial</face>
 832      <size>8</size>
 833      <weight>bold</weight>
 834     </font>
 835     <left/>
 836     <vcenter/>
 837     <data>
 838      <query>detail</query>
 839      <column>item_descrip2</column>
 840     </data>
 841    </field>
 842    <line>
 843     <xstart>5</xstart>
 844     <ystart>50</ystart>
 845     <xend>745</xend>
 846     <yend>50</yend>
 847     <weight>0</weight>
 848    </line>
 849    <field>
 850     <rect>
 851      <x>434</x>
 852      <y>15</y>
 853      <width>100</width>
 854      <height>15</height>
 855     </rect>
 856     <font>
 857      <face>Arial</face>
 858      <size>8</size>
 859      <weight>bold</weight>
 860     </font>
 861     <right/>
 862     <vcenter/>
 863     <data>
 864      <query>detail</query>
 865      <column>f_unallocated</column>
 866     </data>
 867    </field>
 868    <field>
 869     <rect>
 870      <x>5</x>
 871      <y>0</y>
 872      <width>45</width>
 873      <height>15</height>
 874     </rect>
 875     <font>
 876      <face>Arial</face>
 877      <size>8</size>
 878      <weight>bold</weight>
 879     </font>
 880     <hcenter/>
 881     <vcenter/>
 882     <data>
 883      <query>detail</query>
 884      <column>warehous_code</column>
 885     </data>
 886    </field>
 887   </detail>
 888  </section>
 889  <pgfoot>
 890   <height>16</height>
 891   <field>
 892    <rect>
 893     <x>705</x>
 894     <y>0</y>
 895     <width>40</width>
 896     <height>15</height>
 897    </rect>
 898    <font>
 899     <face>Arial</face>
 900     <size>8</size>
 901     <weight>bold</weight>
 902    </font>
 903    <left/>
 904    <vcenter/>
 905    <data>
 906     <query>Context Query</query>
 907     <column>page_number</column>
 908    </data>
 909   </field>
 910   <field>
 911    <rect>
 912     <x>85</x>
 913     <y>0</y>
 914     <width>100</width>
 915     <height>15</height>
 916    </rect>
 917    <font>
 918     <face>Arial</face>
 919     <size>8</size>
 920     <weight>bold</weight>
 921    </font>
 922    <left/>
 923    <vcenter/>
 924    <data>
 925     <query>Context Query</query>
 926     <column>report_date</column>
 927    </data>
 928   </field>
 929   <label>
 930    <rect>
 931     <x>5</x>
 932     <y>0</y>
 933     <width>75</width>
 934     <height>15</height>
 935    </rect>
 936    <font>
 937     <face>Arial</face>
 938     <size>8</size>
 939     <weight>normal</weight>
 940    </font>
 941    <right/>
 942    <vcenter/>
 943    <string>Report Date:</string>
 944   </label>
 945   <label>
 946    <rect>
 947     <x>625</x>
 948     <y>0</y>
 949     <width>75</width>
 950     <height>15</height>
 951    </rect>
 952    <font>
 953     <face>Arial</face>
 954     <size>8</size>
 955     <weight>normal</weight>
 956    </font>
 957    <right/>
 958    <vcenter/>
 959    <string>Page:</string>
 960   </label>
 961  </pgfoot>
 962 </report>