首页 发现 帮助
登录
bn
/
se
2
0
派生 0
文件 工单管理 0 合并请求 0 Wiki
目录树: c17acef6f7
分支列表 标签列表
se
/
SE
/
schema
/
ant-object
/
default_db.BUILDINGS
/
BUILDINGS
/
BUILDINGS.xsd

BUILDINGS.xsd 49 KB
文件历史 原始文件

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670 
  1. <?xml version="1.0" encoding="UTF-8"?>
    2. 

  2. <xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema"
    3. 

  3.    xmlns:default_db__x3A__BUILDINGS="https://biuro.biall-net.pl/wfs/default_db/table/BUILDINGS.xsd"
    4. 

  4.    xmlns:gml="http://www.opengis.net/gml/3.2"
    5. 

  5.    xmlns:default_db__x3A__COMPANIES="https://biuro.biall-net.pl/wfs/default_db/table/COMPANIES.xsd"
    6. 

  6.    xmlns:p5_tr_map="http://biuro.biall-net.pl/xmlschema_procesy5/default_db_xml_cache/procesy5_translate_map.xsd"
    7. 

  7.    xmlns:vc="http://www.w3.org/2007/XMLSchema-versioning"
    8. 

  8.    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"
    9. 

  9.    xmlns:system_cache__appinfo="http://biuro.biall-net.pl/xmlschema_procesy5/default_db_xml_cache/appinfo.xsd"
    10. 

  10.    xmlns:p5Type="http://biuro.biall-net.pl/p5/schema/types"
    11. 

  11.    xmlns:default_db__x3A__TERYT_adresy="https://biuro.biall-net.pl/wfs/default_db/table/TERYT_adresy.xsd"
    12. 

  12.    xmlns:fix_se_defaultdb_schema="http://biuro.biall-net.pl/xmlschema_procesy5/WPS_Functions/fix_se_defaultdb_schema/fix_se_defaultdb_schema.xsd"
    13. 

  13.    xmlns:default_db__x3A__ADMIN_USERS="https://biuro.biall-net.pl/wfs/default_db/table/ADMIN_USERS.xsd"
    14. 

  14.    xmlns:default_db__x3A__CRM_LISTA_ZASOBOW="https://biuro.biall-net.pl/wfs/default_db/table/CRM_LISTA_ZASOBOW.xsd"
    15. 

  15.    xmlns:default_db__x3A__IN7_MK_BAZA_DYSTRYBUCJI="https://biuro.biall-net.pl/wfs/default_db/table/IN7_MK_BAZA_DYSTRYBUCJI.xsd"
    16. 

  16.    xmlns:default_db__x3A__TERYT_SIMC="https://biuro.biall-net.pl/wfs/default_db/table/TERYT_SIMC.xsd"
    17. 

  17.    xmlns:default_db__x3A__USERS2_MARKETING="https://biuro.biall-net.pl/wfs/default_db/table/USERS2_MARKETING.xsd"
    18. 

  18.    elementFormDefault="qualified"
    19. 

  19.    targetNamespace="https://biuro.biall-net.pl/wfs/default_db/table/BUILDINGS.xsd"
    20. 

  20.    vc:minVersion="1.1"
    21. 

  21.    xmlns:default_db__x3A__MK_Rewiry="https://biuro.biall-net.pl/wfs/default_db/table/MK_Rewiry.xsd">
    22. 

  22.    <xs:import namespace="http://www.opengis.net/gml/3.2"
    23. 

  23.       schemaLocation="http://www.opengis.net/gml/3.2"/>
    24. 

  24.    <xs:import namespace="http://biuro.biall-net.pl/p5/schema/types"
    25. 

  25.       schemaLocation="../../../types.xsd"/>
    26. 

  26.    <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/table/COMPANIES.xsd"
    27. 

  27.       schemaLocation="../../default_db.COMPANIES/COMPANIES/COMPANIES.xsd"/>
    28. 

  28.    <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/table/TERYT_adresy.xsd"
    29. 

  29.       schemaLocation="../../default_db.TERYT_adresy/TERYT_adresy/TERYT_adresy.xsd"/>
    30. 

  30.    <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/table/ADMIN_USERS.xsd"
    31. 

  31.       schemaLocation="../../default_db.ADMIN_USERS/ADMIN_USERS/ADMIN_USERS.xsd"/>
    32. 

  32.    <xs:import
    33. 

  33.       namespace="https://biuro.biall-net.pl/wfs/default_db/table/IN7_MK_BAZA_DYSTRYBUCJI.xsd"
    34. 

  34.       schemaLocation="../../default_db.IN7_MK_BAZA_DYSTRYBUCJI/IN7_MK_BAZA_DYSTRYBUCJI/IN7_MK_BAZA_DYSTRYBUCJI.xsd"/>
    35. 

  35.    <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/table/CRM_LISTA_ZASOBOW.xsd"
    36. 

  36.       schemaLocation="../../default_db.CRM_LISTA_ZASOBOW/CRM_LISTA_ZASOBOW/CRM_LISTA_ZASOBOW.xsd"/>
    37. 

  37.    <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/table/TERYT_SIMC.xsd"
    38. 

  38.       schemaLocation="../../default_db.TERYT_SIMC/TERYT_SIMC/TERYT_SIMC.xsd"/>
    39. 

  39.    <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/table/USERS2_MARKETING.xsd"
    40. 

  40.       schemaLocation="../../default_db.USERS2_MARKETING/USERS2_MARKETING/USERS2_MARKETING.xsd"/>
    41. 

  41.    <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/table/MK_Rewiry.xsd"
    42. 

  42.       schemaLocation="../../default_db.MK_Rewiry/MK_Rewiry/MK_Rewiry.xsd"/>
    43. 

  43.    <xs:complexType name="BUILDINGS">
    44. 

  44.       <xs:annotation>
    45. 

  45.          <xs:appinfo>
    46. 

  46.             <system_cache__appinfo:heritage>
    47. 

  47.                <system_cache__appinfo:inherit system_cache__appinfo:inherit_ref="default_db:BUILDINGS" system_cache__appinfo:heritage_acl="true">
    48. 

  48.                   <system_cache__appinfo:acl_rule_inherit_to_all_same_name_elements_and_refs/>
    49. 

  49.                   <acl_rule_inherit_to_all_refs_by_primary/>
    50. 

  50.                   <acl_rule_inherit_to_all_refs_by_local_element system_cache__appinfo:acl_rule_inherit_local_element_name="P_ID"/>
    51. 

  51.                </system_cache__appinfo:inherit>
    52. 

  52.                <system_cache__appinfo:exherit_all system_cache__appinfo:heritage_acl="true" system_cache__appinfo:heritage_sort="true"/>
    53. 

  53.             </system_cache__appinfo:heritage>
    54. 

  54.          </xs:appinfo>
    55. 

  55.       </xs:annotation>
    56. 

  56.       <xs:sequence>
    57. 

  57.          <xs:element name="ID" type="p5Type:integer"/>
    58. 

  58.          <xs:element name="geoportal_gml_punkty_adr_gml_id" minOccurs="0" type="p5Type:string"/>
    59. 

  59.          <xs:element name="SIMC" minOccurs="0" type="p5Type:string"/>
    60. 

  60.          <xs:element minOccurs="0" ref="default_db__x3A__TERYT_SIMC:TERYT_SIMC">
    61. 

  61.             <xs:annotation>
    62. 

  62.                <xs:documentation>Opcjonalne dowiazanie sie do jakiegos adresu i zaciagniecie z niego danych lokalne</xs:documentation>
    63. 

  63.             </xs:annotation>
    64. 

  64.          </xs:element>
    65. 

  65.          <xs:element name="A_RECORD_CREATE_DATE" minOccurs="0" default="" type="p5Type:string"/>
    66. 

  66.          <xs:element name="A_RECORD_CREATE_AUTHOR" minOccurs="0" default="" type="p5Type:string"/>
    67. 

  67.          <xs:element name="A_RECORD_UPDATE_DATE" minOccurs="0" type="p5Type:dateTime"/>
    68. 

  68.          <xs:element name="A_RECORD_UPDATE_AUTHOR" minOccurs="0" default="" type="p5Type:string"/>
    69. 

  69.          <xs:element name="L_APPOITMENT_DATE" minOccurs="0" default="" type="p5Type:string"/>
    70. 

  70.          <xs:element name="L_APPOITMENT_USER" minOccurs="0" default="" type="p5Type:string"/>
    71. 

  71.          <xs:element ref="default_db__x3A__ADMIN_USERS:L_APPOITMENT_USER">
    72. 

  72.             <xs:annotation>
    73. 

  73.                <xs:appinfo>
    74. 

  74.                   <system_cache__appinfo:flat_relation_cache>
    75. 

  75.                      <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"/>
    76. 

  76.                   </system_cache__appinfo:flat_relation_cache>
    77. 

  77.                </xs:appinfo>
    78. 

  78.             </xs:annotation>
    79. 

  79.          </xs:element>
    80. 

  80.          <xs:element name="L_APPOITMENT_PERIOD" minOccurs="0" default="" type="p5Type:string"/>
    81. 

  81.          <xs:element name="L_APPOITMENT_INFO" minOccurs="0" default="" type="p5Type:string"/>
    82. 

  82.          <xs:element name="L_APPOITMENT_TYPE" minOccurs="0" nillable="true" default=""
    83. 

  83.             type="xs:string"> </xs:element>
    84. 

  84.          <xs:element name="A_PROBLEM" minOccurs="0" nillable="true" default="" type="xs:string"> </xs:element>
    85. 

  85.          <xs:element name="A_PROBLEM_DESC" minOccurs="0" default="" type="p5Type:string"/>
    86. 

  86.          <xs:element name="A_PROBLEM_DATE" minOccurs="0" default="" type="p5Type:string"/>
    87. 

  87.          <xs:element name="A_STATUS" minOccurs="0" nillable="true" default="MONITOR"
    88. 

  88.             type="default_db__x3A__BUILDINGS:A_STATUS_Type"/>
    89. 

  89.          <xs:element name="A_STATUS_INFO" minOccurs="0" default="" type="p5Type:string"/>
    90. 

  90.          <xs:element name="A_STATUS_LASTCHANGE_DATE" minOccurs="0" default="" type="p5Type:string"/>
    91. 

  91.          <xs:element name="A_UPDATE_DATE" minOccurs="0" default="" type="p5Type:string"/>
    92. 

  92.          <xs:element name="A_ADM_COMPANY" minOccurs="0" default="" type="p5Type:string"/>
    93. 

  93.          <xs:element name="S_ADMIN_NAME" minOccurs="0" default="" type="p5Type:string"/>
    94. 

  94.          <xs:element name="S_ADDRESS_CITY" minOccurs="0" default="" type="p5Type:string"/>
    95. 

  95.          <xs:element name="S_ADDRESS_POST_CODE" minOccurs="0" default="" type="p5Type:string"/>
    96. 

  96.          <xs:element name="S_ADDRESS_POST_OFFICE" minOccurs="0" default="" type="p5Type:string"/>
    97. 

  97.          <xs:element name="S_ADDRESS_STREET" minOccurs="0" nillable="true" default=""
    98. 

  98.             type="p5Type:string"/>
    99. 

  99.          <xs:element name="S_ADDRESS_STREET_FULL" minOccurs="0" type="p5Type:string"/>
    100. 

  100.          <xs:element name="S_ADDRESS_HOUSE" minOccurs="0" default="" type="p5Type:string"/>
    101. 

  101.          <xs:element name="S_OTHER_INFO" minOccurs="0" default="" type="p5Type:string"/>
    102. 

  102.          <xs:element name="P_ADMIN_NAME" minOccurs="0" default="" type="p5Type:string"/>
    103. 

  103.          <xs:element name="P_ADDRESS_CITY" minOccurs="0" default="" type="p5Type:string"/>
    104. 

  104.          <xs:element name="P_ADDRESS_POST_CODE" minOccurs="0" default="" type="p5Type:string"/>
    105. 

  105.          <xs:element name="P_ADDRESS_POST_OFFICE" minOccurs="0" default="" type="p5Type:string"/>
    106. 

  106.          <xs:element name="P_ADDRESS_STREET" minOccurs="0" default="" type="p5Type:string"/>
    107. 

  107.          <xs:element name="P_ADDRESS_HOUSE" minOccurs="0" default="" type="p5Type:string"/>
    108. 

  108.          <xs:element name="P_OTHER_INFO" minOccurs="0" default="" type="p5Type:string"/>
    109. 

  109.          <xs:element name="P_DEAL_DATE" minOccurs="0" default="" type="p5Type:string"/>
    110. 

  110.          <xs:element name="P_DEALNUMBER" minOccurs="0" default="" type="p5Type:string"/>
    111. 

  111.          <xs:element name="P_DEALEXPIRE" minOccurs="0" default="" type="p5Type:string"/>
    112. 

  112.          <xs:element name="P_DEAL_DETAIL" minOccurs="0" default="" type="p5Type:string"/>
    113. 

  113.          <xs:element name="P_DEAL_LOCATION" minOccurs="0" default="" type="p5Type:string"/>
    114. 

  114.          <xs:element name="T_NETWORK_SERVER" minOccurs="0" default="" type="p5Type:string"/>
    115. 

  115.          <xs:element name="T_TOPOLOGY_PLACE" minOccurs="0" default="" type="p5Type:string"/>
    116. 

  116.          <xs:element name="T_BUILDING_TYPE" minOccurs="0" default="N/S;"
    117. 

  117.             type="default_db__x3A__BUILDINGS:T_BUILDING_TYPE_Type"/>
    118. 

  118.          <xs:element name="T_BUILDING_SAVE" minOccurs="0" default="" type="p5Type:string"/>
    119. 

  119.          <xs:element name="T_BUILDING_POWER" minOccurs="0" default="" type="p5Type:string"/>
    120. 

  120.          <xs:element name="T_INSTALACJA_W_CIAGU_DNI" minOccurs="0" nillable="true" default=""
    121. 

  121.             type="p5Type:string"/>
    122. 

  122.          <xs:element name="T_WORKPOINTS" minOccurs="0" type="p5Type:string"/>
    123. 

  123.          <xs:element name="T_WORKPOINTS_VALUE" minOccurs="0" default="" type="p5Type:string"/>
    124. 

  124.          <xs:element name="T_WORKPOINTS_TYPE" minOccurs="0" nillable="true"
    125. 

  125.             type="default_db__x3A__BUILDINGS:T_WORKPOINTS_TYPE_Type"/>
    126. 

  126.          <xs:element name="T_WORKPOINTS_USER" minOccurs="0" default="" type="p5Type:string"/>
    127. 

  127.          <xs:element name="T_WORKPOINTS_DATE" minOccurs="0" default="" type="p5Type:string"/>
    128. 

  128.          <xs:element name="T_WHO_CONNECTED" minOccurs="0" default="" type="p5Type:string"/>
    129. 

  129.          <xs:element name="T_WHEN_CONNECTED" minOccurs="0" default="" type="p5Type:string"/>
    130. 

  130.          <xs:element name="T_TEL_KONKURENCJA_OPER" minOccurs="0" nillable="true" type="xs:string"/>
    131. 

  131.          <xs:element name="T_TV_KONKURENCJA_OPER" minOccurs="0" nillable="true" type="xs:string"/>
    132. 

  132.          <xs:element name="T_LAN_KONKURENCJA_OPER" minOccurs="0" nillable="true"
    133. 

  133.             type="default_db__x3A__BUILDINGS:T_LAN_KONKURENCJA_OPER_Type"/>
    134. 

  134.          <xs:element name="B_INVENTORY_DATE" minOccurs="0" default="" type="p5Type:string"/>
    135. 

  135.          <xs:element name="M_ZRYWKA_DATE" minOccurs="0" nillable="true" type="p5Type:date"/>
    136. 

  136.          <xs:element name="M_ZRYWKA_NUMBER" minOccurs="0" default="" type="p5Type:string"/>
    137. 

  137.          <xs:element name="M_REWIR" minOccurs="0" default="" type="p5Type:string"/>
    138. 

  138.          <xs:element ref="default_db__x3A__MK_Rewiry:MK_Rewiry">
    139. 

  139.             <xs:annotation>
    140. 

  140.                <xs:appinfo>
    141. 

  141.                   <system_cache__appinfo:flat_relation_cache>
    142. 

  142.                      <system_cache__appinfo:source system_cache__appinfo:ref_engine="view" system_cache__appinfo:name="M_REWIR" system_cache__appinfo:xpath="default_db__x3A__MK_Rewiry:MK_Rewiry/NAZWA_REWI"/>
    143. 

  143.                   </system_cache__appinfo:flat_relation_cache>
    144. 

  144.                </xs:appinfo>
    145. 

  145.                
    146. 

  146.             </xs:annotation>
    147. 

  147.          </xs:element>
    148. 

  148.          <xs:element name="M_PARAMETRY" minOccurs="0" default="" type="p5Type:string"/>
    149. 

  149.          <xs:element name="M_DIST_OPTIONS" minOccurs="0" nillable="true" type="xs:string"> </xs:element>
    150. 

  150.          <xs:element name="M_DIRECT_MARKETING_DATE" minOccurs="0" nillable="true" type="p5Type:date"/>
    151. 

  151.          <xs:element name="M_DATA_ZASIEDLENIA" minOccurs="0" nillable="true" type="p5Type:date"/>
    152. 

  152.          <xs:element name="ID_PROJECT" minOccurs="0" nillable="true" type="p5Type:integer"/>
    153. 

  153.          <xs:element ref="default_db__x3A__IN7_MK_BAZA_DYSTRYBUCJI:ID_PROJECT">
    154. 

  154.             <xs:annotation>
    155. 

  155.                <xs:appinfo>
    156. 

  156.                   <system_cache__appinfo:flat_relation_cache>
    157. 

  157.                      <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"/>
    158. 

  158.                   </system_cache__appinfo:flat_relation_cache>
    159. 

  159.                </xs:appinfo>
    160. 

  160.             </xs:annotation>
    161. 

  161.          </xs:element>
    162. 

  162.          <xs:element name="path" minOccurs="0" nillable="true" default="" type="p5Type:string"/>
    163. 

  163.          <xs:element name="P_NR_DZIALKI" minOccurs="0" default="" type="p5Type:string"/>
    164. 

  164.          <xs:element name="P_NR_KW" minOccurs="0" default="" type="p5Type:string"/>
    165. 

  165.          <xs:element name="P_OTHER_DOC" minOccurs="0" default="" type="p5Type:string"/>
    166. 

  166.          <xs:element name="P_PESEL" minOccurs="0" default="" type="p5Type:string"/>
    167. 

  167.          <xs:element name="P_KRS" minOccurs="0" default="" type="p5Type:string"/>
    168. 

  168.          <xs:element name="P_ADDRESS" minOccurs="0" default="" type="p5Type:string"/>
    169. 

  169.          <xs:element name="P_NAME" minOccurs="0" default="" type="p5Type:string"/>
    170. 

  170.          <xs:element name="P_ACCOUNT" minOccurs="0" type="p5Type:string"/>
    171. 

  171.          <xs:element name="P_OSIEDLE" minOccurs="0" default="" type="p5Type:string"/>
    172. 

  172.          <xs:element name="T_BUILDING_PIETRA" minOccurs="0" type="p5Type:integer"/>
    173. 

  173.          <xs:element name="T_BUILDING_PIWNICA" minOccurs="0" default="N/S;" type="xs:string"> </xs:element>
    174. 

  174.          <xs:element name="T_BUILDING_KLATKI" minOccurs="0" type="p5Type:integer"/>
    175. 

  175.          <xs:element name="T_BUILDING_MIESZKANIA" minOccurs="0" type="p5Type:integer"/>
    176. 

  176.          <xs:element name="A_CLASSIFIED" minOccurs="0" type="p5Type:string"/>
    177. 

  177.          <xs:element name="M_LAST_STICKER_DATE" minOccurs="0" nillable="true" type="p5Type:date"/>
    178. 

  178.          <xs:element name="the_geom" minOccurs="0" nillable="true" type="p5Type:polygon"/>
    179. 

  179.          <xs:element name="SYNC_SQIX_STATUS" minOccurs="0" type="p5Type:string"/>
    180. 

  180.          <xs:element name="gid" minOccurs="0" nillable="true" type="p5Type:integer"/>
    181. 

  181.          <xs:element name="T_ADDRESS_CLASS" minOccurs="0" nillable="true" default=""
    182. 

  182.             type="p5Type:string"/>
    183. 

  183.          <xs:element name="B_LINK" minOccurs="0" nillable="true" default="" type="p5Type:string"/>
    184. 

  184.          <xs:element name="B_URL" minOccurs="0" nillable="true" default="" type="p5Type:string"/>
    185. 

  185.          <xs:element name="B_XYZ" minOccurs="0" nillable="true" default="" type="p5Type:string"/>
    186. 

  186.          <xs:element name="B_ASCII" minOccurs="0" nillable="true" default="" type="p5Type:text"/>
    187. 

  187.          <xs:element name="CRM_LISTA_ZASOBOW_ID" minOccurs="0" type="p5Type:integer"/>
    188. 

  188.          <xs:element ref="default_db__x3A__CRM_LISTA_ZASOBOW:CRM_LISTA_ZASOBOW_ID">
    189. 

  189.             <xs:annotation>
    190. 

  190.                <xs:appinfo>
    191. 

  191.                   <system_cache__appinfo:flat_relation_cache>
    192. 

  192.                      <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"/>
    193. 

  193.                   </system_cache__appinfo:flat_relation_cache>
    194. 

  194.                </xs:appinfo>
    195. 

  195.             </xs:annotation>
    196. 

  196.          </xs:element>
    197. 

  197.          <xs:element name="etykieta_x" minOccurs="0" nillable="true" type="p5Type:decimal"/>
    198. 

  198.          <xs:element name="etykieta_y" minOccurs="0" nillable="true" type="p5Type:decimal"/>
    199. 

  199.          <xs:element name="__Rozdzielcza_Kabel_Swiatlowodowy_wsg84" minOccurs="0" nillable="true"
    200. 

  200.             type="p5Type:integer"/>
    201. 

  201.          <xs:element name="__MK_Rewiry__STATUS" minOccurs="0" type="p5Type:string"/>
    202. 

  202.          <xs:element name="ID_BILLING_USERS" minOccurs="0" type="p5Type:integer"/>
    203. 

  203.          <xs:element ref="default_db__x3A__COMPANIES:ID_BILLING_USERS" minOccurs="0">
    204. 

  204.             <xs:annotation>
    205. 

  205.                <xs:appinfo>
    206. 

  206.                   <system_cache__appinfo:flat_relation_cache>
    207. 

  207.                      <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"/>
    208. 

  208.                   </system_cache__appinfo:flat_relation_cache>
    209. 

  209.                </xs:appinfo>
    210. 

  210.             </xs:annotation>
    211. 

  211.          </xs:element>
    212. 

  212.          <xs:element name="ID_BILLING_USERS_ADMIN" minOccurs="0" type="p5Type:integer"/>
    213. 

  213.          <xs:element ref="default_db__x3A__COMPANIES:ID_BILLING_USERS_ADMIN" minOccurs="0">
    214. 

  214.             <xs:annotation>
    215. 

  215.                <xs:appinfo>
    216. 

  216.                   <system_cache__appinfo:flat_relation_cache>
    217. 

  217.                      <system_cache__appinfo:source system_cache__appinfo:ref_engine="view" system_cache__appinfo:name="ID_BILLING_USERS_ADMIN" system_cache__appinfo:xpath="default_db__x3A__COMPANIES:ID_BILLING_USERS_ADMIN/ID"/>
    218. 

  218.                   </system_cache__appinfo:flat_relation_cache>
    219. 

  219.                </xs:appinfo>
    220. 

  220.             </xs:annotation>
    221. 

  221.          </xs:element>
    222. 

  222.          <xs:element maxOccurs="unbounded" minOccurs="0"
    223. 

  223.             ref="default_db__x3A__USERS2_MARKETING:USERS2_MARKETING">
    224. 

  224.             <xs:annotation>
    225. 

  225.                <xs:appinfo>
    226. 

  226.                   <system_cache__appinfo:flat_relation_cache>
    227. 

  227.                      <system_cache__appinfo:source system_cache__appinfo:ref_engine="view" system_cache__appinfo:name="S_ADDRESS_STREET" system_cache__appinfo:xpath="default_db__x3A__USERS2_MARKETING:USERS2_MARKETING/T_TELBOX_BUILDING_IN"/>
    228. 

  228.                   </system_cache__appinfo:flat_relation_cache>
    229. 

  229.                </xs:appinfo>
    230. 

  230.                <xs:documentation>Reff- backref jest od marketingu</xs:documentation>
    231. 

  231.             </xs:annotation>
    232. 

  232.          </xs:element>
    233. 

  233.       </xs:sequence>
    234. 

  234.    </xs:complexType>
    235. 

  235.    <xs:element name="BUILDINGS" type="default_db__x3A__BUILDINGS:BUILDINGS"/>
    236. 

  236.    <xs:complexType name="Budynek_blok">
    237. 

  237.       <xs:complexContent>
    238. 

  238.          <xs:restriction base="default_db__x3A__BUILDINGS:BUILDINGS">
    239. 

  239.             <xs:sequence>
    240. 

  240.                <xs:element name="ID" type="p5Type:integer"/>
    241. 

  241.                <xs:element name="geoportal_gml_punkty_adr_gml_id" minOccurs="0" type="p5Type:string"/>
    242. 

  242.                <xs:element name="SIMC" minOccurs="0" type="p5Type:string"/>
    243. 

  243.                <xs:element minOccurs="0" ref="default_db__x3A__TERYT_SIMC:TERYT_SIMC">
    244. 

  244.                   <xs:annotation>
    245. 

  245.                      <xs:documentation>Opcjonalne dowiazanie sie do jakiegos adresu i zaciagniecie z niego danych lokalne</xs:documentation>
    246. 

  246.                   </xs:annotation>
    247. 

  247.                </xs:element>
    248. 

  248.                <xs:element name="A_RECORD_CREATE_DATE" minOccurs="0" default="" type="p5Type:string"/>
    249. 

  249.                <xs:element name="A_RECORD_CREATE_AUTHOR" minOccurs="0" default=""
    250. 

  250.                   type="p5Type:string"/>
    251. 

  251.                <xs:element name="A_RECORD_UPDATE_DATE" minOccurs="0" type="p5Type:dateTime"/>
    252. 

  252.                <xs:element name="A_RECORD_UPDATE_AUTHOR" minOccurs="0" default=""
    253. 

  253.                   type="p5Type:string"/>
    254. 

  254.                <xs:element name="L_APPOITMENT_DATE" minOccurs="0" default="" type="p5Type:string"/>
    255. 

  255.                <xs:element name="L_APPOITMENT_USER" minOccurs="0" default="" type="p5Type:string"/>
    256. 

  256.                <xs:element ref="default_db__x3A__ADMIN_USERS:L_APPOITMENT_USER">
    257. 

  257.                   <xs:annotation>
    258. 

  258.                      <xs:appinfo>
    259. 

  259.                         <system_cache__appinfo:flat_relation_cache>
    260. 

  260.                            <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"/>
    261. 

  261.                         </system_cache__appinfo:flat_relation_cache>
    262. 

  262.                      </xs:appinfo>
    263. 

  263.                   </xs:annotation>
    264. 

  264.                </xs:element>
    265. 

  265.                <xs:element name="L_APPOITMENT_PERIOD" minOccurs="0" default="" type="p5Type:string"/>
    266. 

  266.                <xs:element name="L_APPOITMENT_INFO" minOccurs="0" default="" type="p5Type:string"/>
    267. 

  267.                <xs:element name="L_APPOITMENT_TYPE" minOccurs="0" nillable="true" default=""
    268. 

  268.                   type="xs:string"> </xs:element>
    269. 

  269.                <xs:element name="A_PROBLEM" minOccurs="0" nillable="true" default=""
    270. 

  270.                   type="xs:string"> </xs:element>
    271. 

  271.                <xs:element name="A_PROBLEM_DESC" minOccurs="0" default="" type="p5Type:string"/>
    272. 

  272.                <xs:element name="A_PROBLEM_DATE" minOccurs="0" default="" type="p5Type:string"/>
    273. 

  273.                <xs:element name="A_STATUS" minOccurs="0" nillable="true" default="MONITOR"
    274. 

  274.                   type="default_db__x3A__BUILDINGS:A_STATUS_Type"> </xs:element>
    275. 

  275.                <xs:element name="A_STATUS_INFO" minOccurs="0" default="" type="p5Type:string"/>
    276. 

  276.                <xs:element name="A_STATUS_LASTCHANGE_DATE" minOccurs="0" default=""
    277. 

  277.                   type="p5Type:string"/>
    278. 

  278.                <xs:element name="A_UPDATE_DATE" minOccurs="0" default="" type="p5Type:string"/>
    279. 

  279.                <xs:element name="A_ADM_COMPANY" minOccurs="0" default="" type="p5Type:string"/>
    280. 

  280.                <xs:element name="S_ADMIN_NAME" minOccurs="0" default="" type="p5Type:string"/>
    281. 

  281.                <xs:element name="S_ADDRESS_CITY" minOccurs="0" default="" type="p5Type:string"/>
    282. 

  282.                <xs:element name="S_ADDRESS_POST_CODE" minOccurs="0" default="" type="p5Type:string"/>
    283. 

  283.                <xs:element name="S_ADDRESS_POST_OFFICE" minOccurs="0" default=""
    284. 

  284.                   type="p5Type:string"/>
    285. 

  285.                <xs:element name="S_ADDRESS_STREET" minOccurs="0" nillable="true" default=""
    286. 

  286.                   type="p5Type:string"/>
    287. 

  287.                <xs:element name="S_ADDRESS_STREET_FULL" minOccurs="0" type="p5Type:string"/>
    288. 

  288.                <xs:element name="S_ADDRESS_HOUSE" minOccurs="0" default="" type="p5Type:string"/>
    289. 

  289.                <xs:element name="S_OTHER_INFO" minOccurs="0" default="" type="p5Type:string"/>
    290. 

  290.                <xs:element name="P_ADMIN_NAME" minOccurs="0" default="" type="p5Type:string"/>
    291. 

  291.                <xs:element name="P_ADDRESS_CITY" minOccurs="0" default="" type="p5Type:string"/>
    292. 

  292.                <xs:element name="P_ADDRESS_POST_CODE" minOccurs="0" default="" type="p5Type:string"/>
    293. 

  293.                <xs:element name="P_ADDRESS_POST_OFFICE" minOccurs="0" default=""
    294. 

  294.                   type="p5Type:string"/>
    295. 

  295.                <xs:element name="P_ADDRESS_STREET" minOccurs="0" default="" type="p5Type:string"/>
    296. 

  296.                <xs:element name="P_ADDRESS_HOUSE" minOccurs="0" default="" type="p5Type:string"/>
    297. 

  297.                <xs:element name="P_OTHER_INFO" minOccurs="0" default="" type="p5Type:string"/>
    298. 

  298.                <xs:element name="P_DEAL_DATE" minOccurs="0" default="" type="p5Type:string"/>
    299. 

  299.                <xs:element name="P_DEALNUMBER" minOccurs="0" default="" type="p5Type:string"/>
    300. 

  300.                <xs:element name="P_DEALEXPIRE" minOccurs="0" default="" type="p5Type:string"/>
    301. 

  301.                <xs:element name="P_DEAL_DETAIL" minOccurs="0" default="" type="p5Type:string"/>
    302. 

  302.                <xs:element name="P_DEAL_LOCATION" minOccurs="0" default="" type="p5Type:string"/>
    303. 

  303.                <xs:element name="T_NETWORK_SERVER" minOccurs="0" default="" type="p5Type:string"/>
    304. 

  304.                <xs:element name="T_TOPOLOGY_PLACE" minOccurs="0" default="" type="p5Type:string"/>
    305. 

  305.                <xs:element name="T_BUILDING_SAVE" minOccurs="0" default="" type="p5Type:string"/>
    306. 

  306.                <xs:element name="T_BUILDING_POWER" minOccurs="0" default="" type="p5Type:string"/>
    307. 

  307.                <xs:element name="T_INSTALACJA_W_CIAGU_DNI" minOccurs="0" nillable="true" default=""
    308. 

  308.                   type="p5Type:string"/>
    309. 

  309.                <xs:element name="T_WORKPOINTS" minOccurs="0" type="p5Type:string"/>
    310. 

  310.                <xs:element name="T_WORKPOINTS_VALUE" minOccurs="0" default="" type="p5Type:string"/>
    311. 

  311.                <xs:element name="T_WORKPOINTS_USER" minOccurs="0" default="" type="p5Type:string"/>
    312. 

  312.                <xs:element name="T_WORKPOINTS_DATE" minOccurs="0" default="" type="p5Type:string"/>
    313. 

  313.                <xs:element name="T_WHO_CONNECTED" minOccurs="0" default="" type="p5Type:string"/>
    314. 

  314.                <xs:element name="T_WHEN_CONNECTED" minOccurs="0" default="" type="p5Type:string"/>
    315. 

  315.                <xs:element name="T_TEL_KONKURENCJA_OPER" minOccurs="0" nillable="true"
    316. 

  316.                   type="xs:string"> </xs:element>
    317. 

  317.                <xs:element name="T_TV_KONKURENCJA_OPER" minOccurs="0" nillable="true"
    318. 

  318.                   type="xs:string"> </xs:element>
    319. 

  319.                <xs:element name="T_LAN_KONKURENCJA_OPER" minOccurs="0" nillable="true"
    320. 

  320.                   type="default_db__x3A__BUILDINGS:T_LAN_KONKURENCJA_OPER_Type"/>
    321. 

  321.                <xs:element name="B_INVENTORY_DATE" minOccurs="0" default="" type="p5Type:string"/>
    322. 

  322.                <xs:element name="M_ZRYWKA_DATE" minOccurs="0" nillable="true" type="p5Type:date"/>
    323. 

  323.                <xs:element name="M_ZRYWKA_NUMBER" minOccurs="0" default="" type="p5Type:string"/>
    324. 

  324.                <xs:element name="M_REWIR" minOccurs="0" default="" type="p5Type:string"/>
    325. 

  325.                <xs:element ref="default_db__x3A__MK_Rewiry:MK_Rewiry">
    326. 

  326.                   <xs:annotation>
    327. 

  327.                      <xs:appinfo>
    328. 

  328.                         <system_cache__appinfo:flat_relation_cache>
    329. 

  329.                            <system_cache__appinfo:source system_cache__appinfo:ref_engine="view" system_cache__appinfo:name="M_REWIR" system_cache__appinfo:xpath="default_db__x3A__MK_Rewiry:MK_Rewiry/NAZWA_REWI"/>
    330. 

  330.                         </system_cache__appinfo:flat_relation_cache>
    331. 

  331.                      </xs:appinfo>
    332. 

  332.                      <xs:documentation>
    333. 

  333.                     TODO CHECK IF THIS IS CORRECT FLAT RELATION! WAS GENERATED #4122 !!!
    334. 

  334.                 </xs:documentation>
    335. 

  335.                   </xs:annotation>
    336. 

  336.                </xs:element>
    337. 

  337.                <xs:element name="M_PARAMETRY" minOccurs="0" default="" type="p5Type:string"/>
    338. 

  338.                <xs:element name="M_DIST_OPTIONS" minOccurs="0" nillable="true" type="xs:string"> </xs:element>
    339. 

  339.                <xs:element name="M_DIRECT_MARKETING_DATE" minOccurs="0" nillable="true"
    340. 

  340.                   type="p5Type:date"/>
    341. 

  341.                <xs:element name="M_DATA_ZASIEDLENIA" minOccurs="0" nillable="true"
    342. 

  342.                   type="p5Type:date"/>
    343. 

  343.                <xs:element name="ID_PROJECT" minOccurs="0" nillable="true" type="p5Type:integer"/>
    344. 

  344.                <xs:element ref="default_db__x3A__IN7_MK_BAZA_DYSTRYBUCJI:ID_PROJECT">
    345. 

  345.                   <xs:annotation>
    346. 

  346.                      <xs:appinfo>
    347. 

  347.                         <system_cache__appinfo:flat_relation_cache>
    348. 

  348.                            <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"/>
    349. 

  349.                         </system_cache__appinfo:flat_relation_cache>
    350. 

  350.                      </xs:appinfo>
    351. 

  351.                   </xs:annotation>
    352. 

  352.                </xs:element>
    353. 

  353.                <xs:element name="path" minOccurs="0" nillable="true" default="" type="p5Type:string"/>
    354. 

  354.                <xs:element name="P_NR_DZIALKI" minOccurs="0" default="" type="p5Type:string"/>
    355. 

  355.                <xs:element name="P_NR_KW" minOccurs="0" default="" type="p5Type:string"/>
    356. 

  356.                <xs:element name="P_OTHER_DOC" minOccurs="0" default="" type="p5Type:string"/>
    357. 

  357.                <xs:element name="P_PESEL" minOccurs="0" default="" type="p5Type:string"/>
    358. 

  358.                <xs:element name="P_KRS" minOccurs="0" default="" type="p5Type:string"/>
    359. 

  359.                <xs:element name="P_ADDRESS" minOccurs="0" default="" type="p5Type:string"/>
    360. 

  360.                <xs:element name="P_NAME" minOccurs="0" default="" type="p5Type:string"/>
    361. 

  361.                <xs:element name="P_ACCOUNT" minOccurs="0" type="p5Type:string"/>
    362. 

  362.                <xs:element name="P_OSIEDLE" minOccurs="0" default="" type="p5Type:string"/>
    363. 

  363.                <xs:element name="T_BUILDING_PIETRA" minOccurs="0" type="p5Type:integer"/>
    364. 

  364.                <xs:element name="T_BUILDING_PIWNICA" minOccurs="0" default="N/S;" type="xs:string"> </xs:element>
    365. 

  365.                <xs:element name="T_BUILDING_KLATKI" minOccurs="0" type="p5Type:integer"/>
    366. 

  366.                <xs:element name="T_BUILDING_MIESZKANIA" minOccurs="0" type="p5Type:integer"/>
    367. 

  367.                <xs:element name="A_CLASSIFIED" minOccurs="0" type="p5Type:string"/>
    368. 

  368.                <xs:element name="M_LAST_STICKER_DATE" minOccurs="0" nillable="true"
    369. 

  369.                   type="p5Type:date"/>
    370. 

  370.                <xs:element name="the_geom" minOccurs="0" nillable="true" type="p5Type:polygon"/>
    371. 

  371.                <xs:element name="SYNC_SQIX_STATUS" minOccurs="0" type="p5Type:string"/>
    372. 

  372.                <xs:element name="gid" minOccurs="0" nillable="true" type="p5Type:integer"/>
    373. 

  373.                <xs:element name="T_ADDRESS_CLASS" minOccurs="0" nillable="true" default=""
    374. 

  374.                   type="p5Type:string"/>
    375. 

  375.                <xs:element name="B_LINK" minOccurs="0" nillable="true" default=""
    376. 

  376.                   type="p5Type:string"/>
    377. 

  377.                <xs:element name="B_URL" minOccurs="0" nillable="true" default=""
    378. 

  378.                   type="p5Type:string"/>
    379. 

  379.                <xs:element name="B_XYZ" minOccurs="0" nillable="true" default=""
    380. 

  380.                   type="p5Type:string"/>
    381. 

  381.                <xs:element name="B_ASCII" minOccurs="0" nillable="true" default=""
    382. 

  382.                   type="p5Type:text"/>
    383. 

  383.                <xs:element name="CRM_LISTA_ZASOBOW_ID" minOccurs="0" type="p5Type:integer"/>
    384. 

  384.                <xs:element ref="default_db__x3A__CRM_LISTA_ZASOBOW:CRM_LISTA_ZASOBOW_ID">
    385. 

  385.                   <xs:annotation>
    386. 

  386.                      <xs:appinfo>
    387. 

  387.                         <system_cache__appinfo:flat_relation_cache>
    388. 

  388.                            <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"/>
    389. 

  389.                         </system_cache__appinfo:flat_relation_cache>
    390. 

  390.                      </xs:appinfo>
    391. 

  391.                   </xs:annotation>
    392. 

  392.                </xs:element>
    393. 

  393.                <xs:element name="etykieta_x" minOccurs="0" nillable="true" type="p5Type:decimal"/>
    394. 

  394.                <xs:element name="etykieta_y" minOccurs="0" nillable="true" type="p5Type:decimal"/>
    395. 

  395.                <xs:element name="__Rozdzielcza_Kabel_Swiatlowodowy_wsg84" minOccurs="0"
    396. 

  396.                   nillable="true" type="p5Type:integer"/>
    397. 

  397.                <xs:element name="__MK_Rewiry__STATUS" minOccurs="0" type="p5Type:string"/>
    398. 

  398.                <xs:element name="ID_BILLING_USERS" minOccurs="0" type="p5Type:integer"/>
    399. 

  399.                <xs:element ref="default_db__x3A__COMPANIES:ID_BILLING_USERS" minOccurs="0">
    400. 

  400.                   <xs:annotation>
    401. 

  401.                      <xs:appinfo>
    402. 

  402.                         <system_cache__appinfo:flat_relation_cache>
    403. 

  403.                            <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"/>
    404. 

  404.                         </system_cache__appinfo:flat_relation_cache>
    405. 

  405.                      </xs:appinfo>
    406. 

  406.                   </xs:annotation>
    407. 

  407.                </xs:element>
    408. 

  408.                <xs:element name="ID_BILLING_USERS_ADMIN" minOccurs="0" type="p5Type:integer"/>
    409. 

  409.                <xs:element ref="default_db__x3A__COMPANIES:ID_BILLING_USERS_ADMIN" minOccurs="0">
    410. 

  410.                   <xs:annotation>
    411. 

  411.                      <xs:appinfo>
    412. 

  412.                         <system_cache__appinfo:flat_relation_cache>
    413. 

  413.                            <system_cache__appinfo:source system_cache__appinfo:ref_engine="view" system_cache__appinfo:name="ID_BILLING_USERS_ADMIN" system_cache__appinfo:xpath="default_db__x3A__COMPANIES:ID_BILLING_USERS_ADMIN/ID"/>
    414. 

  414.                         </system_cache__appinfo:flat_relation_cache>
    415. 

  415.                      </xs:appinfo>
    416. 

  416.                   </xs:annotation>
    417. 

  417.                </xs:element>
    418. 

  418.                <xs:element maxOccurs="unbounded" minOccurs="0"
    419. 

  419.                   ref="default_db__x3A__USERS2_MARKETING:USERS2_MARKETING">
    420. 

  420.                   <xs:annotation>
    421. 

  421.                      <xs:appinfo>
    422. 

  422.                         <system_cache__appinfo:flat_relation_cache>
    423. 

  423.                            <system_cache__appinfo:source system_cache__appinfo:ref_engine="view" system_cache__appinfo:name="S_ADDRESS_STREET" system_cache__appinfo:xpath="default_db__x3A__USERS2_MARKETING:USERS2_MARKETING/T_TELBOX_BUILDING_IN"/>
    424. 

  424.                         </system_cache__appinfo:flat_relation_cache>
    425. 

  425.                      </xs:appinfo>
    426. 

  426.                      <xs:documentation>Reff- backref jest od marketingu</xs:documentation>
    427. 

  427.                   </xs:annotation>
    428. 

  428.                </xs:element>
    429. 

  429.             </xs:sequence>
    430. 

  430.          </xs:restriction>
    431. 

  431.       </xs:complexContent>
    432. 

  432.    </xs:complexType>
    433. 

  433.    <xs:element name="Budynek_blok" type="default_db__x3A__BUILDINGS:Budynek_blok"/>
    434. 

  434.    <xs:complexType name="Dom_jednorodz">
    435. 

  435.       <xs:complexContent>
    436. 

  436.          <xs:restriction base="default_db__x3A__BUILDINGS:BUILDINGS">
    437. 

  437.             <xs:sequence>
    438. 

  438.                <xs:element name="ID" type="p5Type:integer"/>
    439. 

  439.                <xs:element name="geoportal_gml_punkty_adr_gml_id" minOccurs="0" type="p5Type:string"/>
    440. 

  440.                <xs:element name="SIMC" minOccurs="0" type="p5Type:string"/>
    441. 

  441.                <xs:element minOccurs="0" ref="default_db__x3A__TERYT_SIMC:TERYT_SIMC">
    442. 

  442.                   <xs:annotation>
    443. 

  443.                      <xs:documentation>Opcjonalne dowiazanie sie do jakiegos adresu i zaciagniecie z niego danych lokalne</xs:documentation>
    444. 

  444.                   </xs:annotation>
    445. 

  445.                </xs:element>
    446. 

  446.                <xs:element name="A_RECORD_CREATE_DATE" minOccurs="0" default="" type="p5Type:string"/>
    447. 

  447.                <xs:element name="A_RECORD_CREATE_AUTHOR" minOccurs="0" default=""
    448. 

  448.                   type="p5Type:string"/>
    449. 

  449.                <xs:element name="A_RECORD_UPDATE_DATE" minOccurs="0" type="p5Type:dateTime"/>
    450. 

  450.                <xs:element name="A_RECORD_UPDATE_AUTHOR" minOccurs="0" default=""
    451. 

  451.                   type="p5Type:string"/>
    452. 

  452.                <xs:element name="L_APPOITMENT_DATE" minOccurs="0" default="" type="p5Type:string"/>
    453. 

  453.                <xs:element name="L_APPOITMENT_USER" minOccurs="0" default="" type="p5Type:string"/>
    454. 

  454.                <xs:element ref="default_db__x3A__ADMIN_USERS:L_APPOITMENT_USER">
    455. 

  455.                   <xs:annotation>
    456. 

  456.                      <xs:appinfo>
    457. 

  457.                         <system_cache__appinfo:flat_relation_cache>
    458. 

  458.                            <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"/>
    459. 

  459.                         </system_cache__appinfo:flat_relation_cache>
    460. 

  460.                      </xs:appinfo>
    461. 

  461.                   </xs:annotation>
    462. 

  462.                </xs:element>
    463. 

  463.                <xs:element name="L_APPOITMENT_PERIOD" minOccurs="0" default="" type="p5Type:string"/>
    464. 

  464.                <xs:element name="L_APPOITMENT_INFO" minOccurs="0" default="" type="p5Type:string"/>
    465. 

  465.                <xs:element name="A_PROBLEM_DESC" minOccurs="0" default="" type="p5Type:string"/>
    466. 

  466.                <xs:element name="A_PROBLEM_DATE" minOccurs="0" default="" type="p5Type:string"/>
    467. 

  467.                <xs:element name="A_STATUS" minOccurs="0" nillable="true" default="MONITOR"
    468. 

  468.                   type="default_db__x3A__BUILDINGS:A_STATUS_Type"/>
    469. 

  469.                <xs:element name="A_STATUS_INFO" minOccurs="0" default="" type="p5Type:string"/>
    470. 

  470.                <xs:element name="A_STATUS_LASTCHANGE_DATE" minOccurs="0" default=""
    471. 

  471.                   type="p5Type:string"/>
    472. 

  472.                <xs:element name="A_UPDATE_DATE" minOccurs="0" default="" type="p5Type:string"/>
    473. 

  473.                <xs:element name="A_ADM_COMPANY" minOccurs="0" default="" type="p5Type:string"/>
    474. 

  474.                <xs:element name="S_ADMIN_NAME" minOccurs="0" default="" type="p5Type:string"/>
    475. 

  475.                <xs:element name="S_ADDRESS_CITY" minOccurs="0" default="" type="p5Type:string"/>
    476. 

  476.                <xs:element name="S_ADDRESS_POST_CODE" minOccurs="0" default="" type="p5Type:string"/>
    477. 

  477.                <xs:element name="S_ADDRESS_POST_OFFICE" minOccurs="0" default=""
    478. 

  478.                   type="p5Type:string"/>
    479. 

  479.                <xs:element name="S_ADDRESS_STREET" minOccurs="0" nillable="true" default=""
    480. 

  480.                   type="p5Type:string"/>
    481. 

  481.                <xs:element name="S_ADDRESS_STREET_FULL" minOccurs="0" type="p5Type:string"/>
    482. 

  482.                <xs:element name="S_ADDRESS_HOUSE" minOccurs="0" default="" type="p5Type:string"/>
    483. 

  483.                <xs:element name="S_OTHER_INFO" minOccurs="0" default="" type="p5Type:string"/>
    484. 

  484.                <xs:element name="P_ADMIN_NAME" minOccurs="0" default="" type="p5Type:string"/>
    485. 

  485.                <xs:element name="P_ADDRESS_CITY" minOccurs="0" default="" type="p5Type:string"/>
    486. 

  486.                <xs:element name="P_ADDRESS_POST_CODE" minOccurs="0" default="" type="p5Type:string"/>
    487. 

  487.                <xs:element name="P_ADDRESS_POST_OFFICE" minOccurs="0" default=""
    488. 

  488.                   type="p5Type:string"/>
    489. 

  489.                <xs:element name="P_ADDRESS_STREET" minOccurs="0" default="" type="p5Type:string"/>
    490. 

  490.                <xs:element name="P_ADDRESS_HOUSE" minOccurs="0" default="" type="p5Type:string"/>
    491. 

  491.                <xs:element name="P_OTHER_INFO" minOccurs="0" default="" type="p5Type:string"/>
    492. 

  492.                <xs:element name="P_DEAL_DATE" minOccurs="0" default="" type="p5Type:string"/>
    493. 

  493.                <xs:element name="P_DEALNUMBER" minOccurs="0" default="" type="p5Type:string"/>
    494. 

  494.                <xs:element name="P_DEALEXPIRE" minOccurs="0" default="" type="p5Type:string"/>
    495. 

  495.                <xs:element name="P_DEAL_DETAIL" minOccurs="0" default="" type="p5Type:string"/>
    496. 

  496.                <xs:element name="P_DEAL_LOCATION" minOccurs="0" default="" type="p5Type:string"/>
    497. 

  497.                <xs:element name="T_NETWORK_SERVER" minOccurs="0" default="" type="p5Type:string"/>
    498. 

  498.                <xs:element name="T_TOPOLOGY_PLACE" minOccurs="0" default="" type="p5Type:string"/>
    499. 

  499.                <xs:element name="T_BUILDING_SAVE" minOccurs="0" default="" type="p5Type:string"/>
    500. 

  500.                <xs:element name="T_BUILDING_POWER" minOccurs="0" default="" type="p5Type:string"/>
    501. 

  501.                <xs:element name="T_INSTALACJA_W_CIAGU_DNI" minOccurs="0" nillable="true" default=""
    502. 

  502.                   type="p5Type:string"/>
    503. 

  503.                <xs:element name="T_WORKPOINTS" minOccurs="0" type="p5Type:string"/>
    504. 

  504.                <xs:element name="T_WORKPOINTS_VALUE" minOccurs="0" default="" type="p5Type:string"/>
    505. 

  505.                <xs:element name="T_WORKPOINTS_USER" minOccurs="0" default="" type="p5Type:string"/>
    506. 

  506.                <xs:element name="T_WORKPOINTS_DATE" minOccurs="0" default="" type="p5Type:string"/>
    507. 

  507.                <xs:element name="T_WHO_CONNECTED" minOccurs="0" default="" type="p5Type:string"/>
    508. 

  508.                <xs:element name="T_WHEN_CONNECTED" minOccurs="0" default="" type="p5Type:string"/>
    509. 

  509.                <xs:element name="T_LAN_KONKURENCJA_OPER" minOccurs="0" nillable="true"
    510. 

  510.                   type="default_db__x3A__BUILDINGS:T_LAN_KONKURENCJA_OPER_Type"/>
    511. 

  511.                <xs:element name="B_INVENTORY_DATE" minOccurs="0" default="" type="p5Type:string"/>
    512. 

  512.                <xs:element name="M_ZRYWKA_DATE" minOccurs="0" nillable="true" type="p5Type:date"/>
    513. 

  513.                <xs:element name="M_ZRYWKA_NUMBER" minOccurs="0" default="" type="p5Type:string"/>
    514. 

  514.                <xs:element name="M_REWIR" minOccurs="0" default="" type="p5Type:string"/>
    515. 

  515.                <xs:element ref="default_db__x3A__MK_Rewiry:MK_Rewiry">
    516. 

  516.                   <xs:annotation>
    517. 

  517.                      <xs:appinfo>
    518. 

  518.                         <system_cache__appinfo:flat_relation_cache>
    519. 

  519.                            <system_cache__appinfo:source system_cache__appinfo:ref_engine="view" system_cache__appinfo:name="M_REWIR" system_cache__appinfo:xpath="default_db__x3A__MK_Rewiry:MK_Rewiry/NAZWA_REWI"/>
    520. 

  520.                         </system_cache__appinfo:flat_relation_cache>
    521. 

  521.                      </xs:appinfo>
    522. 

  522.                      <xs:documentation>
    523. 

  523.                     TODO CHECK IF THIS IS CORRECT FLAT RELATION! WAS GENERATED #4122 !!!
    524. 

  524.                 </xs:documentation>
    525. 

  525.                   </xs:annotation>
    526. 

  526.                </xs:element>
    527. 

  527.                <xs:element name="M_PARAMETRY" minOccurs="0" default="" type="p5Type:string"/>
    528. 

  528.                <xs:element name="M_DIRECT_MARKETING_DATE" minOccurs="0" nillable="true"
    529. 

  529.                   type="p5Type:date"/>
    530. 

  530.                <xs:element name="M_DATA_ZASIEDLENIA" minOccurs="0" nillable="true"
    531. 

  531.                   type="p5Type:date"/>
    532. 

  532.                <xs:element name="ID_PROJECT" minOccurs="0" nillable="true" type="p5Type:integer"/>
    533. 

  533.                <xs:element ref="default_db__x3A__IN7_MK_BAZA_DYSTRYBUCJI:ID_PROJECT">
    534. 

  534.                   <xs:annotation>
    535. 

  535.                      <xs:appinfo>
    536. 

  536.                         <system_cache__appinfo:flat_relation_cache>
    537. 

  537.                            <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"/>
    538. 

  538.                         </system_cache__appinfo:flat_relation_cache>
    539. 

  539.                      </xs:appinfo>
    540. 

  540.                   </xs:annotation>
    541. 

  541.                </xs:element>
    542. 

  542.                <xs:element name="path" minOccurs="0" nillable="true" default="" type="p5Type:string"/>
    543. 

  543.                <xs:element name="P_NR_DZIALKI" minOccurs="0" default="" type="p5Type:string"/>
    544. 

  544.                <xs:element name="P_NR_KW" minOccurs="0" default="" type="p5Type:string"/>
    545. 

  545.                <xs:element name="P_OTHER_DOC" minOccurs="0" default="" type="p5Type:string"/>
    546. 

  546.                <xs:element name="P_PESEL" minOccurs="0" default="" type="p5Type:string"/>
    547. 

  547.                <xs:element name="P_KRS" minOccurs="0" default="" type="p5Type:string"/>
    548. 

  548.                <xs:element name="P_ADDRESS" minOccurs="0" default="" type="p5Type:string"/>
    549. 

  549.                <xs:element name="P_NAME" minOccurs="0" default="" type="p5Type:string"/>
    550. 

  550.                <xs:element name="P_ACCOUNT" minOccurs="0" type="p5Type:string"/>
    551. 

  551.                <xs:element name="P_OSIEDLE" minOccurs="0" default="" type="p5Type:string"/>
    552. 

  552.                <xs:element name="T_BUILDING_PIETRA" minOccurs="0" type="p5Type:integer"/>
    553. 

  553.                <xs:element name="T_BUILDING_KLATKI" minOccurs="0" type="p5Type:integer"/>
    554. 

  554.                <xs:element name="T_BUILDING_MIESZKANIA" minOccurs="0" type="p5Type:integer"/>
    555. 

  555.                <xs:element name="A_CLASSIFIED" minOccurs="0" type="p5Type:string"/>
    556. 

  556.                <xs:element name="M_LAST_STICKER_DATE" minOccurs="0" nillable="true"
    557. 

  557.                   type="p5Type:date"/>
    558. 

  558.                <xs:element name="the_geom" minOccurs="0" nillable="true" type="p5Type:polygon"/>
    559. 

  559.                <xs:element name="SYNC_SQIX_STATUS" minOccurs="0" type="p5Type:string"/>
    560. 

  560.                <xs:element name="gid" minOccurs="0" nillable="true" type="p5Type:integer"/>
    561. 

  561.                <xs:element name="T_ADDRESS_CLASS" minOccurs="0" nillable="true" default=""
    562. 

  562.                   type="p5Type:string"/>
    563. 

  563.                <xs:element name="B_LINK" minOccurs="0" nillable="true" default=""
    564. 

  564.                   type="p5Type:string"/>
    565. 

  565.                <xs:element name="B_URL" minOccurs="0" nillable="true" default=""
    566. 

  566.                   type="p5Type:string"/>
    567. 

  567.                <xs:element name="B_XYZ" minOccurs="0" nillable="true" default=""
    568. 

  568.                   type="p5Type:string"/>
    569. 

  569.                <xs:element name="B_ASCII" minOccurs="0" nillable="true" default=""
    570. 

  570.                   type="p5Type:text"/>
    571. 

  571.                <xs:element name="CRM_LISTA_ZASOBOW_ID" minOccurs="0" type="p5Type:integer"/>
    572. 

  572.                <xs:element ref="default_db__x3A__CRM_LISTA_ZASOBOW:CRM_LISTA_ZASOBOW_ID">
    573. 

  573.                   <xs:annotation>
    574. 

  574.                      <xs:appinfo>
    575. 

  575.                         <system_cache__appinfo:flat_relation_cache>
    576. 

  576.                            <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"/>
    577. 

  577.                         </system_cache__appinfo:flat_relation_cache>
    578. 

  578.                      </xs:appinfo>
    579. 

  579.                   </xs:annotation>
    580. 

  580.                </xs:element>
    581. 

  581.                <xs:element name="etykieta_x" minOccurs="0" nillable="true" type="p5Type:decimal"/>
    582. 

  582.                <xs:element name="etykieta_y" minOccurs="0" nillable="true" type="p5Type:decimal"/>
    583. 

  583.                <xs:element name="__Rozdzielcza_Kabel_Swiatlowodowy_wsg84" minOccurs="0"
    584. 

  584.                   nillable="true" type="p5Type:integer"/>
    585. 

  585.                <xs:element name="__MK_Rewiry__STATUS" minOccurs="0" type="p5Type:string"/>
    586. 

  586.                <xs:element name="ID_BILLING_USERS" minOccurs="0" type="p5Type:integer"/>
    587. 

  587.                <xs:element ref="default_db__x3A__COMPANIES:ID_BILLING_USERS" minOccurs="0">
    588. 

  588.                   <xs:annotation>
    589. 

  589.                      <xs:appinfo>
    590. 

  590.                         <system_cache__appinfo:flat_relation_cache>
    591. 

  591.                            <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"/>
    592. 

  592.                         </system_cache__appinfo:flat_relation_cache>
    593. 

  593.                      </xs:appinfo>
    594. 

  594.                   </xs:annotation>
    595. 

  595.                </xs:element>
    596. 

  596.                <xs:element name="ID_BILLING_USERS_ADMIN" minOccurs="0" type="p5Type:integer"/>
    597. 

  597.                <xs:element ref="default_db__x3A__COMPANIES:ID_BILLING_USERS_ADMIN" minOccurs="0">
    598. 

  598.                   <xs:annotation>
    599. 

  599.                      <xs:appinfo>
    600. 

  600.                         <system_cache__appinfo:flat_relation_cache>
    601. 

  601.                            <system_cache__appinfo:source system_cache__appinfo:ref_engine="view" system_cache__appinfo:name="ID_BILLING_USERS_ADMIN" system_cache__appinfo:xpath="default_db__x3A__COMPANIES:ID_BILLING_USERS_ADMIN/ID"/>
    602. 

  602.                         </system_cache__appinfo:flat_relation_cache>
    603. 

  603.                      </xs:appinfo>
    604. 

  604.                   </xs:annotation>
    605. 

  605.                </xs:element>
    606. 

  606.                <xs:element maxOccurs="unbounded" minOccurs="0"
    607. 

  607.                   ref="default_db__x3A__USERS2_MARKETING:USERS2_MARKETING">
    608. 

  608.                   <xs:annotation>
    609. 

  609.                      <xs:appinfo>
    610. 

  610.                         <system_cache__appinfo:flat_relation_cache>
    611. 

  611.                            <system_cache__appinfo:source system_cache__appinfo:ref_engine="view" system_cache__appinfo:name="S_ADDRESS_STREET" system_cache__appinfo:xpath="default_db__x3A__USERS2_MARKETING:USERS2_MARKETING/T_TELBOX_BUILDING_IN"/>
    612. 

  612.                         </system_cache__appinfo:flat_relation_cache>
    613. 

  613.                      </xs:appinfo>
    614. 

  614.                      <xs:documentation>Reff- backref jest od marketingu</xs:documentation>
    615. 

  615.                   </xs:annotation>
    616. 

  616.                </xs:element>
    617. 

  617.             </xs:sequence>
    618. 

  618.          </xs:restriction>
    619. 

  619.       </xs:complexContent>
    620. 

  620.    </xs:complexType>
    621. 

  621.    <xs:simpleType name="T_WORKPOINTS_TYPE_Type">
    622. 

  622.       <xs:restriction base="p5Type:string">
    623. 

  623.          <!--@2018-03-23 fixed blad piotrowego xsd:schema z api @2018-03-23 dla restriction enums-->
    624. 

  624.          <xs:enumeration value="OTHER"/>
    625. 

  625.          <xs:enumeration value="GUARANTY_SERVICE"/>
    626. 

  626.          <xs:enumeration value="ADMIN_AT_WORK"/>
    627. 

  627.          <xs:enumeration value="TECH_AT_DUTY"/>
    628. 

  628.          <xs:enumeration value="TECH_AT_CONTRACT"/>
    629. 

  629.       </xs:restriction>
    630. 

  630.    </xs:simpleType>
    631. 

  631.    <xs:simpleType name="T_BUILDING_TYPE_Type">
    632. 

  632.       <xs:restriction base="p5Type:string">
    633. 

  633.          <!--@2018-03-23 fixed blad piotrowego xsd:schema z api @2018-03-23 dla restriction enums-->
    634. 

  634.          <xs:enumeration value="N/S;"/>
    635. 

  635.          <xs:enumeration value="Domek_Jednorodzin."/>
    636. 

  636.          <xs:enumeration value="Domek_Wielorodz."/>
    637. 

  637.          <xs:enumeration value="Blok_Wielorodz"/>
    638. 

  638.          <xs:enumeration value="Obiekt_jedna_firma"/>
    639. 

  639.          <xs:enumeration value="Obiekt_wiele_firm"/>
    640. 

  640.       </xs:restriction>
    641. 

  641.    </xs:simpleType>
    642. 

  642.    <xs:simpleType name="T_LAN_KONKURENCJA_OPER_Type">
    643. 

  643.       <xs:restriction base="p5Type:string">
    644. 

  644.          <!--@2018-03-23 fixed blad piotrowego xsd:schema z api @2018-03-23 dla restriction enums-->
    645. 

  645.          <xs:enumeration value="NIEWIADOMO"/>
    646. 

  646.          <xs:enumeration value="BRAK"/>
    647. 

  647.          <xs:enumeration value="JEST"/>
    648. 

  648.          <xs:enumeration value="MA BYC"/>
    649. 

  649.       </xs:restriction>
    650. 

  650.    </xs:simpleType>
    651. 

  651.    <xs:simpleType name="A_STATUS_Type">
    652. 

  652.       <xs:restriction base="p5Type:string">
    653. 

  653.          <xs:enumeration value="WAITING"/>
    654. 

  654.          <xs:enumeration value="NORMAL"/>
    655. 

  655.          <xs:enumeration value="MONITOR"/>
    656. 

  656.          <xs:enumeration value="WARNING"/>
    657. 

  657.          <xs:enumeration value="OFF"/>
    658. 

  658.          <xs:enumeration value="TO_OFF"/>
    659. 

  659.          <xs:enumeration value="DELETED"/>
    660. 

  660.          <xs:enumeration value="OFF_SOFT"/>
    661. 

  661.          <xs:enumeration value="OFF_HARD"/>
    662. 

  662.       </xs:restriction>
    663. 

  663.    </xs:simpleType>
    664. 

  664.    <xs:element name="Dom_jednorodz" type="default_db__x3A__BUILDINGS:Dom_jednorodz"/>
    665. 

  665.    <xs:element name="T_TELBOX_BUILDING_IN" type="default_db__x3A__BUILDINGS:BUILDINGS">
    666. 

  666.       <xs:annotation>
    667. 

  667.          <xs:documentation>W telboxes uzywany do budowania struktury</xs:documentation>
    668. 

  668.       </xs:annotation>
    669. 

  669.    </xs:element>
    670. 

  670. </xs:schema>
    671.