USERS2_MARKETING.xsd 176 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621162216231624162516261627162816291630163116321633163416351636163716381639164016411642164316441645164616471648164916501651165216531654165516561657165816591660166116621663166416651666166716681669167016711672167316741675167616771678167916801681168216831684168516861687168816891690169116921693169416951696169716981699170017011702170317041705170617071708170917101711171217131714171517161717171817191720172117221723172417251726172717281729173017311732173317341735173617371738173917401741174217431744174517461747174817491750175117521753175417551756175717581759176017611762176317641765176617671768176917701771177217731774177517761777177817791780178117821783178417851786178717881789179017911792179317941795179617971798179918001801180218031804180518061807180818091810181118121813181418151816181718181819182018211822182318241825182618271828182918301831183218331834183518361837183818391840184118421843184418451846184718481849185018511852185318541855185618571858185918601861186218631864186518661867186818691870187118721873187418751876187718781879188018811882188318841885188618871888188918901891189218931894189518961897189818991900190119021903190419051906190719081909191019111912191319141915191619171918191919201921192219231924192519261927192819291930193119321933193419351936193719381939194019411942194319441945194619471948194919501951195219531954195519561957195819591960196119621963196419651966196719681969197019711972197319741975197619771978197919801981198219831984198519861987198819891990199119921993199419951996199719981999200020012002200320042005200620072008200920102011201220132014201520162017201820192020202120222023202420252026202720282029203020312032203320342035203620372038203920402041204220432044204520462047204820492050205120522053205420552056205720582059206020612062206320642065206620672068206920702071207220732074207520762077207820792080208120822083208420852086208720882089209020912092209320942095209620972098209921002101210221032104210521062107210821092110211121122113211421152116211721182119212021212122212321242125212621272128212921302131213221332134213521362137213821392140214121422143214421452146214721482149215021512152215321542155215621572158215921602161216221632164216521662167216821692170217121722173217421752176217721782179218021812182218321842185218621872188218921902191219221932194219521962197219821992200220122022203220422052206220722082209221022112212221322142215221622172218221922202221222222232224222522262227222822292230223122322233223422352236223722382239224022412242224322442245224622472248224922502251225222532254225522562257225822592260226122622263226422652266226722682269227022712272227322742275227622772278227922802281228222832284228522862287228822892290229122922293229422952296229722982299230023012302230323042305230623072308230923102311231223132314231523162317231823192320232123222323232423252326232723282329233023312332233323342335233623372338233923402341234223432344234523462347234823492350235123522353235423552356235723582359236023612362236323642365236623672368236923702371237223732374237523762377237823792380238123822383238423852386238723882389239023912392239323942395239623972398239924002401240224032404240524062407240824092410241124122413241424152416241724182419242024212422242324242425242624272428242924302431243224332434243524362437243824392440244124422443244424452446244724482449245024512452245324542455245624572458245924602461246224632464246524662467246824692470247124722473247424752476247724782479248024812482248324842485248624872488248924902491249224932494249524962497249824992500250125022503250425052506250725082509251025112512251325142515251625172518251925202521252225232524252525262527252825292530253125322533253425352536253725382539254025412542254325442545254625472548254925502551255225532554255525562557255825592560256125622563256425652566256725682569257025712572257325742575257625772578257925802581258225832584258525862587258825892590259125922593259425952596259725982599260026012602260326042605260626072608260926102611261226132614261526162617261826192620262126222623262426252626262726282629263026312632263326342635263626372638263926402641264226432644264526462647264826492650265126522653265426552656265726582659266026612662266326642665266626672668266926702671267226732674267526762677267826792680268126822683268426852686268726882689269026912692269326942695269626972698269927002701270227032704270527062707270827092710271127122713271427152716271727182719272027212722272327242725272627272728272927302731273227332734273527362737273827392740274127422743274427452746274727482749275027512752275327542755275627572758275927602761276227632764276527662767276827692770277127722773277427752776277727782779278027812782278327842785278627872788278927902791279227932794279527962797279827992800280128022803280428052806280728082809281028112812281328142815281628172818281928202821282228232824282528262827282828292830283128322833283428352836283728382839284028412842284328442845284628472848284928502851285228532854285528562857285828592860286128622863286428652866286728682869287028712872287328742875287628772878287928802881288228832884288528862887288828892890289128922893289428952896289728982899290029012902290329042905290629072908290929102911291229132914291529162917291829192920292129222923292429252926292729282929293029312932293329342935293629372938293929402941294229432944294529462947294829492950295129522953295429552956295729582959296029612962296329642965296629672968296929702971297229732974297529762977297829792980298129822983298429852986298729882989299029912992299329942995299629972998299930003001300230033004300530063007300830093010301130123013301430153016301730183019302030213022302330243025302630273028302930303031303230333034303530363037303830393040304130423043304430453046304730483049305030513052305330543055305630573058305930603061306230633064306530663067306830693070307130723073307430753076307730783079308030813082
  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__USERS2_MARKETING="https://biuro.biall-net.pl/wfs/default_db/table/USERS2_MARKETING.xsd"
  12. xmlns:date="http://exslt.org/dates-and-times"
  13. xmlns:default_db__x3A__MK_Rewiry="https://biuro.biall-net.pl/wfs/default_db/table/MK_Rewiry.xsd"
  14. xmlns:default_db__x3A__CRM_LISTA_ZASOBOW="https://biuro.biall-net.pl/wfs/default_db/table/CRM_LISTA_ZASOBOW.xsd"
  15. xmlns:default_db__x3A__BUILDINGS="https://biuro.biall-net.pl/wfs/default_db/table/BUILDINGS.xsd"
  16. xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  17. xmlns:p5_tr_map="http://biuro.biall-net.pl/xmlschema_procesy5/default_db_xml_cache/procesy5_translate_map.xsd"
  18. xmlns:vc="http://www.w3.org/2007/XMLSchema-versioning"
  19. 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"
  20. xmlns:system_cache__appinfo="http://biuro.biall-net.pl/xmlschema_procesy5/default_db_xml_cache/appinfo.xsd"
  21. xmlns:p5opr="http://biuro.biall-net.pl/xmlschema_procesy5/system_cache/object_parent_relations/object_parent_relations.xsd"
  22. xmlns:p5_simpleSchema_map="http://biuro.biall-net.pl/xmlschema_procesy5/default_db_xml_cache/p5_simpleSchema_map.xsd"
  23. targetNamespace="https://biuro.biall-net.pl/wfs/default_db/table/USERS2_MARKETING.xsd"
  24. vc:minVersion="1.1"><!--#334 $prototype_object_namespace = -->
  25. <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/table/ADMIN_USERS.xsd"
  26. schemaLocation="ADMIN_USERS.xsd"/>
  27. <!--#334 $prototype_object_namespace = -->
  28. <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/table/MK_Rewiry.xsd"
  29. schemaLocation="MK_Rewiry.xsd"/>
  30. <!--#334 $prototype_object_namespace = -->
  31. <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/table/IN7_MK_BAZA_DYSTRYBUCJI.xsd"
  32. schemaLocation="IN7_MK_BAZA_DYSTRYBUCJI.xsd"/>
  33. <!--#334 $prototype_object_namespace = -->
  34. <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/table/CRM_LISTA_ZASOBOW.xsd"
  35. schemaLocation="CRM_LISTA_ZASOBOW.xsd"/>
  36. <!--#334 $prototype_object_namespace = -->
  37. <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/table/BUILDINGS.xsd"
  38. schemaLocation="BUILDINGS.xsd"/>
  39. <!--#336 import upper-->
  40. <xs:import namespace="http://www.opengis.net/gml/3.2"
  41. schemaLocation="../Types/gml.xsd"/>
  42. <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/table/IN7_DZIENNIK_KORESP.xsd"
  43. schemaLocation="../table/IN7_DZIENNIK_KORESP.xsd"/>
  44. <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/table/IN7_MK_BAZA_DYSTRYBUCJI.xsd"
  45. schemaLocation="../table/IN7_MK_BAZA_DYSTRYBUCJI.xsd"/>
  46. <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/SystemObjects/AccessGroup.xsd"
  47. schemaLocation="../SystemObjects/AccessGroup.xsd"/>
  48. <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/SystemObjects/AccessOwner.xsd"
  49. schemaLocation="../SystemObjects/AccessOwner.xsd"/>
  50. <xs:simpleType name="A_STATUS_Type" id="_2_MARKETING___d15e199475-1_A_STATUS_T">
  51. <xs:restriction base="xs:string">
  52. <xs:enumeration value="NORMAL"/>
  53. <xs:enumeration value="WAITING"/>
  54. <xs:enumeration value="MONITOR"/>
  55. <xs:enumeration value="DELETED"/>
  56. <xs:enumeration value="WARNING"/>
  57. <xs:enumeration value="OFF_SOFT"/>
  58. <xs:enumeration value="OFF_HARD"/>
  59. </xs:restriction>
  60. </xs:simpleType>
  61. <xs:simpleType name="I_OPER" id="_2_MARKETING___d15e199484-1_I_OPER">
  62. <xs:restriction base="xs:string"/>
  63. </xs:simpleType>
  64. <xs:simpleType name="I_OPER_BN" id="_2_MARKETING___d15e199486-1_I_OPER_BN">
  65. <xs:restriction base="default_db__x3A__USERS2_MARKETING:I_OPER">
  66. <xs:enumeration value="BN"/>
  67. <xs:enumeration value="ND"/>
  68. </xs:restriction>
  69. </xs:simpleType>
  70. <xs:simpleType name="I_OPER_OBCY" id="_2_MARKETING___d15e199490-1_I_OPER_OBC">
  71. <xs:restriction base="default_db__x3A__USERS2_MARKETING:I_OPER"/>
  72. </xs:simpleType>
  73. <xs:simpleType name="I_BAD_DATE" id="_2_MARKETING___d15e199492-1_I_BAD_DATE">
  74. <xs:restriction base="xs:date"/>
  75. </xs:simpleType>
  76. <xs:simpleType name="I_BAD_DATE_FRESH" id="_2_MARKETING___d15e199494-1_I_BAD_DATE">
  77. <xs:restriction base="default_db__x3A__USERS2_MARKETING:I_BAD_DATE"/>
  78. </xs:simpleType>
  79. <xs:simpleType name="I_BAD_DATE_OLD" id="_2_MARKETING___d15e199497-1_I_BAD_DATE">
  80. <xs:restriction base="default_db__x3A__USERS2_MARKETING:I_BAD_DATE"/>
  81. </xs:simpleType>
  82. <xs:complexType name="USERS2_MARKETING" id="_2_MARKETING___d15e199499-1_USERS2_MAR">
  83. <xs:sequence id="_2_MARKETING___d15e199500-1">
  84. <xs:element name="the_geom"
  85. type="gml:AbstractFeatureType"
  86. id="_2_MARKETING___d15e199501-1_the_geom">
  87. <xs:annotation>
  88. <xs:documentation>Dane geograficzne obiektu - linia, punkt, polygon</xs:documentation>
  89. </xs:annotation>
  90. </xs:element>
  91. <xs:element name="A_STATUS"
  92. type="default_db__x3A__USERS2_MARKETING:A_STATUS_Type"
  93. id="_2_MARKETING___d15e199505-1_A_STATUS"/>
  94. <xs:element name="A_STATUS_INFO"
  95. type="xs:string"
  96. id="_2_MARKETING___d15e199506-1_A_STATUS_I"/>
  97. <xs:element name="L_APPOITMENT_USER"
  98. type="xs:string"
  99. id="_2_MARKETING___d15e199507-1_L_APPOITME"/>
  100. <xs:element name="A_CLASSIFIED"
  101. type="xs:string"
  102. id="_2_MARKETING___d15e199508-1_A_CLASSIFI"/>
  103. <xs:element name="A_ADM_COMPANY"
  104. type="xs:string"
  105. id="_2_MARKETING___d15e199509-1_A_ADM_COMP"/>
  106. <xs:element name="ID" type="xs:integer" id="_2_MARKETING___d15e199510-1_ID"/>
  107. <xs:element name="ADMIN_USERS_ID"
  108. type="xs:integer"
  109. id="_2_MARKETING___d15e199511-1_ADMIN_USER"/>
  110. <xs:element name="A_ID_USERS2"
  111. type="xs:integer"
  112. id="_2_MARKETING___d15e199512-1_A_ID_USERS"/>
  113. <xs:element name="ID_BILLING_USERS"
  114. type="xs:integer"
  115. id="_2_MARKETING___d15e199513-1_ID_BILLING"/>
  116. <xs:element name="ID_SERVICES"
  117. type="xs:integer"
  118. id="_2_MARKETING___d15e199514-1_ID_SERVICE"/>
  119. <xs:element name="A_RECORD_CREATE_DATE"
  120. type="xs:token"
  121. id="_2_MARKETING___d15e199516-1_A_RECORD_C"/>
  122. <xs:element name="A_RECORD_CREATE_AUTHOR"
  123. type="xs:string"
  124. id="_2_MARKETING___d15e199517-1_A_RECORD_C"/>
  125. <xs:element name="A_RECORD_UPDATE_DATE"
  126. type="xs:token"
  127. id="_2_MARKETING___d15e199518-1_A_RECORD_U"/>
  128. <xs:element name="A_RECORD_UPDATE_AUTHOR"
  129. type="xs:string"
  130. id="_2_MARKETING___d15e199519-1_A_RECORD_U"/>
  131. <xs:element name="TAB_UPDATE_STAT"
  132. type="xs:string"
  133. id="_2_MARKETING___d15e199520-1_TAB_UPDATE"/>
  134. <xs:element name="TAB_UPDATE_DATE"
  135. type="xs:token"
  136. id="_2_MARKETING___d15e199521-1_TAB_UPDATE"/>
  137. <xs:element name="TAB_UPDATE_INFO"
  138. type="xs:string"
  139. id="_2_MARKETING___d15e199522-1_TAB_UPDATE"/>
  140. <xs:element name="L_APPOITMENT_DATE"
  141. type="xs:token"
  142. id="_2_MARKETING___d15e199523-1_L_APPOITME"/>
  143. <xs:element name="L_APPOITMENT_PERIOD"
  144. type="xs:string"
  145. id="_2_MARKETING___d15e199524-1_L_APPOITME"/>
  146. <xs:element name="L_APPOITMENT_INFO"
  147. type="xs:string"
  148. id="_2_MARKETING___d15e199525-1_L_APPOITME"/>
  149. <xs:element name="L_APPOITMENT_TYPE"
  150. type="xs:string"
  151. id="_2_MARKETING___d15e199526-1_L_APPOITME"/>
  152. <xs:element name="A_PROBLEM"
  153. type="xs:string"
  154. id="_2_MARKETING___d15e199528-1_A_PROBLEM"/>
  155. <xs:element name="A_PROBLEM_DESC"
  156. type="xs:string"
  157. id="_2_MARKETING___d15e199529-1_A_PROBLEM_"/>
  158. <xs:element name="A_PROBLEM_DATE"
  159. type="xs:token"
  160. id="_2_MARKETING___d15e199530-1_A_PROBLEM_"/>
  161. <xs:element name="A_STATUS_CURRENT"
  162. type="xs:string"
  163. id="_2_MARKETING___d15e199531-1_A_STATUS_C"/>
  164. <xs:element name="A_STATUS_LASTCHANGE_DATE"
  165. type="xs:token"
  166. id="_2_MARKETING___d15e199532-1_A_STATUS_L"/>
  167. <xs:element name="S_ALIAS"
  168. type="xs:string"
  169. id="_2_MARKETING___d15e199533-1_S_ALIAS"/>
  170. <xs:element name="S_ADDRESS_CITY"
  171. type="xs:string"
  172. id="_2_MARKETING___d15e199534-1_S_ADDRESS_"/>
  173. <xs:element name="S_ADDRESS_POST_CODE"
  174. type="xs:string"
  175. id="_2_MARKETING___d15e199535-1_S_ADDRESS_"/>
  176. <xs:element name="S_ADDRESS_POST_OFFICE"
  177. type="xs:string"
  178. id="_2_MARKETING___d15e199536-1_S_ADDRESS_"/>
  179. <xs:element name="S_ADDRESS_STREET"
  180. type="xs:string"
  181. id="_2_MARKETING___d15e199537-1_S_ADDRESS_"/>
  182. <xs:element name="S_ADDRESS_HOUSE"
  183. type="xs:string"
  184. id="_2_MARKETING___d15e199538-1_S_ADDRESS_"/>
  185. <xs:element name="S_OTHER_INFO"
  186. type="xs:string"
  187. id="_2_MARKETING___d15e199540-1_S_OTHER_IN"/>
  188. <xs:element name="S_VIP_LEVEL"
  189. type="xs:string"
  190. id="_2_MARKETING___d15e199541-1_S_VIP_LEVE"/>
  191. <xs:element name="S_VIP_DESC"
  192. type="xs:string"
  193. id="_2_MARKETING___d15e199542-1_S_VIP_DESC"/>
  194. <xs:element name="T_NETWORK_SERVER"
  195. type="xs:string"
  196. id="_2_MARKETING___d15e199543-1_T_NETWORK_"/>
  197. <xs:element name="T_TELBOX_ADDRESS"
  198. type="xs:string"
  199. id="_2_MARKETING___d15e199544-1_T_TELBOX_A"/>
  200. <xs:element name="T_TELBOX_PORT"
  201. type="xs:string"
  202. id="_2_MARKETING___d15e199545-1_T_TELBOX_P"/>
  203. <xs:element name="T_WORKPOINTS"
  204. type="xs:string"
  205. id="_2_MARKETING___d15e199546-1_T_WORKPOIN"/>
  206. <xs:element name="T_WORKPOINTS_PROCES"
  207. type="xs:integer"
  208. id="_2_MARKETING___d15e199547-1_T_WORKPOIN"/>
  209. <xs:element name="T_WORKPOINTS_VALUE"
  210. type="xs:string"
  211. id="_2_MARKETING___d15e199548-1_T_WORKPOIN"/>
  212. <xs:element name="T_WORKPOINTS_TYPE"
  213. type="xs:string"
  214. id="_2_MARKETING___d15e199549-1_T_WORKPOIN"/>
  215. <xs:element name="T_WORKPOINTS_USER"
  216. type="xs:string"
  217. id="_2_MARKETING___d15e199550-1_T_WORKPOIN"/>
  218. <xs:element name="T_WORKPOINTS_DATE"
  219. type="xs:token"
  220. id="_2_MARKETING___d15e199552-1_T_WORKPOIN"/>
  221. <xs:element name="T_PENALTIES"
  222. type="xs:string"
  223. id="_2_MARKETING___d15e199553-1_T_PENALTIE"/>
  224. <xs:element name="T_PENALTIES_TYPE"
  225. type="xs:string"
  226. id="_2_MARKETING___d15e199554-1_T_PENALTIE"/>
  227. <xs:element name="T_PENALTIES_VALUE"
  228. type="xs:string"
  229. id="_2_MARKETING___d15e199555-1_T_PENALTIE"/>
  230. <xs:element name="P_BILLING_NO"
  231. type="xs:integer"
  232. id="_2_MARKETING___d15e199556-1_P_BILLING_"/>
  233. <xs:element name="P_NAME"
  234. type="xs:string"
  235. id="_2_MARKETING___d15e199557-1_P_NAME"/>
  236. <xs:element name="P_NIP"
  237. type="xs:string"
  238. id="_2_MARKETING___d15e199558-1_P_NIP"/>
  239. <xs:element name="P_PESEL"
  240. type="xs:string"
  241. id="_2_MARKETING___d15e199559-1_P_PESEL"/>
  242. <xs:element name="P_OTHER_DOC"
  243. type="xs:string"
  244. id="_2_MARKETING___d15e199560-1_P_OTHER_DO"/>
  245. <xs:element name="P_PHONE"
  246. type="xs:string"
  247. id="_2_MARKETING___d15e199561-1_P_PHONE"/>
  248. <xs:element name="P_FAX"
  249. type="xs:string"
  250. id="_2_MARKETING___d15e199562-1_P_FAX"/>
  251. <xs:element name="P_CONTACT_PERSON"
  252. type="xs:string"
  253. id="_2_MARKETING___d15e199564-1_P_CONTACT_"/>
  254. <xs:element name="P_ADDRESS_CITY"
  255. type="xs:string"
  256. id="_2_MARKETING___d15e199565-1_P_ADDRESS_"/>
  257. <xs:element name="P_ADDRESS_POST_CODE"
  258. type="xs:string"
  259. id="_2_MARKETING___d15e199566-1_P_ADDRESS_"/>
  260. <xs:element name="P_ADDRESS_POST_OFFICE"
  261. type="xs:string"
  262. id="_2_MARKETING___d15e199567-1_P_ADDRESS_"/>
  263. <xs:element name="P_ADDRESS_STREET"
  264. type="xs:string"
  265. id="_2_MARKETING___d15e199568-1_P_ADDRESS_"/>
  266. <xs:element name="P_ADDRESS_HOUSE"
  267. type="xs:string"
  268. id="_2_MARKETING___d15e199569-1_P_ADDRESS_"/>
  269. <xs:element name="P_OTHER_INFO"
  270. type="xs:string"
  271. id="_2_MARKETING___d15e199570-1_P_OTHER_IN"/>
  272. <xs:element name="T_TELBOX_BUILDING_IN"
  273. type="xs:string"
  274. id="_2_MARKETING___d15e199571-1_T_TELBOX_B"/>
  275. <xs:element name="I_BAD_DATE"
  276. type="default_db__x3A__USERS2_MARKETING:I_BAD_DATE"
  277. id="_2_MARKETING___d15e199572-1_I_BAD_DATE"/>
  278. <xs:element name="I_OPER"
  279. type="default_db__x3A__USERS2_MARKETING:I_OPER"
  280. id="_2_MARKETING___d15e199573-1_I_OPER"/>
  281. <xs:element name="I_PAY"
  282. type="xs:double"
  283. id="_2_MARKETING___d15e199574-1_I_PAY"/>
  284. <xs:element name="I_OPER_ZAD"
  285. type="xs:string"
  286. id="_2_MARKETING___d15e199576-1_I_OPER_ZAD"/>
  287. <xs:element name="I_OPER_FIN"
  288. type="xs:token"
  289. id="_2_MARKETING___d15e199577-1_I_OPER_FIN"/>
  290. <xs:element name="I_OPER_ZAINT"
  291. type="xs:string"
  292. id="_2_MARKETING___d15e199578-1_I_OPER_ZAI"/>
  293. <xs:element name="T_BAD_DATE"
  294. type="xs:token"
  295. id="_2_MARKETING___d15e199579-1_T_BAD_DATE"/>
  296. <xs:element name="T_OPER"
  297. type="xs:string"
  298. id="_2_MARKETING___d15e199580-1_T_OPER"/>
  299. <xs:element name="T_PAY"
  300. type="xs:double"
  301. id="_2_MARKETING___d15e199581-1_T_PAY"/>
  302. <xs:element name="T_OPER_ZAD"
  303. type="xs:string"
  304. id="_2_MARKETING___d15e199582-1_T_OPER_ZAD"/>
  305. <xs:element name="T_OPER_FIN"
  306. type="xs:token"
  307. id="_2_MARKETING___d15e199583-1_T_OPER_FIN"/>
  308. <xs:element name="T_OPER_ZAINT"
  309. type="xs:string"
  310. id="_2_MARKETING___d15e199584-1_T_OPER_ZAI"/>
  311. <xs:element name="TV_BAD_DATE"
  312. type="xs:token"
  313. id="_2_MARKETING___d15e199585-1_TV_BAD_DAT"/>
  314. <xs:element name="TV_OPER"
  315. type="xs:string"
  316. id="_2_MARKETING___d15e199586-1_TV_OPER"/>
  317. <xs:element name="TV_PAY"
  318. type="xs:double"
  319. id="_2_MARKETING___d15e199588-1_TV_PAY"/>
  320. <xs:element name="TV_OPER_ZAD"
  321. type="xs:string"
  322. id="_2_MARKETING___d15e199589-1_TV_OPER_ZA"/>
  323. <xs:element name="TV_OPER_FIN"
  324. type="xs:token"
  325. id="_2_MARKETING___d15e199590-1_TV_OPER_FI"/>
  326. <xs:element name="TV_OPER_ZAINT"
  327. type="xs:string"
  328. id="_2_MARKETING___d15e199591-1_TV_OPER_ZA"/>
  329. <xs:element name="BIZ_BAD_DATE"
  330. type="xs:token"
  331. id="_2_MARKETING___d15e199592-1_BIZ_BAD_DA"/>
  332. <xs:element name="BIZ_VOIP_ZAINT"
  333. type="xs:string"
  334. id="_2_MARKETING___d15e199593-1_BIZ_VOIP_Z"/>
  335. <xs:element name="BIZ_PROCESY5_ZAINT"
  336. type="xs:string"
  337. id="_2_MARKETING___d15e199594-1_BIZ_PROCES"/>
  338. <xs:element name="BIZ_SUPPORT_ZAINT"
  339. type="xs:string"
  340. id="_2_MARKETING___d15e199595-1_BIZ_SUPPOR"/>
  341. <xs:element name="M_REWIR"
  342. type="xs:string"
  343. id="_2_MARKETING___d15e199596-1_M_REWIR"/>
  344. <xs:element name="__MK_Rewiry__STATUS"
  345. type="xs:string"
  346. id="_2_MARKETING___d15e199597-1___MK_Rewir"/>
  347. <xs:element name="BOK_ZAD"
  348. type="xs:string"
  349. id="_2_MARKETING___d15e199598-1_BOK_ZAD"/>
  350. <xs:element name="BOK_BAD_DATE"
  351. type="xs:token"
  352. id="_2_MARKETING___d15e199600-1_BOK_BAD_DA"/>
  353. <xs:element name="P_FLOOR_CONTROL"
  354. type="xs:string"
  355. id="_2_MARKETING___d15e199601-1_P_FLOOR_CO"/>
  356. <xs:element name="P_ACCOUNT"
  357. type="xs:string"
  358. id="_2_MARKETING___d15e199602-1_P_ACCOUNT"/>
  359. <xs:element name="S_KLATKA"
  360. type="xs:string"
  361. id="_2_MARKETING___d15e199603-1_S_KLATKA"/>
  362. <xs:element name="BAD_WYS_JAKOSC_OR_NISKA_CENA"
  363. type="xs:string"
  364. id="_2_MARKETING___d15e199604-1_BAD_WYS_JA"/>
  365. <xs:element name="BAD_KROTKA_UMOWA_OR_DLUGI_KONTRAKT_UPUST"
  366. type="xs:string"
  367. id="_2_MARKETING___d15e199605-1_BAD_KROTKA"/>
  368. <xs:element name="BAD_KONTAKT_CALL_CENTER_EBOK_OR_LOKALNY_BOK"
  369. type="xs:string"
  370. id="_2_MARKETING___d15e199606-1_BAD_KONTAK"/>
  371. <xs:element name="BAD_OFERTY_ULOTK_PLAKATY_OR_MASS_MEDIA"
  372. type="xs:string"
  373. id="_2_MARKETING___d15e199607-1_BAD_OFERTY"/>
  374. <xs:element name="BAD_TERMIN_INSTALACJI_TERAZ_OR_TANIO_POTEM"
  375. type="xs:string"
  376. id="_2_MARKETING___d15e199608-1_BAD_TERMIN"/>
  377. <xs:element name="BAD_TV_MULTIROOM_OR_JEDEN_TV"
  378. type="xs:string"
  379. id="_2_MARKETING___d15e199609-1_BAD_TV_MUL"/>
  380. <xs:element name="BAD_TV_CHCE_ZAMAWIAC_PAKIETY_OR_WYSTARCZY_ZAMOWIONY"
  381. type="xs:string"
  382. id="_2_MARKETING___d15e199610-1_BAD_TV_CHC"/>
  383. <xs:element name="BAD_TV_CHCE_NAGRYWAC_INNY_KANAL_OR_TEN_SAM_CO_OGLADAM"
  384. type="xs:string"
  385. id="_2_MARKETING___d15e199612-1_BAD_TV_CHC"/>
  386. <xs:element name="BAD_TV_WYPASIONY_BOX_OR_WYPASIONY_WLASNY_TV"
  387. type="xs:string"
  388. id="_2_MARKETING___d15e199613-1_BAD_TV_WYP"/>
  389. <xs:element name="BAD_TV_PAKIET_KILKADZIESIAT_DOBRYCH_KAN_OR_SETKI_ROZNYCH"
  390. type="xs:string"
  391. id="_2_MARKETING___d15e199614-1_BAD_TV_PAK"/>
  392. <xs:element name="BAD_TV_WOLE_HD_DROZEJ_OR_SD_TANIEJ"
  393. type="xs:string"
  394. id="_2_MARKETING___d15e199615-1_BAD_TV_WOL"/>
  395. <xs:element name="BAD_TV_CHCE_VOD_OPERATORA_OR_WOLE_SMART_TV_LUB_WYPOZYCZALNIE"
  396. type="xs:string"
  397. id="_2_MARKETING___d15e199616-1_BAD_TV_CHC"/>
  398. <xs:element name="BAD_CHCE_LOKALNY_MONITORING_OR_NIE_INTERESUJE_MNIE_TO"
  399. type="xs:string"
  400. id="_2_MARKETING___d15e199617-1_BAD_CHCE_L"/>
  401. <xs:element name="BAD_CHCE_LOKALNE_TV_OR_NIE_OGLADAM_LOK_TV"
  402. type="xs:string"
  403. id="_2_MARKETING___d15e199618-1_BAD_CHCE_L"/>
  404. <xs:element name="BAD_TEL_CHCE_USL_VOICE2MAIL_OR_WOLE_SEKRETARKE"
  405. type="xs:string"
  406. id="_2_MARKETING___d15e199619-1_BAD_TEL_CH"/>
  407. <xs:element name="BAD_TEL_CHCE_DARMOWE_MIEDZYNARODOWE_OR_LOKALNE_KRAJOWE"
  408. type="xs:string"
  409. id="_2_MARKETING___d15e199620-1_BAD_TEL_CH"/>
  410. <xs:element name="BAD_TEL_DZWONIE_NA_KOMORKI_OR_STACJONARNE"
  411. type="xs:string"
  412. id="_2_MARKETING___d15e199621-1_BAD_TEL_DZ"/>
  413. <xs:element name="BAD_TEL_WOLE_WIECEJ_DANYCH_MVNO_OR_DARMOWYCH_MINUT"
  414. type="xs:string"
  415. id="_2_MARKETING___d15e199622-1_BAD_TEL_WO"/>
  416. <xs:element name="BAD_TEL_WOLE_GSM_W_PAKIECIE_U_ISP_OR_KUPIE_GO_U_OPER_GSM"
  417. type="xs:string"
  418. id="_2_MARKETING___d15e199624-1_BAD_TEL_WO"/>
  419. <xs:element name="BAD_MAX_CENA_ZA_DOBRY_PAKIET_TV_TEL_NET"
  420. type="xs:string"
  421. id="_2_MARKETING___d15e199625-1_BAD_MAX_CE"/>
  422. <xs:element name="BAD_DOBRA_CENA_ZA_DOBRY_PAKIET_TV_TEL_NET"
  423. type="xs:string"
  424. id="_2_MARKETING___d15e199626-1_BAD_DOBRA_"/>
  425. <xs:element name="BAD_PLEC"
  426. type="xs:string"
  427. id="_2_MARKETING___d15e199627-1_BAD_PLEC"/>
  428. <xs:element name="BAD_WIELKOSC_MIASTA"
  429. type="xs:string"
  430. id="_2_MARKETING___d15e199628-1_BAD_WIELKO"/>
  431. <xs:element name="BAD_UCZE_SIE"
  432. type="xs:string"
  433. id="_2_MARKETING___d15e199629-1_BAD_UCZE_S"/>
  434. <xs:element name="SYNC_SQIX_STATUS"
  435. type="xs:string"
  436. id="_2_MARKETING___d15e199630-1_SYNC_SQIX_"/>
  437. <xs:element name="id_13102"
  438. type="xs:integer"
  439. id="_2_MARKETING___d15e199631-1_id_13102"/>
  440. <xs:element name="A_UPDATE_DATE"
  441. type="xs:token"
  442. id="_2_MARKETING___d15e199632-1_A_UPDATE_D"/>
  443. <xs:element name="CRM_LISTA_ZASOBOW_ID"
  444. type="xs:integer"
  445. id="_2_MARKETING___d15e199633-1_CRM_LISTA_"/>
  446. <xs:element name="BUSINESS"
  447. type="xs:string"
  448. id="_2_MARKETING___d15e199634-1_BUSINESS"/>
  449. <xs:element name="ID_PROJECT"
  450. type="xs:integer"
  451. id="_2_MARKETING___d15e199636-1_ID_PROJECT"/>
  452. <!--#272 found ignored the_geom-->
  453. <!--#272 found ignored S_ADDRESS_CITY-->
  454. <!--#272 found ignored BAD_CHCE_LOKALNE_TV_OR_NIE_OGLADAM_LOK_TV-->
  455. <!--#272 found ignored BAD_TEL_CHCE_USL_VOICE2MAIL_OR_WOLE_SEKRETARKE-->
  456. <!--#272 found ignored BAD_TEL_CHCE_DARMOWE_MIEDZYNARODOWE_OR_LOKALNE_KRAJOWE-->
  457. <!--#272 found ignored BAD_TEL_DZWONIE_NA_KOMORKI_OR_STACJONARNE-->
  458. <!--#272 found ignored BAD_TEL_WOLE_WIECEJ_DANYCH_MVNO_OR_DARMOWYCH_MINUT-->
  459. <!--#272 found ignored BAD_TEL_WOLE_GSM_W_PAKIECIE_U_ISP_OR_KUPIE_GO_U_OPER_GSM-->
  460. <!--#272 found ignored BAD_MAX_CENA_ZA_DOBRY_PAKIET_TV_TEL_NET-->
  461. <!--#272 found ignored BAD_DOBRA_CENA_ZA_DOBRY_PAKIET_TV_TEL_NET-->
  462. <!--#272 found ignored BAD_PLEC-->
  463. <!--#272 found ignored BAD_WIELKOSC_MIASTA-->
  464. <!--#272 found ignored L_APPOITMENT_DATE-->
  465. <!--#272 found ignored BAD_UCZE_SIE-->
  466. <!--#272 found ignored A_RECORD_CREATE_DATE-->
  467. <!--#272 found ignored A_RECORD_CREATE_AUTHOR-->
  468. <!--#272 found ignored A_RECORD_UPDATE_DATE-->
  469. <!--#272 found ignored A_RECORD_UPDATE_AUTHOR-->
  470. <!--#272 found ignored A_ADM_COMPANY-->
  471. <!--#272 found ignored A_CLASSIFIED-->
  472. <!--#272 found ignored TAB_UPDATE_DATE-->
  473. <!--#272 found ignored TAB_UPDATE_INFO-->
  474. <!--#272 found ignored TAB_UPDATE_STAT-->
  475. <!--#272 found ignored L_APPOITMENT_USER-->
  476. <!--#288 unsupported yet @ref p5_zasob_36:ADMIN_USERS-->
  477. <!--#414-A found adding p5_zasob_36:ADMIN_USERS, $prototype_NamespacePrefix = default_db__x3A__USERS2_MARKETING-->
  478. <xs:element ref="default_db__x3A__ADMIN_USERS:ADMIN_USERS"
  479. minOccurs="0"
  480. id="_2_MARKETING___d15e199664-1">
  481. <xs:annotation>
  482. <xs:appinfo>
  483. <system_cache__appinfo:flat_relation_cache>
  484. <system_cache__appinfo:source system_cache__appinfo:name="L_APPOITMENT_USER"
  485. system_cache__appinfo:xpath="default_db__x3A__ADMIN_USERS:ADMIN_USERS/ADM_ACCOUNT"/>
  486. </system_cache__appinfo:flat_relation_cache>
  487. </xs:appinfo>
  488. </xs:annotation>
  489. </xs:element>
  490. <!--#272 found ignored SYNC_SQIX_STATUS-->
  491. <!--#272 found ignored A_STATUS_CURRENT-->
  492. <!--#272 found ignored id_13102-->
  493. <!--#272 found ignored L_APPOITMENT_PERIOD-->
  494. <!--#272 found ignored L_APPOITMENT_TYPE-->
  495. <!--#272 found ignored L_APPOITMENT_INFO-->
  496. <!--#272 found ignored P_NAME-->
  497. <!--#272 found ignored P_PHONE-->
  498. <!--#272 found ignored BUSINESS-->
  499. <!--#272 found ignored M_REWIR-->
  500. <!--#288 unsupported yet @ref p5_zasob_36:MK_Rewiry-->
  501. <!--#414-A found adding p5_zasob_36:MK_Rewiry, $prototype_NamespacePrefix = default_db__x3A__USERS2_MARKETING-->
  502. <xs:element ref="default_db__x3A__MK_Rewiry:MK_Rewiry"
  503. minOccurs="0"
  504. id="_2_MARKETING___d15e199682-1">
  505. <xs:annotation>
  506. <xs:appinfo>
  507. <system_cache__appinfo:flat_relation_cache>
  508. <system_cache__appinfo:source system_cache__appinfo:name="M_REWIR"
  509. system_cache__appinfo:xpath="default_db__x3A__MK_Rewiry:MK_Rewiry/NAZWA_REWI"/>
  510. </system_cache__appinfo:flat_relation_cache>
  511. </xs:appinfo>
  512. </xs:annotation>
  513. </xs:element>
  514. <!--#272 found ignored ID_PROJECT-->
  515. <!--#288 unsupported yet @ref p5_zasob_36:IN7_MK_BAZA_DYSTRYBUCJI-->
  516. <!--#414-A found adding p5_zasob_36:IN7_MK_BAZA_DYSTRYBUCJI, $prototype_NamespacePrefix = default_db__x3A__USERS2_MARKETING-->
  517. <xs:element ref="default_db__x3A__IN7_MK_BAZA_DYSTRYBUCJI:IN7_MK_BAZA_DYSTRYBUCJI"
  518. minOccurs="0"
  519. id="_2_MARKETING___d15e199690-1">
  520. <xs:annotation>
  521. <xs:appinfo>
  522. <system_cache__appinfo:flat_relation_cache>
  523. <system_cache__appinfo:source system_cache__appinfo:name="ID_PROJECT"
  524. system_cache__appinfo:xpath="default_db__x3A__IN7_MK_BAZA_DYSTRYBUCJI:IN7_MK_BAZA_DYSTRYBUCJI/ID"/>
  525. </system_cache__appinfo:flat_relation_cache>
  526. </xs:appinfo>
  527. </xs:annotation>
  528. </xs:element>
  529. <!--#272 found ignored __MK_Rewiry__STATUS-->
  530. <!--#272 found ignored ID-->
  531. <!--#288 unsupported yet @ref p5_zasob_36:USERS2_MARKETING-->
  532. <!--#414-A found adding p5_zasob_36:USERS2_MARKETING, $prototype_NamespacePrefix = default_db__x3A__USERS2_MARKETING-->
  533. <xs:element ref="default_db__x3A__USERS2_MARKETING:USERS2_MARKETING"
  534. minOccurs="0"
  535. id="_2_MARKETING___d15e199699-1">
  536. <xs:annotation>
  537. <xs:appinfo>
  538. <system_cache__appinfo:flat_relation_cache>
  539. <system_cache__appinfo:source system_cache__appinfo:name="ID"
  540. system_cache__appinfo:xpath="default_db__x3A__USERS2_MARKETING:USERS2_MARKETING/ID"/>
  541. </system_cache__appinfo:flat_relation_cache>
  542. </xs:appinfo>
  543. </xs:annotation>
  544. </xs:element>
  545. <!--#272 found ignored P_OTHER_INFO-->
  546. <!--#272 found ignored A_PROBLEM_DESC-->
  547. <!--#272 found ignored A_PROBLEM-->
  548. <!--#272 found ignored A_ID_USERS2-->
  549. <!--#272 found ignored ID_BILLING_USERS-->
  550. <!--#272 found ignored ID_SERVICES-->
  551. <!--#272 found ignored A_PROBLEM_DATE-->
  552. <!--#272 found ignored A_STATUS-->
  553. <!--#272 found ignored A_STATUS_INFO-->
  554. <!--#272 found ignored ADMIN_USERS_ID-->
  555. <!--#272 found ignored A_UPDATE_DATE-->
  556. <!--#272 found ignored S_ALIAS-->
  557. <!--#272 found ignored S_ADDRESS_POST_CODE-->
  558. <!--#272 found ignored S_ADDRESS_POST_OFFICE-->
  559. <!--#272 found ignored S_ADDRESS_HOUSE-->
  560. <!--#272 found ignored S_OTHER_INFO-->
  561. <!--#272 found ignored S_VIP_LEVEL-->
  562. <!--#272 found ignored S_VIP_DESC-->
  563. <!--#272 found ignored T_NETWORK_SERVER-->
  564. <!--#272 found ignored T_TELBOX_ADDRESS-->
  565. <!--#272 found ignored CRM_LISTA_ZASOBOW_ID-->
  566. <!--#288 unsupported yet @ref p5_zasob_36:CRM_LISTA_ZASOBOW-->
  567. <!--#414-A found adding p5_zasob_36:CRM_LISTA_ZASOBOW, $prototype_NamespacePrefix = default_db__x3A__USERS2_MARKETING-->
  568. <xs:element ref="default_db__x3A__CRM_LISTA_ZASOBOW:CRM_LISTA_ZASOBOW"
  569. minOccurs="0"
  570. id="_2_MARKETING___d15e199728-1">
  571. <xs:annotation>
  572. <xs:appinfo>
  573. <system_cache__appinfo:flat_relation_cache>
  574. <system_cache__appinfo:source system_cache__appinfo:name="CRM_LISTA_ZASOBOW_ID"
  575. system_cache__appinfo:xpath="default_db__x3A__CRM_LISTA_ZASOBOW:CRM_LISTA_ZASOBOW/ID"/>
  576. </system_cache__appinfo:flat_relation_cache>
  577. </xs:appinfo>
  578. </xs:annotation>
  579. </xs:element>
  580. <!--#272 found ignored T_TELBOX_PORT-->
  581. <!--#272 found ignored T_WORKPOINTS-->
  582. <!--#272 found ignored T_WORKPOINTS_VALUE-->
  583. <!--#272 found ignored T_WORKPOINTS_TYPE-->
  584. <!--#272 found ignored T_WORKPOINTS_USER-->
  585. <!--#272 found ignored T_WORKPOINTS_DATE-->
  586. <!--#272 found ignored T_PENALTIES-->
  587. <!--#272 found ignored T_PENALTIES_TYPE-->
  588. <!--#272 found ignored T_PENALTIES_VALUE-->
  589. <!--#272 found ignored P_BILLING_NO-->
  590. <!--#272 found ignored P_NIP-->
  591. <!--#272 found ignored P_PESEL-->
  592. <!--#272 found ignored P_OTHER_DOC-->
  593. <!--#272 found ignored P_FAX-->
  594. <!--#272 found ignored P_CONTACT_PERSON-->
  595. <!--#272 found ignored P_ADDRESS_CITY-->
  596. <!--#272 found ignored P_ADDRESS_STREET-->
  597. <!--#272 found ignored P_ADDRESS_POST_CODE-->
  598. <!--#272 found ignored P_ADDRESS_POST_OFFICE-->
  599. <!--#272 found ignored P_ADDRESS_HOUSE-->
  600. <!--#272 found ignored I_BAD_DATE-->
  601. <!--#272 found ignored T_WORKPOINTS_PROCES-->
  602. <!--#272 found ignored I_OPER-->
  603. <!--#272 found ignored I_PAY-->
  604. <!--#272 found ignored I_OPER_ZAD-->
  605. <!--#272 found ignored I_OPER_FIN-->
  606. <!--#272 found ignored I_OPER_ZAINT-->
  607. <!--#272 found ignored T_BAD_DATE-->
  608. <!--#272 found ignored T_OPER-->
  609. <!--#272 found ignored T_PAY-->
  610. <!--#272 found ignored T_OPER_ZAD-->
  611. <!--#272 found ignored T_OPER_FIN-->
  612. <!--#272 found ignored P_ACCOUNT-->
  613. <!--#272 found ignored T_OPER_ZAINT-->
  614. <!--#272 found ignored TV_BAD_DATE-->
  615. <!--#272 found ignored TV_OPER-->
  616. <!--#272 found ignored TV_PAY-->
  617. <!--#272 found ignored TV_OPER_ZAD-->
  618. <!--#272 found ignored TV_OPER_FIN-->
  619. <!--#272 found ignored TV_OPER_ZAINT-->
  620. <!--#272 found ignored BOK_ZAD-->
  621. <!--#272 found ignored BOK_BAD_DATE-->
  622. <!--#272 found ignored BIZ_BAD_DATE-->
  623. <!--#272 found ignored T_TELBOX_BUILDING_IN-->
  624. <!--#288 unsupported yet @ref p5_zasob_36:BUILDINGS-->
  625. <!--#414-A found adding p5_zasob_36:BUILDINGS, $prototype_NamespacePrefix = default_db__x3A__USERS2_MARKETING-->
  626. <xs:element ref="default_db__x3A__BUILDINGS:BUILDINGS"
  627. minOccurs="0"
  628. id="_2_MARKETING___d15e199780-1">
  629. <xs:annotation>
  630. <xs:appinfo>
  631. <system_cache__appinfo:flat_relation_cache>
  632. <system_cache__appinfo:source system_cache__appinfo:name="T_TELBOX_BUILDING_IN"
  633. system_cache__appinfo:xpath="default_db__x3A__BUILDINGS:BUILDINGS/S_ADDRESS_STREET"/>
  634. </system_cache__appinfo:flat_relation_cache>
  635. </xs:appinfo>
  636. </xs:annotation>
  637. </xs:element>
  638. <!--#272 found ignored BIZ_VOIP_ZAINT-->
  639. <!--#272 found ignored BIZ_SUPPORT_ZAINT-->
  640. <!--#272 found ignored BIZ_PROCESY5_ZAINT-->
  641. <!--#272-A found adding INTERNET_STATUS, $prototype_NamespacePrefix = default_db__x3A__USERS2_MARKETING-->
  642. <xs:element xmlns:p5="https://biuro.biall-net.pl/wfs"
  643. name="INTERNET_STATUS"
  644. p5:id_zasob="3493"
  645. minOccurs="1"
  646. maxOccurs="1"
  647. p5:label="Status usł. Internet"
  648. id="_2_MARKETING___d15e199789-1_INTERNET_S">
  649. <xs:annotation>
  650. <xs:documentation>INTERNET_STATUS Informacje z bazy billingowej/technicznej o tym z jakich usług korzysta/korzystał KLIENT.</xs:documentation>
  651. </xs:annotation>
  652. </xs:element>
  653. <!--#272 found ignored S_KLATKA-->
  654. <!--#272 found ignored P_FLOOR_CONTROL-->
  655. <!--#272 found ignored BAD_WYS_JAKOSC_OR_NISKA_CENA-->
  656. <!--#272 found ignored BAD_KROTKA_UMOWA_OR_DLUGI_KONTRAKT_UPUST-->
  657. <!--#272 found ignored BAD_KONTAKT_CALL_CENTER_EBOK_OR_LOKALNY_BOK-->
  658. <!--#272 found ignored BAD_OFERTY_ULOTK_PLAKATY_OR_MASS_MEDIA-->
  659. <!--#272 found ignored S_ADDRESS_STREET-->
  660. <!--#272 found ignored BAD_TERMIN_INSTALACJI_TERAZ_OR_TANIO_POTEM-->
  661. <!--#272 found ignored BAD_TV_MULTIROOM_OR_JEDEN_TV-->
  662. <!--#272 found ignored BAD_TV_CHCE_ZAMAWIAC_PAKIETY_OR_WYSTARCZY_ZAMOWIONY-->
  663. <!--#272 found ignored BAD_TV_CHCE_NAGRYWAC_INNY_KANAL_OR_TEN_SAM_CO_OGLADAM-->
  664. <!--#272 found ignored BAD_TV_WYPASIONY_BOX_OR_WYPASIONY_WLASNY_TV-->
  665. <!--#272 found ignored BAD_TV_PAKIET_KILKADZIESIAT_DOBRYCH_KAN_OR_SETKI_ROZNYCH-->
  666. <!--#272 found ignored BAD_TV_WOLE_HD_DROZEJ_OR_SD_TANIEJ-->
  667. <!--#272 found ignored BAD_TV_CHCE_VOD_OPERATORA_OR_WOLE_SMART_TV_LUB_WYPOZYCZALNIE-->
  668. <!--#272 found ignored BAD_CHCE_LOKALNY_MONITORING_OR_NIE_INTERESUJE_MNIE_TO-->
  669. <!--#272 found ignored A_STATUS_LASTCHANGE_DATE-->
  670. </xs:sequence>
  671. <xs:attribute name="label" id="_2_MARKETING___d15e199810-1_label"/>
  672. <xs:assert test="@label = concat(I_BAD_DATE, ' ', I_OPER, ' ', I_PAY, ' ', I_BAD_TERM)"
  673. id="_2_MARKETING___d15e199811-1"/>
  674. </xs:complexType>
  675. <xs:element name="USERS2_MARKETING"
  676. type="default_db__x3A__USERS2_MARKETING:USERS2_MARKETING"
  677. id="_2_MARKETING___d15e199812-1_USERS2_MAR"/>
  678. <xs:complexType name="USERS2_MARKETING_BN_FRESH"
  679. id="_2_MARKETING___d15e199813-1_USERS2_MAR">
  680. <xs:complexContent id="_2_MARKETING___d15e199814-1">
  681. <xs:restriction base="default_db__x3A__USERS2_MARKETING:USERS2_MARKETING">
  682. <xs:sequence id="_2_MARKETING___d15e199816-1">
  683. <xs:element name="the_geom"
  684. type="gml:AbstractFeatureType"
  685. id="_2_MARKETING___d15e199817-1_the_geom">
  686. <xs:annotation>
  687. <xs:documentation>Dane geograficzne obiektu - linia, punkt, polygon</xs:documentation>
  688. </xs:annotation>
  689. </xs:element>
  690. <xs:element name="A_STATUS"
  691. type="default_db__x3A__USERS2_MARKETING:A_STATUS_Type"
  692. id="_2_MARKETING___d15e199821-1_A_STATUS"/>
  693. <xs:element name="A_STATUS_INFO"
  694. type="xs:string"
  695. id="_2_MARKETING___d15e199822-1_A_STATUS_I"/>
  696. <xs:element name="L_APPOITMENT_USER"
  697. type="xs:string"
  698. id="_2_MARKETING___d15e199823-1_L_APPOITME"/>
  699. <xs:element name="A_CLASSIFIED"
  700. type="xs:string"
  701. id="_2_MARKETING___d15e199824-1_A_CLASSIFI"/>
  702. <xs:element name="A_ADM_COMPANY"
  703. type="xs:string"
  704. id="_2_MARKETING___d15e199825-1_A_ADM_COMP"/>
  705. <xs:element name="ID" type="xs:integer" id="_2_MARKETING___d15e199826-1_ID"/>
  706. <xs:element name="ADMIN_USERS_ID"
  707. type="xs:integer"
  708. id="_2_MARKETING___d15e199827-1_ADMIN_USER"/>
  709. <xs:element name="A_ID_USERS2"
  710. type="xs:integer"
  711. id="_2_MARKETING___d15e199828-1_A_ID_USERS"/>
  712. <xs:element name="ID_BILLING_USERS"
  713. type="xs:integer"
  714. id="_2_MARKETING___d15e199829-1_ID_BILLING"/>
  715. <xs:element name="ID_SERVICES"
  716. type="xs:integer"
  717. id="_2_MARKETING___d15e199830-1_ID_SERVICE"/>
  718. <xs:element name="A_RECORD_CREATE_DATE"
  719. type="xs:token"
  720. id="_2_MARKETING___d15e199832-1_A_RECORD_C"/>
  721. <xs:element name="A_RECORD_CREATE_AUTHOR"
  722. type="xs:string"
  723. id="_2_MARKETING___d15e199833-1_A_RECORD_C"/>
  724. <xs:element name="A_RECORD_UPDATE_DATE"
  725. type="xs:token"
  726. id="_2_MARKETING___d15e199834-1_A_RECORD_U"/>
  727. <xs:element name="A_RECORD_UPDATE_AUTHOR"
  728. type="xs:string"
  729. id="_2_MARKETING___d15e199835-1_A_RECORD_U"/>
  730. <xs:element name="TAB_UPDATE_STAT"
  731. type="xs:string"
  732. id="_2_MARKETING___d15e199836-1_TAB_UPDATE"/>
  733. <xs:element name="TAB_UPDATE_DATE"
  734. type="xs:token"
  735. id="_2_MARKETING___d15e199837-1_TAB_UPDATE"/>
  736. <xs:element name="TAB_UPDATE_INFO"
  737. type="xs:string"
  738. id="_2_MARKETING___d15e199838-1_TAB_UPDATE"/>
  739. <xs:element name="L_APPOITMENT_DATE"
  740. type="xs:token"
  741. id="_2_MARKETING___d15e199839-1_L_APPOITME"/>
  742. <xs:element name="L_APPOITMENT_PERIOD"
  743. type="xs:string"
  744. id="_2_MARKETING___d15e199840-1_L_APPOITME"/>
  745. <xs:element name="L_APPOITMENT_INFO"
  746. type="xs:string"
  747. id="_2_MARKETING___d15e199841-1_L_APPOITME"/>
  748. <xs:element name="L_APPOITMENT_TYPE"
  749. type="xs:string"
  750. id="_2_MARKETING___d15e199842-1_L_APPOITME"/>
  751. <xs:element name="A_PROBLEM"
  752. type="xs:string"
  753. id="_2_MARKETING___d15e199844-1_A_PROBLEM"/>
  754. <xs:element name="A_PROBLEM_DESC"
  755. type="xs:string"
  756. id="_2_MARKETING___d15e199845-1_A_PROBLEM_"/>
  757. <xs:element name="A_PROBLEM_DATE"
  758. type="xs:token"
  759. id="_2_MARKETING___d15e199846-1_A_PROBLEM_"/>
  760. <xs:element name="A_STATUS_CURRENT"
  761. type="xs:string"
  762. id="_2_MARKETING___d15e199847-1_A_STATUS_C"/>
  763. <xs:element name="A_STATUS_LASTCHANGE_DATE"
  764. type="xs:token"
  765. id="_2_MARKETING___d15e199848-1_A_STATUS_L"/>
  766. <xs:element name="S_ALIAS"
  767. type="xs:string"
  768. id="_2_MARKETING___d15e199849-1_S_ALIAS"/>
  769. <xs:element name="S_ADDRESS_CITY"
  770. type="xs:string"
  771. id="_2_MARKETING___d15e199850-1_S_ADDRESS_"/>
  772. <xs:element name="S_ADDRESS_POST_CODE"
  773. type="xs:string"
  774. id="_2_MARKETING___d15e199851-1_S_ADDRESS_"/>
  775. <xs:element name="S_ADDRESS_POST_OFFICE"
  776. type="xs:string"
  777. id="_2_MARKETING___d15e199852-1_S_ADDRESS_"/>
  778. <xs:element name="S_ADDRESS_STREET"
  779. type="xs:string"
  780. id="_2_MARKETING___d15e199853-1_S_ADDRESS_"/>
  781. <xs:element name="S_ADDRESS_HOUSE"
  782. type="xs:string"
  783. id="_2_MARKETING___d15e199854-1_S_ADDRESS_"/>
  784. <xs:element name="S_OTHER_INFO"
  785. type="xs:string"
  786. id="_2_MARKETING___d15e199856-1_S_OTHER_IN"/>
  787. <xs:element name="S_VIP_LEVEL"
  788. type="xs:string"
  789. id="_2_MARKETING___d15e199857-1_S_VIP_LEVE"/>
  790. <xs:element name="S_VIP_DESC"
  791. type="xs:string"
  792. id="_2_MARKETING___d15e199858-1_S_VIP_DESC"/>
  793. <xs:element name="T_NETWORK_SERVER"
  794. type="xs:string"
  795. id="_2_MARKETING___d15e199859-1_T_NETWORK_"/>
  796. <xs:element name="T_TELBOX_ADDRESS"
  797. type="xs:string"
  798. id="_2_MARKETING___d15e199860-1_T_TELBOX_A"/>
  799. <xs:element name="T_TELBOX_PORT"
  800. type="xs:string"
  801. id="_2_MARKETING___d15e199861-1_T_TELBOX_P"/>
  802. <xs:element name="T_WORKPOINTS"
  803. type="xs:string"
  804. id="_2_MARKETING___d15e199862-1_T_WORKPOIN"/>
  805. <xs:element name="T_WORKPOINTS_PROCES"
  806. type="xs:integer"
  807. id="_2_MARKETING___d15e199863-1_T_WORKPOIN"/>
  808. <xs:element name="T_WORKPOINTS_VALUE"
  809. type="xs:string"
  810. id="_2_MARKETING___d15e199864-1_T_WORKPOIN"/>
  811. <xs:element name="T_WORKPOINTS_TYPE"
  812. type="xs:string"
  813. id="_2_MARKETING___d15e199865-1_T_WORKPOIN"/>
  814. <xs:element name="T_WORKPOINTS_USER"
  815. type="xs:string"
  816. id="_2_MARKETING___d15e199866-1_T_WORKPOIN"/>
  817. <xs:element name="T_WORKPOINTS_DATE"
  818. type="xs:token"
  819. id="_2_MARKETING___d15e199868-1_T_WORKPOIN"/>
  820. <xs:element name="T_PENALTIES"
  821. type="xs:string"
  822. id="_2_MARKETING___d15e199869-1_T_PENALTIE"/>
  823. <xs:element name="T_PENALTIES_TYPE"
  824. type="xs:string"
  825. id="_2_MARKETING___d15e199870-1_T_PENALTIE"/>
  826. <xs:element name="T_PENALTIES_VALUE"
  827. type="xs:string"
  828. id="_2_MARKETING___d15e199871-1_T_PENALTIE"/>
  829. <xs:element name="P_BILLING_NO"
  830. type="xs:integer"
  831. id="_2_MARKETING___d15e199872-1_P_BILLING_"/>
  832. <xs:element name="P_NAME"
  833. type="xs:string"
  834. id="_2_MARKETING___d15e199873-1_P_NAME"/>
  835. <xs:element name="P_NIP"
  836. type="xs:string"
  837. id="_2_MARKETING___d15e199874-1_P_NIP"/>
  838. <xs:element name="P_PESEL"
  839. type="xs:string"
  840. id="_2_MARKETING___d15e199875-1_P_PESEL"/>
  841. <xs:element name="P_OTHER_DOC"
  842. type="xs:string"
  843. id="_2_MARKETING___d15e199876-1_P_OTHER_DO"/>
  844. <xs:element name="P_PHONE"
  845. type="xs:string"
  846. id="_2_MARKETING___d15e199877-1_P_PHONE"/>
  847. <xs:element name="P_FAX"
  848. type="xs:string"
  849. id="_2_MARKETING___d15e199878-1_P_FAX"/>
  850. <xs:element name="P_CONTACT_PERSON"
  851. type="xs:string"
  852. id="_2_MARKETING___d15e199880-1_P_CONTACT_"/>
  853. <xs:element name="P_ADDRESS_CITY"
  854. type="xs:string"
  855. id="_2_MARKETING___d15e199881-1_P_ADDRESS_"/>
  856. <xs:element name="P_ADDRESS_POST_CODE"
  857. type="xs:string"
  858. id="_2_MARKETING___d15e199882-1_P_ADDRESS_"/>
  859. <xs:element name="P_ADDRESS_POST_OFFICE"
  860. type="xs:string"
  861. id="_2_MARKETING___d15e199883-1_P_ADDRESS_"/>
  862. <xs:element name="P_ADDRESS_STREET"
  863. type="xs:string"
  864. id="_2_MARKETING___d15e199884-1_P_ADDRESS_"/>
  865. <xs:element name="P_ADDRESS_HOUSE"
  866. type="xs:string"
  867. id="_2_MARKETING___d15e199885-1_P_ADDRESS_"/>
  868. <xs:element name="P_OTHER_INFO"
  869. type="xs:string"
  870. id="_2_MARKETING___d15e199886-1_P_OTHER_IN"/>
  871. <xs:element name="T_TELBOX_BUILDING_IN"
  872. type="xs:string"
  873. id="_2_MARKETING___d15e199887-1_T_TELBOX_B"/>
  874. <xs:element name="I_BAD_DATE"
  875. type="default_db__x3A__USERS2_MARKETING:I_BAD_DATE_FRESH"
  876. id="_2_MARKETING___d15e199888-1_I_BAD_DATE"/>
  877. <xs:element name="I_OPER"
  878. type="default_db__x3A__USERS2_MARKETING:I_OPER_BN"
  879. id="_2_MARKETING___d15e199889-1_I_OPER"/>
  880. <xs:element name="I_PAY"
  881. type="xs:double"
  882. id="_2_MARKETING___d15e199890-1_I_PAY"/>
  883. <xs:element name="I_OPER_ZAD"
  884. type="xs:string"
  885. id="_2_MARKETING___d15e199892-1_I_OPER_ZAD"/>
  886. <xs:element name="I_OPER_FIN"
  887. type="xs:token"
  888. id="_2_MARKETING___d15e199893-1_I_OPER_FIN"/>
  889. <xs:element name="I_OPER_ZAINT"
  890. type="xs:string"
  891. id="_2_MARKETING___d15e199894-1_I_OPER_ZAI"/>
  892. <xs:element name="T_BAD_DATE"
  893. type="xs:token"
  894. id="_2_MARKETING___d15e199895-1_T_BAD_DATE"/>
  895. <xs:element name="T_OPER"
  896. type="xs:string"
  897. id="_2_MARKETING___d15e199896-1_T_OPER"/>
  898. <xs:element name="T_PAY"
  899. type="xs:double"
  900. id="_2_MARKETING___d15e199897-1_T_PAY"/>
  901. <xs:element name="T_OPER_ZAD"
  902. type="xs:string"
  903. id="_2_MARKETING___d15e199898-1_T_OPER_ZAD"/>
  904. <xs:element name="T_OPER_FIN"
  905. type="xs:token"
  906. id="_2_MARKETING___d15e199899-1_T_OPER_FIN"/>
  907. <xs:element name="T_OPER_ZAINT"
  908. type="xs:string"
  909. id="_2_MARKETING___d15e199900-1_T_OPER_ZAI"/>
  910. <xs:element name="TV_BAD_DATE"
  911. type="xs:token"
  912. id="_2_MARKETING___d15e199901-1_TV_BAD_DAT"/>
  913. <xs:element name="TV_OPER"
  914. type="xs:string"
  915. id="_2_MARKETING___d15e199902-1_TV_OPER"/>
  916. <xs:element name="TV_PAY"
  917. type="xs:double"
  918. id="_2_MARKETING___d15e199904-1_TV_PAY"/>
  919. <xs:element name="TV_OPER_ZAD"
  920. type="xs:string"
  921. id="_2_MARKETING___d15e199905-1_TV_OPER_ZA"/>
  922. <xs:element name="TV_OPER_FIN"
  923. type="xs:token"
  924. id="_2_MARKETING___d15e199906-1_TV_OPER_FI"/>
  925. <xs:element name="TV_OPER_ZAINT"
  926. type="xs:string"
  927. id="_2_MARKETING___d15e199907-1_TV_OPER_ZA"/>
  928. <xs:element name="BIZ_BAD_DATE"
  929. type="xs:token"
  930. id="_2_MARKETING___d15e199908-1_BIZ_BAD_DA"/>
  931. <xs:element name="BIZ_VOIP_ZAINT"
  932. type="xs:string"
  933. id="_2_MARKETING___d15e199909-1_BIZ_VOIP_Z"/>
  934. <xs:element name="BIZ_PROCESY5_ZAINT"
  935. type="xs:string"
  936. id="_2_MARKETING___d15e199910-1_BIZ_PROCES"/>
  937. <xs:element name="BIZ_SUPPORT_ZAINT"
  938. type="xs:string"
  939. id="_2_MARKETING___d15e199911-1_BIZ_SUPPOR"/>
  940. <xs:element name="M_REWIR"
  941. type="xs:string"
  942. id="_2_MARKETING___d15e199912-1_M_REWIR"/>
  943. <xs:element name="__MK_Rewiry__STATUS"
  944. type="xs:string"
  945. id="_2_MARKETING___d15e199913-1___MK_Rewir"/>
  946. <xs:element name="BOK_ZAD"
  947. type="xs:string"
  948. id="_2_MARKETING___d15e199914-1_BOK_ZAD"/>
  949. <xs:element name="BOK_BAD_DATE"
  950. type="xs:token"
  951. id="_2_MARKETING___d15e199916-1_BOK_BAD_DA"/>
  952. <xs:element name="P_FLOOR_CONTROL"
  953. type="xs:string"
  954. id="_2_MARKETING___d15e199917-1_P_FLOOR_CO"/>
  955. <xs:element name="P_ACCOUNT"
  956. type="xs:string"
  957. id="_2_MARKETING___d15e199918-1_P_ACCOUNT"/>
  958. <xs:element name="S_KLATKA"
  959. type="xs:string"
  960. id="_2_MARKETING___d15e199919-1_S_KLATKA"/>
  961. <xs:element name="BAD_WYS_JAKOSC_OR_NISKA_CENA"
  962. type="xs:string"
  963. id="_2_MARKETING___d15e199920-1_BAD_WYS_JA"/>
  964. <xs:element name="BAD_KROTKA_UMOWA_OR_DLUGI_KONTRAKT_UPUST"
  965. type="xs:string"
  966. id="_2_MARKETING___d15e199921-1_BAD_KROTKA"/>
  967. <xs:element name="BAD_KONTAKT_CALL_CENTER_EBOK_OR_LOKALNY_BOK"
  968. type="xs:string"
  969. id="_2_MARKETING___d15e199922-1_BAD_KONTAK"/>
  970. <xs:element name="BAD_OFERTY_ULOTK_PLAKATY_OR_MASS_MEDIA"
  971. type="xs:string"
  972. id="_2_MARKETING___d15e199923-1_BAD_OFERTY"/>
  973. <xs:element name="BAD_TERMIN_INSTALACJI_TERAZ_OR_TANIO_POTEM"
  974. type="xs:string"
  975. id="_2_MARKETING___d15e199924-1_BAD_TERMIN"/>
  976. <xs:element name="BAD_TV_MULTIROOM_OR_JEDEN_TV"
  977. type="xs:string"
  978. id="_2_MARKETING___d15e199925-1_BAD_TV_MUL"/>
  979. <xs:element name="BAD_TV_CHCE_ZAMAWIAC_PAKIETY_OR_WYSTARCZY_ZAMOWIONY"
  980. type="xs:string"
  981. id="_2_MARKETING___d15e199926-1_BAD_TV_CHC"/>
  982. <xs:element name="BAD_TV_CHCE_NAGRYWAC_INNY_KANAL_OR_TEN_SAM_CO_OGLADAM"
  983. type="xs:string"
  984. id="_2_MARKETING___d15e199928-1_BAD_TV_CHC"/>
  985. <xs:element name="BAD_TV_WYPASIONY_BOX_OR_WYPASIONY_WLASNY_TV"
  986. type="xs:string"
  987. id="_2_MARKETING___d15e199929-1_BAD_TV_WYP"/>
  988. <xs:element name="BAD_TV_PAKIET_KILKADZIESIAT_DOBRYCH_KAN_OR_SETKI_ROZNYCH"
  989. type="xs:string"
  990. id="_2_MARKETING___d15e199930-1_BAD_TV_PAK"/>
  991. <xs:element name="BAD_TV_WOLE_HD_DROZEJ_OR_SD_TANIEJ"
  992. type="xs:string"
  993. id="_2_MARKETING___d15e199931-1_BAD_TV_WOL"/>
  994. <xs:element name="BAD_TV_CHCE_VOD_OPERATORA_OR_WOLE_SMART_TV_LUB_WYPOZYCZALNIE"
  995. type="xs:string"
  996. id="_2_MARKETING___d15e199932-1_BAD_TV_CHC"/>
  997. <xs:element name="BAD_CHCE_LOKALNY_MONITORING_OR_NIE_INTERESUJE_MNIE_TO"
  998. type="xs:string"
  999. id="_2_MARKETING___d15e199933-1_BAD_CHCE_L"/>
  1000. <xs:element name="BAD_CHCE_LOKALNE_TV_OR_NIE_OGLADAM_LOK_TV"
  1001. type="xs:string"
  1002. id="_2_MARKETING___d15e199934-1_BAD_CHCE_L"/>
  1003. <xs:element name="BAD_TEL_CHCE_USL_VOICE2MAIL_OR_WOLE_SEKRETARKE"
  1004. type="xs:string"
  1005. id="_2_MARKETING___d15e199935-1_BAD_TEL_CH"/>
  1006. <xs:element name="BAD_TEL_CHCE_DARMOWE_MIEDZYNARODOWE_OR_LOKALNE_KRAJOWE"
  1007. type="xs:string"
  1008. id="_2_MARKETING___d15e199936-1_BAD_TEL_CH"/>
  1009. <xs:element name="BAD_TEL_DZWONIE_NA_KOMORKI_OR_STACJONARNE"
  1010. type="xs:string"
  1011. id="_2_MARKETING___d15e199937-1_BAD_TEL_DZ"/>
  1012. <xs:element name="BAD_TEL_WOLE_WIECEJ_DANYCH_MVNO_OR_DARMOWYCH_MINUT"
  1013. type="xs:string"
  1014. id="_2_MARKETING___d15e199938-1_BAD_TEL_WO"/>
  1015. <xs:element name="BAD_TEL_WOLE_GSM_W_PAKIECIE_U_ISP_OR_KUPIE_GO_U_OPER_GSM"
  1016. type="xs:string"
  1017. id="_2_MARKETING___d15e199940-1_BAD_TEL_WO"/>
  1018. <xs:element name="BAD_MAX_CENA_ZA_DOBRY_PAKIET_TV_TEL_NET"
  1019. type="xs:string"
  1020. id="_2_MARKETING___d15e199941-1_BAD_MAX_CE"/>
  1021. <xs:element name="BAD_DOBRA_CENA_ZA_DOBRY_PAKIET_TV_TEL_NET"
  1022. type="xs:string"
  1023. id="_2_MARKETING___d15e199942-1_BAD_DOBRA_"/>
  1024. <xs:element name="BAD_PLEC"
  1025. type="xs:string"
  1026. id="_2_MARKETING___d15e199943-1_BAD_PLEC"/>
  1027. <xs:element name="BAD_WIELKOSC_MIASTA"
  1028. type="xs:string"
  1029. id="_2_MARKETING___d15e199944-1_BAD_WIELKO"/>
  1030. <xs:element name="BAD_UCZE_SIE"
  1031. type="xs:string"
  1032. id="_2_MARKETING___d15e199945-1_BAD_UCZE_S"/>
  1033. <xs:element name="SYNC_SQIX_STATUS"
  1034. type="xs:string"
  1035. id="_2_MARKETING___d15e199946-1_SYNC_SQIX_"/>
  1036. <xs:element name="id_13102"
  1037. type="xs:integer"
  1038. id="_2_MARKETING___d15e199947-1_id_13102"/>
  1039. <xs:element name="A_UPDATE_DATE"
  1040. type="xs:token"
  1041. id="_2_MARKETING___d15e199948-1_A_UPDATE_D"/>
  1042. <xs:element name="CRM_LISTA_ZASOBOW_ID"
  1043. type="xs:integer"
  1044. id="_2_MARKETING___d15e199949-1_CRM_LISTA_"/>
  1045. <xs:element name="BUSINESS"
  1046. type="xs:string"
  1047. id="_2_MARKETING___d15e199950-1_BUSINESS"/>
  1048. <xs:element name="ID_PROJECT"
  1049. type="xs:integer"
  1050. id="_2_MARKETING___d15e199952-1_ID_PROJECT"/>
  1051. <!--#272 found ignored the_geom-->
  1052. <!--#272 found ignored S_ADDRESS_CITY-->
  1053. <!--#272 found ignored BAD_CHCE_LOKALNE_TV_OR_NIE_OGLADAM_LOK_TV-->
  1054. <!--#272 found ignored BAD_TEL_CHCE_USL_VOICE2MAIL_OR_WOLE_SEKRETARKE-->
  1055. <!--#272 found ignored BAD_TEL_CHCE_DARMOWE_MIEDZYNARODOWE_OR_LOKALNE_KRAJOWE-->
  1056. <!--#272 found ignored BAD_TEL_DZWONIE_NA_KOMORKI_OR_STACJONARNE-->
  1057. <!--#272 found ignored BAD_TEL_WOLE_WIECEJ_DANYCH_MVNO_OR_DARMOWYCH_MINUT-->
  1058. <!--#272 found ignored BAD_TEL_WOLE_GSM_W_PAKIECIE_U_ISP_OR_KUPIE_GO_U_OPER_GSM-->
  1059. <!--#272 found ignored BAD_MAX_CENA_ZA_DOBRY_PAKIET_TV_TEL_NET-->
  1060. <!--#272 found ignored BAD_DOBRA_CENA_ZA_DOBRY_PAKIET_TV_TEL_NET-->
  1061. <!--#272 found ignored BAD_PLEC-->
  1062. <!--#272 found ignored BAD_WIELKOSC_MIASTA-->
  1063. <!--#272 found ignored L_APPOITMENT_DATE-->
  1064. <!--#272 found ignored BAD_UCZE_SIE-->
  1065. <!--#272 found ignored A_RECORD_CREATE_DATE-->
  1066. <!--#272 found ignored A_RECORD_CREATE_AUTHOR-->
  1067. <!--#272 found ignored A_RECORD_UPDATE_DATE-->
  1068. <!--#272 found ignored A_RECORD_UPDATE_AUTHOR-->
  1069. <!--#272 found ignored A_ADM_COMPANY-->
  1070. <!--#272 found ignored A_CLASSIFIED-->
  1071. <!--#272 found ignored TAB_UPDATE_DATE-->
  1072. <!--#272 found ignored TAB_UPDATE_INFO-->
  1073. <!--#272 found ignored TAB_UPDATE_STAT-->
  1074. <!--#272 found ignored L_APPOITMENT_USER-->
  1075. <!--#288 unsupported yet @ref p5_zasob_36:ADMIN_USERS-->
  1076. <!--#414-A found adding p5_zasob_36:ADMIN_USERS, $prototype_NamespacePrefix = default_db__x3A__USERS2_MARKETING-->
  1077. <xs:element ref="default_db__x3A__ADMIN_USERS:ADMIN_USERS"
  1078. minOccurs="0"
  1079. id="_2_MARKETING___d15e199980-1">
  1080. <xs:annotation>
  1081. <xs:appinfo>
  1082. <system_cache__appinfo:flat_relation_cache>
  1083. <system_cache__appinfo:source system_cache__appinfo:name="L_APPOITMENT_USER"
  1084. system_cache__appinfo:xpath="default_db__x3A__ADMIN_USERS:ADMIN_USERS/ADM_ACCOUNT"/>
  1085. </system_cache__appinfo:flat_relation_cache>
  1086. </xs:appinfo>
  1087. </xs:annotation>
  1088. </xs:element>
  1089. <!--#272 found ignored SYNC_SQIX_STATUS-->
  1090. <!--#272 found ignored A_STATUS_CURRENT-->
  1091. <!--#272 found ignored id_13102-->
  1092. <!--#272 found ignored L_APPOITMENT_PERIOD-->
  1093. <!--#272 found ignored L_APPOITMENT_TYPE-->
  1094. <!--#272 found ignored L_APPOITMENT_INFO-->
  1095. <!--#272 found ignored P_NAME-->
  1096. <!--#272 found ignored P_PHONE-->
  1097. <!--#272 found ignored BUSINESS-->
  1098. <!--#272 found ignored M_REWIR-->
  1099. <!--#288 unsupported yet @ref p5_zasob_36:MK_Rewiry-->
  1100. <!--#414-A found adding p5_zasob_36:MK_Rewiry, $prototype_NamespacePrefix = default_db__x3A__USERS2_MARKETING-->
  1101. <xs:element ref="default_db__x3A__MK_Rewiry:MK_Rewiry"
  1102. minOccurs="0"
  1103. id="_2_MARKETING___d15e199998-1">
  1104. <xs:annotation>
  1105. <xs:appinfo>
  1106. <system_cache__appinfo:flat_relation_cache>
  1107. <system_cache__appinfo:source system_cache__appinfo:name="M_REWIR"
  1108. system_cache__appinfo:xpath="default_db__x3A__MK_Rewiry:MK_Rewiry/NAZWA_REWI"/>
  1109. </system_cache__appinfo:flat_relation_cache>
  1110. </xs:appinfo>
  1111. </xs:annotation>
  1112. </xs:element>
  1113. <!--#272 found ignored ID_PROJECT-->
  1114. <!--#288 unsupported yet @ref p5_zasob_36:IN7_MK_BAZA_DYSTRYBUCJI-->
  1115. <!--#414-A found adding p5_zasob_36:IN7_MK_BAZA_DYSTRYBUCJI, $prototype_NamespacePrefix = default_db__x3A__USERS2_MARKETING-->
  1116. <xs:element ref="default_db__x3A__IN7_MK_BAZA_DYSTRYBUCJI:IN7_MK_BAZA_DYSTRYBUCJI"
  1117. minOccurs="0"
  1118. id="_2_MARKETING___d15e200006-1">
  1119. <xs:annotation>
  1120. <xs:appinfo>
  1121. <system_cache__appinfo:flat_relation_cache>
  1122. <system_cache__appinfo:source system_cache__appinfo:name="ID_PROJECT"
  1123. system_cache__appinfo:xpath="default_db__x3A__IN7_MK_BAZA_DYSTRYBUCJI:IN7_MK_BAZA_DYSTRYBUCJI/ID"/>
  1124. </system_cache__appinfo:flat_relation_cache>
  1125. </xs:appinfo>
  1126. </xs:annotation>
  1127. </xs:element>
  1128. <!--#272 found ignored __MK_Rewiry__STATUS-->
  1129. <!--#272 found ignored ID-->
  1130. <!--#288 unsupported yet @ref p5_zasob_36:USERS2_MARKETING-->
  1131. <!--#414-A found adding p5_zasob_36:USERS2_MARKETING, $prototype_NamespacePrefix = default_db__x3A__USERS2_MARKETING-->
  1132. <xs:element ref="default_db__x3A__USERS2_MARKETING:USERS2_MARKETING"
  1133. minOccurs="0"
  1134. id="_2_MARKETING___d15e200015-1">
  1135. <xs:annotation>
  1136. <xs:appinfo>
  1137. <system_cache__appinfo:flat_relation_cache>
  1138. <system_cache__appinfo:source system_cache__appinfo:name="ID"
  1139. system_cache__appinfo:xpath="default_db__x3A__USERS2_MARKETING:USERS2_MARKETING/ID"/>
  1140. </system_cache__appinfo:flat_relation_cache>
  1141. </xs:appinfo>
  1142. </xs:annotation>
  1143. </xs:element>
  1144. <!--#272 found ignored P_OTHER_INFO-->
  1145. <!--#272 found ignored A_PROBLEM_DESC-->
  1146. <!--#272 found ignored A_PROBLEM-->
  1147. <!--#272 found ignored A_ID_USERS2-->
  1148. <!--#272 found ignored ID_BILLING_USERS-->
  1149. <!--#272 found ignored ID_SERVICES-->
  1150. <!--#272 found ignored A_PROBLEM_DATE-->
  1151. <!--#272 found ignored A_STATUS-->
  1152. <!--#272 found ignored A_STATUS_INFO-->
  1153. <!--#272 found ignored ADMIN_USERS_ID-->
  1154. <!--#272 found ignored A_UPDATE_DATE-->
  1155. <!--#272 found ignored S_ALIAS-->
  1156. <!--#272 found ignored S_ADDRESS_POST_CODE-->
  1157. <!--#272 found ignored S_ADDRESS_POST_OFFICE-->
  1158. <!--#272 found ignored S_ADDRESS_HOUSE-->
  1159. <!--#272 found ignored S_OTHER_INFO-->
  1160. <!--#272 found ignored S_VIP_LEVEL-->
  1161. <!--#272 found ignored S_VIP_DESC-->
  1162. <!--#272 found ignored T_NETWORK_SERVER-->
  1163. <!--#272 found ignored T_TELBOX_ADDRESS-->
  1164. <!--#272 found ignored CRM_LISTA_ZASOBOW_ID-->
  1165. <!--#288 unsupported yet @ref p5_zasob_36:CRM_LISTA_ZASOBOW-->
  1166. <!--#414-A found adding p5_zasob_36:CRM_LISTA_ZASOBOW, $prototype_NamespacePrefix = default_db__x3A__USERS2_MARKETING-->
  1167. <xs:element ref="default_db__x3A__CRM_LISTA_ZASOBOW:CRM_LISTA_ZASOBOW"
  1168. minOccurs="0"
  1169. id="_2_MARKETING___d15e200044-1">
  1170. <xs:annotation>
  1171. <xs:appinfo>
  1172. <system_cache__appinfo:flat_relation_cache>
  1173. <system_cache__appinfo:source system_cache__appinfo:name="CRM_LISTA_ZASOBOW_ID"
  1174. system_cache__appinfo:xpath="default_db__x3A__CRM_LISTA_ZASOBOW:CRM_LISTA_ZASOBOW/ID"/>
  1175. </system_cache__appinfo:flat_relation_cache>
  1176. </xs:appinfo>
  1177. </xs:annotation>
  1178. </xs:element>
  1179. <!--#272 found ignored T_TELBOX_PORT-->
  1180. <!--#272 found ignored T_WORKPOINTS-->
  1181. <!--#272 found ignored T_WORKPOINTS_VALUE-->
  1182. <!--#272 found ignored T_WORKPOINTS_TYPE-->
  1183. <!--#272 found ignored T_WORKPOINTS_USER-->
  1184. <!--#272 found ignored T_WORKPOINTS_DATE-->
  1185. <!--#272 found ignored T_PENALTIES-->
  1186. <!--#272 found ignored T_PENALTIES_TYPE-->
  1187. <!--#272 found ignored T_PENALTIES_VALUE-->
  1188. <!--#272 found ignored P_BILLING_NO-->
  1189. <!--#272 found ignored P_NIP-->
  1190. <!--#272 found ignored P_PESEL-->
  1191. <!--#272 found ignored P_OTHER_DOC-->
  1192. <!--#272 found ignored P_FAX-->
  1193. <!--#272 found ignored P_CONTACT_PERSON-->
  1194. <!--#272 found ignored P_ADDRESS_CITY-->
  1195. <!--#272 found ignored P_ADDRESS_STREET-->
  1196. <!--#272 found ignored P_ADDRESS_POST_CODE-->
  1197. <!--#272 found ignored P_ADDRESS_POST_OFFICE-->
  1198. <!--#272 found ignored P_ADDRESS_HOUSE-->
  1199. <!--#272 found ignored I_BAD_DATE-->
  1200. <!--#272 found ignored T_WORKPOINTS_PROCES-->
  1201. <!--#272 found ignored I_OPER-->
  1202. <!--#272 found ignored I_PAY-->
  1203. <!--#272 found ignored I_OPER_ZAD-->
  1204. <!--#272 found ignored I_OPER_FIN-->
  1205. <!--#272 found ignored I_OPER_ZAINT-->
  1206. <!--#272 found ignored T_BAD_DATE-->
  1207. <!--#272 found ignored T_OPER-->
  1208. <!--#272 found ignored T_PAY-->
  1209. <!--#272 found ignored T_OPER_ZAD-->
  1210. <!--#272 found ignored T_OPER_FIN-->
  1211. <!--#272 found ignored P_ACCOUNT-->
  1212. <!--#272 found ignored T_OPER_ZAINT-->
  1213. <!--#272 found ignored TV_BAD_DATE-->
  1214. <!--#272 found ignored TV_OPER-->
  1215. <!--#272 found ignored TV_PAY-->
  1216. <!--#272 found ignored TV_OPER_ZAD-->
  1217. <!--#272 found ignored TV_OPER_FIN-->
  1218. <!--#272 found ignored TV_OPER_ZAINT-->
  1219. <!--#272 found ignored BOK_ZAD-->
  1220. <!--#272 found ignored BOK_BAD_DATE-->
  1221. <!--#272 found ignored BIZ_BAD_DATE-->
  1222. <!--#272 found ignored T_TELBOX_BUILDING_IN-->
  1223. <!--#288 unsupported yet @ref p5_zasob_36:BUILDINGS-->
  1224. <!--#414-A found adding p5_zasob_36:BUILDINGS, $prototype_NamespacePrefix = default_db__x3A__USERS2_MARKETING-->
  1225. <xs:element ref="default_db__x3A__BUILDINGS:BUILDINGS"
  1226. minOccurs="0"
  1227. id="_2_MARKETING___d15e200096-1">
  1228. <xs:annotation>
  1229. <xs:appinfo>
  1230. <system_cache__appinfo:flat_relation_cache>
  1231. <system_cache__appinfo:source system_cache__appinfo:name="T_TELBOX_BUILDING_IN"
  1232. system_cache__appinfo:xpath="default_db__x3A__BUILDINGS:BUILDINGS/S_ADDRESS_STREET"/>
  1233. </system_cache__appinfo:flat_relation_cache>
  1234. </xs:appinfo>
  1235. </xs:annotation>
  1236. </xs:element>
  1237. <!--#272 found ignored BIZ_VOIP_ZAINT-->
  1238. <!--#272 found ignored BIZ_SUPPORT_ZAINT-->
  1239. <!--#272 found ignored BIZ_PROCESY5_ZAINT-->
  1240. <!--#272-A found adding INTERNET_STATUS, $prototype_NamespacePrefix = default_db__x3A__USERS2_MARKETING-->
  1241. <xs:element xmlns:p5="https://biuro.biall-net.pl/wfs"
  1242. name="INTERNET_STATUS"
  1243. p5:id_zasob="3493"
  1244. minOccurs="1"
  1245. maxOccurs="1"
  1246. p5:label="Status usł. Internet"
  1247. id="_2_MARKETING___d15e200105-1_INTERNET_S">
  1248. <xs:annotation>
  1249. <xs:documentation>INTERNET_STATUS Informacje z bazy billingowej/technicznej o tym z jakich usług korzysta/korzystał KLIENT.</xs:documentation>
  1250. </xs:annotation>
  1251. </xs:element>
  1252. <!--#272 found ignored S_KLATKA-->
  1253. <!--#272 found ignored P_FLOOR_CONTROL-->
  1254. <!--#272 found ignored BAD_WYS_JAKOSC_OR_NISKA_CENA-->
  1255. <!--#272 found ignored BAD_KROTKA_UMOWA_OR_DLUGI_KONTRAKT_UPUST-->
  1256. <!--#272 found ignored BAD_KONTAKT_CALL_CENTER_EBOK_OR_LOKALNY_BOK-->
  1257. <!--#272 found ignored BAD_OFERTY_ULOTK_PLAKATY_OR_MASS_MEDIA-->
  1258. <!--#272 found ignored S_ADDRESS_STREET-->
  1259. <!--#272 found ignored BAD_TERMIN_INSTALACJI_TERAZ_OR_TANIO_POTEM-->
  1260. <!--#272 found ignored BAD_TV_MULTIROOM_OR_JEDEN_TV-->
  1261. <!--#272 found ignored BAD_TV_CHCE_ZAMAWIAC_PAKIETY_OR_WYSTARCZY_ZAMOWIONY-->
  1262. <!--#272 found ignored BAD_TV_CHCE_NAGRYWAC_INNY_KANAL_OR_TEN_SAM_CO_OGLADAM-->
  1263. <!--#272 found ignored BAD_TV_WYPASIONY_BOX_OR_WYPASIONY_WLASNY_TV-->
  1264. <!--#272 found ignored BAD_TV_PAKIET_KILKADZIESIAT_DOBRYCH_KAN_OR_SETKI_ROZNYCH-->
  1265. <!--#272 found ignored BAD_TV_WOLE_HD_DROZEJ_OR_SD_TANIEJ-->
  1266. <!--#272 found ignored BAD_TV_CHCE_VOD_OPERATORA_OR_WOLE_SMART_TV_LUB_WYPOZYCZALNIE-->
  1267. <!--#272 found ignored BAD_CHCE_LOKALNY_MONITORING_OR_NIE_INTERESUJE_MNIE_TO-->
  1268. <!--#272 found ignored A_STATUS_LASTCHANGE_DATE-->
  1269. </xs:sequence>
  1270. <xs:assert test="translate(date:difference(I_BAD_DATE, date:date-time()), 'PD', '') &lt; 180"
  1271. id="_2_MARKETING___d15e200126-1"/>
  1272. </xs:restriction>
  1273. </xs:complexContent>
  1274. </xs:complexType>
  1275. <xs:element name="USERS2_MARKETING_BN_FRESH"
  1276. type="default_db__x3A__USERS2_MARKETING:USERS2_MARKETING_BN_FRESH"
  1277. id="_2_MARKETING___d15e200127-1_USERS2_MAR"/>
  1278. <xs:complexType name="USERS2_MARKETING_OBCY_OLD"
  1279. id="_2_MARKETING___d15e200128-1_USERS2_MAR">
  1280. <xs:complexContent id="_2_MARKETING___d15e200129-1">
  1281. <xs:restriction base="default_db__x3A__USERS2_MARKETING:USERS2_MARKETING">
  1282. <xs:sequence id="_2_MARKETING___d15e200131-1">
  1283. <xs:element name="the_geom"
  1284. type="gml:AbstractFeatureType"
  1285. id="_2_MARKETING___d15e200132-1_the_geom">
  1286. <xs:annotation>
  1287. <xs:documentation>Dane geograficzne obiektu - linia, punkt, polygon</xs:documentation>
  1288. </xs:annotation>
  1289. </xs:element>
  1290. <xs:element name="A_STATUS"
  1291. type="default_db__x3A__USERS2_MARKETING:A_STATUS_Type"
  1292. id="_2_MARKETING___d15e200136-1_A_STATUS"/>
  1293. <xs:element name="A_STATUS_INFO"
  1294. type="xs:string"
  1295. id="_2_MARKETING___d15e200137-1_A_STATUS_I"/>
  1296. <xs:element name="L_APPOITMENT_USER"
  1297. type="xs:string"
  1298. id="_2_MARKETING___d15e200138-1_L_APPOITME"/>
  1299. <xs:element name="A_CLASSIFIED"
  1300. type="xs:string"
  1301. id="_2_MARKETING___d15e200139-1_A_CLASSIFI"/>
  1302. <xs:element name="A_ADM_COMPANY"
  1303. type="xs:string"
  1304. id="_2_MARKETING___d15e200140-1_A_ADM_COMP"/>
  1305. <xs:element name="ID" type="xs:integer" id="_2_MARKETING___d15e200141-1_ID"/>
  1306. <xs:element name="ADMIN_USERS_ID"
  1307. type="xs:integer"
  1308. id="_2_MARKETING___d15e200142-1_ADMIN_USER"/>
  1309. <xs:element name="A_ID_USERS2"
  1310. type="xs:integer"
  1311. id="_2_MARKETING___d15e200143-1_A_ID_USERS"/>
  1312. <xs:element name="ID_BILLING_USERS"
  1313. type="xs:integer"
  1314. id="_2_MARKETING___d15e200144-1_ID_BILLING"/>
  1315. <xs:element name="ID_SERVICES"
  1316. type="xs:integer"
  1317. id="_2_MARKETING___d15e200145-1_ID_SERVICE"/>
  1318. <xs:element name="A_RECORD_CREATE_DATE"
  1319. type="xs:token"
  1320. id="_2_MARKETING___d15e200147-1_A_RECORD_C"/>
  1321. <xs:element name="A_RECORD_CREATE_AUTHOR"
  1322. type="xs:string"
  1323. id="_2_MARKETING___d15e200148-1_A_RECORD_C"/>
  1324. <xs:element name="A_RECORD_UPDATE_DATE"
  1325. type="xs:token"
  1326. id="_2_MARKETING___d15e200149-1_A_RECORD_U"/>
  1327. <xs:element name="A_RECORD_UPDATE_AUTHOR"
  1328. type="xs:string"
  1329. id="_2_MARKETING___d15e200150-1_A_RECORD_U"/>
  1330. <xs:element name="TAB_UPDATE_STAT"
  1331. type="xs:string"
  1332. id="_2_MARKETING___d15e200151-1_TAB_UPDATE"/>
  1333. <xs:element name="TAB_UPDATE_DATE"
  1334. type="xs:token"
  1335. id="_2_MARKETING___d15e200152-1_TAB_UPDATE"/>
  1336. <xs:element name="TAB_UPDATE_INFO"
  1337. type="xs:string"
  1338. id="_2_MARKETING___d15e200153-1_TAB_UPDATE"/>
  1339. <xs:element name="L_APPOITMENT_DATE"
  1340. type="xs:token"
  1341. id="_2_MARKETING___d15e200154-1_L_APPOITME"/>
  1342. <xs:element name="L_APPOITMENT_PERIOD"
  1343. type="xs:string"
  1344. id="_2_MARKETING___d15e200155-1_L_APPOITME"/>
  1345. <xs:element name="L_APPOITMENT_INFO"
  1346. type="xs:string"
  1347. id="_2_MARKETING___d15e200156-1_L_APPOITME"/>
  1348. <xs:element name="L_APPOITMENT_TYPE"
  1349. type="xs:string"
  1350. id="_2_MARKETING___d15e200157-1_L_APPOITME"/>
  1351. <xs:element name="A_PROBLEM"
  1352. type="xs:string"
  1353. id="_2_MARKETING___d15e200159-1_A_PROBLEM"/>
  1354. <xs:element name="A_PROBLEM_DESC"
  1355. type="xs:string"
  1356. id="_2_MARKETING___d15e200160-1_A_PROBLEM_"/>
  1357. <xs:element name="A_PROBLEM_DATE"
  1358. type="xs:token"
  1359. id="_2_MARKETING___d15e200161-1_A_PROBLEM_"/>
  1360. <xs:element name="A_STATUS_CURRENT"
  1361. type="xs:string"
  1362. id="_2_MARKETING___d15e200162-1_A_STATUS_C"/>
  1363. <xs:element name="A_STATUS_LASTCHANGE_DATE"
  1364. type="xs:token"
  1365. id="_2_MARKETING___d15e200163-1_A_STATUS_L"/>
  1366. <xs:element name="S_ALIAS"
  1367. type="xs:string"
  1368. id="_2_MARKETING___d15e200164-1_S_ALIAS"/>
  1369. <xs:element name="S_ADDRESS_CITY"
  1370. type="xs:string"
  1371. id="_2_MARKETING___d15e200165-1_S_ADDRESS_"/>
  1372. <xs:element name="S_ADDRESS_POST_CODE"
  1373. type="xs:string"
  1374. id="_2_MARKETING___d15e200166-1_S_ADDRESS_"/>
  1375. <xs:element name="S_ADDRESS_POST_OFFICE"
  1376. type="xs:string"
  1377. id="_2_MARKETING___d15e200167-1_S_ADDRESS_"/>
  1378. <xs:element name="S_ADDRESS_STREET"
  1379. type="xs:string"
  1380. id="_2_MARKETING___d15e200168-1_S_ADDRESS_"/>
  1381. <xs:element name="S_ADDRESS_HOUSE"
  1382. type="xs:string"
  1383. id="_2_MARKETING___d15e200169-1_S_ADDRESS_"/>
  1384. <xs:element name="S_OTHER_INFO"
  1385. type="xs:string"
  1386. id="_2_MARKETING___d15e200171-1_S_OTHER_IN"/>
  1387. <xs:element name="S_VIP_LEVEL"
  1388. type="xs:string"
  1389. id="_2_MARKETING___d15e200172-1_S_VIP_LEVE"/>
  1390. <xs:element name="S_VIP_DESC"
  1391. type="xs:string"
  1392. id="_2_MARKETING___d15e200173-1_S_VIP_DESC"/>
  1393. <xs:element name="T_NETWORK_SERVER"
  1394. type="xs:string"
  1395. id="_2_MARKETING___d15e200174-1_T_NETWORK_"/>
  1396. <xs:element name="T_TELBOX_ADDRESS"
  1397. type="xs:string"
  1398. id="_2_MARKETING___d15e200175-1_T_TELBOX_A"/>
  1399. <xs:element name="T_TELBOX_PORT"
  1400. type="xs:string"
  1401. id="_2_MARKETING___d15e200176-1_T_TELBOX_P"/>
  1402. <xs:element name="T_WORKPOINTS"
  1403. type="xs:string"
  1404. id="_2_MARKETING___d15e200177-1_T_WORKPOIN"/>
  1405. <xs:element name="T_WORKPOINTS_PROCES"
  1406. type="xs:integer"
  1407. id="_2_MARKETING___d15e200178-1_T_WORKPOIN"/>
  1408. <xs:element name="T_WORKPOINTS_VALUE"
  1409. type="xs:string"
  1410. id="_2_MARKETING___d15e200179-1_T_WORKPOIN"/>
  1411. <xs:element name="T_WORKPOINTS_TYPE"
  1412. type="xs:string"
  1413. id="_2_MARKETING___d15e200180-1_T_WORKPOIN"/>
  1414. <xs:element name="T_WORKPOINTS_USER"
  1415. type="xs:string"
  1416. id="_2_MARKETING___d15e200181-1_T_WORKPOIN"/>
  1417. <xs:element name="T_WORKPOINTS_DATE"
  1418. type="xs:token"
  1419. id="_2_MARKETING___d15e200183-1_T_WORKPOIN"/>
  1420. <xs:element name="T_PENALTIES"
  1421. type="xs:string"
  1422. id="_2_MARKETING___d15e200184-1_T_PENALTIE"/>
  1423. <xs:element name="T_PENALTIES_TYPE"
  1424. type="xs:string"
  1425. id="_2_MARKETING___d15e200185-1_T_PENALTIE"/>
  1426. <xs:element name="T_PENALTIES_VALUE"
  1427. type="xs:string"
  1428. id="_2_MARKETING___d15e200186-1_T_PENALTIE"/>
  1429. <xs:element name="P_BILLING_NO"
  1430. type="xs:integer"
  1431. id="_2_MARKETING___d15e200187-1_P_BILLING_"/>
  1432. <xs:element name="P_NAME"
  1433. type="xs:string"
  1434. id="_2_MARKETING___d15e200188-1_P_NAME"/>
  1435. <xs:element name="P_NIP"
  1436. type="xs:string"
  1437. id="_2_MARKETING___d15e200189-1_P_NIP"/>
  1438. <xs:element name="P_PESEL"
  1439. type="xs:string"
  1440. id="_2_MARKETING___d15e200190-1_P_PESEL"/>
  1441. <xs:element name="P_OTHER_DOC"
  1442. type="xs:string"
  1443. id="_2_MARKETING___d15e200191-1_P_OTHER_DO"/>
  1444. <xs:element name="P_PHONE"
  1445. type="xs:string"
  1446. id="_2_MARKETING___d15e200192-1_P_PHONE"/>
  1447. <xs:element name="P_FAX"
  1448. type="xs:string"
  1449. id="_2_MARKETING___d15e200193-1_P_FAX"/>
  1450. <xs:element name="P_CONTACT_PERSON"
  1451. type="xs:string"
  1452. id="_2_MARKETING___d15e200195-1_P_CONTACT_"/>
  1453. <xs:element name="P_ADDRESS_CITY"
  1454. type="xs:string"
  1455. id="_2_MARKETING___d15e200196-1_P_ADDRESS_"/>
  1456. <xs:element name="P_ADDRESS_POST_CODE"
  1457. type="xs:string"
  1458. id="_2_MARKETING___d15e200197-1_P_ADDRESS_"/>
  1459. <xs:element name="P_ADDRESS_POST_OFFICE"
  1460. type="xs:string"
  1461. id="_2_MARKETING___d15e200198-1_P_ADDRESS_"/>
  1462. <xs:element name="P_ADDRESS_STREET"
  1463. type="xs:string"
  1464. id="_2_MARKETING___d15e200199-1_P_ADDRESS_"/>
  1465. <xs:element name="P_ADDRESS_HOUSE"
  1466. type="xs:string"
  1467. id="_2_MARKETING___d15e200200-1_P_ADDRESS_"/>
  1468. <xs:element name="P_OTHER_INFO"
  1469. type="xs:string"
  1470. id="_2_MARKETING___d15e200201-1_P_OTHER_IN"/>
  1471. <xs:element name="T_TELBOX_BUILDING_IN"
  1472. type="xs:string"
  1473. id="_2_MARKETING___d15e200202-1_T_TELBOX_B"/>
  1474. <xs:element name="I_BAD_DATE"
  1475. type="default_db__x3A__USERS2_MARKETING:I_BAD_DATE_OLD"
  1476. id="_2_MARKETING___d15e200203-1_I_BAD_DATE"/>
  1477. <xs:element name="I_OPER"
  1478. type="default_db__x3A__USERS2_MARKETING:I_OPER_OBCY"
  1479. id="_2_MARKETING___d15e200204-1_I_OPER"/>
  1480. <xs:element name="I_PAY"
  1481. type="xs:double"
  1482. id="_2_MARKETING___d15e200205-1_I_PAY"/>
  1483. <xs:element name="I_OPER_ZAD"
  1484. type="xs:string"
  1485. id="_2_MARKETING___d15e200207-1_I_OPER_ZAD"/>
  1486. <xs:element name="I_OPER_FIN"
  1487. type="xs:token"
  1488. id="_2_MARKETING___d15e200208-1_I_OPER_FIN"/>
  1489. <xs:element name="I_OPER_ZAINT"
  1490. type="xs:string"
  1491. id="_2_MARKETING___d15e200209-1_I_OPER_ZAI"/>
  1492. <xs:element name="T_BAD_DATE"
  1493. type="xs:token"
  1494. id="_2_MARKETING___d15e200210-1_T_BAD_DATE"/>
  1495. <xs:element name="T_OPER"
  1496. type="xs:string"
  1497. id="_2_MARKETING___d15e200211-1_T_OPER"/>
  1498. <xs:element name="T_PAY"
  1499. type="xs:double"
  1500. id="_2_MARKETING___d15e200212-1_T_PAY"/>
  1501. <xs:element name="T_OPER_ZAD"
  1502. type="xs:string"
  1503. id="_2_MARKETING___d15e200213-1_T_OPER_ZAD"/>
  1504. <xs:element name="T_OPER_FIN"
  1505. type="xs:token"
  1506. id="_2_MARKETING___d15e200214-1_T_OPER_FIN"/>
  1507. <xs:element name="T_OPER_ZAINT"
  1508. type="xs:string"
  1509. id="_2_MARKETING___d15e200215-1_T_OPER_ZAI"/>
  1510. <xs:element name="TV_BAD_DATE"
  1511. type="xs:token"
  1512. id="_2_MARKETING___d15e200216-1_TV_BAD_DAT"/>
  1513. <xs:element name="TV_OPER"
  1514. type="xs:string"
  1515. id="_2_MARKETING___d15e200217-1_TV_OPER"/>
  1516. <xs:element name="TV_PAY"
  1517. type="xs:double"
  1518. id="_2_MARKETING___d15e200219-1_TV_PAY"/>
  1519. <xs:element name="TV_OPER_ZAD"
  1520. type="xs:string"
  1521. id="_2_MARKETING___d15e200220-1_TV_OPER_ZA"/>
  1522. <xs:element name="TV_OPER_FIN"
  1523. type="xs:token"
  1524. id="_2_MARKETING___d15e200221-1_TV_OPER_FI"/>
  1525. <xs:element name="TV_OPER_ZAINT"
  1526. type="xs:string"
  1527. id="_2_MARKETING___d15e200222-1_TV_OPER_ZA"/>
  1528. <xs:element name="BIZ_BAD_DATE"
  1529. type="xs:token"
  1530. id="_2_MARKETING___d15e200223-1_BIZ_BAD_DA"/>
  1531. <xs:element name="BIZ_VOIP_ZAINT"
  1532. type="xs:string"
  1533. id="_2_MARKETING___d15e200224-1_BIZ_VOIP_Z"/>
  1534. <xs:element name="BIZ_PROCESY5_ZAINT"
  1535. type="xs:string"
  1536. id="_2_MARKETING___d15e200225-1_BIZ_PROCES"/>
  1537. <xs:element name="BIZ_SUPPORT_ZAINT"
  1538. type="xs:string"
  1539. id="_2_MARKETING___d15e200226-1_BIZ_SUPPOR"/>
  1540. <xs:element name="M_REWIR"
  1541. type="xs:string"
  1542. id="_2_MARKETING___d15e200227-1_M_REWIR"/>
  1543. <xs:element name="__MK_Rewiry__STATUS"
  1544. type="xs:string"
  1545. id="_2_MARKETING___d15e200228-1___MK_Rewir"/>
  1546. <xs:element name="BOK_ZAD"
  1547. type="xs:string"
  1548. id="_2_MARKETING___d15e200229-1_BOK_ZAD"/>
  1549. <xs:element name="BOK_BAD_DATE"
  1550. type="xs:token"
  1551. id="_2_MARKETING___d15e200231-1_BOK_BAD_DA"/>
  1552. <xs:element name="P_FLOOR_CONTROL"
  1553. type="xs:string"
  1554. id="_2_MARKETING___d15e200232-1_P_FLOOR_CO"/>
  1555. <xs:element name="P_ACCOUNT"
  1556. type="xs:string"
  1557. id="_2_MARKETING___d15e200233-1_P_ACCOUNT"/>
  1558. <xs:element name="S_KLATKA"
  1559. type="xs:string"
  1560. id="_2_MARKETING___d15e200234-1_S_KLATKA"/>
  1561. <xs:element name="BAD_WYS_JAKOSC_OR_NISKA_CENA"
  1562. type="xs:string"
  1563. id="_2_MARKETING___d15e200235-1_BAD_WYS_JA"/>
  1564. <xs:element name="BAD_KROTKA_UMOWA_OR_DLUGI_KONTRAKT_UPUST"
  1565. type="xs:string"
  1566. id="_2_MARKETING___d15e200236-1_BAD_KROTKA"/>
  1567. <xs:element name="BAD_KONTAKT_CALL_CENTER_EBOK_OR_LOKALNY_BOK"
  1568. type="xs:string"
  1569. id="_2_MARKETING___d15e200237-1_BAD_KONTAK"/>
  1570. <xs:element name="BAD_OFERTY_ULOTK_PLAKATY_OR_MASS_MEDIA"
  1571. type="xs:string"
  1572. id="_2_MARKETING___d15e200238-1_BAD_OFERTY"/>
  1573. <xs:element name="BAD_TERMIN_INSTALACJI_TERAZ_OR_TANIO_POTEM"
  1574. type="xs:string"
  1575. id="_2_MARKETING___d15e200239-1_BAD_TERMIN"/>
  1576. <xs:element name="BAD_TV_MULTIROOM_OR_JEDEN_TV"
  1577. type="xs:string"
  1578. id="_2_MARKETING___d15e200240-1_BAD_TV_MUL"/>
  1579. <xs:element name="BAD_TV_CHCE_ZAMAWIAC_PAKIETY_OR_WYSTARCZY_ZAMOWIONY"
  1580. type="xs:string"
  1581. id="_2_MARKETING___d15e200241-1_BAD_TV_CHC"/>
  1582. <xs:element name="BAD_TV_CHCE_NAGRYWAC_INNY_KANAL_OR_TEN_SAM_CO_OGLADAM"
  1583. type="xs:string"
  1584. id="_2_MARKETING___d15e200243-1_BAD_TV_CHC"/>
  1585. <xs:element name="BAD_TV_WYPASIONY_BOX_OR_WYPASIONY_WLASNY_TV"
  1586. type="xs:string"
  1587. id="_2_MARKETING___d15e200244-1_BAD_TV_WYP"/>
  1588. <xs:element name="BAD_TV_PAKIET_KILKADZIESIAT_DOBRYCH_KAN_OR_SETKI_ROZNYCH"
  1589. type="xs:string"
  1590. id="_2_MARKETING___d15e200245-1_BAD_TV_PAK"/>
  1591. <xs:element name="BAD_TV_WOLE_HD_DROZEJ_OR_SD_TANIEJ"
  1592. type="xs:string"
  1593. id="_2_MARKETING___d15e200246-1_BAD_TV_WOL"/>
  1594. <xs:element name="BAD_TV_CHCE_VOD_OPERATORA_OR_WOLE_SMART_TV_LUB_WYPOZYCZALNIE"
  1595. type="xs:string"
  1596. id="_2_MARKETING___d15e200247-1_BAD_TV_CHC"/>
  1597. <xs:element name="BAD_CHCE_LOKALNY_MONITORING_OR_NIE_INTERESUJE_MNIE_TO"
  1598. type="xs:string"
  1599. id="_2_MARKETING___d15e200248-1_BAD_CHCE_L"/>
  1600. <xs:element name="BAD_CHCE_LOKALNE_TV_OR_NIE_OGLADAM_LOK_TV"
  1601. type="xs:string"
  1602. id="_2_MARKETING___d15e200249-1_BAD_CHCE_L"/>
  1603. <xs:element name="BAD_TEL_CHCE_USL_VOICE2MAIL_OR_WOLE_SEKRETARKE"
  1604. type="xs:string"
  1605. id="_2_MARKETING___d15e200250-1_BAD_TEL_CH"/>
  1606. <xs:element name="BAD_TEL_CHCE_DARMOWE_MIEDZYNARODOWE_OR_LOKALNE_KRAJOWE"
  1607. type="xs:string"
  1608. id="_2_MARKETING___d15e200251-1_BAD_TEL_CH"/>
  1609. <xs:element name="BAD_TEL_DZWONIE_NA_KOMORKI_OR_STACJONARNE"
  1610. type="xs:string"
  1611. id="_2_MARKETING___d15e200252-1_BAD_TEL_DZ"/>
  1612. <xs:element name="BAD_TEL_WOLE_WIECEJ_DANYCH_MVNO_OR_DARMOWYCH_MINUT"
  1613. type="xs:string"
  1614. id="_2_MARKETING___d15e200253-1_BAD_TEL_WO"/>
  1615. <xs:element name="BAD_TEL_WOLE_GSM_W_PAKIECIE_U_ISP_OR_KUPIE_GO_U_OPER_GSM"
  1616. type="xs:string"
  1617. id="_2_MARKETING___d15e200255-1_BAD_TEL_WO"/>
  1618. <xs:element name="BAD_MAX_CENA_ZA_DOBRY_PAKIET_TV_TEL_NET"
  1619. type="xs:string"
  1620. id="_2_MARKETING___d15e200256-1_BAD_MAX_CE"/>
  1621. <xs:element name="BAD_DOBRA_CENA_ZA_DOBRY_PAKIET_TV_TEL_NET"
  1622. type="xs:string"
  1623. id="_2_MARKETING___d15e200257-1_BAD_DOBRA_"/>
  1624. <xs:element name="BAD_PLEC"
  1625. type="xs:string"
  1626. id="_2_MARKETING___d15e200258-1_BAD_PLEC"/>
  1627. <xs:element name="BAD_WIELKOSC_MIASTA"
  1628. type="xs:string"
  1629. id="_2_MARKETING___d15e200259-1_BAD_WIELKO"/>
  1630. <xs:element name="BAD_UCZE_SIE"
  1631. type="xs:string"
  1632. id="_2_MARKETING___d15e200260-1_BAD_UCZE_S"/>
  1633. <xs:element name="SYNC_SQIX_STATUS"
  1634. type="xs:string"
  1635. id="_2_MARKETING___d15e200261-1_SYNC_SQIX_"/>
  1636. <xs:element name="id_13102"
  1637. type="xs:integer"
  1638. id="_2_MARKETING___d15e200262-1_id_13102"/>
  1639. <xs:element name="A_UPDATE_DATE"
  1640. type="xs:token"
  1641. id="_2_MARKETING___d15e200263-1_A_UPDATE_D"/>
  1642. <xs:element name="CRM_LISTA_ZASOBOW_ID"
  1643. type="xs:integer"
  1644. id="_2_MARKETING___d15e200264-1_CRM_LISTA_"/>
  1645. <xs:element name="BUSINESS"
  1646. type="xs:string"
  1647. id="_2_MARKETING___d15e200265-1_BUSINESS"/>
  1648. <xs:element name="ID_PROJECT"
  1649. type="xs:integer"
  1650. id="_2_MARKETING___d15e200267-1_ID_PROJECT"/>
  1651. <!--#272 found ignored the_geom-->
  1652. <!--#272 found ignored S_ADDRESS_CITY-->
  1653. <!--#272 found ignored BAD_CHCE_LOKALNE_TV_OR_NIE_OGLADAM_LOK_TV-->
  1654. <!--#272 found ignored BAD_TEL_CHCE_USL_VOICE2MAIL_OR_WOLE_SEKRETARKE-->
  1655. <!--#272 found ignored BAD_TEL_CHCE_DARMOWE_MIEDZYNARODOWE_OR_LOKALNE_KRAJOWE-->
  1656. <!--#272 found ignored BAD_TEL_DZWONIE_NA_KOMORKI_OR_STACJONARNE-->
  1657. <!--#272 found ignored BAD_TEL_WOLE_WIECEJ_DANYCH_MVNO_OR_DARMOWYCH_MINUT-->
  1658. <!--#272 found ignored BAD_TEL_WOLE_GSM_W_PAKIECIE_U_ISP_OR_KUPIE_GO_U_OPER_GSM-->
  1659. <!--#272 found ignored BAD_MAX_CENA_ZA_DOBRY_PAKIET_TV_TEL_NET-->
  1660. <!--#272 found ignored BAD_DOBRA_CENA_ZA_DOBRY_PAKIET_TV_TEL_NET-->
  1661. <!--#272 found ignored BAD_PLEC-->
  1662. <!--#272 found ignored BAD_WIELKOSC_MIASTA-->
  1663. <!--#272 found ignored L_APPOITMENT_DATE-->
  1664. <!--#272 found ignored BAD_UCZE_SIE-->
  1665. <!--#272 found ignored A_RECORD_CREATE_DATE-->
  1666. <!--#272 found ignored A_RECORD_CREATE_AUTHOR-->
  1667. <!--#272 found ignored A_RECORD_UPDATE_DATE-->
  1668. <!--#272 found ignored A_RECORD_UPDATE_AUTHOR-->
  1669. <!--#272 found ignored A_ADM_COMPANY-->
  1670. <!--#272 found ignored A_CLASSIFIED-->
  1671. <!--#272 found ignored TAB_UPDATE_DATE-->
  1672. <!--#272 found ignored TAB_UPDATE_INFO-->
  1673. <!--#272 found ignored TAB_UPDATE_STAT-->
  1674. <!--#272 found ignored L_APPOITMENT_USER-->
  1675. <!--#288 unsupported yet @ref p5_zasob_36:ADMIN_USERS-->
  1676. <!--#414-A found adding p5_zasob_36:ADMIN_USERS, $prototype_NamespacePrefix = default_db__x3A__USERS2_MARKETING-->
  1677. <xs:element ref="default_db__x3A__ADMIN_USERS:ADMIN_USERS"
  1678. minOccurs="0"
  1679. id="_2_MARKETING___d15e200295-1">
  1680. <xs:annotation>
  1681. <xs:appinfo>
  1682. <system_cache__appinfo:flat_relation_cache>
  1683. <system_cache__appinfo:source system_cache__appinfo:name="L_APPOITMENT_USER"
  1684. system_cache__appinfo:xpath="default_db__x3A__ADMIN_USERS:ADMIN_USERS/ADM_ACCOUNT"/>
  1685. </system_cache__appinfo:flat_relation_cache>
  1686. </xs:appinfo>
  1687. </xs:annotation>
  1688. </xs:element>
  1689. <!--#272 found ignored SYNC_SQIX_STATUS-->
  1690. <!--#272 found ignored A_STATUS_CURRENT-->
  1691. <!--#272 found ignored id_13102-->
  1692. <!--#272 found ignored L_APPOITMENT_PERIOD-->
  1693. <!--#272 found ignored L_APPOITMENT_TYPE-->
  1694. <!--#272 found ignored L_APPOITMENT_INFO-->
  1695. <!--#272 found ignored P_NAME-->
  1696. <!--#272 found ignored P_PHONE-->
  1697. <!--#272 found ignored BUSINESS-->
  1698. <!--#272 found ignored M_REWIR-->
  1699. <!--#288 unsupported yet @ref p5_zasob_36:MK_Rewiry-->
  1700. <!--#414-A found adding p5_zasob_36:MK_Rewiry, $prototype_NamespacePrefix = default_db__x3A__USERS2_MARKETING-->
  1701. <xs:element ref="default_db__x3A__MK_Rewiry:MK_Rewiry"
  1702. minOccurs="0"
  1703. id="_2_MARKETING___d15e200313-1">
  1704. <xs:annotation>
  1705. <xs:appinfo>
  1706. <system_cache__appinfo:flat_relation_cache>
  1707. <system_cache__appinfo:source system_cache__appinfo:name="M_REWIR"
  1708. system_cache__appinfo:xpath="default_db__x3A__MK_Rewiry:MK_Rewiry/NAZWA_REWI"/>
  1709. </system_cache__appinfo:flat_relation_cache>
  1710. </xs:appinfo>
  1711. </xs:annotation>
  1712. </xs:element>
  1713. <!--#272 found ignored ID_PROJECT-->
  1714. <!--#288 unsupported yet @ref p5_zasob_36:IN7_MK_BAZA_DYSTRYBUCJI-->
  1715. <!--#414-A found adding p5_zasob_36:IN7_MK_BAZA_DYSTRYBUCJI, $prototype_NamespacePrefix = default_db__x3A__USERS2_MARKETING-->
  1716. <xs:element ref="default_db__x3A__IN7_MK_BAZA_DYSTRYBUCJI:IN7_MK_BAZA_DYSTRYBUCJI"
  1717. minOccurs="0"
  1718. id="_2_MARKETING___d15e200321-1">
  1719. <xs:annotation>
  1720. <xs:appinfo>
  1721. <system_cache__appinfo:flat_relation_cache>
  1722. <system_cache__appinfo:source system_cache__appinfo:name="ID_PROJECT"
  1723. system_cache__appinfo:xpath="default_db__x3A__IN7_MK_BAZA_DYSTRYBUCJI:IN7_MK_BAZA_DYSTRYBUCJI/ID"/>
  1724. </system_cache__appinfo:flat_relation_cache>
  1725. </xs:appinfo>
  1726. </xs:annotation>
  1727. </xs:element>
  1728. <!--#272 found ignored __MK_Rewiry__STATUS-->
  1729. <!--#272 found ignored ID-->
  1730. <!--#288 unsupported yet @ref p5_zasob_36:USERS2_MARKETING-->
  1731. <!--#414-A found adding p5_zasob_36:USERS2_MARKETING, $prototype_NamespacePrefix = default_db__x3A__USERS2_MARKETING-->
  1732. <xs:element ref="default_db__x3A__USERS2_MARKETING:USERS2_MARKETING"
  1733. minOccurs="0"
  1734. id="_2_MARKETING___d15e200330-1">
  1735. <xs:annotation>
  1736. <xs:appinfo>
  1737. <system_cache__appinfo:flat_relation_cache>
  1738. <system_cache__appinfo:source system_cache__appinfo:name="ID"
  1739. system_cache__appinfo:xpath="default_db__x3A__USERS2_MARKETING:USERS2_MARKETING/ID"/>
  1740. </system_cache__appinfo:flat_relation_cache>
  1741. </xs:appinfo>
  1742. </xs:annotation>
  1743. </xs:element>
  1744. <!--#272 found ignored P_OTHER_INFO-->
  1745. <!--#272 found ignored A_PROBLEM_DESC-->
  1746. <!--#272 found ignored A_PROBLEM-->
  1747. <!--#272 found ignored A_ID_USERS2-->
  1748. <!--#272 found ignored ID_BILLING_USERS-->
  1749. <!--#272 found ignored ID_SERVICES-->
  1750. <!--#272 found ignored A_PROBLEM_DATE-->
  1751. <!--#272 found ignored A_STATUS-->
  1752. <!--#272 found ignored A_STATUS_INFO-->
  1753. <!--#272 found ignored ADMIN_USERS_ID-->
  1754. <!--#272 found ignored A_UPDATE_DATE-->
  1755. <!--#272 found ignored S_ALIAS-->
  1756. <!--#272 found ignored S_ADDRESS_POST_CODE-->
  1757. <!--#272 found ignored S_ADDRESS_POST_OFFICE-->
  1758. <!--#272 found ignored S_ADDRESS_HOUSE-->
  1759. <!--#272 found ignored S_OTHER_INFO-->
  1760. <!--#272 found ignored S_VIP_LEVEL-->
  1761. <!--#272 found ignored S_VIP_DESC-->
  1762. <!--#272 found ignored T_NETWORK_SERVER-->
  1763. <!--#272 found ignored T_TELBOX_ADDRESS-->
  1764. <!--#272 found ignored CRM_LISTA_ZASOBOW_ID-->
  1765. <!--#288 unsupported yet @ref p5_zasob_36:CRM_LISTA_ZASOBOW-->
  1766. <!--#414-A found adding p5_zasob_36:CRM_LISTA_ZASOBOW, $prototype_NamespacePrefix = default_db__x3A__USERS2_MARKETING-->
  1767. <xs:element ref="default_db__x3A__CRM_LISTA_ZASOBOW:CRM_LISTA_ZASOBOW"
  1768. minOccurs="0"
  1769. id="_2_MARKETING___d15e200359-1">
  1770. <xs:annotation>
  1771. <xs:appinfo>
  1772. <system_cache__appinfo:flat_relation_cache>
  1773. <system_cache__appinfo:source system_cache__appinfo:name="CRM_LISTA_ZASOBOW_ID"
  1774. system_cache__appinfo:xpath="default_db__x3A__CRM_LISTA_ZASOBOW:CRM_LISTA_ZASOBOW/ID"/>
  1775. </system_cache__appinfo:flat_relation_cache>
  1776. </xs:appinfo>
  1777. </xs:annotation>
  1778. </xs:element>
  1779. <!--#272 found ignored T_TELBOX_PORT-->
  1780. <!--#272 found ignored T_WORKPOINTS-->
  1781. <!--#272 found ignored T_WORKPOINTS_VALUE-->
  1782. <!--#272 found ignored T_WORKPOINTS_TYPE-->
  1783. <!--#272 found ignored T_WORKPOINTS_USER-->
  1784. <!--#272 found ignored T_WORKPOINTS_DATE-->
  1785. <!--#272 found ignored T_PENALTIES-->
  1786. <!--#272 found ignored T_PENALTIES_TYPE-->
  1787. <!--#272 found ignored T_PENALTIES_VALUE-->
  1788. <!--#272 found ignored P_BILLING_NO-->
  1789. <!--#272 found ignored P_NIP-->
  1790. <!--#272 found ignored P_PESEL-->
  1791. <!--#272 found ignored P_OTHER_DOC-->
  1792. <!--#272 found ignored P_FAX-->
  1793. <!--#272 found ignored P_CONTACT_PERSON-->
  1794. <!--#272 found ignored P_ADDRESS_CITY-->
  1795. <!--#272 found ignored P_ADDRESS_STREET-->
  1796. <!--#272 found ignored P_ADDRESS_POST_CODE-->
  1797. <!--#272 found ignored P_ADDRESS_POST_OFFICE-->
  1798. <!--#272 found ignored P_ADDRESS_HOUSE-->
  1799. <!--#272 found ignored I_BAD_DATE-->
  1800. <!--#272 found ignored T_WORKPOINTS_PROCES-->
  1801. <!--#272 found ignored I_OPER-->
  1802. <!--#272 found ignored I_PAY-->
  1803. <!--#272 found ignored I_OPER_ZAD-->
  1804. <!--#272 found ignored I_OPER_FIN-->
  1805. <!--#272 found ignored I_OPER_ZAINT-->
  1806. <!--#272 found ignored T_BAD_DATE-->
  1807. <!--#272 found ignored T_OPER-->
  1808. <!--#272 found ignored T_PAY-->
  1809. <!--#272 found ignored T_OPER_ZAD-->
  1810. <!--#272 found ignored T_OPER_FIN-->
  1811. <!--#272 found ignored P_ACCOUNT-->
  1812. <!--#272 found ignored T_OPER_ZAINT-->
  1813. <!--#272 found ignored TV_BAD_DATE-->
  1814. <!--#272 found ignored TV_OPER-->
  1815. <!--#272 found ignored TV_PAY-->
  1816. <!--#272 found ignored TV_OPER_ZAD-->
  1817. <!--#272 found ignored TV_OPER_FIN-->
  1818. <!--#272 found ignored TV_OPER_ZAINT-->
  1819. <!--#272 found ignored BOK_ZAD-->
  1820. <!--#272 found ignored BOK_BAD_DATE-->
  1821. <!--#272 found ignored BIZ_BAD_DATE-->
  1822. <!--#272 found ignored T_TELBOX_BUILDING_IN-->
  1823. <!--#288 unsupported yet @ref p5_zasob_36:BUILDINGS-->
  1824. <!--#414-A found adding p5_zasob_36:BUILDINGS, $prototype_NamespacePrefix = default_db__x3A__USERS2_MARKETING-->
  1825. <xs:element ref="default_db__x3A__BUILDINGS:BUILDINGS"
  1826. minOccurs="0"
  1827. id="_2_MARKETING___d15e200411-1">
  1828. <xs:annotation>
  1829. <xs:appinfo>
  1830. <system_cache__appinfo:flat_relation_cache>
  1831. <system_cache__appinfo:source system_cache__appinfo:name="T_TELBOX_BUILDING_IN"
  1832. system_cache__appinfo:xpath="default_db__x3A__BUILDINGS:BUILDINGS/S_ADDRESS_STREET"/>
  1833. </system_cache__appinfo:flat_relation_cache>
  1834. </xs:appinfo>
  1835. </xs:annotation>
  1836. </xs:element>
  1837. <!--#272 found ignored BIZ_VOIP_ZAINT-->
  1838. <!--#272 found ignored BIZ_SUPPORT_ZAINT-->
  1839. <!--#272 found ignored BIZ_PROCESY5_ZAINT-->
  1840. <!--#272-A found adding INTERNET_STATUS, $prototype_NamespacePrefix = default_db__x3A__USERS2_MARKETING-->
  1841. <xs:element xmlns:p5="https://biuro.biall-net.pl/wfs"
  1842. name="INTERNET_STATUS"
  1843. p5:id_zasob="3493"
  1844. minOccurs="1"
  1845. maxOccurs="1"
  1846. p5:label="Status usł. Internet"
  1847. id="_2_MARKETING___d15e200420-1_INTERNET_S">
  1848. <xs:annotation>
  1849. <xs:documentation>INTERNET_STATUS Informacje z bazy billingowej/technicznej o tym z jakich usług korzysta/korzystał KLIENT.</xs:documentation>
  1850. </xs:annotation>
  1851. </xs:element>
  1852. <!--#272 found ignored S_KLATKA-->
  1853. <!--#272 found ignored P_FLOOR_CONTROL-->
  1854. <!--#272 found ignored BAD_WYS_JAKOSC_OR_NISKA_CENA-->
  1855. <!--#272 found ignored BAD_KROTKA_UMOWA_OR_DLUGI_KONTRAKT_UPUST-->
  1856. <!--#272 found ignored BAD_KONTAKT_CALL_CENTER_EBOK_OR_LOKALNY_BOK-->
  1857. <!--#272 found ignored BAD_OFERTY_ULOTK_PLAKATY_OR_MASS_MEDIA-->
  1858. <!--#272 found ignored S_ADDRESS_STREET-->
  1859. <!--#272 found ignored BAD_TERMIN_INSTALACJI_TERAZ_OR_TANIO_POTEM-->
  1860. <!--#272 found ignored BAD_TV_MULTIROOM_OR_JEDEN_TV-->
  1861. <!--#272 found ignored BAD_TV_CHCE_ZAMAWIAC_PAKIETY_OR_WYSTARCZY_ZAMOWIONY-->
  1862. <!--#272 found ignored BAD_TV_CHCE_NAGRYWAC_INNY_KANAL_OR_TEN_SAM_CO_OGLADAM-->
  1863. <!--#272 found ignored BAD_TV_WYPASIONY_BOX_OR_WYPASIONY_WLASNY_TV-->
  1864. <!--#272 found ignored BAD_TV_PAKIET_KILKADZIESIAT_DOBRYCH_KAN_OR_SETKI_ROZNYCH-->
  1865. <!--#272 found ignored BAD_TV_WOLE_HD_DROZEJ_OR_SD_TANIEJ-->
  1866. <!--#272 found ignored BAD_TV_CHCE_VOD_OPERATORA_OR_WOLE_SMART_TV_LUB_WYPOZYCZALNIE-->
  1867. <!--#272 found ignored BAD_CHCE_LOKALNY_MONITORING_OR_NIE_INTERESUJE_MNIE_TO-->
  1868. <!--#272 found ignored A_STATUS_LASTCHANGE_DATE-->
  1869. </xs:sequence>
  1870. <xs:assert test="translate(date:difference(I_BAD_DATE, date:date-time()), 'PD', '') &gt;= 180"
  1871. id="_2_MARKETING___d15e200441-1"/>
  1872. <xs:assert test="not(matches(I_OPER, '(BN)|(ND)'))"
  1873. id="_2_MARKETING___d15e200460-1"/>
  1874. </xs:restriction>
  1875. </xs:complexContent>
  1876. </xs:complexType>
  1877. <xs:element name="USERS2_MARKETING_OBCY_OLD"
  1878. type="default_db__x3A__USERS2_MARKETING:USERS2_MARKETING_OBCY_OLD"
  1879. id="_2_MARKETING___d15e200442-1_USERS2_MAR"/>
  1880. <xs:complexType name="USERS2_MARKETING_BN_OLD"
  1881. id="_2_MARKETING___d15e200443-1_USERS2_MAR">
  1882. <xs:complexContent id="_2_MARKETING___d15e200444-1">
  1883. <xs:restriction base="default_db__x3A__USERS2_MARKETING:USERS2_MARKETING">
  1884. <xs:sequence id="_2_MARKETING___d15e200446-1">
  1885. <xs:element name="the_geom"
  1886. type="gml:AbstractFeatureType"
  1887. id="_2_MARKETING___d15e200447-1_the_geom">
  1888. <xs:annotation>
  1889. <xs:documentation>Dane geograficzne obiektu - linia, punkt, polygon</xs:documentation>
  1890. </xs:annotation>
  1891. </xs:element>
  1892. <xs:element name="A_STATUS"
  1893. type="default_db__x3A__USERS2_MARKETING:A_STATUS_Type"
  1894. id="_2_MARKETING___d15e200451-1_A_STATUS"/>
  1895. <xs:element name="A_STATUS_INFO"
  1896. type="xs:string"
  1897. id="_2_MARKETING___d15e200452-1_A_STATUS_I"/>
  1898. <xs:element name="L_APPOITMENT_USER"
  1899. type="xs:string"
  1900. id="_2_MARKETING___d15e200453-1_L_APPOITME"/>
  1901. <xs:element name="A_CLASSIFIED"
  1902. type="xs:string"
  1903. id="_2_MARKETING___d15e200454-1_A_CLASSIFI"/>
  1904. <xs:element name="A_ADM_COMPANY"
  1905. type="xs:string"
  1906. id="_2_MARKETING___d15e200455-1_A_ADM_COMP"/>
  1907. <xs:element name="ID" type="xs:integer" id="_2_MARKETING___d15e200456-1_ID"/>
  1908. <xs:element name="ADMIN_USERS_ID"
  1909. type="xs:integer"
  1910. id="_2_MARKETING___d15e200457-1_ADMIN_USER"/>
  1911. <xs:element name="A_ID_USERS2"
  1912. type="xs:integer"
  1913. id="_2_MARKETING___d15e200458-1_A_ID_USERS"/>
  1914. <xs:element name="ID_BILLING_USERS"
  1915. type="xs:integer"
  1916. id="_2_MARKETING___d15e200459-1_ID_BILLING"/>
  1917. <xs:element name="ID_SERVICES"
  1918. type="xs:integer"
  1919. id="_2_MARKETING___d15e200460-1_ID_SERVICE"/>
  1920. <xs:element name="A_RECORD_CREATE_DATE"
  1921. type="xs:token"
  1922. id="_2_MARKETING___d15e200462-1_A_RECORD_C"/>
  1923. <xs:element name="A_RECORD_CREATE_AUTHOR"
  1924. type="xs:string"
  1925. id="_2_MARKETING___d15e200463-1_A_RECORD_C"/>
  1926. <xs:element name="A_RECORD_UPDATE_DATE"
  1927. type="xs:token"
  1928. id="_2_MARKETING___d15e200464-1_A_RECORD_U"/>
  1929. <xs:element name="A_RECORD_UPDATE_AUTHOR"
  1930. type="xs:string"
  1931. id="_2_MARKETING___d15e200465-1_A_RECORD_U"/>
  1932. <xs:element name="TAB_UPDATE_STAT"
  1933. type="xs:string"
  1934. id="_2_MARKETING___d15e200466-1_TAB_UPDATE"/>
  1935. <xs:element name="TAB_UPDATE_DATE"
  1936. type="xs:token"
  1937. id="_2_MARKETING___d15e200467-1_TAB_UPDATE"/>
  1938. <xs:element name="TAB_UPDATE_INFO"
  1939. type="xs:string"
  1940. id="_2_MARKETING___d15e200468-1_TAB_UPDATE"/>
  1941. <xs:element name="L_APPOITMENT_DATE"
  1942. type="xs:token"
  1943. id="_2_MARKETING___d15e200469-1_L_APPOITME"/>
  1944. <xs:element name="L_APPOITMENT_PERIOD"
  1945. type="xs:string"
  1946. id="_2_MARKETING___d15e200470-1_L_APPOITME"/>
  1947. <xs:element name="L_APPOITMENT_INFO"
  1948. type="xs:string"
  1949. id="_2_MARKETING___d15e200471-1_L_APPOITME"/>
  1950. <xs:element name="L_APPOITMENT_TYPE"
  1951. type="xs:string"
  1952. id="_2_MARKETING___d15e200472-1_L_APPOITME"/>
  1953. <xs:element name="A_PROBLEM"
  1954. type="xs:string"
  1955. id="_2_MARKETING___d15e200474-1_A_PROBLEM"/>
  1956. <xs:element name="A_PROBLEM_DESC"
  1957. type="xs:string"
  1958. id="_2_MARKETING___d15e200475-1_A_PROBLEM_"/>
  1959. <xs:element name="A_PROBLEM_DATE"
  1960. type="xs:token"
  1961. id="_2_MARKETING___d15e200476-1_A_PROBLEM_"/>
  1962. <xs:element name="A_STATUS_CURRENT"
  1963. type="xs:string"
  1964. id="_2_MARKETING___d15e200477-1_A_STATUS_C"/>
  1965. <xs:element name="A_STATUS_LASTCHANGE_DATE"
  1966. type="xs:token"
  1967. id="_2_MARKETING___d15e200478-1_A_STATUS_L"/>
  1968. <xs:element name="S_ALIAS"
  1969. type="xs:string"
  1970. id="_2_MARKETING___d15e200479-1_S_ALIAS"/>
  1971. <xs:element name="S_ADDRESS_CITY"
  1972. type="xs:string"
  1973. id="_2_MARKETING___d15e200480-1_S_ADDRESS_"/>
  1974. <xs:element name="S_ADDRESS_POST_CODE"
  1975. type="xs:string"
  1976. id="_2_MARKETING___d15e200481-1_S_ADDRESS_"/>
  1977. <xs:element name="S_ADDRESS_POST_OFFICE"
  1978. type="xs:string"
  1979. id="_2_MARKETING___d15e200482-1_S_ADDRESS_"/>
  1980. <xs:element name="S_ADDRESS_STREET"
  1981. type="xs:string"
  1982. id="_2_MARKETING___d15e200483-1_S_ADDRESS_"/>
  1983. <xs:element name="S_ADDRESS_HOUSE"
  1984. type="xs:string"
  1985. id="_2_MARKETING___d15e200484-1_S_ADDRESS_"/>
  1986. <xs:element name="S_OTHER_INFO"
  1987. type="xs:string"
  1988. id="_2_MARKETING___d15e200486-1_S_OTHER_IN"/>
  1989. <xs:element name="S_VIP_LEVEL"
  1990. type="xs:string"
  1991. id="_2_MARKETING___d15e200487-1_S_VIP_LEVE"/>
  1992. <xs:element name="S_VIP_DESC"
  1993. type="xs:string"
  1994. id="_2_MARKETING___d15e200488-1_S_VIP_DESC"/>
  1995. <xs:element name="T_NETWORK_SERVER"
  1996. type="xs:string"
  1997. id="_2_MARKETING___d15e200489-1_T_NETWORK_"/>
  1998. <xs:element name="T_TELBOX_ADDRESS"
  1999. type="xs:string"
  2000. id="_2_MARKETING___d15e200490-1_T_TELBOX_A"/>
  2001. <xs:element name="T_TELBOX_PORT"
  2002. type="xs:string"
  2003. id="_2_MARKETING___d15e200491-1_T_TELBOX_P"/>
  2004. <xs:element name="T_WORKPOINTS"
  2005. type="xs:string"
  2006. id="_2_MARKETING___d15e200492-1_T_WORKPOIN"/>
  2007. <xs:element name="T_WORKPOINTS_PROCES"
  2008. type="xs:integer"
  2009. id="_2_MARKETING___d15e200493-1_T_WORKPOIN"/>
  2010. <xs:element name="T_WORKPOINTS_VALUE"
  2011. type="xs:string"
  2012. id="_2_MARKETING___d15e200494-1_T_WORKPOIN"/>
  2013. <xs:element name="T_WORKPOINTS_TYPE"
  2014. type="xs:string"
  2015. id="_2_MARKETING___d15e200495-1_T_WORKPOIN"/>
  2016. <xs:element name="T_WORKPOINTS_USER"
  2017. type="xs:string"
  2018. id="_2_MARKETING___d15e200496-1_T_WORKPOIN"/>
  2019. <xs:element name="T_WORKPOINTS_DATE"
  2020. type="xs:token"
  2021. id="_2_MARKETING___d15e200498-1_T_WORKPOIN"/>
  2022. <xs:element name="T_PENALTIES"
  2023. type="xs:string"
  2024. id="_2_MARKETING___d15e200499-1_T_PENALTIE"/>
  2025. <xs:element name="T_PENALTIES_TYPE"
  2026. type="xs:string"
  2027. id="_2_MARKETING___d15e200500-1_T_PENALTIE"/>
  2028. <xs:element name="T_PENALTIES_VALUE"
  2029. type="xs:string"
  2030. id="_2_MARKETING___d15e200501-1_T_PENALTIE"/>
  2031. <xs:element name="P_BILLING_NO"
  2032. type="xs:integer"
  2033. id="_2_MARKETING___d15e200502-1_P_BILLING_"/>
  2034. <xs:element name="P_NAME"
  2035. type="xs:string"
  2036. id="_2_MARKETING___d15e200503-1_P_NAME"/>
  2037. <xs:element name="P_NIP"
  2038. type="xs:string"
  2039. id="_2_MARKETING___d15e200504-1_P_NIP"/>
  2040. <xs:element name="P_PESEL"
  2041. type="xs:string"
  2042. id="_2_MARKETING___d15e200505-1_P_PESEL"/>
  2043. <xs:element name="P_OTHER_DOC"
  2044. type="xs:string"
  2045. id="_2_MARKETING___d15e200506-1_P_OTHER_DO"/>
  2046. <xs:element name="P_PHONE"
  2047. type="xs:string"
  2048. id="_2_MARKETING___d15e200507-1_P_PHONE"/>
  2049. <xs:element name="P_FAX"
  2050. type="xs:string"
  2051. id="_2_MARKETING___d15e200508-1_P_FAX"/>
  2052. <xs:element name="P_CONTACT_PERSON"
  2053. type="xs:string"
  2054. id="_2_MARKETING___d15e200510-1_P_CONTACT_"/>
  2055. <xs:element name="P_ADDRESS_CITY"
  2056. type="xs:string"
  2057. id="_2_MARKETING___d15e200511-1_P_ADDRESS_"/>
  2058. <xs:element name="P_ADDRESS_POST_CODE"
  2059. type="xs:string"
  2060. id="_2_MARKETING___d15e200512-1_P_ADDRESS_"/>
  2061. <xs:element name="P_ADDRESS_POST_OFFICE"
  2062. type="xs:string"
  2063. id="_2_MARKETING___d15e200513-1_P_ADDRESS_"/>
  2064. <xs:element name="P_ADDRESS_STREET"
  2065. type="xs:string"
  2066. id="_2_MARKETING___d15e200514-1_P_ADDRESS_"/>
  2067. <xs:element name="P_ADDRESS_HOUSE"
  2068. type="xs:string"
  2069. id="_2_MARKETING___d15e200515-1_P_ADDRESS_"/>
  2070. <xs:element name="P_OTHER_INFO"
  2071. type="xs:string"
  2072. id="_2_MARKETING___d15e200516-1_P_OTHER_IN"/>
  2073. <xs:element name="T_TELBOX_BUILDING_IN"
  2074. type="xs:string"
  2075. id="_2_MARKETING___d15e200517-1_T_TELBOX_B"/>
  2076. <xs:element name="I_BAD_DATE"
  2077. type="default_db__x3A__USERS2_MARKETING:I_BAD_DATE_OLD"
  2078. id="_2_MARKETING___d15e200518-1_I_BAD_DATE"/>
  2079. <xs:element name="I_OPER"
  2080. type="default_db__x3A__USERS2_MARKETING:I_OPER_BN"
  2081. id="_2_MARKETING___d15e200519-1_I_OPER"/>
  2082. <xs:element name="I_PAY"
  2083. type="xs:double"
  2084. id="_2_MARKETING___d15e200520-1_I_PAY"/>
  2085. <xs:element name="I_OPER_ZAD"
  2086. type="xs:string"
  2087. id="_2_MARKETING___d15e200522-1_I_OPER_ZAD"/>
  2088. <xs:element name="I_OPER_FIN"
  2089. type="xs:token"
  2090. id="_2_MARKETING___d15e200523-1_I_OPER_FIN"/>
  2091. <xs:element name="I_OPER_ZAINT"
  2092. type="xs:string"
  2093. id="_2_MARKETING___d15e200524-1_I_OPER_ZAI"/>
  2094. <xs:element name="T_BAD_DATE"
  2095. type="xs:token"
  2096. id="_2_MARKETING___d15e200525-1_T_BAD_DATE"/>
  2097. <xs:element name="T_OPER"
  2098. type="xs:string"
  2099. id="_2_MARKETING___d15e200526-1_T_OPER"/>
  2100. <xs:element name="T_PAY"
  2101. type="xs:double"
  2102. id="_2_MARKETING___d15e200527-1_T_PAY"/>
  2103. <xs:element name="T_OPER_ZAD"
  2104. type="xs:string"
  2105. id="_2_MARKETING___d15e200528-1_T_OPER_ZAD"/>
  2106. <xs:element name="T_OPER_FIN"
  2107. type="xs:token"
  2108. id="_2_MARKETING___d15e200529-1_T_OPER_FIN"/>
  2109. <xs:element name="T_OPER_ZAINT"
  2110. type="xs:string"
  2111. id="_2_MARKETING___d15e200530-1_T_OPER_ZAI"/>
  2112. <xs:element name="TV_BAD_DATE"
  2113. type="xs:token"
  2114. id="_2_MARKETING___d15e200531-1_TV_BAD_DAT"/>
  2115. <xs:element name="TV_OPER"
  2116. type="xs:string"
  2117. id="_2_MARKETING___d15e200532-1_TV_OPER"/>
  2118. <xs:element name="TV_PAY"
  2119. type="xs:double"
  2120. id="_2_MARKETING___d15e200534-1_TV_PAY"/>
  2121. <xs:element name="TV_OPER_ZAD"
  2122. type="xs:string"
  2123. id="_2_MARKETING___d15e200535-1_TV_OPER_ZA"/>
  2124. <xs:element name="TV_OPER_FIN"
  2125. type="xs:token"
  2126. id="_2_MARKETING___d15e200536-1_TV_OPER_FI"/>
  2127. <xs:element name="TV_OPER_ZAINT"
  2128. type="xs:string"
  2129. id="_2_MARKETING___d15e200537-1_TV_OPER_ZA"/>
  2130. <xs:element name="BIZ_BAD_DATE"
  2131. type="xs:token"
  2132. id="_2_MARKETING___d15e200538-1_BIZ_BAD_DA"/>
  2133. <xs:element name="BIZ_VOIP_ZAINT"
  2134. type="xs:string"
  2135. id="_2_MARKETING___d15e200539-1_BIZ_VOIP_Z"/>
  2136. <xs:element name="BIZ_PROCESY5_ZAINT"
  2137. type="xs:string"
  2138. id="_2_MARKETING___d15e200540-1_BIZ_PROCES"/>
  2139. <xs:element name="BIZ_SUPPORT_ZAINT"
  2140. type="xs:string"
  2141. id="_2_MARKETING___d15e200541-1_BIZ_SUPPOR"/>
  2142. <xs:element name="M_REWIR"
  2143. type="xs:string"
  2144. id="_2_MARKETING___d15e200542-1_M_REWIR"/>
  2145. <xs:element name="__MK_Rewiry__STATUS"
  2146. type="xs:string"
  2147. id="_2_MARKETING___d15e200543-1___MK_Rewir"/>
  2148. <xs:element name="BOK_ZAD"
  2149. type="xs:string"
  2150. id="_2_MARKETING___d15e200544-1_BOK_ZAD"/>
  2151. <xs:element name="BOK_BAD_DATE"
  2152. type="xs:token"
  2153. id="_2_MARKETING___d15e200546-1_BOK_BAD_DA"/>
  2154. <xs:element name="P_FLOOR_CONTROL"
  2155. type="xs:string"
  2156. id="_2_MARKETING___d15e200547-1_P_FLOOR_CO"/>
  2157. <xs:element name="P_ACCOUNT"
  2158. type="xs:string"
  2159. id="_2_MARKETING___d15e200548-1_P_ACCOUNT"/>
  2160. <xs:element name="S_KLATKA"
  2161. type="xs:string"
  2162. id="_2_MARKETING___d15e200549-1_S_KLATKA"/>
  2163. <xs:element name="BAD_WYS_JAKOSC_OR_NISKA_CENA"
  2164. type="xs:string"
  2165. id="_2_MARKETING___d15e200550-1_BAD_WYS_JA"/>
  2166. <xs:element name="BAD_KROTKA_UMOWA_OR_DLUGI_KONTRAKT_UPUST"
  2167. type="xs:string"
  2168. id="_2_MARKETING___d15e200551-1_BAD_KROTKA"/>
  2169. <xs:element name="BAD_KONTAKT_CALL_CENTER_EBOK_OR_LOKALNY_BOK"
  2170. type="xs:string"
  2171. id="_2_MARKETING___d15e200552-1_BAD_KONTAK"/>
  2172. <xs:element name="BAD_OFERTY_ULOTK_PLAKATY_OR_MASS_MEDIA"
  2173. type="xs:string"
  2174. id="_2_MARKETING___d15e200553-1_BAD_OFERTY"/>
  2175. <xs:element name="BAD_TERMIN_INSTALACJI_TERAZ_OR_TANIO_POTEM"
  2176. type="xs:string"
  2177. id="_2_MARKETING___d15e200554-1_BAD_TERMIN"/>
  2178. <xs:element name="BAD_TV_MULTIROOM_OR_JEDEN_TV"
  2179. type="xs:string"
  2180. id="_2_MARKETING___d15e200555-1_BAD_TV_MUL"/>
  2181. <xs:element name="BAD_TV_CHCE_ZAMAWIAC_PAKIETY_OR_WYSTARCZY_ZAMOWIONY"
  2182. type="xs:string"
  2183. id="_2_MARKETING___d15e200556-1_BAD_TV_CHC"/>
  2184. <xs:element name="BAD_TV_CHCE_NAGRYWAC_INNY_KANAL_OR_TEN_SAM_CO_OGLADAM"
  2185. type="xs:string"
  2186. id="_2_MARKETING___d15e200558-1_BAD_TV_CHC"/>
  2187. <xs:element name="BAD_TV_WYPASIONY_BOX_OR_WYPASIONY_WLASNY_TV"
  2188. type="xs:string"
  2189. id="_2_MARKETING___d15e200559-1_BAD_TV_WYP"/>
  2190. <xs:element name="BAD_TV_PAKIET_KILKADZIESIAT_DOBRYCH_KAN_OR_SETKI_ROZNYCH"
  2191. type="xs:string"
  2192. id="_2_MARKETING___d15e200560-1_BAD_TV_PAK"/>
  2193. <xs:element name="BAD_TV_WOLE_HD_DROZEJ_OR_SD_TANIEJ"
  2194. type="xs:string"
  2195. id="_2_MARKETING___d15e200561-1_BAD_TV_WOL"/>
  2196. <xs:element name="BAD_TV_CHCE_VOD_OPERATORA_OR_WOLE_SMART_TV_LUB_WYPOZYCZALNIE"
  2197. type="xs:string"
  2198. id="_2_MARKETING___d15e200562-1_BAD_TV_CHC"/>
  2199. <xs:element name="BAD_CHCE_LOKALNY_MONITORING_OR_NIE_INTERESUJE_MNIE_TO"
  2200. type="xs:string"
  2201. id="_2_MARKETING___d15e200563-1_BAD_CHCE_L"/>
  2202. <xs:element name="BAD_CHCE_LOKALNE_TV_OR_NIE_OGLADAM_LOK_TV"
  2203. type="xs:string"
  2204. id="_2_MARKETING___d15e200564-1_BAD_CHCE_L"/>
  2205. <xs:element name="BAD_TEL_CHCE_USL_VOICE2MAIL_OR_WOLE_SEKRETARKE"
  2206. type="xs:string"
  2207. id="_2_MARKETING___d15e200565-1_BAD_TEL_CH"/>
  2208. <xs:element name="BAD_TEL_CHCE_DARMOWE_MIEDZYNARODOWE_OR_LOKALNE_KRAJOWE"
  2209. type="xs:string"
  2210. id="_2_MARKETING___d15e200566-1_BAD_TEL_CH"/>
  2211. <xs:element name="BAD_TEL_DZWONIE_NA_KOMORKI_OR_STACJONARNE"
  2212. type="xs:string"
  2213. id="_2_MARKETING___d15e200567-1_BAD_TEL_DZ"/>
  2214. <xs:element name="BAD_TEL_WOLE_WIECEJ_DANYCH_MVNO_OR_DARMOWYCH_MINUT"
  2215. type="xs:string"
  2216. id="_2_MARKETING___d15e200568-1_BAD_TEL_WO"/>
  2217. <xs:element name="BAD_TEL_WOLE_GSM_W_PAKIECIE_U_ISP_OR_KUPIE_GO_U_OPER_GSM"
  2218. type="xs:string"
  2219. id="_2_MARKETING___d15e200570-1_BAD_TEL_WO"/>
  2220. <xs:element name="BAD_MAX_CENA_ZA_DOBRY_PAKIET_TV_TEL_NET"
  2221. type="xs:string"
  2222. id="_2_MARKETING___d15e200571-1_BAD_MAX_CE"/>
  2223. <xs:element name="BAD_DOBRA_CENA_ZA_DOBRY_PAKIET_TV_TEL_NET"
  2224. type="xs:string"
  2225. id="_2_MARKETING___d15e200572-1_BAD_DOBRA_"/>
  2226. <xs:element name="BAD_PLEC"
  2227. type="xs:string"
  2228. id="_2_MARKETING___d15e200573-1_BAD_PLEC"/>
  2229. <xs:element name="BAD_WIELKOSC_MIASTA"
  2230. type="xs:string"
  2231. id="_2_MARKETING___d15e200574-1_BAD_WIELKO"/>
  2232. <xs:element name="BAD_UCZE_SIE"
  2233. type="xs:string"
  2234. id="_2_MARKETING___d15e200575-1_BAD_UCZE_S"/>
  2235. <xs:element name="SYNC_SQIX_STATUS"
  2236. type="xs:string"
  2237. id="_2_MARKETING___d15e200576-1_SYNC_SQIX_"/>
  2238. <xs:element name="id_13102"
  2239. type="xs:integer"
  2240. id="_2_MARKETING___d15e200577-1_id_13102"/>
  2241. <xs:element name="A_UPDATE_DATE"
  2242. type="xs:token"
  2243. id="_2_MARKETING___d15e200578-1_A_UPDATE_D"/>
  2244. <xs:element name="CRM_LISTA_ZASOBOW_ID"
  2245. type="xs:integer"
  2246. id="_2_MARKETING___d15e200579-1_CRM_LISTA_"/>
  2247. <xs:element name="BUSINESS"
  2248. type="xs:string"
  2249. id="_2_MARKETING___d15e200580-1_BUSINESS"/>
  2250. <xs:element name="ID_PROJECT"
  2251. type="xs:integer"
  2252. id="_2_MARKETING___d15e200582-1_ID_PROJECT"/>
  2253. <!--#272 found ignored the_geom-->
  2254. <!--#272 found ignored S_ADDRESS_CITY-->
  2255. <!--#272 found ignored BAD_CHCE_LOKALNE_TV_OR_NIE_OGLADAM_LOK_TV-->
  2256. <!--#272 found ignored BAD_TEL_CHCE_USL_VOICE2MAIL_OR_WOLE_SEKRETARKE-->
  2257. <!--#272 found ignored BAD_TEL_CHCE_DARMOWE_MIEDZYNARODOWE_OR_LOKALNE_KRAJOWE-->
  2258. <!--#272 found ignored BAD_TEL_DZWONIE_NA_KOMORKI_OR_STACJONARNE-->
  2259. <!--#272 found ignored BAD_TEL_WOLE_WIECEJ_DANYCH_MVNO_OR_DARMOWYCH_MINUT-->
  2260. <!--#272 found ignored BAD_TEL_WOLE_GSM_W_PAKIECIE_U_ISP_OR_KUPIE_GO_U_OPER_GSM-->
  2261. <!--#272 found ignored BAD_MAX_CENA_ZA_DOBRY_PAKIET_TV_TEL_NET-->
  2262. <!--#272 found ignored BAD_DOBRA_CENA_ZA_DOBRY_PAKIET_TV_TEL_NET-->
  2263. <!--#272 found ignored BAD_PLEC-->
  2264. <!--#272 found ignored BAD_WIELKOSC_MIASTA-->
  2265. <!--#272 found ignored L_APPOITMENT_DATE-->
  2266. <!--#272 found ignored BAD_UCZE_SIE-->
  2267. <!--#272 found ignored A_RECORD_CREATE_DATE-->
  2268. <!--#272 found ignored A_RECORD_CREATE_AUTHOR-->
  2269. <!--#272 found ignored A_RECORD_UPDATE_DATE-->
  2270. <!--#272 found ignored A_RECORD_UPDATE_AUTHOR-->
  2271. <!--#272 found ignored A_ADM_COMPANY-->
  2272. <!--#272 found ignored A_CLASSIFIED-->
  2273. <!--#272 found ignored TAB_UPDATE_DATE-->
  2274. <!--#272 found ignored TAB_UPDATE_INFO-->
  2275. <!--#272 found ignored TAB_UPDATE_STAT-->
  2276. <!--#272 found ignored L_APPOITMENT_USER-->
  2277. <!--#288 unsupported yet @ref p5_zasob_36:ADMIN_USERS-->
  2278. <!--#414-A found adding p5_zasob_36:ADMIN_USERS, $prototype_NamespacePrefix = default_db__x3A__USERS2_MARKETING-->
  2279. <xs:element ref="default_db__x3A__ADMIN_USERS:ADMIN_USERS"
  2280. minOccurs="0"
  2281. id="_2_MARKETING___d15e200610-1">
  2282. <xs:annotation>
  2283. <xs:appinfo>
  2284. <system_cache__appinfo:flat_relation_cache>
  2285. <system_cache__appinfo:source system_cache__appinfo:name="L_APPOITMENT_USER"
  2286. system_cache__appinfo:xpath="default_db__x3A__ADMIN_USERS:ADMIN_USERS/ADM_ACCOUNT"/>
  2287. </system_cache__appinfo:flat_relation_cache>
  2288. </xs:appinfo>
  2289. </xs:annotation>
  2290. </xs:element>
  2291. <!--#272 found ignored SYNC_SQIX_STATUS-->
  2292. <!--#272 found ignored A_STATUS_CURRENT-->
  2293. <!--#272 found ignored id_13102-->
  2294. <!--#272 found ignored L_APPOITMENT_PERIOD-->
  2295. <!--#272 found ignored L_APPOITMENT_TYPE-->
  2296. <!--#272 found ignored L_APPOITMENT_INFO-->
  2297. <!--#272 found ignored P_NAME-->
  2298. <!--#272 found ignored P_PHONE-->
  2299. <!--#272 found ignored BUSINESS-->
  2300. <!--#272 found ignored M_REWIR-->
  2301. <!--#288 unsupported yet @ref p5_zasob_36:MK_Rewiry-->
  2302. <!--#414-A found adding p5_zasob_36:MK_Rewiry, $prototype_NamespacePrefix = default_db__x3A__USERS2_MARKETING-->
  2303. <xs:element ref="default_db__x3A__MK_Rewiry:MK_Rewiry"
  2304. minOccurs="0"
  2305. id="_2_MARKETING___d15e200628-1">
  2306. <xs:annotation>
  2307. <xs:appinfo>
  2308. <system_cache__appinfo:flat_relation_cache>
  2309. <system_cache__appinfo:source system_cache__appinfo:name="M_REWIR"
  2310. system_cache__appinfo:xpath="default_db__x3A__MK_Rewiry:MK_Rewiry/NAZWA_REWI"/>
  2311. </system_cache__appinfo:flat_relation_cache>
  2312. </xs:appinfo>
  2313. </xs:annotation>
  2314. </xs:element>
  2315. <!--#272 found ignored ID_PROJECT-->
  2316. <!--#288 unsupported yet @ref p5_zasob_36:IN7_MK_BAZA_DYSTRYBUCJI-->
  2317. <!--#414-A found adding p5_zasob_36:IN7_MK_BAZA_DYSTRYBUCJI, $prototype_NamespacePrefix = default_db__x3A__USERS2_MARKETING-->
  2318. <xs:element ref="default_db__x3A__IN7_MK_BAZA_DYSTRYBUCJI:IN7_MK_BAZA_DYSTRYBUCJI"
  2319. minOccurs="0"
  2320. id="_2_MARKETING___d15e200636-1">
  2321. <xs:annotation>
  2322. <xs:appinfo>
  2323. <system_cache__appinfo:flat_relation_cache>
  2324. <system_cache__appinfo:source system_cache__appinfo:name="ID_PROJECT"
  2325. system_cache__appinfo:xpath="default_db__x3A__IN7_MK_BAZA_DYSTRYBUCJI:IN7_MK_BAZA_DYSTRYBUCJI/ID"/>
  2326. </system_cache__appinfo:flat_relation_cache>
  2327. </xs:appinfo>
  2328. </xs:annotation>
  2329. </xs:element>
  2330. <!--#272 found ignored __MK_Rewiry__STATUS-->
  2331. <!--#272 found ignored ID-->
  2332. <!--#288 unsupported yet @ref p5_zasob_36:USERS2_MARKETING-->
  2333. <!--#414-A found adding p5_zasob_36:USERS2_MARKETING, $prototype_NamespacePrefix = default_db__x3A__USERS2_MARKETING-->
  2334. <xs:element ref="default_db__x3A__USERS2_MARKETING:USERS2_MARKETING"
  2335. minOccurs="0"
  2336. id="_2_MARKETING___d15e200645-1">
  2337. <xs:annotation>
  2338. <xs:appinfo>
  2339. <system_cache__appinfo:flat_relation_cache>
  2340. <system_cache__appinfo:source system_cache__appinfo:name="ID"
  2341. system_cache__appinfo:xpath="default_db__x3A__USERS2_MARKETING:USERS2_MARKETING/ID"/>
  2342. </system_cache__appinfo:flat_relation_cache>
  2343. </xs:appinfo>
  2344. </xs:annotation>
  2345. </xs:element>
  2346. <!--#272 found ignored P_OTHER_INFO-->
  2347. <!--#272 found ignored A_PROBLEM_DESC-->
  2348. <!--#272 found ignored A_PROBLEM-->
  2349. <!--#272 found ignored A_ID_USERS2-->
  2350. <!--#272 found ignored ID_BILLING_USERS-->
  2351. <!--#272 found ignored ID_SERVICES-->
  2352. <!--#272 found ignored A_PROBLEM_DATE-->
  2353. <!--#272 found ignored A_STATUS-->
  2354. <!--#272 found ignored A_STATUS_INFO-->
  2355. <!--#272 found ignored ADMIN_USERS_ID-->
  2356. <!--#272 found ignored A_UPDATE_DATE-->
  2357. <!--#272 found ignored S_ALIAS-->
  2358. <!--#272 found ignored S_ADDRESS_POST_CODE-->
  2359. <!--#272 found ignored S_ADDRESS_POST_OFFICE-->
  2360. <!--#272 found ignored S_ADDRESS_HOUSE-->
  2361. <!--#272 found ignored S_OTHER_INFO-->
  2362. <!--#272 found ignored S_VIP_LEVEL-->
  2363. <!--#272 found ignored S_VIP_DESC-->
  2364. <!--#272 found ignored T_NETWORK_SERVER-->
  2365. <!--#272 found ignored T_TELBOX_ADDRESS-->
  2366. <!--#272 found ignored CRM_LISTA_ZASOBOW_ID-->
  2367. <!--#288 unsupported yet @ref p5_zasob_36:CRM_LISTA_ZASOBOW-->
  2368. <!--#414-A found adding p5_zasob_36:CRM_LISTA_ZASOBOW, $prototype_NamespacePrefix = default_db__x3A__USERS2_MARKETING-->
  2369. <xs:element ref="default_db__x3A__CRM_LISTA_ZASOBOW:CRM_LISTA_ZASOBOW"
  2370. minOccurs="0"
  2371. id="_2_MARKETING___d15e200674-1">
  2372. <xs:annotation>
  2373. <xs:appinfo>
  2374. <system_cache__appinfo:flat_relation_cache>
  2375. <system_cache__appinfo:source system_cache__appinfo:name="CRM_LISTA_ZASOBOW_ID"
  2376. system_cache__appinfo:xpath="default_db__x3A__CRM_LISTA_ZASOBOW:CRM_LISTA_ZASOBOW/ID"/>
  2377. </system_cache__appinfo:flat_relation_cache>
  2378. </xs:appinfo>
  2379. </xs:annotation>
  2380. </xs:element>
  2381. <!--#272 found ignored T_TELBOX_PORT-->
  2382. <!--#272 found ignored T_WORKPOINTS-->
  2383. <!--#272 found ignored T_WORKPOINTS_VALUE-->
  2384. <!--#272 found ignored T_WORKPOINTS_TYPE-->
  2385. <!--#272 found ignored T_WORKPOINTS_USER-->
  2386. <!--#272 found ignored T_WORKPOINTS_DATE-->
  2387. <!--#272 found ignored T_PENALTIES-->
  2388. <!--#272 found ignored T_PENALTIES_TYPE-->
  2389. <!--#272 found ignored T_PENALTIES_VALUE-->
  2390. <!--#272 found ignored P_BILLING_NO-->
  2391. <!--#272 found ignored P_NIP-->
  2392. <!--#272 found ignored P_PESEL-->
  2393. <!--#272 found ignored P_OTHER_DOC-->
  2394. <!--#272 found ignored P_FAX-->
  2395. <!--#272 found ignored P_CONTACT_PERSON-->
  2396. <!--#272 found ignored P_ADDRESS_CITY-->
  2397. <!--#272 found ignored P_ADDRESS_STREET-->
  2398. <!--#272 found ignored P_ADDRESS_POST_CODE-->
  2399. <!--#272 found ignored P_ADDRESS_POST_OFFICE-->
  2400. <!--#272 found ignored P_ADDRESS_HOUSE-->
  2401. <!--#272 found ignored I_BAD_DATE-->
  2402. <!--#272 found ignored T_WORKPOINTS_PROCES-->
  2403. <!--#272 found ignored I_OPER-->
  2404. <!--#272 found ignored I_PAY-->
  2405. <!--#272 found ignored I_OPER_ZAD-->
  2406. <!--#272 found ignored I_OPER_FIN-->
  2407. <!--#272 found ignored I_OPER_ZAINT-->
  2408. <!--#272 found ignored T_BAD_DATE-->
  2409. <!--#272 found ignored T_OPER-->
  2410. <!--#272 found ignored T_PAY-->
  2411. <!--#272 found ignored T_OPER_ZAD-->
  2412. <!--#272 found ignored T_OPER_FIN-->
  2413. <!--#272 found ignored P_ACCOUNT-->
  2414. <!--#272 found ignored T_OPER_ZAINT-->
  2415. <!--#272 found ignored TV_BAD_DATE-->
  2416. <!--#272 found ignored TV_OPER-->
  2417. <!--#272 found ignored TV_PAY-->
  2418. <!--#272 found ignored TV_OPER_ZAD-->
  2419. <!--#272 found ignored TV_OPER_FIN-->
  2420. <!--#272 found ignored TV_OPER_ZAINT-->
  2421. <!--#272 found ignored BOK_ZAD-->
  2422. <!--#272 found ignored BOK_BAD_DATE-->
  2423. <!--#272 found ignored BIZ_BAD_DATE-->
  2424. <!--#272 found ignored T_TELBOX_BUILDING_IN-->
  2425. <!--#288 unsupported yet @ref p5_zasob_36:BUILDINGS-->
  2426. <!--#414-A found adding p5_zasob_36:BUILDINGS, $prototype_NamespacePrefix = default_db__x3A__USERS2_MARKETING-->
  2427. <xs:element ref="default_db__x3A__BUILDINGS:BUILDINGS"
  2428. minOccurs="0"
  2429. id="_2_MARKETING___d15e200726-1">
  2430. <xs:annotation>
  2431. <xs:appinfo>
  2432. <system_cache__appinfo:flat_relation_cache>
  2433. <system_cache__appinfo:source system_cache__appinfo:name="T_TELBOX_BUILDING_IN"
  2434. system_cache__appinfo:xpath="default_db__x3A__BUILDINGS:BUILDINGS/S_ADDRESS_STREET"/>
  2435. </system_cache__appinfo:flat_relation_cache>
  2436. </xs:appinfo>
  2437. </xs:annotation>
  2438. </xs:element>
  2439. <!--#272 found ignored BIZ_VOIP_ZAINT-->
  2440. <!--#272 found ignored BIZ_SUPPORT_ZAINT-->
  2441. <!--#272 found ignored BIZ_PROCESY5_ZAINT-->
  2442. <!--#272-A found adding INTERNET_STATUS, $prototype_NamespacePrefix = default_db__x3A__USERS2_MARKETING-->
  2443. <xs:element xmlns:p5="https://biuro.biall-net.pl/wfs"
  2444. name="INTERNET_STATUS"
  2445. p5:id_zasob="3493"
  2446. minOccurs="1"
  2447. maxOccurs="1"
  2448. p5:label="Status usł. Internet"
  2449. id="_2_MARKETING___d15e200735-1_INTERNET_S">
  2450. <xs:annotation>
  2451. <xs:documentation>INTERNET_STATUS Informacje z bazy billingowej/technicznej o tym z jakich usług korzysta/korzystał KLIENT.</xs:documentation>
  2452. </xs:annotation>
  2453. </xs:element>
  2454. <!--#272 found ignored S_KLATKA-->
  2455. <!--#272 found ignored P_FLOOR_CONTROL-->
  2456. <!--#272 found ignored BAD_WYS_JAKOSC_OR_NISKA_CENA-->
  2457. <!--#272 found ignored BAD_KROTKA_UMOWA_OR_DLUGI_KONTRAKT_UPUST-->
  2458. <!--#272 found ignored BAD_KONTAKT_CALL_CENTER_EBOK_OR_LOKALNY_BOK-->
  2459. <!--#272 found ignored BAD_OFERTY_ULOTK_PLAKATY_OR_MASS_MEDIA-->
  2460. <!--#272 found ignored S_ADDRESS_STREET-->
  2461. <!--#272 found ignored BAD_TERMIN_INSTALACJI_TERAZ_OR_TANIO_POTEM-->
  2462. <!--#272 found ignored BAD_TV_MULTIROOM_OR_JEDEN_TV-->
  2463. <!--#272 found ignored BAD_TV_CHCE_ZAMAWIAC_PAKIETY_OR_WYSTARCZY_ZAMOWIONY-->
  2464. <!--#272 found ignored BAD_TV_CHCE_NAGRYWAC_INNY_KANAL_OR_TEN_SAM_CO_OGLADAM-->
  2465. <!--#272 found ignored BAD_TV_WYPASIONY_BOX_OR_WYPASIONY_WLASNY_TV-->
  2466. <!--#272 found ignored BAD_TV_PAKIET_KILKADZIESIAT_DOBRYCH_KAN_OR_SETKI_ROZNYCH-->
  2467. <!--#272 found ignored BAD_TV_WOLE_HD_DROZEJ_OR_SD_TANIEJ-->
  2468. <!--#272 found ignored BAD_TV_CHCE_VOD_OPERATORA_OR_WOLE_SMART_TV_LUB_WYPOZYCZALNIE-->
  2469. <!--#272 found ignored BAD_CHCE_LOKALNY_MONITORING_OR_NIE_INTERESUJE_MNIE_TO-->
  2470. <!--#272 found ignored A_STATUS_LASTCHANGE_DATE-->
  2471. </xs:sequence>
  2472. <xs:assert test="translate(date:difference(I_BAD_DATE, date:date-time()), 'PD', '') &gt; 180"
  2473. id="_2_MARKETING___d15e200756-1"/>
  2474. </xs:restriction>
  2475. </xs:complexContent>
  2476. </xs:complexType>
  2477. <xs:element name="USERS2_MARKETING_BN_OLD"
  2478. type="default_db__x3A__USERS2_MARKETING:USERS2_MARKETING_BN_OLD"
  2479. id="_2_MARKETING___d15e200757-1_USERS2_MAR"/>
  2480. <xs:complexType name="USERS2_MARKETING_OBCY_FRESH"
  2481. id="_2_MARKETING___d15e200758-1_USERS2_MAR">
  2482. <xs:complexContent id="_2_MARKETING___d15e200759-1">
  2483. <xs:restriction base="default_db__x3A__USERS2_MARKETING:USERS2_MARKETING">
  2484. <xs:sequence id="_2_MARKETING___d15e200761-1">
  2485. <xs:element name="the_geom"
  2486. type="gml:AbstractFeatureType"
  2487. id="_2_MARKETING___d15e200762-1_the_geom">
  2488. <xs:annotation>
  2489. <xs:documentation>Dane geograficzne obiektu - linia, punkt, polygon</xs:documentation>
  2490. </xs:annotation>
  2491. </xs:element>
  2492. <xs:element name="A_STATUS"
  2493. type="default_db__x3A__USERS2_MARKETING:A_STATUS_Type"
  2494. id="_2_MARKETING___d15e200766-1_A_STATUS"/>
  2495. <xs:element name="A_STATUS_INFO"
  2496. type="xs:string"
  2497. id="_2_MARKETING___d15e200767-1_A_STATUS_I"/>
  2498. <xs:element name="L_APPOITMENT_USER"
  2499. type="xs:string"
  2500. id="_2_MARKETING___d15e200768-1_L_APPOITME"/>
  2501. <xs:element name="A_CLASSIFIED"
  2502. type="xs:string"
  2503. id="_2_MARKETING___d15e200769-1_A_CLASSIFI"/>
  2504. <xs:element name="A_ADM_COMPANY"
  2505. type="xs:string"
  2506. id="_2_MARKETING___d15e200770-1_A_ADM_COMP"/>
  2507. <xs:element name="ID" type="xs:integer" id="_2_MARKETING___d15e200771-1_ID"/>
  2508. <xs:element name="ADMIN_USERS_ID"
  2509. type="xs:integer"
  2510. id="_2_MARKETING___d15e200772-1_ADMIN_USER"/>
  2511. <xs:element name="A_ID_USERS2"
  2512. type="xs:integer"
  2513. id="_2_MARKETING___d15e200773-1_A_ID_USERS"/>
  2514. <xs:element name="ID_BILLING_USERS"
  2515. type="xs:integer"
  2516. id="_2_MARKETING___d15e200774-1_ID_BILLING"/>
  2517. <xs:element name="ID_SERVICES"
  2518. type="xs:integer"
  2519. id="_2_MARKETING___d15e200775-1_ID_SERVICE"/>
  2520. <xs:element name="A_RECORD_CREATE_DATE"
  2521. type="xs:token"
  2522. id="_2_MARKETING___d15e200777-1_A_RECORD_C"/>
  2523. <xs:element name="A_RECORD_CREATE_AUTHOR"
  2524. type="xs:string"
  2525. id="_2_MARKETING___d15e200778-1_A_RECORD_C"/>
  2526. <xs:element name="A_RECORD_UPDATE_DATE"
  2527. type="xs:token"
  2528. id="_2_MARKETING___d15e200779-1_A_RECORD_U"/>
  2529. <xs:element name="A_RECORD_UPDATE_AUTHOR"
  2530. type="xs:string"
  2531. id="_2_MARKETING___d15e200780-1_A_RECORD_U"/>
  2532. <xs:element name="TAB_UPDATE_STAT"
  2533. type="xs:string"
  2534. id="_2_MARKETING___d15e200781-1_TAB_UPDATE"/>
  2535. <xs:element name="TAB_UPDATE_DATE"
  2536. type="xs:token"
  2537. id="_2_MARKETING___d15e200782-1_TAB_UPDATE"/>
  2538. <xs:element name="TAB_UPDATE_INFO"
  2539. type="xs:string"
  2540. id="_2_MARKETING___d15e200783-1_TAB_UPDATE"/>
  2541. <xs:element name="L_APPOITMENT_DATE"
  2542. type="xs:token"
  2543. id="_2_MARKETING___d15e200784-1_L_APPOITME"/>
  2544. <xs:element name="L_APPOITMENT_PERIOD"
  2545. type="xs:string"
  2546. id="_2_MARKETING___d15e200785-1_L_APPOITME"/>
  2547. <xs:element name="L_APPOITMENT_INFO"
  2548. type="xs:string"
  2549. id="_2_MARKETING___d15e200786-1_L_APPOITME"/>
  2550. <xs:element name="L_APPOITMENT_TYPE"
  2551. type="xs:string"
  2552. id="_2_MARKETING___d15e200787-1_L_APPOITME"/>
  2553. <xs:element name="A_PROBLEM"
  2554. type="xs:string"
  2555. id="_2_MARKETING___d15e200789-1_A_PROBLEM"/>
  2556. <xs:element name="A_PROBLEM_DESC"
  2557. type="xs:string"
  2558. id="_2_MARKETING___d15e200790-1_A_PROBLEM_"/>
  2559. <xs:element name="A_PROBLEM_DATE"
  2560. type="xs:token"
  2561. id="_2_MARKETING___d15e200791-1_A_PROBLEM_"/>
  2562. <xs:element name="A_STATUS_CURRENT"
  2563. type="xs:string"
  2564. id="_2_MARKETING___d15e200792-1_A_STATUS_C"/>
  2565. <xs:element name="A_STATUS_LASTCHANGE_DATE"
  2566. type="xs:token"
  2567. id="_2_MARKETING___d15e200793-1_A_STATUS_L"/>
  2568. <xs:element name="S_ALIAS"
  2569. type="xs:string"
  2570. id="_2_MARKETING___d15e200794-1_S_ALIAS"/>
  2571. <xs:element name="S_ADDRESS_CITY"
  2572. type="xs:string"
  2573. id="_2_MARKETING___d15e200795-1_S_ADDRESS_"/>
  2574. <xs:element name="S_ADDRESS_POST_CODE"
  2575. type="xs:string"
  2576. id="_2_MARKETING___d15e200796-1_S_ADDRESS_"/>
  2577. <xs:element name="S_ADDRESS_POST_OFFICE"
  2578. type="xs:string"
  2579. id="_2_MARKETING___d15e200797-1_S_ADDRESS_"/>
  2580. <xs:element name="S_ADDRESS_STREET"
  2581. type="xs:string"
  2582. id="_2_MARKETING___d15e200798-1_S_ADDRESS_"/>
  2583. <xs:element name="S_ADDRESS_HOUSE"
  2584. type="xs:string"
  2585. id="_2_MARKETING___d15e200799-1_S_ADDRESS_"/>
  2586. <xs:element name="S_OTHER_INFO"
  2587. type="xs:string"
  2588. id="_2_MARKETING___d15e200801-1_S_OTHER_IN"/>
  2589. <xs:element name="S_VIP_LEVEL"
  2590. type="xs:string"
  2591. id="_2_MARKETING___d15e200802-1_S_VIP_LEVE"/>
  2592. <xs:element name="S_VIP_DESC"
  2593. type="xs:string"
  2594. id="_2_MARKETING___d15e200803-1_S_VIP_DESC"/>
  2595. <xs:element name="T_NETWORK_SERVER"
  2596. type="xs:string"
  2597. id="_2_MARKETING___d15e200804-1_T_NETWORK_"/>
  2598. <xs:element name="T_TELBOX_ADDRESS"
  2599. type="xs:string"
  2600. id="_2_MARKETING___d15e200805-1_T_TELBOX_A"/>
  2601. <xs:element name="T_TELBOX_PORT"
  2602. type="xs:string"
  2603. id="_2_MARKETING___d15e200806-1_T_TELBOX_P"/>
  2604. <xs:element name="T_WORKPOINTS"
  2605. type="xs:string"
  2606. id="_2_MARKETING___d15e200807-1_T_WORKPOIN"/>
  2607. <xs:element name="T_WORKPOINTS_PROCES"
  2608. type="xs:integer"
  2609. id="_2_MARKETING___d15e200808-1_T_WORKPOIN"/>
  2610. <xs:element name="T_WORKPOINTS_VALUE"
  2611. type="xs:string"
  2612. id="_2_MARKETING___d15e200809-1_T_WORKPOIN"/>
  2613. <xs:element name="T_WORKPOINTS_TYPE"
  2614. type="xs:string"
  2615. id="_2_MARKETING___d15e200810-1_T_WORKPOIN"/>
  2616. <xs:element name="T_WORKPOINTS_USER"
  2617. type="xs:string"
  2618. id="_2_MARKETING___d15e200811-1_T_WORKPOIN"/>
  2619. <xs:element name="T_WORKPOINTS_DATE"
  2620. type="xs:token"
  2621. id="_2_MARKETING___d15e200813-1_T_WORKPOIN"/>
  2622. <xs:element name="T_PENALTIES"
  2623. type="xs:string"
  2624. id="_2_MARKETING___d15e200814-1_T_PENALTIE"/>
  2625. <xs:element name="T_PENALTIES_TYPE"
  2626. type="xs:string"
  2627. id="_2_MARKETING___d15e200815-1_T_PENALTIE"/>
  2628. <xs:element name="T_PENALTIES_VALUE"
  2629. type="xs:string"
  2630. id="_2_MARKETING___d15e200816-1_T_PENALTIE"/>
  2631. <xs:element name="P_BILLING_NO"
  2632. type="xs:integer"
  2633. id="_2_MARKETING___d15e200817-1_P_BILLING_"/>
  2634. <xs:element name="P_NAME"
  2635. type="xs:string"
  2636. id="_2_MARKETING___d15e200818-1_P_NAME"/>
  2637. <xs:element name="P_NIP"
  2638. type="xs:string"
  2639. id="_2_MARKETING___d15e200819-1_P_NIP"/>
  2640. <xs:element name="P_PESEL"
  2641. type="xs:string"
  2642. id="_2_MARKETING___d15e200820-1_P_PESEL"/>
  2643. <xs:element name="P_OTHER_DOC"
  2644. type="xs:string"
  2645. id="_2_MARKETING___d15e200821-1_P_OTHER_DO"/>
  2646. <xs:element name="P_PHONE"
  2647. type="xs:string"
  2648. id="_2_MARKETING___d15e200822-1_P_PHONE"/>
  2649. <xs:element name="P_FAX"
  2650. type="xs:string"
  2651. id="_2_MARKETING___d15e200823-1_P_FAX"/>
  2652. <xs:element name="P_CONTACT_PERSON"
  2653. type="xs:string"
  2654. id="_2_MARKETING___d15e200825-1_P_CONTACT_"/>
  2655. <xs:element name="P_ADDRESS_CITY"
  2656. type="xs:string"
  2657. id="_2_MARKETING___d15e200826-1_P_ADDRESS_"/>
  2658. <xs:element name="P_ADDRESS_POST_CODE"
  2659. type="xs:string"
  2660. id="_2_MARKETING___d15e200827-1_P_ADDRESS_"/>
  2661. <xs:element name="P_ADDRESS_POST_OFFICE"
  2662. type="xs:string"
  2663. id="_2_MARKETING___d15e200828-1_P_ADDRESS_"/>
  2664. <xs:element name="P_ADDRESS_STREET"
  2665. type="xs:string"
  2666. id="_2_MARKETING___d15e200829-1_P_ADDRESS_"/>
  2667. <xs:element name="P_ADDRESS_HOUSE"
  2668. type="xs:string"
  2669. id="_2_MARKETING___d15e200830-1_P_ADDRESS_"/>
  2670. <xs:element name="P_OTHER_INFO"
  2671. type="xs:string"
  2672. id="_2_MARKETING___d15e200831-1_P_OTHER_IN"/>
  2673. <xs:element name="T_TELBOX_BUILDING_IN"
  2674. type="xs:string"
  2675. id="_2_MARKETING___d15e200832-1_T_TELBOX_B"/>
  2676. <xs:element name="I_BAD_DATE"
  2677. type="default_db__x3A__USERS2_MARKETING:I_BAD_DATE_FRESH"
  2678. id="_2_MARKETING___d15e200833-1_I_BAD_DATE"/>
  2679. <xs:element name="I_OPER"
  2680. type="default_db__x3A__USERS2_MARKETING:I_OPER_OBCY"
  2681. id="_2_MARKETING___d15e200834-1_I_OPER"/>
  2682. <xs:element name="I_PAY"
  2683. type="xs:double"
  2684. id="_2_MARKETING___d15e200835-1_I_PAY"/>
  2685. <xs:element name="I_OPER_ZAD"
  2686. type="xs:string"
  2687. id="_2_MARKETING___d15e200837-1_I_OPER_ZAD"/>
  2688. <xs:element name="I_OPER_FIN"
  2689. type="xs:token"
  2690. id="_2_MARKETING___d15e200838-1_I_OPER_FIN"/>
  2691. <xs:element name="I_OPER_ZAINT"
  2692. type="xs:string"
  2693. id="_2_MARKETING___d15e200839-1_I_OPER_ZAI"/>
  2694. <xs:element name="T_BAD_DATE"
  2695. type="xs:token"
  2696. id="_2_MARKETING___d15e200840-1_T_BAD_DATE"/>
  2697. <xs:element name="T_OPER"
  2698. type="xs:string"
  2699. id="_2_MARKETING___d15e200841-1_T_OPER"/>
  2700. <xs:element name="T_PAY"
  2701. type="xs:double"
  2702. id="_2_MARKETING___d15e200842-1_T_PAY"/>
  2703. <xs:element name="T_OPER_ZAD"
  2704. type="xs:string"
  2705. id="_2_MARKETING___d15e200843-1_T_OPER_ZAD"/>
  2706. <xs:element name="T_OPER_FIN"
  2707. type="xs:token"
  2708. id="_2_MARKETING___d15e200844-1_T_OPER_FIN"/>
  2709. <xs:element name="T_OPER_ZAINT"
  2710. type="xs:string"
  2711. id="_2_MARKETING___d15e200845-1_T_OPER_ZAI"/>
  2712. <xs:element name="TV_BAD_DATE"
  2713. type="xs:token"
  2714. id="_2_MARKETING___d15e200846-1_TV_BAD_DAT"/>
  2715. <xs:element name="TV_OPER"
  2716. type="xs:string"
  2717. id="_2_MARKETING___d15e200847-1_TV_OPER"/>
  2718. <xs:element name="TV_PAY"
  2719. type="xs:double"
  2720. id="_2_MARKETING___d15e200849-1_TV_PAY"/>
  2721. <xs:element name="TV_OPER_ZAD"
  2722. type="xs:string"
  2723. id="_2_MARKETING___d15e200850-1_TV_OPER_ZA"/>
  2724. <xs:element name="TV_OPER_FIN"
  2725. type="xs:token"
  2726. id="_2_MARKETING___d15e200851-1_TV_OPER_FI"/>
  2727. <xs:element name="TV_OPER_ZAINT"
  2728. type="xs:string"
  2729. id="_2_MARKETING___d15e200852-1_TV_OPER_ZA"/>
  2730. <xs:element name="BIZ_BAD_DATE"
  2731. type="xs:token"
  2732. id="_2_MARKETING___d15e200853-1_BIZ_BAD_DA"/>
  2733. <xs:element name="BIZ_VOIP_ZAINT"
  2734. type="xs:string"
  2735. id="_2_MARKETING___d15e200854-1_BIZ_VOIP_Z"/>
  2736. <xs:element name="BIZ_PROCESY5_ZAINT"
  2737. type="xs:string"
  2738. id="_2_MARKETING___d15e200855-1_BIZ_PROCES"/>
  2739. <xs:element name="BIZ_SUPPORT_ZAINT"
  2740. type="xs:string"
  2741. id="_2_MARKETING___d15e200856-1_BIZ_SUPPOR"/>
  2742. <xs:element name="M_REWIR"
  2743. type="xs:string"
  2744. id="_2_MARKETING___d15e200857-1_M_REWIR"/>
  2745. <xs:element name="__MK_Rewiry__STATUS"
  2746. type="xs:string"
  2747. id="_2_MARKETING___d15e200858-1___MK_Rewir"/>
  2748. <xs:element name="BOK_ZAD"
  2749. type="xs:string"
  2750. id="_2_MARKETING___d15e200859-1_BOK_ZAD"/>
  2751. <xs:element name="BOK_BAD_DATE"
  2752. type="xs:token"
  2753. id="_2_MARKETING___d15e200861-1_BOK_BAD_DA"/>
  2754. <xs:element name="P_FLOOR_CONTROL"
  2755. type="xs:string"
  2756. id="_2_MARKETING___d15e200862-1_P_FLOOR_CO"/>
  2757. <xs:element name="P_ACCOUNT"
  2758. type="xs:string"
  2759. id="_2_MARKETING___d15e200863-1_P_ACCOUNT"/>
  2760. <xs:element name="S_KLATKA"
  2761. type="xs:string"
  2762. id="_2_MARKETING___d15e200864-1_S_KLATKA"/>
  2763. <xs:element name="BAD_WYS_JAKOSC_OR_NISKA_CENA"
  2764. type="xs:string"
  2765. id="_2_MARKETING___d15e200865-1_BAD_WYS_JA"/>
  2766. <xs:element name="BAD_KROTKA_UMOWA_OR_DLUGI_KONTRAKT_UPUST"
  2767. type="xs:string"
  2768. id="_2_MARKETING___d15e200866-1_BAD_KROTKA"/>
  2769. <xs:element name="BAD_KONTAKT_CALL_CENTER_EBOK_OR_LOKALNY_BOK"
  2770. type="xs:string"
  2771. id="_2_MARKETING___d15e200867-1_BAD_KONTAK"/>
  2772. <xs:element name="BAD_OFERTY_ULOTK_PLAKATY_OR_MASS_MEDIA"
  2773. type="xs:string"
  2774. id="_2_MARKETING___d15e200868-1_BAD_OFERTY"/>
  2775. <xs:element name="BAD_TERMIN_INSTALACJI_TERAZ_OR_TANIO_POTEM"
  2776. type="xs:string"
  2777. id="_2_MARKETING___d15e200869-1_BAD_TERMIN"/>
  2778. <xs:element name="BAD_TV_MULTIROOM_OR_JEDEN_TV"
  2779. type="xs:string"
  2780. id="_2_MARKETING___d15e200870-1_BAD_TV_MUL"/>
  2781. <xs:element name="BAD_TV_CHCE_ZAMAWIAC_PAKIETY_OR_WYSTARCZY_ZAMOWIONY"
  2782. type="xs:string"
  2783. id="_2_MARKETING___d15e200871-1_BAD_TV_CHC"/>
  2784. <xs:element name="BAD_TV_CHCE_NAGRYWAC_INNY_KANAL_OR_TEN_SAM_CO_OGLADAM"
  2785. type="xs:string"
  2786. id="_2_MARKETING___d15e200873-1_BAD_TV_CHC"/>
  2787. <xs:element name="BAD_TV_WYPASIONY_BOX_OR_WYPASIONY_WLASNY_TV"
  2788. type="xs:string"
  2789. id="_2_MARKETING___d15e200874-1_BAD_TV_WYP"/>
  2790. <xs:element name="BAD_TV_PAKIET_KILKADZIESIAT_DOBRYCH_KAN_OR_SETKI_ROZNYCH"
  2791. type="xs:string"
  2792. id="_2_MARKETING___d15e200875-1_BAD_TV_PAK"/>
  2793. <xs:element name="BAD_TV_WOLE_HD_DROZEJ_OR_SD_TANIEJ"
  2794. type="xs:string"
  2795. id="_2_MARKETING___d15e200876-1_BAD_TV_WOL"/>
  2796. <xs:element name="BAD_TV_CHCE_VOD_OPERATORA_OR_WOLE_SMART_TV_LUB_WYPOZYCZALNIE"
  2797. type="xs:string"
  2798. id="_2_MARKETING___d15e200877-1_BAD_TV_CHC"/>
  2799. <xs:element name="BAD_CHCE_LOKALNY_MONITORING_OR_NIE_INTERESUJE_MNIE_TO"
  2800. type="xs:string"
  2801. id="_2_MARKETING___d15e200878-1_BAD_CHCE_L"/>
  2802. <xs:element name="BAD_CHCE_LOKALNE_TV_OR_NIE_OGLADAM_LOK_TV"
  2803. type="xs:string"
  2804. id="_2_MARKETING___d15e200879-1_BAD_CHCE_L"/>
  2805. <xs:element name="BAD_TEL_CHCE_USL_VOICE2MAIL_OR_WOLE_SEKRETARKE"
  2806. type="xs:string"
  2807. id="_2_MARKETING___d15e200880-1_BAD_TEL_CH"/>
  2808. <xs:element name="BAD_TEL_CHCE_DARMOWE_MIEDZYNARODOWE_OR_LOKALNE_KRAJOWE"
  2809. type="xs:string"
  2810. id="_2_MARKETING___d15e200881-1_BAD_TEL_CH"/>
  2811. <xs:element name="BAD_TEL_DZWONIE_NA_KOMORKI_OR_STACJONARNE"
  2812. type="xs:string"
  2813. id="_2_MARKETING___d15e200882-1_BAD_TEL_DZ"/>
  2814. <xs:element name="BAD_TEL_WOLE_WIECEJ_DANYCH_MVNO_OR_DARMOWYCH_MINUT"
  2815. type="xs:string"
  2816. id="_2_MARKETING___d15e200883-1_BAD_TEL_WO"/>
  2817. <xs:element name="BAD_TEL_WOLE_GSM_W_PAKIECIE_U_ISP_OR_KUPIE_GO_U_OPER_GSM"
  2818. type="xs:string"
  2819. id="_2_MARKETING___d15e200885-1_BAD_TEL_WO"/>
  2820. <xs:element name="BAD_MAX_CENA_ZA_DOBRY_PAKIET_TV_TEL_NET"
  2821. type="xs:string"
  2822. id="_2_MARKETING___d15e200886-1_BAD_MAX_CE"/>
  2823. <xs:element name="BAD_DOBRA_CENA_ZA_DOBRY_PAKIET_TV_TEL_NET"
  2824. type="xs:string"
  2825. id="_2_MARKETING___d15e200887-1_BAD_DOBRA_"/>
  2826. <xs:element name="BAD_PLEC"
  2827. type="xs:string"
  2828. id="_2_MARKETING___d15e200888-1_BAD_PLEC"/>
  2829. <xs:element name="BAD_WIELKOSC_MIASTA"
  2830. type="xs:string"
  2831. id="_2_MARKETING___d15e200889-1_BAD_WIELKO"/>
  2832. <xs:element name="BAD_UCZE_SIE"
  2833. type="xs:string"
  2834. id="_2_MARKETING___d15e200890-1_BAD_UCZE_S"/>
  2835. <xs:element name="SYNC_SQIX_STATUS"
  2836. type="xs:string"
  2837. id="_2_MARKETING___d15e200891-1_SYNC_SQIX_"/>
  2838. <xs:element name="id_13102"
  2839. type="xs:integer"
  2840. id="_2_MARKETING___d15e200892-1_id_13102"/>
  2841. <xs:element name="A_UPDATE_DATE"
  2842. type="xs:token"
  2843. id="_2_MARKETING___d15e200893-1_A_UPDATE_D"/>
  2844. <xs:element name="CRM_LISTA_ZASOBOW_ID"
  2845. type="xs:integer"
  2846. id="_2_MARKETING___d15e200894-1_CRM_LISTA_"/>
  2847. <xs:element name="BUSINESS"
  2848. type="xs:string"
  2849. id="_2_MARKETING___d15e200895-1_BUSINESS"/>
  2850. <xs:element name="ID_PROJECT"
  2851. type="xs:integer"
  2852. id="_2_MARKETING___d15e200897-1_ID_PROJECT"/>
  2853. <!--#272 found ignored the_geom-->
  2854. <!--#272 found ignored S_ADDRESS_CITY-->
  2855. <!--#272 found ignored BAD_CHCE_LOKALNE_TV_OR_NIE_OGLADAM_LOK_TV-->
  2856. <!--#272 found ignored BAD_TEL_CHCE_USL_VOICE2MAIL_OR_WOLE_SEKRETARKE-->
  2857. <!--#272 found ignored BAD_TEL_CHCE_DARMOWE_MIEDZYNARODOWE_OR_LOKALNE_KRAJOWE-->
  2858. <!--#272 found ignored BAD_TEL_DZWONIE_NA_KOMORKI_OR_STACJONARNE-->
  2859. <!--#272 found ignored BAD_TEL_WOLE_WIECEJ_DANYCH_MVNO_OR_DARMOWYCH_MINUT-->
  2860. <!--#272 found ignored BAD_TEL_WOLE_GSM_W_PAKIECIE_U_ISP_OR_KUPIE_GO_U_OPER_GSM-->
  2861. <!--#272 found ignored BAD_MAX_CENA_ZA_DOBRY_PAKIET_TV_TEL_NET-->
  2862. <!--#272 found ignored BAD_DOBRA_CENA_ZA_DOBRY_PAKIET_TV_TEL_NET-->
  2863. <!--#272 found ignored BAD_PLEC-->
  2864. <!--#272 found ignored BAD_WIELKOSC_MIASTA-->
  2865. <!--#272 found ignored L_APPOITMENT_DATE-->
  2866. <!--#272 found ignored BAD_UCZE_SIE-->
  2867. <!--#272 found ignored A_RECORD_CREATE_DATE-->
  2868. <!--#272 found ignored A_RECORD_CREATE_AUTHOR-->
  2869. <!--#272 found ignored A_RECORD_UPDATE_DATE-->
  2870. <!--#272 found ignored A_RECORD_UPDATE_AUTHOR-->
  2871. <!--#272 found ignored A_ADM_COMPANY-->
  2872. <!--#272 found ignored A_CLASSIFIED-->
  2873. <!--#272 found ignored TAB_UPDATE_DATE-->
  2874. <!--#272 found ignored TAB_UPDATE_INFO-->
  2875. <!--#272 found ignored TAB_UPDATE_STAT-->
  2876. <!--#272 found ignored L_APPOITMENT_USER-->
  2877. <!--#288 unsupported yet @ref p5_zasob_36:ADMIN_USERS-->
  2878. <!--#414-A found adding p5_zasob_36:ADMIN_USERS, $prototype_NamespacePrefix = default_db__x3A__USERS2_MARKETING-->
  2879. <xs:element ref="default_db__x3A__ADMIN_USERS:ADMIN_USERS"
  2880. minOccurs="0"
  2881. id="_2_MARKETING___d15e200925-1">
  2882. <xs:annotation>
  2883. <xs:appinfo>
  2884. <system_cache__appinfo:flat_relation_cache>
  2885. <system_cache__appinfo:source system_cache__appinfo:name="L_APPOITMENT_USER"
  2886. system_cache__appinfo:xpath="default_db__x3A__ADMIN_USERS:ADMIN_USERS/ADM_ACCOUNT"/>
  2887. </system_cache__appinfo:flat_relation_cache>
  2888. </xs:appinfo>
  2889. </xs:annotation>
  2890. </xs:element>
  2891. <!--#272 found ignored SYNC_SQIX_STATUS-->
  2892. <!--#272 found ignored A_STATUS_CURRENT-->
  2893. <!--#272 found ignored id_13102-->
  2894. <!--#272 found ignored L_APPOITMENT_PERIOD-->
  2895. <!--#272 found ignored L_APPOITMENT_TYPE-->
  2896. <!--#272 found ignored L_APPOITMENT_INFO-->
  2897. <!--#272 found ignored P_NAME-->
  2898. <!--#272 found ignored P_PHONE-->
  2899. <!--#272 found ignored BUSINESS-->
  2900. <!--#272 found ignored M_REWIR-->
  2901. <!--#288 unsupported yet @ref p5_zasob_36:MK_Rewiry-->
  2902. <!--#414-A found adding p5_zasob_36:MK_Rewiry, $prototype_NamespacePrefix = default_db__x3A__USERS2_MARKETING-->
  2903. <xs:element ref="default_db__x3A__MK_Rewiry:MK_Rewiry"
  2904. minOccurs="0"
  2905. id="_2_MARKETING___d15e200943-1">
  2906. <xs:annotation>
  2907. <xs:appinfo>
  2908. <system_cache__appinfo:flat_relation_cache>
  2909. <system_cache__appinfo:source system_cache__appinfo:name="M_REWIR"
  2910. system_cache__appinfo:xpath="default_db__x3A__MK_Rewiry:MK_Rewiry/NAZWA_REWI"/>
  2911. </system_cache__appinfo:flat_relation_cache>
  2912. </xs:appinfo>
  2913. </xs:annotation>
  2914. </xs:element>
  2915. <!--#272 found ignored ID_PROJECT-->
  2916. <!--#288 unsupported yet @ref p5_zasob_36:IN7_MK_BAZA_DYSTRYBUCJI-->
  2917. <!--#414-A found adding p5_zasob_36:IN7_MK_BAZA_DYSTRYBUCJI, $prototype_NamespacePrefix = default_db__x3A__USERS2_MARKETING-->
  2918. <xs:element ref="default_db__x3A__IN7_MK_BAZA_DYSTRYBUCJI:IN7_MK_BAZA_DYSTRYBUCJI"
  2919. minOccurs="0"
  2920. id="_2_MARKETING___d15e200951-1">
  2921. <xs:annotation>
  2922. <xs:appinfo>
  2923. <system_cache__appinfo:flat_relation_cache>
  2924. <system_cache__appinfo:source system_cache__appinfo:name="ID_PROJECT"
  2925. system_cache__appinfo:xpath="default_db__x3A__IN7_MK_BAZA_DYSTRYBUCJI:IN7_MK_BAZA_DYSTRYBUCJI/ID"/>
  2926. </system_cache__appinfo:flat_relation_cache>
  2927. </xs:appinfo>
  2928. </xs:annotation>
  2929. </xs:element>
  2930. <!--#272 found ignored __MK_Rewiry__STATUS-->
  2931. <!--#272 found ignored ID-->
  2932. <!--#288 unsupported yet @ref p5_zasob_36:USERS2_MARKETING-->
  2933. <!--#414-A found adding p5_zasob_36:USERS2_MARKETING, $prototype_NamespacePrefix = default_db__x3A__USERS2_MARKETING-->
  2934. <xs:element ref="default_db__x3A__USERS2_MARKETING:USERS2_MARKETING"
  2935. minOccurs="0"
  2936. id="_2_MARKETING___d15e200960-1">
  2937. <xs:annotation>
  2938. <xs:appinfo>
  2939. <system_cache__appinfo:flat_relation_cache>
  2940. <system_cache__appinfo:source system_cache__appinfo:name="ID"
  2941. system_cache__appinfo:xpath="default_db__x3A__USERS2_MARKETING:USERS2_MARKETING/ID"/>
  2942. </system_cache__appinfo:flat_relation_cache>
  2943. </xs:appinfo>
  2944. </xs:annotation>
  2945. </xs:element>
  2946. <!--#272 found ignored P_OTHER_INFO-->
  2947. <!--#272 found ignored A_PROBLEM_DESC-->
  2948. <!--#272 found ignored A_PROBLEM-->
  2949. <!--#272 found ignored A_ID_USERS2-->
  2950. <!--#272 found ignored ID_BILLING_USERS-->
  2951. <!--#272 found ignored ID_SERVICES-->
  2952. <!--#272 found ignored A_PROBLEM_DATE-->
  2953. <!--#272 found ignored A_STATUS-->
  2954. <!--#272 found ignored A_STATUS_INFO-->
  2955. <!--#272 found ignored ADMIN_USERS_ID-->
  2956. <!--#272 found ignored A_UPDATE_DATE-->
  2957. <!--#272 found ignored S_ALIAS-->
  2958. <!--#272 found ignored S_ADDRESS_POST_CODE-->
  2959. <!--#272 found ignored S_ADDRESS_POST_OFFICE-->
  2960. <!--#272 found ignored S_ADDRESS_HOUSE-->
  2961. <!--#272 found ignored S_OTHER_INFO-->
  2962. <!--#272 found ignored S_VIP_LEVEL-->
  2963. <!--#272 found ignored S_VIP_DESC-->
  2964. <!--#272 found ignored T_NETWORK_SERVER-->
  2965. <!--#272 found ignored T_TELBOX_ADDRESS-->
  2966. <!--#272 found ignored CRM_LISTA_ZASOBOW_ID-->
  2967. <!--#288 unsupported yet @ref p5_zasob_36:CRM_LISTA_ZASOBOW-->
  2968. <!--#414-A found adding p5_zasob_36:CRM_LISTA_ZASOBOW, $prototype_NamespacePrefix = default_db__x3A__USERS2_MARKETING-->
  2969. <xs:element ref="default_db__x3A__CRM_LISTA_ZASOBOW:CRM_LISTA_ZASOBOW"
  2970. minOccurs="0"
  2971. id="_2_MARKETING___d15e200989-1">
  2972. <xs:annotation>
  2973. <xs:appinfo>
  2974. <system_cache__appinfo:flat_relation_cache>
  2975. <system_cache__appinfo:source system_cache__appinfo:name="CRM_LISTA_ZASOBOW_ID"
  2976. system_cache__appinfo:xpath="default_db__x3A__CRM_LISTA_ZASOBOW:CRM_LISTA_ZASOBOW/ID"/>
  2977. </system_cache__appinfo:flat_relation_cache>
  2978. </xs:appinfo>
  2979. </xs:annotation>
  2980. </xs:element>
  2981. <!--#272 found ignored T_TELBOX_PORT-->
  2982. <!--#272 found ignored T_WORKPOINTS-->
  2983. <!--#272 found ignored T_WORKPOINTS_VALUE-->
  2984. <!--#272 found ignored T_WORKPOINTS_TYPE-->
  2985. <!--#272 found ignored T_WORKPOINTS_USER-->
  2986. <!--#272 found ignored T_WORKPOINTS_DATE-->
  2987. <!--#272 found ignored T_PENALTIES-->
  2988. <!--#272 found ignored T_PENALTIES_TYPE-->
  2989. <!--#272 found ignored T_PENALTIES_VALUE-->
  2990. <!--#272 found ignored P_BILLING_NO-->
  2991. <!--#272 found ignored P_NIP-->
  2992. <!--#272 found ignored P_PESEL-->
  2993. <!--#272 found ignored P_OTHER_DOC-->
  2994. <!--#272 found ignored P_FAX-->
  2995. <!--#272 found ignored P_CONTACT_PERSON-->
  2996. <!--#272 found ignored P_ADDRESS_CITY-->
  2997. <!--#272 found ignored P_ADDRESS_STREET-->
  2998. <!--#272 found ignored P_ADDRESS_POST_CODE-->
  2999. <!--#272 found ignored P_ADDRESS_POST_OFFICE-->
  3000. <!--#272 found ignored P_ADDRESS_HOUSE-->
  3001. <!--#272 found ignored I_BAD_DATE-->
  3002. <!--#272 found ignored T_WORKPOINTS_PROCES-->
  3003. <!--#272 found ignored I_OPER-->
  3004. <!--#272 found ignored I_PAY-->
  3005. <!--#272 found ignored I_OPER_ZAD-->
  3006. <!--#272 found ignored I_OPER_FIN-->
  3007. <!--#272 found ignored I_OPER_ZAINT-->
  3008. <!--#272 found ignored T_BAD_DATE-->
  3009. <!--#272 found ignored T_OPER-->
  3010. <!--#272 found ignored T_PAY-->
  3011. <!--#272 found ignored T_OPER_ZAD-->
  3012. <!--#272 found ignored T_OPER_FIN-->
  3013. <!--#272 found ignored P_ACCOUNT-->
  3014. <!--#272 found ignored T_OPER_ZAINT-->
  3015. <!--#272 found ignored TV_BAD_DATE-->
  3016. <!--#272 found ignored TV_OPER-->
  3017. <!--#272 found ignored TV_PAY-->
  3018. <!--#272 found ignored TV_OPER_ZAD-->
  3019. <!--#272 found ignored TV_OPER_FIN-->
  3020. <!--#272 found ignored TV_OPER_ZAINT-->
  3021. <!--#272 found ignored BOK_ZAD-->
  3022. <!--#272 found ignored BOK_BAD_DATE-->
  3023. <!--#272 found ignored BIZ_BAD_DATE-->
  3024. <!--#272 found ignored T_TELBOX_BUILDING_IN-->
  3025. <!--#288 unsupported yet @ref p5_zasob_36:BUILDINGS-->
  3026. <!--#414-A found adding p5_zasob_36:BUILDINGS, $prototype_NamespacePrefix = default_db__x3A__USERS2_MARKETING-->
  3027. <xs:element ref="default_db__x3A__BUILDINGS:BUILDINGS"
  3028. minOccurs="0"
  3029. id="_2_MARKETING___d15e201041-1">
  3030. <xs:annotation>
  3031. <xs:appinfo>
  3032. <system_cache__appinfo:flat_relation_cache>
  3033. <system_cache__appinfo:source system_cache__appinfo:name="T_TELBOX_BUILDING_IN"
  3034. system_cache__appinfo:xpath="default_db__x3A__BUILDINGS:BUILDINGS/S_ADDRESS_STREET"/>
  3035. </system_cache__appinfo:flat_relation_cache>
  3036. </xs:appinfo>
  3037. </xs:annotation>
  3038. </xs:element>
  3039. <!--#272 found ignored BIZ_VOIP_ZAINT-->
  3040. <!--#272 found ignored BIZ_SUPPORT_ZAINT-->
  3041. <!--#272 found ignored BIZ_PROCESY5_ZAINT-->
  3042. <!--#272-A found adding INTERNET_STATUS, $prototype_NamespacePrefix = default_db__x3A__USERS2_MARKETING-->
  3043. <xs:element xmlns:p5="https://biuro.biall-net.pl/wfs"
  3044. name="INTERNET_STATUS"
  3045. p5:id_zasob="3493"
  3046. minOccurs="1"
  3047. maxOccurs="1"
  3048. p5:label="Status usł. Internet"
  3049. id="_2_MARKETING___d15e201050-1_INTERNET_S">
  3050. <xs:annotation>
  3051. <xs:documentation>INTERNET_STATUS Informacje z bazy billingowej/technicznej o tym z jakich usług korzysta/korzystał KLIENT.</xs:documentation>
  3052. </xs:annotation>
  3053. </xs:element>
  3054. <!--#272 found ignored S_KLATKA-->
  3055. <!--#272 found ignored P_FLOOR_CONTROL-->
  3056. <!--#272 found ignored BAD_WYS_JAKOSC_OR_NISKA_CENA-->
  3057. <!--#272 found ignored BAD_KROTKA_UMOWA_OR_DLUGI_KONTRAKT_UPUST-->
  3058. <!--#272 found ignored BAD_KONTAKT_CALL_CENTER_EBOK_OR_LOKALNY_BOK-->
  3059. <!--#272 found ignored BAD_OFERTY_ULOTK_PLAKATY_OR_MASS_MEDIA-->
  3060. <!--#272 found ignored S_ADDRESS_STREET-->
  3061. <!--#272 found ignored BAD_TERMIN_INSTALACJI_TERAZ_OR_TANIO_POTEM-->
  3062. <!--#272 found ignored BAD_TV_MULTIROOM_OR_JEDEN_TV-->
  3063. <!--#272 found ignored BAD_TV_CHCE_ZAMAWIAC_PAKIETY_OR_WYSTARCZY_ZAMOWIONY-->
  3064. <!--#272 found ignored BAD_TV_CHCE_NAGRYWAC_INNY_KANAL_OR_TEN_SAM_CO_OGLADAM-->
  3065. <!--#272 found ignored BAD_TV_WYPASIONY_BOX_OR_WYPASIONY_WLASNY_TV-->
  3066. <!--#272 found ignored BAD_TV_PAKIET_KILKADZIESIAT_DOBRYCH_KAN_OR_SETKI_ROZNYCH-->
  3067. <!--#272 found ignored BAD_TV_WOLE_HD_DROZEJ_OR_SD_TANIEJ-->
  3068. <!--#272 found ignored BAD_TV_CHCE_VOD_OPERATORA_OR_WOLE_SMART_TV_LUB_WYPOZYCZALNIE-->
  3069. <!--#272 found ignored BAD_CHCE_LOKALNY_MONITORING_OR_NIE_INTERESUJE_MNIE_TO-->
  3070. <!--#272 found ignored A_STATUS_LASTCHANGE_DATE-->
  3071. </xs:sequence>
  3072. <xs:assert test="translate(date:difference(I_BAD_DATE, date:date-time()), 'PD', '') &lt; 180"
  3073. id="_2_MARKETING___d15e201071-1"/>
  3074. <xs:assert test="not(matches(I_OPER, '(BN)|(ND)'))"
  3075. id="_2_MARKETING___d15e201091-1"/>
  3076. </xs:restriction>
  3077. </xs:complexContent>
  3078. </xs:complexType>
  3079. <xs:element name="USERS2_MARKETING_OBCY_FRESH"
  3080. type="default_db__x3A__USERS2_MARKETING:USERS2_MARKETING_OBCY_FRESH"
  3081. id="_2_MARKETING___d15e201072-1_USERS2_MAR"/>
  3082. </xs:schema>