se/SE/schema/ant-object/default_db.BILLS_FVAT/BILLS_FVAT/BILLS_FVAT.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__BILLS_FVAT="https://biuro.biall-net.pl/wfs/default_db/table/BILLS_FVAT.xsd"
           xmlns:default_db__x3A__BILLS_FVAT_POS="https://biuro.biall-net.pl/wfs/default_db/table/BILLS_FVAT_POS.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:default_db__x3A__COMPANIES="https://biuro.biall-net.pl/wfs/default_db/table/COMPANIES.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/BILLS_FVAT.xsd"
           vc:minVersion="1.1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
   <xs:annotation>
      <xs:documentation>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/BILLS_FVAT_POS.xsd"
              schemaLocation="../../default_db.BILLS_FVAT_POS/BILLS_FVAT_POS/BILLS_FVAT_POS.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/BILLING_NUMBERS.xsd"
              schemaLocation="../../default_db.BILLING_NUMBERS/BILLING_NUMBERS/BILLING_NUMBERS.xsd"/>
   <xs:simpleType name="A_STATUS_Type" id="_BILLS_FVAT___d5e75896-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="BILLS_FVAT" id="_BILLS_FVAT___d5e75905-1_BILLS_FVAT"><!--#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:BILLS_FVAT"
                                              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="_BILLS_FVAT___d5e75906-1">
         <xs:element name="ID" type="xs:integer" id="_BILLS_FVAT___d5e75922-1_ID"/>
         <xs:element name="ID_BILLING_NUMBERS"
                     type="xs:integer"
                     id="_BILLS_FVAT___d5e75923-1_ID_BILLING"/>
         <xs:element name="ID_BILLING_USERS"
                     type="xs:integer"
                     id="_BILLS_FVAT___d5e75924-1_ID_BILLING"/>
         <xs:element name="id_owner"
                     type="xs:integer"
                     id="_BILLS_FVAT___d5e75925-1_id_owner"/>
         <xs:element name="BILL_DATE"
                     type="xs:string"
                     id="_BILLS_FVAT___d5e75926-1_BILL_DATE"/>
         <xs:element name="SELL_DATE"
                     type="xs:string"
                     id="_BILLS_FVAT___d5e75927-1_SELL_DATE"/>
         <xs:element name="TIMESTAMP"
                     type="xs:string"
                     id="_BILLS_FVAT___d5e75928-1_TIMESTAMP"/>
         <xs:element name="PAYMENT_TERM"
                     type="xs:string"
                     id="_BILLS_FVAT___d5e75929-1_PAYMENT_TE"/>
         <xs:element name="PAYMENT_TYPE"
                     type="xs:integer"
                     id="_BILLS_FVAT___d5e75931-1_PAYMENT_TY"/>
         <xs:element name="ID_CURRENCY"
                     type="xs:integer"
                     id="_BILLS_FVAT___d5e75932-1_ID_CURRENC"/>
         <xs:element name="ID_FK_DEKRET"
                     type="xs:integer"
                     id="_BILLS_FVAT___d5e75933-1_ID_FK_DEKR"/>
         <xs:element name="ID_FK_ROZRACH"
                     type="xs:integer"
                     id="_BILLS_FVAT___d5e75934-1_ID_FK_ROZR"/>
         <xs:element name="OPEN" type="xs:string" id="_BILLS_FVAT___d5e75935-1_OPEN"/>
         <xs:element name="FK_ZAKSIEG"
                     type="xs:string"
                     id="_BILLS_FVAT___d5e75936-1_FK_ZAKSIEG"/>
         <xs:element name="IF_KORV"
                     type="xs:string"
                     id="_BILLS_FVAT___d5e75937-1_IF_KORV"/>
         <xs:element maxOccurs="unbounded"
                     minOccurs="0"
                     ref="default_db__x3A__BILLS_FVAT_POS:BILLS_FVAT_POS"
                     id="_BILLS_FVAT___d5e75976-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" -->
                     <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_BILLS_FVAT"/>
                  </system_cache__appinfo:flat_relation_cache>
               </xs:appinfo>
               <xs:documentation>na razie backref od BILLS_FVAT_POS moze nie byc potrzebny</xs:documentation>
            </xs:annotation>
         </xs:element>
      </xs:sequence>
      <xs:attribute name="sum.wo_tax"
                    type="xs:double"
                    id="_BILLS_FVAT___d18e39152-1_sum.wo_tax"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
         <xs:annotation>
            <xs:documentation>powinno się to dynamicznie sumować</xs:documentation>
         </xs:annotation>
      </xs:attribute>
      <xs:attribute name="sum.w_tax"
                    type="xs:double"
                    id="_BILLS_FVAT___d18e39156-1_sum.w_tax"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
         <xs:annotation>
            <xs:documentation>Powinno sie to dynamicznie sumowac</xs:documentation>
         </xs:annotation>
      </xs:attribute>
      <xs:attribute name="positions"
                    type="xs:int"
                    id="_BILLS_FVAT___d18e39160-1_positions"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
         <xs:annotation>
            <xs:documentation>Powinna się dynamicznie tworzyć ilość pozycji</xs:documentation>
         </xs:annotation>
      </xs:attribute>
      <xs:assert test="ID = default_db__x3A__BILLS_FVAT_POS:BILLS_FVAT_POS/ID_BILLS_FVAT"
                 id="_BILLS_FVAT___d18e39164-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
         <xs:annotation>
            <xs:documentation>Wystwietlamy lub/i dzialamy tylko dla swoich rekordow pozycji</xs:documentation>
         </xs:annotation>
      </xs:assert>
      <xs:assert test="@positions = count(default_db__x3A__BILLS_FVAT_POS:BILLS_FVAT_POS/*)"
                 id="_BILLS_FVAT___d18e39168-1"/>
      <xs:assert test="@sum.wo_tax = sum(default_db__x3A__BILLS_FVAT_POS:BILLS_FVAT_POS/(AMMOUNT * PRICE))"
                 id="_BILLS_FVAT___d18e39169-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
         <xs:annotation>
            <xs:documentation>Cos mniej wiecej w ten sposob powinno liczyc. Stawki poszczegolne VATu powinny byc zrobione przez inna strukture, ktora by trzymala jednak wyliczenia gdzies w bazie - bo tak trudno sie to wylicza jakos w powietrzu.</xs:documentation>
         </xs:annotation>
      </xs:assert>
      <xs:assert test="@sum.w_tax = sum(default_db__x3A__BILLS_FVAT_POS:BILLS_FVAT_POS/(AMMOUNT * PRICE * VAT))"
                 id="_BILLS_FVAT___d18e39173-1"/>
   </xs:complexType>
   <xs:complexType name="BILLS_FVAT_open" id="_BILLS_FVAT___d18e39175-1_BILLS_FVAT">
      <xs:complexContent id="_BILLS_FVAT___d18e39176-1">
         <xs:extension base="default_db__x3A__BILLS_FVAT:BILLS_FVAT"
                       id="_BILLS_FVAT___d18e39177-1"/>
      </xs:complexContent>
   </xs:complexType>
   <xs:complexType name="BILLS_FVAT_closed" id="_BILLS_FVAT___d18e39178-1_BILLS_FVAT">
      <xs:complexContent id="_BILLS_FVAT___d18e39179-1">
         <xs:extension base="default_db__x3A__BILLS_FVAT:BILLS_FVAT"
                       id="_BILLS_FVAT___d18e39180-1"/>
      </xs:complexContent>
   </xs:complexType>
   <xs:complexType name="BILLS_FVAT_corrected" id="_BILLS_FVAT___d18e39181-1_BILLS_FVAT"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
      <xs:annotation>
         <xs:documentation>todo</xs:documentation>
      </xs:annotation>
      <xs:complexContent id="_BILLS_FVAT___d18e39185-1">
         <xs:extension base="default_db__x3A__BILLS_FVAT:BILLS_FVAT_closed"
                       id="_BILLS_FVAT___d18e39186-1"/>
      </xs:complexContent>
   </xs:complexType>
   <xs:element name="BILLS_FVAT"
               type="default_db__x3A__BILLS_FVAT:BILLS_FVAT"
               id="_BILLS_FVAT___d5e75938-1_BILLS_FVAT"/>
</xs:schema>