se/SE/schema/ant-object/default_db.BILLING_NUMBERS/BILLING_NUMBERS/BILLING_NUMBERS.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__BILLING_NUMBERS="https://biuro.biall-net.pl/wfs/default_db/table/BILLING_NUMBERS.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"
   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"
   targetNamespace="https://biuro.biall-net.pl/wfs/default_db/table/BILLING_NUMBERS.xsd"
   vc:minVersion="1.1"
   xmlns:default_db__x3A__BILLING_NUMBERS_TYPE="https://biuro.biall-net.pl/wfs/default_db/table/BILLING_NUMBERS_TYPE.xsd"
   xmlns:default_db__x3A__COMPANIES="https://biuro.biall-net.pl/wfs/default_db/table/COMPANIES.xsd"
   xmlns:default_db__x3A__BILLS_FVAT="https://biuro.biall-net.pl/wfs/default_db/table/BILLS_FVAT.xsd">
   <xs:annotation>
      <xs:documentation>Proba zamodelowania faktur dla raportow sprzedazy
TODO niegotowy, koncepcyjny @2018-03</xs:documentation>
   </xs:annotation>
   <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/COMPANIES.xsd"
      schemaLocation="../../default_db.COMPANIES/COMPANIES/COMPANIES.xsd"/>
   <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/table/BILLS_FVAT.xsd"
      schemaLocation="../../default_db.BILLS_FVAT/BILLS_FVAT/BILLS_FVAT.xsd"/>
   <xs:simpleType name="A_STATUS_Type">
      <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="BILLING_NUMBERS">
      <xs:annotation>
         <xs:appinfo>
            <system_cache__appinfo:heritage>
               <system_cache__appinfo:inherit system_cache__appinfo:inherit_ref="default_db:BILLING_NUMBERS" 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>
         <xs:element name="ID" type="xs:integer"/>
         <xs:element name="TIMESTAMP" type="xs:string"/>
         <xs:element name="ID_BILLING_NUMBERS_TYPE" type="xs:integer"/>
         <xs:choice>
            <xs:element ref="default_db__x3A__BILLING_NUMBERS_TYPE:BILLING_NUMBERS_TYPE">
               <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_BILLING_NUMBERS_TYPE"/>
                  </system_cache__appinfo:flat_relation_cache>
               </xs:appinfo>
               </xs:annotation>
            </xs:element>
            <xs:element
               ref="default_db__x3A__BILLING_NUMBERS_TYPE:BILLING_NUMBERS_TYPE_SELL_WINIEN__BILLS_FVAT"/>
            <xs:element
               ref="default_db__x3A__BILLING_NUMBERS_TYPE:BILLING_NUMBERS_TYPE_SELL_WINIEN__BILLS_RU"
            />
         </xs:choice>
         <xs:element name="ID_BILLING_PREFIXES" type="xs:integer"/>
         <xs:element name="NUMBER" type="xs:integer"/>
         <xs:element name="ID_BILLING_USERS" type="xs:integer"/>
         <xs:element ref="default_db__x3A__COMPANIES:ID_BILLING_USERS">
            <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_USERS" system_cache__appinfo:xpath="default_db__x3A__COMPANIES:ID_BILLING_USERS/ID"/>
                  </system_cache__appinfo:flat_relation_cache>
               </xs:appinfo>
            </xs:annotation>
         </xs:element>
      </xs:sequence>
      <xs:assert
         test="ID_BILLING_PREFIXES = default_db__x3A__COMPANIES:ID_BILLING_USERS/ID_BILLING_PREFIXES">
         <xs:annotation>
            <xs:documentation>Prefix dla faktur bierzse sie z klienta</xs:documentation>
         </xs:annotation>
      </xs:assert>
   </xs:complexType>
   <xs:complexType name="BILLING_NUMBERS_BILLS_FVAT">
      <xs:complexContent>
         <xs:restriction base="default_db__x3A__BILLING_NUMBERS:BILLING_NUMBERS">
            <xs:sequence>
               <xs:element name="ID" type="xs:integer"/>
               <xs:element name="TIMESTAMP" type="xs:string"/>
               <xs:element name="ID_BILLING_NUMBERS_TYPE" type="xs:integer"/>
               <xs:choice>
                  <xs:element ref="default_db__x3A__BILLING_NUMBERS_TYPE:BILLING_NUMBERS_TYPE"
                     maxOccurs="0" minOccurs="0">
                     <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_BILLING_NUMBERS_TYPE"/>
                  </system_cache__appinfo:flat_relation_cache>
               </xs:appinfo>
                     </xs:annotation>
                  </xs:element>
                  <xs:sequence>
                     <xs:element
                        ref="default_db__x3A__BILLING_NUMBERS_TYPE:BILLING_NUMBERS_TYPE_SELL_WINIEN__BILLS_FVAT"
                     />
                  </xs:sequence>
                  <xs:element
                     ref="default_db__x3A__BILLING_NUMBERS_TYPE:BILLING_NUMBERS_TYPE_SELL_WINIEN__BILLS_RU"
                     maxOccurs="0" minOccurs="0"/>
               </xs:choice>
               <xs:element name="ID_BILLING_PREFIXES" type="xs:integer"/>
               <xs:element name="NUMBER" type="xs:integer"/>
               <xs:element name="ID_BILLING_USERS" type="xs:integer"/>
               <xs:element ref="default_db__x3A__COMPANIES:ID_BILLING_USERS">
                  <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_USERS" system_cache__appinfo:xpath="default_db__x3A__COMPANIES:ID_BILLING_USERS/ID"/>
                  </system_cache__appinfo:flat_relation_cache>
               </xs:appinfo>
                  </xs:annotation>
               </xs:element>
            </xs:sequence>
            <xs:assert
               test="ID_BILLING_NUMBERS_TYPE = default_db__x3A__BILLING_NUMBERS_TYPE:BILLING_NUMBERS_TYPE_SELL_WINIEN__BILLS_FVAT/ID">
               <xs:annotation>
                  <xs:documentation>Typ danych dla wprowadzania faktury</xs:documentation>
               </xs:annotation>
            </xs:assert>
            <xs:assert
               test="ID_BILLING_PREFIXES = default_db__x3A__COMPANIES:ID_BILLING_USERS/ID_BILLING_PREFIXES">
               <xs:annotation>
                  <xs:documentation>Prefix dla faktur bierzse sie z klienta</xs:documentation>
               </xs:annotation>
            </xs:assert>
            <xs:assert test="ID_BILLING_USERS = default_db__x3A__COMPANIES:ID_BILLING_USERS/ID">
               <xs:annotation>
                  <xs:documentation>Płatnik to ID z Companies</xs:documentation>
               </xs:annotation>
            </xs:assert>
         </xs:restriction>
      </xs:complexContent>
   </xs:complexType>
   <xs:element name="BILLING_NUMBERS_BILLS_FVAT"
      type="default_db__x3A__BILLING_NUMBERS:BILLING_NUMBERS_BILLS_FVAT">
      <xs:annotation>
         <xs:documentation>Obiekt do wystawiania lub/i przegladania faktur</xs:documentation>
      </xs:annotation>
   </xs:element>
   <xs:element name="BILLING_NUMBERS" type="default_db__x3A__BILLING_NUMBERS:BILLING_NUMBERS"/>
</xs:schema>