fin_familiepayments.xsd 21 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320
  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <schema xmlns="http://www.w3.org/2001/XMLSchema"
  3. xmlns:default_db__x3A__sys_users="https://biuro.biall-net.pl/wfs/default_db/table/sys_users.xsd"
  4. xmlns:default_db__x3A__crm_educationlevels="https://biuro.biall-net.pl/wfs/default_db/table/crm_educationlevels.xsd"
  5. xmlns:default_db__x3A__crm_genders="https://biuro.biall-net.pl/wfs/default_db/table/crm_genders.xsd"
  6. xmlns:default_db__x3A__crm_languagelevels="https://biuro.biall-net.pl/wfs/default_db/table/crm_languagelevels.xsd"
  7. xmlns:default_db__x3A__crm_carrerstatuses="https://biuro.biall-net.pl/wfs/default_db/table/crm_carrerstatuses.xsd"
  8. xmlns:default_db__x3A__crm_addresstypes="https://biuro.biall-net.pl/wfs/default_db/table/crm_addresstypes.xsd"
  9. xmlns:default_db__x3A__crm_voivodeships="https://biuro.biall-net.pl/wfs/default_db/table/crm_voivodeships.xsd"
  10. xmlns:default_db__x3A__crm_addresses="https://biuro.biall-net.pl/wfs/default_db/table/crm_addresses.xsd"
  11. xmlns:default_db__x3A__crm_families="https://biuro.biall-net.pl/wfs/default_db/table/crm_families.xsd"
  12. xmlns:default_db__x3A__crm_transportcompanies="https://biuro.biall-net.pl/wfs/default_db/table/crm_transportcompanies.xsd"
  13. xmlns:default_db__x3A__car_carrers="https://biuro.biall-net.pl/wfs/default_db/table/car_carrers.xsd"
  14. xmlns:default_db__x3A__crm_currencys="https://biuro.biall-net.pl/wfs/default_db/table/crm_currencys.xsd"
  15. xmlns:default_db__x3A__crm_notes="https://biuro.biall-net.pl/wfs/default_db/table/crm_notes.xsd"
  16. xmlns:default_db__x3A__crm_contracts="https://biuro.biall-net.pl/wfs/default_db/table/crm_contracts.xsd"
  17. xmlns:default_db__x3A__crm_contracttermtypes="https://biuro.biall-net.pl/wfs/default_db/table/crm_contracttermtypes.xsd"
  18. xmlns:default_db__x3A__crm_orderstatuses="https://biuro.biall-net.pl/wfs/default_db/table/crm_orderstatuses.xsd"
  19. xmlns:default_db__x3A__crm_doctemplatecategories="https://biuro.biall-net.pl/wfs/default_db/table/crm_doctemplatecategories.xsd"
  20. xmlns:default_db__x3A__crm_doctemplates="https://biuro.biall-net.pl/wfs/default_db/table/crm_doctemplates.xsd"
  21. xmlns:default_db__x3A__crm_coordinators="https://biuro.biall-net.pl/wfs/default_db/table/crm_coordinators.xsd"
  22. xmlns:default_db__x3A__fin_familiepayments="https://biuro.biall-net.pl/wfs/default_db/table/fin_familiepayments.xsd"
  23. xmlns:default_db__x3A__crm_filetypes="https://biuro.biall-net.pl/wfs/default_db/table/crm_filetypes.xsd"
  24. xmlns:default_db__x3A__crm_files="https://biuro.biall-net.pl/wfs/default_db/table/crm_files.xsd"
  25. xmlns:default_db__x3A__crm_notetypes="https://biuro.biall-net.pl/wfs/default_db/table/crm_notetypes.xsd"
  26. xmlns:default_db__x3A__crm_transports="https://biuro.biall-net.pl/wfs/default_db/table/crm_transports.xsd"
  27. xmlns:default_db__x3A__crm_transfersgroups="https://biuro.biall-net.pl/wfs/default_db/table/crm_transfersgroups.xsd"
  28. xmlns:default_db__x3A__crm_carrerbankdetails="https://biuro.biall-net.pl/wfs/default_db/table/crm_carrerbankdetails.xsd"
  29. xmlns:default_db__x3A__crm_transfergroupssparts="https://biuro.biall-net.pl/wfs/default_db/table/crm_transfergroupssparts.xsd"
  30. xmlns:default_db__x3A__crm_companies="https://biuro.biall-net.pl/wfs/default_db/table/crm_companies.xsd"
  31. xmlns:default_db__x3A__crm_transportstatuses="https://biuro.biall-net.pl/wfs/default_db/table/crm_transportstatuses.xsd"
  32. xmlns:default_db__x3A__crm_warddiseases="https://biuro.biall-net.pl/wfs/default_db/table/crm_warddiseases.xsd"
  33. xmlns:default_db__x3A__fin_invoices="https://biuro.biall-net.pl/wfs/default_db/table/fin_invoices.xsd"
  34. xmlns:default_db__x3A__crm_orderdayscalculationtypes="https://biuro.biall-net.pl/wfs/default_db/table/crm_orderdayscalculationtypes.xsd"
  35. xmlns:default_db__x3A__fin_paymenttypes="https://biuro.biall-net.pl/wfs/default_db/table/fin_paymenttypes.xsd"
  36. xmlns:default_db__x3A__imp_companies="https://biuro.biall-net.pl/wfs/default_db/table/imp_companies.xsd"
  37. xmlns:default_db__x3A__imp_users="https://biuro.biall-net.pl/wfs/default_db/table/imp_users.xsd"
  38. xmlns:default_db__x3A__sys_applications="https://biuro.biall-net.pl/wfs/default_db/table/sys_applications.xsd"
  39. xmlns:default_db__x3A__sys_accesses="https://biuro.biall-net.pl/wfs/default_db/table/sys_accesses.xsd"
  40. xmlns:default_db__x3A__sys_userstatuses="https://biuro.biall-net.pl/wfs/default_db/table/sys_userstatuses.xsd"
  41. xmlns:default_db__x3A__web_companies="https://biuro.biall-net.pl/wfs/default_db/table/web_companies.xsd"
  42. xmlns:default_db__x3A__web_users="https://biuro.biall-net.pl/wfs/default_db/table/web_users.xsd"
  43. xmlns:system_cache__appinfo="http://biuro.biall-net.pl/xmlschema_procesy5/default_db_xml_cache/appinfo.xsd"
  44. xmlns:p5Type="http://biuro.biall-net.pl/p5/schema/types"
  45. targetNamespace="https://biuro.biall-net.pl/wfs/default_db/table/fin_familiepayments.xsd"
  46. system_cache__appinfo:restriction_path_TODEL=""
  47. system_cache__appinfo:sort="0"
  48. system_cache__appinfo:root_element_in_schema="true"
  49. system_cache__appinfo:prefix="default_db"
  50. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  51. system_cache__appinfo:document-uri-orig="/bravecom/bravecom_ele.xsd">
  52. <import namespace="https://biuro.biall-net.pl/wfs/default_db/table/crm_families.xsd"
  53. schemaLocation="default_db__x3A__crm_families.xsd"/>
  54. <import namespace="https://biuro.biall-net.pl/wfs/default_db/table/sys_users.xsd"
  55. schemaLocation="default_db__x3A__sys_users.xsd"/>
  56. <xs:complexType xmlns:xs="http://www.w3.org/2001/XMLSchema"
  57. system_cache__appinfo:restriction_path_TODEL=""
  58. name="fin_familiepayments"
  59. id="default_d___d5e5690-1_fin_famili"
  60. system_cache__appinfo:sort="0"
  61. system_cache__appinfo:root_element_in_schema="true"
  62. system_cache__appinfo:prefix="default_db"
  63. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"><!--#139 to include -->
  64. <xs:sequence system_cache__appinfo:restriction_path_TODEL=""
  65. id="default_d___d5e5691-1"
  66. system_cache__appinfo:sort="1"
  67. system_cache__appinfo:root_element_in_schema="true"
  68. system_cache__appinfo:prefix="default_db"
  69. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table">
  70. <xs:element system_cache__appinfo:sort="1"
  71. system_cache__appinfo:prefix="default_db"
  72. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  73. id="default_d___d5e5692-1_Id"
  74. name="Id"
  75. minOccurs="0"
  76. type="p5Type:integer"
  77. system_cache__appinfo:xpath_local="p5Type:integer"
  78. system_cache__appinfo:restriction_path=""/>
  79. <xs:element system_cache__appinfo:sort="1"
  80. system_cache__appinfo:prefix="default_db"
  81. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  82. id="default_d___d5e5693-1_CreatedByU"
  83. name="CreatedByUserId"
  84. minOccurs="0"
  85. type="p5Type:integer"
  86. system_cache__appinfo:xpath_local="p5Type:integer"
  87. system_cache__appinfo:restriction_path=""/>
  88. <xs:element system_cache__appinfo:sort="1"
  89. system_cache__appinfo:prefix="default_db"
  90. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  91. id="default_d___d5e5694-1_CreatedDat"
  92. name="CreatedDateTime"
  93. minOccurs="0"
  94. default="CURRENT_TIMESTAMP"
  95. type="p5Type:dateTime"
  96. system_cache__appinfo:xpath_local="p5Type:dateTime"
  97. system_cache__appinfo:restriction_path=""/>
  98. <xs:element system_cache__appinfo:sort="1"
  99. system_cache__appinfo:prefix="default_db"
  100. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  101. id="default_d___d5e5695-1_LastUpdate"
  102. name="LastUpdateUserId"
  103. minOccurs="0"
  104. nillable="true"
  105. default=""
  106. type="p5Type:integer"
  107. system_cache__appinfo:xpath_local="p5Type:integer"
  108. system_cache__appinfo:restriction_path=""/>
  109. <xs:element system_cache__appinfo:sort="1"
  110. system_cache__appinfo:prefix="default_db"
  111. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  112. id="default_d___d5e5696-1_LastUpdate"
  113. name="LastUpdateDateTime"
  114. minOccurs="0"
  115. default="CURRENT_TIMESTAMP"
  116. type="p5Type:integer"
  117. system_cache__appinfo:xpath_local="p5Type:integer"
  118. system_cache__appinfo:restriction_path=""/>
  119. <xs:element system_cache__appinfo:sort="1"
  120. system_cache__appinfo:prefix="default_db"
  121. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  122. id="default_d___d5e5697-1_IsDeleted"
  123. name="IsDeleted"
  124. minOccurs="0"
  125. default="0"
  126. type="p5Type:integer"
  127. system_cache__appinfo:xpath_local="p5Type:integer"
  128. system_cache__appinfo:restriction_path=""/>
  129. <xs:element system_cache__appinfo:sort="1"
  130. system_cache__appinfo:prefix="default_db"
  131. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  132. id="default_d___d5e5698-1_Number"
  133. name="Number"
  134. minOccurs="0"
  135. nillable="true"
  136. default=""
  137. type="p5Type:string"
  138. system_cache__appinfo:xpath_local="p5Type:string"
  139. system_cache__appinfo:restriction_path=""/>
  140. <xs:element system_cache__appinfo:sort="1"
  141. system_cache__appinfo:prefix="default_db"
  142. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  143. id="default_d___d5e5699-1_FamilyId"
  144. name="FamilyId"
  145. minOccurs="0"
  146. type="p5Type:integer"
  147. system_cache__appinfo:xpath_local="p5Type:integer"
  148. system_cache__appinfo:restriction_path=""/>
  149. <xs:element system_cache__appinfo:sort="1"
  150. system_cache__appinfo:prefix="default_db"
  151. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  152. id="default_d___d5e5700-1_TheMonth"
  153. name="TheMonth"
  154. minOccurs="0"
  155. type="p5Type:integer"
  156. system_cache__appinfo:xpath_local="p5Type:integer"
  157. system_cache__appinfo:restriction_path=""/>
  158. <xs:element system_cache__appinfo:sort="1"
  159. system_cache__appinfo:prefix="default_db"
  160. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  161. id="default_d___d5e5701-1_TheYear"
  162. name="TheYear"
  163. minOccurs="0"
  164. type="p5Type:integer"
  165. system_cache__appinfo:xpath_local="p5Type:integer"
  166. system_cache__appinfo:restriction_path=""/>
  167. <xs:element system_cache__appinfo:sort="1"
  168. system_cache__appinfo:prefix="default_db"
  169. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  170. id="default_d___d5e5702-1_Payment"
  171. name="Payment"
  172. minOccurs="0"
  173. default="0.00"
  174. type="p5Type:decimal"
  175. system_cache__appinfo:xpath_local="p5Type:decimal"
  176. system_cache__appinfo:restriction_path=""/>
  177. <xs:element system_cache__appinfo:sort="1"
  178. system_cache__appinfo:prefix="default_db"
  179. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  180. id="default_d___d5e5704-1_PaymentDat"
  181. name="PaymentDate"
  182. minOccurs="0"
  183. type="p5Type:date"
  184. system_cache__appinfo:xpath_local="p5Type:date"
  185. system_cache__appinfo:restriction_path=""/>
  186. <xs:element system_cache__appinfo:sort="1"
  187. system_cache__appinfo:prefix="default_db"
  188. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  189. id="default_d___d5e5705-1_Paid"
  190. name="Paid"
  191. minOccurs="0"
  192. default="0.00"
  193. type="p5Type:decimal"
  194. system_cache__appinfo:xpath_local="p5Type:decimal"
  195. system_cache__appinfo:restriction_path=""/>
  196. <xs:element system_cache__appinfo:sort="1"
  197. system_cache__appinfo:prefix="default_db"
  198. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  199. id="default_d___d5e5706-1_PaidDate"
  200. name="PaidDate"
  201. minOccurs="0"
  202. nillable="true"
  203. default=""
  204. type="p5Type:date"
  205. system_cache__appinfo:xpath_local="p5Type:date"
  206. system_cache__appinfo:restriction_path=""/>
  207. <xs:element system_cache__appinfo:sort="1"
  208. system_cache__appinfo:prefix="default_db"
  209. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  210. id="default_d___d5e5707-1_Info"
  211. name="Info"
  212. minOccurs="0"
  213. nillable="true"
  214. default=""
  215. type="p5Type:text"
  216. system_cache__appinfo:xpath_local="p5Type:text"
  217. system_cache__appinfo:restriction_path=""/>
  218. <xs:element system_cache__appinfo:sort="1"
  219. system_cache__appinfo:prefix="default_db"
  220. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  221. id="default_d___d5e5708-1_BankRecord"
  222. name="BankRecord"
  223. minOccurs="0"
  224. nillable="true"
  225. default=""
  226. type="p5Type:text"
  227. system_cache__appinfo:xpath_local="p5Type:text"
  228. system_cache__appinfo:restriction_path=""/>
  229. <xs:element system_cache__appinfo:sort="1"
  230. system_cache__appinfo:prefix="default_db"
  231. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  232. id="default_d___d5e5709-1_IsAccepted"
  233. name="IsAccepted"
  234. minOccurs="0"
  235. default="0"
  236. type="p5Type:integer"
  237. system_cache__appinfo:xpath_local="p5Type:integer"
  238. system_cache__appinfo:restriction_path=""/>
  239. <xs:element system_cache__appinfo:sort="1"
  240. system_cache__appinfo:prefix="default_db"
  241. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  242. id="default_d___d5e5710-1_AcceptedBy"
  243. name="AcceptedByUserId"
  244. minOccurs="0"
  245. nillable="true"
  246. default=""
  247. type="p5Type:integer"
  248. system_cache__appinfo:xpath_local="p5Type:integer"
  249. system_cache__appinfo:restriction_path=""/>
  250. <xs:element system_cache__appinfo:sort="1"
  251. system_cache__appinfo:prefix="default_db"
  252. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  253. id="default_d___d5e5711-1_InvoiceVal"
  254. name="InvoiceValue"
  255. minOccurs="0"
  256. default="0.00"
  257. type="p5Type:decimal"
  258. system_cache__appinfo:xpath_local="p5Type:decimal"
  259. system_cache__appinfo:restriction_path=""/>
  260. <xs:element system_cache__appinfo:sort="1"
  261. system_cache__appinfo:prefix="default_db"
  262. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  263. id="default_d___d5e5712-1"
  264. ref="default_db__x3A__crm_families:crm_families"
  265. system_cache__appinfo:xpath_local="default_db:crm_families"
  266. system_cache__appinfo:restriction_path=""><!--#139 to include -->
  267. <xs:annotation>
  268. <xs:appinfo>
  269. <system_cache__appinfo:flat_relation_cache>
  270. <system_cache__appinfo:source system_cache__appinfo:name="FamilyId"
  271. system_cache__appinfo:xpath="default_db__x3A__fin_familiepayments__x3A__crm_families:crm_families/Id"/>
  272. </system_cache__appinfo:flat_relation_cache>
  273. </xs:appinfo>
  274. </xs:annotation>
  275. </xs:element>
  276. <xs:element system_cache__appinfo:sort="1"
  277. system_cache__appinfo:prefix="default_db"
  278. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  279. id="default_d___d5e5716-1"
  280. ref="default_db__x3A__sys_users:sys_users"
  281. system_cache__appinfo:xpath_local="default_db:sys_users"
  282. system_cache__appinfo:restriction_path=""><!--#139 to include -->
  283. <xs:annotation>
  284. <xs:appinfo>
  285. <system_cache__appinfo:flat_relation_cache>
  286. <system_cache__appinfo:source system_cache__appinfo:name="CreatedByUserId"
  287. system_cache__appinfo:xpath="default_db__x3A__fin_familiepayments__x3A__sys_users:sys_users/UserId"/>
  288. </system_cache__appinfo:flat_relation_cache>
  289. </xs:appinfo>
  290. </xs:annotation>
  291. </xs:element>
  292. <xs:element system_cache__appinfo:sort="1"
  293. system_cache__appinfo:prefix="default_db"
  294. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  295. id="default_d___d5e5720-1"
  296. ref="default_db__x3A__sys_users:sys_users"
  297. system_cache__appinfo:xpath_local="default_db:sys_users"
  298. system_cache__appinfo:restriction_path=""><!--#139 to include -->
  299. <xs:annotation>
  300. <xs:appinfo>
  301. <system_cache__appinfo:flat_relation_cache>
  302. <system_cache__appinfo:source system_cache__appinfo:name="LastUpdateUserId"
  303. system_cache__appinfo:xpath="default_db__x3A__fin_familiepayments__x3A__sys_users:sys_users/UserId"/>
  304. </system_cache__appinfo:flat_relation_cache>
  305. </xs:appinfo>
  306. </xs:annotation>
  307. </xs:element>
  308. </xs:sequence>
  309. </xs:complexType>
  310. <xs:element xmlns:xs="http://www.w3.org/2001/XMLSchema"
  311. name="fin_familiepayments"
  312. type="default_db__x3A__fin_familiepayments:fin_familiepayments"
  313. id="default_d___d5e5724-1_fin_famili"
  314. system_cache__appinfo:root_element_in_schema="true"
  315. system_cache__appinfo:xpath_local=""
  316. system_cache__appinfo:sort="1"
  317. system_cache__appinfo:prefix="default_db"
  318. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  319. system_cache__appinfo:restriction_path=""><!--#139 to include --></xs:element>
  320. </schema>