USERS2_OFFERS.xsd 38 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573
  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:gml="http://www.opengis.net/gml/3.2"
  3. xmlns:Types__x3A__default_Default="https://biuro.biall-net.pl/wfs/default_db/Types/Default.xsd"
  4. xmlns:default_db__x3A__IN7_DZIENNIK_KORESP="https://biuro.biall-net.pl/wfs/default_db/table/IN7_DZIENNIK_KORESP.xsd"
  5. xmlns:hfp="http://www.w3.org/2001/XMLSchema-hasFacetAndProperty"
  6. xmlns:default_db__x3A__ADMIN_USERS="https://biuro.biall-net.pl/wfs/default_db/table/ADMIN_USERS.xsd"
  7. xmlns:default_db__x3A__IN7_MK_BAZA_DYSTRYBUCJI="https://biuro.biall-net.pl/wfs/default_db/table/IN7_MK_BAZA_DYSTRYBUCJI.xsd"
  8. xmlns:SystemObjects__x3A__AccessGroup="https://biuro.biall-net.pl/wfs/default_db/SystemObjects/AccessGroup.xsd"
  9. xmlns:SystemObjects__x3A__AccessOwner="https://biuro.biall-net.pl/wfs/default_db/SystemObjects/AccessOwner.xsd"
  10. xmlns:default_db__x3A__USERS2_OFFERS="https://biuro.biall-net.pl/wfs/default_db/table/USERS2_OFFERS.xsd"
  11. xmlns:default_db__x3A__USERS2_OFFERS_GROUPS="https://biuro.biall-net.pl/wfs/default_db/table/USERS2_OFFERS_GROUPS.xsd"
  12. xmlns:default_db__x3A__BUILDINGS="https://biuro.biall-net.pl/wfs/default_db/table/BUILDINGS.xsd"
  13. xmlns:fix_se_defaultdb_schema="http://biuro.biall-net.pl/xmlschema_procesy5/WPS_Functions/fix_se_defaultdb_schema/fix_se_defaultdb_schema.xsd"
  14. xmlns:p5Type="http://biuro.biall-net.pl/p5/schema/types"
  15. xmlns:default_db__x3A__CRM_LISTA_ZASOBOW="https://biuro.biall-net.pl/wfs/default_db/table/CRM_LISTA_ZASOBOW.xsd"
  16. xmlns:default_db__x3A__USERS2_OFFERS_COSTS_GROUPS="https://biuro.biall-net.pl/wfs/default_db/table/USERS2_OFFERS_COSTS_GROUPS.xsd"
  17. xmlns:default_db__x3A__MK_Rewiry="https://biuro.biall-net.pl/wfs/default_db/table/MK_Rewiry.xsd"
  18. xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  19. xmlns:p5_tr_map="http://biuro.biall-net.pl/xmlschema_procesy5/default_db_xml_cache/procesy5_translate_map.xsd"
  20. xmlns:vc="http://www.w3.org/2007/XMLSchema-versioning"
  21. 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"
  22. xmlns:system_cache__appinfo="http://biuro.biall-net.pl/xmlschema_procesy5/default_db_xml_cache/appinfo.xsd"
  23. xmlns:p5opr="http://biuro.biall-net.pl/xmlschema_procesy5/system_cache/object_parent_relations/object_parent_relations.xsd"
  24. xmlns:p5_simpleSchema_map="http://biuro.biall-net.pl/xmlschema_procesy5/default_db_xml_cache/p5_simpleSchema_map.xsd"
  25. xmlns:ant-object="http://biuro.biall-net.pl/xmlschema_procesy5/ant-object/ant-object.xsd"
  26. xmlns:p5ant-interface="http://biuro.biall-net.pl/xmlschema_procesy5/WPS_Functions/ant_interface/ant_interface.xsd"
  27. targetNamespace="https://biuro.biall-net.pl/wfs/default_db/table/USERS2_OFFERS.xsd"
  28. vc:minVersion="1.1">
  29. <!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
  30. <xs:annotation>
  31. <xs:documentation>TODO @2018-03-25 - do ustalenia sposob restrykcji optymalny, aby duzo zasobow sie nie dodawalo? lub moze to zostac tak</xs:documentation>
  32. </xs:annotation>
  33. <xs:import namespace="http://biuro.biall-net.pl/p5/schema/types"
  34. schemaLocation="../../../types.xsd"/>
  35. <xs:import namespace="http://www.opengis.net/gml/3.2"
  36. schemaLocation="http://www.opengis.net/gml/3.2"/>
  37. <!---->
  38. <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/table/IN7_DZIENNIK_KORESP.xsd"
  39. schemaLocation="../../default_db.IN7_DZIENNIK_KORESP/IN7_DZIENNIK_KORESP/IN7_DZIENNIK_KORESP.xsd"/>
  40. <xs:import
  41. namespace="https://biuro.biall-net.pl/wfs/default_db/table/IN7_MK_BAZA_DYSTRYBUCJI.xsd"
  42. schemaLocation="../../default_db.IN7_MK_BAZA_DYSTRYBUCJI/IN7_MK_BAZA_DYSTRYBUCJI/IN7_MK_BAZA_DYSTRYBUCJI.xsd"/>
  43. <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/table/USERS2_OFFERS_GROUPS.xsd"
  44. schemaLocation="../../default_db.USERS2_OFFERS_GROUPS/USERS2_OFFERS_GROUPS/USERS2_OFFERS_GROUPS.xsd"/>
  45. <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/table/BUILDINGS.xsd"
  46. schemaLocation="../../default_db.BUILDINGS/BUILDINGS/BUILDINGS.xsd"/>
  47. <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/table/ADMIN_USERS.xsd"
  48. schemaLocation="../../default_db.ADMIN_USERS/ADMIN_USERS/ADMIN_USERS.xsd"/>
  49. <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/table/CRM_LISTA_ZASOBOW.xsd"
  50. schemaLocation="../../default_db.CRM_LISTA_ZASOBOW/CRM_LISTA_ZASOBOW/CRM_LISTA_ZASOBOW.xsd"/>
  51. <xs:import
  52. namespace="https://biuro.biall-net.pl/wfs/default_db/table/USERS2_OFFERS_COSTS_GROUPS.xsd"
  53. schemaLocation="../../default_db.USERS2_OFFERS_COSTS_GROUPS/USERS2_OFFERS_COSTS_GROUPS/USERS2_OFFERS_COSTS_GROUPS.xsd"/>
  54. <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/table/MK_Rewiry.xsd"
  55. schemaLocation="../../default_db.MK_Rewiry/MK_Rewiry/MK_Rewiry.xsd"/>
  56. <xs:simpleType name="A_STATUS_Type" id="ERS2_OFFERS___d18e65313-1_A_STATUS_T">
  57. <xs:restriction base="xs:string">
  58. <xs:enumeration value="NORMAL"/>
  59. <xs:enumeration value="WAITING"/>
  60. <xs:enumeration value="MONITOR"/>
  61. <xs:enumeration value="DELETED"/>
  62. <xs:enumeration value="WARNING"/>
  63. <xs:enumeration value="OFF_SOFT"/>
  64. <xs:enumeration value="OFF_HARD"/>
  65. </xs:restriction>
  66. </xs:simpleType>
  67. <xs:complexType name="USERS2_OFFERS" system_cache__appinfo:primaryKey="ID"
  68. id="ERS2_OFFERS___d18e65322-1_USERS2_OFF">
  69. <!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
  70. <xs:annotation>
  71. <xs:appinfo>
  72. <system_cache__appinfo:heritage>
  73. <system_cache__appinfo:inherit system_cache__appinfo:inherit_ref="default_db:USERS2_OFFERS" system_cache__appinfo:heritage_acl="true">
  74. <system_cache__appinfo:acl_rule_inherit_to_all_same_name_elements_and_refs/>
  75. <acl_rule_inherit_to_all_refs_by_primary/>
  76. <acl_rule_inherit_to_all_refs_by_local_element system_cache__appinfo:acl_rule_inherit_local_element_name="A_STATUS"/>
  77. </system_cache__appinfo:inherit>
  78. <system_cache__appinfo:exherit_all system_cache__appinfo:heritage_acl="true" system_cache__appinfo:heritage_sort="true"/>
  79. </system_cache__appinfo:heritage>
  80. </xs:appinfo>
  81. </xs:annotation>
  82. <xs:sequence id="ERS2_OFFERS___d18e65331-1">
  83. <xs:element name="ID" type="xs:integer" id="ERS2_OFFERS___d18e65332-1_ID"/>
  84. <!--<xs:element name="A_ID_USERS2" type="xs:integer" id="ERS2_OFFERS___d5e91117-1_A_ID_USERS"/>-->
  85. <xs:element name="A_RECORD_CREATE_DATE" type="xs:string"
  86. id="ERS2_OFFERS___d18e65334-1_A_RECORD_C"/>
  87. <xs:element name="A_RECORD_CREATE_AUTHOR" type="xs:string"
  88. id="ERS2_OFFERS___d18e65335-1_A_RECORD_C"/>
  89. <xs:element name="A_RECORD_UPDATE_DATE" type="xs:string"
  90. id="ERS2_OFFERS___d18e65336-1_A_RECORD_U"/>
  91. <xs:element name="A_RECORD_UPDATE_AUTHOR" type="xs:string"
  92. id="ERS2_OFFERS___d18e65337-1_A_RECORD_U"/>
  93. <xs:element name="TAB_UPDATE_STAT" type="xs:string"
  94. id="ERS2_OFFERS___d18e65338-1_TAB_UPDATE"/>
  95. <xs:element name="TAB_UPDATE_DATE" type="xs:token"
  96. id="ERS2_OFFERS___d18e65339-1_TAB_UPDATE"/>
  97. <xs:element name="TAB_UPDATE_INFO" type="xs:string"
  98. id="ERS2_OFFERS___d18e65340-1_TAB_UPDATE"/>
  99. <xs:element name="L_APPOITMENT_DATE" type="xs:string"
  100. id="ERS2_OFFERS___d18e65341-1_L_APPOITME"/>
  101. <xs:element name="L_APPOITMENT_USER" type="xs:string"
  102. id="ERS2_OFFERS___d18e65342-1_L_APPOITME"/>
  103. <xs:element ref="default_db__x3A__ADMIN_USERS:L_APPOITMENT_USER"
  104. id="ERS2_OFFERS___d18e65344-1">
  105. <!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
  106. <xs:annotation>
  107. <xs:appinfo>
  108. <system_cache__appinfo:flat_relation_cache>
  109. <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"/>
  110. </system_cache__appinfo:flat_relation_cache>
  111. </xs:appinfo>
  112. <xs:documentation>
  113. TODO CHECK IF THIS IS CORRECT FLAT RELATION! WAS GENERATED #180200
  114. </xs:documentation>
  115. </xs:annotation>
  116. </xs:element>
  117. <xs:element name="L_APPOITMENT_PERIOD" type="xs:string"
  118. id="ERS2_OFFERS___d18e65351-1_L_APPOITME"/>
  119. <xs:element name="L_APPOITMENT_INFO" type="xs:string"
  120. id="ERS2_OFFERS___d18e65352-1_L_APPOITME"/>
  121. <xs:element name="L_APPOITMENT_TYPE" type="xs:string"
  122. id="ERS2_OFFERS___d18e65353-1_L_APPOITME"/>
  123. <xs:element name="A_PROBLEM" type="xs:string" id="ERS2_OFFERS___d18e65354-1_A_PROBLEM"/>
  124. <xs:element name="A_PROBLEM_DESC" type="xs:string"
  125. id="ERS2_OFFERS___d18e65355-1_A_PROBLEM_"/>
  126. <xs:element name="A_PROBLEM_DATE" type="xs:string"
  127. id="ERS2_OFFERS___d18e65356-1_A_PROBLEM_"/>
  128. <xs:element name="A_STATUS" type="xs:string" id="ERS2_OFFERS___d18e65357-1_A_STATUS"/>
  129. <xs:element name="A_STATUS_CURRENT" type="xs:string"
  130. id="ERS2_OFFERS___d18e65358-1_A_STATUS_C"/>
  131. <xs:element name="A_STATUS_INFO" type="xs:string" id="ERS2_OFFERS___d18e65359-1_A_STATUS_I"/>
  132. <xs:element name="A_STATUS_LASTCHANGE_DATE" type="xs:string"
  133. id="ERS2_OFFERS___d18e65360-1_A_STATUS_L"/>
  134. <xs:element name="A_UPDATE_DATE" type="xs:string" id="ERS2_OFFERS___d18e65362-1_A_UPDATE_D"/>
  135. <xs:element name="A_ADM_COMPANY" type="xs:string" id="ERS2_OFFERS___d18e65363-1_A_ADM_COMP"/>
  136. <xs:element name="S_ALIAS" type="xs:string" id="ERS2_OFFERS___d18e65364-1_S_ALIAS"/>
  137. <xs:element name="S_ADDRESS_CITY" type="xs:string"
  138. id="ERS2_OFFERS___d18e65365-1_S_ADDRESS_"/>
  139. <xs:element name="S_ADDRESS_POST_CODE" type="xs:string"
  140. id="ERS2_OFFERS___d18e65366-1_S_ADDRESS_"/>
  141. <xs:element name="S_ADDRESS_POST_OFFICE" type="xs:string"
  142. id="ERS2_OFFERS___d18e65367-1_S_ADDRESS_"/>
  143. <xs:element name="S_ADDRESS_STREET" type="xs:string"
  144. id="ERS2_OFFERS___d18e65368-1_S_ADDRESS_"/>
  145. <xs:element name="S_ADDRESS_HOUSE" type="xs:string"
  146. id="ERS2_OFFERS___d18e65369-1_S_ADDRESS_"/>
  147. <xs:element name="S_OTHER_INFO" type="xs:string" id="ERS2_OFFERS___d18e65370-1_S_OTHER_IN"/>
  148. <xs:element name="S_VIP_LEVEL" type="xs:string" id="ERS2_OFFERS___d18e65371-1_S_VIP_LEVE"/>
  149. <xs:element name="S_VIP_DESC" type="xs:string" id="ERS2_OFFERS___d18e65372-1_S_VIP_DESC"/>
  150. <xs:element name="T_NETWORK_SERVER" type="xs:string"
  151. id="ERS2_OFFERS___d18e65374-1_T_NETWORK_"/>
  152. <xs:element name="T_TELBOX_ADDRESS" type="xs:string"
  153. id="ERS2_OFFERS___d18e65375-1_T_TELBOX_A"/>
  154. <xs:element name="T_WORKPOINTS" type="xs:string" id="ERS2_OFFERS___d18e65376-1_T_WORKPOIN"/>
  155. <xs:element name="T_WORKPOINTS_VALUE" type="xs:string"
  156. id="ERS2_OFFERS___d18e65377-1_T_WORKPOIN"/>
  157. <xs:element name="T_WORKPOINTS_TYPE" type="xs:string"
  158. id="ERS2_OFFERS___d18e65378-1_T_WORKPOIN"/>
  159. <xs:element name="T_WORKPOINTS_USER" type="xs:string"
  160. id="ERS2_OFFERS___d18e65379-1_T_WORKPOIN"/>
  161. <xs:element name="T_WORKPOINTS_DATE" type="xs:string"
  162. id="ERS2_OFFERS___d18e65380-1_T_WORKPOIN"/>
  163. <xs:element name="T_PENALTIES" type="xs:string" id="ERS2_OFFERS___d18e65381-1_T_PENALTIE"/>
  164. <xs:element name="T_PENALTIES_TYPE" type="xs:string"
  165. id="ERS2_OFFERS___d18e65382-1_T_PENALTIE"/>
  166. <xs:element name="T_PENALTIES_VALUE" type="xs:string"
  167. id="ERS2_OFFERS___d18e65383-1_T_PENALTIE"/>
  168. <xs:element name="P_NAME" type="xs:string" id="ERS2_OFFERS___d18e65384-1_P_NAME"/>
  169. <xs:element name="P_SERVICE" type="xs:string" id="ERS2_OFFERS___d18e65386-1_P_SERVICE"/>
  170. <xs:element name="P_SERVICE_PARENT" type="xs:string"
  171. id="ERS2_OFFERS___d18e65387-1_P_SERVICE_"/>
  172. <xs:element name="P_SERVICE_COMPANY" type="xs:string"
  173. id="ERS2_OFFERS___d18e65388-1_P_SERVICE_"/>
  174. <xs:element name="P_SERVICE_NAME" type="xs:string"
  175. id="ERS2_OFFERS___d18e65389-1_P_SERVICE_"/>
  176. <xs:element name="USERS2_OFFERS_GROUPS_ID" type="xs:integer"
  177. id="ERS2_OFFERS___d18e65390-1_USERS2_OFF"/>
  178. <xs:element ref="default_db__x3A__USERS2_OFFERS_GROUPS:USERS2_OFFERS_GROUPS"
  179. id="ERS2_OFFERS___d18e65391-1"/>
  180. <xs:element name="P_PROMOTION_NAME" type="xs:string"
  181. id="ERS2_OFFERS___d18e65392-1_P_PROMOTIO"/>
  182. <xs:element name="P_S_PARAM1" type="xs:string" id="ERS2_OFFERS___d18e65393-1_P_S_PARAM1"/>
  183. <xs:element name="P_S_PARAM2" type="xs:string" id="ERS2_OFFERS___d18e65394-1_P_S_PARAM2"/>
  184. <xs:element name="P_S_LIMIT" type="xs:string" id="ERS2_OFFERS___d18e65395-1_P_S_LIMIT"/>
  185. <xs:element name="P_S_LAN" type="xs:string" id="ERS2_OFFERS___d18e65396-1_P_S_LAN"/>
  186. <xs:element name="P_DEALTERM_MONTHS" type="xs:integer"
  187. id="ERS2_OFFERS___d18e65398-1_P_DEALTERM"/>
  188. <xs:element name="P_DEAL_PROMO_MONTHS" type="xs:integer"
  189. id="ERS2_OFFERS___d18e65399-1_P_DEAL_PRO"/>
  190. <xs:element name="STAWKA_VAT" type="xs:integer" id="ERS2_OFFERS___d18e65400-1_STAWKA_VAT"/>
  191. <xs:element name="P_INSTALL_QUOTE" type="xs:double"
  192. id="ERS2_OFFERS___d18e65401-1_P_INSTALL_"/>
  193. <xs:element name="P_INSTALL_QUOTE_NORMAL" type="xs:double"
  194. id="ERS2_OFFERS___d18e65402-1_P_INSTALL_"/>
  195. <xs:element name="P_CONTRACT_PRICE" type="xs:double"
  196. id="ERS2_OFFERS___d18e65403-1_P_CONTRACT"/>
  197. <xs:element name="P_CONTRACT_PRICE_NETTO" type="xs:double"
  198. id="ERS2_OFFERS___d18e65404-1_P_CONTRACT"/>
  199. <xs:element name="P_PROMO_MONTH_PRICE" type="xs:double"
  200. id="ERS2_OFFERS___d18e65405-1_P_PROMO_MO"/>
  201. <xs:element name="P_PROMO_MONTH_PRICE_NETTO" type="xs:double"
  202. id="ERS2_OFFERS___d18e65406-1_P_PROMO_MO"/>
  203. <xs:element name="P_NORMAL_PRICE" type="xs:double"
  204. id="ERS2_OFFERS___d18e65407-1_P_NORMAL_P"/>
  205. <xs:element name="P_NORMAL_PRICE_NETTO" type="xs:double"
  206. id="ERS2_OFFERS___d18e65408-1_P_NORMAL_P"/>
  207. <xs:element name="P_S_MAILBOX_SIZE" type="xs:string"
  208. id="ERS2_OFFERS___d18e65410-1_P_S_MAILBO"/>
  209. <xs:element name="P_S_WWW_SIZE" type="xs:string" id="ERS2_OFFERS___d18e65411-1_P_S_WWW_SI"/>
  210. <xs:element name="P_OFFER_TERM_BEGIN" type="xs:token"
  211. id="ERS2_OFFERS___d18e65412-1_P_OFFER_TE"/>
  212. <xs:element name="P_OFFER_TERM" type="xs:token" id="ERS2_OFFERS___d18e65413-1_P_OFFER_TE"/>
  213. <xs:element name="T_TELBOX_BUILDING_IN" type="xs:string"
  214. id="ERS2_OFFERS___d18e65414-1_T_TELBOX_B"/>
  215. <xs:element ref="default_db__x3A__BUILDINGS:T_TELBOX_BUILDING_IN"
  216. id="ERS2_OFFERS___d18e65415-1"/>
  217. <xs:element name="BAD_DATE" type="xs:token" id="ERS2_OFFERS___d18e65416-1_BAD_DATE"/>
  218. <xs:element name="BAD_ZAINT" type="xs:string" id="ERS2_OFFERS___d18e65417-1_BAD_ZAINT"/>
  219. <xs:element name="M_REWIR" type="xs:string" id="ERS2_OFFERS___d18e65418-1_M_REWIR"/>
  220. <xs:element ref="default_db__x3A__MK_Rewiry:MK_Rewiry" id="ERS2_OFFERS___d18e65419-1"/>
  221. <xs:element name="ID_COSTS_GROUPS" type="xs:integer"
  222. id="ERS2_OFFERS___d18e65420-1_ID_COSTS_G"/>
  223. <xs:element ref="default_db__x3A__USERS2_OFFERS_COSTS_GROUPS:USERS2_OFFERS_COSTS_GROUPS"
  224. id="ERS2_OFFERS___d18e65422-1"/>
  225. <xs:element name="S_DEKODER_SD_OPTION" type="xs:string"
  226. id="ERS2_OFFERS___d18e65423-1_S_DEKODER_"/>
  227. <xs:element name="S_MODUL_PCMCIA_OPTION" type="xs:string"
  228. id="ERS2_OFFERS___d18e65424-1_S_MODUL_PC"/>
  229. <xs:element name="S_DEKODER_HD_OPTION" type="xs:string"
  230. id="ERS2_OFFERS___d18e65425-1_S_DEKODER_"/>
  231. <xs:element name="ID_PRODUKT" type="xs:integer" id="ERS2_OFFERS___d18e65426-1_ID_PRODUKT"/>
  232. <xs:element name="P_ACCOUNT" type="xs:string" id="ERS2_OFFERS___d18e65427-1_P_ACCOUNT"/>
  233. <xs:element name="P_SERVICE_QUOTA_PROFILE" type="xs:string"
  234. id="ERS2_OFFERS___d18e65428-1_P_SERVICE_"/>
  235. <xs:element name="LAN_DOWNLOAD" type="xs:string" id="ERS2_OFFERS___d18e65429-1_LAN_DOWNLO"/>
  236. <xs:element name="S_PUBLIC_IP" type="xs:string" id="ERS2_OFFERS___d18e65430-1_S_PUBLIC_I"/>
  237. <xs:element name="S_SOHO_WIFI_ROUTER_1292" type="xs:string"
  238. id="ERS2_OFFERS___d18e65431-1_S_SOHO_WIF"/>
  239. <xs:element name="S_E_PORT_1293" type="xs:string" id="ERS2_OFFERS___d18e65432-1_S_E_PORT_1"/>
  240. <xs:element name="P_DEVICE" type="xs:string" id="ERS2_OFFERS___d18e65434-1_P_DEVICE"/>
  241. <xs:element name="P_SERVICE_CLASS" type="xs:string"
  242. id="ERS2_OFFERS___d18e65435-1_P_SERVICE_"/>
  243. <xs:element name="P_SERVICE_SOCKETS_AMMOUNT_1298" type="xs:string"
  244. id="ERS2_OFFERS___d18e65436-1_P_SERVICE_"/>
  245. <xs:element name="ID_DOMAINS_PACKET_ID" type="xs:string"
  246. id="ERS2_OFFERS___d18e65437-1_ID_DOMAINS"/>
  247. <xs:element name="VOIP_FAX2EMAIL" type="xs:string"
  248. id="ERS2_OFFERS___d18e65438-1_VOIP_FAX2E"/>
  249. <xs:element name="ID_DOMAINS" type="xs:string" id="ERS2_OFFERS___d18e65439-1_ID_DOMAINS"/>
  250. <xs:element name="CONN_DIV" type="xs:string" id="ERS2_OFFERS___d18e65440-1_CONN_DIV"/>
  251. <xs:element name="P_SERVICE_QUOTA" type="xs:integer"
  252. id="ERS2_OFFERS___d18e65441-1_P_SERVICE_"/>
  253. <xs:element name="ID_PROCES" type="xs:integer" id="ERS2_OFFERS___d18e65442-1_ID_PROCES"/>
  254. <xs:element name="S_TECHNOLOGY" type="xs:string" id="ERS2_OFFERS___d18e65443-1_S_TECHNOLO"/>
  255. <xs:element name="A_CLASSIFIED" type="xs:string" id="ERS2_OFFERS___d18e65444-1_A_CLASSIFI"/>
  256. <xs:element name="P_MULTIROOM_ADD_CARDS" type="xs:integer"
  257. id="ERS2_OFFERS___d18e65446-1_P_MULTIROO"/>
  258. <xs:element name="P_MULTIROOM_ADD_DEKODER_SD" type="xs:integer"
  259. id="ERS2_OFFERS___d18e65447-1_P_MULTIROO"/>
  260. <xs:element name="P_MULTIROOM_ADD_DEKODER_HD" type="xs:integer"
  261. id="ERS2_OFFERS___d18e65448-1_P_MULTIROO"/>
  262. <xs:element name="P_MULTIROOM_ADD_MODUL_CAM" type="xs:integer"
  263. id="ERS2_OFFERS___d18e65449-1_P_MULTIROO"/>
  264. <xs:element name="P_SERVICE_UPLOAD_RATIO" type="xs:string"
  265. id="ERS2_OFFERS___d18e65450-1_P_SERVICE_"/>
  266. <xs:element name="ID_OFFER_NEW_SUGGESTED" type="xs:integer"
  267. id="ERS2_OFFERS___d18e65451-1_ID_OFFER_N"/>
  268. <xs:element name="STAT_SOLD_LAST_MONTH_QTY" type="xs:integer"
  269. id="ERS2_OFFERS___d18e65452-1_STAT_SOLD_"/>
  270. <xs:element name="STAT_USED_IN_OFFERS_GROUP_COUNT" type="xs:integer"
  271. id="ERS2_OFFERS___d18e65453-1_STAT_USED_"/>
  272. <xs:element name="PARENT_ID" type="xs:integer" id="ERS2_OFFERS___d18e65454-1_PARENT_ID"/>
  273. <xs:element name="CRM_LISTA_ZASOBOW_ID" type="xs:integer"
  274. id="ERS2_OFFERS___d18e65455-1_CRM_LISTA_"/>
  275. <xs:element ref="default_db__x3A__CRM_LISTA_ZASOBOW:CRM_LISTA_ZASOBOW_ID"
  276. id="ERS2_OFFERS___d18e65456-1">
  277. <!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
  278. <xs:annotation>
  279. <xs:appinfo>
  280. <system_cache__appinfo:flat_relation_cache>
  281. <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"/>
  282. </system_cache__appinfo:flat_relation_cache>
  283. </xs:appinfo>
  284. <xs:documentation>
  285. TODO CHECK IF THIS IS CORRECT FLAT RELATION! WAS GENERATED
  286. </xs:documentation>
  287. </xs:annotation>
  288. </xs:element>
  289. </xs:sequence>
  290. </xs:complexType>
  291. <xs:element name="USERS2_OFFERS" type="default_db__x3A__USERS2_OFFERS:USERS2_OFFERS"
  292. id="ERS2_OFFERS___d18e65465-1_USERS2_OFF"/>
  293. <xs:element name="ID_OFFERS_ON" type="default_db__x3A__USERS2_OFFERS:USERS2_OFFERS"
  294. id="ERS2_OFFERS___d18e65466-1_ID_OFFERS_">
  295. <!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
  296. <xs:annotation>
  297. <xs:documentation>Used in DEALS_TABLE</xs:documentation>
  298. </xs:annotation>
  299. </xs:element>
  300. <xs:element name="ID_OFFERS_OFF" type="default_db__x3A__USERS2_OFFERS:USERS2_OFFERS"
  301. id="ERS2_OFFERS___d18e65470-1_ID_OFFERS_">
  302. <!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
  303. <xs:annotation>
  304. <xs:documentation>Used in DEALS_TABLE</xs:documentation>
  305. </xs:annotation>
  306. </xs:element>
  307. <xs:element name="ID_NET" type="default_db__x3A__USERS2_OFFERS:USERS2_OFFERS"
  308. id="ERS2_OFFERS___d18e65474-1_ID_NET"/>
  309. <xs:complexType name="ID_TVCP" system_cache__appinfo:primaryKey="ID"
  310. id="ERS2_OFFERS___d18e65475-1_ID_TVCP">
  311. <xs:complexContent id="ERS2_OFFERS___d18e65476-1">
  312. <xs:restriction base="default_db__x3A__USERS2_OFFERS:USERS2_OFFERS">
  313. <xs:sequence id="ERS2_OFFERS___d18e65478-1">
  314. <xs:element name="ID" type="xs:integer" id="ERS2_OFFERS___d18e65479-1_ID"/>
  315. <!--<xs:element name="A_ID_USERS2" type="xs:integer" id="ERS2_OFFERS___d5e91117-1_A_ID_USERS"/>-->
  316. <xs:element name="A_RECORD_CREATE_DATE" type="xs:string"
  317. id="ERS2_OFFERS___d18e65481-1_A_RECORD_C"/>
  318. <xs:element name="A_RECORD_CREATE_AUTHOR" type="xs:string"
  319. id="ERS2_OFFERS___d18e65482-1_A_RECORD_C"/>
  320. <xs:element name="A_RECORD_UPDATE_DATE" type="xs:string"
  321. id="ERS2_OFFERS___d18e65483-1_A_RECORD_U"/>
  322. <xs:element name="A_RECORD_UPDATE_AUTHOR" type="xs:string"
  323. id="ERS2_OFFERS___d18e65484-1_A_RECORD_U"/>
  324. <xs:element name="TAB_UPDATE_STAT" type="xs:string"
  325. id="ERS2_OFFERS___d18e65485-1_TAB_UPDATE"/>
  326. <xs:element name="TAB_UPDATE_DATE" type="xs:token"
  327. id="ERS2_OFFERS___d18e65486-1_TAB_UPDATE"/>
  328. <xs:element name="TAB_UPDATE_INFO" type="xs:string"
  329. id="ERS2_OFFERS___d18e65487-1_TAB_UPDATE"/>
  330. <xs:element name="L_APPOITMENT_DATE" type="xs:string"
  331. id="ERS2_OFFERS___d18e65488-1_L_APPOITME"/>
  332. <xs:element name="L_APPOITMENT_USER" type="xs:string"
  333. id="ERS2_OFFERS___d18e65489-1_L_APPOITME"/>
  334. <xs:element ref="default_db__x3A__ADMIN_USERS:L_APPOITMENT_USER"
  335. id="ERS2_OFFERS___d18e65491-1">
  336. <!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
  337. <xs:annotation>
  338. <xs:appinfo>
  339. <system_cache__appinfo:flat_relation_cache>
  340. <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"/>
  341. </system_cache__appinfo:flat_relation_cache>
  342. </xs:appinfo>
  343. <xs:documentation>
  344. TODO CHECK IF THIS IS CORRECT FLAT RELATION! WAS GENERATED #180200
  345. </xs:documentation>
  346. </xs:annotation>
  347. </xs:element>
  348. <xs:element name="L_APPOITMENT_PERIOD" type="xs:string"
  349. id="ERS2_OFFERS___d18e65498-1_L_APPOITME"/>
  350. <xs:element name="L_APPOITMENT_INFO" type="xs:string"
  351. id="ERS2_OFFERS___d18e65499-1_L_APPOITME"/>
  352. <xs:element name="L_APPOITMENT_TYPE" type="xs:string"
  353. id="ERS2_OFFERS___d18e65500-1_L_APPOITME"/>
  354. <xs:element name="A_PROBLEM" type="xs:string"
  355. id="ERS2_OFFERS___d18e65501-1_A_PROBLEM"/>
  356. <xs:element name="A_PROBLEM_DESC" type="xs:string"
  357. id="ERS2_OFFERS___d18e65502-1_A_PROBLEM_"/>
  358. <xs:element name="A_PROBLEM_DATE" type="xs:string"
  359. id="ERS2_OFFERS___d18e65503-1_A_PROBLEM_"/>
  360. <xs:element name="A_STATUS" type="xs:string" id="ERS2_OFFERS___d18e65504-1_A_STATUS"/>
  361. <xs:element name="A_STATUS_CURRENT" type="xs:string"
  362. id="ERS2_OFFERS___d18e65505-1_A_STATUS_C"/>
  363. <xs:element name="A_STATUS_INFO" type="xs:string"
  364. id="ERS2_OFFERS___d18e65506-1_A_STATUS_I"/>
  365. <xs:element name="A_STATUS_LASTCHANGE_DATE" type="xs:string"
  366. id="ERS2_OFFERS___d18e65507-1_A_STATUS_L"/>
  367. <xs:element name="A_UPDATE_DATE" type="xs:string"
  368. id="ERS2_OFFERS___d18e65509-1_A_UPDATE_D"/>
  369. <xs:element name="A_ADM_COMPANY" type="xs:string"
  370. id="ERS2_OFFERS___d18e65510-1_A_ADM_COMP"/>
  371. <xs:element name="S_ALIAS" type="xs:string" id="ERS2_OFFERS___d18e65511-1_S_ALIAS"/>
  372. <xs:element name="S_ADDRESS_CITY" type="xs:string"
  373. id="ERS2_OFFERS___d18e65512-1_S_ADDRESS_"/>
  374. <xs:element name="S_ADDRESS_POST_CODE" type="xs:string"
  375. id="ERS2_OFFERS___d18e65513-1_S_ADDRESS_"/>
  376. <xs:element name="S_ADDRESS_POST_OFFICE" type="xs:string"
  377. id="ERS2_OFFERS___d18e65514-1_S_ADDRESS_"/>
  378. <xs:element name="S_ADDRESS_STREET" type="xs:string"
  379. id="ERS2_OFFERS___d18e65515-1_S_ADDRESS_"/>
  380. <xs:element name="S_ADDRESS_HOUSE" type="xs:string"
  381. id="ERS2_OFFERS___d18e65516-1_S_ADDRESS_"/>
  382. <xs:element name="S_OTHER_INFO" type="xs:string"
  383. id="ERS2_OFFERS___d18e65517-1_S_OTHER_IN"/>
  384. <xs:element name="S_VIP_LEVEL" type="xs:string"
  385. id="ERS2_OFFERS___d18e65518-1_S_VIP_LEVE"/>
  386. <xs:element name="S_VIP_DESC" type="xs:string"
  387. id="ERS2_OFFERS___d18e65519-1_S_VIP_DESC"/>
  388. <xs:element name="T_NETWORK_SERVER" type="xs:string"
  389. id="ERS2_OFFERS___d18e65521-1_T_NETWORK_"/>
  390. <xs:element name="T_TELBOX_ADDRESS" type="xs:string"
  391. id="ERS2_OFFERS___d18e65522-1_T_TELBOX_A"/>
  392. <xs:element name="T_WORKPOINTS" type="xs:string"
  393. id="ERS2_OFFERS___d18e65523-1_T_WORKPOIN"/>
  394. <xs:element name="T_WORKPOINTS_VALUE" type="xs:string"
  395. id="ERS2_OFFERS___d18e65524-1_T_WORKPOIN"/>
  396. <xs:element name="T_WORKPOINTS_TYPE" type="xs:string"
  397. id="ERS2_OFFERS___d18e65525-1_T_WORKPOIN"/>
  398. <xs:element name="T_WORKPOINTS_USER" type="xs:string"
  399. id="ERS2_OFFERS___d18e65526-1_T_WORKPOIN"/>
  400. <xs:element name="T_WORKPOINTS_DATE" type="xs:string"
  401. id="ERS2_OFFERS___d18e65527-1_T_WORKPOIN"/>
  402. <xs:element name="T_PENALTIES" type="xs:string"
  403. id="ERS2_OFFERS___d18e65528-1_T_PENALTIE"/>
  404. <xs:element name="T_PENALTIES_TYPE" type="xs:string"
  405. id="ERS2_OFFERS___d18e65529-1_T_PENALTIE"/>
  406. <xs:element name="T_PENALTIES_VALUE" type="xs:string"
  407. id="ERS2_OFFERS___d18e65530-1_T_PENALTIE"/>
  408. <xs:element name="P_NAME" type="xs:string" id="ERS2_OFFERS___d18e65531-1_P_NAME"/>
  409. <xs:element name="P_SERVICE" type="xs:string" fixed="TVCP"
  410. id="ERS2_OFFERS___d18e65533-1_P_SERVICE">
  411. <!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
  412. <xs:annotation>
  413. <xs:documentation>Takie zabezpiecznie na wyjatkowosc</xs:documentation>
  414. </xs:annotation>
  415. </xs:element>
  416. <xs:element name="P_SERVICE_PARENT" type="xs:string"
  417. id="ERS2_OFFERS___d18e65537-1_P_SERVICE_"/>
  418. <xs:element name="P_SERVICE_COMPANY" type="xs:string"
  419. id="ERS2_OFFERS___d18e65538-1_P_SERVICE_"/>
  420. <xs:element name="P_SERVICE_NAME" type="xs:string"
  421. id="ERS2_OFFERS___d18e65539-1_P_SERVICE_"/>
  422. <xs:element name="USERS2_OFFERS_GROUPS_ID" type="xs:integer"
  423. id="ERS2_OFFERS___d18e65540-1_USERS2_OFF"/>
  424. <xs:element ref="default_db__x3A__USERS2_OFFERS_GROUPS:USERS2_OFFERS_GROUPS"
  425. id="ERS2_OFFERS___d18e65541-1"/>
  426. <xs:element name="P_PROMOTION_NAME" type="xs:string"
  427. id="ERS2_OFFERS___d18e65542-1_P_PROMOTIO"/>
  428. <xs:element name="P_S_PARAM1" type="xs:string"
  429. id="ERS2_OFFERS___d18e65543-1_P_S_PARAM1"/>
  430. <xs:element name="P_S_PARAM2" type="xs:string"
  431. id="ERS2_OFFERS___d18e65544-1_P_S_PARAM2"/>
  432. <xs:element name="P_S_LIMIT" type="xs:string"
  433. id="ERS2_OFFERS___d18e65545-1_P_S_LIMIT"/>
  434. <xs:element name="P_S_LAN" type="xs:string" id="ERS2_OFFERS___d18e65546-1_P_S_LAN"/>
  435. <xs:element name="P_DEALTERM_MONTHS" type="xs:integer"
  436. id="ERS2_OFFERS___d18e65548-1_P_DEALTERM"/>
  437. <xs:element name="P_DEAL_PROMO_MONTHS" type="xs:integer"
  438. id="ERS2_OFFERS___d18e65549-1_P_DEAL_PRO"/>
  439. <xs:element name="STAWKA_VAT" type="xs:integer"
  440. id="ERS2_OFFERS___d18e65550-1_STAWKA_VAT"/>
  441. <xs:element name="P_INSTALL_QUOTE" type="xs:double"
  442. id="ERS2_OFFERS___d18e65551-1_P_INSTALL_"/>
  443. <xs:element name="P_INSTALL_QUOTE_NORMAL" type="xs:double"
  444. id="ERS2_OFFERS___d18e65552-1_P_INSTALL_"/>
  445. <xs:element name="P_CONTRACT_PRICE" type="xs:double"
  446. id="ERS2_OFFERS___d18e65553-1_P_CONTRACT"/>
  447. <xs:element name="P_CONTRACT_PRICE_NETTO" type="xs:double"
  448. id="ERS2_OFFERS___d18e65554-1_P_CONTRACT"/>
  449. <xs:element name="P_PROMO_MONTH_PRICE" type="xs:double"
  450. id="ERS2_OFFERS___d18e65555-1_P_PROMO_MO"/>
  451. <xs:element name="P_PROMO_MONTH_PRICE_NETTO" type="xs:double"
  452. id="ERS2_OFFERS___d18e65556-1_P_PROMO_MO"/>
  453. <xs:element name="P_NORMAL_PRICE" type="xs:double"
  454. id="ERS2_OFFERS___d18e65557-1_P_NORMAL_P"/>
  455. <xs:element name="P_NORMAL_PRICE_NETTO" type="xs:double"
  456. id="ERS2_OFFERS___d18e65558-1_P_NORMAL_P"/>
  457. <xs:element name="P_S_MAILBOX_SIZE" type="xs:string"
  458. id="ERS2_OFFERS___d18e65560-1_P_S_MAILBO"/>
  459. <xs:element name="P_S_WWW_SIZE" type="xs:string"
  460. id="ERS2_OFFERS___d18e65561-1_P_S_WWW_SI"/>
  461. <xs:element name="P_OFFER_TERM_BEGIN" type="xs:token"
  462. id="ERS2_OFFERS___d18e65562-1_P_OFFER_TE"/>
  463. <xs:element name="P_OFFER_TERM" type="xs:token"
  464. id="ERS2_OFFERS___d18e65563-1_P_OFFER_TE"/>
  465. <xs:element name="T_TELBOX_BUILDING_IN" type="xs:string"
  466. id="ERS2_OFFERS___d18e65564-1_T_TELBOX_B"/>
  467. <xs:element ref="default_db__x3A__BUILDINGS:T_TELBOX_BUILDING_IN"
  468. id="ERS2_OFFERS___d18e65565-1"/>
  469. <xs:element name="BAD_DATE" type="xs:token" id="ERS2_OFFERS___d18e65566-1_BAD_DATE"/>
  470. <xs:element name="BAD_ZAINT" type="xs:string"
  471. id="ERS2_OFFERS___d18e65567-1_BAD_ZAINT"/>
  472. <xs:element name="M_REWIR" type="xs:string" id="ERS2_OFFERS___d18e65568-1_M_REWIR"/>
  473. <xs:element ref="default_db__x3A__MK_Rewiry:MK_Rewiry" id="ERS2_OFFERS___d18e65569-1"/>
  474. <xs:element name="ID_COSTS_GROUPS" type="xs:integer"
  475. id="ERS2_OFFERS___d18e65570-1_ID_COSTS_G"/>
  476. <xs:element
  477. ref="default_db__x3A__USERS2_OFFERS_COSTS_GROUPS:USERS2_OFFERS_COSTS_GROUPS"
  478. id="ERS2_OFFERS___d18e65572-1"/>
  479. <xs:element name="S_DEKODER_SD_OPTION" type="xs:string"
  480. id="ERS2_OFFERS___d18e65573-1_S_DEKODER_"/>
  481. <xs:element name="S_MODUL_PCMCIA_OPTION" type="xs:string"
  482. id="ERS2_OFFERS___d18e65574-1_S_MODUL_PC"/>
  483. <xs:element name="S_DEKODER_HD_OPTION" type="xs:string"
  484. id="ERS2_OFFERS___d18e65575-1_S_DEKODER_"/>
  485. <xs:element name="ID_PRODUKT" type="xs:integer"
  486. id="ERS2_OFFERS___d18e65576-1_ID_PRODUKT"/>
  487. <xs:element name="P_ACCOUNT" type="xs:string"
  488. id="ERS2_OFFERS___d18e65577-1_P_ACCOUNT"/>
  489. <xs:element name="P_SERVICE_QUOTA_PROFILE" type="xs:string"
  490. id="ERS2_OFFERS___d18e65578-1_P_SERVICE_"/>
  491. <xs:element name="LAN_DOWNLOAD" type="xs:string"
  492. id="ERS2_OFFERS___d18e65579-1_LAN_DOWNLO"/>
  493. <xs:element name="S_PUBLIC_IP" type="xs:string"
  494. id="ERS2_OFFERS___d18e65580-1_S_PUBLIC_I"/>
  495. <xs:element name="S_SOHO_WIFI_ROUTER_1292" type="xs:string"
  496. id="ERS2_OFFERS___d18e65581-1_S_SOHO_WIF"/>
  497. <xs:element name="S_E_PORT_1293" type="xs:string"
  498. id="ERS2_OFFERS___d18e65582-1_S_E_PORT_1"/>
  499. <xs:element name="P_DEVICE" type="xs:string" id="ERS2_OFFERS___d18e65584-1_P_DEVICE"/>
  500. <xs:element name="P_SERVICE_CLASS" type="xs:string"
  501. id="ERS2_OFFERS___d18e65585-1_P_SERVICE_"/>
  502. <xs:element name="P_SERVICE_SOCKETS_AMMOUNT_1298" type="xs:string"
  503. id="ERS2_OFFERS___d18e65586-1_P_SERVICE_"/>
  504. <xs:element name="ID_DOMAINS_PACKET_ID" type="xs:string"
  505. id="ERS2_OFFERS___d18e65587-1_ID_DOMAINS"/>
  506. <xs:element name="VOIP_FAX2EMAIL" type="xs:string"
  507. id="ERS2_OFFERS___d18e65588-1_VOIP_FAX2E"/>
  508. <xs:element name="ID_DOMAINS" type="xs:string"
  509. id="ERS2_OFFERS___d18e65589-1_ID_DOMAINS"/>
  510. <xs:element name="CONN_DIV" type="xs:string" id="ERS2_OFFERS___d18e65590-1_CONN_DIV"/>
  511. <xs:element name="P_SERVICE_QUOTA" type="xs:integer"
  512. id="ERS2_OFFERS___d18e65591-1_P_SERVICE_"/>
  513. <xs:element name="ID_PROCES" type="xs:integer"
  514. id="ERS2_OFFERS___d18e65592-1_ID_PROCES"/>
  515. <xs:element name="S_TECHNOLOGY" type="xs:string"
  516. id="ERS2_OFFERS___d18e65593-1_S_TECHNOLO"/>
  517. <xs:element name="A_CLASSIFIED" type="xs:string"
  518. id="ERS2_OFFERS___d18e65594-1_A_CLASSIFI"/>
  519. <xs:element name="P_MULTIROOM_ADD_CARDS" type="xs:integer"
  520. id="ERS2_OFFERS___d18e65596-1_P_MULTIROO"/>
  521. <xs:element name="P_MULTIROOM_ADD_DEKODER_SD" type="xs:integer"
  522. id="ERS2_OFFERS___d18e65597-1_P_MULTIROO"/>
  523. <xs:element name="P_MULTIROOM_ADD_DEKODER_HD" type="xs:integer"
  524. id="ERS2_OFFERS___d18e65598-1_P_MULTIROO"/>
  525. <xs:element name="P_MULTIROOM_ADD_MODUL_CAM" type="xs:integer"
  526. id="ERS2_OFFERS___d18e65599-1_P_MULTIROO"/>
  527. <xs:element name="P_SERVICE_UPLOAD_RATIO" type="xs:string"
  528. id="ERS2_OFFERS___d18e65600-1_P_SERVICE_"/>
  529. <xs:element name="ID_OFFER_NEW_SUGGESTED" type="xs:integer"
  530. id="ERS2_OFFERS___d18e65601-1_ID_OFFER_N"/>
  531. <xs:element name="STAT_SOLD_LAST_MONTH_QTY" type="xs:integer"
  532. id="ERS2_OFFERS___d18e65602-1_STAT_SOLD_"/>
  533. <xs:element name="STAT_USED_IN_OFFERS_GROUP_COUNT" type="xs:integer"
  534. id="ERS2_OFFERS___d18e65603-1_STAT_USED_"/>
  535. <xs:element name="PARENT_ID" type="xs:integer"
  536. id="ERS2_OFFERS___d18e65604-1_PARENT_ID"/>
  537. <xs:element name="CRM_LISTA_ZASOBOW_ID" type="xs:integer"
  538. id="ERS2_OFFERS___d18e65605-1_CRM_LISTA_"/>
  539. <xs:element ref="default_db__x3A__CRM_LISTA_ZASOBOW:CRM_LISTA_ZASOBOW_ID"
  540. id="ERS2_OFFERS___d18e65606-1">
  541. <!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
  542. <xs:annotation>
  543. <xs:appinfo>
  544. <system_cache__appinfo:flat_relation_cache>
  545. <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"/>
  546. </system_cache__appinfo:flat_relation_cache>
  547. </xs:appinfo>
  548. <xs:documentation>
  549. TODO CHECK IF THIS IS CORRECT FLAT RELATION! WAS GENERATED
  550. </xs:documentation>
  551. </xs:annotation>
  552. </xs:element>
  553. </xs:sequence>
  554. </xs:restriction>
  555. </xs:complexContent>
  556. </xs:complexType>
  557. <xs:element name="ID_TVCP" type="default_db__x3A__USERS2_OFFERS:ID_TVCP"
  558. id="ERS2_OFFERS___d18e65615-1_ID_TVCP"/>
  559. <xs:element name="ID_TVCP_1" type="default_db__x3A__USERS2_OFFERS:USERS2_OFFERS"
  560. id="ERS2_OFFERS___d18e65616-1_ID_TVCP_1"/>
  561. <xs:element name="ID_TVCP_2" type="default_db__x3A__USERS2_OFFERS:USERS2_OFFERS"
  562. id="ERS2_OFFERS___d18e65617-1_ID_TVCP_2"/>
  563. <xs:element name="ID_TVC" type="default_db__x3A__USERS2_OFFERS:USERS2_OFFERS"
  564. id="ERS2_OFFERS___d18e65619-1_ID_TVC"/>
  565. <xs:element name="ID_TV" type="default_db__x3A__USERS2_OFFERS:USERS2_OFFERS"
  566. id="ERS2_OFFERS___d18e65620-1_ID_TV"/>
  567. <xs:element name="ID_TEL" type="default_db__x3A__USERS2_OFFERS:USERS2_OFFERS"
  568. id="ERS2_OFFERS___d18e65621-1_ID_TEL"/>
  569. <xs:element name="ID_TVCP_4" type="default_db__x3A__USERS2_OFFERS:USERS2_OFFERS"
  570. id="ERS2_OFFERS___d18e65622-1_ID_TVCP_4"/>
  571. <xs:element name="ID_TVCP_3" type="default_db__x3A__USERS2_OFFERS:USERS2_OFFERS"
  572. id="ERS2_OFFERS___d18e65623-1_ID_TVCP_3"/>
  573. </xs:schema>