Orders - OrderDetails

From DevWiki

Jump to: navigation, search

Orders - OrderDetails Intro

Orders and OrderDetails are the only tables which are restricted to an import mode of Insert only. The reason for this is that an update command and delete can be very dangerous and require much more work which the API can not at this time handle.

An insert into TrackingNumbers does give the ability to update the order status of the order for which the tracking number was inserted for and also send the Order Has Shipped email.

Custom Fields

If Custom Fields are changed for orders you must do the following to have access to those fields.

The store owner must FTP into their store and go to the /vspfiles/schema/ directory and delete a file called Orders.xsd. Once this file is deleted the next time the API is called it will generate that file with the new Custom Fields. If this step is not done the API will have no access to those columns. This also applies to Customers.

Orders - OrderDetails XSD 

<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="xmldata" xmlns="" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata"
xmlns:msprop="urn:schemas-microsoft-com:xml-msprop">
 <xs:element name="xmldata" msdata:IsDataSet="true" msdata:UseCurrentLocale="true">
   <xs:complexType>
     <xs:choice minOccurs="0" maxOccurs="unbounded">
       <xs:element name="Orders">
         <xs:complexType>
           <xs:sequence>
             <xs:element msprop:TableNameXsd="Orders" name="OrderID" msprop:SQLTableAlias="o" msprop:SqlDbType="Int"
msprop:IsIdentity="true" minOccurs="0" />
             <xs:element name="AccountNumber" msprop:maxLength="64" msprop:SQLTableAlias="o" msprop:SqlDbType="VarChar"
minOccurs="0" />
             <xs:element name="AccountType" msprop:maxLength="10" msprop:SQLTableAlias="o" msprop:SqlDbType="VarChar"
minOccurs="0" />
             <xs:element name="AddressValidated" msprop:maxLength="1" msprop:SQLTableAlias="o" msprop:SqlDbType="VarChar"
minOccurs="0" />
             <xs:element name="Affiliate_Commissionable_Value" msprop:SQLTableAlias="o" msprop:SqlDbType="Money" minOccurs="0" />
             <xs:element name="AVS" msprop:maxLength="25" msprop:SQLTableAlias="o" msprop:SqlDbType="VarChar" minOccurs="0" />
             <xs:element name="BankName" msprop:maxLength="64" msprop:SQLTableAlias="o" msprop:SqlDbType="VarChar" minOccurs="0" />
             <xs:element name="BatchNumber" msprop:SQLTableAlias="o" msprop:SqlDbType="Int" minOccurs="0" />
             <xs:element name="BillingAddress1" msprop:maxLength="75" msprop:SQLTableAlias="o" msprop:SqlDbType="VarChar"
minOccurs="0" />
             <xs:element name="BillingAddress2" msprop:maxLength="75" msprop:SQLTableAlias="o" msprop:SqlDbType="VarChar"
minOccurs="0" />
             <xs:element name="BillingCity" msprop:maxLength="45" msprop:SQLTableAlias="o" msprop:SqlDbType="VarChar"
minOccurs="0" />
             <xs:element name="BillingCompanyName" msprop:maxLength="50" msprop:SQLTableAlias="o" msprop:SqlDbType="VarChar"
minOccurs="0" />
             <xs:element name="BillingCountry" msprop:maxLength="30" msprop:SQLTableAlias="o" msprop:SqlDbType="VarChar"
minOccurs="0" />
             <xs:element name="BillingFaxNumber" msprop:maxLength="30" msprop:SQLTableAlias="o" msprop:SqlDbType="VarChar"
minOccurs="0" />
             <xs:element name="BillingFirstName" msprop:maxLength="30" msprop:SQLTableAlias="o" msprop:SqlDbType="VarChar"
minOccurs="0" />
             <xs:element name="BillingLastName" msprop:maxLength="40" msprop:SQLTableAlias="o" msprop:SqlDbType="VarChar"
minOccurs="0" />
             <xs:element name="BillingPhoneNumber" msprop:maxLength="35" msprop:SQLTableAlias="o" msprop:SqlDbType="VarChar"
minOccurs="0" />
             <xs:element name="BillingPostalCode" msprop:maxLength="15" msprop:SQLTableAlias="o" msprop:SqlDbType="VarChar"
minOccurs="0" />
             <xs:element name="BillingState" msprop:maxLength="30" msprop:SQLTableAlias="o" msprop:SqlDbType="VarChar"
minOccurs="0" />
             <xs:element name="CardHoldersName" msprop:maxLength="128" msprop:SQLTableAlias="o" msprop:SqlDbType="VarChar"
minOccurs="0" />
             <xs:element name="CashTender" msprop:SQLTableAlias="o" msprop:SqlDbType="Money" minOccurs="0" />
             <xs:element name="CC_Last4" msprop:maxLength="4" msprop:SQLTableAlias="o" msprop:SqlDbType="VarChar" minOccurs="0" />
             <xs:element name="CheckNumber" msprop:maxLength="64" msprop:SQLTableAlias="o" msprop:SqlDbType="VarChar"
minOccurs="0" />
             <xs:element name="CreditCardAuthorizationDate" msprop:SQLTableAlias="o" msprop:SqlDbType="SmallDateTime"
minOccurs="0" />
             <xs:element name="CreditCardAuthorizationNumber" msprop:maxLength="60" msprop:SQLTableAlias="o"
msprop:SqlDbType="VarChar" minOccurs="0" />
             <xs:element name="CreditCardExpDate" msprop:maxLength="64" msprop:SQLTableAlias="o" msprop:SqlDbType="VarChar"
minOccurs="0" />
             <xs:element name="CreditCardIssueDate" msprop:maxLength="64" msprop:SQLTableAlias="o" msprop:SqlDbType="VarChar"
minOccurs="0" />
             <xs:element name="CreditCardIssueNumber" msprop:maxLength="64" msprop:SQLTableAlias="o" msprop:SqlDbType="VarChar"
minOccurs="0" />
             <xs:element name="CreditCardTransactionID" msprop:maxLength="60" msprop:SQLTableAlias="o" msprop:SqlDbType="VarChar"
minOccurs="0" />
             <xs:element name="Custom_Field_Custom1" msprop:maxLength="50" msprop:SQLTableAlias="o" msprop:SqlDbType="VarChar"
minOccurs="0" />
             <xs:element name="Custom_Field_Custom2" msprop:maxLength="50" msprop:SQLTableAlias="o" msprop:SqlDbType="VarChar"
minOccurs="0" />
             <xs:element name="Custom_Field_Custom3" msprop:maxLength="50" msprop:SQLTableAlias="o" msprop:SqlDbType="VarChar"
minOccurs="0" />
             <xs:element name="Custom_Field_Custom4" msprop:maxLength="50" msprop:SQLTableAlias="o" msprop:SqlDbType="VarChar"
minOccurs="0" />
             <xs:element name="Custom_Field_Custom5" msprop:maxLength="50" msprop:SQLTableAlias="o" msprop:SqlDbType="VarChar"
minOccurs="0" />
             <xs:element name="Customer_IPAddress" msprop:maxLength="15" msprop:SQLTableAlias="o" msprop:SqlDbType="VarChar"
minOccurs="0" />
             <xs:element name="CustomerID" msprop:SQLTableAlias="o" msprop:SqlDbType="Int" minOccurs="1" />
             <xs:element name="CVV2_Response" msprop:maxLength="25" msprop:SQLTableAlias="o" msprop:SqlDbType="VarChar"
minOccurs="0" />
             <xs:element name="DV_CreditCardNumber" msprop:SQLTableAlias="o" msprop:SqlDbType="UniqueIdentifier" minOccurs="0" />
             <xs:element name="GiftCardIDUsed" msprop:maxLength="1" msprop:SQLTableAlias="o" msprop:SqlDbType="VarChar"
minOccurs="0" />
             <xs:element name="IsAGift" msprop:maxLength="1" msprop:SQLTableAlias="o" msprop:SqlDbType="VarChar" minOccurs="0" />
             <xs:element name="LastModBy" msprop:SQLTableAlias="o" msprop:SqlDbType="Int" minOccurs="0" />
             <xs:element name="LastModified" msprop:SQLTableAlias="o" msprop:SqlDbType="SmallDateTime" minOccurs="0" />
             <xs:element name="Locked" msprop:maxLength="1" msprop:SQLTableAlias="o" msprop:SqlDbType="VarChar" minOccurs="0" />
             <xs:element name="MICR" msprop:maxLength="64" msprop:SQLTableAlias="o" msprop:SqlDbType="VarChar" minOccurs="0" />
             <xs:element name="Order_Comments" msprop:SQLTableAlias="o" msprop:SqlDbType="Text" minOccurs="0" />
             <xs:element name="Order_Entry_System" msprop:maxLength="15" msprop:SQLTableAlias="o" msprop:SqlDbType="VarChar"
minOccurs="0" />
             <xs:element name="OrderDate" msprop:SQLTableAlias="o" msprop:SqlDbType="SmallDateTime" minOccurs="0" />
             <xs:element name="OrderID_EDI" msprop:maxLength="20" msprop:SQLTableAlias="o" msprop:SqlDbType="VarChar"
minOccurs="0" />
             <xs:element name="OrderID_Third_Party" msprop:maxLength="40" msprop:SQLTableAlias="o" msprop:SqlDbType="VarChar"
minOccurs="0" />
             <xs:element name="OrderNotes" msprop:SQLTableAlias="o" msprop:SqlDbType="Text" minOccurs="0" />
             <xs:element name="OrderStatus" msprop:maxLength="50" msprop:SQLTableAlias="o" msprop:SqlDbType="VarChar"
minOccurs="0" />
             <xs:element name="PaymentAmount" msprop:SQLTableAlias="o" msprop:SqlDbType="Money" minOccurs="0" />
             <xs:element name="PaymentDeclined" msprop:maxLength="1" msprop:SQLTableAlias="o" msprop:SqlDbType="VarChar"
minOccurs="0" />
             <xs:element name="PaymentMethodID" msprop:SQLTableAlias="o" msprop:SqlDbType="Int" minOccurs="1" />
             <xs:element name="PONum" msprop:maxLength="20" msprop:SQLTableAlias="o" msprop:SqlDbType="VarChar" minOccurs="0" />
             <xs:element name="Printed" msprop:maxLength="1" msprop:SQLTableAlias="o" msprop:SqlDbType="VarChar" minOccurs="0" />
             <xs:element name="Processed_AutoEvents" msprop:maxLength="1" msprop:SQLTableAlias="o" msprop:SqlDbType="VarChar"
minOccurs="0" />
             <xs:element name="RoutingNumber" msprop:maxLength="64" msprop:SQLTableAlias="o" msprop:SqlDbType="VarChar"
minOccurs="0" />
             <xs:element name="SalesRep_CustomerID" msprop:SQLTableAlias="o" msprop:SqlDbType="Int" minOccurs="0" />
             <xs:element name="SalesTax1" msprop:SQLTableAlias="o" msprop:SqlDbType="Money" minOccurs="0" />
             <xs:element name="SalesTax2" msprop:SQLTableAlias="o" msprop:SqlDbType="Money" minOccurs="0" />
             <xs:element name="SalesTax3" msprop:SQLTableAlias="o" msprop:SqlDbType="Money" minOccurs="0" />
             <xs:element name="SalesTaxRate" msprop:SQLTableAlias="o" msprop:SqlDbType="Float" minOccurs="0" />
             <xs:element name="SalesTaxRate1" msprop:SQLTableAlias="o" msprop:SqlDbType="Float" minOccurs="0" />
             <xs:element name="SalesTaxRate2" msprop:SQLTableAlias="o" msprop:SqlDbType="Float" minOccurs="0" />
             <xs:element name="SalesTaxRate3" msprop:SQLTableAlias="o" msprop:SqlDbType="Float" minOccurs="0" />
             <xs:element name="ShipAddress1" msprop:maxLength="75" msprop:SQLTableAlias="o" msprop:SqlDbType="VarChar"
minOccurs="0" />
             <xs:element name="ShipAddress2" msprop:maxLength="75" msprop:SQLTableAlias="o" msprop:SqlDbType="VarChar"
minOccurs="0" />
             <xs:element name="ShipCity" msprop:maxLength="45" msprop:SQLTableAlias="o" msprop:SqlDbType="VarChar" minOccurs="0" />
             <xs:element name="ShipCompanyName" msprop:maxLength="50" msprop:SQLTableAlias="o" msprop:SqlDbType="VarChar"
minOccurs="0" />
             <xs:element name="ShipCountry" msprop:maxLength="30" msprop:SQLTableAlias="o" msprop:SqlDbType="VarChar"
minOccurs="0" />
             <xs:element name="ShipDate" msprop:SQLTableAlias="o" msprop:SqlDbType="SmallDateTime" minOccurs="0" />
             <xs:element name="ShipFaxNumber" msprop:maxLength="30" msprop:SQLTableAlias="o" msprop:SqlDbType="VarChar"
minOccurs="0" />
             <xs:element name="ShipFirstName" msprop:maxLength="30" msprop:SQLTableAlias="o" msprop:SqlDbType="VarChar"
minOccurs="0" />
             <xs:element name="ShipLastName" msprop:maxLength="40" msprop:SQLTableAlias="o" msprop:SqlDbType="VarChar"
minOccurs="0" />
             <xs:element name="Shipped" msprop:maxLength="1" msprop:SQLTableAlias="o" msprop:SqlDbType="VarChar" minOccurs="0" />
             <xs:element name="ShipPhoneNumber" msprop:maxLength="35" msprop:SQLTableAlias="o" msprop:SqlDbType="VarChar"
minOccurs="0" />
             <xs:element name="Shipping_Locked" msprop:maxLength="1" msprop:SQLTableAlias="o" msprop:SqlDbType="VarChar"
minOccurs="0" />
             <xs:element name="ShippingMethodID" msprop:SQLTableAlias="o" msprop:SqlDbType="Int" minOccurs="1" />
             <xs:element name="ShipPostalCode" msprop:maxLength="15" msprop:SQLTableAlias="o" msprop:SqlDbType="VarChar"
minOccurs="0" />
             <xs:element name="ShipResidential" msprop:maxLength="1" msprop:SQLTableAlias="o" msprop:SqlDbType="VarChar"
minOccurs="0" />
             <xs:element name="ShipState" msprop:maxLength="30" msprop:SQLTableAlias="o" msprop:SqlDbType="VarChar" minOccurs="0" />
             <xs:element name="Stock_Priority" msprop:SQLTableAlias="o" msprop:SqlDbType="SmallInt" minOccurs="0" />
             <xs:element name="Tax1_Title" msprop:maxLength="25" msprop:SQLTableAlias="o" msprop:SqlDbType="VarChar" minOccurs="0" />
             <xs:element name="Tax2_Title" msprop:maxLength="25" msprop:SQLTableAlias="o" msprop:SqlDbType="VarChar" minOccurs="0" />
             <xs:element name="Tax3_Title" msprop:maxLength="25" msprop:SQLTableAlias="o" msprop:SqlDbType="VarChar" minOccurs="0" />
             <xs:element name="Total_Payment_Authorized" msprop:SQLTableAlias="o" msprop:SqlDbType="Money" minOccurs="0" />
             <xs:element name="Total_Payment_Received" msprop:SQLTableAlias="o" msprop:SqlDbType="Money" minOccurs="0" />
             <xs:element name="TotalShippingCost" msprop:SQLTableAlias="o" msprop:SqlDbType="Money" minOccurs="0" />
             <xs:element name="VendorID" msprop:SQLTableAlias="o" msprop:SqlDbType="Int" minOccurs="0" />
             <xs:element name="OrderDetails" minOccurs="0" maxOccurs="unbounded">
               <xs:annotation>
                 <xs:appinfo>
                   <msdata:Relationship name="Orders_OrderDetails" msdata:parent="Orders" msdata:child="OrderDetails"
msdata:parentkey="OrderID" msdata:childkey="OrderID" />
                 </xs:appinfo>
               </xs:annotation>
               <xs:complexType>
                 <xs:sequence>
                 <xs:element name="OrderDetailID" msprop:IsIdentity="true" minOccurs="0" msprop:TableNameXsd="OrderDetails" 
msprop:SQLTableAlias="od" msprop:SQLFrom="FROM vMerchant.OrderDetails od INNER JOIN vMerchant.Orders o ON od.OrderID = o.OrderID"
msprop:SqlDbType="Int" msprop:LogTableColumnName="od.OrderID" />
                 <xs:element name="Affiliate_Commissionable_Value" msprop:SQLTableAlias="od" msprop:SqlDbType="Money"
minOccurs="0" />
                 <xs:element name="AutoDropShip" msprop:maxLength="1" msprop:SQLTableAlias="od" msprop:SqlDbType="VarChar"
minOccurs="0" />
                 <xs:element name="CategoryID" msprop:SQLTableAlias="od" msprop:SqlDbType="Int" minOccurs="0" />
                 <xs:element name="CouponCode" msprop:maxLength="10" msprop:SQLTableAlias="od" msprop:SqlDbType="VarChar"
minOccurs="0" />
                 <xs:element name="CustomLineItem" msprop:maxLength="1" msprop:SQLTableAlias="od" msprop:SqlDbType="VarChar"
minOccurs="0" />
                 <xs:element name="DiscountAutoID" msprop:SQLTableAlias="od" msprop:SqlDbType="Int" minOccurs="0" />
                 <xs:element name="DownloadFile" msprop:maxLength="100" msprop:SQLTableAlias="od" msprop:SqlDbType="VarChar"
minOccurs="0" />
                 <xs:element name="Fixed_ShippingCost" msprop:SQLTableAlias="od" msprop:SqlDbType="Money" minOccurs="0" />
                 <xs:element name="Fixed_ShippingCost_Outside_LocalRegion" msprop:SQLTableAlias="od" msprop:SqlDbType="Money"
minOccurs="0" />
                 <xs:element name="FreeShippingItem" msprop:maxLength="1" msprop:SQLTableAlias="od" msprop:SqlDbType="VarChar"
minOccurs="0" />
                 <xs:element name="GiftTrakNumber" msprop:SQLTableAlias="od" msprop:SqlDbType="Int" minOccurs="0" />
                 <xs:element name="GiftWrap" msprop:maxLength="1" msprop:SQLTableAlias="od" msprop:SqlDbType="VarChar"
minOccurs="0" />
                 <xs:element name="GiftWrapCost" msprop:SQLTableAlias="od" msprop:SqlDbType="Money" minOccurs="0" />
                 <xs:element name="GiftWrapNote" msprop:maxLength="255" msprop:SQLTableAlias="od" msprop:SqlDbType="VarChar"
minOccurs="0" />
                 <xs:element name="IsKitID" msprop:maxLength="15" msprop:SQLTableAlias="od" msprop:SqlDbType="VarChar"
minOccurs="0" />
                 <xs:element name="KitID" msprop:maxLength="15" msprop:SQLTableAlias="od" msprop:SqlDbType="VarChar"
minOccurs="0" />
                 <xs:element name="LastModBy" msprop:SQLTableAlias="od" msprop:SqlDbType="Int" minOccurs="0" />
                 <xs:element name="LastModified" msprop:SQLTableAlias="od" msprop:SqlDbType="SmallDateTime" minOccurs="0" />
                 <xs:element name="Locked" msprop:maxLength="1" msprop:SQLTableAlias="od" msprop:SqlDbType="VarChar"
minOccurs="0" />
                 <xs:element name="OnOrder_Qty" msprop:SQLTableAlias="od" msprop:SqlDbType="Int" minOccurs="0" />
                 <xs:element name="OptionID" msprop:SQLTableAlias="od" msprop:SqlDbType="Int" minOccurs="0" />
                 <xs:element name="OptionIDs" msprop:maxLength="255" msprop:SQLTableAlias="od" msprop:SqlDbType="VarChar"
minOccurs="0" />
                 <xs:element name="Options" msprop:SQLTableAlias="od" msprop:SqlDbType="Text" minOccurs="0" />
                 <xs:element name="OrderDetailID_EDI" msprop:maxLength="20" msprop:SQLTableAlias="od" msprop:SqlDbType="VarChar"
minOccurs="0" />
                 <xs:element name="OrderID" msprop:SQLTableAlias="od" msprop:SqlDbType="Int" minOccurs="1" />
                 <xs:element name="Product_Keys_Shipped" msprop:maxLength="1" msprop:SQLTableAlias="od" msprop:SqlDbType="VarChar"
minOccurs="0" />
                 <xs:element name="ProductCode" msprop:maxLength="30" msprop:SQLTableAlias="od" msprop:SqlDbType="VarChar"
minOccurs="1" />
                 <xs:element name="ProductID" msprop:SQLTableAlias="od" msprop:SqlDbType="Int" minOccurs="1" />
                 <xs:element name="ProductName" msprop:maxLength="512" msprop:SQLTableAlias="od" msprop:SqlDbType="VarChar"
minOccurs="0" />
                 <xs:element name="ProductNote" msprop:maxLength="150" msprop:SQLTableAlias="od" msprop:SqlDbType="VarChar"
minOccurs="0" />
                 <xs:element name="ProductPrice" msprop:SQLTableAlias="od" msprop:SqlDbType="Money" minOccurs="0" />
                 <xs:element name="ProductWeight" msprop:SQLTableAlias="od" msprop:SqlDbType="Float" minOccurs="0" />
                 <xs:element name="QtyOnBackOrder" msprop:SQLTableAlias="od" msprop:SqlDbType="Int" minOccurs="0" />
                 <xs:element name="QtyOnHold" msprop:SQLTableAlias="od" msprop:SqlDbType="Int" minOccurs="0" />
                 <xs:element name="QtyOnPackingSlip" msprop:SQLTableAlias="od" msprop:SqlDbType="Int" minOccurs="0" />
                 <xs:element name="QtyShipped" msprop:SQLTableAlias="od" msprop:SqlDbType="Int" minOccurs="0" />
                 <xs:element name="Quantity" msprop:SQLTableAlias="od" msprop:SqlDbType="Int" minOccurs="0" />
                 <xs:element name="Returned" msprop:maxLength="1" msprop:SQLTableAlias="od" msprop:SqlDbType="VarChar"
minOccurs="0" />
                 <xs:element name="Returned_Date" msprop:SQLTableAlias="od" msprop:SqlDbType="SmallDateTime" minOccurs="0" />
                 <xs:element name="RMA_Number" msprop:SQLTableAlias="od" msprop:SqlDbType="Int" minOccurs="0" />
                 <xs:element name="RMAI_ID" msprop:SQLTableAlias="od" msprop:SqlDbType="Int" minOccurs="0" />
                 <xs:element name="ShipDate" msprop:SQLTableAlias="od" msprop:SqlDbType="SmallDateTime" minOccurs="0" />
                 <xs:element name="Shipped" msprop:maxLength="1" msprop:SQLTableAlias="od" msprop:SqlDbType="VarChar"
minOccurs="0" />
                 <xs:element name="TaxableProduct" msprop:maxLength="1" msprop:SQLTableAlias="od" msprop:SqlDbType="VarChar"
minOccurs="0" />
                 <xs:element name="TotalPrice" msprop:SQLTableAlias="od" msprop:SqlDbType="Money" minOccurs="0" />
                 <xs:element name="Vendor_Price" msprop:SQLTableAlias="od" msprop:SqlDbType="Money" minOccurs="0" />
                 <xs:element name="Warehouses" msprop:maxLength="255" msprop:SQLTableAlias="od" msprop:SqlDbType="VarChar"
minOccurs="0" />
                   <xs:element name="OrderDetails_Options" minOccurs="0" maxOccurs="unbounded">
                     <xs:annotation>
                       <xs:appinfo>
                         <msdata:Relationship name="OrderDetails_OrderDetails_Options" msdata:parent="OrderDetails"
msdata:child="OrderDetails_Options" msdata:parentkey="OrderDetailID" msdata:childkey="OrderDetailID" />
                       </xs:appinfo>
                     </xs:annotation>
                     <xs:complexType>
                       <xs:sequence>
                      <xs:element msprop:TableNameXsd="OrderDetails_Options" name="OptionID" msprop:LogTableColumnName="od.OrderID"
msprop:SQLTableAlias="odo" msprop:SqlDbType="Int" msprop:SQLFrom="FROM vMerchant.OrderDetails od INNER JOIN
vMerchant.OrderDetails_Options odo ON od.OrderDetailID = odo.OrderDetailID INNER JOIN vMerchant.Orders o ON od.OrderID = o.OrderID"
minOccurs="1" />
                     <xs:element name="OrderDetailID" msprop:SQLTableAlias="odo" msprop:SqlDbType="Int" minOccurs="1" />
                       </xs:sequence>
                     </xs:complexType>
                   </xs:element>
                 </xs:sequence>
               </xs:complexType>
             </xs:element>
           </xs:sequence>
         </xs:complexType>
       </xs:element>
     </xs:choice>
   </xs:complexType>
 </xs:element>
</xs:schema>

<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="xmldata" xmlns="" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata"
xmlns:msprop="urn:schemas-microsoft-com:xml-msprop">
<xs:element name="xmldata" msdata:IsDataSet="true" msdata:UseCurrentLocale="true">
 <xs:complexType>
    <xs:choice minOccurs="0" maxOccurs="unbounded">
      <xs:element name="OrderDetails">
        <xs:complexType>
          <xs:sequence>
              <xs:element msprop:TableNameXsd="OrderDetails" name="OrderDetailID" sprop:LogTableColumnName="od.OrderID"
msprop:SqlDbType="Int" msprop:IsIdentity="true" minOccurs="0" msprop:SQLFrom="FROM vMerchant.OrderDetails od" />
             <xs:element name="Affiliate_Commissionable_Value" msprop:SqlDbType="Money" minOccurs="0" />
             <xs:element name="AutoDropShip" msprop:maxLength="1" msprop:SqlDbType="VarChar" minOccurs="0" />
             <xs:element name="CategoryID" msprop:SqlDbType="Int" minOccurs="0" />
             <xs:element name="CouponCode" msprop:maxLength="10" msprop:SqlDbType="VarChar" minOccurs="0" />
             <xs:element name="CustomLineItem" msprop:maxLength="1" msprop:SqlDbType="VarChar" minOccurs="0" />
             <xs:element name="DiscountAutoID" msprop:SqlDbType="Int" minOccurs="0" />
             <xs:element name="DownloadFile" msprop:maxLength="100" msprop:SqlDbType="VarChar" minOccurs="0" />
             <xs:element name="Fixed_ShippingCost" msprop:SqlDbType="Money" minOccurs="0" />
             <xs:element name="Fixed_ShippingCost_Outside_LocalRegion" msprop:SqlDbType="Money" minOccurs="0" />
             <xs:element name="FreeShippingItem" msprop:maxLength="1" msprop:SqlDbType="VarChar" minOccurs="0" />
             <xs:element name="GiftTrakNumber" msprop:SqlDbType="Int" minOccurs="0" />
             <xs:element name="GiftWrap" msprop:maxLength="1" msprop:SqlDbType="VarChar" minOccurs="0" />
             <xs:element name="GiftWrapCost" msprop:SqlDbType="Money" minOccurs="0" />
             <xs:element name="GiftWrapNote" msprop:maxLength="255" msprop:SqlDbType="VarChar" minOccurs="0" />
             <xs:element name="IsKitID" msprop:maxLength="15" msprop:SqlDbType="VarChar" minOccurs="0" />
             <xs:element name="KitID" msprop:maxLength="15" msprop:SqlDbType="VarChar" minOccurs="0" />
             <xs:element name="LastModBy" msprop:SqlDbType="Int" minOccurs="0" />
             <xs:element name="LastModified" msprop:SqlDbType="SmallDateTime" minOccurs="0" />
             <xs:element name="Locked" msprop:maxLength="1" msprop:SqlDbType="VarChar" minOccurs="0" />
             <xs:element name="OnOrder_Qty" msprop:SqlDbType="Int" minOccurs="0" />
             <xs:element name="OptionID" msprop:SqlDbType="Int" minOccurs="0" />
             <xs:element name="OptionIDs" msprop:maxLength="255" msprop:SqlDbType="VarChar" minOccurs="0" />
             <xs:element name="Options" msprop:SqlDbType="Text" minOccurs="0" />
             <xs:element name="OrderDetailID_EDI" msprop:maxLength="20" msprop:SqlDbType="VarChar" minOccurs="0" />
             <xs:element name="OrderID" msprop:SqlDbType="Int" minOccurs="0" />
             <xs:element name="Product_Keys_Shipped" msprop:maxLength="1" msprop:SqlDbType="VarChar" minOccurs="0" />
             <xs:element name="ProductCode" msprop:maxLength="30" msprop:SqlDbType="VarChar" minOccurs="1" />
             <xs:element name="ProductID" msprop:SqlDbType="Int" minOccurs="0" />
             <xs:element name="ProductName" msprop:maxLength="2000" msprop:SqlDbType="VarChar" minOccurs="0" />
             <xs:element name="ProductNote" msprop:maxLength="150" msprop:SqlDbType="VarChar" minOccurs="0" />
             <xs:element name="ProductPrice" msprop:SqlDbType="Money" minOccurs="0" />
             <xs:element name="ProductWeight" msprop:SqlDbType="Float" minOccurs="0" />
             <xs:element name="QtyOnBackOrder" msprop:SqlDbType="Int" minOccurs="0" />
             <xs:element name="QtyOnHold" msprop:SqlDbType="Int" minOccurs="0" />
             <xs:element name="QtyOnPackingSlip" msprop:SqlDbType="Int" minOccurs="0" />
             <xs:element name="QtyShipped" msprop:SqlDbType="Int" minOccurs="0" />
             <xs:element name="Quantity" msprop:SqlDbType="Int" minOccurs="0" />
             <xs:element name="Returned" msprop:maxLength="1" msprop:SqlDbType="VarChar" minOccurs="0" />
             <xs:element name="Returned_Date" msprop:SqlDbType="SmallDateTime" minOccurs="0" />
             <xs:element name="RMA_Number" msprop:SqlDbType="Int" minOccurs="0" />
             <xs:element name="RMAI_ID" msprop:SqlDbType="Int" minOccurs="0" />
             <xs:element name="ShipDate" msprop:SqlDbType="SmallDateTime" minOccurs="0" />
             <xs:element name="Shipped" msprop:maxLength="1" msprop:SqlDbType="VarChar" minOccurs="0" />
             <xs:element name="TaxableProduct" msprop:maxLength="1" msprop:SqlDbType="VarChar" minOccurs="0" />
             <xs:element name="TotalPrice" msprop:SqlDbType="Money" minOccurs="0" />
             <xs:element name="Vendor_Price" msprop:SqlDbType="Money" minOccurs="0" />
             <xs:element name="Warehouses" msprop:maxLength="255" msprop:SqlDbType="VarChar" minOccurs="0" />
          </xs:sequence>
        </xs:complexType>
      </xs:element>
    </xs:choice>
    </xs:complexType>
 </xs:element>
</xs:schema>

Sample Code

Retrieved from "http://devwiki.volusion.com/index.php/Orders_-_OrderDetails"
Navigation