PURCHASEORDER

Here is a complete listing of the data in the PURCHASEORDER table.

POID STATUS CUSTID ORDERDATE PORDER, shown as it appears using the XMLSERIALIZE scalar function to convert it to serialized character data COMMENTS
5000 Unshipped 1002 02/18/2006
<PurchaseOrder PoNum="5000"
    OrderDate="2006-02-18"
    Status="Unshipped">
<item>
   <partid>100-100-01</partid>
   <name>Snow Shovel, Basic
           22 inch
   </name>
   <quantity>3</quantity>
   <price>9.99</price>
</item>
<item>
   <partid>100-103-01</partid>
   <name>Snow Shovel, Super
           Deluxe 26 inch
   </name>
   <quantity>5</quantity>
   <price>49.99</price>
</item>    
</PurchaseOrder>  
 THIS IS A NEW PURCHASE ORDER
5001 Shipped 1003 02/03/2005
<PurchaseOrder PoNum="5001"
    OrderDate="2005-02-03"
    Status="Shipped">
<item>
   <partid>100-101-01</partid>
   <name>Snow Shovel, Deluxe
           24 inch
   </name>
   <quantity>1</quantity>
   <price>19.99</price>
</item>    
<item>
   <partid>100-103-01</partid>
   <name>Snow Shovel, Super
           Deluxe 26 inch
   </name>
   <quantity>2</quantity>
   <price>49.99</price>
</item>  
<item>
   <partid>100-201-01</partid>
   <name>Ice Scraper, Windshield
           4 inch
   </name>
   <quantity>1</quantity>
   <price>3.99</price>
</item>
</PurchaseOrder>  
THIS IS A NEW PURCHASE ORDER
5002 Shipped 1001 02/29/2004
<PurchaseOrder PoNum="5002"
    OrderDate="2004-02-29"
    Status="Shipped">
<item>
   <partid>100-100-01</partid>
   <name>Snow  Shovel, Basic
           22 inch
   </name>
   <quantity>3</quantity>
   <price>9.99</price>
</item>
<item>
  <partid>100-101-01</partid>
   <name>Snow Shovel, Deluxe
           24  inch
   </name>
   <quantity>5</quantity>
   <price>19.99</price>
</item>  
<item>
   <partid>100-201-01</partid>
   <name>Ice Scraper, Windshield
           4 inch
   </name>
   <quantity>5</quantity>
   <price>3.99</price>
</item>
</PurchaseOrder>    
THIS IS A NEW PURCHASE ORDER
5003 Shipped 1002 02/28/2005
<PurchaseOrder PoNum="5003"
    OrderDate="2005-02-28"
    Status="UnShipped">
<item>
   <partid>100-100-01</partid>
   <name>Snow Shovel, Basic
           22 inch
   </name>
   <quantity>1</quantity>
   <price>9.99</price>
</item>
</PurchaseOrder>
THIS IS A NEW PURCHASE ORDER
5004 Shipped 1005 11/18/2005
<PurchaseOrder PoNum="5004"
    OrderDate="2005-11-18"
    Status="Shipped">
<item>
   <partid>100-100-01</partid>
   <name>Snow Shovel, Basic
           22 inch
   </name>
   <quantity>4</quantity>
   <price>9.99</price>
</item>
< item>
   <partid>100-103-01</partid>
   <name>Snow Shovel, Super
           Deluxe 26 inch
   </name>
   <quantity>2</quantity>
   <price>49.99</price>
</item>
</PurchaseOrder>
THIS IS A NEW PURCHASE ORDER
5005 Shipped 1002 03/01/2006
<PurchaseOrder PoNum="5006"
    OrderDate="2006-03-01"
    Status="Shipped">
<item>
   <partid>100-100-01</partid>
   <name>Snow Shovel, Basic
           22 inch
   </name>
   <quantity>3</quantity>
   <price>9.99</price>
</item>
<item>
   <partid>100-101-01</partid>
   <name>Snow Shovel, Deluxe
           24 inch
   </name>
   <quantity>5</quantity>
   <price>19.99</price>
</item>  
<item>
   <partid>100-201-01</partid>
   <name>Ice Scraper, Windshield
           4 inch
   </name>
   <quantity>5</quantity>
   <price>3.99</price>
</item>
</PurchaseOrder>
 THIS IS A NEW PURCHASE ORDER