1 <?xml version="1.0" encoding="UTF-8" standalone="yes"?>
  2 <xs:schema version="1.0" xmlns:xs="http://www.w3.org/2001/XMLSchema">
  3 
  4   <xs:element name="Report" type="orderReportModel"/>
  5 
  6   <xs:complexType name="user">
  7     <xs:sequence>
  8       <xs:element name="Group" type="order" minOccurs="0" maxOccurs="unbounded"/>
  9     </xs:sequence>
 10   </xs:complexType>
 11 
 12   <xs:complexType name="order">
 13     <xs:sequence>
 14       <xs:element name="Group" type="line" minOccurs="0" maxOccurs="unbounded"/>
 15     </xs:sequence>
 16   </xs:complexType>
 17 
 18   <xs:complexType name="line">
 19     <xs:sequence>
 20       <xs:element name="OnEveryRow" type="row" minOccurs="0" maxOccurs="unbounded"/>
 21     </xs:sequence>
 22   </xs:complexType>
 23 
 24   <xs:complexType name="row">
 25     <xs:sequence>
 26       <xs:element name="orderline.orders.orderid" type="xs:int" nillable="true"/>
 27       <xs:element name="orderline.orders.userid" type="xs:string" nillable="true"/>
 28       <xs:element name="orderline.orders.orderdate" type="xs:string" nillable="true"/>
 29       <xs:element name="orderline.orders.shipfirstname" type="xs:string" nillable="true"/>
 30       <xs:element name="orderline.orders.shiplastname" type="xs:string" nillable="true"/>
 31       <xs:element name="orderline.orders.shipaddr1" type="xs:string" nillable="true"/>
 32       <xs:element name="orderline.orders.shipaddr2" type="xs:string" nillable="true"/>
 33       <xs:element name="orderline.orders.shipcity" type="xs:string" nillable="true"/>
 34       <xs:element name="orderline.orders.shipstate" type="xs:string" nillable="true"/>
 35       <xs:element name="orderline.orders.shipzip" type="xs:string" nillable="true"/>
 36       <xs:element name="orderline.orders.shipcountry" type="xs:string" nillable="true"/>
 37       <xs:element name="orderline.orders.billfirstname" type="xs:string" nillable="true"/>
 38       <xs:element name="orderline.orders.billlastname" type="xs:string" nillable="true"/>
 39       <xs:element name="orderline.orders.billaddr1" type="xs:string" nillable="true"/>
 40       <xs:element name="orderline.orders.billaddr2" type="xs:string" nillable="true"/>
 41       <xs:element name="orderline.orders.billcity" type="xs:string" nillable="true"/>
 42       <xs:element name="orderline.orders.billstate" type="xs:string" nillable="true"/>
 43       <xs:element name="orderline.orders.billzip" type="xs:string" nillable="true"/>
 44       <xs:element name="orderline.orders.billcountry" type="xs:string" nillable="true"/>
 45       <xs:element name="orderline.orders.totalprice" type="xs:double" nillable="true"/>
 46       <xs:element name="orderline.orders.creditcard" type="xs:string" nillable="true"/>
 47       <xs:element name="orderline.orders.exprdate" type="xs:string" nillable="true"/>
 48       <xs:element name="orderline.orders.cardtype" type="xs:string" nillable="true"/>
 49       <xs:element name="orderline.orders.sourceapp" type="xs:string" nillable="true"/>
 50       <xs:element name="orderline.account.userid" type="xs:string" nillable="true"/>
 51       <xs:element name="orderline.account.email" type="xs:string" nillable="true"/>
 52       <xs:element name="orderline.account.firstname" type="xs:string" nillable="true"/>
 53       <xs:element name="orderline.account.lastname" type="xs:string" nillable="true"/>
 54       <xs:element name="orderline.account.acstatus" type="xs:string" nillable="true"/>
 55       <xs:element name="orderline.account.addr1" type="xs:string" nillable="true"/>
 56       <xs:element name="orderline.account.addr2" type="xs:string" nillable="true"/>
 57       <xs:element name="orderline.account.city" type="xs:string" nillable="true"/>
 58       <xs:element name="orderline.account.state" type="xs:string" nillable="true"/>
 59       <xs:element name="orderline.account.zip" type="xs:string" nillable="true"/>
 60       <xs:element name="orderline.account.country" type="xs:string" nillable="true"/>
 61       <xs:element name="orderline.account.phone" type="xs:string" nillable="true"/>
 62       <xs:element name="orderline.account.langpref" type="xs:string" nillable="true"/>
 63       <xs:element name="orderline.account.favcategory" type="xs:string" nillable="true"/>
 64       <xs:element name="orderline.account.mylistopt" type="xs:int" nillable="true"/>
 65       <xs:element name="orderline.account.banneropt" type="xs:int" nillable="true"/>
 66       <xs:element name="orderline.account.sourceapp" type="xs:string" nillable="true"/>
 67       <xs:element name="orderline.country.code" type="xs:string" nillable="true"/>
 68       <xs:element name="orderline.country.codedesc" type="xs:string" nillable="true"/>
 69       <xs:element name="orderline.lineitem.orderid" type="xs:int" nillable="true"/>
 70       <xs:element name="orderline.lineitem.linenum" type="xs:int" nillable="true"/>
 71       <xs:element name="orderline.lineitem.itemid" type="xs:string" nillable="true"/>
 72       <xs:element name="orderline.lineitem.quantity" type="xs:int" nillable="true"/>
 73       <xs:element name="orderline.lineitem.unitprice" type="xs:double" nillable="true"/>
 74       <xs:element name="orderline.product.productid" type="xs:string" nillable="true"/>
 75       <xs:element name="orderline.product.catid" type="xs:string" nillable="true"/>
 76       <xs:element name="orderline.product.prodname" type="xs:string" nillable="true"/>
 77       <xs:element name="orderline.product.proddesc" type="xs:string" nillable="true"/>
 78       <xs:element name="orderline.product.prodpic" type="xs:string" nillable="true"/>
 79       <xs:element name="orderline.category.catid" type="xs:string" nillable="true"/>
 80       <xs:element name="orderline.category.catorder" type="xs:int" nillable="true"/>
 81       <xs:element name="orderline.category.catname" type="xs:string" nillable="true"/>
 82       <xs:element name="orderline.category.catdesc" type="xs:string" nillable="true"/>
 83       <xs:element name="orderline.category.catpic" type="xs:string" nillable="true"/>
 84       <xs:element name="orderline.item.itemid" type="xs:string" nillable="true"/>
 85       <xs:element name="orderline.item.productid" type="xs:string" nillable="true"/>
 86       <xs:element name="orderline.item.listprice" type="xs:double" nillable="true"/>
 87       <xs:element name="orderline.item.unitcost" type="xs:double" nillable="true"/>
 88       <xs:element name="orderline.item.supplier" type="xs:int" nillable="true"/>
 89       <xs:element name="orderline.item.itstatus" type="xs:string" nillable="true"/>
 90       <xs:element name="orderline.item.attr1" type="xs:string" nillable="true"/>
 91       <xs:element name="orderline.item.attr2" type="xs:string" nillable="true"/>
 92       <xs:element name="orderline.item.attr3" type="xs:string" nillable="true"/>
 93       <xs:element name="orderline.item.attr4" type="xs:string" nillable="true"/>
 94       <xs:element name="orderline.item.attr5" type="xs:string" nillable="true"/>
 95       <xs:element name="lineitemprice" type="xs:double" nillable="true"/>
 96       <xs:element name="overalltotal" type="xs:double" nillable="true"/>
 97       <xs:element name="usertotal" type="xs:double" nillable="true"/>
 98       <xs:element name="ordertotal" type="xs:double" nillable="true"/>
 99     </xs:sequence>
100   </xs:complexType>
101 
102   <xs:complexType name="orderReportModel" abstract="true">
103     <xs:element name="Group" type="user" minOccurs="0" maxOccurs="unbounded"/>
104   </xs:complexType>
105 </xs:schema>
106