SQLXML structual schema issue

[admin]

The issue is with the ordering of some elements within then final document>

Element Originator is coming before element OriginManfest.
Element BusinessAddress is coming before StateCode.
Element OutofStateWages is coming out before TotalWages.

As as result, when I send test files to state govenment I get invalid child errors because the previously mentioned elements are out of sequence.

Not being an xml person I have done due digilence in getting this far. All data and elements in the final document are correct except for the sequencing of the mentioned elements. The document is well formed.

A review and advice and direction from anyone using schemas with the xmlns:sql="urn:schemas-microsoft-com:mapping-schema" namespace would be much appreciate.


This is parital view of the schema since it's too long to post:

<?xml version="1.0" encoding="utf-8" ?>
<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:sql="urn:schemas-microsoft-com:mapping-schema"
elementFormDefault = "qualified"
>

<xsd:annotation>
<xsd:appinfo>
<sql:relationship name="EmployeeEmployee"
parent="MRF_FLSuta_Emp" parent-key="SSN"
child="MRF_FLSuta_Emp" child-key="SSN" />

<sql:relationship name="TransHdrTranHdr"
parent="MRF_FLSuta_TranmissionData" parent-key="YrQtr"
child="MRF_FLSuta_TranmissionData" child-key="YrQtr" />

<sql:relationship name="TransHdrEmployee"
parent="MRF_FLSuta_TranmissionData" parent-key="YrQtr"
child="MRF_FLSuta_Emp" child-key="YrQtr" />

</xsd:appinfo>
</xsd:annotation>


<xsd:element name="OriginHeaders" sql:is-constant = "true">
<xsd:complexType>
<xsd:sequence>
<xsd:element name="ReturnOriginHeader" sql:relation="MRF_FLSuta_TranmissionData">
<xsd:complexType>
<xsd:sequence>
<xsd:element name="OriginId" sql:field="OriginId" type="xsd:string" />
<xsd:element name="Timestamp" sql:field="Timestamp" type="xsd:dateTime" />


<xsd:element name="OriginManifest" sql:relation="MRF_FLSuta_TranmissionData" sql:relationship="TransHdrTranHdr">
<xsd:complexType>
<xsd:sequence>
<xsd:element name="ItemReference" maxOccurs="1" sql:relation="MRF_FLSuta_TranmissionData" sql:relationship="TransHdrTranHdr">
<xsd:complexType>
<xsd:attribute name="contentLocation" use="required">
</xsd:attribute>
</xsd:complexType>
</xsd:element>
</xsd:sequence>
<xsd:attribute name="itemCount" type="xsd:integer" use="required">
</xsd:attribute>
</xsd:complexType>
</xsd:element>


<xsd:element name="Originator" sql:relation="MRF_FLSuta_TranmissionData" sql:relationship="TransHdrTranHdr">
<xsd:complexType>
<xsd:sequence>
<xsd:element name="AgentIdentifier" sql:field="AgentIdentifier" type="xsd:string" />
</xsd:sequence>
</xsd:complexType>
</xsd:element>

</xsd:sequence>
</xsd:complexType>
</xsd:element>
</xsd:sequence>
</xsd:complexType>
</xsd:element>










<xsd:element name="Employee" sql:relation="MRF_FLSuta_Emp" sql:relationship="TransHdrEmployee">
<xsd:complexType>
<xsd:sequence>


<xsd:element name="SSN"
sql:field="SSN"
type="xsd:string" />

<xsd:element name="Employee" sql:relation="MRF_FLSuta_Emp"
sql:relationship="EmployeeEmployee">

<xsd:complexType>
<xsd:sequence>


<xsd:element name="SSN" sql:field="SSN"
type="xsd:string" sql:mapped="false"/>

<xsd:element name="FirstName" sql:field="FirstName"
type="xsd:string" />

<xsd:element name="MiddleName" sql:field="MiddleName"
type="xsd:string" />

<xsd:element name="LastName" sql:field="LastName"
type="xsd:string" />

</xsd:sequence>
</xsd:complexType>
</xsd:element>


<xsd:element name="TotalWages" sql:field="TotalWages"
type="xsd:decimal" />
<xsd:element name="TaxableWages" sql:field="TaxableWages"
type="xsd:decimal" />


<xsd:element name="OutOfStateWages" sql:relation="MRF_FLSuta_Emp"
sql:relationship="EmployeeEmployee">

<xsd:complexType>
<xsd:sequence>
<xsd:element name="TotalWages" sql:field="OutofStateTotalWages" type="xsd:decimal"/>
<xsd:element name="TaxableWages" sql:field="OutofStateTaxableWages"
type="xsd:decimal" />
<xsd:element name="TaxState" sql:field="TaxState"
type="xsd:string" />
</xsd:sequence>
</xsd:complexType>

</xsd:element>


</xsd:sequence>
</xsd:complexType>
</xsd:element>