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

   1 <!DOCTYPE openRPTDef>
   2 <report>
   3  <title>Packing List (Shipment)</title>
   4  <name>PackingList-Shipment</name>
   5  <description>Non-Hybrid version - driven only by shiphead_id parameter - Packing List showing the contents of a particular shipment - Shows RA# if SO is a replacement order for and RA</description>
   6  <parameter default="324" active="true" listtype="static" type="string" name="shiphead_id">
   7   <description></description>
   8  </parameter>
   9  <grid>
  10   <snap/>
  11   <show/>
  12   <x>0.05</x>
  13   <y>0.05</y>
  14  </grid>
  15  <size>Letter</size>
  16  <portrait/>
  17  <topmargin>25</topmargin>
  18  <bottommargin>25</bottommargin>
  19  <rightmargin>25</rightmargin>
  20  <leftmargin>25</leftmargin>
  21  <querysource>
  22   <name>head</name>
  23   <sql>SELECT shiphead_number, 'S/O #:' AS ordertype,
  24        cohead_number AS ordernumber,
  25        formatsobarcode(cohead_id) AS order_barcode,
  26        COALESCE(shiphead_shipvia, cohead_shipvia) AS shipvia,
  27        cohead_shiptophone AS shiptophone,
  28        cohead_custponumber,
  29        formatDate(cohead_orderdate) AS orderdate,
  30        cohead_shipcomments AS shipcomments,
  31        cohead_billtoname AS billtoname,
  32        formataddr(cohead_billtoaddress1, cohead_billtoaddress2,
  33                   cohead_billtoaddress3,
  34                   (cohead_billtocity || '  ' ||   cohead_billtostate ||
  35                   '  ' || cohead_billtozipcode), cohead_billtocountry) AS billing_address,
  36        cohead_shiptoname AS shiptoname,
  37        formataddr(cohead_shiptoaddress1, cohead_shiptoaddress2,
  38                   cohead_shiptoaddress3,
  39                   (cohead_shiptocity || '  ' ||   cohead_shiptostate ||
  40                   '  ' || cohead_shiptozipcode), cohead_shiptocountry) AS shipping_address,
  41
  42        cust_number,
  43        trim(cntct_first_name || ' ' || cntct_last_name) AS cust_contact,
  44        cntct_phone AS cust_phone,
  45        terms_descrip
  46   FROM shiphead
  47   JOIN cohead ON (cohead_id=shiphead_order_id)
  48   JOIN custinfo ON (cohead_cust_id=cust_id)
  49   JOIN terms ON (cohead_terms_id=terms_id)
  50   LEFT OUTER JOIN cntct ON (cust_cntct_id=cntct_id)
  51   LEFT OUTER JOIN addr ON (cntct_addr_id=addr_id)
  52  WHERE (shiphead_id=&lt;? value("shiphead_id") ?>)
  53
  54 &lt;? if exists("MultiWhs") ?>
  55 UNION
  56 SELECT shiphead_number, 'T/O #:' AS ordertype,
  57        tohead_number AS ordernumber,
  58        formattobarcode(tohead_id) AS order_barcode,
  59        shiphead_shipvia AS shipvia,
  60        tohead_destphone AS shiptophone,
  61        TEXT(' ') AS cohead_custponumber,
  62        formatDate(tohead_orderdate) AS orderdate,
  63        tohead_shipcomments AS shipcomments,
  64        tohead_srcname AS billtoname,
  65        formataddr(tohead_srcaddress1, tohead_srcaddress2,
  66                    tohead_srcaddress3,
  67                   (tohead_srccity || ' ' || tohead_srcstate ||
  68                    ' ' || tohead_srcpostalcode), tohead_srccountry) AS billing_address,
  69        tohead_destname AS shiptoname,
  70        formataddr(tohead_destaddress1, tohead_destaddress2,
  71                    tohead_destaddress3,
  72                   (tohead_destcity || ' ' || tohead_deststate ||
  73                    ' ' || tohead_destpostalcode), tohead_destcountry) AS shipping_address,
  74        'Transfer Order' AS cust_number,
  75        tohead_destcntct_name AS cust_contact,
  76        tohead_destphone AS cust_phone,
  77        '' AS terms_descrip
  78   FROM shiphead, tohead
  79  WHERE ((tohead_id=shiphead_order_id)
  80    AND  (shiphead_order_type='TO')
  81    AND  (shiphead_id=&lt;? value("shiphead_id") ?>)
  82 )
  83 &lt;? endif ?>;</sql>
  84  </querysource>
  85  <querysource>
  86   <name>scheddate</name>
  87   <sql>SELECT formatDate(MIN(coitem_scheddate)) AS scheddate
  88   FROM coitem, shipitem
  89  WHERE ((coitem_status &lt;> 'X')
  90    AND  (coitem_id=shipitem_orderitem_id)
  91    AND  (shipitem_shiphead_id=&lt;? value("shiphead_id") ?>));</sql>
  92  </querysource>
  93  <querysource>
  94   <name>detail</name>
  95   <sql>SELECT 1 AS groupby,
  96        coitem_linenumber AS sortline, coitem_subnumber AS sortsubline,
  97        formatsolinenumber(coitem_id) AS linenumber,
  98        coitem_memo AS memo,
  99        CASE WHEN (coitem_custpn != '') THEN coitem_custpn
 100             ELSE item_number
 101        END AS item_number,
 102        formatitemsitebarcode(itemsite_id) AS item_barcode,
 103        formatsoitembarcode(coitem_id) AS orderitem_barcode,
 104 --     In 2.3 replaced the next line:
 105 --     uom_name,
 106 --     with:
 107        (select uom_name from uom where uom_id = coitem_qty_uom_id) AS uom_name,
 108        itemsellinguom(item_id) AS shipuom,
 109        CASE WHEN (coitem_custpn != '' AND itemalias_usedescrip=TRUE) THEN itemalias_descrip1
 110             ELSE item_descrip1
 111        END AS item_descrip1,
 112        CASE WHEN (coitem_custpn != '' AND itemalias_usedescrip=TRUE) THEN itemalias_descrip2
 113             ELSE item_descrip2
 114        END AS item_descrip2,
 115
 116        formatQty(coitem_qtyord) AS ordered,
 117        (SELECT formatQty(SUM(shipitem_qty)) FROM shipitem WHERE ((shipitem_shiphead_id=&lt;? value("shiphead_id") ?>) AND (shipitem_orderitem_id=coitem_id))) AS shipped,
 118
 119        CASE WHEN (coitem_status='O' AND (SELECT cust_creditstatus
 120                                            FROM custinfo,cohead
 121                                           WHERE coitem_cohead_id=cohead_id
 122                                             AND (cust_id=cohead_cust_id))='H') THEN 'H'
 123             WHEN (coitem_status='O' AND ((SELECT SUM(invcitem_billed)
 124                                             FROM cohead, invchead, invcitem
 125                                            WHERE ((invchead_ordernumber=cohead_number)
 126                                              AND  (invcitem_invchead_id=invchead_id)
 127                                              AND  (invcitem_item_id=item_id)
 128                                              AND  (invcitem_warehous_id=itemsite_warehous_id)
 129                                              AND  (invcitem_linenumber=coitem_linenumber)
 130                                              AND  (cohead_id=coitem_cohead_id))) >= coitem_qtyord)) THEN 'I'
 131             WHEN (coitem_status='O' AND ((SELECT SUM(invcitem_billed)
 132                                             FROM cohead, invchead, invcitem
 133                                            WHERE ((invchead_ordernumber=cohead_number)
 134                                              AND  (invcitem_invchead_id=invchead_id)
 135                                              AND  (invcitem_item_id=item_id)
 136                                              AND  (invcitem_warehous_id=itemsite_warehous_id)
 137                                              AND  (invcitem_linenumber=coitem_linenumber)
 138                                              AND  (cohead_id=coitem_cohead_id))) > 0)) THEN 'P'
 139             WHEN (coitem_status='O' AND (qtyNetable(itemsite_id) - qtyAllocated(itemsite_id, CURRENT_DATE)
 140                                          + qtyOrdered(itemsite_id, CURRENT_DATE))
 141                                           >= (coitem_qtyord - coitem_qtyshipped + coitem_qtyreturned)) THEN 'R'
 142             ELSE coitem_status
 143        END AS f_status,
 144        CASE
 145          WHEN (getPacklistItemLotSerial(shipitem_shiphead_id, coitem_id) = '') THEN
 146            ''
 147          ELSE
 148            'Serial #/Lot Information:'
 149        END AS lotserial_title,
 150        getPacklistItemLotSerial(shipitem_shiphead_id, coitem_id) AS lotserial,
 151        CASE
 152          WHEN (getPacklistCharName(shipitem_shiphead_id, coitem_id) = '') THEN
 153            ''
 154          ELSE
 155            'Characteristics:'
 156        END AS char_title,
 157        getPacklistCharName(shipitem_shiphead_id, coitem_id) AS char_name,
 158        getPacklistCharValue(shipitem_shiphead_id, coitem_id) AS char_value
 159   FROM shipitem
 160        JOIN coitem ON (coitem_id=shipitem_orderitem_id)
 161        JOIN itemsite ON (itemsite_id=coitem_itemsite_id)
 162        JOIN item ON (item_id=itemsite_item_id)
 163        JOIN uom ON (uom_id=item_inv_uom_id)
 164        LEFT OUTER JOIN itemalias ON (itemalias_item_id=item_id AND itemalias_number=coitem_custpn)
 165  WHERE ( (coitem_status &lt;> 'X')
 166    AND (shipitem_shiphead_id=&lt;? value("shiphead_id") ?>)
 167 )
 168 &lt;? if exists("MultiWhs") ?>
 169 UNION
 170 SELECT 2 AS groupby,
 171        toitem_linenumber AS sortline, 0 AS sortsubline,
 172        CAST(toitem_linenumber AS text) AS linenumber,
 173        toitem_notes AS memo,
 174        item_number,
 175        formatitemsitebarcode(itemsite_id) AS item_barcode,
 176        formattoitembarcode(toitem_id) AS orderitem_barcode,
 177        uom_name,
 178        itemsellinguom(item_id) AS shipuom,
 179        item_descrip1,
 180        item_descrip2,
 181
 182        formatQty(toitem_qty_ordered) AS ordered,
 183
 184        (SELECT formatQty(SUM(shipitem_qty))
 185         FROM shipitem
 186         WHERE ((shipitem_shiphead_id=&lt;? value("shiphead_id") ?>)
 187           AND  (shipitem_orderitem_id=toitem_id))
 188        ) AS shipped,
 189
 190        toitem_status AS f_status,
 191        CASE
 192          WHEN (getPacklistItemLotSerial(shiphead_id, toitem_id) = '') THEN
 193            ''
 194          ELSE
 195            'Serial #/Lot Information:'
 196        END AS lotserial_title,
 197        getPacklistItemLotSerial(shiphead_id, toitem_id) AS lotserial,
 198        '' AS char_title,
 199        '' AS char_name,
 200        '' AS char_value
 201   FROM itemsite, item, toitem, tohead, shipitem, shiphead, uom
 202  WHERE ((toitem_item_id=item_id)
 203    AND  (item_inv_uom_id=uom_id)
 204    AND  (item_id=itemsite_item_id)
 205    AND  (toitem_tohead_id=tohead_id)
 206    AND  (toitem_status &lt;> 'X')
 207    AND  (tohead_src_warehous_id=itemsite_warehous_id)
 208    AND  (toitem_id=shipitem_orderitem_id)
 209    AND  (shipitem_shiphead_id=shiphead_id)
 210    AND  (shiphead_order_type='TO')
 211    AND  (shiphead_id=&lt;? value("shiphead_id") ?>)
 212 )
 213 &lt;? endif ?>
 214 ORDER BY sortline, sortsubline;</sql>
 215  </querysource>
 216  <querysource>
 217   <name>logo</name>
 218   <sql>SELECT image_data
 219 FROM image
 220 WHERE ((image_name='logo'));</sql>
 221  </querysource>
 222  <querysource>
 223   <name>so_ra_relation</name>
 224   <sql>--added in 2.3 to show RA link to S/O if the SO
 225 --was created as the result of a replacement RA
 226 &lt;? if exists("EnableReturnAuth") ?>
 227 select
 228 'RA #' AS ratext,
 229 rahead_number
 230 from
 231 rahead, cohead, shiphead
 232 where
 233 rahead_new_cohead_id = cohead_id
 234 and cohead_id = shiphead_order_id
 235 and shiphead_id = &lt;? value("shiphead_id") ?>;
 236 &lt;? else ?>
 237 select
 238 '' AS ratext,
 239 '' AS rahead_number
 240 &lt;? endif ?></sql>
 241  </querysource>
 242  <rpthead>
 243   <height>463</height>
 244   <image>
 245    <rect>
 246     <x>375</x>
 247     <y>0</y>
 248     <width>425</width>
 249     <height>100</height>
 250    </rect>
 251    <mode>stretch</mode>
 252    <data>
 253     <query>logo</query>
 254     <column>image_data</column>
 255    </data>
 256   </image>
 257   <field>
 258    <rect>
 259     <x>170</x>
 260     <y>112</y>
 261     <width>100</width>
 262     <height>20</height>
 263    </rect>
 264    <font>
 265     <face>Arial</face>
 266     <size>14</size>
 267     <weight>normal</weight>
 268    </font>
 269    <left/>
 270    <vcenter/>
 271    <data>
 272     <query>head</query>
 273     <column>ordernumber</column>
 274    </data>
 275   </field>
 276   <label>
 277    <rect>
 278     <x>10</x>
 279     <y>10</y>
 280     <width>355</width>
 281     <height>50</height>
 282    </rect>
 283    <font>
 284     <face>Arial</face>
 285     <size>20</size>
 286     <weight>bold</weight>
 287    </font>
 288    <left/>
 289    <vcenter/>
 290    <string>Shipment Packing List</string>
 291   </label>
 292   <label>
 293    <rect>
 294     <x>85</x>
 295     <y>440</y>
 296     <width>200</width>
 297     <height>15</height>
 298    </rect>
 299    <font>
 300     <face>Arial</face>
 301     <size>8</size>
 302     <weight>bold</weight>
 303    </font>
 304    <left/>
 305    <vcenter/>
 306    <string>Item Description</string>
 307   </label>
 308   <label>
 309    <rect>
 310     <x>10</x>
 311     <y>85</y>
 312     <width>150</width>
 313     <height>20</height>
 314    </rect>
 315    <font>
 316     <face>Arial</face>
 317     <size>14</size>
 318     <weight>normal</weight>
 319    </font>
 320    <left/>
 321    <vcenter/>
 322    <string>Shipment #:</string>
 323   </label>
 324   <label>
 325    <rect>
 326     <x>525</x>
 327     <y>425</y>
 328     <width>75</width>
 329     <height>20</height>
 330    </rect>
 331    <font>
 332     <face>Arial</face>
 333     <size>10</size>
 334     <weight>bold</weight>
 335    </font>
 336    <hcenter/>
 337    <vcenter/>
 338    <string>Verified</string>
 339   </label>
 340   <field>
 341    <rect>
 342     <x>170</x>
 343     <y>175</y>
 344     <width>170</width>
 345     <height>20</height>
 346    </rect>
 347    <font>
 348     <face>Arial</face>
 349     <size>14</size>
 350     <weight>normal</weight>
 351    </font>
 352    <left/>
 353    <vcenter/>
 354    <data>
 355     <query>head</query>
 356     <column>cust_number</column>
 357    </data>
 358   </field>
 359   <barcode>
 360    <rect>
 361     <x>375</x>
 362     <y>202</y>
 363     <width>307</width>
 364     <height>25</height>
 365    </rect>
 366    <format>3of9</format>
 367    <maxlength>20</maxlength>
 368    <left/>
 369    <narrowBarWidth>0.01</narrowBarWidth>
 370    <data>
 371     <query>head</query>
 372     <column>cohead_custponumber</column>
 373    </data>
 374   </barcode>
 375   <label>
 376    <rect>
 377     <x>375</x>
 378     <y>400</y>
 379     <width>75</width>
 380     <height>20</height>
 381    </rect>
 382    <font>
 383     <face>Arial</face>
 384     <size>12</size>
 385     <weight>normal</weight>
 386    </font>
 387    <left/>
 388    <vcenter/>
 389    <string>Terms:</string>
 390   </label>
 391   <field>
 392    <rect>
 393     <x>480</x>
 394     <y>285</y>
 395     <width>300</width>
 396     <height>20</height>
 397    </rect>
 398    <font>
 399     <face>Arial</face>
 400     <size>14</size>
 401     <weight>normal</weight>
 402    </font>
 403    <left/>
 404    <vcenter/>
 405    <data>
 406     <query>head</query>
 407     <column>shiptoname</column>
 408    </data>
 409   </field>
 410   <line>
 411    <xstart>0</xstart>
 412    <ystart>425</ystart>
 413    <xend>797</xend>
 414    <yend>425</yend>
 415    <weight>0</weight>
 416   </line>
 417   <label>
 418    <rect>
 419     <x>10</x>
 420     <y>202</y>
 421     <width>150</width>
 422     <height>20</height>
 423    </rect>
 424    <font>
 425     <face>Arial</face>
 426     <size>14</size>
 427     <weight>normal</weight>
 428    </font>
 429    <left/>
 430    <vcenter/>
 431    <string>Customer P/O #:</string>
 432   </label>
 433   <label>
 434    <rect>
 435     <x>10</x>
 436     <y>252</y>
 437     <width>150</width>
 438     <height>20</height>
 439    </rect>
 440    <font>
 441     <face>Arial</face>
 442     <size>14</size>
 443     <weight>normal</weight>
 444    </font>
 445    <left/>
 446    <vcenter/>
 447    <string>Sched. Date:</string>
 448   </label>
 449   <label>
 450    <rect>
 451     <x>10</x>
 452     <y>231</y>
 453     <width>150</width>
 454     <height>20</height>
 455    </rect>
 456    <font>
 457     <face>Arial</face>
 458     <size>14</size>
 459     <weight>normal</weight>
 460    </font>
 461    <left/>
 462    <vcenter/>
 463    <string>Order Date:</string>
 464   </label>
 465   <label>
 466    <rect>
 467     <x>25</x>
 468     <y>400</y>
 469     <width>95</width>
 470     <height>25</height>
 471    </rect>
 472    <font>
 473     <face>Arial</face>
 474     <size>12</size>
 475     <weight>normal</weight>
 476    </font>
 477    <left/>
 478    <top/>
 479    <string>Attention:</string>
 480   </label>
 481   <barcode>
 482    <rect>
 483     <x>375</x>
 484     <y>175</y>
 485     <width>177</width>
 486     <height>25</height>
 487    </rect>
 488    <format>3of9</format>
 489    <maxlength>10</maxlength>
 490    <left/>
 491    <narrowBarWidth>0.01</narrowBarWidth>
 492    <data>
 493     <query>head</query>
 494     <column>cust_number</column>
 495    </data>
 496   </barcode>
 497   <field>
 498    <rect>
 499     <x>170</x>
 500     <y>85</y>
 501     <width>100</width>
 502     <height>20</height>
 503    </rect>
 504    <font>
 505     <face>Arial</face>
 506     <size>14</size>
 507     <weight>normal</weight>
 508    </font>
 509    <left/>
 510    <vcenter/>
 511    <data>
 512     <query>head</query>
 513     <column>shiphead_number</column>
 514    </data>
 515   </field>
 516   <field>
 517    <rect>
 518     <x>10</x>
 519     <y>145</y>
 520     <width>150</width>
 521     <height>20</height>
 522    </rect>
 523    <font>
 524     <face>Arial</face>
 525     <size>14</size>
 526     <weight>normal</weight>
 527    </font>
 528    <left/>
 529    <vcenter/>
 530    <data>
 531     <query>so_ra_relation</query>
 532     <column>ratext</column>
 533    </data>
 534   </field>
 535   <field>
 536    <rect>
 537     <x>10</x>
 538     <y>112</y>
 539     <width>150</width>
 540     <height>20</height>
 541    </rect>
 542    <font>
 543     <face>Arial</face>
 544     <size>14</size>
 545     <weight>normal</weight>
 546    </font>
 547    <left/>
 548    <vcenter/>
 549    <data>
 550     <query>head</query>
 551     <column>ordertype</column>
 552    </data>
 553   </field>
 554   <label>
 555    <rect>
 556     <x>295</x>
 557     <y>425</y>
 558     <width>40</width>
 559     <height>20</height>
 560    </rect>
 561    <font>
 562     <face>Arial</face>
 563     <size>10</size>
 564     <weight>bold</weight>
 565    </font>
 566    <hcenter/>
 567    <vcenter/>
 568    <string>UOM</string>
 569   </label>
 570   <text>
 571    <rect>
 572     <x>480</x>
 573     <y>305</y>
 574     <width>300</width>
 575     <height>15</height>
 576    </rect>
 577    <bottompad>10</bottompad>
 578    <font>
 579     <face>Arial</face>
 580     <size>10</size>
 581     <weight>normal</weight>
 582    </font>
 583    <left/>
 584    <top/>
 585    <data>
 586     <query>head</query>
 587     <column>shipping_address</column>
 588    </data>
 589   </text>
 590   <label>
 591    <rect>
 592     <x>10</x>
 593     <y>285</y>
 594     <width>75</width>
 595     <height>20</height>
 596    </rect>
 597    <font>
 598     <face>Arial</face>
 599     <size>14</size>
 600     <weight>normal</weight>
 601    </font>
 602    <left/>
 603    <vcenter/>
 604    <string>Bill To:</string>
 605   </label>
 606   <field>
 607    <rect>
 608     <x>480</x>
 609     <y>252</y>
 610     <width>300</width>
 611     <height>20</height>
 612    </rect>
 613    <font>
 614     <face>Arial</face>
 615     <size>14</size>
 616     <weight>normal</weight>
 617    </font>
 618    <left/>
 619    <vcenter/>
 620    <data>
 621     <query>head</query>
 622     <column>shipvia</column>
 623    </data>
 624   </field>
 625   <field>
 626    <rect>
 627     <x>455</x>
 628     <y>400</y>
 629     <width>320</width>
 630     <height>20</height>
 631    </rect>
 632    <font>
 633     <face>Arial</face>
 634     <size>12</size>
 635     <weight>normal</weight>
 636    </font>
 637    <left/>
 638    <vcenter/>
 639    <data>
 640     <query>head</query>
 641     <column>terms_descrip</column>
 642    </data>
 643   </field>
 644   <field>
 645    <rect>
 646     <x>170</x>
 647     <y>231</y>
 648     <width>100</width>
 649     <height>20</height>
 650    </rect>
 651    <font>
 652     <face>Arial</face>
 653     <size>14</size>
 654     <weight>normal</weight>
 655    </font>
 656    <left/>
 657    <vcenter/>
 658    <data>
 659     <query>head</query>
 660     <column>orderdate</column>
 661    </data>
 662   </field>
 663   <field>
 664    <rect>
 665     <x>170</x>
 666     <y>202</y>
 667     <width>170</width>
 668     <height>20</height>
 669    </rect>
 670    <font>
 671     <face>Arial</face>
 672     <size>14</size>
 673     <weight>normal</weight>
 674    </font>
 675    <left/>
 676    <vcenter/>
 677    <data>
 678     <query>head</query>
 679     <column>cohead_custponumber</column>
 680    </data>
 681   </field>
 682   <line>
 683    <xstart>0</xstart>
 684    <ystart>455</ystart>
 685    <xend>797</xend>
 686    <yend>455</yend>
 687    <weight>0</weight>
 688   </line>
 689   <label>
 690    <rect>
 691     <x>375</x>
 692     <y>252</y>
 693     <width>100</width>
 694     <height>20</height>
 695    </rect>
 696    <font>
 697     <face>Arial</face>
 698     <size>14</size>
 699     <weight>normal</weight>
 700    </font>
 701    <left/>
 702    <vcenter/>
 703    <string>Ship Via:</string>
 704   </label>
 705   <label>
 706    <rect>
 707     <x>5</x>
 708     <y>425</y>
 709     <width>75</width>
 710     <height>20</height>
 711    </rect>
 712    <font>
 713     <face>Arial</face>
 714     <size>10</size>
 715     <weight>bold</weight>
 716    </font>
 717    <left/>
 718    <vcenter/>
 719    <string>Order Line</string>
 720   </label>
 721   <label>
 722    <rect>
 723     <x>345</x>
 724     <y>425</y>
 725     <width>80</width>
 726     <height>20</height>
 727    </rect>
 728    <font>
 729     <face>Arial</face>
 730     <size>10</size>
 731     <weight>bold</weight>
 732    </font>
 733    <right/>
 734    <vcenter/>
 735    <string>Ordered</string>
 736   </label>
 737   <barcode>
 738    <rect>
 739     <x>375</x>
 740     <y>112</y>
 741     <width>231</width>
 742     <height>25</height>
 743    </rect>
 744    <format>128</format>
 745    <maxlength>10</maxlength>
 746    <left/>
 747    <narrowBarWidth>0.01</narrowBarWidth>
 748    <data>
 749     <query>head</query>
 750     <column>order_barcode</column>
 751    </data>
 752   </barcode>
 753   <field>
 754    <rect>
 755     <x>90</x>
 756     <y>285</y>
 757     <width>300</width>
 758     <height>20</height>
 759    </rect>
 760    <font>
 761     <face>Arial</face>
 762     <size>14</size>
 763     <weight>normal</weight>
 764    </font>
 765    <left/>
 766    <vcenter/>
 767    <data>
 768     <query>head</query>
 769     <column>billtoname</column>
 770    </data>
 771   </field>
 772   <field>
 773    <rect>
 774     <x>170</x>
 775     <y>252</y>
 776     <width>100</width>
 777     <height>20</height>
 778    </rect>
 779    <font>
 780     <face>Arial</face>
 781     <size>14</size>
 782     <weight>normal</weight>
 783    </font>
 784    <left/>
 785    <vcenter/>
 786    <data>
 787     <query>scheddate</query>
 788     <column>scheddate</column>
 789    </data>
 790   </field>
 791   <label>
 792    <rect>
 793     <x>432</x>
 794     <y>425</y>
 795     <width>80</width>
 796     <height>20</height>
 797    </rect>
 798    <font>
 799     <face>Arial</face>
 800     <size>10</size>
 801     <weight>bold</weight>
 802    </font>
 803    <right/>
 804    <vcenter/>
 805    <string>Shipped</string>
 806   </label>
 807   <label>
 808    <rect>
 809     <x>85</x>
 810     <y>425</y>
 811     <width>200</width>
 812     <height>20</height>
 813    </rect>
 814    <font>
 815     <face>Arial</face>
 816     <size>10</size>
 817     <weight>bold</weight>
 818    </font>
 819    <left/>
 820    <vcenter/>
 821    <string>Item Number</string>
 822   </label>
 823   <field>
 824    <rect>
 825     <x>170</x>
 826     <y>145</y>
 827     <width>170</width>
 828     <height>20</height>
 829    </rect>
 830    <font>
 831     <face>Arial</face>
 832     <size>14</size>
 833     <weight>normal</weight>
 834    </font>
 835    <left/>
 836    <vcenter/>
 837    <data>
 838     <query>so_ra_relation</query>
 839     <column>rahead_number</column>
 840    </data>
 841   </field>
 842   <label>
 843    <rect>
 844     <x>375</x>
 845     <y>285</y>
 846     <width>100</width>
 847     <height>20</height>
 848    </rect>
 849    <font>
 850     <face>Arial</face>
 851     <size>14</size>
 852     <weight>normal</weight>
 853    </font>
 854    <left/>
 855    <vcenter/>
 856    <string>Ship To:</string>
 857   </label>
 858   <field>
 859    <rect>
 860     <x>112</x>
 861     <y>400</y>
 862     <width>250</width>
 863     <height>20</height>
 864    </rect>
 865    <font>
 866     <face>Arial</face>
 867     <size>12</size>
 868     <weight>normal</weight>
 869    </font>
 870    <left/>
 871    <top/>
 872    <data>
 873     <query>head</query>
 874     <column>cust_contact</column>
 875    </data>
 876   </field>
 877   <text>
 878    <rect>
 879     <x>90</x>
 880     <y>305</y>
 881     <width>300</width>
 882     <height>15</height>
 883    </rect>
 884    <bottompad>10</bottompad>
 885    <font>
 886     <face>Arial</face>
 887     <size>10</size>
 888     <weight>normal</weight>
 889    </font>
 890    <left/>
 891    <top/>
 892    <data>
 893     <query>head</query>
 894     <column>billing_address</column>
 895    </data>
 896   </text>
 897   <label>
 898    <rect>
 899     <x>10</x>
 900     <y>175</y>
 901     <width>150</width>
 902     <height>20</height>
 903    </rect>
 904    <font>
 905     <face>Arial</face>
 906     <size>14</size>
 907     <weight>normal</weight>
 908    </font>
 909    <left/>
 910    <vcenter/>
 911    <string>Customer #:</string>
 912   </label>
 913  </rpthead>
 914  <section>
 915   <name>detail</name>
 916   <group>
 917    <name>characteristic</name>
 918    <column>linenumber</column>
 919    <foot>
 920     <height>35</height>
 921     <text>
 922      <rect>
 923       <x>130</x>
 924       <y>5</y>
 925       <width>195</width>
 926       <height>17</height>
 927      </rect>
 928      <bottompad>14</bottompad>
 929      <font>
 930       <face>Arial</face>
 931       <size>10</size>
 932       <weight>normal</weight>
 933      </font>
 934      <left/>
 935      <vcenter/>
 936      <data>
 937       <query>detail</query>
 938       <column>char_name</column>
 939      </data>
 940     </text>
 941     <text>
 942      <rect>
 943       <x>10</x>
 944       <y>5</y>
 945       <width>103</width>
 946       <height>17</height>
 947      </rect>
 948      <bottompad>14</bottompad>
 949      <font>
 950       <face>Arial</face>
 951       <size>10</size>
 952       <weight>normal</weight>
 953      </font>
 954      <left/>
 955      <vcenter/>
 956      <data>
 957       <query>detail</query>
 958       <column>char_title</column>
 959      </data>
 960     </text>
 961     <text>
 962      <rect>
 963       <x>370</x>
 964       <y>5</y>
 965       <width>195</width>
 966       <height>17</height>
 967      </rect>
 968      <bottompad>14</bottompad>
 969      <font>
 970       <face>Arial</face>
 971       <size>10</size>
 972       <weight>normal</weight>
 973      </font>
 974      <left/>
 975      <vcenter/>
 976      <data>
 977       <query>detail</query>
 978       <column>char_value</column>
 979      </data>
 980     </text>
 981    </foot>
 982   </group>
 983   <group>
 984    <name>lotserial</name>
 985    <column>linenumber</column>
 986    <foot>
 987     <height>29</height>
 988     <text>
 989      <rect>
 990       <x>10</x>
 991       <y>5</y>
 992       <width>185</width>
 993       <height>17</height>
 994      </rect>
 995      <bottompad>14</bottompad>
 996      <font>
 997       <face>Arial</face>
 998       <size>10</size>
 999       <weight>normal</weight>
1000      </font>
1001      <left/>
1002      <vcenter/>
1003      <data>
1004       <query>detail</query>
1005       <column>lotserial_title</column>
1006      </data>
1007     </text>
1008     <text>
1009      <rect>
1010       <x>228</x>
1011       <y>5</y>
1012       <width>550</width>
1013       <height>17</height>
1014      </rect>
1015      <bottompad>14</bottompad>
1016      <font>
1017       <face>Arial</face>
1018       <size>10</size>
1019       <weight>normal</weight>
1020      </font>
1021      <left/>
1022      <vcenter/>
1023      <data>
1024       <query>detail</query>
1025       <column>lotserial</column>
1026      </data>
1027     </text>
1028    </foot>
1029   </group>
1030   <group>
1031    <name>line</name>
1032    <column>linenumber</column>
1033    <foot>
1034     <height>82</height>
1035     <label>
1036      <rect>
1037       <x>610</x>
1038       <y>0</y>
1039       <width>50</width>
1040       <height>17</height>
1041      </rect>
1042      <font>
1043       <face>Arial</face>
1044       <size>10</size>
1045       <weight>normal</weight>
1046      </font>
1047      <left/>
1048      <vcenter/>
1049      <string>Status:</string>
1050     </label>
1051     <field>
1052      <rect>
1053       <x>430</x>
1054       <y>0</y>
1055       <width>80</width>
1056       <height>20</height>
1057      </rect>
1058      <font>
1059       <face>Arial</face>
1060       <size>10</size>
1061       <weight>normal</weight>
1062      </font>
1063      <right/>
1064      <vcenter/>
1065      <data>
1066       <query>detail</query>
1067       <column>shipped</column>
1068      </data>
1069     </field>
1070     <text>
1071      <rect>
1072       <x>70</x>
1073       <y>55</y>
1074       <width>665</width>
1075       <height>17</height>
1076      </rect>
1077      <bottompad>14</bottompad>
1078      <font>
1079       <face>Arial</face>
1080       <size>10</size>
1081       <weight>normal</weight>
1082      </font>
1083      <left/>
1084      <vcenter/>
1085      <data>
1086       <query>detail</query>
1087       <column>memo</column>
1088      </data>
1089     </text>
1090     <field>
1091      <rect>
1092       <x>80</x>
1093       <y>0</y>
1094       <width>200</width>
1095       <height>20</height>
1096      </rect>
1097      <font>
1098       <face>Arial</face>
1099       <size>11</size>
1100       <weight>bold</weight>
1101      </font>
1102      <left/>
1103      <vcenter/>
1104      <data>
1105       <query>detail</query>
1106       <column>item_number</column>
1107      </data>
1108     </field>
1109     <line>
1110      <xstart>545</xstart>
1111      <ystart>15</ystart>
1112      <xend>595</xend>
1113      <yend>15</yend>
1114      <weight>1</weight>
1115     </line>
1116     <field>
1117      <rect>
1118       <x>290</x>
1119       <y>0</y>
1120       <width>40</width>
1121       <height>20</height>
1122      </rect>
1123      <font>
1124       <face>Arial</face>
1125       <size>10</size>
1126       <weight>normal</weight>
1127      </font>
1128      <hcenter/>
1129      <vcenter/>
1130      <data>
1131       <query>detail</query>
1132       <column>uom_name</column>
1133      </data>
1134     </field>
1135     <field>
1136      <rect>
1137       <x>340</x>
1138       <y>0</y>
1139       <width>80</width>
1140       <height>20</height>
1141      </rect>
1142      <font>
1143       <face>Arial</face>
1144       <size>10</size>
1145       <weight>normal</weight>
1146      </font>
1147      <right/>
1148      <vcenter/>
1149      <data>
1150       <query>detail</query>
1151       <column>ordered</column>
1152      </data>
1153     </field>
1154     <field>
1155      <rect>
1156       <x>80</x>
1157       <y>35</y>
1158       <width>300</width>
1159       <height>15</height>
1160      </rect>
1161      <font>
1162       <face>Arial</face>
1163       <size>11</size>
1164       <weight>normal</weight>
1165      </font>
1166      <left/>
1167      <vcenter/>
1168      <data>
1169       <query>detail</query>
1170       <column>item_descrip2</column>
1171      </data>
1172     </field>
1173     <field>
1174      <rect>
1175       <x>670</x>
1176       <y>0</y>
1177       <width>50</width>
1178       <height>17</height>
1179      </rect>
1180      <font>
1181       <face>Arial</face>
1182       <size>10</size>
1183       <weight>normal</weight>
1184      </font>
1185      <left/>
1186      <vcenter/>
1187      <data>
1188       <query>detail</query>
1189       <column>f_status</column>
1190      </data>
1191     </field>
1192     <barcode>
1193      <rect>
1194       <x>415</x>
1195       <y>20</y>
1196       <width>380</width>
1197       <height>30</height>
1198      </rect>
1199      <format>128</format>
1200      <maxlength>15</maxlength>
1201      <right/>
1202      <narrowBarWidth>0.01</narrowBarWidth>
1203      <data>
1204       <query>detail</query>
1205       <column>item_barcode</column>
1206      </data>
1207     </barcode>
1208     <field>
1209      <rect>
1210       <x>80</x>
1211       <y>20</y>
1212       <width>300</width>
1213       <height>15</height>
1214      </rect>
1215      <font>
1216       <face>Arial</face>
1217       <size>11</size>
1218       <weight>normal</weight>
1219      </font>
1220      <left/>
1221      <vcenter/>
1222      <data>
1223       <query>detail</query>
1224       <column>item_descrip1</column>
1225      </data>
1226     </field>
1227     <field>
1228      <rect>
1229       <x>5</x>
1230       <y>0</y>
1231       <width>42</width>
1232       <height>20</height>
1233      </rect>
1234      <font>
1235       <face>Arial</face>
1236       <size>11</size>
1237       <weight>bold</weight>
1238      </font>
1239      <left/>
1240      <vcenter/>
1241      <data>
1242       <query>detail</query>
1243       <column>linenumber</column>
1244      </data>
1245     </field>
1246     <label>
1247      <rect>
1248       <x>10</x>
1249       <y>55</y>
1250       <width>55</width>
1251       <height>17</height>
1252      </rect>
1253      <font>
1254       <face>Arial</face>
1255       <size>10</size>
1256       <weight>normal</weight>
1257      </font>
1258      <left/>
1259      <vcenter/>
1260      <string>Notes:</string>
1261     </label>
1262    </foot>
1263   </group>
1264   <detail>
1265    <key>
1266     <query>detail</query>
1267    </key>
1268    <height>9</height>
1269   </detail>
1270  </section>
1271  <section>
1272   <name>packlist</name>
1273   <detail>
1274    <key>
1275     <query>head</query>
1276    </key>
1277    <height>41</height>
1278    <text>
1279     <rect>
1280      <x>5</x>
1281      <y>10</y>
1282      <width>625</width>
1283      <height>17</height>
1284     </rect>
1285     <bottompad>14</bottompad>
1286     <font>
1287      <face>Arial</face>
1288      <size>10</size>
1289      <weight>normal</weight>
1290     </font>
1291     <left/>
1292     <vcenter/>
1293     <data>
1294      <query>head</query>
1295      <column>shipcomments</column>
1296     </data>
1297    </text>
1298    <line>
1299     <xstart>5</xstart>
1300     <ystart>5</ystart>
1301     <xend>842</xend>
1302     <yend>5</yend>
1303     <weight>0</weight>
1304    </line>
1305   </detail>
1306  </section>
1307  <pgfoot>
1308   <height>57</height>
1309   <field>
1310    <rect>
1311     <x>455</x>
1312     <y>7</y>
1313     <width>80</width>
1314     <height>17</height>
1315    </rect>
1316    <font>
1317     <face>Arial</face>
1318     <size>8</size>
1319     <weight>normal</weight>
1320    </font>
1321    <left/>
1322    <top/>
1323    <data>
1324     <query>head</query>
1325     <column>ordernumber</column>
1326    </data>
1327   </field>
1328   <label>
1329    <rect>
1330     <x>695</x>
1331     <y>5</y>
1332     <width>37</width>
1333     <height>17</height>
1334    </rect>
1335    <font>
1336     <face>Arial</face>
1337     <size>8</size>
1338     <weight>normal</weight>
1339    </font>
1340    <right/>
1341    <top/>
1342    <string>Page:</string>
1343   </label>
1344   <label>
1345    <rect>
1346     <x>25</x>
1347     <y>5</y>
1348     <width>61</width>
1349     <height>17</height>
1350    </rect>
1351    <font>
1352     <face>Arial</face>
1353     <size>8</size>
1354     <weight>normal</weight>
1355    </font>
1356    <right/>
1357    <top/>
1358    <string>Print Date: </string>
1359   </label>
1360   <field>
1361    <rect>
1362     <x>735</x>
1363     <y>5</y>
1364     <width>45</width>
1365     <height>17</height>
1366    </rect>
1367    <font>
1368     <face>Arial</face>
1369     <size>8</size>
1370     <weight>normal</weight>
1371    </font>
1372    <left/>
1373    <top/>
1374    <data>
1375     <query>Context Query</query>
1376     <column>page_number</column>
1377    </data>
1378   </field>
1379   <field>
1380    <rect>
1381     <x>90</x>
1382     <y>5</y>
1383     <width>95</width>
1384     <height>17</height>
1385    </rect>
1386    <font>
1387     <face>Arial</face>
1388     <size>8</size>
1389     <weight>normal</weight>
1390    </font>
1391    <left/>
1392    <top/>
1393    <data>
1394     <query>Context Query</query>
1395     <column>report_date</column>
1396    </data>
1397   </field>
1398   <field>
1399    <rect>
1400     <x>365</x>
1401     <y>7</y>
1402     <width>80</width>
1403     <height>17</height>
1404    </rect>
1405    <font>
1406     <face>Arial</face>
1407     <size>8</size>
1408     <weight>normal</weight>
1409    </font>
1410    <left/>
1411    <top/>
1412    <data>
1413     <query>head</query>
1414     <column>ordertype</column>
1415    </data>
1416   </field>
1417  </pgfoot>
1418  <rptfoot>
1419   <height>94</height>
1420   <label>
1421    <rect>
1422     <x>10</x>
1423     <y>45</y>
1424     <width>160</width>
1425     <height>35</height>
1426    </rect>
1427    <font>
1428     <face>Arial</face>
1429     <size>14</size>
1430     <weight>bold</weight>
1431    </font>
1432    <left/>
1433    <vcenter/>
1434    <string>Completed By:</string>
1435   </label>
1436   <line>
1437    <xstart>540</xstart>
1438    <ystart>70</ystart>
1439    <xend>790</xend>
1440    <yend>70</yend>
1441    <weight>0</weight>
1442   </line>
1443   <label>
1444    <rect>
1445     <x>415</x>
1446     <y>45</y>
1447     <width>165</width>
1448     <height>30</height>
1449    </rect>
1450    <font>
1451     <face>Arial</face>
1452     <size>14</size>
1453     <weight>bold</weight>
1454    </font>
1455    <left/>
1456    <vcenter/>
1457    <string>Checked By:</string>
1458   </label>
1459   <line>
1460    <xstart>160</xstart>
1461    <ystart>70</ystart>
1462    <xend>407</xend>
1463    <yend>70</yend>
1464    <weight>0</weight>
1465   </line>
1466  </rptfoot>
1467 </report>