se/SE/schema/ant-object/default_db.SERVICES/SERVICES/SERVICES.xsd

<?xml version="1.0" encoding="UTF-8"?>
<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema"
           xmlns:gml="http://www.opengis.net/gml/3.2"
           xmlns:Types__x3A__default_Default="https://biuro.biall-net.pl/wfs/default_db/Types/Default.xsd"
           xmlns:default_db__x3A__IN7_DZIENNIK_KORESP="https://biuro.biall-net.pl/wfs/default_db/table/IN7_DZIENNIK_KORESP.xsd"
           xmlns:hfp="http://www.w3.org/2001/XMLSchema-hasFacetAndProperty"
           xmlns:default_db__x3A__ADMIN_USERS="https://biuro.biall-net.pl/wfs/default_db/table/ADMIN_USERS.xsd"
           xmlns:default_db__x3A__IN7_MK_BAZA_DYSTRYBUCJI="https://biuro.biall-net.pl/wfs/default_db/table/IN7_MK_BAZA_DYSTRYBUCJI.xsd"
           xmlns:SystemObjects__x3A__AccessGroup="https://biuro.biall-net.pl/wfs/default_db/SystemObjects/AccessGroup.xsd"
           xmlns:SystemObjects__x3A__AccessOwner="https://biuro.biall-net.pl/wfs/default_db/SystemObjects/AccessOwner.xsd"
           xmlns:default_db__x3A__SERVICES="https://biuro.biall-net.pl/wfs/default_db/table/SERVICES.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_TYPE="https://biuro.biall-net.pl/wfs/default_db/table/BILLING_NUMBERS_TYPE.xsd"
           xmlns:default_db__x3A__DEALS_TABLE="https://biuro.biall-net.pl/wfs/default_db/table/DEALS_TABLE.xsd"
           xmlns:default_db__x3A__BILLS_FVAT_POS="https://biuro.biall-net.pl/wfs/default_db/table/BILLS_FVAT_POS.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"
           targetNamespace="https://biuro.biall-net.pl/wfs/default_db/table/SERVICES.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/IN7_DZIENNIK_KORESP.xsd"
              schemaLocation="../../default_db.IN7_DZIENNIK_KORESP/IN7_DZIENNIK_KORESP/IN7_DZIENNIK_KORESP.xsd"/>
   <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/table/IN7_MK_BAZA_DYSTRYBUCJI.xsd"
              schemaLocation="../../default_db.IN7_MK_BAZA_DYSTRYBUCJI/IN7_MK_BAZA_DYSTRYBUCJI/IN7_MK_BAZA_DYSTRYBUCJI.xsd"/>
   <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/table/BILLING_NUMBERS_TYPE.xsd"
              schemaLocation="../../default_db.BILLING_NUMBERS_TYPE/BILLING_NUMBERS_TYPE/BILLING_NUMBERS_TYPE.xsd"/>
   <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/table/DEALS_TABLE.xsd"
              schemaLocation="../../default_db.DEALS_TABLE/DEALS_TABLE/DEALS_TABLE.xsd"/>
   <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/table/BILLS_FVAT_POS.xsd"
              schemaLocation="../../default_db.BILLS_FVAT_POS/BILLS_FVAT_POS/BILLS_FVAT_POS.xsd"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
      <xs:annotation>
         <xs:documentation>Do wyliczenia raportu w zasadzie wystarcza nam pozycje faktur sprzedanych uslug</xs:documentation>
      </xs:annotation>
   </xs:import>
   <xs:simpleType name="A_STATUS_Type" id="A__SERVICES___d5e84557-1_A_STATUS_T">
      <xs:restriction base="xs:string">
         <xs:enumeration value="NORMAL"/>
         <xs:enumeration value="WAITING"/>
         <xs:enumeration value="MONITOR"/>
         <xs:enumeration value="DELETED"/>
         <xs:enumeration value="WARNING"/>
         <xs:enumeration value="OFF_SOFT"/>
         <xs:enumeration value="OFF_HARD"/>
      </xs:restriction>
   </xs:simpleType>
   <xs:complexType name="SERVICES" id="A__SERVICES___d5e84566-1_SERVICES"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
      <xs:annotation>
         <xs:appinfo>
            <system_cache__appinfo:heritage>
               <system_cache__appinfo:inherit system_cache__appinfo:inherit_ref="default_db:SERVICES"
                                              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="A_STATUS"/>
               </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="A__SERVICES___d5e84567-1">
         <xs:element name="ID" type="xs:integer" id="A__SERVICES___d5e84583-1_ID"/>
         <xs:element name="ID_BILLING_USERS"
                     type="xs:integer"
                     id="A__SERVICES___d5e84584-1_ID_BILLING"/>
         <xs:element name="NAME_LIST_SERVICES"
                     type="xs:string"
                     id="A__SERVICES___d5e84585-1_NAME_LIST_"/>
         <xs:element name="A_STATUS"
                     type="xs:string"
                     id="A__SERVICES___d5e84586-1_A_STATUS"/>
         <xs:element name="active" type="xs:string" id="A__SERVICES___d5e84587-1_active"/>
         <xs:element name="TAB_UPDATE_STAT"
                     type="xs:string"
                     id="A__SERVICES___d5e84588-1_TAB_UPDATE"/>
         <xs:element name="TAB_UPDATE_DATE"
                     type="xs:token"
                     id="A__SERVICES___d5e84589-1_TAB_UPDATE"/>
         <xs:element name="TAB_UPDATE_INFO"
                     type="xs:string"
                     id="A__SERVICES___d5e84590-1_TAB_UPDATE"/>
         <xs:element name="SERVICE_TYPE"
                     type="xs:string"
                     id="A__SERVICES___d5e84592-1_SERVICE_TY"/>
         <xs:element name="ID_BILLING_NUMBERS_TYPE"
                     type="xs:integer"
                     id="A__SERVICES___d5e84593-1_ID_BILLING"/>
         <xs:element ref="default_db__x3A__BILLING_NUMBERS_TYPE:BILLING_NUMBERS_TYPE"
                     id="A__SERVICES___d18e27640-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
            <xs:annotation>
               <xs:appinfo>
                  <system_cache__appinfo:flat_relation_cache>
                     <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
                                                   system_cache__appinfo:name="ID_BILLING_NUMBERS_TYPE"
                                                   system_cache__appinfo:xpath="default_db__x3A__BILLING_NUMBERS_TYPE:BILLING_NUMBERS_TYPE/ID"/>
                  </system_cache__appinfo:flat_relation_cache>
               </xs:appinfo>
            </xs:annotation>
         </xs:element>
         <xs:element name="ABONAMENT_PERIOD"
                     type="xs:integer"
                     id="A__SERVICES___d5e84594-1_ABONAMENT_"/>
         <xs:element name="ABONAMENT_VALUE"
                     type="xs:double"
                     id="A__SERVICES___d5e84595-1_ABONAMENT_"/>
         <xs:element name="VAT" type="xs:double" id="A__SERVICES___d5e84596-1_VAT"/>
         <xs:element name="ID_CURRENCY"
                     type="xs:integer"
                     id="A__SERVICES___d5e84597-1_ID_CURRENC"/>
         <xs:element name="ABONAMENT_PAYMENT"
                     type="xs:string"
                     id="A__SERVICES___d5e84598-1_ABONAMENT_"/>
         <xs:element name="ABONAMENT_START"
                     type="xs:integer"
                     id="A__SERVICES___d5e84599-1_ABONAMENT_"/>
         <xs:element name="MINIMUM_BILLING_VALUE"
                     type="xs:double"
                     id="A__SERVICES___d5e84600-1_MINIMUM_BI"/>
         <xs:element name="BILLED_TILL"
                     type="xs:token"
                     id="A__SERVICES___d5e84601-1_BILLED_TIL"/>
         <xs:element name="HANGUP_FROM"
                     type="xs:token"
                     id="A__SERVICES___d5e84602-1_HANGUP_FRO"/>
         <xs:element name="HANGUP_TILL"
                     type="xs:token"
                     id="A__SERVICES___d5e84604-1_HANGUP_TIL"/>
         <xs:element name="HANGUP_STATUS"
                     type="xs:string"
                     id="A__SERVICES___d5e84605-1_HANGUP_STA"/>
         <xs:element name="HANGUP_RATIO"
                     type="xs:double"
                     id="A__SERVICES___d5e84606-1_HANGUP_RAT"/>
         <xs:element name="TIMESTAMP"
                     type="xs:string"
                     id="A__SERVICES___d5e84607-1_TIMESTAMP"/>
         <xs:element name="P_ID_SERVICES"
                     type="xs:integer"
                     id="A__SERVICES___d5e84608-1_P_ID_SERVI"/>
         <xs:element ref="default_db__x3A__SERVICES:SERVICES" id="A__SERVICES___d18e27661-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
            <xs:annotation>
               <xs:appinfo>
                  <system_cache__appinfo:flat_relation_cache>
                     <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
                                                   system_cache__appinfo:name="P_ID_SERVICES"
                                                   system_cache__appinfo:xpath="default_db__x3A__SERVICES:SERVICES/ID"/>
                  </system_cache__appinfo:flat_relation_cache>
               </xs:appinfo>
            </xs:annotation>
         </xs:element>
         <xs:element name="uwagi" type="xs:string" id="A__SERVICES___d5e84609-1_uwagi"/>
         <xs:element name="ID_DEALS_TABLE"
                     type="xs:integer"
                     id="A__SERVICES___d5e84610-1_ID_DEALS_T"/>
         <xs:element ref="default_db__x3A__DEALS_TABLE:DEALS_TABLE"
                     id="A__SERVICES___d18e27668-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"><!-- to jest dodatkowa relacja, podstawowa powinna byc od umow  -->
                     <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
                                                   system_cache__appinfo:name="ID_DEALS_TABLE"
                                                   system_cache__appinfo:xpath="default_db__x3A__DEALS_TABLE:DEALS_TABLE/ID"/>
                  </system_cache__appinfo:flat_relation_cache>
               </xs:appinfo>
            </xs:annotation>
         </xs:element>
         <xs:element name="VAT_NAME"
                     type="xs:string"
                     id="A__SERVICES___d5e84611-1_VAT_NAME"/>
         <xs:element name="id_list_sww"
                     type="xs:integer"
                     id="A__SERVICES___d5e84612-1_id_list_sw"/>
         <xs:element name="SERV_ID_BILLING_PREFIXES"
                     type="xs:integer"
                     id="A__SERVICES___d5e84613-1_SERV_ID_BI"/>
         <xs:element name="ID_OFFERS"
                     type="xs:integer"
                     id="A__SERVICES___d5e84614-1_ID_OFFERS"/>
         <xs:element name="A_RECORD_CREATE_DATE"
                     type="xs:string"
                     id="A__SERVICES___d5e84616-1_A_RECORD_C"/>
         <xs:element name="A_RECORD_CREATE_AUTHOR"
                     type="xs:string"
                     id="A__SERVICES___d5e84617-1_A_RECORD_C"/>
         <xs:element name="A_RECORD_UPDATE_DATE"
                     type="xs:string"
                     id="A__SERVICES___d5e84618-1_A_RECORD_U"/>
         <xs:element name="A_RECORD_UPDATE_AUTHOR"
                     type="xs:string"
                     id="A__SERVICES___d5e84619-1_A_RECORD_U"/>
         <xs:element name="P_SERVICE_ORDERED_INSTALL_DATE_1297"
                     type="xs:token"
                     id="A__SERVICES___d5e84620-1_P_SERVICE_"/>
         <xs:element name="A_ADM_COMPANY"
                     type="xs:string"
                     id="A__SERVICES___d5e84621-1_A_ADM_COMP"/>
         <xs:element name="L_APPOITMENT_DATE"
                     type="xs:string"
                     id="A__SERVICES___d5e84622-1_L_APPOITME"/>
         <xs:element name="L_APPOITMENT_USER"
                     type="xs:string"
                     id="A__SERVICES___d5e84623-1_L_APPOITME"/>
         <xs:element name="L_APPOITMENT_PERIOD"
                     type="xs:string"
                     id="A__SERVICES___d5e84624-1_L_APPOITME"/>
         <xs:element name="L_APPOITMENT_INFO"
                     type="xs:string"
                     id="A__SERVICES___d5e84625-1_L_APPOITME"/>
         <xs:element name="L_APPOITMENT_TYPE"
                     type="xs:string"
                     id="A__SERVICES___d5e84626-1_L_APPOITME"/>
         <xs:element name="A_PROBLEM"
                     type="xs:string"
                     id="A__SERVICES___d5e84628-1_A_PROBLEM"/>
         <xs:element name="A_PROBLEM_DESC"
                     type="xs:string"
                     id="A__SERVICES___d5e84629-1_A_PROBLEM_"/>
         <xs:element name="A_PROBLEM_DATE"
                     type="xs:string"
                     id="A__SERVICES___d5e84630-1_A_PROBLEM_"/>
         <xs:element name="A_STATUS_INFO"
                     type="xs:string"
                     id="A__SERVICES___d5e84631-1_A_STATUS_I"/>
         <xs:element name="T_WORKPOINTS"
                     type="xs:string"
                     id="A__SERVICES___d5e84632-1_T_WORKPOIN"/>
         <xs:element name="T_WORKPOINTS_VALUE"
                     type="xs:string"
                     id="A__SERVICES___d5e84633-1_T_WORKPOIN"/>
         <xs:element name="T_WORKPOINTS_TYPE"
                     type="xs:string"
                     id="A__SERVICES___d5e84634-1_T_WORKPOIN"/>
         <xs:element name="T_WORKPOINTS_USER"
                     type="xs:string"
                     id="A__SERVICES___d5e84635-1_T_WORKPOIN"/>
         <xs:element name="T_WORKPOINTS_DATE"
                     type="xs:string"
                     id="A__SERVICES___d5e84636-1_T_WORKPOIN"/>
         <xs:element name="P_ACCOUNT"
                     type="xs:string"
                     id="A__SERVICES___d5e84637-1_P_ACCOUNT"/>
         <xs:element name="A_CLASSIFIED"
                     type="xs:string"
                     id="A__SERVICES___d5e84638-1_A_CLASSIFI"/>
         <xs:element name="S_ADDRESS_STREET"
                     type="xs:string"
                     id="A__SERVICES___d5e84640-1_S_ADDRESS_"/>
         <xs:element name="OLD_ID_SERVICES"
                     type="xs:integer"
                     id="A__SERVICES___d5e84641-1_OLD_ID_SER"/>
         <xs:element maxOccurs="unbounded"
                     minOccurs="0"
                     ref="default_db__x3A__BILLS_FVAT_POS:BILLS_FVAT_POS"
                     id="A__SERVICES___d18e27705-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
            <xs:annotation>
               <xs:appinfo>
                  <system_cache__appinfo:flat_relation_cache><!-- to jest dodatkowa relacja, podstawowa powinna byc od umow  -->
                     <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
                                                   system_cache__appinfo:name="ID"
                                                   system_cache__appinfo:xpath="default_db__x3A__BILLS_FVAT_POS:BILLS_FVAT_POS/ID_SERVICES"/>
                  </system_cache__appinfo:flat_relation_cache>
               </xs:appinfo>
               <xs:documentation>Do raportu wystarcza pozycje faktur. 
Ta relacja jest podstawowa, relacja od POZYCJI do SERVICES ustawiono jako backref</xs:documentation>
            </xs:annotation>
         </xs:element>
      </xs:sequence>
   </xs:complexType>
   <xs:element name="SERVICES"
               type="default_db__x3A__SERVICES:SERVICES"
               id="A__SERVICES___d5e84642-1_SERVICES"/>
</xs:schema>