crm_familiebankdetails.xsd 21 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314
  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:default_db__x3A__crm_familiebankdetails="https://biuro.biall-net.pl/wfs/default_db/table/crm_familiebankdetails.xsd"
  44. xmlns:system_cache__appinfo="http://biuro.biall-net.pl/xmlschema_procesy5/default_db_xml_cache/appinfo.xsd"
  45. xmlns:p5Type="http://biuro.biall-net.pl/p5/schema/types"
  46. targetNamespace="https://biuro.biall-net.pl/wfs/default_db/table/crm_familiebankdetails.xsd"
  47. system_cache__appinfo:restriction_path_TODEL=""
  48. system_cache__appinfo:sort="0"
  49. system_cache__appinfo:root_element_in_schema="true"
  50. system_cache__appinfo:prefix="default_db"
  51. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  52. system_cache__appinfo:document-uri-orig="/bravecom/bravecom_ele.xsd">
  53. <import namespace="https://biuro.biall-net.pl/wfs/default_db/table/sys_users.xsd"
  54. schemaLocation="default_db__x3A__sys_users.xsd"/>
  55. <import namespace="https://biuro.biall-net.pl/wfs/default_db/table/crm_currencys.xsd"
  56. schemaLocation="default_db__x3A__crm_currencys.xsd"/>
  57. <import namespace="https://biuro.biall-net.pl/wfs/default_db/table/crm_families.xsd"
  58. schemaLocation="default_db__x3A__crm_families.xsd"/>
  59. <xs:complexType xmlns:xs="http://www.w3.org/2001/XMLSchema"
  60. system_cache__appinfo:restriction_path_TODEL=""
  61. name="crm_familiebankdetails"
  62. id="default_d___d5e4757-1_crm_famili"
  63. system_cache__appinfo:sort="0"
  64. system_cache__appinfo:root_element_in_schema="true"
  65. system_cache__appinfo:prefix="default_db"
  66. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"><!--#139 to include -->
  67. <xs:sequence system_cache__appinfo:restriction_path_TODEL=""
  68. id="default_d___d5e4758-1"
  69. system_cache__appinfo:sort="1"
  70. system_cache__appinfo:root_element_in_schema="true"
  71. system_cache__appinfo:prefix="default_db"
  72. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table">
  73. <xs:element system_cache__appinfo:sort="1"
  74. system_cache__appinfo:prefix="default_db"
  75. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  76. id="default_d___d5e4759-1_Id"
  77. name="Id"
  78. minOccurs="0"
  79. type="p5Type:integer"
  80. system_cache__appinfo:xpath_local="p5Type:integer"
  81. system_cache__appinfo:restriction_path=""/>
  82. <xs:element system_cache__appinfo:sort="1"
  83. system_cache__appinfo:prefix="default_db"
  84. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  85. id="default_d___d5e4760-1_CreatedByU"
  86. name="CreatedByUserId"
  87. minOccurs="0"
  88. type="p5Type:integer"
  89. system_cache__appinfo:xpath_local="p5Type:integer"
  90. system_cache__appinfo:restriction_path=""/>
  91. <xs:element system_cache__appinfo:sort="1"
  92. system_cache__appinfo:prefix="default_db"
  93. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  94. id="default_d___d5e4761-1_CreatedDat"
  95. name="CreatedDateTime"
  96. minOccurs="0"
  97. default="CURRENT_TIMESTAMP"
  98. type="p5Type:dateTime"
  99. system_cache__appinfo:xpath_local="p5Type:dateTime"
  100. system_cache__appinfo:restriction_path=""/>
  101. <xs:element system_cache__appinfo:sort="1"
  102. system_cache__appinfo:prefix="default_db"
  103. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  104. id="default_d___d5e4762-1_LastUpdate"
  105. name="LastUpdateUserId"
  106. minOccurs="0"
  107. nillable="true"
  108. default=""
  109. type="p5Type:integer"
  110. system_cache__appinfo:xpath_local="p5Type:integer"
  111. system_cache__appinfo:restriction_path=""/>
  112. <xs:element system_cache__appinfo:sort="1"
  113. system_cache__appinfo:prefix="default_db"
  114. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  115. id="default_d___d5e4763-1_LastUpdate"
  116. name="LastUpdateDateTime"
  117. minOccurs="0"
  118. default="CURRENT_TIMESTAMP"
  119. type="p5Type:integer"
  120. system_cache__appinfo:xpath_local="p5Type:integer"
  121. system_cache__appinfo:restriction_path=""/>
  122. <xs:element system_cache__appinfo:sort="1"
  123. system_cache__appinfo:prefix="default_db"
  124. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  125. id="default_d___d5e4764-1_IsDeleted"
  126. name="IsDeleted"
  127. minOccurs="0"
  128. default="0"
  129. type="p5Type:integer"
  130. system_cache__appinfo:xpath_local="p5Type:integer"
  131. system_cache__appinfo:restriction_path=""/>
  132. <xs:element system_cache__appinfo:sort="1"
  133. system_cache__appinfo:prefix="default_db"
  134. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  135. id="default_d___d5e4765-1_isDefault"
  136. name="isDefault"
  137. minOccurs="0"
  138. nillable="true"
  139. default="0"
  140. type="p5Type:integer"
  141. system_cache__appinfo:xpath_local="p5Type:integer"
  142. system_cache__appinfo:restriction_path=""/>
  143. <xs:element system_cache__appinfo:sort="1"
  144. system_cache__appinfo:prefix="default_db"
  145. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  146. id="default_d___d5e4766-1_DoneByUser"
  147. name="DoneByUserId"
  148. minOccurs="0"
  149. nillable="true"
  150. default=""
  151. type="p5Type:integer"
  152. system_cache__appinfo:xpath_local="p5Type:integer"
  153. system_cache__appinfo:restriction_path=""/>
  154. <xs:element system_cache__appinfo:sort="1"
  155. system_cache__appinfo:prefix="default_db"
  156. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  157. id="default_d___d5e4767-1_DoneDateTi"
  158. name="DoneDateTime"
  159. minOccurs="0"
  160. nillable="true"
  161. default=""
  162. type="p5Type:dateTime"
  163. system_cache__appinfo:xpath_local="p5Type:dateTime"
  164. system_cache__appinfo:restriction_path=""/>
  165. <xs:element system_cache__appinfo:sort="1"
  166. system_cache__appinfo:prefix="default_db"
  167. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  168. id="default_d___d5e4768-1_FamilyId"
  169. name="FamilyId"
  170. minOccurs="0"
  171. type="p5Type:integer"
  172. system_cache__appinfo:xpath_local="p5Type:integer"
  173. system_cache__appinfo:restriction_path=""/>
  174. <xs:element system_cache__appinfo:sort="1"
  175. system_cache__appinfo:prefix="default_db"
  176. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  177. id="default_d___d5e4769-1_SWIFT"
  178. name="SWIFT"
  179. minOccurs="0"
  180. nillable="true"
  181. default=""
  182. type="p5Type:string"
  183. system_cache__appinfo:xpath_local="p5Type:string"
  184. system_cache__appinfo:restriction_path=""/>
  185. <xs:element system_cache__appinfo:sort="1"
  186. system_cache__appinfo:prefix="default_db"
  187. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  188. id="default_d___d5e4771-1_AccountNum"
  189. name="AccountNumber"
  190. minOccurs="0"
  191. type="p5Type:string"
  192. system_cache__appinfo:xpath_local="p5Type:string"
  193. system_cache__appinfo:restriction_path=""/>
  194. <xs:element system_cache__appinfo:sort="1"
  195. system_cache__appinfo:prefix="default_db"
  196. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  197. id="default_d___d5e4772-1_BankName"
  198. name="BankName"
  199. minOccurs="0"
  200. nillable="true"
  201. default=""
  202. type="p5Type:string"
  203. system_cache__appinfo:xpath_local="p5Type:string"
  204. system_cache__appinfo:restriction_path=""/>
  205. <xs:element system_cache__appinfo:sort="1"
  206. system_cache__appinfo:prefix="default_db"
  207. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  208. id="default_d___d5e4773-1_CurrencyId"
  209. name="CurrencyId"
  210. minOccurs="0"
  211. nillable="true"
  212. default="1"
  213. type="p5Type:integer"
  214. system_cache__appinfo:xpath_local="p5Type:integer"
  215. system_cache__appinfo:restriction_path=""/>
  216. <xs:element system_cache__appinfo:sort="1"
  217. system_cache__appinfo:prefix="default_db"
  218. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  219. id="default_d___d5e4774-1_OwnerName"
  220. name="OwnerName"
  221. minOccurs="0"
  222. nillable="true"
  223. default=""
  224. type="p5Type:string"
  225. system_cache__appinfo:xpath_local="p5Type:string"
  226. system_cache__appinfo:restriction_path=""/>
  227. <xs:element system_cache__appinfo:sort="1"
  228. system_cache__appinfo:prefix="default_db"
  229. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  230. id="default_d___d5e4775-1_Info"
  231. name="Info"
  232. minOccurs="0"
  233. nillable="true"
  234. default=""
  235. type="p5Type:string"
  236. system_cache__appinfo:xpath_local="p5Type:string"
  237. system_cache__appinfo:restriction_path=""/>
  238. <xs:element system_cache__appinfo:sort="1"
  239. system_cache__appinfo:prefix="default_db"
  240. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  241. id="default_d___d5e4776-1"
  242. ref="default_db__x3A__sys_users:sys_users"
  243. system_cache__appinfo:xpath_local="default_db:sys_users"
  244. system_cache__appinfo:restriction_path=""><!--#139 to include -->
  245. <xs:annotation>
  246. <xs:appinfo>
  247. <system_cache__appinfo:flat_relation_cache>
  248. <system_cache__appinfo:source system_cache__appinfo:name="CreatedByUserId"
  249. system_cache__appinfo:xpath="default_db__x3A__crm_familiebankdetails__x3A__sys_users:sys_users/UserId"/>
  250. </system_cache__appinfo:flat_relation_cache>
  251. </xs:appinfo>
  252. </xs:annotation>
  253. </xs:element>
  254. <xs:element system_cache__appinfo:sort="1"
  255. system_cache__appinfo:prefix="default_db"
  256. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  257. id="default_d___d5e4780-1"
  258. ref="default_db__x3A__crm_currencys:crm_currencys"
  259. system_cache__appinfo:xpath_local="default_db:crm_currencys"
  260. system_cache__appinfo:restriction_path=""><!--#139 to include -->
  261. <xs:annotation>
  262. <xs:appinfo>
  263. <system_cache__appinfo:flat_relation_cache>
  264. <system_cache__appinfo:source system_cache__appinfo:name="CurrencyId"
  265. system_cache__appinfo:xpath="default_db__x3A__crm_familiebankdetails__x3A__crm_currencys:crm_currencys/Id"/>
  266. </system_cache__appinfo:flat_relation_cache>
  267. </xs:appinfo>
  268. </xs:annotation>
  269. </xs:element>
  270. <xs:element system_cache__appinfo:sort="1"
  271. system_cache__appinfo:prefix="default_db"
  272. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  273. id="default_d___d5e4784-1"
  274. ref="default_db__x3A__crm_families:crm_families"
  275. system_cache__appinfo:xpath_local="default_db:crm_families"
  276. system_cache__appinfo:restriction_path=""><!--#139 to include -->
  277. <xs:annotation>
  278. <xs:appinfo>
  279. <system_cache__appinfo:flat_relation_cache>
  280. <system_cache__appinfo:source system_cache__appinfo:name="FamilyId"
  281. system_cache__appinfo:xpath="default_db__x3A__crm_familiebankdetails__x3A__crm_families:crm_families/Id"/>
  282. </system_cache__appinfo:flat_relation_cache>
  283. </xs:appinfo>
  284. </xs:annotation>
  285. </xs:element>
  286. <xs:element system_cache__appinfo:sort="1"
  287. system_cache__appinfo:prefix="default_db"
  288. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  289. id="default_d___d5e4788-1"
  290. ref="default_db__x3A__sys_users:sys_users"
  291. system_cache__appinfo:xpath_local="default_db:sys_users"
  292. system_cache__appinfo:restriction_path=""><!--#139 to include -->
  293. <xs:annotation>
  294. <xs:appinfo>
  295. <system_cache__appinfo:flat_relation_cache>
  296. <system_cache__appinfo:source system_cache__appinfo:name="LastUpdateUserId"
  297. system_cache__appinfo:xpath="default_db__x3A__crm_familiebankdetails__x3A__sys_users:sys_users/UserId"/>
  298. </system_cache__appinfo:flat_relation_cache>
  299. </xs:appinfo>
  300. </xs:annotation>
  301. </xs:element>
  302. </xs:sequence>
  303. </xs:complexType>
  304. <xs:element xmlns:xs="http://www.w3.org/2001/XMLSchema"
  305. name="crm_familiebankdetails"
  306. type="default_db__x3A__crm_familiebankdetails:crm_familiebankdetails"
  307. id="default_d___d5e4792-1_crm_famili"
  308. system_cache__appinfo:root_element_in_schema="true"
  309. system_cache__appinfo:xpath_local=""
  310. system_cache__appinfo:sort="1"
  311. system_cache__appinfo:prefix="default_db"
  312. system_cache__appinfo:namespace_uri="https://biuro.biall-net.pl/wfs/default_db/table"
  313. system_cache__appinfo:restriction_path=""><!--#139 to include --></xs:element>
  314. </schema>