| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465 |
- <?xml version="1.0" encoding="UTF-8"?>
- <xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema"
- xmlns:default_db__x3A__COMPANIES="https://biuro.biall-net.pl/wfs/default_db/table/COMPANIES.xsd"
- xmlns:gml="http://www.opengis.net/gml/3.2"
- xmlns:default_db__x3A__BUILDINGS="https://biuro.biall-net.pl/wfs/default_db/table/BUILDINGS.xsd"
- xmlns:default_db__x3A__PROBLEMS="https://biuro.biall-net.pl/wfs/default_db/table/PROBLEMS.xsd"
- xmlns:fix_se_defaultdb_schema="http://biuro.biall-net.pl/xmlschema_procesy5/WPS_Functions/fix_se_defaultdb_schema/fix_se_defaultdb_schema.xsd"
- xmlns:p5Type="http://biuro.biall-net.pl/p5/schema/types"
- xmlns:default_db__x3A__BILLING_NUMBERS="https://biuro.biall-net.pl/wfs/default_db/table/BILLING_NUMBERS.xsd"
- xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
- xmlns:p5_tr_map="http://biuro.biall-net.pl/xmlschema_procesy5/default_db_xml_cache/procesy5_translate_map.xsd"
- xmlns:vc="http://www.w3.org/2007/XMLSchema-versioning"
- 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"
- xmlns:system_cache__appinfo="http://biuro.biall-net.pl/xmlschema_procesy5/default_db_xml_cache/appinfo.xsd"
- xmlns:p5opr="http://biuro.biall-net.pl/xmlschema_procesy5/system_cache/object_parent_relations/object_parent_relations.xsd"
- xmlns:p5_simpleSchema_map="http://biuro.biall-net.pl/xmlschema_procesy5/default_db_xml_cache/p5_simpleSchema_map.xsd"
- xmlns:ant-object="http://biuro.biall-net.pl/xmlschema_procesy5/ant-object/ant-object.xsd"
- xmlns:p5ant-interface="http://biuro.biall-net.pl/xmlschema_procesy5/WPS_Functions/ant_interface/ant_interface.xsd"
- elementFormDefault="qualified"
- targetNamespace="https://biuro.biall-net.pl/wfs/default_db/table/COMPANIES.xsd"
- vc:minVersion="1.1">
- <xs:import namespace="http://biuro.biall-net.pl/p5/schema/types"
- schemaLocation="../../../types.xsd"/>
- <xs:import namespace="http://www.opengis.net/gml/3.2"
- schemaLocation="http://www.opengis.net/gml/3.2"/>
- <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/table/BUILDINGS.xsd"
- schemaLocation="../../default_db.BUILDINGS/BUILDINGS/BUILDINGS.xsd"/>
- <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/table/PROBLEMS.xsd"
- schemaLocation="../../default_db.PROBLEMS/PROBLEMS/PROBLEMS.xsd"/>
- <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/table/BILLING_NUMBERS.xsd"
- schemaLocation="../../default_db.BILLING_NUMBERS/BILLING_NUMBERS/BILLING_NUMBERS.xsd"/>
- <xs:complexType name="COMPANIES" id="__COMPANIES___d5e7424-1_COMPANIES">
- <!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
- <xs:annotation>
- <xs:documentation>TODO do rozbudowy, obiekt konatku dla firmy lub kowalskiego, trzeba
- dobrze zamodelowac </xs:documentation>
- <xs:appinfo>
- <system_cache__appinfo:heritage>
- <system_cache__appinfo:inherit system_cache__appinfo:inherit_ref="default_db:COMPANIES" system_cache__appinfo:heritage_acl="true">
- <system_cache__appinfo:acl_rule_inherit_to_all_same_name_elements_and_refs/>
- <acl_rule_inherit_to_all_refs_by_primary/>
- <acl_rule_inherit_to_all_refs_by_local_element system_cache__appinfo:acl_rule_inherit_local_element_name="P_NAME"/>
- </system_cache__appinfo:inherit>
- <system_cache__appinfo:exherit_all system_cache__appinfo:heritage_acl="true" system_cache__appinfo:heritage_sort="true"/>
- </system_cache__appinfo:heritage>
- </xs:appinfo>
- </xs:annotation>
- <xs:sequence id="__COMPANIES___d5e7428-1">
- <xs:element name="ID" minOccurs="0" type="p5Type:integer" id="__COMPANIES___d18e15923-1_ID"/>
- <xs:element name="ACCOUNT" minOccurs="0" nillable="true" default="" type="p5Type:string"
- id="__COMPANIES___d18e15924-1_ACCOUNT"/>
- <xs:element name="PASSWD" minOccurs="0" default="" type="p5Type:string"
- id="__COMPANIES___d18e15925-1_PASSWD"/>
- <xs:element name="STATUS" minOccurs="0" default="5" type="p5Type:integer"
- id="__COMPANIES___d18e15926-1_STATUS"/>
- <xs:element name="A_RECORD_CREATE_DATE" minOccurs="0" default="" type="p5Type:string"
- id="__COMPANIES___d18e15927-1_A_RECORD_C"/>
- <xs:element name="A_RECORD_CREATE_AUTHOR" minOccurs="0" default="" type="p5Type:string"
- id="__COMPANIES___d18e15928-1_A_RECORD_C"/>
- <xs:element name="A_RECORD_UPDATE_DATE" minOccurs="0" default="" type="p5Type:string"
- id="__COMPANIES___d18e15929-1_A_RECORD_U"/>
- <xs:element name="A_RECORD_UPDATE_AUTHOR" minOccurs="0" default="" type="p5Type:string"
- id="__COMPANIES___d18e15930-1_A_RECORD_U"/>
- <xs:element name="L_APPOITMENT_DATE" minOccurs="0" default="" type="p5Type:string"
- id="__COMPANIES___d18e15931-1_L_APPOITME"/>
- <xs:element name="L_APPOITMENT_USER" minOccurs="0" default="" type="p5Type:string"
- id="__COMPANIES___d18e15932-1_L_APPOITME"/>
- <xs:element name="L_APPOITMENT_PERIOD" minOccurs="0" default="" type="p5Type:string"
- id="__COMPANIES___d18e15933-1_L_APPOITME"/>
- <xs:element name="L_APPOITMENT_INFO" minOccurs="0" default="" type="p5Type:string"
- id="__COMPANIES___d18e15935-1_L_APPOITME"/>
- <xs:element name="L_APPOITMENT_TYPE" minOccurs="0" default=""
- id="__COMPANIES___d18e15936-1_L_APPOITME">
- <xs:simpleType id="__COMPANIES___d18e15937-1">
- <xs:restriction base="p5Type:string">
- <!--@2018-03-23 fixed blad piotrowego xsd:schema z api @2018-03-23 dla restriction enums-->
- <xs:enumeration value=""/>
- <xs:enumeration value="ARRANGED"/>
- <xs:enumeration value="TO_ARRANGE"/>
- <xs:enumeration value="CANCELLED"/>
- <xs:enumeration value="TO_CANCEL"/>
- <xs:enumeration value="RELATE"/>
- <xs:enumeration value="WAIT"/>
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <xs:element name="A_PROBLEM" minOccurs="0" default=""
- id="__COMPANIES___d18e15947-1_A_PROBLEM">
- <xs:simpleType id="__COMPANIES___d18e15948-1">
- <xs:restriction base="p5Type:string">
- <!--@2018-03-23 fixed blad piotrowego xsd:schema z api @2018-03-23 dla restriction enums-->
- <xs:enumeration value=""/>
- <xs:enumeration value="WARNING"/>
- <xs:enumeration value="PROBLEM"/>
- <xs:enumeration value="SERIOUS"/>
- <xs:enumeration value="UNVERIFIED"/>
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <xs:element name="A_PROBLEM_DESC" minOccurs="0" default="" type="p5Type:string"
- id="__COMPANIES___d18e15956-1_A_PROBLEM_"/>
- <xs:element name="A_PROBLEM_DATE" minOccurs="0" default="" type="p5Type:string"
- id="__COMPANIES___d18e15957-1_A_PROBLEM_"/>
- <xs:element name="A_STATUS" minOccurs="0" default="WAITING"
- id="__COMPANIES___d18e15958-1_A_STATUS">
- <xs:simpleType id="__COMPANIES___d18e15959-1">
- <xs:restriction base="p5Type:string">
- <!--@2018-03-23 fixed blad piotrowego xsd:schema z api @2018-03-23 dla restriction enums-->
- <xs:enumeration value="WAITING"/>
- <xs:enumeration value="NORMAL"/>
- <xs:enumeration value="MONITOR"/>
- <xs:enumeration value="WARNING"/>
- <xs:enumeration value="OFF_SOFT"/>
- <xs:enumeration value="OFF_HARD"/>
- <xs:enumeration value="DELETED"/>
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <xs:element name="A_STATUS_INFO" minOccurs="0" default="" type="p5Type:string"
- id="__COMPANIES___d18e15969-1_A_STATUS_I"/>
- <xs:element name="A_ADM_COMPANY" minOccurs="0" default="" type="p5Type:string"
- id="__COMPANIES___d18e15970-1_A_ADM_COMP"/>
- <xs:element name="P_ACCOUNT" minOccurs="0" default="" type="p5Type:string"
- id="__COMPANIES___d18e15971-1_P_ACCOUNT"/>
- <xs:element name="T_WORKPOINTS" minOccurs="0" default="10" type="p5Type:string"
- id="__COMPANIES___d18e15972-1_T_WORKPOIN"/>
- <xs:element name="T_WORKPOINTS_VALUE" minOccurs="0" default="" type="p5Type:string"
- id="__COMPANIES___d18e15973-1_T_WORKPOIN"/>
- <xs:element name="T_WORKPOINTS_TYPE" minOccurs="0" default="" type="p5Type:string"
- id="__COMPANIES___d18e15975-1_T_WORKPOIN"/>
- <xs:element name="T_WORKPOINTS_USER" minOccurs="0" default="" type="p5Type:string"
- id="__COMPANIES___d18e15976-1_T_WORKPOIN"/>
- <xs:element name="T_WORKPOINTS_DATE" minOccurs="0" default="" type="p5Type:string"
- id="__COMPANIES___d18e15977-1_T_WORKPOIN"/>
- <xs:element name="A_STATUS_LASTCHANGE_DATE" minOccurs="0" default="" type="p5Type:string"
- id="__COMPANIES___d18e15978-1_A_STATUS_L"/>
- <xs:element name="S_ADDRESS_CITY" minOccurs="0" default="" type="p5Type:string"
- id="__COMPANIES___d18e15979-1_S_ADDRESS_"/>
- <xs:element name="S_ADDRESS_POST_CODE" minOccurs="0" default="" type="p5Type:string"
- id="__COMPANIES___d18e15980-1_S_ADDRESS_"/>
- <xs:element name="S_ADDRESS_POST_OFFICE" minOccurs="0" default="" type="p5Type:string"
- id="__COMPANIES___d18e15981-1_S_ADDRESS_"/>
- <xs:element name="S_ADDRESS_STREET" minOccurs="0" default="" type="p5Type:string"
- id="__COMPANIES___d18e15982-1_S_ADDRESS_"/>
- <xs:element name="S_ADDRESS_HOUSE" minOccurs="0" default="" type="p5Type:string"
- id="__COMPANIES___d18e15983-1_S_ADDRESS_"/>
- <xs:element name="S_OTHER_INFO" minOccurs="0" default="" type="p5Type:string"
- id="__COMPANIES___d18e15984-1_S_OTHER_IN"/>
- <xs:element name="S_VIP_LEVEL" minOccurs="0" default="0"
- id="__COMPANIES___d18e15985-1_S_VIP_LEVE">
- <xs:simpleType id="__COMPANIES___d18e15986-1">
- <xs:restriction base="p5Type:string">
- <!--@2018-03-23 fixed blad piotrowego xsd:schema z api @2018-03-23 dla restriction enums-->
- <xs:enumeration value="0"/>
- <xs:enumeration value="1"/>
- <xs:enumeration value="2"/>
- <xs:enumeration value="3"/>
- <xs:enumeration value="4"/>
- <xs:enumeration value="5"/>
- <xs:enumeration value="6"/>
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <xs:element name="S_VIP_DESC" minOccurs="0" default="" type="p5Type:string"
- id="__COMPANIES___d18e15997-1_S_VIP_DESC"/>
- <xs:element name="N_P_STATUS_INFORMED_COUNT" minOccurs="0" default="0" type="p5Type:string"
- id="__COMPANIES___d18e15998-1_N_P_STATUS"/>
- <xs:element name="N_P_STATUS_NEXT_INFORM_DATE" minOccurs="0" default=""
- type="p5Type:string" id="__COMPANIES___d18e15999-1_N_P_STATUS"/>
- <xs:element name="N_P_STATUS_INFORMED" minOccurs="0" default="N"
- id="__COMPANIES___d18e16000-1_N_P_STATUS">
- <xs:simpleType id="__COMPANIES___d18e16001-1">
- <xs:restriction base="p5Type:string">
- <!--@2018-03-23 fixed blad piotrowego xsd:schema z api @2018-03-23 dla restriction enums-->
- <xs:enumeration value="Y"/>
- <xs:enumeration value="N"/>
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <xs:element name="N_P_STATUS_HOW_LAST_INFORMED" minOccurs="0" default=""
- type="p5Type:string" id="__COMPANIES___d18e16006-1_N_P_STATUS"/>
- <xs:element name="T_PENALTIES" minOccurs="0" default="10" type="p5Type:string"
- id="__COMPANIES___d18e16007-1_T_PENALTIE"/>
- <xs:element name="T_PENALTIES_TYPE" minOccurs="0" default="" type="p5Type:string"
- id="__COMPANIES___d18e16008-1_T_PENALTIE"/>
- <xs:element name="T_PENALTIES_VALUE" minOccurs="0" default="" type="p5Type:string"
- id="__COMPANIES___d18e16009-1_T_PENALTIE"/>
- <xs:element name="T_WHO_CONNECTED" minOccurs="0" default="" type="p5Type:string"
- id="__COMPANIES___d18e16010-1_T_WHO_CONN"/>
- <xs:element name="T_WHEN_CONNECTED" minOccurs="0" default="" type="p5Type:string"
- id="__COMPANIES___d18e16011-1_T_WHEN_CON"/>
- <xs:element name="P_ADM_COMPANY" minOccurs="0" default="" type="p5Type:string"
- id="__COMPANIES___d18e16012-1_P_ADM_COMP"/>
- <xs:element name="P_DEAL_DATE" minOccurs="0" default="" type="p5Type:string"
- id="__COMPANIES___d18e16014-1_P_DEAL_DAT"/>
- <xs:element name="P_DEALNUMBER" minOccurs="0" nillable="true" default=""
- type="p5Type:string" id="__COMPANIES___d18e16015-1_P_DEALNUMB"/>
- <xs:element name="P_DEALNUMBER_PREFIX" minOccurs="0" default="" type="p5Type:string"
- id="__COMPANIES___d18e16016-1_P_DEALNUMB"/>
- <xs:element name="P_DEALEXPIRE" minOccurs="0" default="" type="p5Type:string"
- id="__COMPANIES___d18e16017-1_P_DEALEXPI"/>
- <xs:element name="P_HANGUP_FROM" minOccurs="0" nillable="true" default=""
- type="p5Type:string" id="__COMPANIES___d18e16018-1_P_HANGUP_F"/>
- <xs:element name="P_HANGUP_TILL" minOccurs="0" nillable="true" default=""
- type="p5Type:string" id="__COMPANIES___d18e16019-1_P_HANGUP_T"/>
- <xs:element name="P_ACCOUNT_LIMIT" minOccurs="0" default="" type="p5Type:string"
- id="__COMPANIES___d18e16020-1_P_ACCOUNT_"/>
- <xs:element name="P_NAME" minOccurs="0" default="" type="p5Type:string"
- id="__COMPANIES___d18e16021-1_P_NAME"/>
- <xs:element name="P_NAME_SECOND" minOccurs="0" default="" type="p5Type:string"
- id="__COMPANIES___d18e16022-1_P_NAME_SEC"/>
- <xs:element name="P_NIP" minOccurs="0" nillable="true" default="" type="p5Type:string"
- id="__COMPANIES___d18e16023-1_P_NIP"/>
- <xs:element name="P_PESEL" minOccurs="0" nillable="true" default="" type="p5Type:string"
- id="__COMPANIES___d18e16024-1_P_PESEL"/>
- <xs:element name="P_OTHER_DOC" minOccurs="0" default="" type="p5Type:string"
- id="__COMPANIES___d18e16026-1_P_OTHER_DO"/>
- <xs:element name="P_PHONE" minOccurs="0" default="" type="p5Type:string"
- id="__COMPANIES___d18e16027-1_P_PHONE"/>
- <xs:element name="P_PHONE_SMS" minOccurs="0" default="" type="p5Type:string"
- id="__COMPANIES___d18e16028-1_P_PHONE_SM"/>
- <xs:element name="P_FAX" minOccurs="0" default="" type="p5Type:string"
- id="__COMPANIES___d18e16029-1_P_FAX"/>
- <xs:element name="P_CONTACT_PERSON" minOccurs="0" type="p5Type:text"
- id="__COMPANIES___d18e16030-1_P_CONTACT_"/>
- <xs:element name="P_ADDRESS_CITY" minOccurs="0" default="" type="p5Type:string"
- id="__COMPANIES___d18e16031-1_P_ADDRESS_"/>
- <xs:element name="P_ADDRESS_POST_CODE" minOccurs="0" default="" type="p5Type:string"
- id="__COMPANIES___d18e16032-1_P_ADDRESS_"/>
- <xs:element name="P_ADDRESS_POST_OFFICE" minOccurs="0" default="" type="p5Type:string"
- id="__COMPANIES___d18e16033-1_P_ADDRESS_"/>
- <xs:element name="P_ADDRESS_STREET" minOccurs="0" default="" type="p5Type:string"
- id="__COMPANIES___d18e16034-1_P_ADDRESS_"/>
- <xs:element name="P_ADDRESS_HOME" minOccurs="0" default="" type="p5Type:string"
- id="__COMPANIES___d18e16035-1_P_ADDRESS_"/>
- <xs:element name="P_ADDRESS_HOUSE" minOccurs="0" default="" type="p5Type:string"
- id="__COMPANIES___d18e16036-1_P_ADDRESS_"/>
- <xs:element name="P_ADDRESS_REGION" minOccurs="0" default="0" type="p5Type:integer"
- id="__COMPANIES___d18e16038-1_P_ADDRESS_"/>
- <xs:element name="P_OTHER_INFO" minOccurs="0" default="" type="p5Type:string"
- id="__COMPANIES___d18e16039-1_P_OTHER_IN"/>
- <xs:element name="TAB_UPDATE_STAT" minOccurs="0" default="1"
- id="__COMPANIES___d18e16040-1_TAB_UPDATE">
- <xs:simpleType id="__COMPANIES___d18e16041-1">
- <xs:restriction base="p5Type:string">
- <!--@2018-03-23 fixed blad piotrowego xsd:schema z api @2018-03-23 dla restriction enums-->
- <xs:enumeration value="0"/>
- <xs:enumeration value="1"/>
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <xs:element name="TAB_UPDATE_DATE" minOccurs="0" default="0000-00-00 00:00:00"
- type="p5Type:dateTime" id="__COMPANIES___d18e16046-1_TAB_UPDATE"/>
- <xs:element name="TAB_UPDATE_INFO" minOccurs="0" default="" type="p5Type:string"
- id="__COMPANIES___d18e16047-1_TAB_UPDATE"/>
- <xs:element name="BILLING_OWNER" minOccurs="0" default="1" type="p5Type:integer"
- id="__COMPANIES___d18e16048-1_BILLING_OW"/>
- <xs:element name="ID_BILLING_PREFIXES" minOccurs="0" default="0" type="p5Type:string"
- id="__COMPANIES___d18e16049-1_ID_BILLING"/>
- <xs:element name="id_list_form_pay" minOccurs="0" default="1" type="p5Type:integer"
- id="__COMPANIES___d18e16050-1_id_list_fo"/>
- <xs:element name="user_mail_contact" minOccurs="0" default="" type="p5Type:string"
- id="__COMPANIES___d18e16051-1_user_mail_"/>
- <xs:element name="is_firma" minOccurs="0" default="0" type="p5Type:integer"
- id="__COMPANIES___d18e16052-1_is_firma"/>
- <xs:element name="P_ADRESS_KORESP_1282" minOccurs="0" type="p5Type:string"
- id="__COMPANIES___d18e16053-1_P_ADRESS_K"/>
- <xs:element name="P_REGON" minOccurs="0" type="p5Type:string"
- id="__COMPANIES___d18e16055-1_P_REGON"/>
- <xs:element name="P_KRS_NUMBER" minOccurs="0" type="p5Type:string"
- id="__COMPANIES___d18e16056-1_P_KRS_NUMB"/>
- <xs:element name="P_ZGODA_NA_PRZETWARZANIE_DANYCH_OSOBOWYCH" minOccurs="0"
- default="NIEWIADOMO" id="__COMPANIES___d18e16057-1_P_ZGODA_NA">
- <xs:simpleType id="__COMPANIES___d18e16058-1">
- <xs:restriction base="p5Type:string">
- <!--@2018-03-23 fixed blad piotrowego xsd:schema z api @2018-03-23 dla restriction enums-->
- <xs:enumeration value="TAK"/>
- <xs:enumeration value="NIE"/>
- <xs:enumeration value="NIEWIADOMO"/>
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <xs:element name="P_ZGODA_NA_OTRZYMYWANIE_FAKTUR_ELEKTRONICZNYCH" minOccurs="0"
- default="NIEWIADOMO" id="__COMPANIES___d18e16064-1_P_ZGODA_NA">
- <xs:simpleType id="__COMPANIES___d18e16065-1">
- <xs:restriction base="p5Type:string">
- <!--@2018-03-23 fixed blad piotrowego xsd:schema z api @2018-03-23 dla restriction enums-->
- <xs:enumeration value="TAK"/>
- <xs:enumeration value="NIE"/>
- <xs:enumeration value="NIEWIADOMO"/>
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <xs:element name="P_ZGODA_NA_UMIESZCZENIE_DANYCH_W_PUBLICZNYM_SPISIE_ABONENTOW"
- minOccurs="0" default="NIEWIADOMO" id="__COMPANIES___d18e16071-1_P_ZGODA_NA">
- <xs:simpleType id="__COMPANIES___d18e16072-1">
- <xs:restriction base="p5Type:string">
- <!--@2018-03-23 fixed blad piotrowego xsd:schema z api @2018-03-23 dla restriction enums-->
- <xs:enumeration value="TAK"/>
- <xs:enumeration value="NIE"/>
- <xs:enumeration value="NIEWIADOMO"/>
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <xs:element name="A_CLASSIFIED" minOccurs="0" type="p5Type:string"
- id="__COMPANIES___d18e16078-1_A_CLASSIFI"/>
- <xs:element name="CRM_LISTA_ZASOBOW_ID" minOccurs="0" type="p5Type:integer"
- id="__COMPANIES___d18e16079-1_CRM_LISTA_"/>
- <xs:element name="K_TYPE" minOccurs="0" default="INNY"
- id="__COMPANIES___d18e16080-1_K_TYPE">
- <xs:simpleType id="__COMPANIES___d18e16081-1">
- <xs:restriction base="p5Type:string">
- <!--@2018-03-23 fixed blad piotrowego xsd:schema z api @2018-03-23 dla restriction enums-->
- <xs:enumeration value="INNY"/>
- <xs:enumeration value="DOSTAWCA/ODBIORCA"/>
- <xs:enumeration value="ODBIORCA"/>
- <xs:enumeration value="DOSTAWCA"/>
- <xs:enumeration value="URZAD"/>
- <xs:enumeration value="INWESTOR"/>
- <xs:enumeration value="OS.FIZYCZNA"/>
- <xs:enumeration value="FIRMA"/>
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <xs:element name="P_ZGODA_NA_PRZETWARZANIE_NIP_KONTA_BANKOWEGO_EMAIL_NR_TEL" minOccurs="0"
- default="NIEWIADOMO" id="__COMPANIES___d18e16092-1_P_ZGODA_NA">
- <xs:simpleType id="__COMPANIES___d18e16093-1">
- <xs:restriction base="p5Type:string">
- <!--@2018-03-23 fixed blad piotrowego xsd:schema z api @2018-03-23 dla restriction enums-->
- <xs:enumeration value="TAK"/>
- <xs:enumeration value="NIE"/>
- <xs:enumeration value="NIEWIADOMO"/>
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <xs:element name="P_ZGODA_NA_PRZETWARZANIE_DANYCH_W_CELACH_MARKETINGOWYCH" minOccurs="0"
- default="NIEWIADOMO" id="__COMPANIES___d18e16099-1_P_ZGODA_NA">
- <xs:simpleType id="__COMPANIES___d18e16100-1">
- <xs:restriction base="p5Type:string">
- <!--@2018-03-23 fixed blad piotrowego xsd:schema z api @2018-03-23 dla restriction enums-->
- <xs:enumeration value="TAK"/>
- <xs:enumeration value="NIE"/>
- <xs:enumeration value="NIEWIADOMO"/>
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <xs:element name="P_ZGODA_NA_WYSŁANIE_PROPONOWANYCH_ZMIAN_W_UMOWIE" minOccurs="0"
- default="NIEWIADOMO" id="__COMPANIES___d18e16106-1_P_ZGODA_NA">
- <xs:simpleType id="__COMPANIES___d18e16107-1">
- <xs:restriction base="p5Type:string">
- <!--@2018-03-23 fixed blad piotrowego xsd:schema z api @2018-03-23 dla restriction enums-->
- <xs:enumeration value="TAK"/>
- <xs:enumeration value="NIE"/>
- <xs:enumeration value="NIEWIADOMO"/>
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <xs:element name="P_ZGODA_NA_KIEROWANIE_KORESP_DROGA_ELEKTRONICZNA" minOccurs="0"
- default="NIEWIADOMO" id="__COMPANIES___d18e16114-1_P_ZGODA_NA">
- <xs:simpleType id="__COMPANIES___d18e16115-1">
- <xs:restriction base="p5Type:string">
- <!--@2018-03-23 fixed blad piotrowego xsd:schema z api @2018-03-23 dla restriction enums-->
- <xs:enumeration value="TAK"/>
- <xs:enumeration value="NIE"/>
- <xs:enumeration value="NIEWIADOMO"/>
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <xs:element name="P_ZGODA_NA_WYSYLANIE_FAKTUR_ELEKTRONICZNIE" minOccurs="0"
- default="NIEWIADOMO" id="__COMPANIES___d18e16121-1_P_ZGODA_NA">
- <xs:simpleType id="__COMPANIES___d18e16122-1">
- <xs:restriction base="p5Type:string">
- <!--@2018-03-23 fixed blad piotrowego xsd:schema z api @2018-03-23 dla restriction enums-->
- <xs:enumeration value="TAK"/>
- <xs:enumeration value="NIE"/>
- <xs:enumeration value="NIEWIADOMO"/>
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <xs:element name="P_ZGODA_NA_POTW_PRZYJECIA_REKLAMACJI_ELEKTRONICZNIE" minOccurs="0"
- default="NIEWIADOMO" id="__COMPANIES___d18e16128-1_P_ZGODA_NA">
- <xs:simpleType id="__COMPANIES___d18e16129-1">
- <xs:restriction base="p5Type:string">
- <!--@2018-03-23 fixed blad piotrowego xsd:schema z api @2018-03-23 dla restriction enums-->
- <xs:enumeration value="TAK"/>
- <xs:enumeration value="NIE"/>
- <xs:enumeration value="NIEWIADOMO"/>
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <xs:element name="P_ZGODA_NA_ZAMIESZCZENIE_DANYCH_W_SPISIE_ABONENTOW" minOccurs="0"
- default="NIEWIADOMO" id="__COMPANIES___d18e16135-1_P_ZGODA_NA">
- <xs:simpleType id="__COMPANIES___d18e16136-1">
- <xs:restriction base="p5Type:string">
- <!--@2018-03-23 fixed blad piotrowego xsd:schema z api @2018-03-23 dla restriction enums-->
- <xs:enumeration value="TAK"/>
- <xs:enumeration value="NIE"/>
- <xs:enumeration value="NIEWIADOMO"/>
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <xs:element name="bank" minOccurs="0" type="p5Type:string"
- id="__COMPANIES___d18e16142-1_bank"/>
- <xs:element name="nr_rach" minOccurs="0" type="p5Type:string"
- id="__COMPANIES___d18e16143-1_nr_rach"/>
- <xs:element name="TAXPAYER_ID_BILLING_USERS" minOccurs="0" default="0"
- type="p5Type:integer" id="__COMPANIES___d18e16144-1_TAXPAYER_I"/>
- <xs:element maxOccurs="unbounded" minOccurs="0" ref="default_db__x3A__PROBLEMS:PROBLEMS"
- id="__COMPANIES___d18e16145-1"/>
- <xs:element maxOccurs="unbounded" minOccurs="0"
- ref="default_db__x3A__BILLING_NUMBERS:BILLING_NUMBERS_BILLS_FVAT"
- id="__COMPANIES___d18e16146-1">
- <!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
- <xs:annotation>
- <xs:appinfo>
- <system_cache__appinfo:flat_relation_cache system_cache__appinfo:backref_evaluate="true"><!-- todo czy backref jest potrzebny... -->
- <system_cache__appinfo:source system_cache__appinfo:ref_engine="view" system_cache__appinfo:name="ID" system_cache__appinfo:xpath="default_db__x3A__BILLING_NUMBERS:BILLING_NUMBERS_BILLS_FVAT/ID_BILLING_USERS"/>
- </system_cache__appinfo:flat_relation_cache>
- </xs:appinfo>
- <xs:documentation>FAKTURY DO OGLADANIA</xs:documentation>
- </xs:annotation>
- </xs:element>
- </xs:sequence>
- <xs:attribute name="label" type="xs:string" id="__COMPANIES___d18e16154-1_label"/>
- <xs:assert test="@label = concat(P_NAME, ' ', P_NAME_SECOND)" id="__COMPANIES___d18e16155-1"/>
- </xs:complexType>
- <xs:element name="COMPANIES" type="default_db__x3A__COMPANIES:COMPANIES"
- id="__COMPANIES___d5e7461-1_COMPANIES">
- <xs:key name="COMPANIES">
- <xs:selector xpath="."/>
- <xs:field xpath="P_NAME"/>
- <xs:field xpath="P_NAME_SECOND"/>
- </xs:key>
- </xs:element>
- <xs:element name="ID_BILLING_USERS" id="__COMPANIES___d5e7466-1_ID_BILLING"
- type="default_db__x3A__COMPANIES:COMPANIES">
- <xs:key name="ID_BILLING_USERS">
- <xs:selector xpath="."/>
- <xs:field xpath="P_NAME"/>
- <xs:field xpath="P_NAME_SECOND"/>
- </xs:key>
- </xs:element>
- <xs:element name="ID_BILLING_USERS_ADMIN" type="default_db__x3A__COMPANIES:COMPANIES"
- id="__COMPANIES___d18e16166-1_ID_BILLING">
- <!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
- <xs:annotation>
- <xs:documentation>Np. Dowiązanie tego obiektu w ramach BUILDINGS określa, że obiekt jest administratorem danej nieruchomości. </xs:documentation>
- </xs:annotation>
- </xs:element>
- <xs:element name="KONTRAHENT" type="default_db__x3A__COMPANIES:COMPANIES"
- id="__COMPANIES___d5e7475-1_KONTRAHENT">
- <xs:key name="KONTRAHENT">
- <xs:selector xpath="."/>
- <xs:field xpath="P_NAME"/>
- <xs:field xpath="P_NAME_SECOND"/>
- </xs:key>
- </xs:element>
- <xs:element name="DOSTAWCA" type="default_db__x3A__COMPANIES:COMPANIES"
- id="__COMPANIES___d18e16175-1_DOSTAWCA">
- <!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
- <xs:annotation>
- <xs:documentation>na potrzeby SIGMA</xs:documentation>
- </xs:annotation>
- </xs:element>
- </xs:schema>
|