FutureDBA-
asked on
select xml data as column
I have a file
/home/oracle/output.xml
i inserted file data into table using
I can select the xml in the table with
Now i want to select the xml as columns.
Can someone poing me in the right direction?
This is the accompanying XSD for the xml data which i also have created in XML Schemas
/home/oracle/output.xml
i inserted file data into table using
INSERT INTO xml_table VALUES (XMLType(bfilename('XMLDIR', 'output.xml'), nls_charset_id('AL32UTF8')));
INSERT INTO table_with_xml_column (filename, xml_document)
VALUES ('output.xml',
XMLType(bfilename('XMLDIR', 'output.xml'),
nls_charset_id('AL32UTF8')));
commit;
I can select the xml in the table with
SELECT x.OBJECT_VALUE.getCLOBVal() FROM xml_table x;
Now i want to select the xml as columns.
Can someone poing me in the right direction?
This is the accompanying XSD for the xml data which i also have created in XML Schemas
<?xml version="1.0" encoding="WINDOWS-1252"?>
<!-- Created with Liquid XML 2013 Designer Edition (Trial) 11.1.0.4725 (http://www.liquid-technologies.com) -->
<xs:schema attributeFormDefault="unqualified" elementFormDefault="qualified" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:oraxdb="http://xmlns.oracle.com/xdb" oraxdb:storeVarrayAsTable="true" oraxdb:flags="2105639" oraxdb:schemaURL="XML_SCHEMA" oraxdb:schemaOwner="REPERMS" oraxdb:numProps="330">
<xs:element name="response" oraxdb:propNumber="4289" oraxdb:global="true" oraxdb:SQLName="response" oraxdb:SQLType="response621_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:defaultTable="response729_TAB" oraxdb:defaultTableSchema="REPERMS">
<xs:complexType oraxdb:SQLType="response621_T" oraxdb:SQLSchema="REPERMS">
<xs:sequence>
<xs:element minOccurs="0" name="objects" oraxdb:propNumber="4277" oraxdb:global="false" oraxdb:SQLName="objects" oraxdb:SQLType="objects622_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
<xs:complexType oraxdb:SQLType="objects622_T" oraxdb:SQLSchema="REPERMS">
<xs:sequence>
<xs:element minOccurs="0" maxOccurs="unbounded" name="object" oraxdb:propNumber="4276" oraxdb:global="false" oraxdb:SQLName="object" oraxdb:SQLType="object623_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false" oraxdb:SQLCollType="object723_COLL" oraxdb:SQLCollSchema="REPERMS">
<xs:complexType oraxdb:SQLType="object623_T" oraxdb:SQLSchema="REPERMS">
<xs:sequence>
<xs:element minOccurs="0" name="otherVersions" oraxdb:propNumber="3963" oraxdb:global="false" oraxdb:SQLName="otherVersions" oraxdb:SQLType="otherVersions624_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
<xs:complexType oraxdb:SQLType="otherVersions624_T" oraxdb:SQLSchema="REPERMS">
<xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="3962" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
</xs:complexType>
</xs:element>
<xs:element minOccurs="0" name="percentDiscount" oraxdb:propNumber="3965" oraxdb:global="false" oraxdb:SQLName="percentDiscount" oraxdb:SQLType="percentDiscount625_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
<xs:complexType oraxdb:SQLType="percentDiscount625_T" oraxdb:SQLSchema="REPERMS">
<xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="3964" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
</xs:complexType>
</xs:element>
<xs:element minOccurs="0" name="entityType" type="xs:string" oraxdb:propNumber="3966" oraxdb:global="false" oraxdb:SQLName="entityType" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
<xs:element minOccurs="0" name="ownerName" type="xs:string" oraxdb:propNumber="3967" oraxdb:global="false" oraxdb:SQLName="ownerName" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
<xs:element minOccurs="0" name="mtime" type="xs:dateTime" oraxdb:propNumber="3968" oraxdb:global="false" oraxdb:SQLName="mtime" oraxdb:SQLType="TIMESTAMP" oraxdb:memType="180" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
<xs:element minOccurs="0" name="owner" type="xs:string" oraxdb:propNumber="3969" oraxdb:global="false" oraxdb:SQLName="owner" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
<xs:element minOccurs="0" name="shippingMethod" type="xs:string" oraxdb:propNumber="3970" oraxdb:global="false" oraxdb:SQLName="shippingMethod" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
<xs:element minOccurs="0" name="id" type="xs:string" oraxdb:propNumber="3971" oraxdb:global="false" oraxdb:SQLName="id" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
<xs:element minOccurs="0" name="category" type="xs:string" oraxdb:propNumber="3972" oraxdb:global="false" oraxdb:SQLName="category" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
<xs:element minOccurs="0" name="billTo" oraxdb:propNumber="4010" oraxdb:global="false" oraxdb:SQLName="billTo" oraxdb:SQLType="billTo626_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
<xs:complexType oraxdb:SQLType="billTo626_T" oraxdb:SQLSchema="REPERMS">
<xs:sequence>
<xs:element minOccurs="0" name="btCustomer" type="xs:string" oraxdb:propNumber="3974" oraxdb:global="false" oraxdb:SQLName="btCustomer" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
<xs:element minOccurs="0" name="entityType" type="xs:string" oraxdb:propNumber="3975" oraxdb:global="false" oraxdb:SQLName="entityType" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
<xs:element minOccurs="0" name="street" oraxdb:propNumber="3977" oraxdb:global="false" oraxdb:SQLName="street" oraxdb:SQLType="street627_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
<xs:complexType oraxdb:SQLType="street627_T" oraxdb:SQLSchema="REPERMS">
<xs:simpleContent>
<xs:extension base="xs:string">
<xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="3976" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
</xs:extension>
</xs:simpleContent>
</xs:complexType>
</xs:element>
<xs:element minOccurs="0" name="postcode" oraxdb:propNumber="3979" oraxdb:global="false" oraxdb:SQLName="postcode" oraxdb:SQLType="postcode628_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
<xs:complexType oraxdb:SQLType="postcode628_T" oraxdb:SQLSchema="REPERMS">
<xs:simpleContent>
<xs:extension base="xs:string">
<xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="3978" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
</xs:extension>
</xs:simpleContent>
</xs:complexType>
</xs:element>
<xs:element minOccurs="0" name="mtime" type="xs:dateTime" oraxdb:propNumber="3980" oraxdb:global="false" oraxdb:SQLName="mtime" oraxdb:SQLType="TIMESTAMP" oraxdb:memType="180" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
<xs:element minOccurs="0" name="owner" type="xs:string" oraxdb:propNumber="3981" oraxdb:global="false" oraxdb:SQLName="owner" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
<xs:element minOccurs="0" name="id" oraxdb:propNumber="3983" oraxdb:global="false" oraxdb:SQLName="id" oraxdb:SQLType="id629_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
<xs:complexType oraxdb:SQLType="id629_T" oraxdb:SQLSchema="REPERMS">
<xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="3982" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
</xs:complexType>
</xs:element>
<xs:element minOccurs="0" name="city" oraxdb:propNumber="3985" oraxdb:global="false" oraxdb:SQLName="city" oraxdb:SQLType="city630_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
<xs:complexType oraxdb:SQLType="city630_T" oraxdb:SQLSchema="REPERMS">
<xs:simpleContent>
<xs:extension base="xs:string">
<xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="3984" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
</xs:extension>
</xs:simpleContent>
</xs:complexType>
</xs:element>
<xs:element minOccurs="0" name="uuid" type="xs:string" oraxdb:propNumber="3986" oraxdb:global="false" oraxdb:SQLName="uuid" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
<xs:element minOccurs="0" name="ctimeOnServer" type="xs:dateTime" oraxdb:propNumber="3987" oraxdb:global="false" oraxdb:SQLName="ctimeOnServer" oraxdb:SQLType="TIMESTAMP" oraxdb:memType="180" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
<xs:element minOccurs="0" name="mtimeOnServer" type="xs:dateTime" oraxdb:propNumber="3988" oraxdb:global="false" oraxdb:SQLName="mtimeOnServer" oraxdb:SQLType="TIMESTAMP" oraxdb:memType="180" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
<xs:element minOccurs="0" name="state" oraxdb:propNumber="3990" oraxdb:global="false" oraxdb:SQLName="state" oraxdb:SQLType="state631_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
<xs:complexType oraxdb:SQLType="state631_T" oraxdb:SQLSchema="REPERMS">
<xs:simpleContent>
<xs:extension base="xs:string">
<xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="3989" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
</xs:extension>
</xs:simpleContent>
</xs:complexType>
</xs:element>
<xs:element minOccurs="0" name="fax" oraxdb:propNumber="3992" oraxdb:global="false" oraxdb:SQLName="fax" oraxdb:SQLType="fax632_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
<xs:complexType oraxdb:SQLType="fax632_T" oraxdb:SQLSchema="REPERMS">
<xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="3991" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
</xs:complexType>
</xs:element>
<xs:element minOccurs="0" name="isDefaultShipTo" oraxdb:propNumber="3994" oraxdb:global="false" oraxdb:SQLName="isDefaultShipTo" oraxdb:SQLType="isDefaultShipTo633_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
<xs:complexType oraxdb:SQLType="isDefaultShipTo633_T" oraxdb:SQLSchema="REPERMS">
<xs:simpleContent>
<xs:extension base="xs:string">
<xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="3993" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
</xs:extension>
</xs:simpleContent>
</xs:complexType>
</xs:element>
<xs:element minOccurs="0" name="street2" oraxdb:propNumber="3996" oraxdb:global="false" oraxdb:SQLName="street2" oraxdb:SQLType="street2634_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
<xs:complexType oraxdb:SQLType="street2634_T" oraxdb:SQLSchema="REPERMS">
<xs:simpleContent>
<xs:extension base="xs:string">
<xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="3995" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
</xs:extension>
</xs:simpleContent>
</xs:complexType>
</xs:element>
<xs:element minOccurs="0" name="stCustomer" oraxdb:propNumber="3998" oraxdb:global="false" oraxdb:SQLName="stCustomer" oraxdb:SQLType="stCustomer635_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
<xs:complexType oraxdb:SQLType="stCustomer635_T" oraxdb:SQLSchema="REPERMS">
<xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="3997" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
</xs:complexType>
</xs:element>
<xs:element minOccurs="0" name="phone" oraxdb:propNumber="4000" oraxdb:global="false" oraxdb:SQLName="phone" oraxdb:SQLType="phone636_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
<xs:complexType oraxdb:SQLType="phone636_T" oraxdb:SQLSchema="REPERMS">
<xs:simpleContent>
<xs:extension base="xs:string">
<xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="3999" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
</xs:extension>
</xs:simpleContent>
</xs:complexType>
</xs:element>
<xs:element minOccurs="0" name="cdate" type="xs:date" oraxdb:propNumber="4001" oraxdb:global="false" oraxdb:SQLName="cdate" oraxdb:SQLType="DATE" oraxdb:memType="12" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
<xs:element minOccurs="0" name="ctime" type="xs:dateTime" oraxdb:propNumber="4002" oraxdb:global="false" oraxdb:SQLName="ctime" oraxdb:SQLType="TIMESTAMP" oraxdb:memType="180" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
<xs:element minOccurs="0" name="name" oraxdb:propNumber="4004" oraxdb:global="false" oraxdb:SQLName="name" oraxdb:SQLType="name637_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
<xs:complexType oraxdb:SQLType="name637_T" oraxdb:SQLSchema="REPERMS">
<xs:simpleContent>
<xs:extension base="xs:string">
<xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4003" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
</xs:extension>
</xs:simpleContent>
</xs:complexType>
</xs:element>
<xs:element minOccurs="0" name="country" oraxdb:propNumber="4006" oraxdb:global="false" oraxdb:SQLName="country" oraxdb:SQLType="country638_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
<xs:complexType oraxdb:SQLType="country638_T" oraxdb:SQLSchema="REPERMS">
<xs:simpleContent>
<xs:extension base="xs:string">
<xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4005" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
</xs:extension>
</xs:simpleContent>
</xs:complexType>
</xs:element>
<xs:element minOccurs="0" name="objID" oraxdb:propNumber="4008" oraxdb:global="false" oraxdb:SQLName="objID" oraxdb:SQLType="objID639_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
<xs:complexType oraxdb:SQLType="objID639_T" oraxdb:SQLSchema="REPERMS">
<xs:simpleContent>
<xs:extension base="xs:unsignedInt">
<xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4007" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
</xs:extension>
</xs:simpleContent>
</xs:complexType>
</xs:element>
<xs:element minOccurs="0" name="resource_uri" type="xs:string" oraxdb:propNumber="4009" oraxdb:global="false" oraxdb:SQLName="resource_uri" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
</xs:sequence>
<xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="3973" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
</xs:complexType>
</xs:element>
<xs:element minOccurs="0" name="paymentTerms" type="xs:string" oraxdb:propNumber="4011" oraxdb:global="false" oraxdb:SQLName="paymentTerms" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
<xs:element minOccurs="0" name="uuid" type="xs:string" oraxdb:propNumber="4012" oraxdb:global="false" oraxdb:SQLName="uuid" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
<xs:element minOccurs="0" name="ctimeOnServer" type="xs:dateTime" oraxdb:propNumber="4013" oraxdb:global="false" oraxdb:SQLName="ctimeOnServer" oraxdb:SQLType="TIMESTAMP" oraxdb:memType="180" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
<xs:element minOccurs="0" name="freeShipping" oraxdb:propNumber="4015" oraxdb:global="false" oraxdb:SQLName="freeShipping" oraxdb:SQLType="freeShipping640_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
<xs:complexType oraxdb:SQLType="freeShipping640_T" oraxdb:SQLSchema="REPERMS">
<xs:simpleContent>
<xs:extension base="xs:string">
<xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4014" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
</xs:extension>
</xs:simpleContent>
</xs:complexType>
</xs:element>
<xs:element minOccurs="0" name="startShipDate" oraxdb:propNumber="4017" oraxdb:global="false" oraxdb:SQLName="startShipDate" oraxdb:SQLType="startShipDate641_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
<xs:complexType oraxdb:SQLType="startShipDate641_T" oraxdb:SQLSchema="REPERMS">
<xs:simpleContent>
<xs:extension base="xs:string">
<xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4016" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
</xs:extension>
</xs:simpleContent>
</xs:complexType>
</xs:element>
<xs:element minOccurs="0" name="mtimeOnServer" type="xs:dateTime" oraxdb:propNumber="4018" oraxdb:global="false" oraxdb:SQLName="mtimeOnServer" oraxdb:SQLType="TIMESTAMP" oraxdb:memType="180" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
<xs:element minOccurs="0" name="shipPartial" oraxdb:propNumber="4020" oraxdb:global="false" oraxdb:SQLName="shipPartial" oraxdb:SQLType="shipPartial642_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
<xs:complexType oraxdb:SQLType="shipPartial642_T" oraxdb:SQLSchema="REPERMS">
<xs:simpleContent>
<xs:extension base="xs:string">
<xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4019" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
</xs:extension>
</xs:simpleContent>
</xs:complexType>
</xs:element>
<xs:element minOccurs="0" name="userGroup" type="xs:string" oraxdb:propNumber="4021" oraxdb:global="false" oraxdb:SQLName="userGroup" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
<xs:element minOccurs="0" name="status" type="xs:string" oraxdb:propNumber="4022" oraxdb:global="false" oraxdb:SQLName="status" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
<xs:element minOccurs="0" name="customer" oraxdb:propNumber="4169" oraxdb:global="false" oraxdb:SQLName="customer" oraxdb:SQLType="customer643_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
<xs:complexType oraxdb:SQLType="customer643_T" oraxdb:SQLSchema="REPERMS">
<xs:sequence>
<xs:element minOccurs="0" name="locale" type="xs:string" oraxdb:propNumber="4024" oraxdb:global="false" oraxdb:SQLName="locale" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
<xs:element minOccurs="0" name="percentDiscount" oraxdb:propNumber="4026" oraxdb:global="false" oraxdb:SQLName="percentDiscount" oraxdb:SQLType="percentDiscount644_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
<xs:complexType oraxdb:SQLType="percentDiscount644_T" oraxdb:SQLSchema="REPERMS">
<xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4025" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
</xs:complexType>
</xs:element>
<xs:element minOccurs="0" name="entityType" type="xs:string" oraxdb:propNumber="4027" oraxdb:global="false" oraxdb:SQLName="entityType" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
<xs:element minOccurs="0" name="currency" type="xs:string" oraxdb:propNumber="4028" oraxdb:global="false" oraxdb:SQLName="currency" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
<xs:element minOccurs="0" name="ownerName" type="xs:string" oraxdb:propNumber="4029" oraxdb:global="false" oraxdb:SQLName="ownerName" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
<xs:element minOccurs="0" name="mtime" type="xs:dateTime" oraxdb:propNumber="4030" oraxdb:global="false" oraxdb:SQLName="mtime" oraxdb:SQLType="TIMESTAMP" oraxdb:memType="180" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
<xs:element minOccurs="0" name="owner" type="xs:string" oraxdb:propNumber="4031" oraxdb:global="false" oraxdb:SQLName="owner" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
<xs:element minOccurs="0" name="shippingMethod" type="xs:string" oraxdb:propNumber="4032" oraxdb:global="false" oraxdb:SQLName="shippingMethod" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
<xs:element minOccurs="0" name="id" type="xs:string" oraxdb:propNumber="4033" oraxdb:global="false" oraxdb:SQLName="id" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
<xs:element minOccurs="0" name="billTo" oraxdb:propNumber="4071" oraxdb:global="false" oraxdb:SQLName="billTo" oraxdb:SQLType="billTo645_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
<xs:complexType oraxdb:SQLType="billTo645_T" oraxdb:SQLSchema="REPERMS">
<xs:sequence>
<xs:element minOccurs="0" name="btCustomer" type="xs:string" oraxdb:propNumber="4035" oraxdb:global="false" oraxdb:SQLName="btCustomer" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
<xs:element minOccurs="0" name="entityType" type="xs:string" oraxdb:propNumber="4036" oraxdb:global="false" oraxdb:SQLName="entityType" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
<xs:element minOccurs="0" name="street" oraxdb:propNumber="4038" oraxdb:global="false" oraxdb:SQLName="street" oraxdb:SQLType="street646_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
<xs:complexType oraxdb:SQLType="street646_T" oraxdb:SQLSchema="REPERMS">
<xs:simpleContent>
<xs:extension base="xs:string">
<xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4037" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
</xs:extension>
</xs:simpleContent>
</xs:complexType>
</xs:element>
<xs:element minOccurs="0" name="postcode" oraxdb:propNumber="4040" oraxdb:global="false" oraxdb:SQLName="postcode" oraxdb:SQLType="postcode647_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
<xs:complexType oraxdb:SQLType="postcode647_T" oraxdb:SQLSchema="REPERMS">
<xs:simpleContent>
<xs:extension base="xs:string">
<xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4039" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
</xs:extension>
</xs:simpleContent>
</xs:complexType>
</xs:element>
<xs:element minOccurs="0" name="mtime" type="xs:dateTime" oraxdb:propNumber="4041" oraxdb:global="false" oraxdb:SQLName="mtime" oraxdb:SQLType="TIMESTAMP" oraxdb:memType="180" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
<xs:element minOccurs="0" name="owner" type="xs:string" oraxdb:propNumber="4042" oraxdb:global="false" oraxdb:SQLName="owner" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
<xs:element minOccurs="0" name="id" oraxdb:propNumber="4044" oraxdb:global="false" oraxdb:SQLName="id" oraxdb:SQLType="id648_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
<xs:complexType oraxdb:SQLType="id648_T" oraxdb:SQLSchema="REPERMS">
<xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4043" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
</xs:complexType>
</xs:element>
<xs:element minOccurs="0" name="city" oraxdb:propNumber="4046" oraxdb:global="false" oraxdb:SQLName="city" oraxdb:SQLType="city649_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
<xs:complexType oraxdb:SQLType="city649_T" oraxdb:SQLSchema="REPERMS">
<xs:simpleContent>
<xs:extension base="xs:string">
<xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4045" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
</xs:extension>
</xs:simpleContent>
</xs:complexType>
</xs:element>
<xs:element minOccurs="0" name="uuid" type="xs:string" oraxdb:propNumber="4047" oraxdb:global="false" oraxdb:SQLName="uuid" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
<xs:element minOccurs="0" name="ctimeOnServer" type="xs:dateTime" oraxdb:propNumber="4048" oraxdb:global="false" oraxdb:SQLName="ctimeOnServer" oraxdb:SQLType="TIMESTAMP" oraxdb:memType="180" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
<xs:element minOccurs="0" name="mtimeOnServer" type="xs:dateTime" oraxdb:propNumber="4049" oraxdb:global="false" oraxdb:SQLName="mtimeOnServer" oraxdb:SQLType="TIMESTAMP" oraxdb:memType="180" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
<xs:element minOccurs="0" name="state" oraxdb:propNumber="4051" oraxdb:global="false" oraxdb:SQLName="state" oraxdb:SQLType="state650_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
<xs:complexType oraxdb:SQLType="state650_T" oraxdb:SQLSchema="REPERMS">
<xs:simpleContent>
<xs:extension base="xs:string">
<xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4050" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
</xs:extension>
</xs:simpleContent>
</xs:complexType>
</xs:element>
<xs:element minOccurs="0" name="fax" oraxdb:propNumber="4053" oraxdb:global="false" oraxdb:SQLName="fax" oraxdb:SQLType="fax651_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
<xs:complexType oraxdb:SQLType="fax651_T" oraxdb:SQLSchema="REPERMS">
<xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4052" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
</xs:complexType>
</xs:element>
<xs:element minOccurs="0" name="isDefaultShipTo" oraxdb:propNumber="4055" oraxdb:global="false" oraxdb:SQLName="isDefaultShipTo" oraxdb:SQLType="isDefaultShipTo652_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
<xs:complexType oraxdb:SQLType="isDefaultShipTo652_T" oraxdb:SQLSchema="REPERMS">
<xs:simpleContent>
<xs:extension base="xs:string">
<xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4054" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
</xs:extension>
</xs:simpleContent>
</xs:complexType>
</xs:element>
<xs:element minOccurs="0" name="street2" oraxdb:propNumber="4057" oraxdb:global="false" oraxdb:SQLName="street2" oraxdb:SQLType="street2653_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
<xs:complexType oraxdb:SQLType="street2653_T" oraxdb:SQLSchema="REPERMS">
<xs:simpleContent>
<xs:extension base="xs:string">
<xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4056" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
</xs:extension>
</xs:simpleContent>
</xs:complexType>
</xs:element>
<xs:element minOccurs="0" name="stCustomer" oraxdb:propNumber="4059" oraxdb:global="false" oraxdb:SQLName="stCustomer" oraxdb:SQLType="stCustomer654_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
<xs:complexType oraxdb:SQLType="stCustomer654_T" oraxdb:SQLSchema="REPERMS">
<xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4058" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
</xs:complexType>
</xs:element>
<xs:element minOccurs="0" name="phone" oraxdb:propNumber="4061" oraxdb:global="false" oraxdb:SQLName="phone" oraxdb:SQLType="phone655_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
<xs:complexType oraxdb:SQLType="phone655_T" oraxdb:SQLSchema="REPERMS">
<xs:simpleContent>
<xs:extension base="xs:string">
<xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4060" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
</xs:extension>
</xs:simpleContent>
</xs:complexType>
</xs:element>
<xs:element minOccurs="0" name="cdate" type="xs:date" oraxdb:propNumber="4062" oraxdb:global="false" oraxdb:SQLName="cdate" oraxdb:SQLType="DATE" oraxdb:memType="12" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
<xs:element minOccurs="0" name="ctime" type="xs:dateTime" oraxdb:propNumber="4063" oraxdb:global="false" oraxdb:SQLName="ctime" oraxdb:SQLType="TIMESTAMP" oraxdb:memType="180" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
<xs:element minOccurs="0" name="name" oraxdb:propNumber="4065" oraxdb:global="false" oraxdb:SQLName="name" oraxdb:SQLType="name656_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
<xs:complexType oraxdb:SQLType="name656_T" oraxdb:SQLSchema="REPERMS">
<xs:simpleContent>
<xs:extension base="xs:string">
<xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4064" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
</xs:extension>
</xs:simpleContent>
</xs:complexType>
</xs:element>
<xs:element minOccurs="0" name="country" oraxdb:propNumber="4067" oraxdb:global="false" oraxdb:SQLName="country" oraxdb:SQLType="country657_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
<xs:complexType oraxdb:SQLType="country657_T" oraxdb:SQLSchema="REPERMS">
<xs:simpleContent>
<xs:extension base="xs:string">
<xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4066" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
</xs:extension>
</xs:simpleContent>
</xs:complexType>
</xs:element>
<xs:element minOccurs="0" name="objID" oraxdb:propNumber="4069" oraxdb:global="false" oraxdb:SQLName="objID" oraxdb:SQLType="objID658_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
<xs:complexType oraxdb:SQLType="objID658_T" oraxdb:SQLSchema="REPERMS">
<xs:simpleContent>
<xs:extension base="xs:unsignedInt">
<xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4068" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
</xs:extension>
</xs:simpleContent>
</xs:complexType>
</xs:element>
<xs:element minOccurs="0" name="resource_uri" type="xs:string" oraxdb:propNumber="4070" oraxdb:global="false" oraxdb:SQLName="resource_uri" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
</xs:sequence>
<xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4034" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
</xs:complexType>
</xs:element>
<xs:element minOccurs="0" name="paymentTerms" type="xs:string" oraxdb:propNumber="4072" oraxdb:global="false" oraxdb:SQLName="paymentTerms" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
<xs:element minOccurs="0" name="customerGroup" oraxdb:propNumber="4090" oraxdb:global="false" oraxdb:SQLName="customerGroup" oraxdb:SQLType="customerGroup659_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
<xs:complexType oraxdb:SQLType="customerGroup659_T" oraxdb:SQLSchema="REPERMS">
<xs:sequence>
<xs:element minOccurs="0" name="uuid" type="xs:string" oraxdb:propNumber="4074" oraxdb:global="false" oraxdb:SQLName="uuid" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
<xs:element minOccurs="0" name="ctimeOnServer" type="xs:dateTime" oraxdb:propNumber="4075" oraxdb:global="false" oraxdb:SQLName="ctimeOnServer" oraxdb:SQLType="TIMESTAMP" oraxdb:memType="180" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
<xs:element minOccurs="0" name="currencyCode" type="xs:string" oraxdb:propNumber="4076" oraxdb:global="false" oraxdb:SQLName="currencyCode" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
<xs:element minOccurs="0" name="entityType" type="xs:string" oraxdb:propNumber="4077" oraxdb:global="false" oraxdb:SQLName="entityType" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
<xs:element minOccurs="0" name="name" type="xs:string" oraxdb:propNumber="4078" oraxdb:global="false" oraxdb:SQLName="name" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
<xs:element minOccurs="0" name="mtimeOnServer" type="xs:dateTime" oraxdb:propNumber="4079" oraxdb:global="false" oraxdb:SQLName="mtimeOnServer" oraxdb:SQLType="TIMESTAMP" oraxdb:memType="180" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
<xs:element minOccurs="0" name="cdate" type="xs:date" oraxdb:propNumber="4080" oraxdb:global="false" oraxdb:SQLName="cdate" oraxdb:SQLType="DATE" oraxdb:memType="12" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
<xs:element minOccurs="0" name="objID" oraxdb:propNumber="4082" oraxdb:global="false" oraxdb:SQLName="objID" oraxdb:SQLType="objID660_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
<xs:complexType oraxdb:SQLType="objID660_T" oraxdb:SQLSchema="REPERMS">
<xs:simpleContent>
<xs:extension base="xs:unsignedShort">
<xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4081" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
</xs:extension>
</xs:simpleContent>
</xs:complexType>
</xs:element>
<xs:element minOccurs="0" name="mtime" type="xs:dateTime" oraxdb:propNumber="4083" oraxdb:global="false" oraxdb:SQLName="mtime" oraxdb:SQLType="TIMESTAMP" oraxdb:memType="180" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
<xs:element minOccurs="0" name="owner" type="xs:string" oraxdb:propNumber="4084" oraxdb:global="false" oraxdb:SQLName="owner" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
<xs:element minOccurs="0" name="resource_uri" type="xs:string" oraxdb:propNumber="4085" oraxdb:global="false" oraxdb:SQLName="resource_uri" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
<xs:element minOccurs="0" name="id" type="xs:unsignedByte" oraxdb:propNumber="4086" oraxdb:global="false" oraxdb:SQLName="id" oraxdb:SQLType="NUMBER" oraxdb:memType="68" oraxdb:memByteLength="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
<xs:element minOccurs="0" name="isDefault" oraxdb:propNumber="4088" oraxdb:global="false" oraxdb:SQLName="isDefault" oraxdb:SQLType="isDefault661_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
<xs:complexType oraxdb:SQLType="isDefault661_T" oraxdb:SQLSchema="REPERMS">
<xs:simpleContent>
<xs:extension base="xs:string">
<xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4087" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
</xs:extension>
</xs:simpleContent>
</xs:complexType>
</xs:element>
<xs:element minOccurs="0" name="ctime" type="xs:dateTime" oraxdb:propNumber="4089" oraxdb:global="false" oraxdb:SQLName="ctime" oraxdb:SQLType="TIMESTAMP" oraxdb:memType="180" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
</xs:sequence>
<xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4073" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
</xs:complexType>
</xs:element>
<xs:element minOccurs="0" name="uuid" type="xs:string" oraxdb:propNumber="4091" oraxdb:global="false" oraxdb:SQLName="uuid" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
<xs:element minOccurs="0" name="ctimeOnServer" type="xs:dateTime" oraxdb:propNumber="4092" oraxdb:global="false" oraxdb:SQLName="ctimeOnServer" oraxdb:SQLType="TIMESTAMP" oraxdb:memType="180" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
<xs:element minOccurs="0" name="taxID" type="xs:string" oraxdb:propNumber="4093" oraxdb:global="false" oraxdb:SQLName="taxID" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
<xs:element minOccurs="0" name="mtimeOnServer" type="xs:dateTime" oraxdb:propNumber="4094" oraxdb:global="false" oraxdb:SQLName="mtimeOnServer" oraxdb:SQLType="TIMESTAMP" oraxdb:memType="180" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
<xs:element minOccurs="0" name="userGroup" oraxdb:propNumber="4114" oraxdb:global="false" oraxdb:SQLName="userGroup" oraxdb:SQLType="userGroup662_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
<xs:complexType oraxdb:SQLType="userGroup662_T" oraxdb:SQLSchema="REPERMS">
<xs:sequence>
<xs:element minOccurs="0" name="isMaster" oraxdb:propNumber="4097" oraxdb:global="false" oraxdb:SQLName="isMaster" oraxdb:SQLType="isMaster663_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
<xs:complexType oraxdb:SQLType="isMaster663_T" oraxdb:SQLSchema="REPERMS">
<xs:simpleContent>
<xs:extension base="xs:string">
<xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4096" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
</xs:extension>
</xs:simpleContent>
</xs:complexType>
</xs:element>
<xs:element minOccurs="0" name="subcategories" oraxdb:propNumber="4099" oraxdb:global="false" oraxdb:SQLName="subcategories" oraxdb:SQLType="subcategories664_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
<xs:complexType oraxdb:SQLType="subcategories664_T" oraxdb:SQLSchema="REPERMS">
<xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4098" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
</xs:complexType>
</xs:element>
<xs:element minOccurs="0" name="ctime" type="xs:dateTime" oraxdb:propNumber="4100" oraxdb:global="false" oraxdb:SQLName="ctime" oraxdb:SQLType="TIMESTAMP" oraxdb:memType="180" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
<xs:element minOccurs="0" name="parent" type="xs:string" oraxdb:propNumber="4101" oraxdb:global="false" oraxdb:SQLName="parent" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
<xs:element minOccurs="0" name="ctimeOnServer" type="xs:dateTime" oraxdb:propNumber="4102" oraxdb:global="false" oraxdb:SQLName="ctimeOnServer" oraxdb:SQLType="TIMESTAMP" oraxdb:memType="180" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
<xs:element minOccurs="0" name="entityType" type="xs:string" oraxdb:propNumber="4103" oraxdb:global="false" oraxdb:SQLName="entityType" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
<xs:element minOccurs="0" name="name" type="xs:string" oraxdb:propNumber="4104" oraxdb:global="false" oraxdb:SQLName="name" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
<xs:element minOccurs="0" name="mtimeOnServer" type="xs:dateTime" oraxdb:propNumber="4105" oraxdb:global="false" oraxdb:SQLName="mtimeOnServer" oraxdb:SQLType="TIMESTAMP" oraxdb:memType="180" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
<xs:element minOccurs="0" name="cdate" type="xs:date" oraxdb:propNumber="4106" oraxdb:global="false" oraxdb:SQLName="cdate" oraxdb:SQLType="DATE" oraxdb:memType="12" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
<xs:element minOccurs="0" name="objID" oraxdb:propNumber="4108" oraxdb:global="false" oraxdb:SQLName="objID" oraxdb:SQLType="objID665_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
<xs:complexType oraxdb:SQLType="objID665_T" oraxdb:SQLSchema="REPERMS">
<xs:simpleContent>
<xs:extension base="xs:unsignedShort">
<xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4107" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
</xs:extension>
</xs:simpleContent>
</xs:complexType>
</xs:element>
<xs:element minOccurs="0" name="mtime" type="xs:dateTime" oraxdb:propNumber="4109" oraxdb:global="false" oraxdb:SQLName="mtime" oraxdb:SQLType="TIMESTAMP" oraxdb:memType="180" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
<xs:element minOccurs="0" name="owner" type="xs:string" oraxdb:propNumber="4110" oraxdb:global="false" oraxdb:SQLName="owner" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
<xs:element minOccurs="0" name="resource_uri" type="xs:string" oraxdb:propNumber="4111" oraxdb:global="false" oraxdb:SQLName="resource_uri" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
<xs:element minOccurs="0" name="id" type="xs:string" oraxdb:propNumber="4112" oraxdb:global="false" oraxdb:SQLName="id" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
<xs:element minOccurs="0" name="uuid" type="xs:string" oraxdb:propNumber="4113" oraxdb:global="false" oraxdb:SQLName="uuid" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
</xs:sequence>
<xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4095" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
</xs:complexType>
</xs:element>
<xs:element minOccurs="0" name="defaultShipTo" type="xs:string" oraxdb:propNumber="4115" oraxdb:global="false" oraxdb:SQLName="defaultShipTo" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
<xs:element minOccurs="0" name="email" oraxdb:propNumber="4117" oraxdb:global="false" oraxdb:SQLName="email" oraxdb:SQLType="email666_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
<xs:complexType oraxdb:SQLType="email666_T" oraxdb:SQLSchema="REPERMS">
<xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4116" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
</xs:complexType>
</xs:element>
<xs:element minOccurs="0" name="defaultWarehouse" oraxdb:propNumber="4119" oraxdb:global="false" oraxdb:SQLName="defaultWarehouse" oraxdb:SQLType="defaultWarehouse667_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
<xs:complexType oraxdb:SQLType="defaultWarehouse667_T" oraxdb:SQLSchema="REPERMS">
<xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4118" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
</xs:complexType>
</xs:element>
<xs:element minOccurs="0" name="cdate" type="xs:date" oraxdb:propNumber="4120" oraxdb:global="false" oraxdb:SQLName="cdate" oraxdb:SQLType="DATE" oraxdb:memType="12" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
<xs:element minOccurs="0" name="name" type="xs:string" oraxdb:propNumber="4121" oraxdb:global="false" oraxdb:SQLName="name" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
<xs:element minOccurs="0" name="ctime" type="xs:dateTime" oraxdb:propNumber="4122" oraxdb:global="false" oraxdb:SQLName="ctime" oraxdb:SQLType="TIMESTAMP" oraxdb:memType="180" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
<xs:element minOccurs="0" name="contact" oraxdb:propNumber="4124" oraxdb:global="false" oraxdb:SQLName="contact" oraxdb:SQLType="contact668_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
<xs:complexType oraxdb:SQLType="contact668_T" oraxdb:SQLSchema="REPERMS">
<xs:simpleContent>
<xs:extension base="xs:string">
<xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4123" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
</xs:extension>
</xs:simpleContent>
</xs:complexType>
</xs:element>
<xs:element minOccurs="0" name="objID" oraxdb:propNumber="4126" oraxdb:global="false" oraxdb:SQLName="objID" oraxdb:SQLType="objID669_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
<xs:complexType oraxdb:SQLType="objID669_T" oraxdb:SQLSchema="REPERMS">
<xs:simpleContent>
<xs:extension base="xs:unsignedInt">
<xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4125" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
</xs:extension>
</xs:simpleContent>
</xs:complexType>
</xs:element>
<xs:element minOccurs="0" name="creditCards" oraxdb:propNumber="4128" oraxdb:global="false" oraxdb:SQLName="creditCards" oraxdb:SQLType="creditCards670_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
<xs:complexType oraxdb:SQLType="creditCards670_T" oraxdb:SQLSchema="REPERMS">
<xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4127" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
</xs:complexType>
</xs:element>
<xs:element minOccurs="0" name="shipTos" oraxdb:propNumber="4167" oraxdb:global="false" oraxdb:SQLName="shipTos" oraxdb:SQLType="shipTos671_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
<xs:complexType oraxdb:SQLType="shipTos671_T" oraxdb:SQLSchema="REPERMS">
<xs:sequence>
<xs:element minOccurs="0" name="object" oraxdb:propNumber="4166" oraxdb:global="false" oraxdb:SQLName="object" oraxdb:SQLType="object672_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
<xs:complexType oraxdb:SQLType="object672_T" oraxdb:SQLSchema="REPERMS">
<xs:sequence>
<xs:element minOccurs="0" name="btCustomer" oraxdb:propNumber="4132" oraxdb:global="false" oraxdb:SQLName="btCustomer" oraxdb:SQLType="btCustomer673_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
<xs:complexType oraxdb:SQLType="btCustomer673_T" oraxdb:SQLSchema="REPERMS">
<xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4131" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
</xs:complexType>
</xs:element>
<xs:element minOccurs="0" name="entityType" type="xs:string" oraxdb:propNumber="4133" oraxdb:global="false" oraxdb:SQLName="entityType" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
<xs:element minOccurs="0" name="street" type="xs:unsignedByte" oraxdb:propNumber="4134" oraxdb:global="false" oraxdb:SQLName="street" oraxdb:SQLType="NUMBER" oraxdb:memType="68" oraxdb:memByteLength="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
<xs:element minOccurs="0" name="postcode" oraxdb:propNumber="4136" oraxdb:global="false" oraxdb:SQLName="postcode" oraxdb:SQLType="postcode674_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
<xs:complexType oraxdb:SQLType="postcode674_T" oraxdb:SQLSchema="REPERMS">
<xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4135" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
</xs:complexType>
</xs:element>
<xs:element minOccurs="0" name="mtime" type="xs:dateTime" oraxdb:propNumber="4137" oraxdb:global="false" oraxdb:SQLName="mtime" oraxdb:SQLType="TIMESTAMP" oraxdb:memType="180" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
<xs:element minOccurs="0" name="owner" type="xs:string" oraxdb:propNumber="4138" oraxdb:global="false" oraxdb:SQLName="owner" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
<xs:element minOccurs="0" name="id" oraxdb:propNumber="4140" oraxdb:global="false" oraxdb:SQLName="id" oraxdb:SQLType="id675_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
<xs:complexType oraxdb:SQLType="id675_T" oraxdb:SQLSchema="REPERMS">
<xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4139" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
</xs:complexType>
</xs:element>
<xs:element minOccurs="0" name="city" oraxdb:propNumber="4142" oraxdb:global="false" oraxdb:SQLName="city" oraxdb:SQLType="city676_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
<xs:complexType oraxdb:SQLType="city676_T" oraxdb:SQLSchema="REPERMS">
<xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4141" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
</xs:complexType>
</xs:element>
<xs:element minOccurs="0" name="uuid" type="xs:string" oraxdb:propNumber="4143" oraxdb:global="false" oraxdb:SQLName="uuid" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
<xs:element minOccurs="0" name="ctimeOnServer" type="xs:dateTime" oraxdb:propNumber="4144" oraxdb:global="false" oraxdb:SQLName="ctimeOnServer" oraxdb:SQLType="TIMESTAMP" oraxdb:memType="180" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
<xs:element minOccurs="0" name="mtimeOnServer" type="xs:dateTime" oraxdb:propNumber="4145" oraxdb:global="false" oraxdb:SQLName="mtimeOnServer" oraxdb:SQLType="TIMESTAMP" oraxdb:memType="180" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
<xs:element minOccurs="0" name="state" oraxdb:propNumber="4147" oraxdb:global="false" oraxdb:SQLName="state" oraxdb:SQLType="state677_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
<xs:complexType oraxdb:SQLType="state677_T" oraxdb:SQLSchema="REPERMS">
<xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4146" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
</xs:complexType>
</xs:element>
<xs:element minOccurs="0" name="fax" oraxdb:propNumber="4149" oraxdb:global="false" oraxdb:SQLName="fax" oraxdb:SQLType="fax678_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
<xs:complexType oraxdb:SQLType="fax678_T" oraxdb:SQLSchema="REPERMS">
<xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4148" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
</xs:complexType>
</xs:element>
<xs:element minOccurs="0" name="isDefaultShipTo" oraxdb:propNumber="4151" oraxdb:global="false" oraxdb:SQLName="isDefaultShipTo" oraxdb:SQLType="isDefaultShipTo679_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
<xs:complexType oraxdb:SQLType="isDefaultShipTo679_T" oraxdb:SQLSchema="REPERMS">
<xs:simpleContent>
<xs:extension base="xs:string">
<xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4150" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
</xs:extension>
</xs:simpleContent>
</xs:complexType>
</xs:element>
<xs:element minOccurs="0" name="street2" oraxdb:propNumber="4153" oraxdb:global="false" oraxdb:SQLName="street2" oraxdb:SQLType="street2680_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
<xs:complexType oraxdb:SQLType="street2680_T" oraxdb:SQLSchema="REPERMS">
<xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4152" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
</xs:complexType>
</xs:element>
<xs:element minOccurs="0" name="stCustomer" type="xs:string" oraxdb:propNumber="4154" oraxdb:global="false" oraxdb:SQLName="stCustomer" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
<xs:element minOccurs="0" name="phone" oraxdb:propNumber="4156" oraxdb:global="false" oraxdb:SQLName="phone" oraxdb:SQLType="phone681_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
<xs:complexType oraxdb:SQLType="phone681_T" oraxdb:SQLSchema="REPERMS">
<xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4155" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
</xs:complexType>
</xs:element>
<xs:element minOccurs="0" name="cdate" type="xs:date" oraxdb:propNumber="4157" oraxdb:global="false" oraxdb:SQLName="cdate" oraxdb:SQLType="DATE" oraxdb:memType="12" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
<xs:element minOccurs="0" name="ctime" type="xs:dateTime" oraxdb:propNumber="4158" oraxdb:global="false" oraxdb:SQLName="ctime" oraxdb:SQLType="TIMESTAMP" oraxdb:memType="180" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
<xs:element minOccurs="0" name="name" oraxdb:propNumber="4160" oraxdb:global="false" oraxdb:SQLName="name" oraxdb:SQLType="name682_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
<xs:complexType oraxdb:SQLType="name682_T" oraxdb:SQLSchema="REPERMS">
<xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4159" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
</xs:complexType>
</xs:element>
<xs:element minOccurs="0" name="country" oraxdb:propNumber="4162" oraxdb:global="false" oraxdb:SQLName="country" oraxdb:SQLType="country683_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
<xs:complexType oraxdb:SQLType="country683_T" oraxdb:SQLSchema="REPERMS">
<xs:simpleContent>
<xs:extension base="xs:string">
<xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4161" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
</xs:extension>
</xs:simpleContent>
</xs:complexType>
</xs:element>
<xs:element minOccurs="0" name="objID" oraxdb:propNumber="4164" oraxdb:global="false" oraxdb:SQLName="objID" oraxdb:SQLType="objID684_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
<xs:complexType oraxdb:SQLType="objID684_T" oraxdb:SQLSchema="REPERMS">
<xs:simpleContent>
<xs:extension base="xs:unsignedInt">
<xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4163" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
</xs:extension>
</xs:simpleContent>
</xs:complexType>
</xs:element>
<xs:element minOccurs="0" name="resource_uri" type="xs:string" oraxdb:propNumber="4165" oraxdb:global="false" oraxdb:SQLName="resource_uri" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
</xs:sequence>
<xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4130" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
</xs:complexType>
</xs:element>
</xs:sequence>
<xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4129" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
</xs:complexType>
</xs:element>
<xs:element minOccurs="0" name="resource_uri" type="xs:string" oraxdb:propNumber="4168" oraxdb:global="false" oraxdb:SQLName="resource_uri" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
</xs:sequence>
<xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4023" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
</xs:complexType>
</xs:element>
<xs:element minOccurs="0" name="versionInfo" oraxdb:propNumber="4171" oraxdb:global="false" oraxdb:SQLName="versionInfo" oraxdb:SQLType="versionInfo685_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
<xs:complexType oraxdb:SQLType="versionInfo685_T" oraxdb:SQLSchema="REPERMS">
<xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4170" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
</xs:complexType>
</xs:element>
<xs:element minOccurs="0" name="shipTo" oraxdb:propNumber="4209" oraxdb:global="false" oraxdb:SQLName="shipTo" oraxdb:SQLType="shipTo686_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
<xs:complexType oraxdb:SQLType="shipTo686_T" oraxdb:SQLSchema="REPERMS">
<xs:sequence>
<xs:element minOccurs="0" name="btCustomer" oraxdb:propNumber="4174" oraxdb:global="false" oraxdb:SQLName="btCustomer" oraxdb:SQLType="btCustomer687_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
<xs:complexType oraxdb:SQLType="btCustomer687_T" oraxdb:SQLSchema="REPERMS">
<xs:simpleContent>
<xs:extension base="xs:string">
<xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4173" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
</xs:extension>
</xs:simpleContent>
</xs:complexType>
</xs:element>
<xs:element minOccurs="0" name="entityType" type="xs:string" oraxdb:propNumber="4175" oraxdb:global="false" oraxdb:SQLName="entityType" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
<xs:element minOccurs="0" name="street" type="xs:string" oraxdb:propNumber="4176" oraxdb:global="false" oraxdb:SQLName="street" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
<xs:element minOccurs="0" name="postcode" oraxdb:propNumber="4178" oraxdb:global="false" oraxdb:SQLName="postcode" oraxdb:SQLType="postcode688_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
<xs:complexType oraxdb:SQLType="postcode688_T" oraxdb:SQLSchema="REPERMS">
<xs:simpleContent>
<xs:extension base="xs:string">
<xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4177" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
</xs:extension>
</xs:simpleContent>
</xs:complexType>
</xs:element>
<xs:element minOccurs="0" name="mtime" type="xs:dateTime" oraxdb:propNumber="4179" oraxdb:global="false" oraxdb:SQLName="mtime" oraxdb:SQLType="TIMESTAMP" oraxdb:memType="180" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
<xs:element minOccurs="0" name="owner" type="xs:string" oraxdb:propNumber="4180" oraxdb:global="false" oraxdb:SQLName="owner" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
<xs:element minOccurs="0" name="id" oraxdb:propNumber="4182" oraxdb:global="false" oraxdb:SQLName="id" oraxdb:SQLType="id689_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
<xs:complexType oraxdb:SQLType="id689_T" oraxdb:SQLSchema="REPERMS">
<xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4181" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
</xs:complexType>
</xs:element>
<xs:element minOccurs="0" name="city" oraxdb:propNumber="4184" oraxdb:global="false" oraxdb:SQLName="city" oraxdb:SQLType="city690_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
<xs:complexType oraxdb:SQLType="city690_T" oraxdb:SQLSchema="REPERMS">
<xs:simpleContent>
<xs:extension base="xs:string">
<xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4183" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
</xs:extension>
</xs:simpleContent>
</xs:complexType>
</xs:element>
<xs:element minOccurs="0" name="uuid" type="xs:string" oraxdb:propNumber="4185" oraxdb:global="false" oraxdb:SQLName="uuid" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
<xs:element minOccurs="0" name="ctimeOnServer" type="xs:dateTime" oraxdb:propNumber="4186" oraxdb:global="false" oraxdb:SQLName="ctimeOnServer" oraxdb:SQLType="TIMESTAMP" oraxdb:memType="180" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
<xs:element minOccurs="0" name="mtimeOnServer" type="xs:dateTime" oraxdb:propNumber="4187" oraxdb:global="false" oraxdb:SQLName="mtimeOnServer" oraxdb:SQLType="TIMESTAMP" oraxdb:memType="180" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
<xs:element minOccurs="0" name="state" oraxdb:propNumber="4189" oraxdb:global="false" oraxdb:SQLName="state" oraxdb:SQLType="state691_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
<xs:complexType oraxdb:SQLType="state691_T" oraxdb:SQLSchema="REPERMS">
<xs:simpleContent>
<xs:extension base="xs:string">
<xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4188" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
</xs:extension>
</xs:simpleContent>
</xs:complexType>
</xs:element>
<xs:element minOccurs="0" name="fax" oraxdb:propNumber="4191" oraxdb:global="false" oraxdb:SQLName="fax" oraxdb:SQLType="fax692_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
<xs:complexType oraxdb:SQLType="fax692_T" oraxdb:SQLSchema="REPERMS">
<xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4190" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
</xs:complexType>
</xs:element>
<xs:element minOccurs="0" name="isDefaultShipTo" oraxdb:propNumber="4193" oraxdb:global="false" oraxdb:SQLName="isDefaultShipTo" oraxdb:SQLType="isDefaultShipTo693_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
<xs:complexType oraxdb:SQLType="isDefaultShipTo693_T" oraxdb:SQLSchema="REPERMS">
<xs:simpleContent>
<xs:extension base="xs:string">
<xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4192" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
</xs:extension>
</xs:simpleContent>
</xs:complexType>
</xs:element>
<xs:element minOccurs="0" name="street2" oraxdb:propNumber="4195" oraxdb:global="false" oraxdb:SQLName="street2" oraxdb:SQLType="street2694_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
<xs:complexType oraxdb:SQLType="street2694_T" oraxdb:SQLSchema="REPERMS">
<xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4194" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
</xs:complexType>
</xs:element>
<xs:element minOccurs="0" name="stCustomer" oraxdb:propNumber="4197" oraxdb:global="false" oraxdb:SQLName="stCustomer" oraxdb:SQLType="stCustomer695_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
<xs:complexType oraxdb:SQLType="stCustomer695_T" oraxdb:SQLSchema="REPERMS">
<xs:simpleContent>
<xs:extension base="xs:string">
<xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4196" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
</xs:extension>
</xs:simpleContent>
</xs:complexType>
</xs:element>
<xs:element minOccurs="0" name="phone" oraxdb:propNumber="4199" oraxdb:global="false" oraxdb:SQLName="phone" oraxdb:SQLType="phone696_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
<xs:complexType oraxdb:SQLType="phone696_T" oraxdb:SQLSchema="REPERMS">
<xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4198" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
</xs:complexType>
</xs:element>
<xs:element minOccurs="0" name="cdate" type="xs:date" oraxdb:propNumber="4200" oraxdb:global="false" oraxdb:SQLName="cdate" oraxdb:SQLType="DATE" oraxdb:memType="12" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
<xs:element minOccurs="0" name="ctime" type="xs:dateTime" oraxdb:propNumber="4201" oraxdb:global="false" oraxdb:SQLName="ctime" oraxdb:SQLType="TIMESTAMP" oraxdb:memType="180" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
<xs:element minOccurs="0" name="name" oraxdb:propNumber="4203" oraxdb:global="false" oraxdb:SQLName="name" oraxdb:SQLType="name697_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
<xs:complexType oraxdb:SQLType="name697_T" oraxdb:SQLSchema="REPERMS">
<xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4202" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
</xs:complexType>
</xs:element>
<xs:element minOccurs="0" name="country" oraxdb:propNumber="4205" oraxdb:global="false" oraxdb:SQLName="country" oraxdb:SQLType="country698_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
<xs:complexType oraxdb:SQLType="country698_T" oraxdb:SQLSchema="REPERMS">
<xs:simpleContent>
<xs:extension base="xs:string">
<xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4204" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
</xs:extension>
</xs:simpleContent>
</xs:complexType>
</xs:element>
<xs:element minOccurs="0" name="objID" oraxdb:propNumber="4207" oraxdb:global="false" oraxdb:SQLName="objID" oraxdb:SQLType="objID699_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
<xs:complexType oraxdb:SQLType="objID699_T" oraxdb:SQLSchema="REPERMS">
<xs:simpleContent>
<xs:extension base="xs:unsignedInt">
<xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4206" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
</xs:extension>
</xs:simpleContent>
</xs:complexType>
</xs:element>
<xs:element minOccurs="0" name="resource_uri" type="xs:string" oraxdb:propNumber="4208" oraxdb:global="false" oraxdb:SQLName="resource_uri" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
</xs:sequence>
<xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4172" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
</xs:complexType>
</xs:element>
<xs:element minOccurs="0" name="defaultWarehouse" oraxdb:propNumber="4211" oraxdb:global="false" oraxdb:SQLName="defaultWarehouse" oraxdb:SQLType="defaultWarehouse700_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
<xs:complexType oraxdb:SQLType="defaultWarehouse700_T" oraxdb:SQLSchema="REPERMS">
<xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4210" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
</xs:complexType>
</xs:element>
<xs:element minOccurs="0" name="customerPO" oraxdb:propNumber="4213" oraxdb:global="false" oraxdb:SQLName="customerPO" oraxdb:SQLType="customerPO701_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
<xs:complexType oraxdb:SQLType="customerPO701_T" oraxdb:SQLSchema="REPERMS">
<xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4212" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
</xs:complexType>
</xs:element>
<xs:element minOccurs="0" name="lastEdited" type="xs:dateTime" oraxdb:propNumber="4214" oraxdb:global="false" oraxdb:SQLName="lastEdited" oraxdb:SQLType="TIMESTAMP" oraxdb:memType="180" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
<xs:element minOccurs="0" name="creditCard" oraxdb:propNumber="4216" oraxdb:global="false" oraxdb:SQLName="creditCard" oraxdb:SQLType="creditCard702_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
<xs:complexType oraxdb:SQLType="creditCard702_T" oraxdb:SQLSchema="REPERMS">
<xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4215" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
</xs:complexType>
</xs:element>
<xs:element minOccurs="0" name="lastExported" oraxdb:propNumber="4218" oraxdb:global="false" oraxdb:SQLName="lastExported" oraxdb:SQLType="lastExported703_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
<xs:complexType oraxdb:SQLType="lastExported703_T" oraxdb:SQLSchema="REPERMS">
<xs:simpleContent>
<xs:extension base="xs:string">
<xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4217" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
</xs:extension>
</xs:simpleContent>
</xs:complexType>
</xs:element>
<xs:element minOccurs="0" name="cdate" type="xs:date" oraxdb:propNumber="4219" oraxdb:global="false" oraxdb:SQLName="cdate" oraxdb:SQLType="DATE" oraxdb:memType="12" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
<xs:element minOccurs="0" name="versionType" oraxdb:propNumber="4221" oraxdb:global="false" oraxdb:SQLName="versionType" oraxdb:SQLType="versionType704_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
<xs:complexType oraxdb:SQLType="versionType704_T" oraxdb:SQLSchema="REPERMS">
<xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4220" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
</xs:complexType>
</xs:element>
<xs:element minOccurs="0" name="realVersion" oraxdb:propNumber="4223" oraxdb:global="false" oraxdb:SQLName="realVersion" oraxdb:SQLType="realVersion705_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
<xs:complexType oraxdb:SQLType="realVersion705_T" oraxdb:SQLSchema="REPERMS">
<xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4222" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
</xs:complexType>
</xs:element>
<xs:element minOccurs="0" name="signatureURL" oraxdb:propNumber="4225" oraxdb:global="false" oraxdb:SQLName="signatureURL" oraxdb:SQLType="signatureURL706_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
<xs:complexType oraxdb:SQLType="signatureURL706_T" oraxdb:SQLSchema="REPERMS">
<xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4224" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
</xs:complexType>
</xs:element>
<xs:element minOccurs="0" name="shippedStatus" type="xs:string" oraxdb:propNumber="4226" oraxdb:global="false" oraxdb:SQLName="shippedStatus" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
<xs:element minOccurs="0" name="totalOffDiscount" oraxdb:propNumber="4228" oraxdb:global="false" oraxdb:SQLName="totalOffDiscount" oraxdb:SQLType="totalOffDiscount707_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
<xs:complexType oraxdb:SQLType="totalOffDiscount707_T" oraxdb:SQLSchema="REPERMS">
<xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4227" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
</xs:complexType>
</xs:element>
<xs:element minOccurs="0" name="ctime" type="xs:dateTime" oraxdb:propNumber="4229" oraxdb:global="false" oraxdb:SQLName="ctime" oraxdb:SQLType="TIMESTAMP" oraxdb:memType="180" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
<xs:element minOccurs="0" name="photoURLs" oraxdb:propNumber="4231" oraxdb:global="false" oraxdb:SQLName="photoURLs" oraxdb:SQLType="photoURLs708_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
<xs:complexType oraxdb:SQLType="photoURLs708_T" oraxdb:SQLSchema="REPERMS">
<xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4230" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
</xs:complexType>
</xs:element>
<xs:element minOccurs="0" name="lines" oraxdb:propNumber="4269" oraxdb:global="false" oraxdb:SQLName="lines" oraxdb:SQLType="lines709_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
<xs:complexType oraxdb:SQLType="lines709_T" oraxdb:SQLSchema="REPERMS">
<xs:sequence minOccurs="0">
<xs:element minOccurs="0" maxOccurs="unbounded" name="object" oraxdb:propNumber="4268" oraxdb:global="false" oraxdb:SQLName="object" oraxdb:SQLType="object710_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false" oraxdb:SQLCollType="object720_COLL" oraxdb:SQLCollSchema="REPERMS">
<xs:complexType oraxdb:SQLType="object710_T" oraxdb:SQLSchema="REPERMS">
<xs:sequence>
<xs:element minOccurs="0" name="barcode" oraxdb:propNumber="4235" oraxdb:global="false" oraxdb:SQLName="barcode" oraxdb:SQLType="barcode711_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
<xs:complexType oraxdb:SQLType="barcode711_T" oraxdb:SQLSchema="REPERMS">
<xs:simpleContent>
<xs:extension base="xs:string">
<xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4234" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
</xs:extension>
</xs:simpleContent>
</xs:complexType>
</xs:element>
<xs:element minOccurs="0" name="description" type="xs:string" oraxdb:propNumber="4236" oraxdb:global="false" oraxdb:SQLName="description" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
<xs:element minOccurs="0" name="item" oraxdb:propNumber="4238" oraxdb:global="false" oraxdb:SQLName="item" oraxdb:SQLType="item712_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
<xs:complexType oraxdb:SQLType="item712_T" oraxdb:SQLSchema="REPERMS">
<xs:simpleContent>
<xs:extension base="xs:string">
<xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4237" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
</xs:extension>
</xs:simpleContent>
</xs:complexType>
</xs:element>
<xs:element minOccurs="0" name="entityType" type="xs:string" oraxdb:propNumber="4239" oraxdb:global="false" oraxdb:SQLName="entityType" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
<xs:element minOccurs="0" name="ctime" type="xs:dateTime" oraxdb:propNumber="4240" oraxdb:global="false" oraxdb:SQLName="ctime" oraxdb:SQLType="TIMESTAMP" oraxdb:memType="180" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
<xs:element minOccurs="0" name="qty" oraxdb:propNumber="4242" oraxdb:global="false" oraxdb:SQLName="qty" oraxdb:SQLType="qty713_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
<xs:complexType oraxdb:SQLType="qty713_T" oraxdb:SQLSchema="REPERMS">
<xs:simpleContent>
<xs:extension base="xs:unsignedByte">
<xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4241" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
</xs:extension>
</xs:simpleContent>
</xs:complexType>
</xs:element>
<xs:element minOccurs="0" name="dimensions" oraxdb:propNumber="4244" oraxdb:global="false" oraxdb:SQLName="dimensions" oraxdb:SQLType="dimensions714_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
<xs:complexType oraxdb:SQLType="dimensions714_T" oraxdb:SQLSchema="REPERMS">
<xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4243" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
</xs:complexType>
</xs:element>
<xs:element minOccurs="0" name="cdate" type="xs:date" oraxdb:propNumber="4245" oraxdb:global="false" oraxdb:SQLName="cdate" oraxdb:SQLType="DATE" oraxdb:memType="12" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
<xs:element minOccurs="0" name="mtime" type="xs:dateTime" oraxdb:propNumber="4246" oraxdb:global="false" oraxdb:SQLName="mtime" oraxdb:SQLType="TIMESTAMP" oraxdb:memType="180" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
<xs:element minOccurs="0" name="owner" type="xs:string" oraxdb:propNumber="4247" oraxdb:global="false" oraxdb:SQLName="owner" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
<xs:element minOccurs="0" name="total" type="xs:decimal" oraxdb:propNumber="4248" oraxdb:global="false" oraxdb:SQLName="total" oraxdb:SQLType="NUMBER" oraxdb:memType="2" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
<xs:element minOccurs="0" name="unitPrice" type="xs:decimal" oraxdb:propNumber="4249" oraxdb:global="false" oraxdb:SQLName="unitPrice" oraxdb:SQLType="NUMBER" oraxdb:memType="2" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
<xs:element minOccurs="0" name="manufacturer" oraxdb:propNumber="4251" oraxdb:global="false" oraxdb:SQLName="manufacturer" oraxdb:SQLType="manufacturer715_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
<xs:complexType oraxdb:SQLType="manufacturer715_T" oraxdb:SQLSchema="REPERMS">
<xs:simpleContent>
<xs:extension base="xs:string">
<xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4250" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
</xs:extension>
</xs:simpleContent>
</xs:complexType>
</xs:element>
<xs:element minOccurs="0" name="sku" type="xs:unsignedInt" oraxdb:propNumber="4252" oraxdb:global="false" oraxdb:SQLName="sku" oraxdb:SQLType="NUMBER" oraxdb:memType="68" oraxdb:memByteLength="4" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
<xs:element minOccurs="0" name="uuid" type="xs:string" oraxdb:propNumber="4253" oraxdb:global="false" oraxdb:SQLName="uuid" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
<xs:element minOccurs="0" name="mtimeOnServer" type="xs:dateTime" oraxdb:propNumber="4254" oraxdb:global="false" oraxdb:SQLName="mtimeOnServer" oraxdb:SQLType="TIMESTAMP" oraxdb:memType="180" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
<xs:element minOccurs="0" name="isku" type="xs:unsignedInt" oraxdb:propNumber="4255" oraxdb:global="false" oraxdb:SQLName="isku" oraxdb:SQLType="NUMBER" oraxdb:memType="68" oraxdb:memByteLength="4" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
<xs:element minOccurs="0" name="qtyFree" oraxdb:propNumber="4257" oraxdb:global="false" oraxdb:SQLName="qtyFree" oraxdb:SQLType="qtyFree716_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
<xs:complexType oraxdb:SQLType="qtyFree716_T" oraxdb:SQLSchema="REPERMS">
<xs:simpleContent>
<xs:extension base="xs:unsignedByte">
<xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4256" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
</xs:extension>
</xs:simpleContent>
</xs:complexType>
</xs:element>
<xs:element minOccurs="0" name="notes" oraxdb:propNumber="4258" oraxdb:global="false" oraxdb:SQLName="notes" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false"/>
<xs:element minOccurs="0" name="ctimeOnServer" type="xs:dateTime" oraxdb:propNumber="4259" oraxdb:global="false" oraxdb:SQLName="ctimeOnServer" oraxdb:SQLType="TIMESTAMP" oraxdb:memType="180" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
<xs:element minOccurs="0" name="qtyShipped" oraxdb:propNumber="4261" oraxdb:global="false" oraxdb:SQLName="qtyShipped" oraxdb:SQLType="qtyShipped717_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
<xs:complexType oraxdb:SQLType="qtyShipped717_T" oraxdb:SQLSchema="REPERMS">
<xs:simpleContent>
<xs:extension base="xs:unsignedByte">
<xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4260" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
</xs:extension>
</xs:simpleContent>
</xs:complexType>
</xs:element>
<xs:element minOccurs="0" name="objID" oraxdb:propNumber="4263" oraxdb:global="false" oraxdb:SQLName="objID" oraxdb:SQLType="objID718_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
<xs:complexType oraxdb:SQLType="objID718_T" oraxdb:SQLSchema="REPERMS">
<xs:simpleContent>
<xs:extension base="xs:unsignedInt">
<xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4262" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
</xs:extension>
</xs:simpleContent>
</xs:complexType>
</xs:element>
<xs:element minOccurs="0" name="vsku" oraxdb:propNumber="4265" oraxdb:global="false" oraxdb:SQLName="vsku" oraxdb:SQLType="vsku719_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
<xs:complexType oraxdb:SQLType="vsku719_T" oraxdb:SQLSchema="REPERMS">
<xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4264" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
</xs:complexType>
</xs:element>
<xs:element minOccurs="0" name="order" type="xs:string" oraxdb:propNumber="4266" oraxdb:global="false" oraxdb:SQLName="order" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
<xs:element minOccurs="0" name="resource_uri" type="xs:string" oraxdb:propNumber="4267" oraxdb:global="false" oraxdb:SQLName="resource_uri" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
</xs:sequence>
<xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4233" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
</xs:complexType>
</xs:element>
</xs:sequence>
<xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4232" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
</xs:complexType>
</xs:element>
<xs:element minOccurs="0" name="cancelDate" oraxdb:propNumber="4271" oraxdb:global="false" oraxdb:SQLName="cancelDate" oraxdb:SQLType="cancelDate721_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
<xs:complexType oraxdb:SQLType="cancelDate721_T" oraxdb:SQLSchema="REPERMS">
<xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4270" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
</xs:complexType>
</xs:element>
<xs:element minOccurs="0" name="objID" oraxdb:propNumber="4273" oraxdb:global="false" oraxdb:SQLName="objID" oraxdb:SQLType="objID722_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
<xs:complexType oraxdb:SQLType="objID722_T" oraxdb:SQLSchema="REPERMS">
<xs:simpleContent>
<xs:extension base="xs:unsignedInt">
<xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4272" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
</xs:extension>
</xs:simpleContent>
</xs:complexType>
</xs:element>
<xs:element minOccurs="0" name="notes" type="xs:string" oraxdb:propNumber="4274" oraxdb:global="false" oraxdb:SQLName="notes" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
<xs:element minOccurs="0" name="resource_uri" type="xs:string" oraxdb:propNumber="4275" oraxdb:global="false" oraxdb:SQLName="resource_uri" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
</xs:sequence>
<xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="3961" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
</xs:complexType>
</xs:element>
</xs:sequence>
<xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="3960" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
</xs:complexType>
</xs:element>
<xs:element minOccurs="0" name="meta" oraxdb:propNumber="4288" oraxdb:global="false" oraxdb:SQLName="meta" oraxdb:SQLType="meta724_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
<xs:complexType oraxdb:SQLType="meta724_T" oraxdb:SQLSchema="REPERMS">
<xs:sequence>
<xs:element minOccurs="0" name="next" type="xs:string" oraxdb:propNumber="4279" oraxdb:global="false" oraxdb:SQLName="next" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
<xs:element minOccurs="0" name="total_count" oraxdb:propNumber="4281" oraxdb:global="false" oraxdb:SQLName="total_count" oraxdb:SQLType="total_count725_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
<xs:complexType oraxdb:SQLType="total_count725_T" oraxdb:SQLSchema="REPERMS">
<xs:simpleContent>
<xs:extension base="xs:unsignedShort">
<xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4280" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
</xs:extension>
</xs:simpleContent>
</xs:complexType>
</xs:element>
<xs:element minOccurs="0" name="previous" oraxdb:propNumber="4283" oraxdb:global="false" oraxdb:SQLName="previous" oraxdb:SQLType="previous726_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
<xs:complexType oraxdb:SQLType="previous726_T" oraxdb:SQLSchema="REPERMS">
<xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4282" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
</xs:complexType>
</xs:element>
<xs:element minOccurs="0" name="limit" oraxdb:propNumber="4285" oraxdb:global="false" oraxdb:SQLName="limit" oraxdb:SQLType="limit727_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
<xs:complexType oraxdb:SQLType="limit727_T" oraxdb:SQLSchema="REPERMS">
<xs:simpleContent>
<xs:extension base="xs:unsignedByte">
<xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4284" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
</xs:extension>
</xs:simpleContent>
</xs:complexType>
</xs:element>
<xs:element minOccurs="0" name="offset" oraxdb:propNumber="4287" oraxdb:global="false" oraxdb:SQLName="offset" oraxdb:SQLType="offset728_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
<xs:complexType oraxdb:SQLType="offset728_T" oraxdb:SQLSchema="REPERMS">
<xs:simpleContent>
<xs:extension base="xs:unsignedByte">
<xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4286" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
</xs:extension>
</xs:simpleContent>
</xs:complexType>
</xs:element>
</xs:sequence>
<xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4278" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:schema>
how do you want them extracted?
are you expecting a single table? multiple tables?
single row? multiple rows?
Given the xml above, what is the expected result?
please provide rows/columns of data. That's what I'll use to confirm my test results
are you expecting a single table? multiple tables?
single row? multiple rows?
Given the xml above, what is the expected result?
please provide rows/columns of data. That's what I'll use to confirm my test results
ASKER
in a perfect world. from the last xml sample i uploaded to this thread. i would get these results
owner taxid mtime owner sku qty
24233 0 2013-11-11T17:27:36Z johnd@nowhere.com 746 12
24233 0 2013-11-11T17:27:36Z johnd@nowhere.com 748 24
24233 0 2013-11-11T17:27:36Z johnd@nowhere.com 2152 12
24233 0 2013-11-11T17:27:36Z johnd@nowhere.com 2153 12
24233 0 2013-11-11T17:27:36Z johnd@nowhere.com 2361 24
24233 0 2013-11-11T17:27:36Z johnd@nowhere.com 10101 6
24233 0 2013-11-11T17:27:36Z johnd@nowhere.com 10102 6
24233 0 2013-11-11T17:27:36Z johnd@nowhere.com 10103 6
24233 0 2013-11-11T17:27:36Z johnd@nowhere.com 11010 12
24233 0 2013-11-11T17:27:36Z johnd@nowhere.com 700748 24
24233 0 2013-11-11T17:27:36Z johnd@nowhere.com 994 1
SELECT EXTRACTVALUE(t.xml_documen t, '//customer/id') id,
EXTRACTVALUE(t.xml_documen t, '//customer/taxID') taxid,
x.*
FROM table_with_xml_column t,
XMLTABLE(
'//lines/object'
PASSING t.xml_document
COLUMNS mtime VARCHAR2(50) PATH '/object/mtime',
owner VARCHAR2(50) PATH '/object/owner',
sku NUMBER PATH '/object/sku',
qty NUMBER PATH '/object/qty'
) x
WHERE filename = 'output.xml'
EXTRACTVALUE(t.xml_documen
x.*
FROM table_with_xml_column t,
XMLTABLE(
'//lines/object'
PASSING t.xml_document
COLUMNS mtime VARCHAR2(50) PATH '/object/mtime',
owner VARCHAR2(50) PATH '/object/owner',
sku NUMBER PATH '/object/sku',
qty NUMBER PATH '/object/qty'
) x
WHERE filename = 'output.xml'
ASKER
ORA-19025: EXTRACTVALUE returns value of only one node
19025. 00000 - "EXTRACTVALUE returns value of only one node"
*Cause: Given XPath points to more than one node.
*Action: Rewrite the query so that exactly one node is returned.
alternate version using xmltable for both the customer portion and the lines
SELECT c.*, l.*
FROM table_with_xml_column t,
XMLTABLE(
'//customer'
PASSING t.xml_document
COLUMNS id NUMBER PATH '/customer/id', taxid NUMBER PATH '/customer/taxID'
) c,
XMLTABLE(
'//lines/object'
PASSING t.xml_document
COLUMNS mtime VARCHAR2(50) PATH '/object/mtime',
owner VARCHAR2(50) PATH '/object/owner',
sku NUMBER PATH '/object/sku',
qty NUMBER PATH '/object/qty'
) l
WHERE filename = 'output.xml'
SELECT c.*, l.*
FROM table_with_xml_column t,
XMLTABLE(
'//customer'
PASSING t.xml_document
COLUMNS id NUMBER PATH '/customer/id', taxid NUMBER PATH '/customer/taxID'
) c,
XMLTABLE(
'//lines/object'
PASSING t.xml_document
COLUMNS mtime VARCHAR2(50) PATH '/object/mtime',
owner VARCHAR2(50) PATH '/object/owner',
sku NUMBER PATH '/object/sku',
qty NUMBER PATH '/object/qty'
) l
WHERE filename = 'output.xml'
using the xml provided above, I get the the requested results.
if you're getting
ORA-19025: EXTRACTVALUE returns value of only one node
are you sure your input XML is the same as what you have posted above?
The xmltable version I posted will allow you to pull multiple customers out of a single xml, but there is nothing in the sample above to correlate a particular customer to a particular set of lines
if you're getting
ORA-19025: EXTRACTVALUE returns value of only one node
are you sure your input XML is the same as what you have posted above?
The xmltable version I posted will allow you to pull multiple customers out of a single xml, but there is nothing in the sample above to correlate a particular customer to a particular set of lines
ASKER
using the below code, i cant select anything in the xml file that has a recent data.
the last select-able date is 20131004.
Also, when i run this, i get a query with 130K rows.
would it help if i uploaded an XML file that had multiple orders ?
the last select-able date is 20131004.
Also, when i run this, i get a query with 130K rows.
would it help if i uploaded an XML file that had multiple orders ?
WITH Q AS (SELECT c.*, l.*
FROM table_with_xml_column t,
XMLTABLE(
'//customer'
PASSING t.xml_document
COLUMNS id VARCHAR2(10) PATH '/customer/id'
) c,
XMLTABLE(
'//lines/object'
PASSING t.xml_document
COLUMNS mtime VARCHAR2(50) PATH '/object/mtime',
owner VARCHAR2(50) PATH '/object/owner',
sku VARCHAR2(10) PATH '/object/sku',
qty VARCHAR2(10) PATH '/object/qty'
) l
WHERE filename = 'output.xml')
select * from (
select
id,
to_char(to_date(substr(mtime,1,10),'YYYY-MM-DD'),'yyyymmdd') xdate,
owner,
sku,
qty from Q) where xdate = 20131107;
ASKER
i just checked the xml file manually. mtime does has a 2013-11-07 order
The file above doesn't have any data for 2013-11-07.
We need to use the same data with the same expected results.
If you're trying to do something different than what you've posted above, it doesn't surprise me that it might fail or produce different results.
What do you get when you run either of the queries I posted using the file you posted above?
If you post a new file, then include the expected results for that file.
We need to use the same data with the same expected results.
If you're trying to do something different than what you've posted above, it doesn't surprise me that it might fail or produce different results.
What do you get when you run either of the queries I posted using the file you posted above?
If you post a new file, then include the expected results for that file.
ASKER
Im going to post a new file that has 5 orders.
i will also post expected results. gimme 10 mins to prepare
i will also post expected results. gimme 10 mins to prepare
ASKER
I think the problem is that different sections have different mtimes, the one i am looking for is the one under billto
ASKER
<object type="hash">
<otherVersions type="list"/>
<percentDiscount type="null"/>
<entityType>SalesOrder</entityType>
<ownerName>Somefirstname Somelastname</ownerName>
<mtime>2013-10-12T20:17:05Z</mtime>
<owner>Somefirstnamek@somedomain</owner>
<shippingMethod>FEDEX</shippingMethod>
<id>#81331</id>
<category>/api/v2/order_categories/4960</category>
<billTo type="hash">
<btCustomer>/api/v2/customers/98969</btCustomer>
<entityType>Address</entityType>
<street type="null"/>
<postcode type="null"/>
<mtime>2013-11-08T16:43:43Z</mtime>
<owner>system</owner>
<id type="null"/>
<city type="null"/>
<uuid>a3e9b1d3-6247-4a21-8283-69d473d37824</uuid>
<ctimeOnServer>2013-10-04T16:31:19Z</ctimeOnServer>
<mtimeOnServer>2013-11-08T17:29:39Z</mtimeOnServer>
<state type="null"/>
<fax type="null"/>
<isDefaultShipTo type="boolean">False</isDefaultShipTo>
<street2 type="null"/>
<stCustomer type="null"/>
<phone type="null"/>
<cdate>2013-10-04</cdate>
<ctime>2013-10-04T16:31:19Z</ctime>
<name type="null"/>
<country type="null"/>
<objID type="integer">98970</objID>
<resource_uri>/api/v2/addresses/98970</resource_uri>
</billTo>
<paymentTerms>PREPAID</paymentTerms>
<uuid>b0454240-fd38-4363-997e-518e6a7086d7</uuid>
<ctimeOnServer>2013-10-04T17:43:59Z</ctimeOnServer>
<freeShipping type="boolean">False</freeShipping>
<startShipDate>2013-10-05</startShipDate>
<mtimeOnServer>2013-10-12T20:17:06Z</mtimeOnServer>
<shipPartial type="boolean">True</shipPartial>
<userGroup>/api/v2/user_groups/20743</userGroup>
<status>Confirmed</status>
<customer type="hash">
<locale>en_US</locale>
<percentDiscount type="null"/>
<entityType>Customer</entityType>
<currency>USD</currency>
<ownerName>system</ownerName>
<mtime>2013-11-08T16:43:43Z</mtime>
<owner>system</owner>
<shippingMethod>FEDEX</shippingMethod>
<id>26483</id>
<billTo type="hash">
<btCustomer>/api/v2/customers/98969</btCustomer>
<entityType>Address</entityType>
<street type="null"/>
<postcode type="null"/>
<mtime>2013-11-08T16:43:43Z</mtime>
<owner>system</owner>
<id type="null"/>
<city type="null"/>
<uuid>a3e9b1d3-6247-4a21-8283-69d473d37824</uuid>
<ctimeOnServer>2013-10-04T16:31:19Z</ctimeOnServer>
<mtimeOnServer>2013-11-08T17:29:39Z</mtimeOnServer>
<state type="null"/>
<fax type="null"/>
<isDefaultShipTo type="boolean">False</isDefaultShipTo>
<street2 type="null"/>
<stCustomer type="null"/>
<phone type="null"/>
<cdate>2013-10-04</cdate>
<ctime>2013-10-04T16:31:19Z</ctime>
<name type="null"/>
<country type="null"/>
<objID type="integer">98970</objID>
<resource_uri>/api/v2/addresses/98970</resource_uri>
</billTo>
<paymentTerms>PREPAID</paymentTerms>
<customerGroup type="hash">
<uuid>5e0ccb0b-d2d6-496f-8c0c-0fbfba0d5807</uuid>
<ctimeOnServer>2013-09-12T18:33:09Z</ctimeOnServer>
<currencyCode>USD</currencyCode>
<entityType>CustomerGroup</entityType>
<name>Somefirstname Somelastname</name>
<mtimeOnServer>2013-09-12T18:34:22Z</mtimeOnServer>
<cdate>2013-09-12</cdate>
<objID type="integer">20659</objID>
<mtime>2013-09-12T18:34:22Z</mtime>
<owner>johnt@somedomain</owner>
<resource_uri>/api/v2/customer_groups/20659</resource_uri>
<id>9</id>
<isDefault type="boolean">False</isDefault>
<ctime>2013-09-12T18:33:09Z</ctime>
</customerGroup>
<uuid>95619422-11fd-49d1-87e5-18e1d0bd005f</uuid>
<ctimeOnServer>2013-10-04T16:31:19Z</ctimeOnServer>
<taxID>0</taxID>
<mtimeOnServer>2013-11-08T17:29:39Z</mtimeOnServer>
<userGroup type="hash">
<isMaster type="boolean">False</isMaster>
<subcategories type="list"/>
<ctime>2013-09-12T18:59:19Z</ctime>
<parent>/api/v2/user_groups/2</parent>
<ctimeOnServer>2013-09-12T18:59:19Z</ctimeOnServer>
<entityType>UserGroup</entityType>
<name>Somefirstname Somelastname</name>
<mtimeOnServer>2013-09-12T18:59:19Z</mtimeOnServer>
<cdate>2013-09-12</cdate>
<objID type="integer">20743</objID>
<mtime>2013-09-12T18:59:19Z</mtime>
<owner>johnt@somedomain</owner>
<resource_uri>/api/v2/user_groups/20743</resource_uri>
<id>Somefirstname Somelastname</id>
<uuid>0af1dc20-2567-4f7d-96d4-20e80a28d6a4</uuid>
</userGroup>
<defaultShipTo>/api/v2/addresses/156711</defaultShipTo>
<email type="null"/>
<defaultWarehouse type="null"/>
<cdate>2013-10-04</cdate>
<name>Healthways (26483)</name>
<ctime>2013-10-04T16:31:19Z</ctime>
<contact>Khalid</contact>
<objID type="integer">98969</objID>
<creditCards type="list"/>
<shipTos type="list">
<object type="hash">
<btCustomer type="null"/>
<entityType>Address</entityType>
<street>90</street>
<postcode/>
<mtime>2013-11-08T16:43:43Z</mtime>
<owner>johnt@somedomain</owner>
<id type="null"/>
<city/>
<uuid>5605c073-7db1-4fe9-9285-ff70cdd2cac6</uuid>
<ctimeOnServer>2013-10-04T19:30:00Z</ctimeOnServer>
<mtimeOnServer>2013-11-08T17:29:39Z</mtimeOnServer>
<state/>
<fax/>
<isDefaultShipTo type="boolean">True</isDefaultShipTo>
<street2/>
<stCustomer>/api/v2/customers/98969</stCustomer>
<phone/>
<cdate>2013-10-04</cdate>
<ctime>2013-10-04T19:30:00Z</ctime>
<name/>
<country/>
<objID type="integer">156711</objID>
<resource_uri>/api/v2/addresses/156711</resource_uri>
</object>
</shipTos>
<resource_uri>/api/v2/customers/98969</resource_uri>
</customer>
<versionInfo type="null"/>
<shipTo type="hash">
<btCustomer type="null"/>
<entityType>Address</entityType>
<street>90</street>
<postcode/>
<mtime>2013-11-08T16:43:43Z</mtime>
<owner>johnt@somedomain</owner>
<id type="null"/>
<city/>
<uuid>5605c073-7db1-4fe9-9285-ff70cdd2cac6</uuid>
<ctimeOnServer>2013-10-04T19:30:00Z</ctimeOnServer>
<mtimeOnServer>2013-11-08T17:29:39Z</mtimeOnServer>
<state/>
<fax/>
<isDefaultShipTo type="boolean">True</isDefaultShipTo>
<street2/>
<stCustomer>/api/v2/customers/98969</stCustomer>
<phone/>
<cdate>2013-10-04</cdate>
<ctime>2013-10-04T19:30:00Z</ctime>
<name/>
<country/>
<objID type="integer">156711</objID>
<resource_uri>/api/v2/addresses/156711</resource_uri>
</shipTo>
<defaultWarehouse type="null"/>
<customerPO type="null"/>
<lastEdited>2013-11-08T16:43:43Z</lastEdited>
<creditCard type="null"/>
<lastExported>2013-10-10T20:29:29Z</lastExported>
<cdate>2013-10-04</cdate>
<versionType type="null"/>
<realVersion type="null"/>
<signatureURL type="null"/>
<shippedStatus>Not Shipped</shippedStatus>
<totalOffDiscount type="null"/>
<ctime>2013-10-04T14:24:38Z</ctime>
<photoURLs type="list"/>
<lines type="list">
<object type="hash">
<barcode>7-22430-11016-5</barcode>
<description>Synergy, Trilogy - 16 OZ</description>
<item>/api/v2/items/156998</item>
<entityType>SalesOrderLine</entityType>
<ctime>2013-10-04T14:24:48Z</ctime>
<qty type="integer">12</qty>
<dimensions type="null"/>
<cdate>2013-10-04</cdate>
<mtime>2013-10-06T21:06:11Z</mtime>
<owner>Somefirstnamek@somedomain</owner>
<total>0.00</total>
<unitPrice>0.00</unitPrice>
<manufacturer>/api/v2/manufacturers/3</manufacturer>
<sku>402</sku>
<uuid>bb85e14d-c500-4395-8e1e-a4c041fc3c23</uuid>
<mtimeOnServer>2013-10-06T21:06:11Z</mtimeOnServer>
<isku>402</isku>
<qtyFree type="integer">0</qtyFree>
<notes/>
<ctimeOnServer>2013-10-04T17:43:59Z</ctimeOnServer>
<qtyShipped type="integer">0</qtyShipped>
<objID type="integer">81332</objID>
<vsku type="null"/>
<order>/api/v2/orders/81331</order>
<resource_uri>/api/v2/order_lines/81332</resource_uri>
</object>
<object type="hash">
<barcode>7-22430-60016-1</barcode>
<description>Synergy, Gingerberry - 16 OZ</description>
<item>/api/v2/items/157001</item>
<entityType>SalesOrderLine</entityType>
<ctime>2013-10-04T14:24:51Z</ctime>
<qty type="integer">12</qty>
<dimensions type="null"/>
<cdate>2013-10-04</cdate>
<mtime>2013-10-06T21:06:11Z</mtime>
<owner>Somefirstnamek@somedomain</owner>
<total>0.00</total>
<unitPrice>0.00</unitPrice>
<manufacturer>/api/v2/manufacturers/3</manufacturer>
<sku>406</sku>
<uuid>521cf305-8826-4f4b-9dd2-e83f4673c948</uuid>
<mtimeOnServer>2013-10-06T21:06:11Z</mtimeOnServer>
<isku>406</isku>
<qtyFree type="integer">0</qtyFree>
<notes/>
<ctimeOnServer>2013-10-04T17:43:59Z</ctimeOnServer>
<qtyShipped type="integer">0</qtyShipped>
<objID type="integer">81333</objID>
<vsku type="null"/>
<order>/api/v2/orders/81331</order>
<resource_uri>/api/v2/order_lines/81333</resource_uri>
</object>
<object type="hash">
<barcode>7-22430-10016-6</barcode>
<description>GT's, Citrus - 16 OZ</description>
<item>/api/v2/items/157009</item>
<entityType>SalesOrderLine</entityType>
<ctime>2013-10-04T14:24:54Z</ctime>
<qty type="integer">12</qty>
<dimensions type="null"/>
<cdate>2013-10-04</cdate>
<mtime>2013-10-06T21:06:11Z</mtime>
<owner>Somefirstnamek@somedomain</owner>
<total>0.00</total>
<unitPrice>0.00</unitPrice>
<manufacturer>/api/v2/manufacturers/3</manufacturer>
<sku>415</sku>
<uuid>cada83c4-b159-4873-8290-e9939b0e20f5</uuid>
<mtimeOnServer>2013-10-06T21:06:11Z</mtimeOnServer>
<isku>415</isku>
<qtyFree type="integer">0</qtyFree>
<notes/>
<ctimeOnServer>2013-10-04T17:43:59Z</ctimeOnServer>
<qtyShipped type="integer">0</qtyShipped>
<objID type="integer">81334</objID>
<vsku type="null"/>
<order>/api/v2/orders/81331</order>
<resource_uri>/api/v2/order_lines/81334</resource_uri>
</object>
<object type="hash">
<barcode>8-59078-00209-2</barcode>
<description>100% Raw Coconut Water - 8 OZ</description>
<item>/api/v2/items/157055</item>
<entityType>SalesOrderLine</entityType>
<ctime>2013-10-04T14:28:29Z</ctime>
<qty type="integer">24</qty>
<dimensions type="null"/>
<cdate>2013-10-04</cdate>
<mtime>2013-10-06T21:06:12Z</mtime>
<owner>Somefirstnamek@somedomain</owner>
<total>0.00</total>
<unitPrice>0.00</unitPrice>
<manufacturer>/api/v2/manufacturers/3</manufacturer>
<sku>470</sku>
<uuid>8e82528a-709b-427e-afe9-453d879417d2</uuid>
<mtimeOnServer>2013-10-06T21:06:12Z</mtimeOnServer>
<isku>470</isku>
<qtyFree type="integer">0</qtyFree>
<notes/>
<ctimeOnServer>2013-10-04T17:43:59Z</ctimeOnServer>
<qtyShipped type="integer">0</qtyShipped>
<objID type="integer">81335</objID>
<vsku type="null"/>
<order>/api/v2/orders/81331</order>
<resource_uri>/api/v2/order_lines/81335</resource_uri>
</object>
<object type="hash">
<barcode>8-59078-00215-3</barcode>
<description>100% Raw Coconut Water - 16 OZ</description>
<item>/api/v2/items/157057</item>
<entityType>SalesOrderLine</entityType>
<ctime>2013-10-04T14:28:30Z</ctime>
<qty type="integer">36</qty>
<dimensions type="null"/>
<cdate>2013-10-04</cdate>
<mtime>2013-10-06T21:06:13Z</mtime>
<owner>Somefirstnamek@somedomain</owner>
<total>0.00</total>
<unitPrice>0.00</unitPrice>
<manufacturer>/api/v2/manufacturers/3</manufacturer>
<sku>471</sku>
<uuid>98852331-0a45-443e-b8d3-0943183b89f5</uuid>
<mtimeOnServer>2013-10-06T21:06:13Z</mtimeOnServer>
<isku>471</isku>
<qtyFree type="integer">0</qtyFree>
<notes/>
<ctimeOnServer>2013-10-04T17:43:59Z</ctimeOnServer>
<qtyShipped type="integer">0</qtyShipped>
<objID type="integer">81336</objID>
<vsku type="null"/>
<order>/api/v2/orders/81331</order>
<resource_uri>/api/v2/order_lines/81336</resource_uri>
</object>
</lines>
<cancelDate type="null"/>
<objID type="integer">81331</objID>
<notes>
WARNING: The customer for this order was deleted by John Terrero. You will need to recreate this customer record manually and then tap the top row in the 'Summary' view to re-link this order to the new customer record. The old customer was: Healthways (Contact: Khalid) Email: Phone: None
</notes>
<resource_uri>/api/v2/orders/81331</resource_uri>
</object>
<object type="hash">
<otherVersions type="list"/>
<percentDiscount type="null"/>
<entityType>SalesOrder</entityType>
<ownerName>Somefirstname Somelastname</ownerName>
<mtime>2013-10-12T20:17:20Z</mtime>
<owner>Somefirstnamek@somedomain</owner>
<shippingMethod>FEDEX</shippingMethod>
<id>#81341</id>
<category>/api/v2/order_categories/4960</category>
<billTo type="hash">
<btCustomer>/api/v2/customers/81337</btCustomer>
<entityType>Address</entityType>
<street>78 West Pleasant Ave</street>
<postcode>07601</postcode>
<mtime>2013-10-22T21:14:46Z</mtime>
<owner>Somefirstnamek@somedomain</owner>
<id type="null"/>
<city>Maywood</city>
<uuid>2efc8147-42ad-43be-a4a2-9864ca27b390</uuid>
<ctimeOnServer>2013-10-04T17:48:37Z</ctimeOnServer>
<mtimeOnServer>2013-10-23T11:40:33Z</mtimeOnServer>
<state>NJ</state>
<fax type="null"/>
<isDefaultShipTo type="boolean">False</isDefaultShipTo>
<street2/>
<stCustomer type="null"/>
<phone/>
<cdate>2013-10-04</cdate>
<ctime>2013-10-04T17:44:01Z</ctime>
<name>West side Market Dba May wood Market</name>
<country>US</country>
<objID type="integer">81338</objID>
<resource_uri>/api/v2/addresses/81338</resource_uri>
</billTo>
<paymentTerms>PREPAID</paymentTerms>
<uuid>3b644adc-7071-4e52-9760-f02bc52ba52a</uuid>
<ctimeOnServer>2013-10-04T17:48:37Z</ctimeOnServer>
<freeShipping type="boolean">False</freeShipping>
<startShipDate type="null"/>
<mtimeOnServer>2013-10-13T20:01:37Z</mtimeOnServer>
<shipPartial type="boolean">True</shipPartial>
<userGroup>/api/v2/user_groups/20743</userGroup>
<status>Confirmed</status>
<customer type="hash">
<locale>en_US</locale>
<percentDiscount type="null"/>
<entityType>Customer</entityType>
<currency>USD</currency>
<ownerName>Somefirstname Somelastname</ownerName>
<mtime>2013-10-22T21:14:46Z</mtime>
<owner>Somefirstnamek@somedomain</owner>
<shippingMethod>FEDEX</shippingMethod>
<id>23075</id>
<billTo type="hash">
<btCustomer>/api/v2/customers/81337</btCustomer>
<entityType>Address</entityType>
<street>78 West Pleasant Ave</street>
<postcode>07601</postcode>
<mtime>2013-10-22T21:14:46Z</mtime>
<owner>Somefirstnamek@somedomain</owner>
<id type="null"/>
<city>Maywood</city>
<uuid>2efc8147-42ad-43be-a4a2-9864ca27b390</uuid>
<ctimeOnServer>2013-10-04T17:48:37Z</ctimeOnServer>
<mtimeOnServer>2013-10-23T11:40:33Z</mtimeOnServer>
<state>NJ</state>
<fax type="null"/>
<isDefaultShipTo type="boolean">False</isDefaultShipTo>
<street2/>
<stCustomer type="null"/>
<phone/>
<cdate>2013-10-04</cdate>
<ctime>2013-10-04T17:44:01Z</ctime>
<name>West side Market Dba May wood Market</name>
<country>US</country>
<objID type="integer">81338</objID>
<resource_uri>/api/v2/addresses/81338</resource_uri>
</billTo>
<paymentTerms>PREPAID</paymentTerms>
<customerGroup type="hash">
<uuid>5e0ccb0b-d2d6-496f-8c0c-0fbfba0d5807</uuid>
<ctimeOnServer>2013-09-12T18:33:09Z</ctimeOnServer>
<currencyCode>USD</currencyCode>
<entityType>CustomerGroup</entityType>
<name>Somefirstname Somelastname</name>
<mtimeOnServer>2013-09-12T18:34:22Z</mtimeOnServer>
<cdate>2013-09-12</cdate>
<objID type="integer">20659</objID>
<mtime>2013-09-12T18:34:22Z</mtime>
<owner>johnt@somedomain</owner>
<resource_uri>/api/v2/customer_groups/20659</resource_uri>
<id>9</id>
<isDefault type="boolean">False</isDefault>
<ctime>2013-09-12T18:33:09Z</ctime>
</customerGroup>
<uuid>e52cd757-5127-4c62-9eb3-6bb3eea9de8d</uuid>
<ctimeOnServer>2013-10-04T17:48:37Z</ctimeOnServer>
<taxID>0</taxID>
<mtimeOnServer>2013-10-23T11:40:33Z</mtimeOnServer>
<userGroup type="hash">
<isMaster type="boolean">False</isMaster>
<subcategories type="list"/>
<ctime>2013-09-12T18:59:19Z</ctime>
<parent>/api/v2/user_groups/2</parent>
<ctimeOnServer>2013-09-12T18:59:19Z</ctimeOnServer>
<entityType>UserGroup</entityType>
<name>Somefirstname Somelastname</name>
<mtimeOnServer>2013-09-12T18:59:19Z</mtimeOnServer>
<cdate>2013-09-12</cdate>
<objID type="integer">20743</objID>
<mtime>2013-09-12T18:59:19Z</mtime>
<owner>johnt@somedomain</owner>
<resource_uri>/api/v2/user_groups/20743</resource_uri>
<id>Somefirstname Somelastname</id>
<uuid>0af1dc20-2567-4f7d-96d4-20e80a28d6a4</uuid>
</userGroup>
<defaultShipTo>/api/v2/addresses/81340</defaultShipTo>
<email/>
<defaultWarehouse type="null"/>
<cdate>2013-10-04</cdate>
<name>Maywood Market</name>
<ctime>2013-10-04T17:44:01Z</ctime>
<contact>Kosta</contact>
<objID type="integer">81337</objID>
<creditCards type="list"/>
<shipTos type="list">
<object type="hash">
<btCustomer type="null"/>
<entityType>Address</entityType>
<street>90</street>
<postcode type="null"/>
<mtime>2013-10-22T21:14:46Z</mtime>
<owner>Somefirstnamek@somedomain</owner>
<id type="null"/>
<city type="null"/>
<uuid>dfa31602-ae56-4ed7-8dad-3fb8164feb83</uuid>
<ctimeOnServer>2013-10-04T17:48:37Z</ctimeOnServer>
<mtimeOnServer>2013-10-23T11:40:33Z</mtimeOnServer>
<state type="null"/>
<fax type="null"/>
<isDefaultShipTo type="boolean">True</isDefaultShipTo>
<street2 type="null"/>
<stCustomer>/api/v2/customers/81337</stCustomer>
<phone type="null"/>
<cdate>2013-10-04</cdate>
<ctime>2013-10-04T17:45:21Z</ctime>
<name type="null"/>
<country>US</country>
<objID type="integer">81340</objID>
<resource_uri>/api/v2/addresses/81340</resource_uri>
</object>
</shipTos>
<resource_uri>/api/v2/customers/81337</resource_uri>
</customer>
<versionInfo type="null"/>
<shipTo type="hash">
<btCustomer type="null"/>
<entityType>Address</entityType>
<street>90</street>
<postcode type="null"/>
<mtime>2013-10-22T21:14:46Z</mtime>
<owner>Somefirstnamek@somedomain</owner>
<id type="null"/>
<city type="null"/>
<uuid>dfa31602-ae56-4ed7-8dad-3fb8164feb83</uuid>
<ctimeOnServer>2013-10-04T17:48:37Z</ctimeOnServer>
<mtimeOnServer>2013-10-23T11:40:33Z</mtimeOnServer>
<state type="null"/>
<fax type="null"/>
<isDefaultShipTo type="boolean">True</isDefaultShipTo>
<street2 type="null"/>
<stCustomer>/api/v2/customers/81337</stCustomer>
<phone type="null"/>
<cdate>2013-10-04</cdate>
<ctime>2013-10-04T17:45:21Z</ctime>
<name type="null"/>
<country>US</country>
<objID type="integer">81340</objID>
<resource_uri>/api/v2/addresses/81340</resource_uri>
</shipTo>
<defaultWarehouse type="null"/>
<customerPO type="null"/>
<lastEdited>2013-10-22T21:14:46Z</lastEdited>
<creditCard type="null"/>
<lastExported>2013-10-10T20:29:29Z</lastExported>
<cdate>2013-10-04</cdate>
<versionType type="null"/>
<realVersion type="null"/>
<signatureURL type="null"/>
<shippedStatus>Not Shipped</shippedStatus>
<totalOffDiscount type="null"/>
<ctime>2013-10-04T17:47:48Z</ctime>
<photoURLs type="list"/>
<lines type="list">
<object type="hash">
<barcode>7-22430-20016-3</barcode>
<description>GT's, Gingerade - 16 OZ</description>
<item>/api/v2/items/156995</item>
<entityType>SalesOrderLine</entityType>
<ctime>2013-10-04T17:48:19Z</ctime>
<qty type="integer">12</qty>
<dimensions type="null"/>
<cdate>2013-10-04</cdate>
<mtime>2013-10-06T21:06:11Z</mtime>
<owner>Somefirstnamek@somedomain</owner>
<total>0.00</total>
<unitPrice>0.00</unitPrice>
<manufacturer>/api/v2/manufacturers/3</manufacturer>
<sku>400</sku>
<uuid>2d026d00-89b6-4381-89b9-54569546b8ae</uuid>
<mtimeOnServer>2013-10-06T21:06:11Z</mtimeOnServer>
<isku>400</isku>
<qtyFree type="integer">0</qtyFree>
<notes/>
<ctimeOnServer>2013-10-04T17:48:37Z</ctimeOnServer>
<qtyShipped type="integer">0</qtyShipped>
<objID type="integer">81345</objID>
<vsku type="null"/>
<order>/api/v2/orders/81341</order>
<resource_uri>/api/v2/order_lines/81345</resource_uri>
</object>
<object type="hash">
<barcode>7-22430-14016-2</barcode>
<description>GT's, Multi-green - 16 OZ</description>
<item>/api/v2/items/156997</item>
<entityType>SalesOrderLine</entityType>
<ctime>2013-10-04T17:48:20Z</ctime>
<qty type="integer">12</qty>
<dimensions type="null"/>
<cdate>2013-10-04</cdate>
<mtime>2013-10-06T21:06:11Z</mtime>
<owner>Somefirstnamek@somedomain</owner>
<total>0.00</total>
<unitPrice>0.00</unitPrice>
<manufacturer>/api/v2/manufacturers/3</manufacturer>
<sku>401</sku>
<uuid>84264055-738c-4958-a6b8-4c2cb2025806</uuid>
<mtimeOnServer>2013-10-06T21:06:11Z</mtimeOnServer>
<isku>401</isku>
<qtyFree type="integer">0</qtyFree>
<notes/>
<ctimeOnServer>2013-10-04T17:48:37Z</ctimeOnServer>
<qtyShipped type="integer">0</qtyShipped>
<objID type="integer">81346</objID>
<vsku type="null"/>
<order>/api/v2/orders/81341</order>
<resource_uri>/api/v2/order_lines/81346</resource_uri>
</object>
<object type="hash">
<barcode>7-22430-11016-5</barcode>
<description>Synergy, Trilogy - 16 OZ</description>
<item>/api/v2/items/156998</item>
<entityType>SalesOrderLine</entityType>
<ctime>2013-10-04T17:48:20Z</ctime>
<qty type="integer">12</qty>
<dimensions type="null"/>
<cdate>2013-10-04</cdate>
<mtime>2013-10-06T21:06:11Z</mtime>
<owner>Somefirstnamek@somedomain</owner>
<total>0.00</total>
<unitPrice>0.00</unitPrice>
<manufacturer>/api/v2/manufacturers/3</manufacturer>
<sku>402</sku>
<uuid>9e3a7b9f-c573-49d4-ab69-0e7cd13a73b3</uuid>
<mtimeOnServer>2013-10-06T21:06:11Z</mtimeOnServer>
<isku>402</isku>
<qtyFree type="integer">0</qtyFree>
<notes/>
<ctimeOnServer>2013-10-04T17:48:37Z</ctimeOnServer>
<qtyShipped type="integer">0</qtyShipped>
<objID type="integer">81347</objID>
<vsku type="null"/>
<order>/api/v2/orders/81341</order>
<resource_uri>/api/v2/order_lines/81347</resource_uri>
</object>
<object type="hash">
<barcode>7-22430-60016-1</barcode>
<description>Synergy, Gingerberry - 16 OZ</description>
<item>/api/v2/items/157001</item>
<entityType>SalesOrderLine</entityType>
<ctime>2013-10-04T17:48:22Z</ctime>
<qty type="integer">12</qty>
<dimensions type="null"/>
<cdate>2013-10-04</cdate>
<mtime>2013-10-06T21:06:11Z</mtime>
<owner>Somefirstnamek@somedomain</owner>
<total>0.00</total>
<unitPrice>0.00</unitPrice>
<manufacturer>/api/v2/manufacturers/3</manufacturer>
<sku>406</sku>
<uuid>06945e84-56f1-40bb-9f7b-14e87df39bbc</uuid>
<mtimeOnServer>2013-10-06T21:06:11Z</mtimeOnServer>
<isku>406</isku>
<qtyFree type="integer">0</qtyFree>
<notes/>
<ctimeOnServer>2013-10-04T17:48:37Z</ctimeOnServer>
<qtyShipped type="integer">0</qtyShipped>
<objID type="integer">81348</objID>
<vsku type="null"/>
<order>/api/v2/orders/81341</order>
<resource_uri>/api/v2/order_lines/81348</resource_uri>
</object>
<object type="hash">
<barcode>7-22430-00016-9</barcode>
<description>GT's, Original Raw - 16 OZ</description>
<item>/api/v2/items/157002</item>
<entityType>SalesOrderLine</entityType>
<ctime>2013-10-04T17:48:24Z</ctime>
<qty type="integer">12</qty>
<dimensions type="null"/>
<cdate>2013-10-04</cdate>
<mtime>2013-10-06T21:06:11Z</mtime>
<owner>Somefirstnamek@somedomain</owner>
<total>0.00</total>
<unitPrice>0.00</unitPrice>
<manufacturer>/api/v2/manufacturers/3</manufacturer>
<sku>407</sku>
<uuid>92520a73-613c-425c-be19-e8f0d4a27985</uuid>
<mtimeOnServer>2013-10-06T21:06:11Z</mtimeOnServer>
<isku>407</isku>
<qtyFree type="integer">0</qtyFree>
<notes/>
<ctimeOnServer>2013-10-04T17:48:37Z</ctimeOnServer>
<qtyShipped type="integer">0</qtyShipped>
<objID type="integer">81349</objID>
<vsku type="null"/>
<order>/api/v2/orders/81341</order>
<resource_uri>/api/v2/order_lines/81349</resource_uri>
</object>
<object type="hash">
<barcode>0-72050-30070-6</barcode>
<description>Eggs, Cage Free Omega 3 - 1 DOZEN</description>
<item>/api/v2/items/157189</item>
<entityType>SalesOrderLine</entityType>
<ctime>2013-10-04T17:48:05Z</ctime>
<qty type="integer">15</qty>
<dimensions type="null"/>
<cdate>2013-10-04</cdate>
<mtime>2013-10-06T21:06:15Z</mtime>
<owner>Somefirstnamek@somedomain</owner>
<total>0.00</total>
<unitPrice>0.00</unitPrice>
<manufacturer>/api/v2/manufacturers/3</manufacturer>
<sku>29332</sku>
<uuid>cbc4da0a-5f10-4a51-a28f-ac2c141e817c</uuid>
<mtimeOnServer>2013-10-06T21:06:15Z</mtimeOnServer>
<isku>29332</isku>
<qtyFree type="integer">0</qtyFree>
<notes/>
<ctimeOnServer>2013-10-04T17:48:37Z</ctimeOnServer>
<qtyShipped type="integer">0</qtyShipped>
<objID type="integer">81342</objID>
<vsku type="null"/>
<order>/api/v2/orders/81341</order>
<resource_uri>/api/v2/order_lines/81342</resource_uri>
</object>
<object type="hash">
<barcode>0-72050-30080-5</barcode>
<description>Eggs, Cage Free Vitamin D - 1 DOZEN</description>
<item>/api/v2/items/157190</item>
<entityType>SalesOrderLine</entityType>
<ctime>2013-10-04T17:48:06Z</ctime>
<qty type="integer">15</qty>
<dimensions type="null"/>
<cdate>2013-10-04</cdate>
<mtime>2013-10-06T21:06:15Z</mtime>
<owner>Somefirstnamek@somedomain</owner>
<total>0.00</total>
<unitPrice>0.00</unitPrice>
<manufacturer>/api/v2/manufacturers/3</manufacturer>
<sku>29333</sku>
<uuid>e69347d7-ff2a-4912-aad1-9d09639a646b</uuid>
<mtimeOnServer>2013-10-06T21:06:15Z</mtimeOnServer>
<isku>29333</isku>
<qtyFree type="integer">0</qtyFree>
<notes/>
<ctimeOnServer>2013-10-04T17:48:37Z</ctimeOnServer>
<qtyShipped type="integer">0</qtyShipped>
<objID type="integer">81343</objID>
<vsku type="null"/>
<order>/api/v2/orders/81341</order>
<resource_uri>/api/v2/order_lines/81343</resource_uri>
</object>
<object type="hash">
<barcode>0-72050-30090-4</barcode>
<description>Eggs, Cage Free Natural - 1 DOZEN</description>
<item>/api/v2/items/157191</item>
<entityType>SalesOrderLine</entityType>
<ctime>2013-10-04T17:48:07Z</ctime>
<qty type="integer">15</qty>
<dimensions type="null"/>
<cdate>2013-10-04</cdate>
<mtime>2013-10-06T21:06:15Z</mtime>
<owner>Somefirstnamek@somedomain</owner>
<total>0.00</total>
<unitPrice>0.00</unitPrice>
<manufacturer>/api/v2/manufacturers/3</manufacturer>
<sku>29335</sku>
<uuid>ac8279ab-fdbd-44af-9421-0a591ecf593d</uuid>
<mtimeOnServer>2013-10-06T21:06:15Z</mtimeOnServer>
<isku>29335</isku>
<qtyFree type="integer">0</qtyFree>
<notes/>
<ctimeOnServer>2013-10-04T17:48:37Z</ctimeOnServer>
<qtyShipped type="integer">0</qtyShipped>
<objID type="integer">81344</objID>
<vsku type="null"/>
<order>/api/v2/orders/81341</order>
<resource_uri>/api/v2/order_lines/81344</resource_uri>
</object>
</lines>
<cancelDate type="null"/>
<objID type="integer">81341</objID>
<notes/>
<resource_uri>/api/v2/orders/81341</resource_uri>
</object>
ASKER
correct, the mtime i need to grab is the one within
<billTo type="hash">
<btCustomer>/api/v2/custom ers/98969< /btCustome r>
<entityType>Address</entit yType>
<street type="null"/>
<postcode type="null"/>
<mtime>2013-11-08T16:43:43 Z</mtime>
<owner>system</owner>
<id type="null"/>
<city type="null"/>
<uuid>a3e9b1d3-6247-4a21-8 283-69d473 d37824</uu id>
<ctimeOnServer>2013-10-04T 16:31:19Z< /ctimeOnSe rver>
<mtimeOnServer>2013-11-08T 17:29:39Z< /mtimeOnSe rver>
<state type="null"/>
<fax type="null"/>
<isDefaultShipTo type="boolean">False</isDe faultShipT o>
<street2 type="null"/>
<stCustomer type="null"/>
<phone type="null"/>
<cdate>2013-10-04</cdate>
<ctime>2013-10-04T16:31:19 Z</ctime>
<name type="null"/>
<country type="null"/>
<objID type="integer">98970</objI D>
<resource_uri>/api/v2/addr esses/9897 0</resourc e_uri>
</billTo>
<billTo type="hash">
<btCustomer>/api/v2/custom
<entityType>Address</entit
<street type="null"/>
<postcode type="null"/>
<mtime>2013-11-08T16:43:43
<owner>system</owner>
<id type="null"/>
<city type="null"/>
<uuid>a3e9b1d3-6247-4a21-8
<ctimeOnServer>2013-10-04T
<mtimeOnServer>2013-11-08T
<state type="null"/>
<fax type="null"/>
<isDefaultShipTo type="boolean">False</isDe
<street2 type="null"/>
<stCustomer type="null"/>
<phone type="null"/>
<cdate>2013-10-04</cdate>
<ctime>2013-10-04T16:31:19
<name type="null"/>
<country type="null"/>
<objID type="integer">98970</objI
<resource_uri>/api/v2/addr
</billTo>
how do you tie an mtime from billTo to an object in lines?
also, what are the results you get for original file?
If you don't get the expected results posted above then there's no sense pursuing another file.
Both queries work for me. If they don't work for you, please describe exactly what is different between what you're doing and what you posted above.
If you do get the expected results for the original input file, great.
Post similar results for the new file
also, what are the results you get for original file?
If you don't get the expected results posted above then there's no sense pursuing another file.
Both queries work for me. If they don't work for you, please describe exactly what is different between what you're doing and what you posted above.
If you do get the expected results for the original input file, great.
Post similar results for the new file
ASKER
sdstuber, sorry I didnt post the file. I am going to upload the main xml file to a remote directory so that you can access it, I will delete it once solution has been solved.
What i originally posted was one portion of the file for one order. that entire file has about 100 - 150 orders per day over the last 2 months.
right now we have to download the file in CSV format from 3rd party, import to oracle, export CSV file in new format so that we can import into our ERP, if i can get this done from within oracle via XML, i can eliminate that step and completely automate this process.
What I really need from this is each order giving me the data in this format for each order.
actual XML file is here
http://199.237.198.11/EE/o utput.xml
also. right now i am running curl, with my api key to download it to the server where Oracle sits on.
would it be better to run this directly from a URL? or as a local file like i am currently doing.
Additionally, There is various parts that are called mtime on the XML file. the time I am actually looking for, is the order create day. the other mtimes are the create time for the resource (which i do not need in my final output)
from what I understand, the correct time would be the time under
the bill to section
eg
Thanks for all the help
What i originally posted was one portion of the file for one order. that entire file has about 100 - 150 orders per day over the last 2 months.
right now we have to download the file in CSV format from 3rd party, import to oracle, export CSV file in new format so that we can import into our ERP, if i can get this done from within oracle via XML, i can eliminate that step and completely automate this process.
What I really need from this is each order giving me the data in this format for each order.
owner taxid mtime owner sku qty
24233 0 2013-11-11T17:27:36Z johnd@nowhere.com 746 12
24233 0 2013-11-11T17:27:36Z johnd@nowhere.com 748 24
24233 0 2013-11-11T17:27:36Z johnd@nowhere.com 2152 12
24233 0 2013-11-11T17:27:36Z johnd@nowhere.com 2153 12
24233 0 2013-11-11T17:27:36Z johnd@nowhere.com 2361 24
24233 0 2013-11-11T17:27:36Z johnd@nowhere.com 10101 6
24233 0 2013-11-11T17:27:36Z johnd@nowhere.com 10102 6
24233 0 2013-11-11T17:27:36Z johnd@nowhere.com 10103 6
24233 0 2013-11-11T17:27:36Z johnd@nowhere.com 11010 12
24233 0 2013-11-11T17:27:36Z johnd@nowhere.com 700748 24
24233 0 2013-11-11T17:27:36Z johnd@nowhere.com 994 1
actual XML file is here
http://199.237.198.11/EE/o
also. right now i am running curl, with my api key to download it to the server where Oracle sits on.
would it be better to run this directly from a URL? or as a local file like i am currently doing.
Additionally, There is various parts that are called mtime on the XML file. the time I am actually looking for, is the order create day. the other mtimes are the create time for the resource (which i do not need in my final output)
from what I understand, the correct time would be the time under
the bill to section
eg
<billTo type="hash">
<btCustomer>/api/v2/customers/99233</btCustomer>
<entityType>Address</entityType>
<street>77 HUSDON ST</street>
<postcode>07302</postcode>
<mtime>2013-11-07T16:58:10Z</mtime>
<owner>system</owner>
<id type="null"/>
<city>JERSEY CITY</city>
<uuid>2de1c96f-c9b3-44bd-a99c-2aaf9a98d3e5</uuid>
<ctimeOnServer>2013-10-04T16:31:25Z</ctimeOnServer>
<mtimeOnServer>2013-11-07T17:53:56Z</mtimeOnServer>
Thanks for all the help
>> I will delete it once solution has been solved.
All communication for the question should occur within EE itself.
If the link you've provided isn't going to be reliable going forward then it shouldn't be used.
If you can't post a full real file here, that's ok. We don't need the real file. We just need a consistent set of input and output.
>>> What i originally posted was one portion of the file for one order.
That's fine. Did the queries work for you with that file? They did for me. If not, what did you get?
All communication for the question should occur within EE itself.
If the link you've provided isn't going to be reliable going forward then it shouldn't be used.
If you can't post a full real file here, that's ok. We don't need the real file. We just need a consistent set of input and output.
>>> What i originally posted was one portion of the file for one order.
That's fine. Did the queries work for you with that file? They did for me. If not, what did you get?
on second thought, let's simplify. You have lots of nodes you're not interested in, so don't post those.
Just construct an example manually that has what you want and leave out the rest.
I think, based on your previous comments and posts that this is what you want for a single customer with multiple lines
If that is not correct, please adjust.
Let's do ONE, then you can expand that example for 2 customers.
If there is a connection between customers and their lines, please explain what that connection is.
If it's simply order within the xml document I can work with that too
Just construct an example manually that has what you want and leave out the rest.
I think, based on your previous comments and posts that this is what you want for a single customer with multiple lines
<object type="hash">
<customer type="hash">
<id>24233</id>
<taxID>0</taxID>
<billTo type="hash">
<mtime>2013-11-11T17:27:36Z</mtime>
</billTo>
</customer>
<lines type="list">
<object type="hash">
<qty type="integer">12</qty>
<owner>johnd@nowhere.com</owner>
<sku>746</sku>
</object>
<object type="hash">
<qty type="integer">24</qty>
<owner>johnd@nowhere.com</owner>
<sku>748</sku>
</object>
</lines>
</object>
If that is not correct, please adjust.
Let's do ONE, then you can expand that example for 2 customers.
If there is a connection between customers and their lines, please explain what that connection is.
If it's simply order within the xml document I can work with that too
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
A "B" grade is not appropriate
ASKER
that my friend, was a mistake. I always give you an A
ASKER
the fields i really need to pull are
OWNER
CTIME
SKU
taxid
ID
QTY
Open in new window