COMPANIES.xsd 29 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465
  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema"
  3. xmlns:default_db__x3A__COMPANIES="https://biuro.biall-net.pl/wfs/default_db/table/COMPANIES.xsd"
  4. xmlns:gml="http://www.opengis.net/gml/3.2"
  5. xmlns:default_db__x3A__BUILDINGS="https://biuro.biall-net.pl/wfs/default_db/table/BUILDINGS.xsd"
  6. xmlns:default_db__x3A__PROBLEMS="https://biuro.biall-net.pl/wfs/default_db/table/PROBLEMS.xsd"
  7. xmlns:fix_se_defaultdb_schema="http://biuro.biall-net.pl/xmlschema_procesy5/WPS_Functions/fix_se_defaultdb_schema/fix_se_defaultdb_schema.xsd"
  8. xmlns:p5Type="http://biuro.biall-net.pl/p5/schema/types"
  9. xmlns:default_db__x3A__BILLING_NUMBERS="https://biuro.biall-net.pl/wfs/default_db/table/BILLING_NUMBERS.xsd"
  10. xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  11. xmlns:p5_tr_map="http://biuro.biall-net.pl/xmlschema_procesy5/default_db_xml_cache/procesy5_translate_map.xsd"
  12. xmlns:vc="http://www.w3.org/2007/XMLSchema-versioning"
  13. 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"
  14. xmlns:system_cache__appinfo="http://biuro.biall-net.pl/xmlschema_procesy5/default_db_xml_cache/appinfo.xsd"
  15. xmlns:p5opr="http://biuro.biall-net.pl/xmlschema_procesy5/system_cache/object_parent_relations/object_parent_relations.xsd"
  16. xmlns:p5_simpleSchema_map="http://biuro.biall-net.pl/xmlschema_procesy5/default_db_xml_cache/p5_simpleSchema_map.xsd"
  17. xmlns:ant-object="http://biuro.biall-net.pl/xmlschema_procesy5/ant-object/ant-object.xsd"
  18. xmlns:p5ant-interface="http://biuro.biall-net.pl/xmlschema_procesy5/WPS_Functions/ant_interface/ant_interface.xsd"
  19. elementFormDefault="qualified"
  20. targetNamespace="https://biuro.biall-net.pl/wfs/default_db/table/COMPANIES.xsd"
  21. vc:minVersion="1.1">
  22. <xs:import namespace="http://biuro.biall-net.pl/p5/schema/types"
  23. schemaLocation="../../../types.xsd"/>
  24. <xs:import namespace="http://www.opengis.net/gml/3.2"
  25. schemaLocation="http://www.opengis.net/gml/3.2"/>
  26. <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/table/BUILDINGS.xsd"
  27. schemaLocation="../../default_db.BUILDINGS/BUILDINGS/BUILDINGS.xsd"/>
  28. <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/table/PROBLEMS.xsd"
  29. schemaLocation="../../default_db.PROBLEMS/PROBLEMS/PROBLEMS.xsd"/>
  30. <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/table/BILLING_NUMBERS.xsd"
  31. schemaLocation="../../default_db.BILLING_NUMBERS/BILLING_NUMBERS/BILLING_NUMBERS.xsd"/>
  32. <xs:complexType name="COMPANIES" id="__COMPANIES___d5e7424-1_COMPANIES">
  33. <!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
  34. <xs:annotation>
  35. <xs:documentation>TODO do rozbudowy, obiekt konatku dla firmy lub kowalskiego, trzeba
  36. dobrze zamodelowac </xs:documentation>
  37. <xs:appinfo>
  38. <system_cache__appinfo:heritage>
  39. <system_cache__appinfo:inherit system_cache__appinfo:inherit_ref="default_db:COMPANIES" system_cache__appinfo:heritage_acl="true">
  40. <system_cache__appinfo:acl_rule_inherit_to_all_same_name_elements_and_refs/>
  41. <acl_rule_inherit_to_all_refs_by_primary/>
  42. <acl_rule_inherit_to_all_refs_by_local_element system_cache__appinfo:acl_rule_inherit_local_element_name="P_NAME"/>
  43. </system_cache__appinfo:inherit>
  44. <system_cache__appinfo:exherit_all system_cache__appinfo:heritage_acl="true" system_cache__appinfo:heritage_sort="true"/>
  45. </system_cache__appinfo:heritage>
  46. </xs:appinfo>
  47. </xs:annotation>
  48. <xs:sequence id="__COMPANIES___d5e7428-1">
  49. <xs:element name="ID" minOccurs="0" type="p5Type:integer" id="__COMPANIES___d18e15923-1_ID"/>
  50. <xs:element name="ACCOUNT" minOccurs="0" nillable="true" default="" type="p5Type:string"
  51. id="__COMPANIES___d18e15924-1_ACCOUNT"/>
  52. <xs:element name="PASSWD" minOccurs="0" default="" type="p5Type:string"
  53. id="__COMPANIES___d18e15925-1_PASSWD"/>
  54. <xs:element name="STATUS" minOccurs="0" default="5" type="p5Type:integer"
  55. id="__COMPANIES___d18e15926-1_STATUS"/>
  56. <xs:element name="A_RECORD_CREATE_DATE" minOccurs="0" default="" type="p5Type:string"
  57. id="__COMPANIES___d18e15927-1_A_RECORD_C"/>
  58. <xs:element name="A_RECORD_CREATE_AUTHOR" minOccurs="0" default="" type="p5Type:string"
  59. id="__COMPANIES___d18e15928-1_A_RECORD_C"/>
  60. <xs:element name="A_RECORD_UPDATE_DATE" minOccurs="0" default="" type="p5Type:string"
  61. id="__COMPANIES___d18e15929-1_A_RECORD_U"/>
  62. <xs:element name="A_RECORD_UPDATE_AUTHOR" minOccurs="0" default="" type="p5Type:string"
  63. id="__COMPANIES___d18e15930-1_A_RECORD_U"/>
  64. <xs:element name="L_APPOITMENT_DATE" minOccurs="0" default="" type="p5Type:string"
  65. id="__COMPANIES___d18e15931-1_L_APPOITME"/>
  66. <xs:element name="L_APPOITMENT_USER" minOccurs="0" default="" type="p5Type:string"
  67. id="__COMPANIES___d18e15932-1_L_APPOITME"/>
  68. <xs:element name="L_APPOITMENT_PERIOD" minOccurs="0" default="" type="p5Type:string"
  69. id="__COMPANIES___d18e15933-1_L_APPOITME"/>
  70. <xs:element name="L_APPOITMENT_INFO" minOccurs="0" default="" type="p5Type:string"
  71. id="__COMPANIES___d18e15935-1_L_APPOITME"/>
  72. <xs:element name="L_APPOITMENT_TYPE" minOccurs="0" default=""
  73. id="__COMPANIES___d18e15936-1_L_APPOITME">
  74. <xs:simpleType id="__COMPANIES___d18e15937-1">
  75. <xs:restriction base="p5Type:string">
  76. <!--@2018-03-23 fixed blad piotrowego xsd:schema z api @2018-03-23 dla restriction enums-->
  77. <xs:enumeration value=""/>
  78. <xs:enumeration value="ARRANGED"/>
  79. <xs:enumeration value="TO_ARRANGE"/>
  80. <xs:enumeration value="CANCELLED"/>
  81. <xs:enumeration value="TO_CANCEL"/>
  82. <xs:enumeration value="RELATE"/>
  83. <xs:enumeration value="WAIT"/>
  84. </xs:restriction>
  85. </xs:simpleType>
  86. </xs:element>
  87. <xs:element name="A_PROBLEM" minOccurs="0" default=""
  88. id="__COMPANIES___d18e15947-1_A_PROBLEM">
  89. <xs:simpleType id="__COMPANIES___d18e15948-1">
  90. <xs:restriction base="p5Type:string">
  91. <!--@2018-03-23 fixed blad piotrowego xsd:schema z api @2018-03-23 dla restriction enums-->
  92. <xs:enumeration value=""/>
  93. <xs:enumeration value="WARNING"/>
  94. <xs:enumeration value="PROBLEM"/>
  95. <xs:enumeration value="SERIOUS"/>
  96. <xs:enumeration value="UNVERIFIED"/>
  97. </xs:restriction>
  98. </xs:simpleType>
  99. </xs:element>
  100. <xs:element name="A_PROBLEM_DESC" minOccurs="0" default="" type="p5Type:string"
  101. id="__COMPANIES___d18e15956-1_A_PROBLEM_"/>
  102. <xs:element name="A_PROBLEM_DATE" minOccurs="0" default="" type="p5Type:string"
  103. id="__COMPANIES___d18e15957-1_A_PROBLEM_"/>
  104. <xs:element name="A_STATUS" minOccurs="0" default="WAITING"
  105. id="__COMPANIES___d18e15958-1_A_STATUS">
  106. <xs:simpleType id="__COMPANIES___d18e15959-1">
  107. <xs:restriction base="p5Type:string">
  108. <!--@2018-03-23 fixed blad piotrowego xsd:schema z api @2018-03-23 dla restriction enums-->
  109. <xs:enumeration value="WAITING"/>
  110. <xs:enumeration value="NORMAL"/>
  111. <xs:enumeration value="MONITOR"/>
  112. <xs:enumeration value="WARNING"/>
  113. <xs:enumeration value="OFF_SOFT"/>
  114. <xs:enumeration value="OFF_HARD"/>
  115. <xs:enumeration value="DELETED"/>
  116. </xs:restriction>
  117. </xs:simpleType>
  118. </xs:element>
  119. <xs:element name="A_STATUS_INFO" minOccurs="0" default="" type="p5Type:string"
  120. id="__COMPANIES___d18e15969-1_A_STATUS_I"/>
  121. <xs:element name="A_ADM_COMPANY" minOccurs="0" default="" type="p5Type:string"
  122. id="__COMPANIES___d18e15970-1_A_ADM_COMP"/>
  123. <xs:element name="P_ACCOUNT" minOccurs="0" default="" type="p5Type:string"
  124. id="__COMPANIES___d18e15971-1_P_ACCOUNT"/>
  125. <xs:element name="T_WORKPOINTS" minOccurs="0" default="10" type="p5Type:string"
  126. id="__COMPANIES___d18e15972-1_T_WORKPOIN"/>
  127. <xs:element name="T_WORKPOINTS_VALUE" minOccurs="0" default="" type="p5Type:string"
  128. id="__COMPANIES___d18e15973-1_T_WORKPOIN"/>
  129. <xs:element name="T_WORKPOINTS_TYPE" minOccurs="0" default="" type="p5Type:string"
  130. id="__COMPANIES___d18e15975-1_T_WORKPOIN"/>
  131. <xs:element name="T_WORKPOINTS_USER" minOccurs="0" default="" type="p5Type:string"
  132. id="__COMPANIES___d18e15976-1_T_WORKPOIN"/>
  133. <xs:element name="T_WORKPOINTS_DATE" minOccurs="0" default="" type="p5Type:string"
  134. id="__COMPANIES___d18e15977-1_T_WORKPOIN"/>
  135. <xs:element name="A_STATUS_LASTCHANGE_DATE" minOccurs="0" default="" type="p5Type:string"
  136. id="__COMPANIES___d18e15978-1_A_STATUS_L"/>
  137. <xs:element name="S_ADDRESS_CITY" minOccurs="0" default="" type="p5Type:string"
  138. id="__COMPANIES___d18e15979-1_S_ADDRESS_"/>
  139. <xs:element name="S_ADDRESS_POST_CODE" minOccurs="0" default="" type="p5Type:string"
  140. id="__COMPANIES___d18e15980-1_S_ADDRESS_"/>
  141. <xs:element name="S_ADDRESS_POST_OFFICE" minOccurs="0" default="" type="p5Type:string"
  142. id="__COMPANIES___d18e15981-1_S_ADDRESS_"/>
  143. <xs:element name="S_ADDRESS_STREET" minOccurs="0" default="" type="p5Type:string"
  144. id="__COMPANIES___d18e15982-1_S_ADDRESS_"/>
  145. <xs:element name="S_ADDRESS_HOUSE" minOccurs="0" default="" type="p5Type:string"
  146. id="__COMPANIES___d18e15983-1_S_ADDRESS_"/>
  147. <xs:element name="S_OTHER_INFO" minOccurs="0" default="" type="p5Type:string"
  148. id="__COMPANIES___d18e15984-1_S_OTHER_IN"/>
  149. <xs:element name="S_VIP_LEVEL" minOccurs="0" default="0"
  150. id="__COMPANIES___d18e15985-1_S_VIP_LEVE">
  151. <xs:simpleType id="__COMPANIES___d18e15986-1">
  152. <xs:restriction base="p5Type:string">
  153. <!--@2018-03-23 fixed blad piotrowego xsd:schema z api @2018-03-23 dla restriction enums-->
  154. <xs:enumeration value="0"/>
  155. <xs:enumeration value="1"/>
  156. <xs:enumeration value="2"/>
  157. <xs:enumeration value="3"/>
  158. <xs:enumeration value="4"/>
  159. <xs:enumeration value="5"/>
  160. <xs:enumeration value="6"/>
  161. </xs:restriction>
  162. </xs:simpleType>
  163. </xs:element>
  164. <xs:element name="S_VIP_DESC" minOccurs="0" default="" type="p5Type:string"
  165. id="__COMPANIES___d18e15997-1_S_VIP_DESC"/>
  166. <xs:element name="N_P_STATUS_INFORMED_COUNT" minOccurs="0" default="0" type="p5Type:string"
  167. id="__COMPANIES___d18e15998-1_N_P_STATUS"/>
  168. <xs:element name="N_P_STATUS_NEXT_INFORM_DATE" minOccurs="0" default=""
  169. type="p5Type:string" id="__COMPANIES___d18e15999-1_N_P_STATUS"/>
  170. <xs:element name="N_P_STATUS_INFORMED" minOccurs="0" default="N"
  171. id="__COMPANIES___d18e16000-1_N_P_STATUS">
  172. <xs:simpleType id="__COMPANIES___d18e16001-1">
  173. <xs:restriction base="p5Type:string">
  174. <!--@2018-03-23 fixed blad piotrowego xsd:schema z api @2018-03-23 dla restriction enums-->
  175. <xs:enumeration value="Y"/>
  176. <xs:enumeration value="N"/>
  177. </xs:restriction>
  178. </xs:simpleType>
  179. </xs:element>
  180. <xs:element name="N_P_STATUS_HOW_LAST_INFORMED" minOccurs="0" default=""
  181. type="p5Type:string" id="__COMPANIES___d18e16006-1_N_P_STATUS"/>
  182. <xs:element name="T_PENALTIES" minOccurs="0" default="10" type="p5Type:string"
  183. id="__COMPANIES___d18e16007-1_T_PENALTIE"/>
  184. <xs:element name="T_PENALTIES_TYPE" minOccurs="0" default="" type="p5Type:string"
  185. id="__COMPANIES___d18e16008-1_T_PENALTIE"/>
  186. <xs:element name="T_PENALTIES_VALUE" minOccurs="0" default="" type="p5Type:string"
  187. id="__COMPANIES___d18e16009-1_T_PENALTIE"/>
  188. <xs:element name="T_WHO_CONNECTED" minOccurs="0" default="" type="p5Type:string"
  189. id="__COMPANIES___d18e16010-1_T_WHO_CONN"/>
  190. <xs:element name="T_WHEN_CONNECTED" minOccurs="0" default="" type="p5Type:string"
  191. id="__COMPANIES___d18e16011-1_T_WHEN_CON"/>
  192. <xs:element name="P_ADM_COMPANY" minOccurs="0" default="" type="p5Type:string"
  193. id="__COMPANIES___d18e16012-1_P_ADM_COMP"/>
  194. <xs:element name="P_DEAL_DATE" minOccurs="0" default="" type="p5Type:string"
  195. id="__COMPANIES___d18e16014-1_P_DEAL_DAT"/>
  196. <xs:element name="P_DEALNUMBER" minOccurs="0" nillable="true" default=""
  197. type="p5Type:string" id="__COMPANIES___d18e16015-1_P_DEALNUMB"/>
  198. <xs:element name="P_DEALNUMBER_PREFIX" minOccurs="0" default="" type="p5Type:string"
  199. id="__COMPANIES___d18e16016-1_P_DEALNUMB"/>
  200. <xs:element name="P_DEALEXPIRE" minOccurs="0" default="" type="p5Type:string"
  201. id="__COMPANIES___d18e16017-1_P_DEALEXPI"/>
  202. <xs:element name="P_HANGUP_FROM" minOccurs="0" nillable="true" default=""
  203. type="p5Type:string" id="__COMPANIES___d18e16018-1_P_HANGUP_F"/>
  204. <xs:element name="P_HANGUP_TILL" minOccurs="0" nillable="true" default=""
  205. type="p5Type:string" id="__COMPANIES___d18e16019-1_P_HANGUP_T"/>
  206. <xs:element name="P_ACCOUNT_LIMIT" minOccurs="0" default="" type="p5Type:string"
  207. id="__COMPANIES___d18e16020-1_P_ACCOUNT_"/>
  208. <xs:element name="P_NAME" minOccurs="0" default="" type="p5Type:string"
  209. id="__COMPANIES___d18e16021-1_P_NAME"/>
  210. <xs:element name="P_NAME_SECOND" minOccurs="0" default="" type="p5Type:string"
  211. id="__COMPANIES___d18e16022-1_P_NAME_SEC"/>
  212. <xs:element name="P_NIP" minOccurs="0" nillable="true" default="" type="p5Type:string"
  213. id="__COMPANIES___d18e16023-1_P_NIP"/>
  214. <xs:element name="P_PESEL" minOccurs="0" nillable="true" default="" type="p5Type:string"
  215. id="__COMPANIES___d18e16024-1_P_PESEL"/>
  216. <xs:element name="P_OTHER_DOC" minOccurs="0" default="" type="p5Type:string"
  217. id="__COMPANIES___d18e16026-1_P_OTHER_DO"/>
  218. <xs:element name="P_PHONE" minOccurs="0" default="" type="p5Type:string"
  219. id="__COMPANIES___d18e16027-1_P_PHONE"/>
  220. <xs:element name="P_PHONE_SMS" minOccurs="0" default="" type="p5Type:string"
  221. id="__COMPANIES___d18e16028-1_P_PHONE_SM"/>
  222. <xs:element name="P_FAX" minOccurs="0" default="" type="p5Type:string"
  223. id="__COMPANIES___d18e16029-1_P_FAX"/>
  224. <xs:element name="P_CONTACT_PERSON" minOccurs="0" type="p5Type:text"
  225. id="__COMPANIES___d18e16030-1_P_CONTACT_"/>
  226. <xs:element name="P_ADDRESS_CITY" minOccurs="0" default="" type="p5Type:string"
  227. id="__COMPANIES___d18e16031-1_P_ADDRESS_"/>
  228. <xs:element name="P_ADDRESS_POST_CODE" minOccurs="0" default="" type="p5Type:string"
  229. id="__COMPANIES___d18e16032-1_P_ADDRESS_"/>
  230. <xs:element name="P_ADDRESS_POST_OFFICE" minOccurs="0" default="" type="p5Type:string"
  231. id="__COMPANIES___d18e16033-1_P_ADDRESS_"/>
  232. <xs:element name="P_ADDRESS_STREET" minOccurs="0" default="" type="p5Type:string"
  233. id="__COMPANIES___d18e16034-1_P_ADDRESS_"/>
  234. <xs:element name="P_ADDRESS_HOME" minOccurs="0" default="" type="p5Type:string"
  235. id="__COMPANIES___d18e16035-1_P_ADDRESS_"/>
  236. <xs:element name="P_ADDRESS_HOUSE" minOccurs="0" default="" type="p5Type:string"
  237. id="__COMPANIES___d18e16036-1_P_ADDRESS_"/>
  238. <xs:element name="P_ADDRESS_REGION" minOccurs="0" default="0" type="p5Type:integer"
  239. id="__COMPANIES___d18e16038-1_P_ADDRESS_"/>
  240. <xs:element name="P_OTHER_INFO" minOccurs="0" default="" type="p5Type:string"
  241. id="__COMPANIES___d18e16039-1_P_OTHER_IN"/>
  242. <xs:element name="TAB_UPDATE_STAT" minOccurs="0" default="1"
  243. id="__COMPANIES___d18e16040-1_TAB_UPDATE">
  244. <xs:simpleType id="__COMPANIES___d18e16041-1">
  245. <xs:restriction base="p5Type:string">
  246. <!--@2018-03-23 fixed blad piotrowego xsd:schema z api @2018-03-23 dla restriction enums-->
  247. <xs:enumeration value="0"/>
  248. <xs:enumeration value="1"/>
  249. </xs:restriction>
  250. </xs:simpleType>
  251. </xs:element>
  252. <xs:element name="TAB_UPDATE_DATE" minOccurs="0" default="0000-00-00 00:00:00"
  253. type="p5Type:dateTime" id="__COMPANIES___d18e16046-1_TAB_UPDATE"/>
  254. <xs:element name="TAB_UPDATE_INFO" minOccurs="0" default="" type="p5Type:string"
  255. id="__COMPANIES___d18e16047-1_TAB_UPDATE"/>
  256. <xs:element name="BILLING_OWNER" minOccurs="0" default="1" type="p5Type:integer"
  257. id="__COMPANIES___d18e16048-1_BILLING_OW"/>
  258. <xs:element name="ID_BILLING_PREFIXES" minOccurs="0" default="0" type="p5Type:string"
  259. id="__COMPANIES___d18e16049-1_ID_BILLING"/>
  260. <xs:element name="id_list_form_pay" minOccurs="0" default="1" type="p5Type:integer"
  261. id="__COMPANIES___d18e16050-1_id_list_fo"/>
  262. <xs:element name="user_mail_contact" minOccurs="0" default="" type="p5Type:string"
  263. id="__COMPANIES___d18e16051-1_user_mail_"/>
  264. <xs:element name="is_firma" minOccurs="0" default="0" type="p5Type:integer"
  265. id="__COMPANIES___d18e16052-1_is_firma"/>
  266. <xs:element name="P_ADRESS_KORESP_1282" minOccurs="0" type="p5Type:string"
  267. id="__COMPANIES___d18e16053-1_P_ADRESS_K"/>
  268. <xs:element name="P_REGON" minOccurs="0" type="p5Type:string"
  269. id="__COMPANIES___d18e16055-1_P_REGON"/>
  270. <xs:element name="P_KRS_NUMBER" minOccurs="0" type="p5Type:string"
  271. id="__COMPANIES___d18e16056-1_P_KRS_NUMB"/>
  272. <xs:element name="P_ZGODA_NA_PRZETWARZANIE_DANYCH_OSOBOWYCH" minOccurs="0"
  273. default="NIEWIADOMO" id="__COMPANIES___d18e16057-1_P_ZGODA_NA">
  274. <xs:simpleType id="__COMPANIES___d18e16058-1">
  275. <xs:restriction base="p5Type:string">
  276. <!--@2018-03-23 fixed blad piotrowego xsd:schema z api @2018-03-23 dla restriction enums-->
  277. <xs:enumeration value="TAK"/>
  278. <xs:enumeration value="NIE"/>
  279. <xs:enumeration value="NIEWIADOMO"/>
  280. </xs:restriction>
  281. </xs:simpleType>
  282. </xs:element>
  283. <xs:element name="P_ZGODA_NA_OTRZYMYWANIE_FAKTUR_ELEKTRONICZNYCH" minOccurs="0"
  284. default="NIEWIADOMO" id="__COMPANIES___d18e16064-1_P_ZGODA_NA">
  285. <xs:simpleType id="__COMPANIES___d18e16065-1">
  286. <xs:restriction base="p5Type:string">
  287. <!--@2018-03-23 fixed blad piotrowego xsd:schema z api @2018-03-23 dla restriction enums-->
  288. <xs:enumeration value="TAK"/>
  289. <xs:enumeration value="NIE"/>
  290. <xs:enumeration value="NIEWIADOMO"/>
  291. </xs:restriction>
  292. </xs:simpleType>
  293. </xs:element>
  294. <xs:element name="P_ZGODA_NA_UMIESZCZENIE_DANYCH_W_PUBLICZNYM_SPISIE_ABONENTOW"
  295. minOccurs="0" default="NIEWIADOMO" id="__COMPANIES___d18e16071-1_P_ZGODA_NA">
  296. <xs:simpleType id="__COMPANIES___d18e16072-1">
  297. <xs:restriction base="p5Type:string">
  298. <!--@2018-03-23 fixed blad piotrowego xsd:schema z api @2018-03-23 dla restriction enums-->
  299. <xs:enumeration value="TAK"/>
  300. <xs:enumeration value="NIE"/>
  301. <xs:enumeration value="NIEWIADOMO"/>
  302. </xs:restriction>
  303. </xs:simpleType>
  304. </xs:element>
  305. <xs:element name="A_CLASSIFIED" minOccurs="0" type="p5Type:string"
  306. id="__COMPANIES___d18e16078-1_A_CLASSIFI"/>
  307. <xs:element name="CRM_LISTA_ZASOBOW_ID" minOccurs="0" type="p5Type:integer"
  308. id="__COMPANIES___d18e16079-1_CRM_LISTA_"/>
  309. <xs:element name="K_TYPE" minOccurs="0" default="INNY"
  310. id="__COMPANIES___d18e16080-1_K_TYPE">
  311. <xs:simpleType id="__COMPANIES___d18e16081-1">
  312. <xs:restriction base="p5Type:string">
  313. <!--@2018-03-23 fixed blad piotrowego xsd:schema z api @2018-03-23 dla restriction enums-->
  314. <xs:enumeration value="INNY"/>
  315. <xs:enumeration value="DOSTAWCA/ODBIORCA"/>
  316. <xs:enumeration value="ODBIORCA"/>
  317. <xs:enumeration value="DOSTAWCA"/>
  318. <xs:enumeration value="URZAD"/>
  319. <xs:enumeration value="INWESTOR"/>
  320. <xs:enumeration value="OS.FIZYCZNA"/>
  321. <xs:enumeration value="FIRMA"/>
  322. </xs:restriction>
  323. </xs:simpleType>
  324. </xs:element>
  325. <xs:element name="P_ZGODA_NA_PRZETWARZANIE_NIP_KONTA_BANKOWEGO_EMAIL_NR_TEL" minOccurs="0"
  326. default="NIEWIADOMO" id="__COMPANIES___d18e16092-1_P_ZGODA_NA">
  327. <xs:simpleType id="__COMPANIES___d18e16093-1">
  328. <xs:restriction base="p5Type:string">
  329. <!--@2018-03-23 fixed blad piotrowego xsd:schema z api @2018-03-23 dla restriction enums-->
  330. <xs:enumeration value="TAK"/>
  331. <xs:enumeration value="NIE"/>
  332. <xs:enumeration value="NIEWIADOMO"/>
  333. </xs:restriction>
  334. </xs:simpleType>
  335. </xs:element>
  336. <xs:element name="P_ZGODA_NA_PRZETWARZANIE_DANYCH_W_CELACH_MARKETINGOWYCH" minOccurs="0"
  337. default="NIEWIADOMO" id="__COMPANIES___d18e16099-1_P_ZGODA_NA">
  338. <xs:simpleType id="__COMPANIES___d18e16100-1">
  339. <xs:restriction base="p5Type:string">
  340. <!--@2018-03-23 fixed blad piotrowego xsd:schema z api @2018-03-23 dla restriction enums-->
  341. <xs:enumeration value="TAK"/>
  342. <xs:enumeration value="NIE"/>
  343. <xs:enumeration value="NIEWIADOMO"/>
  344. </xs:restriction>
  345. </xs:simpleType>
  346. </xs:element>
  347. <xs:element name="P_ZGODA_NA_WYSŁANIE_PROPONOWANYCH_ZMIAN_W_UMOWIE" minOccurs="0"
  348. default="NIEWIADOMO" id="__COMPANIES___d18e16106-1_P_ZGODA_NA">
  349. <xs:simpleType id="__COMPANIES___d18e16107-1">
  350. <xs:restriction base="p5Type:string">
  351. <!--@2018-03-23 fixed blad piotrowego xsd:schema z api @2018-03-23 dla restriction enums-->
  352. <xs:enumeration value="TAK"/>
  353. <xs:enumeration value="NIE"/>
  354. <xs:enumeration value="NIEWIADOMO"/>
  355. </xs:restriction>
  356. </xs:simpleType>
  357. </xs:element>
  358. <xs:element name="P_ZGODA_NA_KIEROWANIE_KORESP_DROGA_ELEKTRONICZNA" minOccurs="0"
  359. default="NIEWIADOMO" id="__COMPANIES___d18e16114-1_P_ZGODA_NA">
  360. <xs:simpleType id="__COMPANIES___d18e16115-1">
  361. <xs:restriction base="p5Type:string">
  362. <!--@2018-03-23 fixed blad piotrowego xsd:schema z api @2018-03-23 dla restriction enums-->
  363. <xs:enumeration value="TAK"/>
  364. <xs:enumeration value="NIE"/>
  365. <xs:enumeration value="NIEWIADOMO"/>
  366. </xs:restriction>
  367. </xs:simpleType>
  368. </xs:element>
  369. <xs:element name="P_ZGODA_NA_WYSYLANIE_FAKTUR_ELEKTRONICZNIE" minOccurs="0"
  370. default="NIEWIADOMO" id="__COMPANIES___d18e16121-1_P_ZGODA_NA">
  371. <xs:simpleType id="__COMPANIES___d18e16122-1">
  372. <xs:restriction base="p5Type:string">
  373. <!--@2018-03-23 fixed blad piotrowego xsd:schema z api @2018-03-23 dla restriction enums-->
  374. <xs:enumeration value="TAK"/>
  375. <xs:enumeration value="NIE"/>
  376. <xs:enumeration value="NIEWIADOMO"/>
  377. </xs:restriction>
  378. </xs:simpleType>
  379. </xs:element>
  380. <xs:element name="P_ZGODA_NA_POTW_PRZYJECIA_REKLAMACJI_ELEKTRONICZNIE" minOccurs="0"
  381. default="NIEWIADOMO" id="__COMPANIES___d18e16128-1_P_ZGODA_NA">
  382. <xs:simpleType id="__COMPANIES___d18e16129-1">
  383. <xs:restriction base="p5Type:string">
  384. <!--@2018-03-23 fixed blad piotrowego xsd:schema z api @2018-03-23 dla restriction enums-->
  385. <xs:enumeration value="TAK"/>
  386. <xs:enumeration value="NIE"/>
  387. <xs:enumeration value="NIEWIADOMO"/>
  388. </xs:restriction>
  389. </xs:simpleType>
  390. </xs:element>
  391. <xs:element name="P_ZGODA_NA_ZAMIESZCZENIE_DANYCH_W_SPISIE_ABONENTOW" minOccurs="0"
  392. default="NIEWIADOMO" id="__COMPANIES___d18e16135-1_P_ZGODA_NA">
  393. <xs:simpleType id="__COMPANIES___d18e16136-1">
  394. <xs:restriction base="p5Type:string">
  395. <!--@2018-03-23 fixed blad piotrowego xsd:schema z api @2018-03-23 dla restriction enums-->
  396. <xs:enumeration value="TAK"/>
  397. <xs:enumeration value="NIE"/>
  398. <xs:enumeration value="NIEWIADOMO"/>
  399. </xs:restriction>
  400. </xs:simpleType>
  401. </xs:element>
  402. <xs:element name="bank" minOccurs="0" type="p5Type:string"
  403. id="__COMPANIES___d18e16142-1_bank"/>
  404. <xs:element name="nr_rach" minOccurs="0" type="p5Type:string"
  405. id="__COMPANIES___d18e16143-1_nr_rach"/>
  406. <xs:element name="TAXPAYER_ID_BILLING_USERS" minOccurs="0" default="0"
  407. type="p5Type:integer" id="__COMPANIES___d18e16144-1_TAXPAYER_I"/>
  408. <xs:element maxOccurs="unbounded" minOccurs="0" ref="default_db__x3A__PROBLEMS:PROBLEMS"
  409. id="__COMPANIES___d18e16145-1"/>
  410. <xs:element maxOccurs="unbounded" minOccurs="0"
  411. ref="default_db__x3A__BILLING_NUMBERS:BILLING_NUMBERS_BILLS_FVAT"
  412. id="__COMPANIES___d18e16146-1">
  413. <!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
  414. <xs:annotation>
  415. <xs:appinfo>
  416. <system_cache__appinfo:flat_relation_cache system_cache__appinfo:backref_evaluate="true"><!-- todo czy backref jest potrzebny... -->
  417. <system_cache__appinfo:source system_cache__appinfo:ref_engine="view" system_cache__appinfo:name="ID" system_cache__appinfo:xpath="default_db__x3A__BILLING_NUMBERS:BILLING_NUMBERS_BILLS_FVAT/ID_BILLING_USERS"/>
  418. </system_cache__appinfo:flat_relation_cache>
  419. </xs:appinfo>
  420. <xs:documentation>FAKTURY DO OGLADANIA</xs:documentation>
  421. </xs:annotation>
  422. </xs:element>
  423. </xs:sequence>
  424. <xs:attribute name="label" type="xs:string" id="__COMPANIES___d18e16154-1_label"/>
  425. <xs:assert test="@label = concat(P_NAME, ' ', P_NAME_SECOND)" id="__COMPANIES___d18e16155-1"/>
  426. </xs:complexType>
  427. <xs:element name="COMPANIES" type="default_db__x3A__COMPANIES:COMPANIES"
  428. id="__COMPANIES___d5e7461-1_COMPANIES">
  429. <xs:key name="COMPANIES">
  430. <xs:selector xpath="."/>
  431. <xs:field xpath="P_NAME"/>
  432. <xs:field xpath="P_NAME_SECOND"/>
  433. </xs:key>
  434. </xs:element>
  435. <xs:element name="ID_BILLING_USERS" id="__COMPANIES___d5e7466-1_ID_BILLING"
  436. type="default_db__x3A__COMPANIES:COMPANIES">
  437. <xs:key name="ID_BILLING_USERS">
  438. <xs:selector xpath="."/>
  439. <xs:field xpath="P_NAME"/>
  440. <xs:field xpath="P_NAME_SECOND"/>
  441. </xs:key>
  442. </xs:element>
  443. <xs:element name="ID_BILLING_USERS_ADMIN" type="default_db__x3A__COMPANIES:COMPANIES"
  444. id="__COMPANIES___d18e16166-1_ID_BILLING">
  445. <!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
  446. <xs:annotation>
  447. <xs:documentation>Np. Dowiązanie tego obiektu w ramach BUILDINGS określa, że obiekt jest administratorem danej nieruchomości. </xs:documentation>
  448. </xs:annotation>
  449. </xs:element>
  450. <xs:element name="KONTRAHENT" type="default_db__x3A__COMPANIES:COMPANIES"
  451. id="__COMPANIES___d5e7475-1_KONTRAHENT">
  452. <xs:key name="KONTRAHENT">
  453. <xs:selector xpath="."/>
  454. <xs:field xpath="P_NAME"/>
  455. <xs:field xpath="P_NAME_SECOND"/>
  456. </xs:key>
  457. </xs:element>
  458. <xs:element name="DOSTAWCA" type="default_db__x3A__COMPANIES:COMPANIES"
  459. id="__COMPANIES___d18e16175-1_DOSTAWCA">
  460. <!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
  461. <xs:annotation>
  462. <xs:documentation>na potrzeby SIGMA</xs:documentation>
  463. </xs:annotation>
  464. </xs:element>
  465. </xs:schema>