BILLING_NUMBERS.xsd 15 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217
  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema"
  3. xmlns:gml="http://www.opengis.net/gml/3.2"
  4. xmlns:Types__x3A__default_Default="https://biuro.biall-net.pl/wfs/default_db/Types/Default.xsd"
  5. xmlns:default_db__x3A__IN7_DZIENNIK_KORESP="https://biuro.biall-net.pl/wfs/default_db/table/IN7_DZIENNIK_KORESP.xsd"
  6. xmlns:hfp="http://www.w3.org/2001/XMLSchema-hasFacetAndProperty"
  7. xmlns:default_db__x3A__ADMIN_USERS="https://biuro.biall-net.pl/wfs/default_db/table/ADMIN_USERS.xsd"
  8. xmlns:default_db__x3A__IN7_MK_BAZA_DYSTRYBUCJI="https://biuro.biall-net.pl/wfs/default_db/table/IN7_MK_BAZA_DYSTRYBUCJI.xsd"
  9. xmlns:SystemObjects__x3A__AccessGroup="https://biuro.biall-net.pl/wfs/default_db/SystemObjects/AccessGroup.xsd"
  10. xmlns:SystemObjects__x3A__AccessOwner="https://biuro.biall-net.pl/wfs/default_db/SystemObjects/AccessOwner.xsd"
  11. xmlns:default_db__x3A__BILLING_NUMBERS="https://biuro.biall-net.pl/wfs/default_db/table/BILLING_NUMBERS.xsd"
  12. xmlns:fix_se_defaultdb_schema="http://biuro.biall-net.pl/xmlschema_procesy5/WPS_Functions/fix_se_defaultdb_schema/fix_se_defaultdb_schema.xsd"
  13. xmlns:p5Type="http://biuro.biall-net.pl/p5/schema/types"
  14. xmlns:default_db__x3A__BILLING_NUMBERS_TYPE="https://biuro.biall-net.pl/wfs/default_db/table/BILLING_NUMBERS_TYPE.xsd"
  15. xmlns:default_db__x3A__COMPANIES="https://biuro.biall-net.pl/wfs/default_db/table/COMPANIES.xsd"
  16. xmlns:default_db__x3A__BILLS_FVAT="https://biuro.biall-net.pl/wfs/default_db/table/BILLS_FVAT.xsd"
  17. xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  18. xmlns:p5_tr_map="http://biuro.biall-net.pl/xmlschema_procesy5/default_db_xml_cache/procesy5_translate_map.xsd"
  19. xmlns:vc="http://www.w3.org/2007/XMLSchema-versioning"
  20. 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"
  21. xmlns:system_cache__appinfo="http://biuro.biall-net.pl/xmlschema_procesy5/default_db_xml_cache/appinfo.xsd"
  22. xmlns:p5opr="http://biuro.biall-net.pl/xmlschema_procesy5/system_cache/object_parent_relations/object_parent_relations.xsd"
  23. xmlns:p5_simpleSchema_map="http://biuro.biall-net.pl/xmlschema_procesy5/default_db_xml_cache/p5_simpleSchema_map.xsd"
  24. xmlns:ant-object="http://biuro.biall-net.pl/xmlschema_procesy5/ant-object/ant-object.xsd"
  25. xmlns:p5ant-interface="http://biuro.biall-net.pl/xmlschema_procesy5/WPS_Functions/ant_interface/ant_interface.xsd"
  26. targetNamespace="https://biuro.biall-net.pl/wfs/default_db/table/BILLING_NUMBERS.xsd"
  27. vc:minVersion="1.1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
  28. <xs:annotation>
  29. <xs:documentation>Proba zamodelowania faktur dla raportow sprzedazy
  30. TODO niegotowy, koncepcyjny @2018-03</xs:documentation>
  31. </xs:annotation>
  32. <xs:import namespace="http://biuro.biall-net.pl/p5/schema/types"
  33. schemaLocation="../../../types.xsd"/>
  34. <xs:import namespace="http://www.opengis.net/gml/3.2"
  35. schemaLocation="http://www.opengis.net/gml/3.2"/>
  36. <!---->
  37. <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/table/IN7_DZIENNIK_KORESP.xsd"
  38. schemaLocation="../../default_db.IN7_DZIENNIK_KORESP/IN7_DZIENNIK_KORESP/IN7_DZIENNIK_KORESP.xsd"/>
  39. <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/table/IN7_MK_BAZA_DYSTRYBUCJI.xsd"
  40. schemaLocation="../../default_db.IN7_MK_BAZA_DYSTRYBUCJI/IN7_MK_BAZA_DYSTRYBUCJI/IN7_MK_BAZA_DYSTRYBUCJI.xsd"/>
  41. <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/table/BILLING_NUMBERS_TYPE.xsd"
  42. schemaLocation="../../default_db.BILLING_NUMBERS_TYPE/BILLING_NUMBERS_TYPE/BILLING_NUMBERS_TYPE.xsd"/>
  43. <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/table/COMPANIES.xsd"
  44. schemaLocation="../../default_db.COMPANIES/COMPANIES/COMPANIES.xsd"/>
  45. <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/table/BILLS_FVAT.xsd"
  46. schemaLocation="../../default_db.BILLS_FVAT/BILLS_FVAT/BILLS_FVAT.xsd"/>
  47. <xs:simpleType name="A_STATUS_Type" id="ING_NUMBERS___d18e65209-1_A_STATUS_T">
  48. <xs:restriction base="xs:string">
  49. <xs:enumeration value="NORMAL"/>
  50. <xs:enumeration value="WAITING"/>
  51. <xs:enumeration value="MONITOR"/>
  52. <xs:enumeration value="DELETED"/>
  53. <xs:enumeration value="WARNING"/>
  54. <xs:enumeration value="OFF_SOFT"/>
  55. <xs:enumeration value="OFF_HARD"/>
  56. </xs:restriction>
  57. </xs:simpleType>
  58. <xs:complexType name="BILLING_NUMBERS" id="ING_NUMBERS___d18e65218-1_BILLING_NU"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
  59. <xs:annotation>
  60. <xs:appinfo>
  61. <system_cache__appinfo:heritage>
  62. <system_cache__appinfo:inherit system_cache__appinfo:inherit_ref="default_db:BILLING_NUMBERS"
  63. system_cache__appinfo:heritage_acl="true">
  64. <system_cache__appinfo:acl_rule_inherit_to_all_same_name_elements_and_refs/>
  65. <acl_rule_inherit_to_all_refs_by_primary/>
  66. <acl_rule_inherit_to_all_refs_by_local_element system_cache__appinfo:acl_rule_inherit_local_element_name="A_STATUS"/>
  67. </system_cache__appinfo:inherit>
  68. <system_cache__appinfo:exherit_all system_cache__appinfo:heritage_acl="true"
  69. system_cache__appinfo:heritage_sort="true"/>
  70. </system_cache__appinfo:heritage>
  71. </xs:appinfo>
  72. </xs:annotation>
  73. <xs:sequence id="ING_NUMBERS___d18e65227-1">
  74. <xs:element name="ID" type="xs:integer" id="ING_NUMBERS___d18e65228-1_ID"/>
  75. <xs:element name="TIMESTAMP"
  76. type="xs:string"
  77. id="ING_NUMBERS___d18e65229-1_TIMESTAMP"/>
  78. <xs:element name="ID_BILLING_NUMBERS_TYPE"
  79. type="xs:integer"
  80. id="ING_NUMBERS___d18e65230-1_ID_BILLING"/>
  81. <xs:choice id="ING_NUMBERS___d18e65231-1">
  82. <xs:element ref="default_db__x3A__BILLING_NUMBERS_TYPE:BILLING_NUMBERS_TYPE"
  83. id="ING_NUMBERS___d18e65232-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
  84. <xs:annotation>
  85. <xs:appinfo>
  86. <system_cache__appinfo:flat_relation_cache>
  87. <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
  88. system_cache__appinfo:name="ID_BILLING_NUMBERS_TYPE"
  89. system_cache__appinfo:xpath="default_db__x3A__BILLING_NUMBERS_TYPE:BILLING_NUMBERS_TYPE/ID_BILLING_NUMBERS_TYPE"/>
  90. </system_cache__appinfo:flat_relation_cache>
  91. </xs:appinfo>
  92. </xs:annotation>
  93. </xs:element>
  94. <xs:element ref="default_db__x3A__BILLING_NUMBERS_TYPE:BILLING_NUMBERS_TYPE_SELL_WINIEN__BILLS_FVAT"
  95. id="ING_NUMBERS___d18e65237-1"/>
  96. <xs:element ref="default_db__x3A__BILLING_NUMBERS_TYPE:BILLING_NUMBERS_TYPE_SELL_WINIEN__BILLS_RU"
  97. id="ING_NUMBERS___d18e65238-1"/>
  98. </xs:choice>
  99. <xs:element name="ID_BILLING_PREFIXES"
  100. type="xs:integer"
  101. id="ING_NUMBERS___d18e65239-1_ID_BILLING"/>
  102. <xs:element name="NUMBER"
  103. type="xs:integer"
  104. id="ING_NUMBERS___d18e65240-1_NUMBER"/>
  105. <xs:element name="ID_BILLING_USERS"
  106. type="xs:integer"
  107. id="ING_NUMBERS___d18e65241-1_ID_BILLING"/>
  108. <xs:element ref="default_db__x3A__COMPANIES:ID_BILLING_USERS"
  109. id="ING_NUMBERS___d18e65242-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
  110. <xs:annotation>
  111. <xs:appinfo>
  112. <system_cache__appinfo:flat_relation_cache>
  113. <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
  114. system_cache__appinfo:name="ID_BILLING_USERS"
  115. system_cache__appinfo:xpath="default_db__x3A__COMPANIES:ID_BILLING_USERS/ID"/>
  116. </system_cache__appinfo:flat_relation_cache>
  117. </xs:appinfo>
  118. </xs:annotation>
  119. </xs:element>
  120. </xs:sequence>
  121. <xs:assert test="ID_BILLING_PREFIXES = default_db__x3A__COMPANIES:ID_BILLING_USERS/ID_BILLING_PREFIXES"
  122. id="ING_NUMBERS___d18e65247-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
  123. <xs:annotation>
  124. <xs:documentation>Prefix dla faktur bierzse sie z klienta</xs:documentation>
  125. </xs:annotation>
  126. </xs:assert>
  127. </xs:complexType>
  128. <xs:complexType name="BILLING_NUMBERS_BILLS_FVAT"
  129. id="ING_NUMBERS___d18e65252-1_BILLING_NU">
  130. <xs:complexContent id="ING_NUMBERS___d18e65253-1">
  131. <xs:restriction base="default_db__x3A__BILLING_NUMBERS:BILLING_NUMBERS">
  132. <xs:sequence id="ING_NUMBERS___d18e65255-1">
  133. <xs:element name="ID" type="xs:integer" id="ING_NUMBERS___d18e65256-1_ID"/>
  134. <xs:element name="TIMESTAMP"
  135. type="xs:string"
  136. id="ING_NUMBERS___d18e65257-1_TIMESTAMP"/>
  137. <xs:element name="ID_BILLING_NUMBERS_TYPE"
  138. type="xs:integer"
  139. id="ING_NUMBERS___d18e65258-1_ID_BILLING"/>
  140. <xs:choice id="ING_NUMBERS___d18e65259-1">
  141. <xs:element ref="default_db__x3A__BILLING_NUMBERS_TYPE:BILLING_NUMBERS_TYPE"
  142. maxOccurs="0"
  143. minOccurs="0"
  144. id="ING_NUMBERS___d18e65260-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
  145. <xs:annotation>
  146. <xs:appinfo>
  147. <system_cache__appinfo:flat_relation_cache>
  148. <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
  149. system_cache__appinfo:name="ID_BILLING_NUMBERS_TYPE"
  150. system_cache__appinfo:xpath="default_db__x3A__BILLING_NUMBERS_TYPE:BILLING_NUMBERS_TYPE/ID_BILLING_NUMBERS_TYPE"/>
  151. </system_cache__appinfo:flat_relation_cache>
  152. </xs:appinfo>
  153. </xs:annotation>
  154. </xs:element>
  155. <xs:sequence id="ING_NUMBERS___d18e65265-1">
  156. <xs:element ref="default_db__x3A__BILLING_NUMBERS_TYPE:BILLING_NUMBERS_TYPE_SELL_WINIEN__BILLS_FVAT"
  157. id="ING_NUMBERS___d18e65266-1"/>
  158. </xs:sequence>
  159. <xs:element ref="default_db__x3A__BILLING_NUMBERS_TYPE:BILLING_NUMBERS_TYPE_SELL_WINIEN__BILLS_RU"
  160. maxOccurs="0"
  161. minOccurs="0"
  162. id="ING_NUMBERS___d18e65267-1"/>
  163. </xs:choice>
  164. <xs:element name="ID_BILLING_PREFIXES"
  165. type="xs:integer"
  166. id="ING_NUMBERS___d18e65268-1_ID_BILLING"/>
  167. <xs:element name="NUMBER"
  168. type="xs:integer"
  169. id="ING_NUMBERS___d18e65269-1_NUMBER"/>
  170. <xs:element name="ID_BILLING_USERS"
  171. type="xs:integer"
  172. id="ING_NUMBERS___d18e65270-1_ID_BILLING"/>
  173. <xs:element ref="default_db__x3A__COMPANIES:ID_BILLING_USERS"
  174. id="ING_NUMBERS___d18e65271-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
  175. <xs:annotation>
  176. <xs:appinfo>
  177. <system_cache__appinfo:flat_relation_cache>
  178. <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
  179. system_cache__appinfo:name="ID_BILLING_USERS"
  180. system_cache__appinfo:xpath="default_db__x3A__COMPANIES:ID_BILLING_USERS/ID"/>
  181. </system_cache__appinfo:flat_relation_cache>
  182. </xs:appinfo>
  183. </xs:annotation>
  184. </xs:element>
  185. </xs:sequence>
  186. <xs:assert test="ID_BILLING_NUMBERS_TYPE = default_db__x3A__BILLING_NUMBERS_TYPE:BILLING_NUMBERS_TYPE_SELL_WINIEN__BILLS_FVAT/ID"
  187. id="ING_NUMBERS___d18e65276-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
  188. <xs:annotation>
  189. <xs:documentation>Typ danych dla wprowadzania faktury</xs:documentation>
  190. </xs:annotation>
  191. </xs:assert>
  192. <xs:assert test="ID_BILLING_PREFIXES = default_db__x3A__COMPANIES:ID_BILLING_USERS/ID_BILLING_PREFIXES"
  193. id="ING_NUMBERS___d18e65280-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
  194. <xs:annotation>
  195. <xs:documentation>Prefix dla faktur bierzse sie z klienta</xs:documentation>
  196. </xs:annotation>
  197. </xs:assert>
  198. <xs:assert test="ID_BILLING_USERS = default_db__x3A__COMPANIES:ID_BILLING_USERS/ID"
  199. id="ING_NUMBERS___d18e65284-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
  200. <xs:annotation>
  201. <xs:documentation>Płatnik to ID z Companies</xs:documentation>
  202. </xs:annotation>
  203. </xs:assert>
  204. </xs:restriction>
  205. </xs:complexContent>
  206. </xs:complexType>
  207. <xs:element name="BILLING_NUMBERS_BILLS_FVAT"
  208. type="default_db__x3A__BILLING_NUMBERS:BILLING_NUMBERS_BILLS_FVAT"
  209. id="ING_NUMBERS___d18e65288-1_BILLING_NU"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
  210. <xs:annotation>
  211. <xs:documentation>Obiekt do wystawiania lub/i przegladania faktur</xs:documentation>
  212. </xs:annotation>
  213. </xs:element>
  214. <xs:element name="BILLING_NUMBERS"
  215. type="default_db__x3A__BILLING_NUMBERS:BILLING_NUMBERS"
  216. id="ING_NUMBERS___d18e65292-1_BILLING_NU"/>
  217. </xs:schema>