COMPANIES.xsd 22 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374
  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:p5_tr_map="http://biuro.biall-net.pl/xmlschema_procesy5/default_db_xml_cache/procesy5_translate_map.xsd"
  6. xmlns:vc="http://www.w3.org/2007/XMLSchema-versioning"
  7. 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"
  8. xmlns:system_cache__appinfo="http://biuro.biall-net.pl/xmlschema_procesy5/default_db_xml_cache/appinfo.xsd"
  9. xmlns:default_db__x3A__BUILDINGS="https://biuro.biall-net.pl/wfs/default_db/table/BUILDINGS.xsd"
  10. xmlns:default_db__x3A__PROBLEMS="https://biuro.biall-net.pl/wfs/default_db/table/PROBLEMS.xsd"
  11. xmlns:fix_se_defaultdb_schema="http://biuro.biall-net.pl/xmlschema_procesy5/WPS_Functions/fix_se_defaultdb_schema/fix_se_defaultdb_schema.xsd"
  12. xmlns:p5Type="http://biuro.biall-net.pl/p5/schema/types" elementFormDefault="qualified"
  13. targetNamespace="https://biuro.biall-net.pl/wfs/default_db/table/COMPANIES.xsd"
  14. vc:minVersion="1.1"
  15. xmlns:default_db__x3A__BILLING_NUMBERS="https://biuro.biall-net.pl/wfs/default_db/table/BILLING_NUMBERS.xsd">
  16. <xs:import namespace="http://biuro.biall-net.pl/p5/schema/types"
  17. schemaLocation="../../../types.xsd"/>
  18. <xs:import namespace="http://www.opengis.net/gml/3.2"
  19. schemaLocation="http://www.opengis.net/gml/3.2"/>
  20. <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/table/BUILDINGS.xsd"
  21. schemaLocation="../../default_db.BUILDINGS/BUILDINGS/BUILDINGS.xsd"/>
  22. <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/table/PROBLEMS.xsd"
  23. schemaLocation="../../default_db.PROBLEMS/PROBLEMS/PROBLEMS.xsd"/>
  24. <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/table/BILLING_NUMBERS.xsd"
  25. schemaLocation="../../default_db.BILLING_NUMBERS/BILLING_NUMBERS/BILLING_NUMBERS.xsd"/>
  26. <xs:complexType name="COMPANIES" id="__COMPANIES___d5e7424-1_COMPANIES">
  27. <xs:annotation>
  28. <xs:documentation>TODO do rozbudowy, obiekt konatku dla firmy lub kowalskiego, trzeba
  29. dobrze zamodelowac </xs:documentation>
  30. <xs:appinfo>
  31. <system_cache__appinfo:heritage>
  32. <system_cache__appinfo:inherit system_cache__appinfo:inherit_ref="default_db:COMPANIES" system_cache__appinfo:heritage_acl="true">
  33. <system_cache__appinfo:acl_rule_inherit_to_all_same_name_elements_and_refs/>
  34. <acl_rule_inherit_to_all_refs_by_primary/>
  35. <acl_rule_inherit_to_all_refs_by_local_element system_cache__appinfo:acl_rule_inherit_local_element_name="P_NAME"/>
  36. </system_cache__appinfo:inherit>
  37. <system_cache__appinfo:exherit_all system_cache__appinfo:heritage_acl="true" system_cache__appinfo:heritage_sort="true"/>
  38. </system_cache__appinfo:heritage>
  39. </xs:appinfo>
  40. </xs:annotation>
  41. <xs:sequence id="__COMPANIES___d5e7428-1">
  42. <xs:element name="ID" minOccurs="0" type="p5Type:integer"/>
  43. <xs:element name="ACCOUNT" minOccurs="0" nillable="true" default="" type="p5Type:string"/>
  44. <xs:element name="PASSWD" minOccurs="0" default="" type="p5Type:string"/>
  45. <xs:element name="STATUS" minOccurs="0" default="5" type="p5Type:integer"/>
  46. <xs:element name="A_RECORD_CREATE_DATE" minOccurs="0" default="" type="p5Type:string"/>
  47. <xs:element name="A_RECORD_CREATE_AUTHOR" minOccurs="0" default="" type="p5Type:string"/>
  48. <xs:element name="A_RECORD_UPDATE_DATE" minOccurs="0" default="" type="p5Type:string"/>
  49. <xs:element name="A_RECORD_UPDATE_AUTHOR" minOccurs="0" default="" type="p5Type:string"/>
  50. <xs:element name="L_APPOITMENT_DATE" minOccurs="0" default="" type="p5Type:string"/>
  51. <xs:element name="L_APPOITMENT_USER" minOccurs="0" default="" type="p5Type:string"/>
  52. <xs:element name="L_APPOITMENT_PERIOD" minOccurs="0" default="" type="p5Type:string"/>
  53. <xs:element name="L_APPOITMENT_INFO" minOccurs="0" default="" type="p5Type:string"/>
  54. <xs:element name="L_APPOITMENT_TYPE" minOccurs="0" default="">
  55. <xs:simpleType>
  56. <xs:restriction base="p5Type:string">
  57. <!--@2018-03-23 fixed blad piotrowego xsd:schema z api @2018-03-23 dla restriction enums-->
  58. <xs:enumeration value=""/>
  59. <xs:enumeration value="ARRANGED"/>
  60. <xs:enumeration value="TO_ARRANGE"/>
  61. <xs:enumeration value="CANCELLED"/>
  62. <xs:enumeration value="TO_CANCEL"/>
  63. <xs:enumeration value="RELATE"/>
  64. <xs:enumeration value="WAIT"/>
  65. </xs:restriction>
  66. </xs:simpleType>
  67. </xs:element>
  68. <xs:element name="A_PROBLEM" minOccurs="0" default="">
  69. <xs:simpleType>
  70. <xs:restriction base="p5Type:string">
  71. <!--@2018-03-23 fixed blad piotrowego xsd:schema z api @2018-03-23 dla restriction enums-->
  72. <xs:enumeration value=""/>
  73. <xs:enumeration value="WARNING"/>
  74. <xs:enumeration value="PROBLEM"/>
  75. <xs:enumeration value="SERIOUS"/>
  76. <xs:enumeration value="UNVERIFIED"/>
  77. </xs:restriction>
  78. </xs:simpleType>
  79. </xs:element>
  80. <xs:element name="A_PROBLEM_DESC" minOccurs="0" default="" type="p5Type:string"/>
  81. <xs:element name="A_PROBLEM_DATE" minOccurs="0" default="" type="p5Type:string"/>
  82. <xs:element name="A_STATUS" minOccurs="0" default="WAITING">
  83. <xs:simpleType>
  84. <xs:restriction base="p5Type:string">
  85. <!--@2018-03-23 fixed blad piotrowego xsd:schema z api @2018-03-23 dla restriction enums-->
  86. <xs:enumeration value="WAITING"/>
  87. <xs:enumeration value="NORMAL"/>
  88. <xs:enumeration value="MONITOR"/>
  89. <xs:enumeration value="WARNING"/>
  90. <xs:enumeration value="OFF_SOFT"/>
  91. <xs:enumeration value="OFF_HARD"/>
  92. <xs:enumeration value="DELETED"/>
  93. </xs:restriction>
  94. </xs:simpleType>
  95. </xs:element>
  96. <xs:element name="A_STATUS_INFO" minOccurs="0" default="" type="p5Type:string"/>
  97. <xs:element name="A_ADM_COMPANY" minOccurs="0" default="" type="p5Type:string"/>
  98. <xs:element name="P_ACCOUNT" minOccurs="0" default="" type="p5Type:string"/>
  99. <xs:element name="T_WORKPOINTS" minOccurs="0" default="10" type="p5Type:string"/>
  100. <xs:element name="T_WORKPOINTS_VALUE" minOccurs="0" default="" type="p5Type:string"/>
  101. <xs:element name="T_WORKPOINTS_TYPE" minOccurs="0" default="" type="p5Type:string"/>
  102. <xs:element name="T_WORKPOINTS_USER" minOccurs="0" default="" type="p5Type:string"/>
  103. <xs:element name="T_WORKPOINTS_DATE" minOccurs="0" default="" type="p5Type:string"/>
  104. <xs:element name="A_STATUS_LASTCHANGE_DATE" minOccurs="0" default="" type="p5Type:string"/>
  105. <xs:element name="S_ADDRESS_CITY" minOccurs="0" default="" type="p5Type:string"/>
  106. <xs:element name="S_ADDRESS_POST_CODE" minOccurs="0" default="" type="p5Type:string"/>
  107. <xs:element name="S_ADDRESS_POST_OFFICE" minOccurs="0" default="" type="p5Type:string"/>
  108. <xs:element name="S_ADDRESS_STREET" minOccurs="0" default="" type="p5Type:string"/>
  109. <xs:element name="S_ADDRESS_HOUSE" minOccurs="0" default="" type="p5Type:string"/>
  110. <xs:element name="S_OTHER_INFO" minOccurs="0" default="" type="p5Type:string"/>
  111. <xs:element name="S_VIP_LEVEL" minOccurs="0" default="0">
  112. <xs:simpleType>
  113. <xs:restriction base="p5Type:string">
  114. <!--@2018-03-23 fixed blad piotrowego xsd:schema z api @2018-03-23 dla restriction enums-->
  115. <xs:enumeration value="0"/>
  116. <xs:enumeration value="1"/>
  117. <xs:enumeration value="2"/>
  118. <xs:enumeration value="3"/>
  119. <xs:enumeration value="4"/>
  120. <xs:enumeration value="5"/>
  121. <xs:enumeration value="6"/>
  122. </xs:restriction>
  123. </xs:simpleType>
  124. </xs:element>
  125. <xs:element name="S_VIP_DESC" minOccurs="0" default="" type="p5Type:string"/>
  126. <xs:element name="N_P_STATUS_INFORMED_COUNT" minOccurs="0" default="0" type="p5Type:string"/>
  127. <xs:element name="N_P_STATUS_NEXT_INFORM_DATE" minOccurs="0" default=""
  128. type="p5Type:string"/>
  129. <xs:element name="N_P_STATUS_INFORMED" minOccurs="0" default="N">
  130. <xs:simpleType>
  131. <xs:restriction base="p5Type:string">
  132. <!--@2018-03-23 fixed blad piotrowego xsd:schema z api @2018-03-23 dla restriction enums-->
  133. <xs:enumeration value="Y"/>
  134. <xs:enumeration value="N"/>
  135. </xs:restriction>
  136. </xs:simpleType>
  137. </xs:element>
  138. <xs:element name="N_P_STATUS_HOW_LAST_INFORMED" minOccurs="0" default=""
  139. type="p5Type:string"/>
  140. <xs:element name="T_PENALTIES" minOccurs="0" default="10" type="p5Type:string"/>
  141. <xs:element name="T_PENALTIES_TYPE" minOccurs="0" default="" type="p5Type:string"/>
  142. <xs:element name="T_PENALTIES_VALUE" minOccurs="0" default="" type="p5Type:string"/>
  143. <xs:element name="T_WHO_CONNECTED" minOccurs="0" default="" type="p5Type:string"/>
  144. <xs:element name="T_WHEN_CONNECTED" minOccurs="0" default="" type="p5Type:string"/>
  145. <xs:element name="P_ADM_COMPANY" minOccurs="0" default="" type="p5Type:string"/>
  146. <xs:element name="P_DEAL_DATE" minOccurs="0" default="" type="p5Type:string"/>
  147. <xs:element name="P_DEALNUMBER" minOccurs="0" nillable="true" default=""
  148. type="p5Type:string"/>
  149. <xs:element name="P_DEALNUMBER_PREFIX" minOccurs="0" default="" type="p5Type:string"/>
  150. <xs:element name="P_DEALEXPIRE" minOccurs="0" default="" type="p5Type:string"/>
  151. <xs:element name="P_HANGUP_FROM" minOccurs="0" nillable="true" default=""
  152. type="p5Type:string"/>
  153. <xs:element name="P_HANGUP_TILL" minOccurs="0" nillable="true" default=""
  154. type="p5Type:string"/>
  155. <xs:element name="P_ACCOUNT_LIMIT" minOccurs="0" default="" type="p5Type:string"/>
  156. <xs:element name="P_NAME" minOccurs="0" default="" type="p5Type:string"/>
  157. <xs:element name="P_NAME_SECOND" minOccurs="0" default="" type="p5Type:string"/>
  158. <xs:element name="P_NIP" minOccurs="0" nillable="true" default="" type="p5Type:string"/>
  159. <xs:element name="P_PESEL" minOccurs="0" nillable="true" default="" type="p5Type:string"/>
  160. <xs:element name="P_OTHER_DOC" minOccurs="0" default="" type="p5Type:string"/>
  161. <xs:element name="P_PHONE" minOccurs="0" default="" type="p5Type:string"/>
  162. <xs:element name="P_PHONE_SMS" minOccurs="0" default="" type="p5Type:string"/>
  163. <xs:element name="P_FAX" minOccurs="0" default="" type="p5Type:string"/>
  164. <xs:element name="P_CONTACT_PERSON" minOccurs="0" type="p5Type:text"/>
  165. <xs:element name="P_ADDRESS_CITY" minOccurs="0" default="" type="p5Type:string"/>
  166. <xs:element name="P_ADDRESS_POST_CODE" minOccurs="0" default="" type="p5Type:string"/>
  167. <xs:element name="P_ADDRESS_POST_OFFICE" minOccurs="0" default="" type="p5Type:string"/>
  168. <xs:element name="P_ADDRESS_STREET" minOccurs="0" default="" type="p5Type:string"/>
  169. <xs:element name="P_ADDRESS_HOME" minOccurs="0" default="" type="p5Type:string"/>
  170. <xs:element name="P_ADDRESS_HOUSE" minOccurs="0" default="" type="p5Type:string"/>
  171. <xs:element name="P_ADDRESS_REGION" minOccurs="0" default="0" type="p5Type:integer"/>
  172. <xs:element name="P_OTHER_INFO" minOccurs="0" default="" type="p5Type:string"/>
  173. <xs:element name="TAB_UPDATE_STAT" minOccurs="0" default="1">
  174. <xs:simpleType>
  175. <xs:restriction base="p5Type:string">
  176. <!--@2018-03-23 fixed blad piotrowego xsd:schema z api @2018-03-23 dla restriction enums-->
  177. <xs:enumeration value="0"/>
  178. <xs:enumeration value="1"/>
  179. </xs:restriction>
  180. </xs:simpleType>
  181. </xs:element>
  182. <xs:element name="TAB_UPDATE_DATE" minOccurs="0" default="0000-00-00 00:00:00"
  183. type="p5Type:dateTime"/>
  184. <xs:element name="TAB_UPDATE_INFO" minOccurs="0" default="" type="p5Type:string"/>
  185. <xs:element name="BILLING_OWNER" minOccurs="0" default="1" type="p5Type:integer"/>
  186. <xs:element name="ID_BILLING_PREFIXES" minOccurs="0" default="0" type="p5Type:string"/>
  187. <xs:element name="id_list_form_pay" minOccurs="0" default="1" type="p5Type:integer"/>
  188. <xs:element name="user_mail_contact" minOccurs="0" default="" type="p5Type:string"/>
  189. <xs:element name="is_firma" minOccurs="0" default="0" type="p5Type:integer"/>
  190. <xs:element name="P_ADRESS_KORESP_1282" minOccurs="0" type="p5Type:string"/>
  191. <xs:element name="P_REGON" minOccurs="0" type="p5Type:string"/>
  192. <xs:element name="P_KRS_NUMBER" minOccurs="0" type="p5Type:string"/>
  193. <xs:element name="P_ZGODA_NA_PRZETWARZANIE_DANYCH_OSOBOWYCH" minOccurs="0"
  194. default="NIEWIADOMO">
  195. <xs:simpleType>
  196. <xs:restriction base="p5Type:string">
  197. <!--@2018-03-23 fixed blad piotrowego xsd:schema z api @2018-03-23 dla restriction enums-->
  198. <xs:enumeration value="TAK"/>
  199. <xs:enumeration value="NIE"/>
  200. <xs:enumeration value="NIEWIADOMO"/>
  201. </xs:restriction>
  202. </xs:simpleType>
  203. </xs:element>
  204. <xs:element name="P_ZGODA_NA_OTRZYMYWANIE_FAKTUR_ELEKTRONICZNYCH" minOccurs="0"
  205. default="NIEWIADOMO">
  206. <xs:simpleType>
  207. <xs:restriction base="p5Type:string">
  208. <!--@2018-03-23 fixed blad piotrowego xsd:schema z api @2018-03-23 dla restriction enums-->
  209. <xs:enumeration value="TAK"/>
  210. <xs:enumeration value="NIE"/>
  211. <xs:enumeration value="NIEWIADOMO"/>
  212. </xs:restriction>
  213. </xs:simpleType>
  214. </xs:element>
  215. <xs:element name="P_ZGODA_NA_UMIESZCZENIE_DANYCH_W_PUBLICZNYM_SPISIE_ABONENTOW"
  216. minOccurs="0" default="NIEWIADOMO">
  217. <xs:simpleType>
  218. <xs:restriction base="p5Type:string">
  219. <!--@2018-03-23 fixed blad piotrowego xsd:schema z api @2018-03-23 dla restriction enums-->
  220. <xs:enumeration value="TAK"/>
  221. <xs:enumeration value="NIE"/>
  222. <xs:enumeration value="NIEWIADOMO"/>
  223. </xs:restriction>
  224. </xs:simpleType>
  225. </xs:element>
  226. <xs:element name="A_CLASSIFIED" minOccurs="0" type="p5Type:string"/>
  227. <xs:element name="CRM_LISTA_ZASOBOW_ID" minOccurs="0" type="p5Type:integer"/>
  228. <xs:element name="K_TYPE" minOccurs="0" default="INNY">
  229. <xs:simpleType>
  230. <xs:restriction base="p5Type:string">
  231. <!--@2018-03-23 fixed blad piotrowego xsd:schema z api @2018-03-23 dla restriction enums-->
  232. <xs:enumeration value="INNY"/>
  233. <xs:enumeration value="DOSTAWCA/ODBIORCA"/>
  234. <xs:enumeration value="ODBIORCA"/>
  235. <xs:enumeration value="DOSTAWCA"/>
  236. <xs:enumeration value="URZAD"/>
  237. <xs:enumeration value="INWESTOR"/>
  238. <xs:enumeration value="OS.FIZYCZNA"/>
  239. <xs:enumeration value="FIRMA"/>
  240. </xs:restriction>
  241. </xs:simpleType>
  242. </xs:element>
  243. <xs:element name="P_ZGODA_NA_PRZETWARZANIE_NIP_KONTA_BANKOWEGO_EMAIL_NR_TEL" minOccurs="0"
  244. default="NIEWIADOMO">
  245. <xs:simpleType>
  246. <xs:restriction base="p5Type:string">
  247. <!--@2018-03-23 fixed blad piotrowego xsd:schema z api @2018-03-23 dla restriction enums-->
  248. <xs:enumeration value="TAK"/>
  249. <xs:enumeration value="NIE"/>
  250. <xs:enumeration value="NIEWIADOMO"/>
  251. </xs:restriction>
  252. </xs:simpleType>
  253. </xs:element>
  254. <xs:element name="P_ZGODA_NA_PRZETWARZANIE_DANYCH_W_CELACH_MARKETINGOWYCH" minOccurs="0"
  255. default="NIEWIADOMO">
  256. <xs:simpleType>
  257. <xs:restriction base="p5Type:string">
  258. <!--@2018-03-23 fixed blad piotrowego xsd:schema z api @2018-03-23 dla restriction enums-->
  259. <xs:enumeration value="TAK"/>
  260. <xs:enumeration value="NIE"/>
  261. <xs:enumeration value="NIEWIADOMO"/>
  262. </xs:restriction>
  263. </xs:simpleType>
  264. </xs:element>
  265. <xs:element name="P_ZGODA_NA_WYSŁANIE_PROPONOWANYCH_ZMIAN_W_UMOWIE" minOccurs="0"
  266. default="NIEWIADOMO">
  267. <xs:simpleType>
  268. <xs:restriction base="p5Type:string">
  269. <!--@2018-03-23 fixed blad piotrowego xsd:schema z api @2018-03-23 dla restriction enums-->
  270. <xs:enumeration value="TAK"/>
  271. <xs:enumeration value="NIE"/>
  272. <xs:enumeration value="NIEWIADOMO"/>
  273. </xs:restriction>
  274. </xs:simpleType>
  275. </xs:element>
  276. <xs:element name="P_ZGODA_NA_KIEROWANIE_KORESP_DROGA_ELEKTRONICZNA" minOccurs="0"
  277. default="NIEWIADOMO">
  278. <xs:simpleType>
  279. <xs:restriction base="p5Type:string">
  280. <!--@2018-03-23 fixed blad piotrowego xsd:schema z api @2018-03-23 dla restriction enums-->
  281. <xs:enumeration value="TAK"/>
  282. <xs:enumeration value="NIE"/>
  283. <xs:enumeration value="NIEWIADOMO"/>
  284. </xs:restriction>
  285. </xs:simpleType>
  286. </xs:element>
  287. <xs:element name="P_ZGODA_NA_WYSYLANIE_FAKTUR_ELEKTRONICZNIE" minOccurs="0"
  288. default="NIEWIADOMO">
  289. <xs:simpleType>
  290. <xs:restriction base="p5Type:string">
  291. <!--@2018-03-23 fixed blad piotrowego xsd:schema z api @2018-03-23 dla restriction enums-->
  292. <xs:enumeration value="TAK"/>
  293. <xs:enumeration value="NIE"/>
  294. <xs:enumeration value="NIEWIADOMO"/>
  295. </xs:restriction>
  296. </xs:simpleType>
  297. </xs:element>
  298. <xs:element name="P_ZGODA_NA_POTW_PRZYJECIA_REKLAMACJI_ELEKTRONICZNIE" minOccurs="0"
  299. default="NIEWIADOMO">
  300. <xs:simpleType>
  301. <xs:restriction base="p5Type:string">
  302. <!--@2018-03-23 fixed blad piotrowego xsd:schema z api @2018-03-23 dla restriction enums-->
  303. <xs:enumeration value="TAK"/>
  304. <xs:enumeration value="NIE"/>
  305. <xs:enumeration value="NIEWIADOMO"/>
  306. </xs:restriction>
  307. </xs:simpleType>
  308. </xs:element>
  309. <xs:element name="P_ZGODA_NA_ZAMIESZCZENIE_DANYCH_W_SPISIE_ABONENTOW" minOccurs="0"
  310. default="NIEWIADOMO">
  311. <xs:simpleType>
  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="TAK"/>
  315. <xs:enumeration value="NIE"/>
  316. <xs:enumeration value="NIEWIADOMO"/>
  317. </xs:restriction>
  318. </xs:simpleType>
  319. </xs:element>
  320. <xs:element name="bank" minOccurs="0" type="p5Type:string"/>
  321. <xs:element name="nr_rach" minOccurs="0" type="p5Type:string"/>
  322. <xs:element name="TAXPAYER_ID_BILLING_USERS" minOccurs="0" default="0"
  323. type="p5Type:integer"/>
  324. <xs:element maxOccurs="unbounded" minOccurs="0" ref="default_db__x3A__PROBLEMS:PROBLEMS"/>
  325. <xs:element maxOccurs="unbounded" minOccurs="0"
  326. ref="default_db__x3A__BILLING_NUMBERS:BILLING_NUMBERS_BILLS_FVAT">
  327. <xs:annotation>
  328. <xs:appinfo>
  329. <system_cache__appinfo:flat_relation_cache system_cache__appinfo:backref_evaluate="true"> <!-- todo czy backref jest potrzebny... -->
  330. <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"/>
  331. </system_cache__appinfo:flat_relation_cache>
  332. </xs:appinfo>
  333. <xs:documentation>FAKTURY DO OGLADANIA</xs:documentation>
  334. </xs:annotation>
  335. </xs:element>
  336. </xs:sequence>
  337. <xs:attribute name="label" type="xs:string"/>
  338. <xs:assert test="@label = concat(P_NAME, ' ', P_NAME_SECOND)"/>
  339. </xs:complexType>
  340. <xs:element name="COMPANIES" type="default_db__x3A__COMPANIES:COMPANIES"
  341. id="__COMPANIES___d5e7461-1_COMPANIES">
  342. <xs:key name="COMPANIES">
  343. <xs:selector xpath="."/>
  344. <xs:field xpath="P_NAME"/>
  345. <xs:field xpath="P_NAME_SECOND"/>
  346. </xs:key>
  347. </xs:element>
  348. <xs:element name="ID_BILLING_USERS" id="__COMPANIES___d5e7466-1_ID_BILLING"
  349. type="default_db__x3A__COMPANIES:COMPANIES">
  350. <xs:key name="ID_BILLING_USERS">
  351. <xs:selector xpath="."/>
  352. <xs:field xpath="P_NAME"/>
  353. <xs:field xpath="P_NAME_SECOND"/>
  354. </xs:key>
  355. </xs:element>
  356. <xs:element name="ID_BILLING_USERS_ADMIN" type="default_db__x3A__COMPANIES:COMPANIES">
  357. <xs:annotation>
  358. <xs:documentation>Np. Dowiązanie tego obiektu w ramach BUILDINGS określa, że obiekt jest administratorem danej nieruchomości. </xs:documentation>
  359. </xs:annotation>
  360. </xs:element>
  361. <xs:element name="KONTRAHENT" type="default_db__x3A__COMPANIES:COMPANIES"
  362. id="__COMPANIES___d5e7475-1_KONTRAHENT">
  363. <xs:key name="KONTRAHENT">
  364. <xs:selector xpath="."/>
  365. <xs:field xpath="P_NAME"/>
  366. <xs:field xpath="P_NAME_SECOND"/>
  367. </xs:key>
  368. </xs:element>
  369. <xs:element name="DOSTAWCA" type="default_db__x3A__COMPANIES:COMPANIES">
  370. <xs:annotation>
  371. <xs:documentation>na potrzeby SIGMA</xs:documentation>
  372. </xs:annotation>
  373. </xs:element>
  374. </xs:schema>