se/SE/schema/table/USERS2_OFFERS.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__USERS2_OFFERS="https://biuro.biall-net.pl/wfs/default_db/table/USERS2_OFFERS.xsd"
           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"
           targetNamespace="https://biuro.biall-net.pl/wfs/default_db/table/USERS2_OFFERS.xsd"
           vc:minVersion="1.1">
   <xs:import namespace="http://www.opengis.net/gml/3.2"
              schemaLocation="../Types/gml.xsd"/>
   <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/table/IN7_DZIENNIK_KORESP.xsd"
              schemaLocation="../table/IN7_DZIENNIK_KORESP.xsd"/>
   <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/table/IN7_MK_BAZA_DYSTRYBUCJI.xsd"
              schemaLocation="../table/IN7_MK_BAZA_DYSTRYBUCJI.xsd"/>
   <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/SystemObjects/AccessGroup.xsd"
              schemaLocation="../SystemObjects/AccessGroup.xsd"/>
   <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/SystemObjects/AccessOwner.xsd"
              schemaLocation="../SystemObjects/AccessOwner.xsd"/>
   <xs:simpleType name="A_STATUS_Type" id="ERS2_OFFERS___d5e91090-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="USERS2_OFFERS" id="ERS2_OFFERS___d5e91099-1_USERS2_OFF">
      <xs:sequence id="ERS2_OFFERS___d5e91100-1">
         <xs:element ref="SystemObjects__x3A__AccessOwner:AccessOwner"
                     id="ERS2_OFFERS___d5e91101-1">
            <xs:annotation>
               <xs:appinfo>
                  <system_cache__appinfo:flat_relation_cache>
                     <system_cache__appinfo:source system_cache__appinfo:name="L_APPOITMENT_USER"
                                                   system_cache__appinfo:xpath="SystemObjects__x3A__AccessOwner:AccessOwner/login"/>
                  </system_cache__appinfo:flat_relation_cache>
               </xs:appinfo>
            </xs:annotation>
         </xs:element>
         <xs:element ref="SystemObjects__x3A__AccessGroup:AccessGroupRead"
                     id="ERS2_OFFERS___d5e91106-1">
            <xs:annotation>
               <xs:appinfo>
                  <system_cache__appinfo:flat_relation_cache>
                     <system_cache__appinfo:source system_cache__appinfo:name="A_CLASSIFIED"
                                                   system_cache__appinfo:xpath="SystemObjects__x3A__AccessGroup:AccessGroupRead/uid"/>
                  </system_cache__appinfo:flat_relation_cache>
               </xs:appinfo>
            </xs:annotation>
         </xs:element>
         <xs:element ref="SystemObjects__x3A__AccessGroup:AccessGroupWrite"
                     id="ERS2_OFFERS___d5e91111-1">
            <xs:annotation>
               <xs:appinfo>
                  <system_cache__appinfo:flat_relation_cache>
                     <system_cache__appinfo:source system_cache__appinfo:name="A_ADM_COMPANY"
                                                   system_cache__appinfo:xpath="SystemObjects__x3A__AccessGroup:AccessGroupWrite/uid"/>
                  </system_cache__appinfo:flat_relation_cache>
               </xs:appinfo>
            </xs:annotation>
         </xs:element>
         <xs:element name="ID" type="xs:integer" id="ERS2_OFFERS___d5e91116-1_ID"/>
         <xs:element name="A_ID_USERS2"
                     type="xs:integer"
                     id="ERS2_OFFERS___d5e91117-1_A_ID_USERS"/>
         <xs:element name="A_RECORD_CREATE_DATE"
                     type="xs:string"
                     id="ERS2_OFFERS___d5e91118-1_A_RECORD_C"/>
         <xs:element name="A_RECORD_CREATE_AUTHOR"
                     type="xs:string"
                     id="ERS2_OFFERS___d5e91119-1_A_RECORD_C"/>
         <xs:element name="A_RECORD_UPDATE_DATE"
                     type="xs:string"
                     id="ERS2_OFFERS___d5e91120-1_A_RECORD_U"/>
         <xs:element name="A_RECORD_UPDATE_AUTHOR"
                     type="xs:string"
                     id="ERS2_OFFERS___d5e91121-1_A_RECORD_U"/>
         <xs:element name="TAB_UPDATE_STAT"
                     type="xs:string"
                     id="ERS2_OFFERS___d5e91122-1_TAB_UPDATE"/>
         <xs:element name="TAB_UPDATE_DATE"
                     type="xs:token"
                     id="ERS2_OFFERS___d5e91123-1_TAB_UPDATE"/>
         <xs:element name="TAB_UPDATE_INFO"
                     type="xs:string"
                     id="ERS2_OFFERS___d5e91125-1_TAB_UPDATE"/>
         <xs:element name="L_APPOITMENT_DATE"
                     type="xs:string"
                     id="ERS2_OFFERS___d5e91126-1_L_APPOITME"/>
         <xs:element name="L_APPOITMENT_USER"
                     type="xs:string"
                     id="ERS2_OFFERS___d5e91127-1_L_APPOITME"/>
         <xs:element name="L_APPOITMENT_PERIOD"
                     type="xs:string"
                     id="ERS2_OFFERS___d5e91128-1_L_APPOITME"/>
         <xs:element name="L_APPOITMENT_INFO"
                     type="xs:string"
                     id="ERS2_OFFERS___d5e91129-1_L_APPOITME"/>
         <xs:element name="L_APPOITMENT_TYPE"
                     type="xs:string"
                     id="ERS2_OFFERS___d5e91130-1_L_APPOITME"/>
         <xs:element name="A_PROBLEM"
                     type="xs:string"
                     id="ERS2_OFFERS___d5e91131-1_A_PROBLEM"/>
         <xs:element name="A_PROBLEM_DESC"
                     type="xs:string"
                     id="ERS2_OFFERS___d5e91132-1_A_PROBLEM_"/>
         <xs:element name="A_PROBLEM_DATE"
                     type="xs:string"
                     id="ERS2_OFFERS___d5e91133-1_A_PROBLEM_"/>
         <xs:element name="A_STATUS"
                     type="xs:string"
                     id="ERS2_OFFERS___d5e91134-1_A_STATUS"/>
         <xs:element name="A_STATUS_CURRENT"
                     type="xs:string"
                     id="ERS2_OFFERS___d5e91135-1_A_STATUS_C"/>
         <xs:element name="A_STATUS_INFO"
                     type="xs:string"
                     id="ERS2_OFFERS___d5e91137-1_A_STATUS_I"/>
         <xs:element name="A_STATUS_LASTCHANGE_DATE"
                     type="xs:string"
                     id="ERS2_OFFERS___d5e91138-1_A_STATUS_L"/>
         <xs:element name="A_UPDATE_DATE"
                     type="xs:string"
                     id="ERS2_OFFERS___d5e91139-1_A_UPDATE_D"/>
         <xs:element name="A_ADM_COMPANY"
                     type="xs:string"
                     id="ERS2_OFFERS___d5e91140-1_A_ADM_COMP"/>
         <xs:element name="S_ALIAS"
                     type="xs:string"
                     id="ERS2_OFFERS___d5e91141-1_S_ALIAS"/>
         <xs:element name="S_ADDRESS_CITY"
                     type="xs:string"
                     id="ERS2_OFFERS___d5e91142-1_S_ADDRESS_"/>
         <xs:element name="S_ADDRESS_POST_CODE"
                     type="xs:string"
                     id="ERS2_OFFERS___d5e91143-1_S_ADDRESS_"/>
         <xs:element name="S_ADDRESS_POST_OFFICE"
                     type="xs:string"
                     id="ERS2_OFFERS___d5e91144-1_S_ADDRESS_"/>
         <xs:element name="S_ADDRESS_STREET"
                     type="xs:string"
                     id="ERS2_OFFERS___d5e91145-1_S_ADDRESS_"/>
         <xs:element name="S_ADDRESS_HOUSE"
                     type="xs:string"
                     id="ERS2_OFFERS___d5e91146-1_S_ADDRESS_"/>
         <xs:element name="S_OTHER_INFO"
                     type="xs:string"
                     id="ERS2_OFFERS___d5e91147-1_S_OTHER_IN"/>
         <xs:element name="S_VIP_LEVEL"
                     type="xs:string"
                     id="ERS2_OFFERS___d5e91149-1_S_VIP_LEVE"/>
         <xs:element name="S_VIP_DESC"
                     type="xs:string"
                     id="ERS2_OFFERS___d5e91150-1_S_VIP_DESC"/>
         <xs:element name="T_NETWORK_SERVER"
                     type="xs:string"
                     id="ERS2_OFFERS___d5e91151-1_T_NETWORK_"/>
         <xs:element name="T_TELBOX_ADDRESS"
                     type="xs:string"
                     id="ERS2_OFFERS___d5e91152-1_T_TELBOX_A"/>
         <xs:element name="T_WORKPOINTS"
                     type="xs:string"
                     id="ERS2_OFFERS___d5e91153-1_T_WORKPOIN"/>
         <xs:element name="T_WORKPOINTS_VALUE"
                     type="xs:string"
                     id="ERS2_OFFERS___d5e91154-1_T_WORKPOIN"/>
         <xs:element name="T_WORKPOINTS_TYPE"
                     type="xs:string"
                     id="ERS2_OFFERS___d5e91155-1_T_WORKPOIN"/>
         <xs:element name="T_WORKPOINTS_USER"
                     type="xs:string"
                     id="ERS2_OFFERS___d5e91156-1_T_WORKPOIN"/>
         <xs:element name="T_WORKPOINTS_DATE"
                     type="xs:string"
                     id="ERS2_OFFERS___d5e91157-1_T_WORKPOIN"/>
         <xs:element name="T_PENALTIES"
                     type="xs:string"
                     id="ERS2_OFFERS___d5e91158-1_T_PENALTIE"/>
         <xs:element name="T_PENALTIES_TYPE"
                     type="xs:string"
                     id="ERS2_OFFERS___d5e91159-1_T_PENALTIE"/>
         <xs:element name="T_PENALTIES_VALUE"
                     type="xs:string"
                     id="ERS2_OFFERS___d5e91161-1_T_PENALTIE"/>
         <xs:element name="P_NAME" type="xs:string" id="ERS2_OFFERS___d5e91162-1_P_NAME"/>
         <xs:element name="P_SERVICE"
                     type="xs:string"
                     id="ERS2_OFFERS___d5e91163-1_P_SERVICE"/>
         <xs:element name="P_SERVICE_PARENT"
                     type="xs:string"
                     id="ERS2_OFFERS___d5e91164-1_P_SERVICE_"/>
         <xs:element name="P_SERVICE_COMPANY"
                     type="xs:string"
                     id="ERS2_OFFERS___d5e91165-1_P_SERVICE_"/>
         <xs:element name="P_SERVICE_NAME"
                     type="xs:string"
                     id="ERS2_OFFERS___d5e91166-1_P_SERVICE_"/>
         <xs:element name="USERS2_OFFERS_GROUPS_ID"
                     type="xs:integer"
                     id="ERS2_OFFERS___d5e91167-1_USERS2_OFF"/>
         <xs:element name="P_PROMOTION_NAME"
                     type="xs:string"
                     id="ERS2_OFFERS___d5e91168-1_P_PROMOTIO"/>
         <xs:element name="P_S_PARAM1"
                     type="xs:string"
                     id="ERS2_OFFERS___d5e91169-1_P_S_PARAM1"/>
         <xs:element name="P_S_PARAM2"
                     type="xs:string"
                     id="ERS2_OFFERS___d5e91170-1_P_S_PARAM2"/>
         <xs:element name="P_S_LIMIT"
                     type="xs:string"
                     id="ERS2_OFFERS___d5e91171-1_P_S_LIMIT"/>
         <xs:element name="P_S_LAN"
                     type="xs:string"
                     id="ERS2_OFFERS___d5e91173-1_P_S_LAN"/>
         <xs:element name="P_DEALTERM_MONTHS"
                     type="xs:integer"
                     id="ERS2_OFFERS___d5e91174-1_P_DEALTERM"/>
         <xs:element name="P_DEAL_PROMO_MONTHS"
                     type="xs:integer"
                     id="ERS2_OFFERS___d5e91175-1_P_DEAL_PRO"/>
         <xs:element name="STAWKA_VAT"
                     type="xs:integer"
                     id="ERS2_OFFERS___d5e91176-1_STAWKA_VAT"/>
         <xs:element name="P_INSTALL_QUOTE"
                     type="xs:double"
                     id="ERS2_OFFERS___d5e91177-1_P_INSTALL_"/>
         <xs:element name="P_INSTALL_QUOTE_NORMAL"
                     type="xs:double"
                     id="ERS2_OFFERS___d5e91178-1_P_INSTALL_"/>
         <xs:element name="P_CONTRACT_PRICE"
                     type="xs:double"
                     id="ERS2_OFFERS___d5e91179-1_P_CONTRACT"/>
         <xs:element name="P_CONTRACT_PRICE_NETTO"
                     type="xs:double"
                     id="ERS2_OFFERS___d5e91180-1_P_CONTRACT"/>
         <xs:element name="P_PROMO_MONTH_PRICE"
                     type="xs:double"
                     id="ERS2_OFFERS___d5e91181-1_P_PROMO_MO"/>
         <xs:element name="P_PROMO_MONTH_PRICE_NETTO"
                     type="xs:double"
                     id="ERS2_OFFERS___d5e91182-1_P_PROMO_MO"/>
         <xs:element name="P_NORMAL_PRICE"
                     type="xs:double"
                     id="ERS2_OFFERS___d5e91183-1_P_NORMAL_P"/>
         <xs:element name="P_NORMAL_PRICE_NETTO"
                     type="xs:double"
                     id="ERS2_OFFERS___d5e91185-1_P_NORMAL_P"/>
         <xs:element name="P_S_MAILBOX_SIZE"
                     type="xs:string"
                     id="ERS2_OFFERS___d5e91186-1_P_S_MAILBO"/>
         <xs:element name="P_S_WWW_SIZE"
                     type="xs:string"
                     id="ERS2_OFFERS___d5e91187-1_P_S_WWW_SI"/>
         <xs:element name="P_OFFER_TERM_BEGIN"
                     type="xs:token"
                     id="ERS2_OFFERS___d5e91188-1_P_OFFER_TE"/>
         <xs:element name="P_OFFER_TERM"
                     type="xs:token"
                     id="ERS2_OFFERS___d5e91189-1_P_OFFER_TE"/>
         <xs:element name="T_TELBOX_BUILDING_IN"
                     type="xs:string"
                     id="ERS2_OFFERS___d5e91190-1_T_TELBOX_B"/>
         <xs:element name="BAD_DATE"
                     type="xs:token"
                     id="ERS2_OFFERS___d5e91191-1_BAD_DATE"/>
         <xs:element name="BAD_ZAINT"
                     type="xs:string"
                     id="ERS2_OFFERS___d5e91192-1_BAD_ZAINT"/>
         <xs:element name="M_REWIR"
                     type="xs:string"
                     id="ERS2_OFFERS___d5e91193-1_M_REWIR"/>
         <xs:element name="ID_COSTS_GROUPS"
                     type="xs:integer"
                     id="ERS2_OFFERS___d5e91194-1_ID_COSTS_G"/>
         <xs:element name="S_DEKODER_SD_OPTION"
                     type="xs:string"
                     id="ERS2_OFFERS___d5e91195-1_S_DEKODER_"/>
         <xs:element name="S_MODUL_PCMCIA_OPTION"
                     type="xs:string"
                     id="ERS2_OFFERS___d5e91197-1_S_MODUL_PC"/>
         <xs:element name="S_DEKODER_HD_OPTION"
                     type="xs:string"
                     id="ERS2_OFFERS___d5e91198-1_S_DEKODER_"/>
         <xs:element name="ID_PRODUKT"
                     type="xs:integer"
                     id="ERS2_OFFERS___d5e91199-1_ID_PRODUKT"/>
         <xs:element name="P_ACCOUNT"
                     type="xs:string"
                     id="ERS2_OFFERS___d5e91200-1_P_ACCOUNT"/>
         <xs:element name="P_SERVICE_QUOTA_PROFILE"
                     type="xs:string"
                     id="ERS2_OFFERS___d5e91201-1_P_SERVICE_"/>
         <xs:element name="LAN_DOWNLOAD"
                     type="xs:string"
                     id="ERS2_OFFERS___d5e91202-1_LAN_DOWNLO"/>
         <xs:element name="S_PUBLIC_IP"
                     type="xs:string"
                     id="ERS2_OFFERS___d5e91203-1_S_PUBLIC_I"/>
         <xs:element name="S_SOHO_WIFI_ROUTER_1292"
                     type="xs:string"
                     id="ERS2_OFFERS___d5e91204-1_S_SOHO_WIF"/>
         <xs:element name="S_E_PORT_1293"
                     type="xs:string"
                     id="ERS2_OFFERS___d5e91205-1_S_E_PORT_1"/>
         <xs:element name="P_DEVICE"
                     type="xs:string"
                     id="ERS2_OFFERS___d5e91206-1_P_DEVICE"/>
         <xs:element name="P_SERVICE_CLASS"
                     type="xs:string"
                     id="ERS2_OFFERS___d5e91207-1_P_SERVICE_"/>
         <xs:element name="P_SERVICE_SOCKETS_AMMOUNT_1298"
                     type="xs:string"
                     id="ERS2_OFFERS___d5e91209-1_P_SERVICE_"/>
         <xs:element name="ID_DOMAINS_PACKET_ID"
                     type="xs:string"
                     id="ERS2_OFFERS___d5e91210-1_ID_DOMAINS"/>
         <xs:element name="VOIP_FAX2EMAIL"
                     type="xs:string"
                     id="ERS2_OFFERS___d5e91211-1_VOIP_FAX2E"/>
         <xs:element name="ID_DOMAINS"
                     type="xs:string"
                     id="ERS2_OFFERS___d5e91212-1_ID_DOMAINS"/>
         <xs:element name="CONN_DIV"
                     type="xs:string"
                     id="ERS2_OFFERS___d5e91213-1_CONN_DIV"/>
         <xs:element name="P_SERVICE_QUOTA"
                     type="xs:integer"
                     id="ERS2_OFFERS___d5e91214-1_P_SERVICE_"/>
         <xs:element name="ID_PROCES"
                     type="xs:integer"
                     id="ERS2_OFFERS___d5e91215-1_ID_PROCES"/>
         <xs:element name="S_TECHNOLOGY"
                     type="xs:string"
                     id="ERS2_OFFERS___d5e91216-1_S_TECHNOLO"/>
         <xs:element name="A_CLASSIFIED"
                     type="xs:string"
                     id="ERS2_OFFERS___d5e91217-1_A_CLASSIFI"/>
         <xs:element name="P_MULTIROOM_ADD_CARDS"
                     type="xs:integer"
                     id="ERS2_OFFERS___d5e91218-1_P_MULTIROO"/>
         <xs:element name="P_MULTIROOM_ADD_DEKODER_SD"
                     type="xs:integer"
                     id="ERS2_OFFERS___d5e91219-1_P_MULTIROO"/>
         <xs:element name="P_MULTIROOM_ADD_DEKODER_HD"
                     type="xs:integer"
                     id="ERS2_OFFERS___d5e91221-1_P_MULTIROO"/>
         <xs:element name="P_MULTIROOM_ADD_MODUL_CAM"
                     type="xs:integer"
                     id="ERS2_OFFERS___d5e91222-1_P_MULTIROO"/>
         <xs:element name="P_SERVICE_UPLOAD_RATIO"
                     type="xs:string"
                     id="ERS2_OFFERS___d5e91223-1_P_SERVICE_"/>
         <xs:element name="ID_OFFER_NEW_SUGGESTED"
                     type="xs:integer"
                     id="ERS2_OFFERS___d5e91224-1_ID_OFFER_N"/>
         <xs:element name="STAT_SOLD_LAST_MONTH_QTY"
                     type="xs:integer"
                     id="ERS2_OFFERS___d5e91225-1_STAT_SOLD_"/>
         <xs:element name="STAT_USED_IN_OFFERS_GROUP_COUNT"
                     type="xs:integer"
                     id="ERS2_OFFERS___d5e91226-1_STAT_USED_"/>
         <xs:element name="PARENT_ID"
                     type="xs:integer"
                     id="ERS2_OFFERS___d5e91227-1_PARENT_ID"/>
         <xs:element name="CRM_LISTA_ZASOBOW_ID"
                     type="xs:integer"
                     id="ERS2_OFFERS___d5e91228-1_CRM_LISTA_"/>
      </xs:sequence>
   </xs:complexType>
   <xs:element name="USERS2_OFFERS"
               type="default_db__x3A__USERS2_OFFERS:USERS2_OFFERS"
               id="ERS2_OFFERS___d5e91229-1_USERS2_OFF"/>
</xs:schema>