采购单

以下是 PURCHASEORDER 表中数据的完整列表。

POID 状态 CUSTID ORDERDATE PORDER，显示为使用 XMLSERIALIZE 标量函数将其转换为序列化字符数据 注释
5000 未交付 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>

</PurchaseOrder> </item>
 这是新购买订单
5001 已装运 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>刮冰器，挡风玻璃
4 inch
</name>
<quantity>1</quantity>
<price>3.99</price>
</item>
</PurchaseOrder>
 这是新购买订单
5002 已装运 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>刮冰器，挡风玻璃
4 inch
</name>
<quantity>5</quantity>
<price>3.99</price>
</item>
</PurchaseOrder>
 这是新购买订单
5003 已装运 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>
 这是新购买订单
5004 已装运 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>
< items>
<partid>100-103-01</partid>
<name>Snow Shovel, Super
Deluxe 26 inch
</name>
<quantity>2</quantity>
<price>49.99</price>
</item>
</PurchaseOrder>
 这是新购买订单
5005 已装运 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>刮冰器，挡风玻璃
4 inch
</name>
<quantity>5</quantity>
<price>3.99</price>
</item>
</PurchaseOrder>
 这是新购买订单