se/SE/schema/ant-object/default_db.DEVICES/DEVICES/DEVICES.xsd

<?xml version="1.0" encoding="UTF-8"?>
<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema"
           xmlns:gml="http://www.opengis.net/gml/3.2"
           xmlns:Types__x3A__default_Default="https://biuro.biall-net.pl/wfs/default_db/Types/Default.xsd"
           xmlns:default_db__x3A__IN7_DZIENNIK_KORESP="https://biuro.biall-net.pl/wfs/default_db/table/IN7_DZIENNIK_KORESP.xsd"
           xmlns:hfp="http://www.w3.org/2001/XMLSchema-hasFacetAndProperty"
           xmlns:default_db__x3A__ADMIN_USERS="https://biuro.biall-net.pl/wfs/default_db/table/ADMIN_USERS.xsd"
           xmlns:default_db__x3A__IN7_MK_BAZA_DYSTRYBUCJI="https://biuro.biall-net.pl/wfs/default_db/table/IN7_MK_BAZA_DYSTRYBUCJI.xsd"
           xmlns:SystemObjects__x3A__AccessGroup="https://biuro.biall-net.pl/wfs/default_db/SystemObjects/AccessGroup.xsd"
           xmlns:SystemObjects__x3A__AccessOwner="https://biuro.biall-net.pl/wfs/default_db/SystemObjects/AccessOwner.xsd"
           xmlns:default_db__x3A__DEVICES="https://biuro.biall-net.pl/wfs/default_db/table/DEVICES.xsd"
           xmlns:fix_se_defaultdb_schema="http://biuro.biall-net.pl/xmlschema_procesy5/WPS_Functions/fix_se_defaultdb_schema/fix_se_defaultdb_schema.xsd"
           xmlns:p5Type="http://biuro.biall-net.pl/p5/schema/types"
           xmlns:default_db__x3A__COMPANIES="https://biuro.biall-net.pl/wfs/default_db/table/COMPANIES.xsd"
           xmlns:default_db__x3A__CRM_LISTA_ZASOBOW="https://biuro.biall-net.pl/wfs/default_db/table/CRM_LISTA_ZASOBOW.xsd"
           xmlns:default_db__x3A__SERVICES="https://biuro.biall-net.pl/wfs/default_db/table/SERVICES.xsd"
           xmlns:default_db__x3A__TELBOXES="https://biuro.biall-net.pl/wfs/default_db/table/TELBOXES.xsd"
           xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
           xmlns:p5_tr_map="http://biuro.biall-net.pl/xmlschema_procesy5/default_db_xml_cache/procesy5_translate_map.xsd"
           xmlns:vc="http://www.w3.org/2007/XMLSchema-versioning"
           xmlns:system_cache__resources_tree_generate_xsl_required_occurs_raport="http://biuro.biall-net.pl/xmlschema_procesy5/system_cache/resources_tree_generate_xsl_require_occurs_raport"
           xmlns:system_cache__appinfo="http://biuro.biall-net.pl/xmlschema_procesy5/default_db_xml_cache/appinfo.xsd"
           xmlns:p5opr="http://biuro.biall-net.pl/xmlschema_procesy5/system_cache/object_parent_relations/object_parent_relations.xsd"
           xmlns:p5_simpleSchema_map="http://biuro.biall-net.pl/xmlschema_procesy5/default_db_xml_cache/p5_simpleSchema_map.xsd"
           xmlns:ant-object="http://biuro.biall-net.pl/xmlschema_procesy5/ant-object/ant-object.xsd"
           xmlns:p5ant-interface="http://biuro.biall-net.pl/xmlschema_procesy5/WPS_Functions/ant_interface/ant_interface.xsd"
           targetNamespace="https://biuro.biall-net.pl/wfs/default_db/table/DEVICES.xsd"
           vc:minVersion="1.1">
   <xs:import namespace="http://biuro.biall-net.pl/p5/schema/types"
              schemaLocation="../../../types.xsd"/>
   <xs:import namespace="http://www.opengis.net/gml/3.2"
              schemaLocation="http://www.opengis.net/gml/3.2"/>
   <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/table/IN7_DZIENNIK_KORESP.xsd"
              schemaLocation="../../default_db.IN7_DZIENNIK_KORESP/IN7_DZIENNIK_KORESP/IN7_DZIENNIK_KORESP.xsd"/>
   <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/table/IN7_MK_BAZA_DYSTRYBUCJI.xsd"
              schemaLocation="../../default_db.IN7_MK_BAZA_DYSTRYBUCJI/IN7_MK_BAZA_DYSTRYBUCJI/IN7_MK_BAZA_DYSTRYBUCJI.xsd"/>
   <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/table/ADMIN_USERS.xsd"
              schemaLocation="../../default_db.ADMIN_USERS/ADMIN_USERS/ADMIN_USERS.xsd"/>
   <xs:import schemaLocation="../../default_db.TELBOXES/TELBOXES/TELBOXES.xsd"
              namespace="https://biuro.biall-net.pl/wfs/default_db/table/TELBOXES.xsd"/>
   <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/table/COMPANIES.xsd"
              schemaLocation="../../default_db.COMPANIES/COMPANIES/COMPANIES.xsd"/>
   <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/table/CRM_LISTA_ZASOBOW.xsd"
              schemaLocation="../../default_db.CRM_LISTA_ZASOBOW/CRM_LISTA_ZASOBOW/CRM_LISTA_ZASOBOW.xsd"/>
   <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/table/SERVICES.xsd"
              schemaLocation="../../default_db.SERVICES/SERVICES/SERVICES.xsd"/>
   <xs:simpleType name="A_STATUS_Type" id="_3A__DEVICES___d18e36928-1_A_STATUS_T">
      <xs:restriction base="xs:string">
         <xs:enumeration value="NORMAL"/>
         <xs:enumeration value="WAITING"/>
         <xs:enumeration value="MONITOR"/>
         <xs:enumeration value="DELETED"/>
         <xs:enumeration value="WARNING"/>
         <xs:enumeration value="OFF_SOFT"/>
         <xs:enumeration value="OFF_HARD"/>
      </xs:restriction>
   </xs:simpleType>
   <xs:simpleType name="T_DEVICE_TYPE" id="_3A__DEVICES___d18e36937-1_T_DEVICE_T">
      <xs:restriction base="xs:string"/>
   </xs:simpleType>
   <xs:simpleType name="T_DEVICE_TYPE_forma" id="_3A__DEVICES___d18e36940-1_T_DEVICE_T">
      <xs:restriction base="default_db__x3A__DEVICES:T_DEVICE_TYPE">
         <xs:enumeration value="FORMA"/>
      </xs:restriction>
   </xs:simpleType>
   <xs:simpleType name="T_DEVICE_TYPE_maszyna" id="_3A__DEVICES___d18e36943-1_T_DEVICE_T">
      <xs:restriction base="default_db__x3A__DEVICES:T_DEVICE_TYPE">
         <xs:enumeration value="MASZYNA"/>
      </xs:restriction>
   </xs:simpleType>
   <xs:complexType name="DEVICES"
                   system_cache__appinfo:primaryKey="ID"
                   id="_3A__DEVICES___d18e36946-1_DEVICES"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
      <xs:annotation>
         <xs:appinfo>
            <system_cache__appinfo:heritage>
               <system_cache__appinfo:inherit system_cache__appinfo:inherit_ref="default_db:DEVICES"
                                              system_cache__appinfo:heritage_acl="true">
                  <system_cache__appinfo:acl_rule_inherit_to_all_same_name_elements_and_refs/>
                  <acl_rule_inherit_to_all_refs_by_primary/>
                  <acl_rule_inherit_to_all_refs_by_local_element system_cache__appinfo:acl_rule_inherit_local_element_name="A_STATUS"/>
               </system_cache__appinfo:inherit>
               <system_cache__appinfo:exherit_all system_cache__appinfo:heritage_acl="true"
                                                  system_cache__appinfo:heritage_sort="true"/>
            </system_cache__appinfo:heritage>
         </xs:appinfo>
      </xs:annotation>
      <xs:sequence id="_3A__DEVICES___d18e36955-1"><!--<xs:element minOccurs="0" ref="SystemObjects__x3A__AccessOwner:AccessOwner"
                     id="a3A__DEVICES___d5e78892-1">
            <xs:annotation>
               <xs:appinfo>
                  <system_cache__appinfo:flat_relation_cache>
                     <system_cache__appinfo:source system_cache__appinfo:name="L_APPOITMENT_USER"
                                                   system_cache__appinfo:xpath="SystemObjects__x3A__AccessOwner:AccessOwner/login"/>
                  </system_cache__appinfo:flat_relation_cache>
               </xs:appinfo>
            </xs:annotation>
         </xs:element>--><!--<xs:element minOccurs="0" ref="SystemObjects__x3A__AccessGroup:AccessGroupRead"
                     id="a3A__DEVICES___d5e78897-1">
            <xs:annotation>
               <xs:appinfo>
                  <system_cache__appinfo:flat_relation_cache>
                     <system_cache__appinfo:source system_cache__appinfo:name="A_CLASSIFIED"
                                                   system_cache__appinfo:xpath="SystemObjects__x3A__AccessGroup:AccessGroupRead/uid"/>
                  </system_cache__appinfo:flat_relation_cache>
               </xs:appinfo>
            </xs:annotation>
         </xs:element>--><!--<xs:element minOccurs="0" ref="SystemObjects__x3A__AccessGroup:AccessGroupWrite"
                     id="a3A__DEVICES___d5e78902-1">
            <xs:annotation>
               <xs:appinfo>
                  <system_cache__appinfo:flat_relation_cache>
                     <system_cache__appinfo:source system_cache__appinfo:name="A_ADM_COMPANY"
                                                   system_cache__appinfo:xpath="SystemObjects__x3A__AccessGroup:AccessGroupWrite/uid"/>
                  </system_cache__appinfo:flat_relation_cache>
               </xs:appinfo>
            </xs:annotation>
         </xs:element>-->
         <xs:element name="ID" type="xs:integer" id="_3A__DEVICES___d18e36959-1_ID"/>
         <xs:element name="PARENT_ID"
                     type="xs:integer"
                     minOccurs="0"
                     id="_3A__DEVICES___d18e36960-1_PARENT_ID"/>
         <xs:element ref="default_db__x3A__DEVICES:DEVICES"
                     minOccurs="0"
                     id="_3A__DEVICES___d18e36961-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
            <xs:annotation>
               <xs:appinfo>
                  <system_cache__appinfo:flat_relation_cache>
                     <system_cache__appinfo:source system_cache__appinfo:name="ID"
                                                   system_cache__appinfo:ref_engine="view"
                                                   system_cache__appinfo:xpath="default_db__x3A__DEVICES:DEVICES/PARENT_ID"/>
                  </system_cache__appinfo:flat_relation_cache>
               </xs:appinfo>
               <xs:documentation>Budujemy drzewo w dół poprzez dzieci</xs:documentation>
            </xs:annotation>
         </xs:element>
         <xs:element minOccurs="0"
                     name="A_RECORD_CREATE_DATE"
                     type="xs:string"
                     id="_3A__DEVICES___d18e36968-1_A_RECORD_C"/>
         <xs:element minOccurs="0"
                     name="A_RECORD_CREATE_AUTHOR"
                     type="xs:string"
                     id="_3A__DEVICES___d18e36969-1_A_RECORD_C"/>
         <xs:element minOccurs="0"
                     name="A_RECORD_UPDATE_DATE"
                     type="xs:string"
                     id="_3A__DEVICES___d18e36970-1_A_RECORD_U"/>
         <xs:element minOccurs="0"
                     name="A_RECORD_UPDATE_AUTHOR"
                     type="xs:string"
                     id="_3A__DEVICES___d18e36971-1_A_RECORD_U"/>
         <xs:element minOccurs="0"
                     name="A_PROBLEM"
                     type="xs:string"
                     id="_3A__DEVICES___d18e36972-1_A_PROBLEM"/>
         <xs:element minOccurs="0"
                     name="A_PROBLEM_DESC"
                     type="xs:string"
                     id="_3A__DEVICES___d18e36974-1_A_PROBLEM_"/>
         <xs:element minOccurs="0"
                     name="A_PROBLEM_DATE"
                     type="xs:string"
                     id="_3A__DEVICES___d18e36975-1_A_PROBLEM_"/>
         <xs:element minOccurs="0"
                     name="A_STATUS"
                     type="xs:string"
                     id="_3A__DEVICES___d18e36976-1_A_STATUS"/>
         <xs:element minOccurs="0"
                     name="A_STATUS_EV"
                     type="xs:string"
                     id="_3A__DEVICES___d18e36977-1_A_STATUS_E"/>
         <xs:element minOccurs="0"
                     name="A_STATUS_INFO"
                     type="xs:string"
                     id="_3A__DEVICES___d18e36978-1_A_STATUS_I"/>
         <xs:element minOccurs="0"
                     name="IN7_DZIENNIK_KORESP_ID"
                     type="xs:integer"
                     id="_3A__DEVICES___d18e36979-1_IN7_DZIENN"/>
         <xs:element ref="default_db__x3A__IN7_DZIENNIK_KORESP:ID_KORESP__FAKTURA__ZAKUP_SPRZETU"
                     minOccurs="0"
                     id="_3A__DEVICES___d18e36980-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
            <xs:annotation>
               <xs:appinfo>
                  <system_cache__appinfo:flat_relation_cache>
                     <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
                                                   system_cache__appinfo:name="IN7_DZIENNIK_KORESP_ID"
                                                   system_cache__appinfo:xpath="default_db__x3A__IN7_DZIENNIK_KORESP:ID_KORESP__FAKTURA__ZAKUP_SPRZETU/ID"/>
                  </system_cache__appinfo:flat_relation_cache>
               </xs:appinfo>
               <xs:documentation>
                    TODO CHECK IF THIS IS CORRECT FLAT RELATION! WAS GENERATED #24995 !!!
                </xs:documentation>
            </xs:annotation>
         </xs:element>
         <xs:element minOccurs="0"
                     name="IN7_DZIENNIK_KORESP_ID_ZAMOWIENIE"
                     type="xs:integer"
                     id="_3A__DEVICES___d18e36987-1_IN7_DZIENN"/>
         <xs:element ref="default_db__x3A__IN7_DZIENNIK_KORESP:ID_KORESP__FAKTURA__ZAKUP_SPRZETU_ZAMOWIENIE"
                     minOccurs="0"
                     id="_3A__DEVICES___d18e36988-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
            <xs:annotation>
               <xs:appinfo>
                  <system_cache__appinfo:flat_relation_cache>
                     <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
                                                   system_cache__appinfo:name="IN7_DZIENNIK_KORESP_ID_ZAMOWIENIE"
                                                   system_cache__appinfo:xpath="default_db__x3A__IN7_DZIENNIK_KORESP:ID_KORESP__FAKTURA__ZAKUP_SPRZETU_ZAMOWIENIE/ID"/>
                  </system_cache__appinfo:flat_relation_cache>
               </xs:appinfo>
            </xs:annotation>
         </xs:element>
         <xs:element minOccurs="0"
                     name="ID_KORESP__FAKTURA__ZAKUP_SPRZETU__PZ"
                     type="xs:int"
                     id="_3A__DEVICES___d18e36993-1_ID_KORESP_"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
            <xs:annotation>
               <xs:documentation>Potwierdzenie, że towar został odebrany poprzez skojarzenie z dokumentem PZ</xs:documentation>
            </xs:annotation>
         </xs:element>
         <xs:element ref="default_db__x3A__IN7_DZIENNIK_KORESP:ID_KORESP__FAKTURA__ZAKUP_SPRZETU__PZ"
                     minOccurs="0"
                     id="_3A__DEVICES___d18e36997-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
            <xs:annotation>
               <xs:appinfo>
                  <system_cache__appinfo:flat_relation_cache>
                     <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
                                                   system_cache__appinfo:name="ID_KORESP__FAKTURA__ZAKUP_SPRZETU__PZ"
                                                   system_cache__appinfo:xpath="default_db__x3A__IN7_DZIENNIK_KORESP:ID_KORESP__FAKTURA__ZAKUP_SPRZETU__PZ/ID"/>
                  </system_cache__appinfo:flat_relation_cache>
               </xs:appinfo>
               <xs:documentation>
                    TODO CHECK IF THIS IS CORRECT FLAT RELATION! WAS GENERATED #245 !!!
                </xs:documentation>
            </xs:annotation>
         </xs:element>
         <xs:element minOccurs="0"
                     name="A_UPDATE_DATE"
                     type="xs:string"
                     id="_3A__DEVICES___d18e37005-1_A_UPDATE_D"/>
         <xs:element minOccurs="0"
                     name="A_ADM_COMPANY"
                     type="xs:string"
                     id="_3A__DEVICES___d18e37006-1_A_ADM_COMP"/>
         <xs:element minOccurs="0"
                     name="S_ADDRESS_CITY"
                     type="xs:string"
                     id="_3A__DEVICES___d18e37007-1_S_ADDRESS_"/>
         <xs:element minOccurs="0"
                     name="S_ADDRESS_POST_CODE"
                     type="xs:string"
                     id="_3A__DEVICES___d18e37008-1_S_ADDRESS_"/>
         <xs:element minOccurs="0"
                     name="S_ADDRESS_POST_OFFICE"
                     type="xs:string"
                     id="_3A__DEVICES___d18e37009-1_S_ADDRESS_"/>
         <xs:element minOccurs="0"
                     name="S_ADDRESS_STREET"
                     type="xs:string"
                     id="_3A__DEVICES___d18e37010-1_S_ADDRESS_"/>
         <xs:element minOccurs="0"
                     name="S_ADDRESS_HOUSE"
                     type="xs:string"
                     id="_3A__DEVICES___d18e37011-1_S_ADDRESS_"/>
         <xs:element minOccurs="0"
                     name="S_OTHER_INFO"
                     type="xs:string"
                     id="_3A__DEVICES___d18e37012-1_S_OTHER_IN"/>
         <xs:element minOccurs="0"
                     name="S_IP"
                     type="xs:string"
                     id="_3A__DEVICES___d18e37013-1_S_IP"/>
         <xs:element minOccurs="0"
                     name="T_NETWORK_SERVER"
                     type="xs:string"
                     id="_3A__DEVICES___d18e37014-1_T_NETWORK_"/>
         <xs:element minOccurs="0"
                     name="T_TOPOLOGY_PLACE"
                     type="xs:string"
                     id="_3A__DEVICES___d18e37015-1_T_TOPOLOGY"/>
         <xs:element minOccurs="0"
                     name="T_DEVICE_SERIAL"
                     type="xs:string"
                     id="_3A__DEVICES___d18e37017-1_T_DEVICE_S"/>
         <xs:element minOccurs="0"
                     name="T_DEVICE_TYPE"
                     type="default_db__x3A__DEVICES:T_DEVICE_TYPE"
                     id="_3A__DEVICES___d18e37018-1_T_DEVICE_T"/>
         <xs:element minOccurs="0"
                     name="T_DEVICE_PORTS_OK"
                     type="xs:integer"
                     id="_3A__DEVICES___d18e37019-1_T_DEVICE_P"/>
         <xs:element minOccurs="0"
                     name="T_DEVICE_INFO"
                     type="xs:string"
                     id="_3A__DEVICES___d18e37020-1_T_DEVICE_I"/>
         <xs:element minOccurs="0"
                     name="T_DEVICE_POWER"
                     type="xs:string"
                     id="_3A__DEVICES___d18e37021-1_T_DEVICE_P"/>
         <xs:element minOccurs="0"
                     name="T_TELBOX_NEIGHBOUR_IN"
                     type="xs:string"
                     id="_3A__DEVICES___d18e37022-1_T_TELBOX_N"/>
         <xs:element minOccurs="0"
                     name="T_TELBOX_NEIGHBOUR_IN_ID"
                     type="xs:integer"
                     id="_3A__DEVICES___d18e37023-1_T_TELBOX_N"/>
         <xs:element minOccurs="0"
                     ref="default_db__x3A__TELBOXES:T_TELBOX_NEIGHBOUR_IN_ID"
                     id="_3A__DEVICES___d18e37024-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
            <xs:annotation>
               <xs:appinfo>
                  <system_cache__appinfo:flat_relation_cache>
                     <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
                                                   system_cache__appinfo:name="T_TELBOX_NEIGHBOUR_IN_ID"
                                                   system_cache__appinfo:xpath="default_db__x3A__TELBOXES:T_TELBOX_NEIGHBOUR_IN_ID/ID"/>
                  </system_cache__appinfo:flat_relation_cache>
               </xs:appinfo>
               <xs:documentation>
                    TODO CHECK IF THIS IS CORRECT FLAT RELATION! WAS GENERATED #2225 !!!
                </xs:documentation>
            </xs:annotation>
         </xs:element>
         <xs:element minOccurs="0"
                     name="the_geom"
                     type="p5Type:polygon"
                     id="_3A__DEVICES___d18e37031-1_the_geom"/>
         <xs:element minOccurs="0"
                     name="T_WORKPOINTS"
                     type="xs:string"
                     id="_3A__DEVICES___d18e37032-1_T_WORKPOIN"/>
         <xs:element minOccurs="0"
                     name="T_WORKPOINTS_VALUE"
                     type="xs:string"
                     id="_3A__DEVICES___d18e37033-1_T_WORKPOIN"/>
         <xs:element minOccurs="0"
                     name="T_WORKPOINTS_TYPE"
                     type="xs:string"
                     id="_3A__DEVICES___d18e37035-1_T_WORKPOIN"/>
         <xs:element minOccurs="0"
                     name="T_WORKPOINTS_USER"
                     type="xs:string"
                     id="_3A__DEVICES___d18e37036-1_T_WORKPOIN"/>
         <xs:element minOccurs="0"
                     name="T_WORKPOINTS_DATE"
                     type="xs:string"
                     id="_3A__DEVICES___d18e37037-1_T_WORKPOIN"/>
         <xs:element minOccurs="0"
                     name="T_PENALTIES"
                     type="xs:string"
                     id="_3A__DEVICES___d18e37038-1_T_PENALTIE"/>
         <xs:element minOccurs="0"
                     name="T_PENALTIES_TYPE"
                     type="xs:string"
                     id="_3A__DEVICES___d18e37039-1_T_PENALTIE"/>
         <xs:element minOccurs="0"
                     name="T_PENALTIES_VALUE"
                     type="xs:string"
                     id="_3A__DEVICES___d18e37040-1_T_PENALTIE"/>
         <xs:element minOccurs="0"
                     name="T_WHO_CONNECTED"
                     type="xs:string"
                     id="_3A__DEVICES___d18e37041-1_T_WHO_CONN"/>
         <xs:element minOccurs="0"
                     name="T_WHEN_CONNECTED"
                     type="xs:string"
                     id="_3A__DEVICES___d18e37042-1_T_WHEN_CON"/>
         <xs:element minOccurs="0"
                     name="T_PRODUCER"
                     type="xs:string"
                     id="_3A__DEVICES___d18e37043-1_T_PRODUCER"/>
         <xs:element minOccurs="0"
                     name="T_PRODUCTION_DATE"
                     type="xs:string"
                     id="_3A__DEVICES___d18e37044-1_T_PRODUCTI"/>
         <xs:element minOccurs="0"
                     name="T_BUY_DATE"
                     type="xs:token"
                     id="_3A__DEVICES___d18e37045-1_T_BUY_DATE"/>
         <xs:element minOccurs="0"
                     name="T_SELLER"
                     type="xs:string"
                     id="_3A__DEVICES___d18e37047-1_T_SELLER"/>
         <xs:element minOccurs="0"
                     name="T_OWNER"
                     type="xs:string"
                     id="_3A__DEVICES___d18e37048-1_T_OWNER"/>
         <xs:element minOccurs="0"
                     name="T_GUARRANTY_EXPIRE"
                     type="xs:string"
                     id="_3A__DEVICES___d18e37049-1_T_GUARRANT"/>
         <xs:element minOccurs="0"
                     name="T_PAPERBOX_LOCATION"
                     type="xs:string"
                     id="_3A__DEVICES___d18e37050-1_T_PAPERBOX"/>
         <xs:element minOccurs="0"
                     name="F_BILL_DATE"
                     type="xs:token"
                     id="_3A__DEVICES___d18e37051-1_F_BILL_DAT"/>
         <xs:element minOccurs="0"
                     name="F_BILL_NUMBER"
                     type="xs:string"
                     id="_3A__DEVICES___d18e37052-1_F_BILL_NUM"/>
         <xs:element minOccurs="0"
                     name="F_BILL_POSITION"
                     type="xs:string"
                     id="_3A__DEVICES___d18e37053-1_F_BILL_POS"/>
         <xs:element minOccurs="0"
                     name="F_BILL_COST"
                     type="xs:double"
                     id="_3A__DEVICES___d18e37054-1_F_BILL_COS"/>
         <xs:element minOccurs="0"
                     name="F_MONTHLY_LEASE_COST"
                     type="xs:double"
                     id="_3A__DEVICES___d18e37055-1_F_MONTHLY_"/>
         <xs:element minOccurs="0"
                     name="F_DEPTECIATION_LENGTH_YEARS"
                     type="xs:string"
                     id="_3A__DEVICES___d18e37056-1_F_DEPTECIA"/>
         <xs:element minOccurs="0"
                     name="S_HW"
                     type="xs:string"
                     id="_3A__DEVICES___d18e37057-1_S_HW"/>
         <xs:element minOccurs="0"
                     name="CRM_LISTA_ZASOBOW_ID"
                     type="xs:integer"
                     id="_3A__DEVICES___d18e37059-1_CRM_LISTA_"/>
         <xs:element minOccurs="0"
                     ref="default_db__x3A__CRM_LISTA_ZASOBOW:CRM_LISTA_ZASOBOW_ID"
                     id="_3A__DEVICES___d18e37060-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
            <xs:annotation>
               <xs:appinfo>
                  <system_cache__appinfo:flat_relation_cache>
                     <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
                                                   system_cache__appinfo:name="CRM_LISTA_ZASOBOW_ID"
                                                   system_cache__appinfo:xpath="default_db__x3A__CRM_LISTA_ZASOBOW:CRM_LISTA_ZASOBOW_ID/ID"/>
                  </system_cache__appinfo:flat_relation_cache>
               </xs:appinfo>
               <xs:documentation>
                    TODO CHECK IF THIS IS CORRECT FLAT RELATION! WAS GENERATED #224
                </xs:documentation>
            </xs:annotation>
         </xs:element>
         <xs:element minOccurs="0"
                     name="CRM_LISTA_ZASOBOW_xpath"
                     type="xs:string"
                     id="_3A__DEVICES___d18e37067-1_CRM_LISTA_"/>
         <xs:element minOccurs="0"
                     name="ID_PROJECT"
                     type="xs:integer"
                     id="_3A__DEVICES___d18e37068-1_ID_PROJECT"/>
         <xs:element minOccurs="0"
                     ref="default_db__x3A__IN7_MK_BAZA_DYSTRYBUCJI:ID_PROJECT"
                     id="_3A__DEVICES___d18e37069-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
            <xs:annotation>
               <xs:appinfo>
                  <system_cache__appinfo:flat_relation_cache>
                     <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
                                                   system_cache__appinfo:name="ID_PROJECT"
                                                   system_cache__appinfo:xpath="default_db__x3A__IN7_MK_BAZA_DYSTRYBUCJI:ID_PROJECT/ID"/>
                  </system_cache__appinfo:flat_relation_cache>
               </xs:appinfo>
               <xs:documentation>
                    TODO CHECK IF THIS IS CORRECT FLAT RELATION! WAS GENERATED #204
                </xs:documentation>
            </xs:annotation>
         </xs:element>
         <xs:element minOccurs="0"
                     name="L_APPOITMENT_DATE"
                     type="xs:string"
                     id="_3A__DEVICES___d18e37076-1_L_APPOITME"/>
         <xs:element minOccurs="0"
                     name="L_APPOITMENT_USER"
                     type="xs:string"
                     id="_3A__DEVICES___d18e37077-1_L_APPOITME"/>
         <xs:element minOccurs="0"
                     ref="default_db__x3A__ADMIN_USERS:L_APPOITMENT_USER"
                     id="_3A__DEVICES___d18e37078-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
            <xs:annotation>
               <xs:appinfo>
                  <system_cache__appinfo:flat_relation_cache>
                     <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
                                                   system_cache__appinfo:name="L_APPOITMENT_USER"
                                                   system_cache__appinfo:xpath="default_db__x3A__ADMIN_USERS:L_APPOITMENT_USER/ADM_ACCOUNT"/>
                  </system_cache__appinfo:flat_relation_cache>
               </xs:appinfo>
               <xs:documentation>
                    TODO CHECK IF THIS IS CORRECT FLAT RELATION! WAS GENERATED #166
                </xs:documentation>
            </xs:annotation>
         </xs:element>
         <xs:element minOccurs="0"
                     name="L_APPOITMENT_PERIOD"
                     type="xs:string"
                     id="_3A__DEVICES___d18e37085-1_L_APPOITME"/>
         <xs:element minOccurs="0"
                     name="L_APPOITMENT_INFO"
                     type="xs:string"
                     id="_3A__DEVICES___d18e37086-1_L_APPOITME"/>
         <xs:element minOccurs="0"
                     name="L_APPOITMENT_TYPE"
                     type="xs:string"
                     id="_3A__DEVICES___d18e37087-1_L_APPOITME"/>
         <xs:element minOccurs="0"
                     name="L_CALENDAR"
                     type="xs:string"
                     id="_3A__DEVICES___d18e37089-1_L_CALENDAR"/>
         <xs:element minOccurs="0"
                     name="P_ACCOUNT"
                     type="xs:string"
                     id="_3A__DEVICES___d18e37090-1_P_ACCOUNT"/>
         <xs:element minOccurs="0"
                     name="ID_BILLING_USERS"
                     type="xs:integer"
                     id="_3A__DEVICES___d18e37091-1_ID_BILLING"/>
         <xs:element minOccurs="0"
                     ref="default_db__x3A__COMPANIES:ID_BILLING_USERS"
                     id="_3A__DEVICES___d18e37092-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
            <xs:annotation>
               <xs:appinfo>
                  <system_cache__appinfo:flat_relation_cache>
                     <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
                                                   system_cache__appinfo:name="ID_BILLING_USERS"
                                                   system_cache__appinfo:xpath="default_db__x3A__COMPANIES:ID_BILLING_USERS/ID"/>
                  </system_cache__appinfo:flat_relation_cache>
               </xs:appinfo>
            </xs:annotation>
         </xs:element>
         <xs:element minOccurs="0"
                     name="ID_SERVICES"
                     type="xs:integer"
                     id="_3A__DEVICES___d18e37097-1_ID_SERVICE"/>
         <xs:element minOccurs="0"
                     ref="default_db__x3A__SERVICES:SERVICES"
                     id="_3A__DEVICES___d18e37098-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
            <xs:annotation>
               <xs:appinfo>
                  <system_cache__appinfo:flat_relation_cache>
                     <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
                                                   system_cache__appinfo:name="ID_SERVICES"
                                                   system_cache__appinfo:xpath="default_db__x3A__SERVICES:SERVICES/ID"/>
                  </system_cache__appinfo:flat_relation_cache>
               </xs:appinfo>
            </xs:annotation>
         </xs:element>
         <xs:element minOccurs="0"
                     name="A_CLASSIFIED"
                     type="xs:string"
                     id="_3A__DEVICES___d18e37103-1_A_CLASSIFI"/>
         <xs:element minOccurs="0"
                     name="ADM_PASSWD"
                     type="xs:string"
                     id="_3A__DEVICES___d18e37104-1_ADM_PASSWD"/>
         <xs:element minOccurs="0"
                     name="S_PASSWD"
                     type="xs:string"
                     id="_3A__DEVICES___d18e37105-1_S_PASSWD"/>
         <xs:element minOccurs="0"
                     name="ADMIN_USERS_ID"
                     type="xs:integer"
                     id="_3A__DEVICES___d18e37106-1_ADMIN_USER"/>
         <xs:element minOccurs="0"
                     ref="default_db__x3A__ADMIN_USERS:ADMIN_USERS_ID"
                     id="_3A__DEVICES___d18e37107-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
            <xs:annotation>
               <xs:appinfo>
                  <system_cache__appinfo:flat_relation_cache>
                     <system_cache__appinfo:source system_cache__appinfo:name="ADMIN_USERS_ID"
                                                   system_cache__appinfo:ref_engine="view"
                                                   system_cache__appinfo:xpath="default_db__x3A__ADMIN_USERS:ADMIN_USERS_ID/ID"/>
                  </system_cache__appinfo:flat_relation_cache>
               </xs:appinfo>
               <xs:documentation>Osoba odpowiedzialna</xs:documentation>
            </xs:annotation>
         </xs:element>
         <!--<xs:element  minOccurs="0" ref="default_db__x3A__ADMIN_USERS:ADMIN_USERS" maxOccurs="1" minOccurs="0">
            <xs:annotation>
               <xs:appinfo>
                  <system_cache__appinfo:flat_relation_cache>
                     <system_cache__appinfo:source system_cache__appinfo:name="ADMIN_USERS_ID" system_cache__appinfo:ref_engine="view" system_cache__appinfo:xpath="default_db__x3A__ADMIN_USERS:ADMIN_USERS/ID"/>
                  </system_cache__appinfo:flat_relation_cache>
               </xs:appinfo>
            </xs:annotation>
         </xs:element> dodatk? po co -->
         <xs:element maxOccurs="unbounded"
                     minOccurs="0"
                     ref="default_db__x3A__IN7_DZIENNIK_KORESP:ID_KORESP__DOWOD_PRZECHOWANIA"
                     id="_3A__DEVICES___d18e37116-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
            <xs:annotation>
               <xs:appinfo>
                  <system_cache__appinfo:flat_relation_cache system_cache__appinfo:backref_evaluate="true"/>
               </xs:appinfo>
               <xs:documentation>Może być wiele przechowań, lecz nie w jednym czasie. Wydania z przechowania zeruja stan wydania na przechowanie - TODO konsultacje mechanizmu, backref</xs:documentation>
            </xs:annotation>
         </xs:element>
         <xs:element maxOccurs="unbounded"
                     minOccurs="0"
                     ref="default_db__x3A__IN7_DZIENNIK_KORESP:ID_KORESP__DOWOD_PRZECHOWANIA_WYDANIA"
                     id="_3A__DEVICES___d18e37122-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
            <xs:annotation>
               <xs:appinfo>
                  <system_cache__appinfo:flat_relation_cache system_cache__appinfo:backref_evaluate="true"/>
               </xs:appinfo>
               <xs:documentation>Może być wiele przechowań, lecz nie w jednym czasie. Wydania z przechowania zeruja stan wydania na przechowanie - TODO konsultacje mechanizmu, backref</xs:documentation>
            </xs:annotation>
         </xs:element>
      </xs:sequence>
      <xs:attribute name="label" type="xs:string" id="_3A__DEVICES___d18e37128-1_label"/>
      <xs:assert test="@label = concat(ID, ' ', T_DEVICE_TYPE)"
                 id="_3A__DEVICES___d18e37129-1"/>
      <xs:assert test="T_SELLER = default_db__x3A__IN7_DZIENNIK_KORESP:ID_KORESP__FAKTURA__ZAKUP_SPRZETU/K_OD_KOGO"
                 id="_3A__DEVICES___d18e37130-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
         <xs:annotation>
            <xs:documentation>Cache - sprzedawca  = firma powiazana z faktura</xs:documentation>
         </xs:annotation>
      </xs:assert>
      <xs:assert test="T_BUY_DATE = default_db__x3A__IN7_DZIENNIK_KORESP:ID_KORESP__FAKTURA__ZAKUP_SPRZETU/K_DATA_OTRZYMANEJ_KORESP"
                 id="_3A__DEVICES___d18e37134-1"/>
      <xs:assert test="F_BILL_NUMBER = default_db__x3A__IN7_DZIENNIK_KORESP:ID_KORESP__FAKTURA__ZAKUP_SPRZETU/K_NR_OTRZYM_KORESP"
                 id="_3A__DEVICES___d18e37135-1"/>
   </xs:complexType>
   <xs:element name="DEVICES"
               type="default_db__x3A__DEVICES:DEVICES"
               id="_3A__DEVICES___d18e37136-1_DEVICES"/>
   <xs:complexType name="DEVICES__DO_ZAMOWIENIA"
                   system_cache__appinfo:primaryKey="ID"
                   id="_3A__DEVICES___d18e37137-1_DEVICES__D"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
      <xs:annotation>
         <xs:documentation>Urządzenia do zamowienia - nie posiadaja powiazanych danych o fakturze i zamowieniu oraz zwlaszcza PZ</xs:documentation>
      </xs:annotation>
      <xs:complexContent id="_3A__DEVICES___d18e37141-1">
         <xs:restriction base="default_db__x3A__DEVICES:DEVICES">
            <xs:sequence id="_3A__DEVICES___d18e37143-1"><!--<xs:element minOccurs="0" ref="SystemObjects__x3A__AccessOwner:AccessOwner"
                     id="a3A__DEVICES___d5e78892-1">
            <xs:annotation>
               <xs:appinfo>
                  <system_cache__appinfo:flat_relation_cache>
                     <system_cache__appinfo:source system_cache__appinfo:name="L_APPOITMENT_USER"
                                                   system_cache__appinfo:xpath="SystemObjects__x3A__AccessOwner:AccessOwner/login"/>
                  </system_cache__appinfo:flat_relation_cache>
               </xs:appinfo>
            </xs:annotation>
         </xs:element>--><!--<xs:element minOccurs="0" ref="SystemObjects__x3A__AccessGroup:AccessGroupRead"
                     id="a3A__DEVICES___d5e78897-1">
            <xs:annotation>
               <xs:appinfo>
                  <system_cache__appinfo:flat_relation_cache>
                     <system_cache__appinfo:source system_cache__appinfo:name="A_CLASSIFIED"
                                                   system_cache__appinfo:xpath="SystemObjects__x3A__AccessGroup:AccessGroupRead/uid"/>
                  </system_cache__appinfo:flat_relation_cache>
               </xs:appinfo>
            </xs:annotation>
         </xs:element>--><!--<xs:element minOccurs="0" ref="SystemObjects__x3A__AccessGroup:AccessGroupWrite"
                     id="a3A__DEVICES___d5e78902-1">
            <xs:annotation>
               <xs:appinfo>
                  <system_cache__appinfo:flat_relation_cache>
                     <system_cache__appinfo:source system_cache__appinfo:name="A_ADM_COMPANY"
                                                   system_cache__appinfo:xpath="SystemObjects__x3A__AccessGroup:AccessGroupWrite/uid"/>
                  </system_cache__appinfo:flat_relation_cache>
               </xs:appinfo>
            </xs:annotation>
         </xs:element>-->
               <xs:element name="ID" type="xs:integer" id="_3A__DEVICES___d18e37147-1_ID"/>
               <xs:element name="PARENT_ID"
                           type="xs:integer"
                           minOccurs="0"
                           id="_3A__DEVICES___d18e37148-1_PARENT_ID"/>
               <xs:element ref="default_db__x3A__DEVICES:DEVICES"
                           minOccurs="0"
                           id="_3A__DEVICES___d18e37149-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:name="ID"
                                                         system_cache__appinfo:ref_engine="view"
                                                         system_cache__appinfo:xpath="default_db__x3A__DEVICES:DEVICES/PARENT_ID"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                  </xs:annotation>
               </xs:element>
               <xs:element minOccurs="0"
                           name="A_RECORD_CREATE_DATE"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37154-1_A_RECORD_C"/>
               <xs:element minOccurs="0"
                           name="A_RECORD_CREATE_AUTHOR"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37155-1_A_RECORD_C"/>
               <xs:element minOccurs="0"
                           name="A_RECORD_UPDATE_DATE"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37156-1_A_RECORD_U"/>
               <xs:element minOccurs="0"
                           name="A_RECORD_UPDATE_AUTHOR"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37157-1_A_RECORD_U"/>
               <xs:element minOccurs="0"
                           name="A_PROBLEM"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37158-1_A_PROBLEM"/>
               <xs:element minOccurs="0"
                           name="A_PROBLEM_DESC"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37160-1_A_PROBLEM_"/>
               <xs:element minOccurs="0"
                           name="A_PROBLEM_DATE"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37161-1_A_PROBLEM_"/>
               <xs:element minOccurs="0"
                           name="A_STATUS"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37162-1_A_STATUS"/>
               <xs:element minOccurs="0"
                           name="A_STATUS_EV"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37163-1_A_STATUS_E"/>
               <xs:element minOccurs="0"
                           name="A_STATUS_INFO"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37164-1_A_STATUS_I"/>
               <xs:element minOccurs="0"
                           name="IN7_DZIENNIK_KORESP_ID"
                           type="xs:integer"
                           maxOccurs="0"
                           id="_3A__DEVICES___d18e37165-1_IN7_DZIENN"/>
               <xs:element ref="default_db__x3A__IN7_DZIENNIK_KORESP:ID_KORESP__FAKTURA__ZAKUP_SPRZETU"
                           minOccurs="0"
                           maxOccurs="0"
                           id="_3A__DEVICES___d18e37166-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
                                                         system_cache__appinfo:name="IN7_DZIENNIK_KORESP_ID"
                                                         system_cache__appinfo:xpath="default_db__x3A__IN7_DZIENNIK_KORESP:ID_KORESP__FAKTURA__ZAKUP_SPRZETU/ID"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                     <xs:documentation>
                    TODO CHECK IF THIS IS CORRECT FLAT RELATION! WAS GENERATED #24995 !!!
                </xs:documentation>
                  </xs:annotation>
               </xs:element>
               <xs:element minOccurs="0"
                           name="IN7_DZIENNIK_KORESP_ID_ZAMOWIENIE"
                           type="xs:integer"
                           maxOccurs="0"
                           id="_3A__DEVICES___d18e37173-1_IN7_DZIENN"/>
               <xs:element ref="default_db__x3A__IN7_DZIENNIK_KORESP:ID_KORESP__FAKTURA__ZAKUP_SPRZETU_ZAMOWIENIE"
                           minOccurs="0"
                           maxOccurs="0"
                           id="_3A__DEVICES___d18e37174-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
                                                         system_cache__appinfo:name="IN7_DZIENNIK_KORESP_ID_ZAMOWIENIE"
                                                         system_cache__appinfo:xpath="default_db__x3A__IN7_DZIENNIK_KORESP:ID_KORESP__FAKTURA__ZAKUP_SPRZETU_ZAMOWIENIE/ID"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                  </xs:annotation>
               </xs:element>
               <xs:element minOccurs="0"
                           name="ID_KORESP__FAKTURA__ZAKUP_SPRZETU__PZ"
                           type="xs:int"
                           maxOccurs="0"
                           id="_3A__DEVICES___d18e37179-1_ID_KORESP_"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
                  <xs:annotation>
                     <xs:documentation>Potwierdzenie, że towar został odebrany poprzez skojarzenie z dokumentem PZ</xs:documentation>
                  </xs:annotation>
               </xs:element>
               <xs:element ref="default_db__x3A__IN7_DZIENNIK_KORESP:ID_KORESP__FAKTURA__ZAKUP_SPRZETU__PZ"
                           maxOccurs="0"
                           minOccurs="0"
                           id="_3A__DEVICES___d18e37183-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
                                                         system_cache__appinfo:name="ID_KORESP__FAKTURA__ZAKUP_SPRZETU__PZ"
                                                         system_cache__appinfo:xpath="default_db__x3A__IN7_DZIENNIK_KORESP:ID_KORESP__FAKTURA__ZAKUP_SPRZETU__PZ/ID"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                     <xs:documentation>
                    TODO CHECK IF THIS IS CORRECT FLAT RELATION! WAS GENERATED #245 !!!
                </xs:documentation>
                  </xs:annotation>
               </xs:element>
               <xs:element minOccurs="0"
                           name="A_UPDATE_DATE"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37191-1_A_UPDATE_D"/>
               <xs:element minOccurs="0"
                           name="A_ADM_COMPANY"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37192-1_A_ADM_COMP"/>
               <xs:element minOccurs="0"
                           name="S_ADDRESS_CITY"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37193-1_S_ADDRESS_"/>
               <xs:element minOccurs="0"
                           name="S_ADDRESS_POST_CODE"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37194-1_S_ADDRESS_"/>
               <xs:element minOccurs="0"
                           name="S_ADDRESS_POST_OFFICE"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37195-1_S_ADDRESS_"/>
               <xs:element minOccurs="0"
                           name="S_ADDRESS_STREET"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37196-1_S_ADDRESS_"/>
               <xs:element minOccurs="0"
                           name="S_ADDRESS_HOUSE"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37197-1_S_ADDRESS_"/>
               <xs:element minOccurs="0"
                           name="S_OTHER_INFO"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37198-1_S_OTHER_IN"/>
               <xs:element minOccurs="0"
                           name="S_IP"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37199-1_S_IP"/>
               <xs:element minOccurs="0"
                           name="T_NETWORK_SERVER"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37200-1_T_NETWORK_"/>
               <xs:element minOccurs="0"
                           name="T_TOPOLOGY_PLACE"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37201-1_T_TOPOLOGY"/>
               <xs:element minOccurs="0"
                           name="T_DEVICE_SERIAL"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37203-1_T_DEVICE_S"/>
               <xs:element minOccurs="0"
                           name="T_DEVICE_TYPE"
                           type="default_db__x3A__DEVICES:T_DEVICE_TYPE"
                           id="_3A__DEVICES___d18e37204-1_T_DEVICE_T"/>
               <xs:element minOccurs="0"
                           name="T_DEVICE_PORTS_OK"
                           type="xs:integer"
                           id="_3A__DEVICES___d18e37205-1_T_DEVICE_P"/>
               <xs:element minOccurs="0"
                           name="T_DEVICE_INFO"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37206-1_T_DEVICE_I"/>
               <xs:element minOccurs="0"
                           name="T_DEVICE_POWER"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37207-1_T_DEVICE_P"/>
               <xs:element minOccurs="0"
                           name="T_TELBOX_NEIGHBOUR_IN"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37208-1_T_TELBOX_N"/>
               <xs:element minOccurs="0"
                           name="T_TELBOX_NEIGHBOUR_IN_ID"
                           type="xs:integer"
                           id="_3A__DEVICES___d18e37209-1_T_TELBOX_N"/>
               <xs:element minOccurs="0"
                           ref="default_db__x3A__TELBOXES:T_TELBOX_NEIGHBOUR_IN_ID"
                           id="_3A__DEVICES___d18e37210-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
                                                         system_cache__appinfo:name="T_TELBOX_NEIGHBOUR_IN_ID"
                                                         system_cache__appinfo:xpath="default_db__x3A__TELBOXES:T_TELBOX_NEIGHBOUR_IN_ID/ID"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                     <xs:documentation>
                    TODO CHECK IF THIS IS CORRECT FLAT RELATION! WAS GENERATED #2225 !!!
                </xs:documentation>
                  </xs:annotation>
               </xs:element>
               <xs:element minOccurs="0"
                           name="the_geom"
                           type="p5Type:polygon"
                           id="_3A__DEVICES___d18e37217-1_the_geom"/>
               <xs:element minOccurs="0"
                           name="T_WORKPOINTS"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37218-1_T_WORKPOIN"/>
               <xs:element minOccurs="0"
                           name="T_WORKPOINTS_VALUE"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37219-1_T_WORKPOIN"/>
               <xs:element minOccurs="0"
                           name="T_WORKPOINTS_TYPE"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37221-1_T_WORKPOIN"/>
               <xs:element minOccurs="0"
                           name="T_WORKPOINTS_USER"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37222-1_T_WORKPOIN"/>
               <xs:element minOccurs="0"
                           name="T_WORKPOINTS_DATE"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37223-1_T_WORKPOIN"/>
               <xs:element minOccurs="0"
                           name="T_PENALTIES"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37224-1_T_PENALTIE"/>
               <xs:element minOccurs="0"
                           name="T_PENALTIES_TYPE"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37225-1_T_PENALTIE"/>
               <xs:element minOccurs="0"
                           name="T_PENALTIES_VALUE"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37226-1_T_PENALTIE"/>
               <xs:element minOccurs="0"
                           name="T_WHO_CONNECTED"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37227-1_T_WHO_CONN"/>
               <xs:element minOccurs="0"
                           name="T_WHEN_CONNECTED"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37228-1_T_WHEN_CON"/>
               <xs:element minOccurs="0"
                           name="T_PRODUCER"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37229-1_T_PRODUCER"/>
               <xs:element minOccurs="0"
                           name="T_PRODUCTION_DATE"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37230-1_T_PRODUCTI"/>
               <xs:element minOccurs="0"
                           name="T_BUY_DATE"
                           type="xs:token"
                           id="_3A__DEVICES___d18e37231-1_T_BUY_DATE"/>
               <xs:element minOccurs="0"
                           name="T_SELLER"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37233-1_T_SELLER"/>
               <xs:element minOccurs="0"
                           name="T_OWNER"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37234-1_T_OWNER"/>
               <xs:element minOccurs="0"
                           name="T_GUARRANTY_EXPIRE"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37235-1_T_GUARRANT"/>
               <xs:element minOccurs="0"
                           name="T_PAPERBOX_LOCATION"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37236-1_T_PAPERBOX"/>
               <xs:element minOccurs="0"
                           name="F_BILL_DATE"
                           type="xs:token"
                           id="_3A__DEVICES___d18e37237-1_F_BILL_DAT"/>
               <xs:element minOccurs="0"
                           name="F_BILL_NUMBER"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37238-1_F_BILL_NUM"/>
               <xs:element minOccurs="0"
                           name="F_BILL_POSITION"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37239-1_F_BILL_POS"/>
               <xs:element minOccurs="0"
                           name="F_BILL_COST"
                           type="xs:double"
                           id="_3A__DEVICES___d18e37240-1_F_BILL_COS"/>
               <xs:element minOccurs="0"
                           name="F_MONTHLY_LEASE_COST"
                           type="xs:double"
                           id="_3A__DEVICES___d18e37241-1_F_MONTHLY_"/>
               <xs:element minOccurs="0"
                           name="F_DEPTECIATION_LENGTH_YEARS"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37242-1_F_DEPTECIA"/>
               <xs:element minOccurs="0"
                           name="S_HW"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37243-1_S_HW"/>
               <xs:element minOccurs="0"
                           name="CRM_LISTA_ZASOBOW_ID"
                           type="xs:integer"
                           id="_3A__DEVICES___d18e37245-1_CRM_LISTA_"/>
               <xs:element minOccurs="0"
                           ref="default_db__x3A__CRM_LISTA_ZASOBOW:CRM_LISTA_ZASOBOW_ID"
                           id="_3A__DEVICES___d18e37246-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
                                                         system_cache__appinfo:name="CRM_LISTA_ZASOBOW_ID"
                                                         system_cache__appinfo:xpath="default_db__x3A__CRM_LISTA_ZASOBOW:CRM_LISTA_ZASOBOW_ID/ID"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                     <xs:documentation>
                    TODO CHECK IF THIS IS CORRECT FLAT RELATION! WAS GENERATED #224
                </xs:documentation>
                  </xs:annotation>
               </xs:element>
               <xs:element minOccurs="0"
                           name="CRM_LISTA_ZASOBOW_xpath"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37253-1_CRM_LISTA_"/>
               <xs:element minOccurs="0"
                           name="ID_PROJECT"
                           type="xs:integer"
                           id="_3A__DEVICES___d18e37254-1_ID_PROJECT"/>
               <xs:element minOccurs="0"
                           ref="default_db__x3A__IN7_MK_BAZA_DYSTRYBUCJI:ID_PROJECT"
                           id="_3A__DEVICES___d18e37255-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
                                                         system_cache__appinfo:name="ID_PROJECT"
                                                         system_cache__appinfo:xpath="default_db__x3A__IN7_MK_BAZA_DYSTRYBUCJI:ID_PROJECT/ID"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                     <xs:documentation>
                    TODO CHECK IF THIS IS CORRECT FLAT RELATION! WAS GENERATED #204
                </xs:documentation>
                  </xs:annotation>
               </xs:element>
               <xs:element minOccurs="0"
                           name="L_APPOITMENT_DATE"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37262-1_L_APPOITME"/>
               <xs:element minOccurs="0"
                           name="L_APPOITMENT_USER"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37263-1_L_APPOITME"/>
               <xs:element minOccurs="0"
                           ref="default_db__x3A__ADMIN_USERS:L_APPOITMENT_USER"
                           id="_3A__DEVICES___d18e37264-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
                                                         system_cache__appinfo:name="L_APPOITMENT_USER"
                                                         system_cache__appinfo:xpath="default_db__x3A__ADMIN_USERS:L_APPOITMENT_USER/ADM_ACCOUNT"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                     <xs:documentation>
                    TODO CHECK IF THIS IS CORRECT FLAT RELATION! WAS GENERATED #166
                </xs:documentation>
                  </xs:annotation>
               </xs:element>
               <xs:element minOccurs="0"
                           name="L_APPOITMENT_PERIOD"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37271-1_L_APPOITME"/>
               <xs:element minOccurs="0"
                           name="L_APPOITMENT_INFO"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37272-1_L_APPOITME"/>
               <xs:element minOccurs="0"
                           name="L_APPOITMENT_TYPE"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37273-1_L_APPOITME"/>
               <xs:element minOccurs="0"
                           name="L_CALENDAR"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37275-1_L_CALENDAR"/>
               <xs:element minOccurs="0"
                           name="P_ACCOUNT"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37276-1_P_ACCOUNT"/>
               <xs:element minOccurs="0"
                           name="ID_BILLING_USERS"
                           type="xs:integer"
                           id="_3A__DEVICES___d18e37277-1_ID_BILLING"/>
               <xs:element minOccurs="0"
                           ref="default_db__x3A__COMPANIES:ID_BILLING_USERS"
                           id="_3A__DEVICES___d18e37278-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
                                                         system_cache__appinfo:name="ID_BILLING_USERS"
                                                         system_cache__appinfo:xpath="default_db__x3A__COMPANIES:ID_BILLING_USERS/ID"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                  </xs:annotation>
               </xs:element>
               <xs:element minOccurs="0"
                           name="ID_SERVICES"
                           type="xs:integer"
                           id="_3A__DEVICES___d18e37283-1_ID_SERVICE"/>
               <xs:element minOccurs="0"
                           ref="default_db__x3A__SERVICES:SERVICES"
                           id="_3A__DEVICES___d18e37284-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
                                                         system_cache__appinfo:name="ID_SERVICES"
                                                         system_cache__appinfo:xpath="default_db__x3A__SERVICES:SERVICES/ID"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                  </xs:annotation>
               </xs:element>
               <xs:element minOccurs="0"
                           name="A_CLASSIFIED"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37289-1_A_CLASSIFI"/>
               <xs:element minOccurs="0"
                           name="ADM_PASSWD"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37290-1_ADM_PASSWD"/>
               <xs:element minOccurs="0"
                           name="S_PASSWD"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37291-1_S_PASSWD"/>
               <xs:element minOccurs="0"
                           name="ADMIN_USERS_ID"
                           type="xs:integer"
                           id="_3A__DEVICES___d18e37292-1_ADMIN_USER"/>
               <xs:element minOccurs="0"
                           ref="default_db__x3A__ADMIN_USERS:ADMIN_USERS_ID"
                           id="_3A__DEVICES___d18e37293-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:name="ADMIN_USERS_ID"
                                                         system_cache__appinfo:ref_engine="view"
                                                         system_cache__appinfo:xpath="default_db__x3A__ADMIN_USERS:ADMIN_USERS_ID/ID"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                     <xs:documentation>Osoba odpowiedzialna</xs:documentation>
                  </xs:annotation>
               </xs:element>
               <!--<xs:element  minOccurs="0" ref="default_db__x3A__ADMIN_USERS:ADMIN_USERS" maxOccurs="1" minOccurs="0">
            <xs:annotation>
               <xs:appinfo>
                  <system_cache__appinfo:flat_relation_cache>
                     <system_cache__appinfo:source system_cache__appinfo:name="ADMIN_USERS_ID" system_cache__appinfo:ref_engine="view" system_cache__appinfo:xpath="default_db__x3A__ADMIN_USERS:ADMIN_USERS/ID"/>
                  </system_cache__appinfo:flat_relation_cache>
               </xs:appinfo>
            </xs:annotation>
         </xs:element> dodatk? po co -->
            </xs:sequence>
         </xs:restriction>
      </xs:complexContent>
   </xs:complexType>
   <xs:element name="DEVICES__DO_ZAMOWIENIA"
               type="default_db__x3A__DEVICES:DEVICES__DO_ZAMOWIENIA"
               id="_3A__DEVICES___d18e37301-1_DEVICES__D"/>
   <xs:complexType name="DEVICES__ZAMOWIONE_NIE_DOSTARCZONE"
                   system_cache__appinfo:primaryKey="ID"
                   id="_3A__DEVICES___d18e37302-1_DEVICES__Z"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
      <xs:annotation>
         <xs:documentation>Urządzenia zamówione, lecz nie dostarczone - posiadaja relacje do zamówienia, lecz nie maja powiąaznego dokumentu PZ </xs:documentation>
      </xs:annotation>
      <xs:complexContent id="_3A__DEVICES___d18e37306-1">
         <xs:restriction base="default_db__x3A__DEVICES:DEVICES">
            <xs:sequence id="_3A__DEVICES___d18e37308-1"><!--<xs:element minOccurs="0" ref="SystemObjects__x3A__AccessOwner:AccessOwner"
                     id="a3A__DEVICES___d5e78892-1">
            <xs:annotation>
               <xs:appinfo>
                  <system_cache__appinfo:flat_relation_cache>
                     <system_cache__appinfo:source system_cache__appinfo:name="L_APPOITMENT_USER"
                                                   system_cache__appinfo:xpath="SystemObjects__x3A__AccessOwner:AccessOwner/login"/>
                  </system_cache__appinfo:flat_relation_cache>
               </xs:appinfo>
            </xs:annotation>
         </xs:element>--><!--<xs:element minOccurs="0" ref="SystemObjects__x3A__AccessGroup:AccessGroupRead"
                     id="a3A__DEVICES___d5e78897-1">
            <xs:annotation>
               <xs:appinfo>
                  <system_cache__appinfo:flat_relation_cache>
                     <system_cache__appinfo:source system_cache__appinfo:name="A_CLASSIFIED"
                                                   system_cache__appinfo:xpath="SystemObjects__x3A__AccessGroup:AccessGroupRead/uid"/>
                  </system_cache__appinfo:flat_relation_cache>
               </xs:appinfo>
            </xs:annotation>
         </xs:element>--><!--<xs:element minOccurs="0" ref="SystemObjects__x3A__AccessGroup:AccessGroupWrite"
                     id="a3A__DEVICES___d5e78902-1">
            <xs:annotation>
               <xs:appinfo>
                  <system_cache__appinfo:flat_relation_cache>
                     <system_cache__appinfo:source system_cache__appinfo:name="A_ADM_COMPANY"
                                                   system_cache__appinfo:xpath="SystemObjects__x3A__AccessGroup:AccessGroupWrite/uid"/>
                  </system_cache__appinfo:flat_relation_cache>
               </xs:appinfo>
            </xs:annotation>
         </xs:element>-->
               <xs:element name="ID" type="xs:integer" id="_3A__DEVICES___d18e37312-1_ID"/>
               <xs:element name="PARENT_ID"
                           type="xs:integer"
                           minOccurs="0"
                           id="_3A__DEVICES___d18e37313-1_PARENT_ID"/>
               <xs:element ref="default_db__x3A__DEVICES:DEVICES"
                           minOccurs="0"
                           id="_3A__DEVICES___d18e37314-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:name="ID"
                                                         system_cache__appinfo:ref_engine="view"
                                                         system_cache__appinfo:xpath="default_db__x3A__DEVICES:DEVICES/PARENT_ID"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                  </xs:annotation>
               </xs:element>
               <xs:element minOccurs="0"
                           name="A_RECORD_CREATE_DATE"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37319-1_A_RECORD_C"/>
               <xs:element minOccurs="0"
                           name="A_RECORD_CREATE_AUTHOR"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37320-1_A_RECORD_C"/>
               <xs:element minOccurs="0"
                           name="A_RECORD_UPDATE_DATE"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37321-1_A_RECORD_U"/>
               <xs:element minOccurs="0"
                           name="A_RECORD_UPDATE_AUTHOR"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37322-1_A_RECORD_U"/>
               <xs:element minOccurs="0"
                           name="A_PROBLEM"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37323-1_A_PROBLEM"/>
               <xs:element minOccurs="0"
                           name="A_PROBLEM_DESC"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37325-1_A_PROBLEM_"/>
               <xs:element minOccurs="0"
                           name="A_PROBLEM_DATE"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37326-1_A_PROBLEM_"/>
               <xs:element minOccurs="0"
                           name="A_STATUS"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37327-1_A_STATUS"/>
               <xs:element minOccurs="0"
                           name="A_STATUS_EV"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37328-1_A_STATUS_E"/>
               <xs:element minOccurs="0"
                           name="A_STATUS_INFO"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37329-1_A_STATUS_I"/>
               <xs:element minOccurs="0"
                           name="IN7_DZIENNIK_KORESP_ID"
                           type="xs:integer"
                           id="_3A__DEVICES___d18e37330-1_IN7_DZIENN"/>
               <xs:element ref="default_db__x3A__IN7_DZIENNIK_KORESP:ID_KORESP__FAKTURA__ZAKUP_SPRZETU"
                           minOccurs="0"
                           id="_3A__DEVICES___d18e37331-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
                                                         system_cache__appinfo:name="IN7_DZIENNIK_KORESP_ID"
                                                         system_cache__appinfo:xpath="default_db__x3A__IN7_DZIENNIK_KORESP:ID_KORESP__FAKTURA__ZAKUP_SPRZETU/ID"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                     <xs:documentation>
                    TODO CHECK IF THIS IS CORRECT FLAT RELATION! WAS GENERATED #24995 !!!
                </xs:documentation>
                  </xs:annotation>
               </xs:element>
               <xs:element minOccurs="1"
                           name="IN7_DZIENNIK_KORESP_ID_ZAMOWIENIE"
                           type="xs:integer"
                           id="_3A__DEVICES___d18e37338-1_IN7_DZIENN"/>
               <xs:element ref="default_db__x3A__IN7_DZIENNIK_KORESP:ID_KORESP__FAKTURA__ZAKUP_SPRZETU_ZAMOWIENIE"
                           minOccurs="1"
                           id="_3A__DEVICES___d18e37339-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
                                                         system_cache__appinfo:name="IN7_DZIENNIK_KORESP_ID_ZAMOWIENIE"
                                                         system_cache__appinfo:xpath="default_db__x3A__IN7_DZIENNIK_KORESP:ID_KORESP__FAKTURA__ZAKUP_SPRZETU_ZAMOWIENIE/ID"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                  </xs:annotation>
               </xs:element>
               <xs:element minOccurs="0"
                           name="ID_KORESP__FAKTURA__ZAKUP_SPRZETU__PZ"
                           type="xs:int"
                           maxOccurs="0"
                           id="_3A__DEVICES___d18e37344-1_ID_KORESP_"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
                  <xs:annotation>
                     <xs:documentation>Potwierdzenie, że towar został odebrany poprzez skojarzenie z dokumentem PZ</xs:documentation>
                  </xs:annotation>
               </xs:element>
               <xs:element ref="default_db__x3A__IN7_DZIENNIK_KORESP:ID_KORESP__FAKTURA__ZAKUP_SPRZETU__PZ"
                           maxOccurs="0"
                           minOccurs="0"
                           id="_3A__DEVICES___d18e37348-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
                                                         system_cache__appinfo:name="ID_KORESP__FAKTURA__ZAKUP_SPRZETU__PZ"
                                                         system_cache__appinfo:xpath="default_db__x3A__IN7_DZIENNIK_KORESP:ID_KORESP__FAKTURA__ZAKUP_SPRZETU__PZ/ID"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                     <xs:documentation>
                    TODO CHECK IF THIS IS CORRECT FLAT RELATION! WAS GENERATED #245 !!!
                </xs:documentation>
                  </xs:annotation>
               </xs:element>
               <xs:element minOccurs="0"
                           name="A_UPDATE_DATE"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37356-1_A_UPDATE_D"/>
               <xs:element minOccurs="0"
                           name="A_ADM_COMPANY"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37357-1_A_ADM_COMP"/>
               <xs:element minOccurs="0"
                           name="S_ADDRESS_CITY"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37358-1_S_ADDRESS_"/>
               <xs:element minOccurs="0"
                           name="S_ADDRESS_POST_CODE"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37359-1_S_ADDRESS_"/>
               <xs:element minOccurs="0"
                           name="S_ADDRESS_POST_OFFICE"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37360-1_S_ADDRESS_"/>
               <xs:element minOccurs="0"
                           name="S_ADDRESS_STREET"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37361-1_S_ADDRESS_"/>
               <xs:element minOccurs="0"
                           name="S_ADDRESS_HOUSE"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37362-1_S_ADDRESS_"/>
               <xs:element minOccurs="0"
                           name="S_OTHER_INFO"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37363-1_S_OTHER_IN"/>
               <xs:element minOccurs="0"
                           name="S_IP"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37364-1_S_IP"/>
               <xs:element minOccurs="0"
                           name="T_NETWORK_SERVER"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37365-1_T_NETWORK_"/>
               <xs:element minOccurs="0"
                           name="T_TOPOLOGY_PLACE"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37366-1_T_TOPOLOGY"/>
               <xs:element minOccurs="0"
                           name="T_DEVICE_SERIAL"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37368-1_T_DEVICE_S"/>
               <xs:element minOccurs="0"
                           name="T_DEVICE_TYPE"
                           type="default_db__x3A__DEVICES:T_DEVICE_TYPE"
                           id="_3A__DEVICES___d18e37369-1_T_DEVICE_T"/>
               <xs:element minOccurs="0"
                           name="T_DEVICE_PORTS_OK"
                           type="xs:integer"
                           id="_3A__DEVICES___d18e37370-1_T_DEVICE_P"/>
               <xs:element minOccurs="0"
                           name="T_DEVICE_INFO"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37371-1_T_DEVICE_I"/>
               <xs:element minOccurs="0"
                           name="T_DEVICE_POWER"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37372-1_T_DEVICE_P"/>
               <xs:element minOccurs="0"
                           name="T_TELBOX_NEIGHBOUR_IN"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37373-1_T_TELBOX_N"/>
               <xs:element minOccurs="0"
                           name="T_TELBOX_NEIGHBOUR_IN_ID"
                           type="xs:integer"
                           id="_3A__DEVICES___d18e37374-1_T_TELBOX_N"/>
               <xs:element minOccurs="0"
                           ref="default_db__x3A__TELBOXES:T_TELBOX_NEIGHBOUR_IN_ID"
                           id="_3A__DEVICES___d18e37375-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
                                                         system_cache__appinfo:name="T_TELBOX_NEIGHBOUR_IN_ID"
                                                         system_cache__appinfo:xpath="default_db__x3A__TELBOXES:T_TELBOX_NEIGHBOUR_IN_ID/ID"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                     <xs:documentation>
                    TODO CHECK IF THIS IS CORRECT FLAT RELATION! WAS GENERATED #2225 !!!
                </xs:documentation>
                  </xs:annotation>
               </xs:element>
               <xs:element minOccurs="0"
                           name="the_geom"
                           type="p5Type:polygon"
                           id="_3A__DEVICES___d18e37382-1_the_geom"/>
               <xs:element minOccurs="0"
                           name="T_WORKPOINTS"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37383-1_T_WORKPOIN"/>
               <xs:element minOccurs="0"
                           name="T_WORKPOINTS_VALUE"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37384-1_T_WORKPOIN"/>
               <xs:element minOccurs="0"
                           name="T_WORKPOINTS_TYPE"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37386-1_T_WORKPOIN"/>
               <xs:element minOccurs="0"
                           name="T_WORKPOINTS_USER"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37387-1_T_WORKPOIN"/>
               <xs:element minOccurs="0"
                           name="T_WORKPOINTS_DATE"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37388-1_T_WORKPOIN"/>
               <xs:element minOccurs="0"
                           name="T_PENALTIES"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37389-1_T_PENALTIE"/>
               <xs:element minOccurs="0"
                           name="T_PENALTIES_TYPE"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37390-1_T_PENALTIE"/>
               <xs:element minOccurs="0"
                           name="T_PENALTIES_VALUE"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37391-1_T_PENALTIE"/>
               <xs:element minOccurs="0"
                           name="T_WHO_CONNECTED"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37392-1_T_WHO_CONN"/>
               <xs:element minOccurs="0"
                           name="T_WHEN_CONNECTED"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37393-1_T_WHEN_CON"/>
               <xs:element minOccurs="0"
                           name="T_PRODUCER"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37394-1_T_PRODUCER"/>
               <xs:element minOccurs="0"
                           name="T_PRODUCTION_DATE"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37395-1_T_PRODUCTI"/>
               <xs:element minOccurs="0"
                           name="T_BUY_DATE"
                           type="xs:token"
                           id="_3A__DEVICES___d18e37396-1_T_BUY_DATE"/>
               <xs:element minOccurs="0"
                           name="T_SELLER"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37398-1_T_SELLER"/>
               <xs:element minOccurs="0"
                           name="T_OWNER"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37399-1_T_OWNER"/>
               <xs:element minOccurs="0"
                           name="T_GUARRANTY_EXPIRE"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37400-1_T_GUARRANT"/>
               <xs:element minOccurs="0"
                           name="T_PAPERBOX_LOCATION"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37401-1_T_PAPERBOX"/>
               <xs:element minOccurs="0"
                           name="F_BILL_DATE"
                           type="xs:token"
                           id="_3A__DEVICES___d18e37402-1_F_BILL_DAT"/>
               <xs:element minOccurs="0"
                           name="F_BILL_NUMBER"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37403-1_F_BILL_NUM"/>
               <xs:element minOccurs="0"
                           name="F_BILL_POSITION"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37404-1_F_BILL_POS"/>
               <xs:element minOccurs="0"
                           name="F_BILL_COST"
                           type="xs:double"
                           id="_3A__DEVICES___d18e37405-1_F_BILL_COS"/>
               <xs:element minOccurs="0"
                           name="F_MONTHLY_LEASE_COST"
                           type="xs:double"
                           id="_3A__DEVICES___d18e37406-1_F_MONTHLY_"/>
               <xs:element minOccurs="0"
                           name="F_DEPTECIATION_LENGTH_YEARS"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37407-1_F_DEPTECIA"/>
               <xs:element minOccurs="0"
                           name="S_HW"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37408-1_S_HW"/>
               <xs:element minOccurs="0"
                           name="CRM_LISTA_ZASOBOW_ID"
                           type="xs:integer"
                           id="_3A__DEVICES___d18e37410-1_CRM_LISTA_"/>
               <xs:element minOccurs="0"
                           ref="default_db__x3A__CRM_LISTA_ZASOBOW:CRM_LISTA_ZASOBOW_ID"
                           id="_3A__DEVICES___d18e37411-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
                                                         system_cache__appinfo:name="CRM_LISTA_ZASOBOW_ID"
                                                         system_cache__appinfo:xpath="default_db__x3A__CRM_LISTA_ZASOBOW:CRM_LISTA_ZASOBOW_ID/ID"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                     <xs:documentation>
                    TODO CHECK IF THIS IS CORRECT FLAT RELATION! WAS GENERATED #224
                </xs:documentation>
                  </xs:annotation>
               </xs:element>
               <xs:element minOccurs="0"
                           name="CRM_LISTA_ZASOBOW_xpath"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37418-1_CRM_LISTA_"/>
               <xs:element minOccurs="0"
                           name="ID_PROJECT"
                           type="xs:integer"
                           id="_3A__DEVICES___d18e37419-1_ID_PROJECT"/>
               <xs:element minOccurs="0"
                           ref="default_db__x3A__IN7_MK_BAZA_DYSTRYBUCJI:ID_PROJECT"
                           id="_3A__DEVICES___d18e37420-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
                                                         system_cache__appinfo:name="ID_PROJECT"
                                                         system_cache__appinfo:xpath="default_db__x3A__IN7_MK_BAZA_DYSTRYBUCJI:ID_PROJECT/ID"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                     <xs:documentation>
                    TODO CHECK IF THIS IS CORRECT FLAT RELATION! WAS GENERATED #204
                </xs:documentation>
                  </xs:annotation>
               </xs:element>
               <xs:element minOccurs="0"
                           name="L_APPOITMENT_DATE"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37427-1_L_APPOITME"/>
               <xs:element minOccurs="0"
                           name="L_APPOITMENT_USER"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37428-1_L_APPOITME"/>
               <xs:element minOccurs="0"
                           ref="default_db__x3A__ADMIN_USERS:L_APPOITMENT_USER"
                           id="_3A__DEVICES___d18e37429-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
                                                         system_cache__appinfo:name="L_APPOITMENT_USER"
                                                         system_cache__appinfo:xpath="default_db__x3A__ADMIN_USERS:L_APPOITMENT_USER/ADM_ACCOUNT"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                     <xs:documentation>
                    TODO CHECK IF THIS IS CORRECT FLAT RELATION! WAS GENERATED #166
                </xs:documentation>
                  </xs:annotation>
               </xs:element>
               <xs:element minOccurs="0"
                           name="L_APPOITMENT_PERIOD"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37436-1_L_APPOITME"/>
               <xs:element minOccurs="0"
                           name="L_APPOITMENT_INFO"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37437-1_L_APPOITME"/>
               <xs:element minOccurs="0"
                           name="L_APPOITMENT_TYPE"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37438-1_L_APPOITME"/>
               <xs:element minOccurs="0"
                           name="L_CALENDAR"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37440-1_L_CALENDAR"/>
               <xs:element minOccurs="0"
                           name="P_ACCOUNT"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37441-1_P_ACCOUNT"/>
               <xs:element minOccurs="0"
                           name="ID_BILLING_USERS"
                           type="xs:integer"
                           id="_3A__DEVICES___d18e37442-1_ID_BILLING"/>
               <xs:element minOccurs="0"
                           ref="default_db__x3A__COMPANIES:ID_BILLING_USERS"
                           id="_3A__DEVICES___d18e37443-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
                                                         system_cache__appinfo:name="ID_BILLING_USERS"
                                                         system_cache__appinfo:xpath="default_db__x3A__COMPANIES:ID_BILLING_USERS/ID"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                  </xs:annotation>
               </xs:element>
               <xs:element minOccurs="0"
                           name="ID_SERVICES"
                           type="xs:integer"
                           id="_3A__DEVICES___d18e37448-1_ID_SERVICE"/>
               <xs:element minOccurs="0"
                           ref="default_db__x3A__SERVICES:SERVICES"
                           id="_3A__DEVICES___d18e37449-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
                                                         system_cache__appinfo:name="ID_SERVICES"
                                                         system_cache__appinfo:xpath="default_db__x3A__SERVICES:SERVICES/ID"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                  </xs:annotation>
               </xs:element>
               <xs:element minOccurs="0"
                           name="A_CLASSIFIED"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37454-1_A_CLASSIFI"/>
               <xs:element minOccurs="0"
                           name="ADM_PASSWD"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37455-1_ADM_PASSWD"/>
               <xs:element minOccurs="0"
                           name="S_PASSWD"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37456-1_S_PASSWD"/>
               <xs:element minOccurs="0"
                           name="ADMIN_USERS_ID"
                           type="xs:integer"
                           id="_3A__DEVICES___d18e37457-1_ADMIN_USER"/>
               <xs:element minOccurs="0"
                           ref="default_db__x3A__ADMIN_USERS:ADMIN_USERS_ID"
                           id="_3A__DEVICES___d18e37458-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:name="ADMIN_USERS_ID"
                                                         system_cache__appinfo:ref_engine="view"
                                                         system_cache__appinfo:xpath="default_db__x3A__ADMIN_USERS:ADMIN_USERS_ID/ID"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                     <xs:documentation>Osoba odpowiedzialna</xs:documentation>
                  </xs:annotation>
               </xs:element>
               <!--<xs:element  minOccurs="0" ref="default_db__x3A__ADMIN_USERS:ADMIN_USERS" maxOccurs="1" minOccurs="0">
            <xs:annotation>
               <xs:appinfo>
                  <system_cache__appinfo:flat_relation_cache>
                     <system_cache__appinfo:source system_cache__appinfo:name="ADMIN_USERS_ID" system_cache__appinfo:ref_engine="view" system_cache__appinfo:xpath="default_db__x3A__ADMIN_USERS:ADMIN_USERS/ID"/>
                  </system_cache__appinfo:flat_relation_cache>
               </xs:appinfo>
            </xs:annotation>
         </xs:element> dodatk? po co -->
            </xs:sequence>
         </xs:restriction>
      </xs:complexContent>
   </xs:complexType>
   <xs:element name="DEVICES__ZAMOWIONE_NIE_DOSTARCZONE"
               type="default_db__x3A__DEVICES:DEVICES__ZAMOWIONE_NIE_DOSTARCZONE"
               id="_3A__DEVICES___d18e37466-1_DEVICES__Z"/>
   <xs:complexType name="DEVICES__DOSTARCZONE"
                   system_cache__appinfo:primaryKey="ID"
                   id="_3A__DEVICES___d18e37467-1_DEVICES__D"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
      <xs:annotation>
         <xs:documentation>Urządzenia które posiadają relacje do obiektu PZ, czyli znajdują się fizycznie w zasobach</xs:documentation>
      </xs:annotation>
      <xs:complexContent id="_3A__DEVICES___d18e37471-1">
         <xs:restriction base="default_db__x3A__DEVICES:DEVICES">
            <xs:sequence id="_3A__DEVICES___d18e37473-1"><!--<xs:element minOccurs="0" ref="SystemObjects__x3A__AccessOwner:AccessOwner"
                     id="a3A__DEVICES___d5e78892-1">
            <xs:annotation>
               <xs:appinfo>
                  <system_cache__appinfo:flat_relation_cache>
                     <system_cache__appinfo:source system_cache__appinfo:name="L_APPOITMENT_USER"
                                                   system_cache__appinfo:xpath="SystemObjects__x3A__AccessOwner:AccessOwner/login"/>
                  </system_cache__appinfo:flat_relation_cache>
               </xs:appinfo>
            </xs:annotation>
         </xs:element>--><!--<xs:element minOccurs="0" ref="SystemObjects__x3A__AccessGroup:AccessGroupRead"
                     id="a3A__DEVICES___d5e78897-1">
            <xs:annotation>
               <xs:appinfo>
                  <system_cache__appinfo:flat_relation_cache>
                     <system_cache__appinfo:source system_cache__appinfo:name="A_CLASSIFIED"
                                                   system_cache__appinfo:xpath="SystemObjects__x3A__AccessGroup:AccessGroupRead/uid"/>
                  </system_cache__appinfo:flat_relation_cache>
               </xs:appinfo>
            </xs:annotation>
         </xs:element>--><!--<xs:element minOccurs="0" ref="SystemObjects__x3A__AccessGroup:AccessGroupWrite"
                     id="a3A__DEVICES___d5e78902-1">
            <xs:annotation>
               <xs:appinfo>
                  <system_cache__appinfo:flat_relation_cache>
                     <system_cache__appinfo:source system_cache__appinfo:name="A_ADM_COMPANY"
                                                   system_cache__appinfo:xpath="SystemObjects__x3A__AccessGroup:AccessGroupWrite/uid"/>
                  </system_cache__appinfo:flat_relation_cache>
               </xs:appinfo>
            </xs:annotation>
         </xs:element>-->
               <xs:element name="ID" type="xs:integer" id="_3A__DEVICES___d18e37477-1_ID"/>
               <xs:element name="PARENT_ID"
                           type="xs:integer"
                           minOccurs="0"
                           id="_3A__DEVICES___d18e37478-1_PARENT_ID"/>
               <xs:element ref="default_db__x3A__DEVICES:DEVICES"
                           minOccurs="0"
                           id="_3A__DEVICES___d18e37479-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:name="ID"
                                                         system_cache__appinfo:ref_engine="view"
                                                         system_cache__appinfo:xpath="default_db__x3A__DEVICES:DEVICES/PARENT_ID"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                  </xs:annotation>
               </xs:element>
               <xs:element minOccurs="0"
                           name="A_RECORD_CREATE_DATE"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37484-1_A_RECORD_C"/>
               <xs:element minOccurs="0"
                           name="A_RECORD_CREATE_AUTHOR"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37485-1_A_RECORD_C"/>
               <xs:element minOccurs="0"
                           name="A_RECORD_UPDATE_DATE"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37486-1_A_RECORD_U"/>
               <xs:element minOccurs="0"
                           name="A_RECORD_UPDATE_AUTHOR"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37487-1_A_RECORD_U"/>
               <xs:element minOccurs="0"
                           name="A_PROBLEM"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37488-1_A_PROBLEM"/>
               <xs:element minOccurs="0"
                           name="A_PROBLEM_DESC"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37490-1_A_PROBLEM_"/>
               <xs:element minOccurs="0"
                           name="A_PROBLEM_DATE"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37491-1_A_PROBLEM_"/>
               <xs:element minOccurs="0"
                           name="A_STATUS"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37492-1_A_STATUS"/>
               <xs:element minOccurs="0"
                           name="A_STATUS_EV"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37493-1_A_STATUS_E"/>
               <xs:element minOccurs="0"
                           name="A_STATUS_INFO"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37494-1_A_STATUS_I"/>
               <xs:element minOccurs="0"
                           name="IN7_DZIENNIK_KORESP_ID"
                           type="xs:integer"
                           id="_3A__DEVICES___d18e37495-1_IN7_DZIENN"/>
               <xs:element ref="default_db__x3A__IN7_DZIENNIK_KORESP:ID_KORESP__FAKTURA__ZAKUP_SPRZETU"
                           minOccurs="0"
                           id="_3A__DEVICES___d18e37496-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
                                                         system_cache__appinfo:name="IN7_DZIENNIK_KORESP_ID"
                                                         system_cache__appinfo:xpath="default_db__x3A__IN7_DZIENNIK_KORESP:ID_KORESP__FAKTURA__ZAKUP_SPRZETU/ID"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                     <xs:documentation>
                    TODO CHECK IF THIS IS CORRECT FLAT RELATION! WAS GENERATED #24995 !!!
                </xs:documentation>
                  </xs:annotation>
               </xs:element>
               <xs:element minOccurs="0"
                           name="IN7_DZIENNIK_KORESP_ID_ZAMOWIENIE"
                           type="xs:integer"
                           id="_3A__DEVICES___d18e37503-1_IN7_DZIENN"/>
               <xs:element ref="default_db__x3A__IN7_DZIENNIK_KORESP:ID_KORESP__FAKTURA__ZAKUP_SPRZETU_ZAMOWIENIE"
                           minOccurs="0"
                           id="_3A__DEVICES___d18e37504-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
                                                         system_cache__appinfo:name="IN7_DZIENNIK_KORESP_ID_ZAMOWIENIE"
                                                         system_cache__appinfo:xpath="default_db__x3A__IN7_DZIENNIK_KORESP:ID_KORESP__FAKTURA__ZAKUP_SPRZETU_ZAMOWIENIE/ID"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                  </xs:annotation>
               </xs:element>
               <xs:element minOccurs="1"
                           name="ID_KORESP__FAKTURA__ZAKUP_SPRZETU__PZ"
                           type="xs:int"
                           id="_3A__DEVICES___d18e37509-1_ID_KORESP_"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
                  <xs:annotation>
                     <xs:documentation>Potwierdzenie, że towar został odebrany poprzez skojarzenie z dokumentem PZ</xs:documentation>
                  </xs:annotation>
               </xs:element>
               <xs:element ref="default_db__x3A__IN7_DZIENNIK_KORESP:ID_KORESP__FAKTURA__ZAKUP_SPRZETU__PZ"
                           minOccurs="1"
                           id="_3A__DEVICES___d18e37513-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
                                                         system_cache__appinfo:name="ID_KORESP__FAKTURA__ZAKUP_SPRZETU__PZ"
                                                         system_cache__appinfo:xpath="default_db__x3A__IN7_DZIENNIK_KORESP:ID_KORESP__FAKTURA__ZAKUP_SPRZETU__PZ/ID"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                     <xs:documentation>
                    TODO CHECK IF THIS IS CORRECT FLAT RELATION! WAS GENERATED #245 !!!
                </xs:documentation>
                  </xs:annotation>
               </xs:element>
               <xs:element minOccurs="0"
                           name="A_UPDATE_DATE"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37521-1_A_UPDATE_D"/>
               <xs:element minOccurs="0"
                           name="A_ADM_COMPANY"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37522-1_A_ADM_COMP"/>
               <xs:element minOccurs="0"
                           name="S_ADDRESS_CITY"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37523-1_S_ADDRESS_"/>
               <xs:element minOccurs="0"
                           name="S_ADDRESS_POST_CODE"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37524-1_S_ADDRESS_"/>
               <xs:element minOccurs="0"
                           name="S_ADDRESS_POST_OFFICE"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37525-1_S_ADDRESS_"/>
               <xs:element minOccurs="0"
                           name="S_ADDRESS_STREET"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37526-1_S_ADDRESS_"/>
               <xs:element minOccurs="0"
                           name="S_ADDRESS_HOUSE"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37527-1_S_ADDRESS_"/>
               <xs:element minOccurs="0"
                           name="S_OTHER_INFO"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37528-1_S_OTHER_IN"/>
               <xs:element minOccurs="0"
                           name="S_IP"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37529-1_S_IP"/>
               <xs:element minOccurs="0"
                           name="T_NETWORK_SERVER"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37530-1_T_NETWORK_"/>
               <xs:element minOccurs="0"
                           name="T_TOPOLOGY_PLACE"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37531-1_T_TOPOLOGY"/>
               <xs:element minOccurs="0"
                           name="T_DEVICE_SERIAL"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37533-1_T_DEVICE_S"/>
               <xs:element minOccurs="0"
                           name="T_DEVICE_TYPE"
                           type="default_db__x3A__DEVICES:T_DEVICE_TYPE"
                           id="_3A__DEVICES___d18e37534-1_T_DEVICE_T"/>
               <xs:element minOccurs="0"
                           name="T_DEVICE_PORTS_OK"
                           type="xs:integer"
                           id="_3A__DEVICES___d18e37535-1_T_DEVICE_P"/>
               <xs:element minOccurs="0"
                           name="T_DEVICE_INFO"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37536-1_T_DEVICE_I"/>
               <xs:element minOccurs="0"
                           name="T_DEVICE_POWER"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37537-1_T_DEVICE_P"/>
               <xs:element minOccurs="0"
                           name="T_TELBOX_NEIGHBOUR_IN"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37538-1_T_TELBOX_N"/>
               <xs:element minOccurs="0"
                           name="T_TELBOX_NEIGHBOUR_IN_ID"
                           type="xs:integer"
                           id="_3A__DEVICES___d18e37539-1_T_TELBOX_N"/>
               <xs:element minOccurs="0"
                           ref="default_db__x3A__TELBOXES:T_TELBOX_NEIGHBOUR_IN_ID"
                           id="_3A__DEVICES___d18e37540-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
                                                         system_cache__appinfo:name="T_TELBOX_NEIGHBOUR_IN_ID"
                                                         system_cache__appinfo:xpath="default_db__x3A__TELBOXES:T_TELBOX_NEIGHBOUR_IN_ID/ID"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                     <xs:documentation>
                    TODO CHECK IF THIS IS CORRECT FLAT RELATION! WAS GENERATED #2225 !!!
                </xs:documentation>
                  </xs:annotation>
               </xs:element>
               <xs:element minOccurs="0"
                           name="the_geom"
                           type="p5Type:polygon"
                           id="_3A__DEVICES___d18e37547-1_the_geom"/>
               <xs:element minOccurs="0"
                           name="T_WORKPOINTS"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37548-1_T_WORKPOIN"/>
               <xs:element minOccurs="0"
                           name="T_WORKPOINTS_VALUE"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37549-1_T_WORKPOIN"/>
               <xs:element minOccurs="0"
                           name="T_WORKPOINTS_TYPE"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37551-1_T_WORKPOIN"/>
               <xs:element minOccurs="0"
                           name="T_WORKPOINTS_USER"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37552-1_T_WORKPOIN"/>
               <xs:element minOccurs="0"
                           name="T_WORKPOINTS_DATE"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37553-1_T_WORKPOIN"/>
               <xs:element minOccurs="0"
                           name="T_PENALTIES"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37554-1_T_PENALTIE"/>
               <xs:element minOccurs="0"
                           name="T_PENALTIES_TYPE"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37555-1_T_PENALTIE"/>
               <xs:element minOccurs="0"
                           name="T_PENALTIES_VALUE"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37556-1_T_PENALTIE"/>
               <xs:element minOccurs="0"
                           name="T_WHO_CONNECTED"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37557-1_T_WHO_CONN"/>
               <xs:element minOccurs="0"
                           name="T_WHEN_CONNECTED"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37558-1_T_WHEN_CON"/>
               <xs:element minOccurs="0"
                           name="T_PRODUCER"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37559-1_T_PRODUCER"/>
               <xs:element minOccurs="0"
                           name="T_PRODUCTION_DATE"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37560-1_T_PRODUCTI"/>
               <xs:element minOccurs="0"
                           name="T_BUY_DATE"
                           type="xs:token"
                           id="_3A__DEVICES___d18e37561-1_T_BUY_DATE"/>
               <xs:element minOccurs="0"
                           name="T_SELLER"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37563-1_T_SELLER"/>
               <xs:element minOccurs="0"
                           name="T_OWNER"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37564-1_T_OWNER"/>
               <xs:element minOccurs="0"
                           name="T_GUARRANTY_EXPIRE"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37565-1_T_GUARRANT"/>
               <xs:element minOccurs="0"
                           name="T_PAPERBOX_LOCATION"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37566-1_T_PAPERBOX"/>
               <xs:element minOccurs="0"
                           name="F_BILL_DATE"
                           type="xs:token"
                           id="_3A__DEVICES___d18e37567-1_F_BILL_DAT"/>
               <xs:element minOccurs="0"
                           name="F_BILL_NUMBER"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37568-1_F_BILL_NUM"/>
               <xs:element minOccurs="0"
                           name="F_BILL_POSITION"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37569-1_F_BILL_POS"/>
               <xs:element minOccurs="0"
                           name="F_BILL_COST"
                           type="xs:double"
                           id="_3A__DEVICES___d18e37570-1_F_BILL_COS"/>
               <xs:element minOccurs="0"
                           name="F_MONTHLY_LEASE_COST"
                           type="xs:double"
                           id="_3A__DEVICES___d18e37571-1_F_MONTHLY_"/>
               <xs:element minOccurs="0"
                           name="F_DEPTECIATION_LENGTH_YEARS"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37572-1_F_DEPTECIA"/>
               <xs:element minOccurs="0"
                           name="S_HW"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37573-1_S_HW"/>
               <xs:element minOccurs="0"
                           name="CRM_LISTA_ZASOBOW_ID"
                           type="xs:integer"
                           id="_3A__DEVICES___d18e37575-1_CRM_LISTA_"/>
               <xs:element minOccurs="0"
                           ref="default_db__x3A__CRM_LISTA_ZASOBOW:CRM_LISTA_ZASOBOW_ID"
                           id="_3A__DEVICES___d18e37576-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
                                                         system_cache__appinfo:name="CRM_LISTA_ZASOBOW_ID"
                                                         system_cache__appinfo:xpath="default_db__x3A__CRM_LISTA_ZASOBOW:CRM_LISTA_ZASOBOW_ID/ID"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                     <xs:documentation>
                    TODO CHECK IF THIS IS CORRECT FLAT RELATION! WAS GENERATED #224
                </xs:documentation>
                  </xs:annotation>
               </xs:element>
               <xs:element minOccurs="0"
                           name="CRM_LISTA_ZASOBOW_xpath"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37583-1_CRM_LISTA_"/>
               <xs:element minOccurs="0"
                           name="ID_PROJECT"
                           type="xs:integer"
                           id="_3A__DEVICES___d18e37584-1_ID_PROJECT"/>
               <xs:element minOccurs="0"
                           ref="default_db__x3A__IN7_MK_BAZA_DYSTRYBUCJI:ID_PROJECT"
                           id="_3A__DEVICES___d18e37585-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
                                                         system_cache__appinfo:name="ID_PROJECT"
                                                         system_cache__appinfo:xpath="default_db__x3A__IN7_MK_BAZA_DYSTRYBUCJI:ID_PROJECT/ID"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                     <xs:documentation>
                    TODO CHECK IF THIS IS CORRECT FLAT RELATION! WAS GENERATED #204
                </xs:documentation>
                  </xs:annotation>
               </xs:element>
               <xs:element minOccurs="0"
                           name="L_APPOITMENT_DATE"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37592-1_L_APPOITME"/>
               <xs:element minOccurs="0"
                           name="L_APPOITMENT_USER"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37593-1_L_APPOITME"/>
               <xs:element minOccurs="0"
                           ref="default_db__x3A__ADMIN_USERS:L_APPOITMENT_USER"
                           id="_3A__DEVICES___d18e37594-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
                                                         system_cache__appinfo:name="L_APPOITMENT_USER"
                                                         system_cache__appinfo:xpath="default_db__x3A__ADMIN_USERS:L_APPOITMENT_USER/ADM_ACCOUNT"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                     <xs:documentation>
                    TODO CHECK IF THIS IS CORRECT FLAT RELATION! WAS GENERATED #166
                </xs:documentation>
                  </xs:annotation>
               </xs:element>
               <xs:element minOccurs="0"
                           name="L_APPOITMENT_PERIOD"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37601-1_L_APPOITME"/>
               <xs:element minOccurs="0"
                           name="L_APPOITMENT_INFO"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37602-1_L_APPOITME"/>
               <xs:element minOccurs="0"
                           name="L_APPOITMENT_TYPE"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37603-1_L_APPOITME"/>
               <xs:element minOccurs="0"
                           name="L_CALENDAR"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37605-1_L_CALENDAR"/>
               <xs:element minOccurs="0"
                           name="P_ACCOUNT"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37606-1_P_ACCOUNT"/>
               <xs:element minOccurs="0"
                           name="ID_BILLING_USERS"
                           type="xs:integer"
                           id="_3A__DEVICES___d18e37607-1_ID_BILLING"/>
               <xs:element minOccurs="0"
                           ref="default_db__x3A__COMPANIES:ID_BILLING_USERS"
                           id="_3A__DEVICES___d18e37608-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
                                                         system_cache__appinfo:name="ID_BILLING_USERS"
                                                         system_cache__appinfo:xpath="default_db__x3A__COMPANIES:ID_BILLING_USERS/ID"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                  </xs:annotation>
               </xs:element>
               <xs:element minOccurs="0"
                           name="ID_SERVICES"
                           type="xs:integer"
                           id="_3A__DEVICES___d18e37613-1_ID_SERVICE"/>
               <xs:element minOccurs="0"
                           ref="default_db__x3A__SERVICES:SERVICES"
                           id="_3A__DEVICES___d18e37614-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
                                                         system_cache__appinfo:name="ID_SERVICES"
                                                         system_cache__appinfo:xpath="default_db__x3A__SERVICES:SERVICES/ID"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                  </xs:annotation>
               </xs:element>
               <xs:element minOccurs="0"
                           name="A_CLASSIFIED"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37619-1_A_CLASSIFI"/>
               <xs:element minOccurs="0"
                           name="ADM_PASSWD"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37620-1_ADM_PASSWD"/>
               <xs:element minOccurs="0"
                           name="S_PASSWD"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37621-1_S_PASSWD"/>
               <xs:element minOccurs="0"
                           name="ADMIN_USERS_ID"
                           type="xs:integer"
                           id="_3A__DEVICES___d18e37622-1_ADMIN_USER"/>
               <xs:element minOccurs="0"
                           ref="default_db__x3A__ADMIN_USERS:ADMIN_USERS_ID"
                           id="_3A__DEVICES___d18e37623-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:name="ADMIN_USERS_ID"
                                                         system_cache__appinfo:ref_engine="view"
                                                         system_cache__appinfo:xpath="default_db__x3A__ADMIN_USERS:ADMIN_USERS_ID/ID"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                     <xs:documentation>Osoba odpowiedzialna</xs:documentation>
                  </xs:annotation>
               </xs:element>
               <!--<xs:element  minOccurs="0" ref="default_db__x3A__ADMIN_USERS:ADMIN_USERS" maxOccurs="1" minOccurs="0">
            <xs:annotation>
               <xs:appinfo>
                  <system_cache__appinfo:flat_relation_cache>
                     <system_cache__appinfo:source system_cache__appinfo:name="ADMIN_USERS_ID" system_cache__appinfo:ref_engine="view" system_cache__appinfo:xpath="default_db__x3A__ADMIN_USERS:ADMIN_USERS/ID"/>
                  </system_cache__appinfo:flat_relation_cache>
               </xs:appinfo>
            </xs:annotation>
         </xs:element> dodatk? po co -->
            </xs:sequence>
         </xs:restriction>
      </xs:complexContent>
   </xs:complexType>
   <xs:element name="DEVICES__DOSTARCZONE"
               type="default_db__x3A__DEVICES:DEVICES__DOSTARCZONE"
               id="_3A__DEVICES___d18e37631-1_DEVICES__D"/>
   <xs:complexType name="DEVICES__W_PRZECHOWANIU"
                   system_cache__appinfo:primaryKey="ID"
                   id="_3A__DEVICES___d18e37632-1_DEVICES__W"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
      <xs:annotation>
         <xs:documentation>Urządzenia jakie są aktualnie w przechowaniu  - np koła na zimę</xs:documentation>
      </xs:annotation>
      <xs:complexContent id="_3A__DEVICES___d18e37636-1">
         <xs:restriction base="default_db__x3A__DEVICES:DEVICES">
            <xs:sequence id="_3A__DEVICES___d18e37638-1"><!--<xs:element minOccurs="0" ref="SystemObjects__x3A__AccessOwner:AccessOwner"
                     id="a3A__DEVICES___d5e78892-1">
            <xs:annotation>
               <xs:appinfo>
                  <system_cache__appinfo:flat_relation_cache>
                     <system_cache__appinfo:source system_cache__appinfo:name="L_APPOITMENT_USER"
                                                   system_cache__appinfo:xpath="SystemObjects__x3A__AccessOwner:AccessOwner/login"/>
                  </system_cache__appinfo:flat_relation_cache>
               </xs:appinfo>
            </xs:annotation>
         </xs:element>--><!--<xs:element minOccurs="0" ref="SystemObjects__x3A__AccessGroup:AccessGroupRead"
                     id="a3A__DEVICES___d5e78897-1">
            <xs:annotation>
               <xs:appinfo>
                  <system_cache__appinfo:flat_relation_cache>
                     <system_cache__appinfo:source system_cache__appinfo:name="A_CLASSIFIED"
                                                   system_cache__appinfo:xpath="SystemObjects__x3A__AccessGroup:AccessGroupRead/uid"/>
                  </system_cache__appinfo:flat_relation_cache>
               </xs:appinfo>
            </xs:annotation>
         </xs:element>--><!--<xs:element minOccurs="0" ref="SystemObjects__x3A__AccessGroup:AccessGroupWrite"
                     id="a3A__DEVICES___d5e78902-1">
            <xs:annotation>
               <xs:appinfo>
                  <system_cache__appinfo:flat_relation_cache>
                     <system_cache__appinfo:source system_cache__appinfo:name="A_ADM_COMPANY"
                                                   system_cache__appinfo:xpath="SystemObjects__x3A__AccessGroup:AccessGroupWrite/uid"/>
                  </system_cache__appinfo:flat_relation_cache>
               </xs:appinfo>
            </xs:annotation>
         </xs:element>-->
               <xs:element name="ID" type="xs:integer" id="_3A__DEVICES___d18e37642-1_ID"/>
               <xs:element name="PARENT_ID"
                           type="xs:integer"
                           minOccurs="0"
                           id="_3A__DEVICES___d18e37643-1_PARENT_ID"/>
               <xs:element ref="default_db__x3A__DEVICES:DEVICES"
                           minOccurs="0"
                           id="_3A__DEVICES___d18e37644-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:name="ID"
                                                         system_cache__appinfo:ref_engine="view"
                                                         system_cache__appinfo:xpath="default_db__x3A__DEVICES:DEVICES/PARENT_ID"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                     <xs:documentation>Budujemy drzewo w dół poprzez dzieci</xs:documentation>
                  </xs:annotation>
               </xs:element>
               <xs:element minOccurs="0"
                           name="A_RECORD_CREATE_DATE"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37651-1_A_RECORD_C"/>
               <xs:element minOccurs="0"
                           name="A_RECORD_CREATE_AUTHOR"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37652-1_A_RECORD_C"/>
               <xs:element minOccurs="0"
                           name="A_RECORD_UPDATE_DATE"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37653-1_A_RECORD_U"/>
               <xs:element minOccurs="0"
                           name="A_RECORD_UPDATE_AUTHOR"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37654-1_A_RECORD_U"/>
               <xs:element minOccurs="0"
                           name="A_PROBLEM"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37655-1_A_PROBLEM"/>
               <xs:element minOccurs="0"
                           name="A_PROBLEM_DESC"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37657-1_A_PROBLEM_"/>
               <xs:element minOccurs="0"
                           name="A_PROBLEM_DATE"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37658-1_A_PROBLEM_"/>
               <xs:element minOccurs="0"
                           name="A_STATUS"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37659-1_A_STATUS"/>
               <xs:element minOccurs="0"
                           name="A_STATUS_EV"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37660-1_A_STATUS_E"/>
               <xs:element minOccurs="0"
                           name="A_STATUS_INFO"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37661-1_A_STATUS_I"/>
               <xs:element minOccurs="0"
                           name="IN7_DZIENNIK_KORESP_ID"
                           type="xs:integer"
                           id="_3A__DEVICES___d18e37662-1_IN7_DZIENN"/>
               <xs:element ref="default_db__x3A__IN7_DZIENNIK_KORESP:ID_KORESP__FAKTURA__ZAKUP_SPRZETU"
                           minOccurs="0"
                           id="_3A__DEVICES___d18e37663-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
                                                         system_cache__appinfo:name="IN7_DZIENNIK_KORESP_ID"
                                                         system_cache__appinfo:xpath="default_db__x3A__IN7_DZIENNIK_KORESP:ID_KORESP__FAKTURA__ZAKUP_SPRZETU/ID"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                     <xs:documentation>
                    TODO CHECK IF THIS IS CORRECT FLAT RELATION! WAS GENERATED #24995 !!!
                </xs:documentation>
                  </xs:annotation>
               </xs:element>
               <xs:element minOccurs="0"
                           name="IN7_DZIENNIK_KORESP_ID_ZAMOWIENIE"
                           type="xs:integer"
                           id="_3A__DEVICES___d18e37670-1_IN7_DZIENN"/>
               <xs:element ref="default_db__x3A__IN7_DZIENNIK_KORESP:ID_KORESP__FAKTURA__ZAKUP_SPRZETU_ZAMOWIENIE"
                           minOccurs="0"
                           id="_3A__DEVICES___d18e37671-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
                                                         system_cache__appinfo:name="IN7_DZIENNIK_KORESP_ID_ZAMOWIENIE"
                                                         system_cache__appinfo:xpath="default_db__x3A__IN7_DZIENNIK_KORESP:ID_KORESP__FAKTURA__ZAKUP_SPRZETU_ZAMOWIENIE/ID"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                  </xs:annotation>
               </xs:element>
               <xs:element minOccurs="0"
                           name="ID_KORESP__FAKTURA__ZAKUP_SPRZETU__PZ"
                           type="xs:int"
                           id="_3A__DEVICES___d18e37676-1_ID_KORESP_"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
                  <xs:annotation>
                     <xs:documentation>Potwierdzenie, że towar został odebrany poprzez skojarzenie z dokumentem PZ</xs:documentation>
                  </xs:annotation>
               </xs:element>
               <xs:element ref="default_db__x3A__IN7_DZIENNIK_KORESP:ID_KORESP__FAKTURA__ZAKUP_SPRZETU__PZ"
                           minOccurs="0"
                           id="_3A__DEVICES___d18e37680-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
                                                         system_cache__appinfo:name="ID_KORESP__FAKTURA__ZAKUP_SPRZETU__PZ"
                                                         system_cache__appinfo:xpath="default_db__x3A__IN7_DZIENNIK_KORESP:ID_KORESP__FAKTURA__ZAKUP_SPRZETU__PZ/ID"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                     <xs:documentation>
                    TODO CHECK IF THIS IS CORRECT FLAT RELATION! WAS GENERATED #245 !!!
                </xs:documentation>
                  </xs:annotation>
               </xs:element>
               <xs:element minOccurs="0"
                           name="A_UPDATE_DATE"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37688-1_A_UPDATE_D"/>
               <xs:element minOccurs="0"
                           name="A_ADM_COMPANY"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37689-1_A_ADM_COMP"/>
               <xs:element minOccurs="0"
                           name="S_ADDRESS_CITY"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37690-1_S_ADDRESS_"/>
               <xs:element minOccurs="0"
                           name="S_ADDRESS_POST_CODE"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37691-1_S_ADDRESS_"/>
               <xs:element minOccurs="0"
                           name="S_ADDRESS_POST_OFFICE"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37692-1_S_ADDRESS_"/>
               <xs:element minOccurs="0"
                           name="S_ADDRESS_STREET"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37693-1_S_ADDRESS_"/>
               <xs:element minOccurs="0"
                           name="S_ADDRESS_HOUSE"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37694-1_S_ADDRESS_"/>
               <xs:element minOccurs="0"
                           name="S_OTHER_INFO"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37695-1_S_OTHER_IN"/>
               <xs:element minOccurs="0"
                           name="S_IP"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37696-1_S_IP"/>
               <xs:element minOccurs="0"
                           name="T_NETWORK_SERVER"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37697-1_T_NETWORK_"/>
               <xs:element minOccurs="0"
                           name="T_TOPOLOGY_PLACE"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37698-1_T_TOPOLOGY"/>
               <xs:element minOccurs="0"
                           name="T_DEVICE_SERIAL"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37700-1_T_DEVICE_S"/>
               <xs:element minOccurs="0"
                           name="T_DEVICE_TYPE"
                           type="default_db__x3A__DEVICES:T_DEVICE_TYPE"
                           id="_3A__DEVICES___d18e37701-1_T_DEVICE_T"/>
               <xs:element minOccurs="0"
                           name="T_DEVICE_PORTS_OK"
                           type="xs:integer"
                           id="_3A__DEVICES___d18e37702-1_T_DEVICE_P"/>
               <xs:element minOccurs="0"
                           name="T_DEVICE_INFO"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37703-1_T_DEVICE_I"/>
               <xs:element minOccurs="0"
                           name="T_DEVICE_POWER"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37704-1_T_DEVICE_P"/>
               <xs:element minOccurs="0"
                           name="T_TELBOX_NEIGHBOUR_IN"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37705-1_T_TELBOX_N"/>
               <xs:element minOccurs="0"
                           name="T_TELBOX_NEIGHBOUR_IN_ID"
                           type="xs:integer"
                           id="_3A__DEVICES___d18e37706-1_T_TELBOX_N"/>
               <xs:element minOccurs="0"
                           ref="default_db__x3A__TELBOXES:T_TELBOX_NEIGHBOUR_IN_ID"
                           id="_3A__DEVICES___d18e37707-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
                                                         system_cache__appinfo:name="T_TELBOX_NEIGHBOUR_IN_ID"
                                                         system_cache__appinfo:xpath="default_db__x3A__TELBOXES:T_TELBOX_NEIGHBOUR_IN_ID/ID"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                     <xs:documentation>
                    TODO CHECK IF THIS IS CORRECT FLAT RELATION! WAS GENERATED #2225 !!!
                </xs:documentation>
                  </xs:annotation>
               </xs:element>
               <xs:element minOccurs="0"
                           name="the_geom"
                           type="p5Type:polygon"
                           id="_3A__DEVICES___d18e37714-1_the_geom"/>
               <xs:element minOccurs="0"
                           name="T_WORKPOINTS"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37715-1_T_WORKPOIN"/>
               <xs:element minOccurs="0"
                           name="T_WORKPOINTS_VALUE"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37716-1_T_WORKPOIN"/>
               <xs:element minOccurs="0"
                           name="T_WORKPOINTS_TYPE"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37718-1_T_WORKPOIN"/>
               <xs:element minOccurs="0"
                           name="T_WORKPOINTS_USER"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37719-1_T_WORKPOIN"/>
               <xs:element minOccurs="0"
                           name="T_WORKPOINTS_DATE"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37720-1_T_WORKPOIN"/>
               <xs:element minOccurs="0"
                           name="T_PENALTIES"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37721-1_T_PENALTIE"/>
               <xs:element minOccurs="0"
                           name="T_PENALTIES_TYPE"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37722-1_T_PENALTIE"/>
               <xs:element minOccurs="0"
                           name="T_PENALTIES_VALUE"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37723-1_T_PENALTIE"/>
               <xs:element minOccurs="0"
                           name="T_WHO_CONNECTED"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37724-1_T_WHO_CONN"/>
               <xs:element minOccurs="0"
                           name="T_WHEN_CONNECTED"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37725-1_T_WHEN_CON"/>
               <xs:element minOccurs="0"
                           name="T_PRODUCER"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37726-1_T_PRODUCER"/>
               <xs:element minOccurs="0"
                           name="T_PRODUCTION_DATE"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37727-1_T_PRODUCTI"/>
               <xs:element minOccurs="0"
                           name="T_BUY_DATE"
                           type="xs:token"
                           id="_3A__DEVICES___d18e37728-1_T_BUY_DATE"/>
               <xs:element minOccurs="0"
                           name="T_SELLER"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37730-1_T_SELLER"/>
               <xs:element minOccurs="0"
                           name="T_OWNER"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37731-1_T_OWNER"/>
               <xs:element minOccurs="0"
                           name="T_GUARRANTY_EXPIRE"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37732-1_T_GUARRANT"/>
               <xs:element minOccurs="0"
                           name="T_PAPERBOX_LOCATION"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37733-1_T_PAPERBOX"/>
               <xs:element minOccurs="0"
                           name="F_BILL_DATE"
                           type="xs:token"
                           id="_3A__DEVICES___d18e37734-1_F_BILL_DAT"/>
               <xs:element minOccurs="0"
                           name="F_BILL_NUMBER"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37735-1_F_BILL_NUM"/>
               <xs:element minOccurs="0"
                           name="F_BILL_POSITION"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37736-1_F_BILL_POS"/>
               <xs:element minOccurs="0"
                           name="F_BILL_COST"
                           type="xs:double"
                           id="_3A__DEVICES___d18e37737-1_F_BILL_COS"/>
               <xs:element minOccurs="0"
                           name="F_MONTHLY_LEASE_COST"
                           type="xs:double"
                           id="_3A__DEVICES___d18e37738-1_F_MONTHLY_"/>
               <xs:element minOccurs="0"
                           name="F_DEPTECIATION_LENGTH_YEARS"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37739-1_F_DEPTECIA"/>
               <xs:element minOccurs="0"
                           name="S_HW"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37740-1_S_HW"/>
               <xs:element minOccurs="0"
                           name="CRM_LISTA_ZASOBOW_ID"
                           type="xs:integer"
                           id="_3A__DEVICES___d18e37742-1_CRM_LISTA_"/>
               <xs:element minOccurs="0"
                           ref="default_db__x3A__CRM_LISTA_ZASOBOW:CRM_LISTA_ZASOBOW_ID"
                           id="_3A__DEVICES___d18e37743-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
                                                         system_cache__appinfo:name="CRM_LISTA_ZASOBOW_ID"
                                                         system_cache__appinfo:xpath="default_db__x3A__CRM_LISTA_ZASOBOW:CRM_LISTA_ZASOBOW_ID/ID"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                     <xs:documentation>
                    TODO CHECK IF THIS IS CORRECT FLAT RELATION! WAS GENERATED #224
                </xs:documentation>
                  </xs:annotation>
               </xs:element>
               <xs:element minOccurs="0"
                           name="CRM_LISTA_ZASOBOW_xpath"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37750-1_CRM_LISTA_"/>
               <xs:element minOccurs="0"
                           name="ID_PROJECT"
                           type="xs:integer"
                           id="_3A__DEVICES___d18e37751-1_ID_PROJECT"/>
               <xs:element minOccurs="0"
                           ref="default_db__x3A__IN7_MK_BAZA_DYSTRYBUCJI:ID_PROJECT"
                           id="_3A__DEVICES___d18e37752-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
                                                         system_cache__appinfo:name="ID_PROJECT"
                                                         system_cache__appinfo:xpath="default_db__x3A__IN7_MK_BAZA_DYSTRYBUCJI:ID_PROJECT/ID"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                     <xs:documentation>
                    TODO CHECK IF THIS IS CORRECT FLAT RELATION! WAS GENERATED #204
                </xs:documentation>
                  </xs:annotation>
               </xs:element>
               <xs:element minOccurs="0"
                           name="L_APPOITMENT_DATE"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37759-1_L_APPOITME"/>
               <xs:element minOccurs="0"
                           name="L_APPOITMENT_USER"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37760-1_L_APPOITME"/>
               <xs:element minOccurs="0"
                           ref="default_db__x3A__ADMIN_USERS:L_APPOITMENT_USER"
                           id="_3A__DEVICES___d18e37761-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
                                                         system_cache__appinfo:name="L_APPOITMENT_USER"
                                                         system_cache__appinfo:xpath="default_db__x3A__ADMIN_USERS:L_APPOITMENT_USER/ADM_ACCOUNT"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                     <xs:documentation>
                    TODO CHECK IF THIS IS CORRECT FLAT RELATION! WAS GENERATED #166
                </xs:documentation>
                  </xs:annotation>
               </xs:element>
               <xs:element minOccurs="0"
                           name="L_APPOITMENT_PERIOD"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37768-1_L_APPOITME"/>
               <xs:element minOccurs="0"
                           name="L_APPOITMENT_INFO"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37769-1_L_APPOITME"/>
               <xs:element minOccurs="0"
                           name="L_APPOITMENT_TYPE"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37770-1_L_APPOITME"/>
               <xs:element minOccurs="0"
                           name="L_CALENDAR"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37772-1_L_CALENDAR"/>
               <xs:element minOccurs="0"
                           name="P_ACCOUNT"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37773-1_P_ACCOUNT"/>
               <xs:element minOccurs="0"
                           name="ID_BILLING_USERS"
                           type="xs:integer"
                           id="_3A__DEVICES___d18e37774-1_ID_BILLING"/>
               <xs:element minOccurs="0"
                           ref="default_db__x3A__COMPANIES:ID_BILLING_USERS"
                           id="_3A__DEVICES___d18e37775-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
                                                         system_cache__appinfo:name="ID_BILLING_USERS"
                                                         system_cache__appinfo:xpath="default_db__x3A__COMPANIES:ID_BILLING_USERS/ID"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                  </xs:annotation>
               </xs:element>
               <xs:element minOccurs="0"
                           name="ID_SERVICES"
                           type="xs:integer"
                           id="_3A__DEVICES___d18e37780-1_ID_SERVICE"/>
               <xs:element minOccurs="0"
                           ref="default_db__x3A__SERVICES:SERVICES"
                           id="_3A__DEVICES___d18e37781-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
                                                         system_cache__appinfo:name="ID_SERVICES"
                                                         system_cache__appinfo:xpath="default_db__x3A__SERVICES:SERVICES/ID"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                  </xs:annotation>
               </xs:element>
               <xs:element minOccurs="0"
                           name="A_CLASSIFIED"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37786-1_A_CLASSIFI"/>
               <xs:element minOccurs="0"
                           name="ADM_PASSWD"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37787-1_ADM_PASSWD"/>
               <xs:element minOccurs="0"
                           name="S_PASSWD"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37788-1_S_PASSWD"/>
               <xs:element minOccurs="0"
                           name="ADMIN_USERS_ID"
                           type="xs:integer"
                           id="_3A__DEVICES___d18e37789-1_ADMIN_USER"/>
               <xs:element minOccurs="0"
                           ref="default_db__x3A__ADMIN_USERS:ADMIN_USERS_ID"
                           id="_3A__DEVICES___d18e37790-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:name="ADMIN_USERS_ID"
                                                         system_cache__appinfo:ref_engine="view"
                                                         system_cache__appinfo:xpath="default_db__x3A__ADMIN_USERS:ADMIN_USERS_ID/ID"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                     <xs:documentation>Osoba odpowiedzialna</xs:documentation>
                  </xs:annotation>
               </xs:element>
               <!--<xs:element  minOccurs="0" ref="default_db__x3A__ADMIN_USERS:ADMIN_USERS" maxOccurs="1" minOccurs="0">
            <xs:annotation>
               <xs:appinfo>
                  <system_cache__appinfo:flat_relation_cache>
                     <system_cache__appinfo:source system_cache__appinfo:name="ADMIN_USERS_ID" system_cache__appinfo:ref_engine="view" system_cache__appinfo:xpath="default_db__x3A__ADMIN_USERS:ADMIN_USERS/ID"/>
                  </system_cache__appinfo:flat_relation_cache>
               </xs:appinfo>
            </xs:annotation>
         </xs:element> dodatk? po co -->
               <xs:element maxOccurs="unbounded"
                           minOccurs="1"
                           ref="default_db__x3A__IN7_DZIENNIK_KORESP:ID_KORESP__DOWOD_PRZECHOWANIA"
                           id="_3A__DEVICES___d18e37799-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
                  <xs:annotation>
                     <xs:documentation>Może być wiele przechowań, lecz nie w jednym czasie. Wydania z przechowania zeruja stan wydania na przechowanie - TODO konsultacje mechanizmu</xs:documentation>
                  </xs:annotation>
               </xs:element>
               <xs:element maxOccurs="unbounded"
                           minOccurs="0"
                           ref="default_db__x3A__IN7_DZIENNIK_KORESP:ID_KORESP__DOWOD_PRZECHOWANIA_WYDANIA"
                           id="_3A__DEVICES___d18e37803-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
                  <xs:annotation>
                     <xs:documentation>Może być wiele przechowań, lecz nie w jednym czasie. Wydania z przechowania zeruja stan wydania na przechowanie - TODO konsultacje mechanizmu</xs:documentation>
                  </xs:annotation>
               </xs:element>
            </xs:sequence>
            <xs:assert test="count(default_db__x3A__IN7_DZIENNIK_KORESP:ID_KORESP__DOWOD_PRZECHOWANIA) != count(default_db__x3A__IN7_DZIENNIK_KORESP:ID_KORESP__DOWOD_PRZECHOWANIA_WYDANIA)"
                       id="_3A__DEVICES___d18e37807-1"/>
         </xs:restriction>
      </xs:complexContent>
   </xs:complexType>
   <xs:element name="DEVICES__W_PRZECHOWANIU"
               type="default_db__x3A__DEVICES:DEVICES__W_PRZECHOWANIU"
               id="_3A__DEVICES___d18e37809-1_DEVICES__W"/>
   <xs:complexType name="MASZYNA"
                   system_cache__appinfo:primaryKey="ID"
                   id="_3A__DEVICES___d18e37810-1_MASZYNA">
      <xs:complexContent id="_3A__DEVICES___d18e37811-1">
         <xs:restriction base="default_db__x3A__DEVICES:DEVICES">
            <xs:sequence id="_3A__DEVICES___d18e37813-1"><!--<xs:element minOccurs="0" ref="SystemObjects__x3A__AccessOwner:AccessOwner"
                  id="a3A__DEVICES___d5e78995-1">
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:name="L_APPOITMENT_USER" system_cache__appinfo:xpath="SystemObjects__x3A__AccessOwner:AccessOwner/login"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                  </xs:annotation>
               </xs:element>--><!--<xs:element minOccurs="0" ref="SystemObjects__x3A__AccessGroup:AccessGroupRead"
                  id="a3A__DEVICES___d5e79000-1">
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:name="A_CLASSIFIED" system_cache__appinfo:xpath="SystemObjects__x3A__AccessGroup:AccessGroupRead/uid"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                  </xs:annotation>
               </xs:element>--><!--<xs:element minOccurs="0" ref="SystemObjects__x3A__AccessGroup:AccessGroupWrite"
                  id="a3A__DEVICES___d5e79005-1">
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:name="A_ADM_COMPANY" system_cache__appinfo:xpath="SystemObjects__x3A__AccessGroup:AccessGroupWrite/uid"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                  </xs:annotation>
               </xs:element>-->
               <xs:element name="ID" type="xs:integer" id="_3A__DEVICES___d18e37817-1_ID"/>
               <xs:element name="PARENT_ID"
                           type="xs:integer"
                           minOccurs="0"
                           id="_3A__DEVICES___d18e37818-1_PARENT_ID"/>
               <xs:element ref="default_db__x3A__DEVICES:DEVICES"
                           minOccurs="0"
                           id="_3A__DEVICES___d18e37819-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:name="ID"
                                                         system_cache__appinfo:ref_engine="view"
                                                         system_cache__appinfo:xpath="default_db__x3A__DEVICES:DEVICES/PARENT_ID"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                  </xs:annotation>
               </xs:element>
               <xs:element minOccurs="0"
                           name="A_RECORD_CREATE_DATE"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37824-1_A_RECORD_C"/>
               <xs:element minOccurs="0"
                           name="A_RECORD_CREATE_AUTHOR"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37825-1_A_RECORD_C"/>
               <xs:element minOccurs="0"
                           name="A_RECORD_UPDATE_DATE"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37826-1_A_RECORD_U"/>
               <xs:element minOccurs="0"
                           name="A_RECORD_UPDATE_AUTHOR"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37827-1_A_RECORD_U"/>
               <xs:element minOccurs="0"
                           name="A_PROBLEM"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37828-1_A_PROBLEM"/>
               <xs:element minOccurs="0"
                           name="A_PROBLEM_DESC"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37830-1_A_PROBLEM_"/>
               <xs:element minOccurs="0"
                           name="A_PROBLEM_DATE"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37831-1_A_PROBLEM_"/>
               <xs:element minOccurs="0"
                           name="A_STATUS"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37832-1_A_STATUS"/>
               <xs:element minOccurs="0"
                           name="A_STATUS_EV"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37833-1_A_STATUS_E"/>
               <xs:element minOccurs="0"
                           name="A_STATUS_INFO"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37834-1_A_STATUS_I"/>
               <xs:element minOccurs="0"
                           name="IN7_DZIENNIK_KORESP_ID"
                           type="xs:integer"
                           id="_3A__DEVICES___d18e37835-1_IN7_DZIENN"/>
               <xs:element ref="default_db__x3A__IN7_DZIENNIK_KORESP:ID_KORESP__FAKTURA__ZAKUP_SPRZETU"
                           minOccurs="0"
                           id="_3A__DEVICES___d18e37836-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
                                                         system_cache__appinfo:name="IN7_DZIENNIK_KORESP_ID"
                                                         system_cache__appinfo:xpath="default_db__x3A__IN7_DZIENNIK_KORESP:ID_KORESP__FAKTURA__ZAKUP_SPRZETU/ID"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                     <xs:documentation>
                    TODO CHECK IF THIS IS CORRECT FLAT RELATION! WAS GENERATED #24995 !!!
                </xs:documentation>
                  </xs:annotation>
               </xs:element>
               <xs:element minOccurs="0"
                           name="IN7_DZIENNIK_KORESP_ID_ZAMOWIENIE"
                           type="xs:integer"
                           id="_3A__DEVICES___d18e37843-1_IN7_DZIENN"/>
               <xs:element ref="default_db__x3A__IN7_DZIENNIK_KORESP:ID_KORESP__FAKTURA__ZAKUP_SPRZETU_ZAMOWIENIE"
                           minOccurs="0"
                           id="_3A__DEVICES___d18e37844-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
                                                         system_cache__appinfo:name="IN7_DZIENNIK_KORESP_ID_ZAMOWIENIE"
                                                         system_cache__appinfo:xpath="default_db__x3A__IN7_DZIENNIK_KORESP:ID_KORESP__FAKTURA__ZAKUP_SPRZETU_ZAMOWIENIE/ID"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                     <xs:documentation>
                    TODO CHECK IF THIS IS CORRECT FLAT RELATION! WAS GENERATED #24995 !!!
                </xs:documentation>
                  </xs:annotation>
               </xs:element>
               <xs:element minOccurs="0"
                           name="ID_KORESP__FAKTURA__ZAKUP_SPRZETU__PZ"
                           type="xs:int"
                           id="_3A__DEVICES___d18e37851-1_ID_KORESP_"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
                  <xs:annotation>
                     <xs:documentation>Potwierdzenie, że towar został odebrany poprzez skojarzenie z dokumentem PZ</xs:documentation>
                  </xs:annotation>
               </xs:element>
               <xs:element ref="default_db__x3A__IN7_DZIENNIK_KORESP:ID_KORESP__FAKTURA__ZAKUP_SPRZETU__PZ"
                           minOccurs="0"
                           id="_3A__DEVICES___d18e37855-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
                                                         system_cache__appinfo:name="ID_KORESP__FAKTURA__ZAKUP_SPRZETU__PZ"
                                                         system_cache__appinfo:xpath="default_db__x3A__IN7_DZIENNIK_KORESP:ID_KORESP__FAKTURA__ZAKUP_SPRZETU__PZ/ID"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                     <xs:documentation>
                    TODO CHECK IF THIS IS CORRECT FLAT RELATION! WAS GENERATED #245 !!!
                </xs:documentation>
                  </xs:annotation>
               </xs:element>
               <xs:element minOccurs="0"
                           name="A_UPDATE_DATE"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37863-1_A_UPDATE_D"/>
               <xs:element minOccurs="0"
                           name="A_ADM_COMPANY"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37864-1_A_ADM_COMP"/>
               <xs:element minOccurs="0"
                           name="S_ADDRESS_CITY"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37865-1_S_ADDRESS_"/>
               <xs:element minOccurs="0"
                           name="S_ADDRESS_POST_CODE"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37866-1_S_ADDRESS_"/>
               <xs:element minOccurs="0"
                           name="S_ADDRESS_POST_OFFICE"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37867-1_S_ADDRESS_"/>
               <xs:element minOccurs="0"
                           name="S_ADDRESS_STREET"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37868-1_S_ADDRESS_"/>
               <xs:element minOccurs="0"
                           name="S_ADDRESS_HOUSE"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37869-1_S_ADDRESS_"/>
               <xs:element minOccurs="0"
                           name="S_OTHER_INFO"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37870-1_S_OTHER_IN"/>
               <xs:element minOccurs="0"
                           name="S_IP"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37871-1_S_IP"/>
               <xs:element minOccurs="0"
                           name="T_NETWORK_SERVER"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37872-1_T_NETWORK_"/>
               <xs:element minOccurs="0"
                           name="T_TOPOLOGY_PLACE"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37873-1_T_TOPOLOGY"/>
               <xs:element minOccurs="0"
                           name="T_DEVICE_SERIAL"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37875-1_T_DEVICE_S"/>
               <xs:element minOccurs="0"
                           name="T_DEVICE_TYPE"
                           type="default_db__x3A__DEVICES:T_DEVICE_TYPE_maszyna"
                           id="_3A__DEVICES___d18e37876-1_T_DEVICE_T"/>
               <xs:element minOccurs="0"
                           name="T_DEVICE_PORTS_OK"
                           type="xs:integer"
                           id="_3A__DEVICES___d18e37877-1_T_DEVICE_P"/>
               <xs:element minOccurs="0"
                           name="T_DEVICE_INFO"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37878-1_T_DEVICE_I"/>
               <xs:element minOccurs="0"
                           name="T_DEVICE_POWER"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37879-1_T_DEVICE_P"/>
               <xs:element minOccurs="0"
                           name="T_TELBOX_NEIGHBOUR_IN"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37880-1_T_TELBOX_N"/>
               <xs:element minOccurs="0"
                           name="T_TELBOX_NEIGHBOUR_IN_ID"
                           type="xs:integer"
                           id="_3A__DEVICES___d18e37881-1_T_TELBOX_N"/>
               <xs:element minOccurs="0"
                           ref="default_db__x3A__TELBOXES:T_TELBOX_NEIGHBOUR_IN_ID"
                           id="_3A__DEVICES___d18e37882-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
                                                         system_cache__appinfo:name="T_TELBOX_NEIGHBOUR_IN_ID"
                                                         system_cache__appinfo:xpath="default_db__x3A__TELBOXES:T_TELBOX_NEIGHBOUR_IN_ID/ID"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                     <xs:documentation>
                    TODO CHECK IF THIS IS CORRECT FLAT RELATION! WAS GENERATED #2225 !!!
                </xs:documentation>
                  </xs:annotation>
               </xs:element>
               <xs:element minOccurs="0"
                           name="the_geom"
                           type="p5Type:polygon"
                           id="_3A__DEVICES___d18e37889-1_the_geom"/>
               <xs:element minOccurs="0"
                           name="T_WORKPOINTS"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37890-1_T_WORKPOIN"/>
               <xs:element minOccurs="0"
                           name="T_WORKPOINTS_VALUE"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37891-1_T_WORKPOIN"/>
               <xs:element minOccurs="0"
                           name="T_WORKPOINTS_TYPE"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37893-1_T_WORKPOIN"/>
               <xs:element minOccurs="0"
                           name="T_WORKPOINTS_USER"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37894-1_T_WORKPOIN"/>
               <xs:element minOccurs="0"
                           name="T_WORKPOINTS_DATE"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37895-1_T_WORKPOIN"/>
               <xs:element minOccurs="0"
                           name="T_PENALTIES"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37896-1_T_PENALTIE"/>
               <xs:element minOccurs="0"
                           name="T_PENALTIES_TYPE"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37897-1_T_PENALTIE"/>
               <xs:element minOccurs="0"
                           name="T_PENALTIES_VALUE"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37898-1_T_PENALTIE"/>
               <xs:element minOccurs="0"
                           name="T_WHO_CONNECTED"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37899-1_T_WHO_CONN"/>
               <xs:element minOccurs="0"
                           name="T_WHEN_CONNECTED"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37900-1_T_WHEN_CON"/>
               <xs:element minOccurs="0"
                           name="T_PRODUCER"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37901-1_T_PRODUCER"/>
               <xs:element minOccurs="0"
                           name="T_PRODUCTION_DATE"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37902-1_T_PRODUCTI"/>
               <xs:element minOccurs="0"
                           name="T_BUY_DATE"
                           type="xs:token"
                           id="_3A__DEVICES___d18e37903-1_T_BUY_DATE"/>
               <xs:element minOccurs="0"
                           name="T_SELLER"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37905-1_T_SELLER"/>
               <xs:element minOccurs="0"
                           name="T_OWNER"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37906-1_T_OWNER"/>
               <xs:element minOccurs="0"
                           name="T_GUARRANTY_EXPIRE"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37907-1_T_GUARRANT"/>
               <xs:element minOccurs="0"
                           name="T_PAPERBOX_LOCATION"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37908-1_T_PAPERBOX"/>
               <xs:element minOccurs="0"
                           name="F_BILL_DATE"
                           type="xs:token"
                           id="_3A__DEVICES___d18e37909-1_F_BILL_DAT"/>
               <xs:element minOccurs="0"
                           name="F_BILL_NUMBER"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37910-1_F_BILL_NUM"/>
               <xs:element minOccurs="0"
                           name="F_BILL_POSITION"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37911-1_F_BILL_POS"/>
               <xs:element minOccurs="0"
                           name="F_BILL_COST"
                           type="xs:double"
                           id="_3A__DEVICES___d18e37912-1_F_BILL_COS"/>
               <xs:element minOccurs="0"
                           name="F_MONTHLY_LEASE_COST"
                           type="xs:double"
                           id="_3A__DEVICES___d18e37913-1_F_MONTHLY_"/>
               <xs:element minOccurs="0"
                           name="F_DEPTECIATION_LENGTH_YEARS"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37914-1_F_DEPTECIA"/>
               <xs:element minOccurs="0"
                           name="S_HW"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37915-1_S_HW"/>
               <xs:element minOccurs="0"
                           name="CRM_LISTA_ZASOBOW_ID"
                           type="xs:integer"
                           id="_3A__DEVICES___d18e37917-1_CRM_LISTA_"/>
               <xs:element minOccurs="0"
                           ref="default_db__x3A__CRM_LISTA_ZASOBOW:CRM_LISTA_ZASOBOW_ID"
                           id="_3A__DEVICES___d18e37918-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
                                                         system_cache__appinfo:name="CRM_LISTA_ZASOBOW_ID"
                                                         system_cache__appinfo:xpath="default_db__x3A__CRM_LISTA_ZASOBOW:CRM_LISTA_ZASOBOW_ID/ID"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                     <xs:documentation>
                    TODO CHECK IF THIS IS CORRECT FLAT RELATION! WAS GENERATED #224
                </xs:documentation>
                  </xs:annotation>
               </xs:element>
               <xs:element minOccurs="0"
                           name="CRM_LISTA_ZASOBOW_xpath"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37925-1_CRM_LISTA_"/>
               <xs:element minOccurs="0"
                           name="ID_PROJECT"
                           type="xs:integer"
                           id="_3A__DEVICES___d18e37926-1_ID_PROJECT"/>
               <xs:element minOccurs="0"
                           ref="default_db__x3A__IN7_MK_BAZA_DYSTRYBUCJI:ID_PROJECT"
                           id="_3A__DEVICES___d18e37927-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
                                                         system_cache__appinfo:name="ID_PROJECT"
                                                         system_cache__appinfo:xpath="default_db__x3A__IN7_MK_BAZA_DYSTRYBUCJI:ID_PROJECT/ID"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                     <xs:documentation>
                    TODO CHECK IF THIS IS CORRECT FLAT RELATION! WAS GENERATED #204
                </xs:documentation>
                  </xs:annotation>
               </xs:element>
               <xs:element minOccurs="0"
                           name="L_APPOITMENT_DATE"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37934-1_L_APPOITME"/>
               <xs:element minOccurs="0"
                           name="L_APPOITMENT_USER"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37935-1_L_APPOITME"/>
               <xs:element minOccurs="0"
                           ref="default_db__x3A__ADMIN_USERS:L_APPOITMENT_USER"
                           id="_3A__DEVICES___d18e37936-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
                                                         system_cache__appinfo:name="L_APPOITMENT_USER"
                                                         system_cache__appinfo:xpath="default_db__x3A__ADMIN_USERS:L_APPOITMENT_USER/ADM_ACCOUNT"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                     <xs:documentation>
                    TODO CHECK IF THIS IS CORRECT FLAT RELATION! WAS GENERATED #166
                </xs:documentation>
                  </xs:annotation>
               </xs:element>
               <xs:element minOccurs="0"
                           name="L_APPOITMENT_PERIOD"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37943-1_L_APPOITME"/>
               <xs:element minOccurs="0"
                           name="L_APPOITMENT_INFO"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37944-1_L_APPOITME"/>
               <xs:element minOccurs="0"
                           name="L_APPOITMENT_TYPE"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37945-1_L_APPOITME"/>
               <xs:element minOccurs="0"
                           name="L_CALENDAR"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37947-1_L_CALENDAR"/>
               <xs:element minOccurs="0"
                           name="P_ACCOUNT"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37948-1_P_ACCOUNT"/>
               <xs:element minOccurs="0"
                           name="ID_BILLING_USERS"
                           type="xs:integer"
                           id="_3A__DEVICES___d18e37949-1_ID_BILLING"/>
               <xs:element minOccurs="0"
                           ref="default_db__x3A__COMPANIES:ID_BILLING_USERS"
                           id="_3A__DEVICES___d18e37950-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
                                                         system_cache__appinfo:name="ID_BILLING_USERS"
                                                         system_cache__appinfo:xpath="default_db__x3A__COMPANIES:ID_BILLING_USERS/ID"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                     <xs:documentation>
                    TODO CHECK IF THIS IS CORRECT FLAT RELATION! WAS GENERATED #3992 !!!
                </xs:documentation>
                  </xs:annotation>
               </xs:element>
               <xs:element minOccurs="0"
                           name="ID_SERVICES"
                           type="xs:integer"
                           id="_3A__DEVICES___d18e37957-1_ID_SERVICE"/>
               <xs:element minOccurs="0"
                           ref="default_db__x3A__SERVICES:SERVICES"
                           id="_3A__DEVICES___d18e37958-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
                                                         system_cache__appinfo:name="ID_SERVICES"
                                                         system_cache__appinfo:xpath="default_db__x3A__SERVICES:SERVICES/ID"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                     <xs:documentation>
                    TODO CHECK IF THIS IS CORRECT FLAT RELATION! WAS GENERATED #183
                </xs:documentation>
                  </xs:annotation>
               </xs:element>
               <xs:element minOccurs="0"
                           name="A_CLASSIFIED"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37965-1_A_CLASSIFI"/>
               <xs:element minOccurs="0"
                           name="ADM_PASSWD"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37966-1_ADM_PASSWD"/>
               <xs:element minOccurs="0"
                           name="S_PASSWD"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37967-1_S_PASSWD"/>
               <xs:element minOccurs="0"
                           name="ADMIN_USERS_ID"
                           type="xs:integer"
                           id="_3A__DEVICES___d18e37968-1_ADMIN_USER"/>
               <xs:element minOccurs="0"
                           ref="default_db__x3A__ADMIN_USERS:ADMIN_USERS_ID"
                           id="_3A__DEVICES___d18e37969-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
                                                         system_cache__appinfo:name="ADMIN_USERS_ID"
                                                         system_cache__appinfo:xpath="default_db__x3A__ADMIN_USERS:ADMIN_USERS_ID/ID"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                     <xs:documentation>
                    TODO CHECK IF THIS IS CORRECT FLAT RELATION! WAS GENERATED #185
                </xs:documentation>
                  </xs:annotation>
               </xs:element>
            </xs:sequence>
            <xs:attribute name="label" type="xs:string" id="_3A__DEVICES___d18e37976-1_label"/>
            <xs:assert test="@label = concat(ID, ' ', T_DEVICE_TYPE)"
                       id="_3A__DEVICES___d18e37977-1"/>
         </xs:restriction>
      </xs:complexContent>
   </xs:complexType>
   <xs:element name="FORMA"
               type="default_db__x3A__DEVICES:FORMA"
               id="_3A__DEVICES___d18e37978-1_FORMA"/>
   <xs:complexType name="FORMA"
                   system_cache__appinfo:primaryKey="ID"
                   id="_3A__DEVICES___d18e37979-1_FORMA">
      <xs:complexContent id="_3A__DEVICES___d18e37980-1">
         <xs:restriction base="default_db__x3A__DEVICES:DEVICES">
            <xs:sequence id="_3A__DEVICES___d18e37982-1"><!--<xs:element minOccurs="0" ref="SystemObjects__x3A__AccessOwner:AccessOwner"
                  id="a3A__DEVICES___d5e79097-1">
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:name="L_APPOITMENT_USER" system_cache__appinfo:xpath="SystemObjects__x3A__AccessOwner:AccessOwner/login"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                  </xs:annotation>
               </xs:element>--><!--<xs:element minOccurs="0" ref="SystemObjects__x3A__AccessGroup:AccessGroupRead"
                  id="a3A__DEVICES___d5e79102-1">
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:name="A_CLASSIFIED" system_cache__appinfo:xpath="SystemObjects__x3A__AccessGroup:AccessGroupRead/uid"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                  </xs:annotation>
               </xs:element>--><!--<xs:element minOccurs="0" ref="SystemObjects__x3A__AccessGroup:AccessGroupWrite"
                  id="a3A__DEVICES___d5e79107-1">
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:name="A_ADM_COMPANY" system_cache__appinfo:xpath="SystemObjects__x3A__AccessGroup:AccessGroupWrite/uid"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                  </xs:annotation>
               </xs:element>-->
               <xs:element name="ID" type="xs:integer" id="_3A__DEVICES___d18e37986-1_ID"/>
               <xs:element minOccurs="0"
                           name="PARENT_ID"
                           type="xs:integer"
                           id="_3A__DEVICES___d18e37987-1_PARENT_ID"/>
               <xs:element ref="default_db__x3A__DEVICES:DEVICES"
                           minOccurs="0"
                           id="_3A__DEVICES___d18e37988-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:name="ID"
                                                         system_cache__appinfo:ref_engine="view"
                                                         system_cache__appinfo:xpath="default_db__x3A__DEVICES:DEVICES/PARENT_ID"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                  </xs:annotation>
               </xs:element>
               <xs:element minOccurs="0"
                           name="A_RECORD_CREATE_DATE"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37993-1_A_RECORD_C"/>
               <xs:element minOccurs="0"
                           name="A_RECORD_CREATE_AUTHOR"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37994-1_A_RECORD_C"/>
               <xs:element minOccurs="0"
                           name="A_RECORD_UPDATE_DATE"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37995-1_A_RECORD_U"/>
               <xs:element minOccurs="0"
                           name="A_RECORD_UPDATE_AUTHOR"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37996-1_A_RECORD_U"/>
               <xs:element minOccurs="0"
                           name="A_PROBLEM"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37997-1_A_PROBLEM"/>
               <xs:element minOccurs="0"
                           name="A_PROBLEM_DESC"
                           type="xs:string"
                           id="_3A__DEVICES___d18e37999-1_A_PROBLEM_"/>
               <xs:element minOccurs="0"
                           name="A_PROBLEM_DATE"
                           type="xs:string"
                           id="_3A__DEVICES___d18e38000-1_A_PROBLEM_"/>
               <xs:element minOccurs="0"
                           name="A_STATUS"
                           type="xs:string"
                           id="_3A__DEVICES___d18e38001-1_A_STATUS"/>
               <xs:element minOccurs="0"
                           name="A_STATUS_EV"
                           type="xs:string"
                           id="_3A__DEVICES___d18e38002-1_A_STATUS_E"/>
               <xs:element minOccurs="0"
                           name="A_STATUS_INFO"
                           type="xs:string"
                           id="_3A__DEVICES___d18e38003-1_A_STATUS_I"/>
               <xs:element minOccurs="0"
                           name="IN7_DZIENNIK_KORESP_ID"
                           type="xs:integer"
                           id="_3A__DEVICES___d18e38004-1_IN7_DZIENN"/>
               <xs:element ref="default_db__x3A__IN7_DZIENNIK_KORESP:ID_KORESP__FAKTURA__ZAKUP_SPRZETU"
                           minOccurs="0"
                           id="_3A__DEVICES___d18e38005-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
                                                         system_cache__appinfo:name="IN7_DZIENNIK_KORESP_ID"
                                                         system_cache__appinfo:xpath="default_db__x3A__IN7_DZIENNIK_KORESP:ID_KORESP__FAKTURA__ZAKUP_SPRZETU/ID"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                     <xs:documentation>
                    TODO CHECK IF THIS IS CORRECT FLAT RELATION! WAS GENERATED #24995 !!!
                </xs:documentation>
                  </xs:annotation>
               </xs:element>
               <xs:element minOccurs="0"
                           name="IN7_DZIENNIK_KORESP_ID_ZAMOWIENIE"
                           type="xs:integer"
                           id="_3A__DEVICES___d18e38012-1_IN7_DZIENN"/>
               <xs:element ref="default_db__x3A__IN7_DZIENNIK_KORESP:ID_KORESP__FAKTURA__ZAKUP_SPRZETU_ZAMOWIENIE"
                           minOccurs="0"
                           id="_3A__DEVICES___d18e38013-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
                                                         system_cache__appinfo:name="IN7_DZIENNIK_KORESP_ID_ZAMOWIENIE"
                                                         system_cache__appinfo:xpath="default_db__x3A__IN7_DZIENNIK_KORESP:ID_KORESP__FAKTURA__ZAKUP_SPRZETU_ZAMOWIENIE/ID"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                     <xs:documentation>
                    TODO CHECK IF THIS IS CORRECT FLAT RELATION! WAS GENERATED #24995 !!!
                </xs:documentation>
                  </xs:annotation>
               </xs:element>
               <xs:element minOccurs="0"
                           name="ID_KORESP__FAKTURA__ZAKUP_SPRZETU__PZ"
                           type="xs:int"
                           id="_3A__DEVICES___d18e38020-1_ID_KORESP_"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
                  <xs:annotation>
                     <xs:documentation>Potwierdzenie, że towar został odebrany poprzez skojarzenie z dokumentem PZ</xs:documentation>
                  </xs:annotation>
               </xs:element>
               <xs:element ref="default_db__x3A__IN7_DZIENNIK_KORESP:ID_KORESP__FAKTURA__ZAKUP_SPRZETU__PZ"
                           minOccurs="0"
                           id="_3A__DEVICES___d18e38024-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
                                                         system_cache__appinfo:name="ID_KORESP__FAKTURA__ZAKUP_SPRZETU__PZ"
                                                         system_cache__appinfo:xpath="default_db__x3A__IN7_DZIENNIK_KORESP:ID_KORESP__FAKTURA__ZAKUP_SPRZETU__PZ/ID"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                     <xs:documentation>
                    TODO CHECK IF THIS IS CORRECT FLAT RELATION! WAS GENERATED #245 !!!
                </xs:documentation>
                  </xs:annotation>
               </xs:element>
               <xs:element minOccurs="0"
                           name="A_UPDATE_DATE"
                           type="xs:string"
                           id="_3A__DEVICES___d18e38032-1_A_UPDATE_D"/>
               <xs:element minOccurs="0"
                           name="A_ADM_COMPANY"
                           type="xs:string"
                           id="_3A__DEVICES___d18e38033-1_A_ADM_COMP"/>
               <xs:element minOccurs="0"
                           name="S_ADDRESS_CITY"
                           type="xs:string"
                           id="_3A__DEVICES___d18e38034-1_S_ADDRESS_"/>
               <xs:element minOccurs="0"
                           name="S_ADDRESS_POST_CODE"
                           type="xs:string"
                           id="_3A__DEVICES___d18e38035-1_S_ADDRESS_"/>
               <xs:element minOccurs="0"
                           name="S_ADDRESS_POST_OFFICE"
                           type="xs:string"
                           id="_3A__DEVICES___d18e38036-1_S_ADDRESS_"/>
               <xs:element minOccurs="0"
                           name="S_ADDRESS_STREET"
                           type="xs:string"
                           id="_3A__DEVICES___d18e38037-1_S_ADDRESS_"/>
               <xs:element minOccurs="0"
                           name="S_ADDRESS_HOUSE"
                           type="xs:string"
                           id="_3A__DEVICES___d18e38038-1_S_ADDRESS_"/>
               <xs:element minOccurs="0"
                           name="S_OTHER_INFO"
                           type="xs:string"
                           id="_3A__DEVICES___d18e38039-1_S_OTHER_IN"/>
               <xs:element minOccurs="0"
                           name="S_IP"
                           type="xs:string"
                           id="_3A__DEVICES___d18e38040-1_S_IP"/>
               <xs:element minOccurs="0"
                           name="T_NETWORK_SERVER"
                           type="xs:string"
                           id="_3A__DEVICES___d18e38041-1_T_NETWORK_"/>
               <xs:element minOccurs="0"
                           name="T_TOPOLOGY_PLACE"
                           type="xs:string"
                           id="_3A__DEVICES___d18e38042-1_T_TOPOLOGY"/>
               <xs:element minOccurs="0"
                           name="T_DEVICE_SERIAL"
                           type="xs:string"
                           id="_3A__DEVICES___d18e38044-1_T_DEVICE_S"/>
               <xs:element minOccurs="0"
                           name="T_DEVICE_TYPE"
                           type="default_db__x3A__DEVICES:T_DEVICE_TYPE_forma"
                           id="_3A__DEVICES___d18e38045-1_T_DEVICE_T"/>
               <xs:element minOccurs="0"
                           name="T_DEVICE_PORTS_OK"
                           type="xs:integer"
                           id="_3A__DEVICES___d18e38046-1_T_DEVICE_P"/>
               <xs:element minOccurs="0"
                           name="T_DEVICE_INFO"
                           type="xs:string"
                           id="_3A__DEVICES___d18e38047-1_T_DEVICE_I"/>
               <xs:element minOccurs="0"
                           name="T_DEVICE_POWER"
                           type="xs:string"
                           id="_3A__DEVICES___d18e38048-1_T_DEVICE_P"/>
               <xs:element minOccurs="0"
                           name="T_TELBOX_NEIGHBOUR_IN"
                           type="xs:string"
                           id="_3A__DEVICES___d18e38049-1_T_TELBOX_N"/>
               <xs:element minOccurs="0"
                           name="T_TELBOX_NEIGHBOUR_IN_ID"
                           type="xs:integer"
                           id="_3A__DEVICES___d18e38050-1_T_TELBOX_N"/>
               <xs:element ref="default_db__x3A__TELBOXES:T_TELBOX_NEIGHBOUR_IN_ID"
                           minOccurs="0"
                           id="_3A__DEVICES___d18e38051-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
                                                         system_cache__appinfo:name="T_TELBOX_NEIGHBOUR_IN_ID"
                                                         system_cache__appinfo:xpath="default_db__x3A__TELBOXES:T_TELBOX_NEIGHBOUR_IN_ID/ID"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                     <xs:documentation>
                    TODO CHECK IF THIS IS CORRECT FLAT RELATION! WAS GENERATED #2225 !!!
                </xs:documentation>
                  </xs:annotation>
               </xs:element>
               <xs:element minOccurs="0"
                           name="the_geom"
                           type="p5Type:polygon"
                           id="_3A__DEVICES___d18e38058-1_the_geom"/>
               <xs:element minOccurs="0"
                           name="T_WORKPOINTS"
                           type="xs:string"
                           id="_3A__DEVICES___d18e38059-1_T_WORKPOIN"/>
               <xs:element minOccurs="0"
                           name="T_WORKPOINTS_VALUE"
                           type="xs:string"
                           id="_3A__DEVICES___d18e38060-1_T_WORKPOIN"/>
               <xs:element minOccurs="0"
                           name="T_WORKPOINTS_TYPE"
                           type="xs:string"
                           id="_3A__DEVICES___d18e38062-1_T_WORKPOIN"/>
               <xs:element minOccurs="0"
                           name="T_WORKPOINTS_USER"
                           type="xs:string"
                           id="_3A__DEVICES___d18e38063-1_T_WORKPOIN"/>
               <xs:element minOccurs="0"
                           name="T_WORKPOINTS_DATE"
                           type="xs:string"
                           id="_3A__DEVICES___d18e38064-1_T_WORKPOIN"/>
               <xs:element minOccurs="0"
                           name="T_PENALTIES"
                           type="xs:string"
                           id="_3A__DEVICES___d18e38065-1_T_PENALTIE"/>
               <xs:element minOccurs="0"
                           name="T_PENALTIES_TYPE"
                           type="xs:string"
                           id="_3A__DEVICES___d18e38066-1_T_PENALTIE"/>
               <xs:element minOccurs="0"
                           name="T_PENALTIES_VALUE"
                           type="xs:string"
                           id="_3A__DEVICES___d18e38067-1_T_PENALTIE"/>
               <xs:element minOccurs="0"
                           name="T_WHO_CONNECTED"
                           type="xs:string"
                           id="_3A__DEVICES___d18e38068-1_T_WHO_CONN"/>
               <xs:element minOccurs="0"
                           name="T_WHEN_CONNECTED"
                           type="xs:string"
                           id="_3A__DEVICES___d18e38069-1_T_WHEN_CON"/>
               <xs:element minOccurs="0"
                           name="T_PRODUCER"
                           type="xs:string"
                           id="_3A__DEVICES___d18e38070-1_T_PRODUCER"/>
               <xs:element minOccurs="0"
                           name="T_PRODUCTION_DATE"
                           type="xs:string"
                           id="_3A__DEVICES___d18e38071-1_T_PRODUCTI"/>
               <xs:element minOccurs="0"
                           name="T_BUY_DATE"
                           type="xs:token"
                           id="_3A__DEVICES___d18e38072-1_T_BUY_DATE"/>
               <xs:element minOccurs="0"
                           name="T_SELLER"
                           type="xs:string"
                           id="_3A__DEVICES___d18e38074-1_T_SELLER"/>
               <xs:element minOccurs="0"
                           name="T_OWNER"
                           type="xs:string"
                           id="_3A__DEVICES___d18e38075-1_T_OWNER"/>
               <xs:element minOccurs="0"
                           name="T_GUARRANTY_EXPIRE"
                           type="xs:string"
                           id="_3A__DEVICES___d18e38076-1_T_GUARRANT"/>
               <xs:element minOccurs="0"
                           name="T_PAPERBOX_LOCATION"
                           type="xs:string"
                           id="_3A__DEVICES___d18e38077-1_T_PAPERBOX"/>
               <xs:element minOccurs="0"
                           name="F_BILL_DATE"
                           type="xs:token"
                           id="_3A__DEVICES___d18e38078-1_F_BILL_DAT"/>
               <xs:element minOccurs="0"
                           name="F_BILL_NUMBER"
                           type="xs:string"
                           id="_3A__DEVICES___d18e38079-1_F_BILL_NUM"/>
               <xs:element minOccurs="0"
                           name="F_BILL_POSITION"
                           type="xs:string"
                           id="_3A__DEVICES___d18e38080-1_F_BILL_POS"/>
               <xs:element minOccurs="0"
                           name="F_BILL_COST"
                           type="xs:double"
                           id="_3A__DEVICES___d18e38081-1_F_BILL_COS"/>
               <xs:element minOccurs="0"
                           name="F_MONTHLY_LEASE_COST"
                           type="xs:double"
                           id="_3A__DEVICES___d18e38082-1_F_MONTHLY_"/>
               <xs:element minOccurs="0"
                           name="F_DEPTECIATION_LENGTH_YEARS"
                           type="xs:string"
                           id="_3A__DEVICES___d18e38083-1_F_DEPTECIA"/>
               <xs:element minOccurs="0"
                           name="S_HW"
                           type="xs:string"
                           id="_3A__DEVICES___d18e38084-1_S_HW"/>
               <xs:element minOccurs="0"
                           name="CRM_LISTA_ZASOBOW_ID"
                           type="xs:integer"
                           id="_3A__DEVICES___d18e38086-1_CRM_LISTA_"/>
               <xs:element minOccurs="0"
                           ref="default_db__x3A__CRM_LISTA_ZASOBOW:CRM_LISTA_ZASOBOW_ID"
                           id="_3A__DEVICES___d18e38087-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
                                                         system_cache__appinfo:name="CRM_LISTA_ZASOBOW_ID"
                                                         system_cache__appinfo:xpath="default_db__x3A__CRM_LISTA_ZASOBOW:CRM_LISTA_ZASOBOW_ID/ID"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                     <xs:documentation>
                    TODO CHECK IF THIS IS CORRECT FLAT RELATION! WAS GENERATED #224
                </xs:documentation>
                  </xs:annotation>
               </xs:element>
               <xs:element minOccurs="0"
                           name="CRM_LISTA_ZASOBOW_xpath"
                           type="xs:string"
                           id="_3A__DEVICES___d18e38094-1_CRM_LISTA_"/>
               <xs:element minOccurs="0"
                           name="ID_PROJECT"
                           type="xs:integer"
                           id="_3A__DEVICES___d18e38095-1_ID_PROJECT"/>
               <xs:element minOccurs="0"
                           ref="default_db__x3A__IN7_MK_BAZA_DYSTRYBUCJI:ID_PROJECT"
                           id="_3A__DEVICES___d18e38096-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
                                                         system_cache__appinfo:name="ID_PROJECT"
                                                         system_cache__appinfo:xpath="default_db__x3A__IN7_MK_BAZA_DYSTRYBUCJI:ID_PROJECT/ID"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                     <xs:documentation>
                    TODO CHECK IF THIS IS CORRECT FLAT RELATION! WAS GENERATED #204
                </xs:documentation>
                  </xs:annotation>
               </xs:element>
               <xs:element minOccurs="0"
                           name="L_APPOITMENT_DATE"
                           type="xs:string"
                           id="_3A__DEVICES___d18e38103-1_L_APPOITME"/>
               <xs:element minOccurs="0"
                           name="L_APPOITMENT_USER"
                           type="xs:string"
                           id="_3A__DEVICES___d18e38104-1_L_APPOITME"/>
               <xs:element minOccurs="0"
                           ref="default_db__x3A__ADMIN_USERS:L_APPOITMENT_USER"
                           id="_3A__DEVICES___d18e38105-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
                                                         system_cache__appinfo:name="L_APPOITMENT_USER"
                                                         system_cache__appinfo:xpath="default_db__x3A__ADMIN_USERS:L_APPOITMENT_USER/ADM_ACCOUNT"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                     <xs:documentation>
                    TODO CHECK IF THIS IS CORRECT FLAT RELATION! WAS GENERATED #166
                </xs:documentation>
                  </xs:annotation>
               </xs:element>
               <xs:element minOccurs="0"
                           name="L_APPOITMENT_PERIOD"
                           type="xs:string"
                           id="_3A__DEVICES___d18e38112-1_L_APPOITME"/>
               <xs:element minOccurs="0"
                           name="L_APPOITMENT_INFO"
                           type="xs:string"
                           id="_3A__DEVICES___d18e38113-1_L_APPOITME"/>
               <xs:element minOccurs="0"
                           name="L_APPOITMENT_TYPE"
                           type="xs:string"
                           id="_3A__DEVICES___d18e38114-1_L_APPOITME"/>
               <xs:element minOccurs="0"
                           name="L_CALENDAR"
                           type="xs:string"
                           id="_3A__DEVICES___d18e38116-1_L_CALENDAR"/>
               <xs:element minOccurs="0"
                           name="P_ACCOUNT"
                           type="xs:string"
                           id="_3A__DEVICES___d18e38117-1_P_ACCOUNT"/>
               <xs:element minOccurs="0"
                           name="ID_BILLING_USERS"
                           type="xs:integer"
                           id="_3A__DEVICES___d18e38118-1_ID_BILLING"/>
               <xs:element minOccurs="0"
                           ref="default_db__x3A__COMPANIES:ID_BILLING_USERS"
                           id="_3A__DEVICES___d18e38119-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
                                                         system_cache__appinfo:name="ID_BILLING_USERS"
                                                         system_cache__appinfo:xpath="default_db__x3A__COMPANIES:ID_BILLING_USERS/ID"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                     <xs:documentation>
                    TODO CHECK IF THIS IS CORRECT FLAT RELATION! WAS GENERATED #3992 !!!
                </xs:documentation>
                  </xs:annotation>
               </xs:element>
               <xs:element minOccurs="0"
                           name="ID_SERVICES"
                           type="xs:integer"
                           id="_3A__DEVICES___d18e38126-1_ID_SERVICE"/>
               <xs:element minOccurs="0"
                           ref="default_db__x3A__SERVICES:SERVICES"
                           id="_3A__DEVICES___d18e38127-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
                                                         system_cache__appinfo:name="ID_SERVICES"
                                                         system_cache__appinfo:xpath="default_db__x3A__SERVICES:SERVICES/ID"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                     <xs:documentation>
                    TODO CHECK IF THIS IS CORRECT FLAT RELATION! WAS GENERATED #183
                </xs:documentation>
                  </xs:annotation>
               </xs:element>
               <xs:element minOccurs="0"
                           name="A_CLASSIFIED"
                           type="xs:string"
                           id="_3A__DEVICES___d18e38134-1_A_CLASSIFI"/>
               <xs:element minOccurs="0"
                           name="ADM_PASSWD"
                           type="xs:string"
                           id="_3A__DEVICES___d18e38135-1_ADM_PASSWD"/>
               <xs:element minOccurs="0"
                           name="S_PASSWD"
                           type="xs:string"
                           id="_3A__DEVICES___d18e38136-1_S_PASSWD"/>
               <xs:element minOccurs="0"
                           name="ADMIN_USERS_ID"
                           type="xs:integer"
                           id="_3A__DEVICES___d18e38137-1_ADMIN_USER"/>
               <xs:element minOccurs="0"
                           ref="default_db__x3A__ADMIN_USERS:ADMIN_USERS_ID"
                           id="_3A__DEVICES___d18e38138-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
                                                         system_cache__appinfo:name="ADMIN_USERS_ID"
                                                         system_cache__appinfo:xpath="default_db__x3A__ADMIN_USERS:ADMIN_USERS_ID/ID"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                     <xs:documentation>
                    TODO CHECK IF THIS IS CORRECT FLAT RELATION! WAS GENERATED #185
                </xs:documentation>
                  </xs:annotation>
               </xs:element>
            </xs:sequence>
            <xs:attribute name="label" type="xs:string" id="_3A__DEVICES___d18e38145-1_label"/>
            <xs:assert test="@label = concat(ID, ' ', T_DEVICE_TYPE)"
                       id="_3A__DEVICES___d18e38146-1"/>
         </xs:restriction>
      </xs:complexContent>
   </xs:complexType>
   <xs:element name="MASZYNA"
               type="default_db__x3A__DEVICES:MASZYNA"
               id="_3A__DEVICES___d18e38147-1_MASZYNA"/>
   <xs:element name="ID_DEVICE"
               type="default_db__x3A__DEVICES:DEVICES"
               id="_3A__DEVICES___d18e38148-1_ID_DEVICE"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
      <xs:annotation>
         <xs:documentation>Uzyte glownie w Korespondencji</xs:documentation>
      </xs:annotation>
   </xs:element>
   <xs:element name="PARENT_ID_DEVICE"
               type="default_db__x3A__DEVICES:DEVICES"
               id="_3A__DEVICES___d18e38152-1_PARENT_ID_"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
      <xs:annotation>
         <xs:documentation>Uzyte w telboxach do tworzenia struktury</xs:documentation>
      </xs:annotation>
   </xs:element>
</xs:schema>