<?xml version="1.0" ?>
<Schema xmlns="urn:schemas-microsoft-com:xml-data" 
        xmlns:dt="urn:schemas-microsoft-com:xml:datatypes"  
        xmlns:sql="urn:schemas-microsoft-com:xml-sql" > 

   <ElementType name="EDIFACT_D96A_INVRPT" sql:is-constant="1">
     <element type="UNB" />
     <element type="LIN" />
     <element type="QTY" />
   </ElementType>

   <ElementType name="UNB"  sql:relation="AA_InventoryOnHand" >
      <AttributeType name="UNB040_0017_dateOfPreparation" dt:type="string" />
      <attribute type="UNB040_0017_dateOfPreparation" sql:field="InventoryDate" />
   </ElementType>


   <ElementType name="LIN"  sql:relation="AA_InventoryOnHand" >
      <AttributeType name="LIN030_7140_itemNumber" dt:type="string" />
      <attribute type="LIN030_7140_itemNumber" sql:field="Barcode" />
   </ElementType>

   <ElementType name="QTY"  sql:relation="AA_InventoryOnHand" >
      <AttributeType name="QTY010_6060_quantity" dt:type="float" />
      <attribute type="QTY010_6060_quantity" sql:field="Quantity" />
   </ElementType>

</Schema>
	