MK_Rewiry.xsd 26 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445
  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema"
  3. xmlns:gml="http://www.opengis.net/gml/3.2"
  4. xmlns:Types__x3A__default_Default="https://biuro.biall-net.pl/wfs/default_db/Types/Default.xsd"
  5. xmlns:default_db__x3A__IN7_DZIENNIK_KORESP="https://biuro.biall-net.pl/wfs/default_db/table/IN7_DZIENNIK_KORESP.xsd"
  6. xmlns:hfp="http://www.w3.org/2001/XMLSchema-hasFacetAndProperty"
  7. xmlns:default_db__x3A__ADMIN_USERS="https://biuro.biall-net.pl/wfs/default_db/table/ADMIN_USERS.xsd"
  8. xmlns:default_db__x3A__IN7_MK_BAZA_DYSTRYBUCJI="https://biuro.biall-net.pl/wfs/default_db/table/IN7_MK_BAZA_DYSTRYBUCJI.xsd"
  9. xmlns:SystemObjects__x3A__AccessGroup="https://biuro.biall-net.pl/wfs/default_db/SystemObjects/AccessGroup.xsd"
  10. xmlns:SystemObjects__x3A__AccessOwner="https://biuro.biall-net.pl/wfs/default_db/SystemObjects/AccessOwner.xsd"
  11. xmlns:default_db__x3A__MK_Rewiry="https://biuro.biall-net.pl/wfs/default_db/table/MK_Rewiry.xsd"
  12. xmlns:default_db__x3A__USERS2_MARKETING="https://biuro.biall-net.pl/wfs/default_db/table/USERS2_MARKETING.xsd"
  13. xmlns:p5_tr_map="http://biuro.biall-net.pl/xmlschema_procesy5/default_db_xml_cache/procesy5_translate_map.xsd"
  14. xmlns:vc="http://www.w3.org/2007/XMLSchema-versioning"
  15. 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"
  16. xmlns:system_cache__appinfo="http://biuro.biall-net.pl/xmlschema_procesy5/default_db_xml_cache/appinfo.xsd"
  17. xmlns:fix_se_defaultdb_schema="http://biuro.biall-net.pl/xmlschema_procesy5/WPS_Functions/fix_se_defaultdb_schema/fix_se_defaultdb_schema.xsd"
  18. xmlns:p5Type="http://biuro.biall-net.pl/p5/schema/types"
  19. xmlns:default_db__x3A__CRM_LISTA_ZASOBOW="https://biuro.biall-net.pl/wfs/default_db/table/CRM_LISTA_ZASOBOW.xsd"
  20. xmlns:default_db__x3A__SALES_PLAN="https://biuro.biall-net.pl/wfs/default_db/table/SALES_PLAN.xsd"
  21. xmlns:default_db__x3A__DEALS_TABLE="https://biuro.biall-net.pl/wfs/default_db/table/DEALS_TABLE.xsd"
  22. targetNamespace="https://biuro.biall-net.pl/wfs/default_db/table/MK_Rewiry.xsd"
  23. vc:minVersion="1.1">
  24. <xs:import namespace="http://biuro.biall-net.pl/p5/schema/types"
  25. schemaLocation="../../../types.xsd"/>
  26. <xs:import namespace="http://www.opengis.net/gml/3.2"
  27. schemaLocation="http://www.opengis.net/gml/3.2"/>
  28. <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/table/IN7_DZIENNIK_KORESP.xsd"
  29. schemaLocation="../../default_db.IN7_DZIENNIK_KORESP/IN7_DZIENNIK_KORESP/IN7_DZIENNIK_KORESP.xsd"/>
  30. <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/table/IN7_MK_BAZA_DYSTRYBUCJI.xsd"
  31. schemaLocation="../../default_db.IN7_MK_BAZA_DYSTRYBUCJI/IN7_MK_BAZA_DYSTRYBUCJI/IN7_MK_BAZA_DYSTRYBUCJI.xsd"/>
  32. <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/table/USERS2_MARKETING.xsd"
  33. schemaLocation="../../default_db.USERS2_MARKETING/USERS2_MARKETING/USERS2_MARKETING.xsd"/>
  34. <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/table/ADMIN_USERS.xsd"
  35. schemaLocation="../../default_db.ADMIN_USERS/ADMIN_USERS/ADMIN_USERS.xsd"/>
  36. <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/table/CRM_LISTA_ZASOBOW.xsd"
  37. schemaLocation="../../default_db.CRM_LISTA_ZASOBOW/CRM_LISTA_ZASOBOW/CRM_LISTA_ZASOBOW.xsd"/>
  38. <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/table/SALES_PLAN.xsd"
  39. schemaLocation="../../default_db.SALES_PLAN/SALES_PLAN/SALES_PLAN.xsd"/>
  40. <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/table/DEALS_TABLE.xsd"
  41. schemaLocation="../../default_db.DEALS_TABLE/DEALS_TABLE/DEALS_TABLE.xsd">
  42. <xs:annotation>
  43. <xs:documentation>Ta relacja bedzie potrzebna do raportów sprzedazy</xs:documentation>
  44. </xs:annotation>
  45. </xs:import>
  46. <xs:simpleType name="A_STATUS_Type" id="__MK_Rewiry___d5e78387-1_A_STATUS_T">
  47. <xs:restriction base="xs:string">
  48. <xs:enumeration value="NORMAL"/>
  49. <xs:enumeration value="WAITING"/>
  50. <xs:enumeration value="MONITOR"/>
  51. <xs:enumeration value="DELETED"/>
  52. <xs:enumeration value="WARNING"/>
  53. <xs:enumeration value="OFF_SOFT"/>
  54. <xs:enumeration value="OFF_HARD"/>
  55. </xs:restriction>
  56. </xs:simpleType>
  57. <xs:complexType name="MK_Rewiry"
  58. id="__MK_Rewiry___d5e78396-1_MK_Rewiry"
  59. system_cache__appinfo:primaryKey="ID">
  60. <xs:annotation>
  61. <xs:appinfo>
  62. <system_cache__appinfo:heritage>
  63. <system_cache__appinfo:inherit system_cache__appinfo:inherit_ref="default_db:MK_Rewiry"
  64. system_cache__appinfo:heritage_acl="true">
  65. <system_cache__appinfo:acl_rule_inherit_to_all_same_name_elements_and_refs/>
  66. <acl_rule_inherit_to_all_refs_by_primary/>
  67. <acl_rule_inherit_to_all_refs_by_local_element system_cache__appinfo:acl_rule_inherit_local_element_name="A_STATUS"/>
  68. </system_cache__appinfo:inherit>
  69. <system_cache__appinfo:exherit_all system_cache__appinfo:heritage_acl="true"
  70. system_cache__appinfo:heritage_sort="true"/>
  71. </system_cache__appinfo:heritage>
  72. </xs:appinfo>
  73. </xs:annotation>
  74. <xs:sequence id="__MK_Rewiry___d5e78397-1">
  75. <xs:element name="ID" type="xs:integer" id="__MK_Rewiry___d5e78417-1_ID"/>
  76. <xs:element name="the_geom"
  77. id="__MK_Rewiry___d5e78398-1_the_geom"
  78. type="p5Type:polygon"/>
  79. <xs:element name="A_STATUS"
  80. type="default_db__x3A__MK_Rewiry:A_STATUS_Type"
  81. id="__MK_Rewiry___d5e78402-1_A_STATUS"/>
  82. <xs:element name="A_STATUS_INFO"
  83. type="xs:string"
  84. id="__MK_Rewiry___d5e78403-1_A_STATUS_I"/>
  85. <xs:element name="L_APPOITMENT_USER"
  86. type="xs:string"
  87. id="__MK_Rewiry___d5e78404-1_L_APPOITME"/>
  88. <xs:element ref="default_db__x3A__ADMIN_USERS:L_APPOITMENT_USER">
  89. <xs:annotation>
  90. <xs:appinfo>
  91. <system_cache__appinfo:flat_relation_cache>
  92. <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
  93. system_cache__appinfo:name="L_APPOITMENT_USER"
  94. system_cache__appinfo:xpath="default_db__x3A__ADMIN_USERS:L_APPOITMENT_USER/ADM_ACCOUNT"/>
  95. </system_cache__appinfo:flat_relation_cache>
  96. </xs:appinfo>
  97. <xs:documentation>
  98. TODO CHECK IF THIS IS CORRECT FLAT RELATION! WAS GENERATED #166
  99. </xs:documentation>
  100. </xs:annotation>
  101. </xs:element>
  102. <!--<xs:element ref="SystemObjects__x3A__AccessOwner:AccessOwner">
  103. <xs:annotation>
  104. <xs:appinfo>
  105. <system_cache__appinfo:flat_relation_cache>
  106. <system_cache__appinfo:source system_cache__appinfo:name="L_APPOITMENT_USER" system_cache__appinfo:xpath="SystemObjects__x3A__AccessOwner:AccessOwner/name"/>
  107. </system_cache__appinfo:flat_relation_cache>
  108. </xs:appinfo>
  109. </xs:annotation>
  110. </xs:element>-->
  111. <xs:element name="A_CLASSIFIED"
  112. type="xs:string"
  113. id="__MK_Rewiry___d5e78406-1_A_CLASSIFI"/>
  114. <!--<xs:element ref="SystemObjects__x3A__AccessGroup:AccessGroupRead">
  115. <xs:annotation>
  116. <xs:appinfo>
  117. <system_cache__appinfo:flat_relation_cache>
  118. <system_cache__appinfo:source system_cache__appinfo:name="A_CLASSIFIED" system_cache__appinfo:xpath="SystemObjects__x3A__AccessGroup:AccessGroupRead/name"/>
  119. </system_cache__appinfo:flat_relation_cache>
  120. </xs:appinfo>
  121. </xs:annotation>
  122. </xs:element>-->
  123. <xs:element name="A_ADM_COMPANY"
  124. type="xs:string"
  125. id="__MK_Rewiry___d5e78408-1_A_ADM_COMP"/>
  126. <!--<xs:element ref="SystemObjects__x3A__AccessGroup:AccessGroupWrite">
  127. <xs:annotation>
  128. <xs:appinfo>
  129. <system_cache__appinfo:flat_relation_cache>
  130. <system_cache__appinfo:source system_cache__appinfo:name="A_ADM_COMPANY" system_cache__appinfo:xpath="SystemObjects__x3A__AccessGroup:AccessGroupWrite/name"/>
  131. </system_cache__appinfo:flat_relation_cache>
  132. </xs:appinfo>
  133. </xs:annotation>
  134. </xs:element>-->
  135. <xs:element name="cache_count_POPC_lokali"
  136. type="xs:integer"
  137. id="__MK_Rewiry___d5e78411-1_cache_coun"/>
  138. <xs:element name="data_kuponow"
  139. type="xs:string"
  140. id="__MK_Rewiry___d5e78413-1_data_kupon"/>
  141. <xs:element name="gis_square_ha_area"
  142. type="xs:double"
  143. id="__MK_Rewiry___d5e78414-1_gis_square"/>
  144. <xs:element name="NAZWA_REWI"
  145. type="xs:string"
  146. id="__MK_Rewiry___d5e78415-1_NAZWA_REWI"/>
  147. <xs:element name="T_INSTALACJA_W_CIAGU_DNI"
  148. type="xs:string"
  149. id="__MK_Rewiry___d5e78416-1_T_INSTALAC"/>
  150. <xs:element name="A_RECORD_CREATE_DATE"
  151. type="xs:token"
  152. id="__MK_Rewiry___d5e78418-1_A_RECORD_C"/>
  153. <xs:element name="A_RECORD_CREATE_AUTHOR"
  154. type="xs:string"
  155. id="__MK_Rewiry___d5e78419-1_A_RECORD_C"/>
  156. <xs:element name="A_RECORD_UPDATE_DATE"
  157. type="xs:token"
  158. id="__MK_Rewiry___d5e78421-1_A_RECORD_U"/>
  159. <xs:element name="A_RECORD_UPDATE_AUTHOR"
  160. type="xs:string"
  161. id="__MK_Rewiry___d5e78422-1_A_RECORD_U"/>
  162. <xs:element name="L_APPOITMENT_DATE"
  163. type="xs:string"
  164. id="__MK_Rewiry___d5e78423-1_L_APPOITME"/>
  165. <xs:element name="L_APPOITMENT_PERIOD"
  166. type="xs:string"
  167. id="__MK_Rewiry___d5e78425-1_L_APPOITME"/>
  168. <xs:element name="L_APPOITMENT_INFO"
  169. type="xs:string"
  170. id="__MK_Rewiry___d5e78426-1_L_APPOITME"/>
  171. <xs:element name="L_APPOITMENT_TYPE"
  172. type="xs:string"
  173. id="__MK_Rewiry___d5e78427-1_L_APPOITME"/>
  174. <xs:element name="CRM_LISTA_ZASOBOW_ID"
  175. type="xs:integer"
  176. id="__MK_Rewiry___d5e78428-1_CRM_LISTA_"/>
  177. <xs:element ref="default_db__x3A__CRM_LISTA_ZASOBOW:CRM_LISTA_ZASOBOW_ID">
  178. <xs:annotation>
  179. <xs:appinfo>
  180. <system_cache__appinfo:flat_relation_cache>
  181. <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
  182. system_cache__appinfo:name="CRM_LISTA_ZASOBOW_ID"
  183. system_cache__appinfo:xpath="default_db__x3A__CRM_LISTA_ZASOBOW:CRM_LISTA_ZASOBOW_ID/ID"/>
  184. </system_cache__appinfo:flat_relation_cache>
  185. </xs:appinfo>
  186. <xs:documentation>
  187. TODO CHECK IF THIS IS CORRECT FLAT RELATION! WAS GENERATED #224
  188. </xs:documentation>
  189. </xs:annotation>
  190. </xs:element>
  191. <xs:element name="ADMIN_USERS_ID"
  192. type="xs:integer"
  193. id="__MK_Rewiry___d5e78429-1_ADMIN_USER"/>
  194. <xs:element ref="default_db__x3A__ADMIN_USERS:ADMIN_USERS_ID">
  195. <xs:annotation>
  196. <xs:appinfo>
  197. <system_cache__appinfo:flat_relation_cache>
  198. <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
  199. system_cache__appinfo:name="ADMIN_USERS_ID"
  200. system_cache__appinfo:xpath="default_db__x3A__ADMIN_USERS:ADMIN_USERS_ID/ID"/>
  201. </system_cache__appinfo:flat_relation_cache>
  202. </xs:appinfo>
  203. <xs:documentation>
  204. TODO CHECK IF THIS IS CORRECT FLAT RELATION! WAS GENERATED #185
  205. </xs:documentation>
  206. </xs:annotation>
  207. </xs:element>
  208. <xs:element name="cache_count_POPC"
  209. type="xs:integer"
  210. id="__MK_Rewiry___d5e78430-1_cache_coun"/>
  211. <xs:element name="cache_count_POPC_plac"
  212. type="xs:integer"
  213. id="__MK_Rewiry___d5e78431-1_cache_coun"/>
  214. <xs:element name="cache_count_POPC_plac_os_A"
  215. type="xs:integer"
  216. id="__MK_Rewiry___d5e78432-1_cache_coun"/>
  217. <xs:element name="ID_PROJECT"
  218. type="xs:integer"
  219. id="__MK_Rewiry___d5e78433-1_ID_PROJECT"/>
  220. <xs:element ref="default_db__x3A__IN7_MK_BAZA_DYSTRYBUCJI:ID_PROJECT">
  221. <xs:annotation>
  222. <xs:appinfo>
  223. <system_cache__appinfo:flat_relation_cache>
  224. <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
  225. system_cache__appinfo:name="ID_PROJECT"
  226. system_cache__appinfo:xpath="default_db__x3A__IN7_MK_BAZA_DYSTRYBUCJI:ID_PROJECT/ID"/>
  227. </system_cache__appinfo:flat_relation_cache>
  228. </xs:appinfo>
  229. <xs:documentation>
  230. TODO CHECK IF THIS IS CORRECT FLAT RELATION! WAS GENERATED #204
  231. </xs:documentation>
  232. </xs:annotation>
  233. </xs:element>
  234. <xs:element name="TASKS_INFO_trigger" type="xs:string"/>
  235. <xs:element name="PROJ_INFO_trigger" type="xs:string">
  236. <xs:annotation>
  237. <xs:documentation>Bez tego pola @2018-03-28 ktore jest w bazie natywnie, UI zglaszal error ze Field Not Found - zatem dodaje te pola...</xs:documentation>
  238. </xs:annotation>
  239. </xs:element>
  240. <xs:element name="IN7_DZIENNIK_KORESP_INFO_trigger" type="xs:string"/>
  241. <xs:element name="ID_KORESP_PROJEKT"
  242. type="xs:integer"
  243. id="__MK_Rewiry___d5e78434-1_ID_KORESP_"/>
  244. <xs:element ref="default_db__x3A__IN7_DZIENNIK_KORESP:ID_KORESP_PROJEKT">
  245. <xs:annotation>
  246. <xs:appinfo>
  247. <system_cache__appinfo:flat_relation_cache>
  248. <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
  249. system_cache__appinfo:name="ID_KORESP_PROJEKT"
  250. system_cache__appinfo:xpath="default_db__x3A__IN7_DZIENNIK_KORESP:ID_KORESP_PROJEKT"/>
  251. </system_cache__appinfo:flat_relation_cache>
  252. </xs:appinfo>
  253. <xs:documentation>
  254. TODO CHECK IF THIS IS CORRECT FLAT RELATION! WAS GENERATED #245 !!!
  255. </xs:documentation>
  256. </xs:annotation>
  257. </xs:element>
  258. <xs:element name="ID_KORESP_ZLECENIE"
  259. type="xs:integer"
  260. id="__MK_Rewiry___d5e78437-1_ID_KORESP_"/>
  261. <xs:element ref="default_db__x3A__IN7_DZIENNIK_KORESP:ID_KORESP_ZLECENIE">
  262. <xs:annotation>
  263. <xs:appinfo>
  264. <system_cache__appinfo:flat_relation_cache>
  265. <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
  266. system_cache__appinfo:name="ID_KORESP_ZLECENIE"
  267. system_cache__appinfo:xpath="default_db__x3A__IN7_DZIENNIK_KORESP:ID_KORESP_ZLECENIE"/>
  268. </system_cache__appinfo:flat_relation_cache>
  269. </xs:appinfo>
  270. <xs:documentation>
  271. TODO CHECK IF THIS IS CORRECT FLAT RELATION! WAS GENERATED #245 !!!
  272. </xs:documentation>
  273. </xs:annotation>
  274. </xs:element>
  275. <xs:element name="ID_KORESP_ZLECENIE_PROJEKT"
  276. type="xs:integer"
  277. id="__MK_Rewiry___d5e78438-1_ID_KORESP_"/>
  278. <xs:element ref="default_db__x3A__IN7_DZIENNIK_KORESP:ID_KORESP_ZLECENIE_PROJEKT">
  279. <xs:annotation>
  280. <xs:appinfo>
  281. <system_cache__appinfo:flat_relation_cache>
  282. <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
  283. system_cache__appinfo:name="ID_KORESP_ZLECENIE_PROJEKT"
  284. system_cache__appinfo:xpath="default_db__x3A__IN7_DZIENNIK_KORESP:ID_KORESP_ZLECENIE_PROJEKT"/>
  285. </system_cache__appinfo:flat_relation_cache>
  286. </xs:appinfo>
  287. <xs:documentation>
  288. TODO CHECK IF THIS IS CORRECT FLAT RELATION! WAS GENERATED #245 !!!
  289. </xs:documentation>
  290. </xs:annotation>
  291. </xs:element>
  292. <xs:element name="ID_KORESP_PROTOK_ODB"
  293. type="xs:integer"
  294. id="__MK_Rewiry___d5e78439-1_ID_KORESP_"/>
  295. <xs:element ref="default_db__x3A__IN7_DZIENNIK_KORESP:ID_KORESP_PROTOK_ODB">
  296. <xs:annotation>
  297. <xs:appinfo>
  298. <system_cache__appinfo:flat_relation_cache>
  299. <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
  300. system_cache__appinfo:name="ID_KORESP_PROTOK_ODB"
  301. system_cache__appinfo:xpath="default_db__x3A__IN7_DZIENNIK_KORESP:ID_KORESP_PROTOK_ODB"/>
  302. </system_cache__appinfo:flat_relation_cache>
  303. </xs:appinfo>
  304. <xs:documentation>
  305. TODO CHECK IF THIS IS CORRECT FLAT RELATION! WAS GENERATED #245 !!!
  306. </xs:documentation>
  307. </xs:annotation>
  308. </xs:element>
  309. <xs:element name="ID_KORESP_OFFER"
  310. type="xs:integer"
  311. id="__MK_Rewiry___d5e78440-1_ID_KORESP_"/>
  312. <xs:element ref="default_db__x3A__IN7_DZIENNIK_KORESP:ID_KORESP_OFFER">
  313. <xs:annotation>
  314. <xs:appinfo>
  315. <system_cache__appinfo:flat_relation_cache>
  316. <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
  317. system_cache__appinfo:name="ID_KORESP_OFFER"
  318. system_cache__appinfo:xpath="default_db__x3A__IN7_DZIENNIK_KORESP:ID_KORESP_OFFER"/>
  319. </system_cache__appinfo:flat_relation_cache>
  320. </xs:appinfo>
  321. <xs:documentation>
  322. TODO CHECK IF THIS IS CORRECT FLAT RELATION! WAS GENERATED #245 !!!
  323. </xs:documentation>
  324. </xs:annotation>
  325. </xs:element>
  326. <xs:element name="ID_KORESP_UMOWA_DEVELOPPER"
  327. type="xs:integer"
  328. id="__MK_Rewiry___d5e78441-1_ID_KORESP_"/>
  329. <xs:element ref="default_db__x3A__IN7_DZIENNIK_KORESP:ID_KORESP_UMOWA_DEVELOPPER">
  330. <xs:annotation>
  331. <xs:appinfo>
  332. <system_cache__appinfo:flat_relation_cache>
  333. <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
  334. system_cache__appinfo:name="ID_KORESP_UMOWA_DEVELOPPER"
  335. system_cache__appinfo:xpath="default_db__x3A__IN7_DZIENNIK_KORESP:ID_KORESP_UMOWA_DEVELOPPER"/>
  336. </system_cache__appinfo:flat_relation_cache>
  337. </xs:appinfo>
  338. <xs:documentation>
  339. TODO CHECK IF THIS IS CORRECT FLAT RELATION! WAS GENERATED #245 !!!
  340. </xs:documentation>
  341. </xs:annotation>
  342. </xs:element>
  343. <xs:element name="PLANNED_DATE_PROJEKT_FINISH"
  344. type="xs:token"
  345. id="__MK_Rewiry___d5e78442-1_PLANNED_DA"/>
  346. <xs:element name="PLANNED_DATE_BUDOWA_START"
  347. type="xs:token"
  348. id="__MK_Rewiry___d5e78443-1_PLANNED_DA"/>
  349. <xs:element name="PLANNED_DATE_BUDOWA_FINISH"
  350. type="xs:token"
  351. id="__MK_Rewiry___d5e78444-1_PLANNED_DA"/>
  352. <xs:element ref="default_db__x3A__USERS2_MARKETING:USERS2_MARKETING"
  353. maxOccurs="unbounded"
  354. minOccurs="0">
  355. <xs:annotation>
  356. <xs:appinfo>
  357. <system_cache__appinfo:flat_relation_cache>
  358. <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
  359. system_cache__appinfo:name="NAZWA_REWI"
  360. system_cache__appinfo:xpath="default_db__x3A__USERS2_MARKETING:USERS2_MARKETING/M_REWIR"/>
  361. </system_cache__appinfo:flat_relation_cache>
  362. </xs:appinfo>
  363. <xs:documentation>Podstawowqe filtrowania klientow</xs:documentation>
  364. </xs:annotation>
  365. </xs:element>
  366. <xs:element ref="default_db__x3A__USERS2_MARKETING:USERS2_MARKETING_BN_FRESH"
  367. id="__MK_Rewiry___d5e78445-1"
  368. maxOccurs="unbounded"
  369. minOccurs="0">
  370. <xs:annotation>
  371. <xs:appinfo>
  372. <system_cache__appinfo:flat_relation_cache>
  373. <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
  374. system_cache__appinfo:name="NAZWA_REWI"
  375. system_cache__appinfo:xpath="default_db__x3A__USERS2_MARKETING:USERS2_MARKETING_BN_FRESH/M_REWIR"/>
  376. </system_cache__appinfo:flat_relation_cache>
  377. </xs:appinfo>
  378. <xs:documentation>Podstawowqe filtrowania klientow</xs:documentation>
  379. </xs:annotation>
  380. </xs:element>
  381. <xs:element ref="default_db__x3A__USERS2_MARKETING:USERS2_MARKETING_OBCY_OLD"
  382. id="__MK_Rewiry___d5e78450-1"
  383. maxOccurs="unbounded"
  384. minOccurs="0">
  385. <xs:annotation>
  386. <xs:appinfo>
  387. <system_cache__appinfo:flat_relation_cache>
  388. <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
  389. system_cache__appinfo:name="NAZWA_REWI"
  390. system_cache__appinfo:xpath="default_db__x3A__USERS2_MARKETING:USERS2_MARKETING_OBCY_OLD/M_REWIR"/>
  391. </system_cache__appinfo:flat_relation_cache>
  392. </xs:appinfo>
  393. <xs:documentation>Podstawowqe filtrowania klientow</xs:documentation>
  394. </xs:annotation>
  395. </xs:element>
  396. <xs:element ref="default_db__x3A__USERS2_MARKETING:USERS2_MARKETING_BN_OLD"
  397. id="__MK_Rewiry___d5e78455-1"
  398. maxOccurs="unbounded"
  399. minOccurs="0">
  400. <xs:annotation>
  401. <xs:appinfo>
  402. <system_cache__appinfo:flat_relation_cache>
  403. <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
  404. system_cache__appinfo:name="NAZWA_REWI"
  405. system_cache__appinfo:xpath="default_db__x3A__USERS2_MARKETING:USERS2_MARKETING_BN_OLD/M_REWIR"/>
  406. </system_cache__appinfo:flat_relation_cache>
  407. </xs:appinfo>
  408. <xs:documentation>Podstawowqe filtrowania klientow</xs:documentation>
  409. </xs:annotation>
  410. </xs:element>
  411. <xs:element maxOccurs="unbounded"
  412. minOccurs="0"
  413. ref="default_db__x3A__SALES_PLAN:SALES_PLAN">
  414. <xs:annotation>
  415. <xs:appinfo>
  416. <system_cache__appinfo:flat_relation_cache>
  417. <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
  418. system_cache__appinfo:name="NAZWA_REWI"
  419. system_cache__appinfo:xpath="default_db__x3A__SALES_PLAN:SALES_PLAN/NAZWA_REWI"/>
  420. </system_cache__appinfo:flat_relation_cache>
  421. </xs:appinfo>
  422. </xs:annotation>
  423. </xs:element>
  424. <xs:element maxOccurs="unbounded"
  425. minOccurs="0"
  426. ref="default_db__x3A__DEALS_TABLE:DEALS_TABLE">
  427. <xs:annotation>
  428. <xs:documentation>
  429. Potrzebne do raportu sprzedazy - idziemy do faktur
  430. </xs:documentation>
  431. <xs:appinfo>
  432. <system_cache__appinfo:flat_relation_cache>
  433. <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
  434. system_cache__appinfo:name="NAZWA_REWI"
  435. system_cache__appinfo:xpath="default_db__x3A__DEALS_TABLE:DEALS_TABLE/M_REWIR"/>
  436. </system_cache__appinfo:flat_relation_cache>
  437. </xs:appinfo>
  438. </xs:annotation>
  439. </xs:element>
  440. </xs:sequence>
  441. </xs:complexType>
  442. <xs:element name="MK_Rewiry"
  443. type="default_db__x3A__MK_Rewiry:MK_Rewiry"
  444. id="__MK_Rewiry___d5e78466-1_MK_Rewiry"/>
  445. </xs:schema>