[TABLO] xml verileri accesse alırken
#1
Ekteki gibi xml dosyam var access veritabanına aldığımda ayrı tablolar şeklinde geliyor veriler her tablo birbirinden bağımsız olarak ilişkili olmadan tüm alanların veri türü metin olarak kaydediliyor

Tabloları Müşteriler-Poliçe-primlervergiler-taksit

Poliçeler-teminatlar

olarak ilişkilendirmem gerek .

xml dosya içerisinde ilişkili gibi gözüküyor ancak accese alırken herşey gözardı ediliyor ve bütün alanlar metin olarak geliyor belkide gelen veride bütün alanlar metin olarak tanımlı .

Verilerin anlamlı bir hal alabilmesi için ne yapmak gerek.





Eklenti Dosyaları
.rar   0707 soru.rar (Boyut: 23,98 KB / İndirilme: 65)



  Alıntı
Bu mesajı beğenenler:
#2
Dosyanızı ilişkili ve alanları istediğiniz gibi veri tipi tanımlı olarak ekler misiniz?



  Alıntı
Bu mesajı beğenenler:
#3
Müşteri-Poliçe-Primvevergiler-Taksit olarak ilişkilendirdim .
Şimdilik ilişki kısmını anlamam gerek diğer alanlar
metin olarak kalsa da olur.




Eklenti Dosyaları
.rar   0707 soru.rar (Boyut: 32,71 KB / İndirilme: 74)



  Alıntı
Bu mesajı beğenenler:
#4
XMLde tanımlı tablololardaki alan sayısı ile tablonuzdakiler eşleşmiyor.. Buna çözüm bulmalısınız öncelikle.. Benim önerim XML deki veriyi başka tablolarda alıp diğerlerine o tablolardan aktarın.. Sonra da o tabloları silin..

Bu kod aynı dizindeki xml dosyanızı farklı tablo ismi (adına 1 ekleyerek) ile kaydeder..:

Visual Basic
  1. ImportXML CurrentProject.Path & "/05072012.XML", acStructureAndData





  Alıntı
Bu mesajı beğenenler:
#5
Başka tablolarda alın derken neyi kasdettiğinizi anlayamadım internette araştırma yaparken
http://technet.microsoft.com/library/ee692914.aspx Buraya ulaştım ama denemeler sonucunda hep aynı şekilde tüm tablo alanları metin olarak alınıyor tablolar arasındada kendi yapısında ilişki kurabileceğim tanımlı bir alan yok.
Daha sonra excel ile denemeler yaptım orda ise durum biraz farklı alma işlemi yaparken geçerli bir şablon yok excel bir şablon oluşturacak şeklinde mesaj verdikten sonra ekteki gibi tüm tabloları tek sayfaya alıyor.

Burada ise tablolardaki veri durumuna bağlı olarak kayıtlar 1 den fazla tekrarlayan bir şekilde çıkıyor.

Ücretli bir programda ise onun sadece resmini ekleyebiliyorum kayıtlar bağlantılı ve kurallara uygun olarak getiriliyor.


Eklenti Dosyaları
.rar   Excel-t.rar (Boyut: 30,32 KB / İndirilme: 71)
.jpg   pr.JPG (Boyut: 128,73 KB / İndirilme: 82)



  Alıntı
Bu mesajı beğenenler:
#6
Bu konu ile ilgili halen bir cevap bulamadım son olarak verilerin accesse alırken dönüşüm uygulanabileceği bilgisine ulaştım ancak şema dönüşümünü uygulayamıyorum .
Birde dönüşümde kullanılan aşağıdaki kodu buldum ancak ne işe yarar nasıl kullanılır bir fikir edinemedim.

Visual Basic
  1. XmlTransformation Version="1.0">
  2. - <Transform Direction="ToCds" DataEncoding="iso-8859-9">
  3. - <SelectEach dest="DATAPACKET\ROWDATA\ROW" from="\POLİÇELER\POLİÇE">
  4. - <SelectEach dest="TEMİNAT\ROWTEMİNAT" from="\TEMİNATLAR\TEMİNAT">
  5. <Select dest="@TeminatKodu" from="\TeminatKodu" />
  6. <Select dest="@TeminatAdı" from="\TeminatAdı" />
  7. <Select dest="@Bedel" from="\Bedel" />
  8. <Select dest="@Fiyat" from="\Fiyat" />
  9. <Select dest="@İndirimliPrim" from="\İndirimliPrim" />
  10. </SelectEach>
  11. - <SelectEach dest="Brans\ROWBrans" from="\Branslar\Brans">
  12. <Select dest="@BransKodu" from="\BransKodu" />
  13. <Select dest="@BransAd" from="\BransAd" />
  14. <Select dest="@TeminatBedel" from="\TeminatBedel" />
  15. <Select dest="@BransNetPrim" from="\BransNetPrim" />
  16. <Select dest="@Komisyon" from="\Komisyon" />
  17. </SelectEach>
  18. <Select dest="@AcenteKodu" from="\AcenteKodu" />
  19. <Select dest="@Talikodu" from="\Talikodu" />
  20. <Select dest="@TanzimTarihi" from="\TanzimTarihi" />
  21. <Select dest="@BaşlangıçTarihi" from="\BaşlangıçTarihi" />
  22. <Select dest="@BitişTarihi" from="\BitişTarihi" />
  23. <Select dest="@İşlemTarihi" from="\İşlemTarihi" />
  24. <Select dest="@İşlemSaati" from="\İşlemSaati" />
  25. <Select dest="@PoliceNumarası" from="\PoliceNumarası" />
  26. <Select dest="@YenilemeNumarası" from="\YenilemeNumarası" />
  27. <Select dest="@ZeylNo" from="\ZeylNo" />
  28. <Select dest="@UrunKodu" from="\UrunKodu" />
  29. <Select dest="@BranşKodu" from="\BranşKodu" />
  30. <Select dest="@ZeylKodu" from="\ZeylKodu" />
  31. <Select dest="@iptal" from="\iptal" />
  32. <Select dest="@NetPrim" from="\PRİMVEVERGİLER\NetPrim" />
  33. <Select dest="@YangınSigortaVergisi" from="\PRİMVEVERGİLER\YangınSigortaVergisi" />
  34. <Select dest="@GiderVergisi" from="\PRİMVEVERGİLER\GiderVergisi" />
  35. <Select dest="@GarantiFonu" from="\PRİMVEVERGİLER\GarantiFonu" />
  36. <Select dest="@TrafikHizmetleriGeliştirmeFonu" from="\PRİMVEVERGİLER\TrafikHizmetleriGeliştirmeFonu" />
  37. <Select dest="@BrütPrim" from="\PRİMVEVERGİLER\BrütPrim" />
  38. <Select dest="@AcenteKomisyonu" from="\PRİMVEVERGİLER\AcenteKomisyonu" />
  39. <Select dest="@PoliçeTürü" from="\DÖVİZ\PoliçeTürü" />
  40. <Select dest="@DövizCinsi" from="\DÖVİZ\DövizCinsi" />
  41. <Select dest="@DövizKuru" from="\DÖVİZ\DövizKuru" />
  42. <Select dest="@MüşteriNumarası1" from="\MÜŞTERİ\MüşteriNumarası" />
  43. <Select dest="@AdıSoyadı-Ünvanı1" from="\MÜŞTERİ\AdıSoyadı-Ünvanı" />
  44. <Select dest="@DoğumTarihi1" from="\MÜŞTERİ\DoğumTarihi" />
  45. <Select dest="@EvTelefonu11" from="\MÜŞTERİ\EvTelefonu1" />
  46. <Select dest="@EvTelefonu21" from="\MÜŞTERİ\EvTelefonu2" />
  47. <Select dest="@İşTelefonu11" from="\MÜŞTERİ\İşTelefonu1" />
  48. <Select dest="@İşTelefonu21" from="\MÜŞTERİ\İşTelefonu2" />
  49. <Select dest="@FaxNumarası1" from="\MÜŞTERİ\FaxNumarası" />
  50. <Select dest="@CepNumarası1" from="\MÜŞTERİ\CepNumarası" />
  51. <Select dest="@E-Posta1" from="\MÜŞTERİ\E-Posta" />
  52. <Select dest="@VergiKimlikNumarası1" from="\MÜŞTERİ\VergiKimlikNumarası" />
  53. <Select dest="@VergiDairesi1" from="\MÜŞTERİ\VergiDairesi" />
  54. <Select dest="@TCKimlikNumarası1" from="\MÜŞTERİ\TCKimlikNumarası" />
  55. <Select dest="@ÖzelTüzelKodu1" from="\MÜŞTERİ\ÖzelTüzelKodu" />
  56. <Select dest="@Uyruğu1" from="\MÜŞTERİ\Uyruğu" />
  57. <Select dest="@BabaAdı1" from="\MÜŞTERİ\BabaAdı" />
  58. <Select dest="@Adres11" from="\MÜŞTERİ\Adres1" />
  59. <Select dest="@Adres21" from="\MÜŞTERİ\Adres2" />
  60. <Select dest="@Adres31" from="\MÜŞTERİ\Adres3" />
  61. <Select dest="@Adres41" from="\MÜŞTERİ\Adres4" />
  62. <Select dest="@Adres51" from="\MÜŞTERİ\Adres5" />
  63. <Select dest="@İlçe1" from="\MÜŞTERİ\İlçe" />
  64. <Select dest="@İl1" from="\MÜŞTERİ\İl" />
  65. <Select dest="@TemsilciNo1" from="\MÜŞTERİ\TemsilciNo" />
  66. <Select dest="@Line" from="\ARAC\Line" />
  67. <Select dest="@AracDegerKodu" from="\ARAC\AracDegerKodu" />
  68. <Select dest="@Marka" from="\ARAC\Marka" />
  69. <Select dest="@Model" from="\ARAC\Model" />
  70. <Select dest="@Plaka" from="\ARAC\Plaka" />
  71. <Select dest="@TescilTarihi" from="\ARAC\TescilTarihi" />
  72. <Select dest="@ModelYili" from="\ARAC\ModelYili" />
  73. <Select dest="@RuhsatSahibi" from="\ARAC\RuhsatSahibi" />
  74. <Select dest="@MotorNo" from="\ARAC\MotorNo" />
  75. <Select dest="@SasiNo" from="\ARAC\SasiNo" />
  76. <Select dest="@YerAdedi" from="\ARAC\YerAdedi" />
  77. <Select dest="@Tonaj" from="\ARAC\Tonaj" />
  78. <Select dest="@KulTarzKodu" from="\ARAC\KulTarzKodu" />
  79. <Select dest="@KulTarzKodu2" from="\ARAC\KulTarzKodu2" />
  80. <Select dest="@KulTarz" from="\ARAC\KulTarz" />
  81. <Select dest="@VadeTarihi" from="\TAKSİTLER\TAKSİT\VadeTarihi" />
  82. <Select dest="@Tutar" from="\TAKSİTLER\TAKSİT\Tutar" />
  83. <Select dest="@MüşteriNumarası2" from="\SİGORTALILAR\SİGORTALI\MüşteriNumarası" />
  84. <Select dest="@AdıSoyadı-Ünvanı2" from="\SİGORTALILAR\SİGORTALI\AdıSoyadı-Ünvanı" />
  85. <Select dest="@DoğumTarihi2" from="\SİGORTALILAR\SİGORTALI\DoğumTarihi" />
  86. <Select dest="@EvTelefonu12" from="\SİGORTALILAR\SİGORTALI\EvTelefonu1" />
  87. <Select dest="@EvTelefonu22" from="\SİGORTALILAR\SİGORTALI\EvTelefonu2" />
  88. <Select dest="@İşTelefonu12" from="\SİGORTALILAR\SİGORTALI\İşTelefonu1" />
  89. <Select dest="@İşTelefonu22" from="\SİGORTALILAR\SİGORTALI\İşTelefonu2" />
  90. <Select dest="@FaxNumarası2" from="\SİGORTALILAR\SİGORTALI\FaxNumarası" />
  91. <Select dest="@CepNumarası2" from="\SİGORTALILAR\SİGORTALI\CepNumarası" />
  92. <Select dest="@E-Posta2" from="\SİGORTALILAR\SİGORTALI\E-Posta" />
  93. <Select dest="@VergiKimlikNumarası2" from="\SİGORTALILAR\SİGORTALI\VergiKimlikNumarası" />
  94. <Select dest="@VergiDairesi2" from="\SİGORTALILAR\SİGORTALI\VergiDairesi" />
  95. <Select dest="@TCKimlikNumarası2" from="\SİGORTALILAR\SİGORTALI\TCKimlikNumarası" />
  96. <Select dest="@ÖzelTüzelKodu2" from="\SİGORTALILAR\SİGORTALI\ÖzelTüzelKodu" />
  97. <Select dest="@Uyruğu2" from="\SİGORTALILAR\SİGORTALI\Uyruğu" />
  98. <Select dest="@BabaAdı2" from="\SİGORTALILAR\SİGORTALI\BabaAdı" />
  99. <Select dest="@Adres12" from="\SİGORTALILAR\SİGORTALI\Adres1" />
  100. <Select dest="@Adres22" from="\SİGORTALILAR\SİGORTALI\Adres2" />
  101. <Select dest="@Adres32" from="\SİGORTALILAR\SİGORTALI\Adres3" />
  102. <Select dest="@Adres42" from="\SİGORTALILAR\SİGORTALI\Adres4" />
  103. <Select dest="@Adres52" from="\SİGORTALILAR\SİGORTALI\Adres5" />
  104. <Select dest="@İlçe2" from="\SİGORTALILAR\SİGORTALI\İlçe" />
  105. <Select dest="@İl2" from="\SİGORTALILAR\SİGORTALI\İl" />
  106. <Select dest="@TemsilciNo2" from="\SİGORTALILAR\SİGORTALI\TemsilciNo" />
  107. <Select dest="@PoliçeBaşTar" from="\PoliçeBaşTar" />
  108. <Select dest="@PoliçeBitTar" from="\PoliçeBitTar" />
  109. - <SelectEach dest="TAKSİT\ROWTAKSİT" from="\TAKSİTLER\TAKSİT">
  110. <Select dest="@VadeTarihi" from="\VadeTarihi" />
  111. <Select dest="@Tutar" from="\Tutar" />
  112. </SelectEach>
  113. </SelectEach>
  114. </Transform>
  115. - <XmlSchema RootName="POLİÇELER">
  116. - <![CDATA[ <xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema">
  117. <xs:element name="POLİÇELER" type="POLİÇELERType"/>
  118. <xs:complexType name="POLİÇELERType">
  119. <xs:sequence>
  120. <xs:element name="KOD" type="KODType"/>
  121. <xs:element name="POLİÇE" type="POLİÇEType" minOccurs="0" maxOccurs="unbounded"/>
  122. </xs:sequence>
  123. </xs:complexType>
  124. <xs:element name="KOD" type="KODType"/>
  125. <xs:simpleType name="KODType">
  126. <xs:restriction base="xs:string"/>
  127. </xs:simpleType>
  128. <xs:element name="POLİÇE" type="POLİÇEType"/>
  129. <xs:complexType name="POLİÇEType">
  130. <xs:sequence>
  131. <xs:element name="AcenteKodu" type="AcenteKoduType"/>
  132. <xs:element name="Talikodu" type="TalikoduType"/>
  133. <xs:element name="TanzimTarihi" type="TanzimTarihiType"/>
  134. <xs:element name="BaşlangıçTarihi" type="BaşlangıçTarihiType"/>
  135. <xs:element name="BitişTarihi" type="BitişTarihiType"/>
  136. <xs:element name="İşlemTarihi" type="İşlemTarihiType"/>
  137. <xs:element name="İşlemSaati" type="İşlemSaatiType"/>
  138. <xs:element name="PoliceNumarası" type="PoliceNumarasıType"/>
  139. <xs:element name="YenilemeNumarası" type="YenilemeNumarasıType"/>
  140. <xs:element name="ZeylNo" type="ZeylNoType"/>
  141. <xs:element name="UrunKodu" type="UrunKoduType"/>
  142. <xs:element name="BranşKodu" type="BranşKoduType"/>
  143. <xs:element name="ZeylKodu" type="ZeylKoduType"/>
  144. <xs:element name="iptal" type="iptalType"/>
  145. <xs:element name="PRİMVEVERGİLER" type="PRİMVEVERGİLERType"/>
  146. <xs:element name="DÖVİZ" type="DÖVİZType"/>
  147. <xs:element name="MÜŞTERİ" type="MÜŞTERİType"/>
  148. <xs:element name="ARAC" type="ARACType"/>
  149. <xs:element name="TAKSİTLER" type="TAKSİTLERType"/>
  150. <xs:element name="SİGORTALILAR" type="SİGORTALILARType"/>
  151. <xs:element name="TEMİNATLAR" type="TEMİNATLARType"/>
  152. <xs:element name="Branslar" type="BranslarType"/>
  153. <xs:element name="PoliçeBaşTar" type="PoliçeBaşTarType"/>
  154. <xs:element name="PoliçeBitTar" type="PoliçeBitTarType"/>
  155. </xs:sequence>
  156. </xs:complexType>
  157. <xs:element name="AcenteKodu" type="AcenteKoduType"/>
  158. <xs:simpleType name="AcenteKoduType">
  159. <xs:restriction base="xs:string"/>
  160. </xs:simpleType>
  161. <xs:element name="Talikodu" type="TalikoduType"/>
  162. <xs:simpleType name="TalikoduType">
  163. <xs:restriction base="xs:string"/>
  164. </xs:simpleType>
  165. <xs:element name="TanzimTarihi" type="TanzimTarihiType"/>
  166. <xs:simpleType name="TanzimTarihiType">
  167. <xs:restriction base="xs:string"/>
  168. </xs:simpleType>
  169. <xs:element name="BaşlangıçTarihi" type="BaşlangıçTarihiType"/>
  170. <xs:simpleType name="BaşlangıçTarihiType">
  171. <xs:restriction base="xs:string"/>
  172. </xs:simpleType>
  173. <xs:element name="BitişTarihi" type="BitişTarihiType"/>
  174. <xs:simpleType name="BitişTarihiType">
  175. <xs:restriction base="xs:string"/>
  176. </xs:simpleType>
  177. <xs:element name="İşlemTarihi" type="İşlemTarihiType"/>
  178. <xs:simpleType name="İşlemTarihiType">
  179. <xs:restriction base="xs:string"/>
  180. </xs:simpleType>
  181. <xs:element name="İşlemSaati" type="İşlemSaatiType"/>
  182. <xs:simpleType name="İşlemSaatiType">
  183. <xs:restriction base="xs:string"/>
  184. </xs:simpleType>
  185. <xs:element name="PoliceNumarası" type="PoliceNumarasıType"/>
  186. <xs:simpleType name="PoliceNumarasıType">
  187. <xs:restriction base="xs:string"/>
  188. </xs:simpleType>
  189. <xs:element name="YenilemeNumarası" type="YenilemeNumarasıType"/>
  190. <xs:simpleType name="YenilemeNumarasıType">
  191. <xs:restriction base="xs:string"/>
  192. </xs:simpleType>
  193. <xs:element name="ZeylNo" type="ZeylNoType"/>
  194. <xs:simpleType name="ZeylNoType">
  195. <xs:restriction base="xs:string"/>
  196. </xs:simpleType>
  197. <xs:element name="UrunKodu" type="UrunKoduType"/>
  198. <xs:simpleType name="UrunKoduType">
  199. <xs:restriction base="xs:string"/>
  200. </xs:simpleType>
  201. <xs:element name="BranşKodu" type="BranşKoduType"/>
  202. <xs:simpleType name="BranşKoduType">
  203. <xs:restriction base="xs:string"/>
  204. </xs:simpleType>
  205. <xs:element name="ZeylKodu" type="ZeylKoduType"/>
  206. <xs:simpleType name="ZeylKoduType">
  207. <xs:restriction base="xs:string"/>
  208. </xs:simpleType>
  209. <xs:element name="iptal" type="iptalType"/>
  210. <xs:simpleType name="iptalType">
  211. <xs:restriction base="xs:string"/>
  212. </xs:simpleType>
  213. <xs:element name="PRİMVEVERGİLER" type="PRİMVEVERGİLERType"/>
  214. <xs:complexType name="PRİMVEVERGİLERType">
  215. <xs:sequence>
  216. <xs:element name="NetPrim" type="NetPrimType"/>
  217. <xs:element name="YangınSigortaVergisi" type="YangınSigortaVergisiType"/>
  218. <xs:element name="GiderVergisi" type="GiderVergisiType"/>
  219. <xs:element name="GarantiFonu" type="GarantiFonuType"/>
  220. <xs:element name="TrafikHizmetleriGeliştirmeFonu" type="TrafikHizmetleriGeliştirmeFonuType"/>
  221. <xs:element name="BrütPrim" type="BrütPrimType"/>
  222. <xs:element name="AcenteKomisyonu" type="AcenteKomisyonuType"/>
  223. </xs:sequence>
  224. </xs:complexType>
  225. <xs:element name="NetPrim" type="NetPrimType"/>
  226. <xs:simpleType name="NetPrimType">
  227. <xs:restriction base="xs:string"/>
  228. </xs:simpleType>
  229. <xs:element name="YangınSigortaVergisi" type="YangınSigortaVergisiType"/>
  230. <xs:simpleType name="YangınSigortaVergisiType">
  231. <xs:restriction base="xs:string"/>
  232. </xs:simpleType>
  233. <xs:element name="GiderVergisi" type="GiderVergisiType"/>
  234. <xs:simpleType name="GiderVergisiType">
  235. <xs:restriction base="xs:string"/>
  236. </xs:simpleType>
  237. <xs:element name="GarantiFonu" type="GarantiFonuType"/>
  238. <xs:simpleType name="GarantiFonuType">
  239. <xs:restriction base="xs:string"/>
  240. </xs:simpleType>
  241. <xs:element name="TrafikHizmetleriGeliştirmeFonu" type="TrafikHizmetleriGeliştirmeFonuType"/>
  242. <xs:simpleType name="TrafikHizmetleriGeliştirmeFonuType">
  243. <xs:restriction base="xs:string"/>
  244. </xs:simpleType>
  245. <xs:element name="BrütPrim" type="BrütPrimType"/>
  246. <xs:simpleType name="BrütPrimType">
  247. <xs:restriction base="xs:string"/>
  248. </xs:simpleType>
  249. <xs:element name="AcenteKomisyonu" type="AcenteKomisyonuType"/>
  250. <xs:simpleType name="AcenteKomisyonuType">
  251. <xs:restriction base="xs:string"/>
  252. </xs:simpleType>
  253. <xs:element name="DÖVİZ" type="DÖVİZType"/>
  254. <xs:complexType name="DÖVİZType">
  255. <xs:sequence>
  256. <xs:element name="PoliçeTürü" type="PoliçeTürüType"/>
  257. <xs:element name="DövizCinsi" type="DövizCinsiType"/>
  258. <xs:element name="DövizKuru" type="DövizKuruType"/>
  259. </xs:sequence>
  260. </xs:complexType>
  261. <xs:element name="PoliçeTürü" type="PoliçeTürüType"/>
  262. <xs:simpleType name="PoliçeTürüType">
  263. <xs:restriction base="xs:string"/>
  264. </xs:simpleType>
  265. <xs:element name="DövizCinsi" type="DövizCinsiType"/>
  266. <xs:simpleType name="DövizCinsiType">
  267. <xs:restriction base="xs:string"/>
  268. </xs:simpleType>
  269. <xs:element name="DövizKuru" type="DövizKuruType"/>
  270. <xs:simpleType name="DövizKuruType">
  271. <xs:restriction base="xs:string"/>
  272. </xs:simpleType>
  273. <xs:element name="MÜŞTERİ" type="MÜŞTERİType"/>
  274. <xs:complexType name="MÜŞTERİType">
  275. <xs:sequence>
  276. <xs:element name="MüşteriNumarası" type="MüşteriNumarasıType"/>
  277. <xs:element name="AdıSoyadı-Ünvanı" type="AdıSoyadı-ÜnvanıType"/>
  278. <xs:element name="DoğumTarihi" type="DoğumTarihiType"/>
  279. <xs:element name="EvTelefonu1" type="EvTelefonu1Type"/>
  280. <xs:element name="EvTelefonu2" type="EvTelefonu2Type"/>
  281. <xs:element name="İşTelefonu1" type="İşTelefonu1Type"/>
  282. <xs:element name="İşTelefonu2" type="İşTelefonu2Type"/>
  283. <xs:element name="FaxNumarası" type="FaxNumarasıType"/>
  284. <xs:element name="CepNumarası" type="CepNumarasıType"/>
  285. <xs:element name="E-Posta" type="E-PostaType"/>
  286. <xs:element name="VergiKimlikNumarası" type="VergiKimlikNumarasıType"/>
  287. <xs:element name="VergiDairesi" type="VergiDairesiType"/>
  288. <xs:element name="TCKimlikNumarası" type="TCKimlikNumarasıType"/>
  289. <xs:element name="ÖzelTüzelKodu" type="ÖzelTüzelKoduType"/>
  290. <xs:element name="Uyruğu" type="UyruğuType"/>
  291. <xs:element name="BabaAdı" type="BabaAdıType"/>
  292. <xs:element name="Adres1" type="Adres1Type"/>
  293. <xs:element name="Adres2" type="Adres2Type"/>
  294. <xs:element name="Adres3" type="Adres3Type"/>
  295. <xs:element name="Adres4" type="Adres4Type"/>
  296. <xs:element name="Adres5" type="Adres5Type"/>
  297. <xs:element name="İlçe" type="İlçeType"/>
  298. <xs:element name="İl" type="İlType"/>
  299. <xs:element name="TemsilciNo" type="TemsilciNoType"/>
  300. </xs:sequence>
  301. </xs:complexType>
  302. <xs:element name="MüşteriNumarası" type="MüşteriNumarasıType"/>
  303. <xs:simpleType name="MüşteriNumarasıType">
  304. <xs:restriction base="xs:string"/>
  305. </xs:simpleType>
  306. <xs:element name="AdıSoyadı-Ünvanı" type="AdıSoyadı-ÜnvanıType"/>
  307. <xs:simpleType name="AdıSoyadı-ÜnvanıType">
  308. <xs:restriction base="xs:string"/>
  309. </xs:simpleType>
  310. <xs:element name="DoğumTarihi" type="DoğumTarihiType"/>
  311. <xs:simpleType name="DoğumTarihiType">
  312. <xs:restriction base="xs:string"/>
  313. </xs:simpleType>
  314. <xs:element name="EvTelefonu1" type="EvTelefonu1Type"/>
  315. <xs:simpleType name="EvTelefonu1Type">
  316. <xs:restriction base="xs:string"/>
  317. </xs:simpleType>
  318. <xs:element name="EvTelefonu2" type="EvTelefonu2Type"/>
  319. <xs:simpleType name="EvTelefonu2Type">
  320. <xs:restriction base="xs:string"/>
  321. </xs:simpleType>
  322. <xs:element name="İşTelefonu1" type="İşTelefonu1Type"/>
  323. <xs:simpleType name="İşTelefonu1Type">
  324. <xs:restriction base="xs:string"/>
  325. </xs:simpleType>
  326. <xs:element name="İşTelefonu2" type="İşTelefonu2Type"/>
  327. <xs:simpleType name="İşTelefonu2Type">
  328. <xs:restriction base="xs:string"/>
  329. </xs:simpleType>
  330. <xs:element name="FaxNumarası" type="FaxNumarasıType"/>
  331. <xs:simpleType name="FaxNumarasıType">
  332. <xs:restriction base="xs:string"/>
  333. </xs:simpleType>
  334. <xs:element name="CepNumarası" type="CepNumarasıType"/>
  335. <xs:simpleType name="CepNumarasıType">
  336. <xs:restriction base="xs:string"/>
  337. </xs:simpleType>
  338. <xs:element name="E-Posta" type="E-PostaType"/>
  339. <xs:simpleType name="E-PostaType">
  340. <xs:restriction base="xs:string"/>
  341. </xs:simpleType>
  342. <xs:element name="VergiKimlikNumarası" type="VergiKimlikNumarasıType"/>
  343. <xs:simpleType name="VergiKimlikNumarasıType">
  344. <xs:restriction base="xs:string"/>
  345. </xs:simpleType>
  346. <xs:element name="VergiDairesi" type="VergiDairesiType"/>
  347. <xs:simpleType name="VergiDairesiType">
  348. <xs:restriction base="xs:string"/>
  349. </xs:simpleType>
  350. <xs:element name="TCKimlikNumarası" type="TCKimlikNumarasıType"/>
  351. <xs:simpleType name="TCKimlikNumarasıType">
  352. <xs:restriction base="xs:string"/>
  353. </xs:simpleType>
  354. <xs:element name="ÖzelTüzelKodu" type="ÖzelTüzelKoduType"/>
  355. <xs:simpleType name="ÖzelTüzelKoduType">
  356. <xs:restriction base="xs:string"/>
  357. </xs:simpleType>
  358. <xs:element name="Uyruğu" type="UyruğuType"/>
  359. <xs:simpleType name="UyruğuType">
  360. <xs:restriction base="xs:string"/>
  361. </xs:simpleType>
  362. <xs:element name="BabaAdı" type="BabaAdıType"/>
  363. <xs:simpleType name="BabaAdıType">
  364. <xs:restriction base="xs:string"/>
  365. </xs:simpleType>
  366. <xs:element name="Adres1" type="Adres1Type"/>
  367. <xs:simpleType name="Adres1Type">
  368. <xs:restriction base="xs:string"/>
  369. </xs:simpleType>
  370. <xs:element name="Adres2" type="Adres2Type"/>
  371. <xs:simpleType name="Adres2Type">
  372. <xs:restriction base="xs:string"/>
  373. </xs:simpleType>
  374. <xs:element name="Adres3" type="Adres3Type"/>
  375. <xs:simpleType name="Adres3Type">
  376. <xs:restriction base="xs:string"/>
  377. </xs:simpleType>
  378. <xs:element name="Adres4" type="Adres4Type"/>
  379. <xs:simpleType name="Adres4Type">
  380. <xs:restriction base="xs:string"/>
  381. </xs:simpleType>
  382. <xs:element name="Adres5" type="Adres5Type"/>
  383. <xs:simpleType name="Adres5Type">
  384. <xs:restriction base="xs:string"/>
  385. </xs:simpleType>
  386. <xs:element name="İlçe" type="İlçeType"/>
  387. <xs:simpleType name="İlçeType">
  388. <xs:restriction base="xs:string"/>
  389. </xs:simpleType>
  390. <xs:element name="İl" type="İlType"/>
  391. <xs:simpleType name="İlType">
  392. <xs:restriction base="xs:string"/>
  393. </xs:simpleType>
  394. <xs:element name="TemsilciNo" type="TemsilciNoType"/>
  395. <xs:simpleType name="TemsilciNoType">
  396. <xs:restriction base="xs:string"/>
  397. </xs:simpleType>
  398. <xs:element name="ARAC" type="ARACType"/>
  399. <xs:complexType name="ARACType">
  400. <xs:sequence>
  401. <xs:element name="Line" type="LineType"/>
  402. <xs:element name="AracDegerKodu" type="AracDegerKoduType"/>
  403. <xs:element name="Marka" type="MarkaType"/>
  404. <xs:element name="Model" type="ModelType"/>
  405. <xs:element name="Plaka" type="PlakaType"/>
  406. <xs:element name="TescilTarihi" type="TescilTarihiType"/>
  407. <xs:element name="ModelYili" type="ModelYiliType"/>
  408. <xs:element name="RuhsatSahibi" type="RuhsatSahibiType"/>
  409. <xs:element name="MotorNo" type="MotorNoType"/>
  410. <xs:element name="SasiNo" type="SasiNoType"/>
  411. <xs:element name="YerAdedi" type="YerAdediType"/>
  412. <xs:element name="Tonaj" type="TonajType"/>
  413. <xs:element name="KulTarzKodu" type="KulTarzKoduType"/>
  414. <xs:element name="KulTarzKodu2" type="KulTarzKodu2Type"/>
  415. <xs:element name="KulTarz" type="KulTarzType"/>
  416. </xs:sequence>
  417. </xs:complexType>
  418. <xs:element name="Line" type="LineType"/>
  419. <xs:simpleType name="LineType">
  420. <xs:restriction base="xs:string"/>
  421. </xs:simpleType>
  422. <xs:element name="AracDegerKodu" type="AracDegerKoduType"/>
  423. <xs:simpleType name="AracDegerKoduType">
  424. <xs:restriction base="xs:string"/>
  425. </xs:simpleType>
  426. <xs:element name="Marka" type="MarkaType"/>
  427. <xs:simpleType name="MarkaType">
  428. <xs:restriction base="xs:string"/>
  429. </xs:simpleType>
  430. <xs:element name="Model" type="ModelType"/>
  431. <xs:simpleType name="ModelType">
  432. <xs:restriction base="xs:string"/>
  433. </xs:simpleType>
  434. <xs:element name="Plaka" type="PlakaType"/>
  435. <xs:simpleType name="PlakaType">
  436. <xs:restriction base="xs:string"/>
  437. </xs:simpleType>
  438. <xs:element name="TescilTarihi" type="TescilTarihiType"/>
  439. <xs:simpleType name="TescilTarihiType">
  440. <xs:restriction base="xs:string"/>
  441. </xs:simpleType>
  442. <xs:element name="ModelYili" type="ModelYiliType"/>
  443. <xs:simpleType name="ModelYiliType">
  444. <xs:restriction base="xs:string"/>
  445. </xs:simpleType>
  446. <xs:element name="RuhsatSahibi" type="RuhsatSahibiType"/>
  447. <xs:simpleType name="RuhsatSahibiType">
  448. <xs:restriction base="xs:string"/>
  449. </xs:simpleType>
  450. <xs:element name="MotorNo" type="MotorNoType"/>
  451. <xs:simpleType name="MotorNoType">
  452. <xs:restriction base="xs:string"/>
  453. </xs:simpleType>
  454. <xs:element name="SasiNo" type="SasiNoType"/>
  455. <xs:simpleType name="SasiNoType">
  456. <xs:restriction base="xs:string"/>
  457. </xs:simpleType>
  458. <xs:element name="YerAdedi" type="YerAdediType"/>
  459. <xs:simpleType name="YerAdediType">
  460. <xs:restriction base="xs:string"/>
  461. </xs:simpleType>
  462. <xs:element name="Tonaj" type="TonajType"/>
  463. <xs:simpleType name="TonajType">
  464. <xs:restriction base="xs:string"/>
  465. </xs:simpleType>
  466. <xs:element name="KulTarzKodu" type="KulTarzKoduType"/>
  467. <xs:simpleType name="KulTarzKoduType">
  468. <xs:restriction base="xs:string"/>
  469. </xs:simpleType>
  470. <xs:element name="KulTarzKodu2" type="KulTarzKodu2Type"/>
  471. <xs:simpleType name="KulTarzKodu2Type">
  472. <xs:restriction base="xs:string"/>
  473. </xs:simpleType>
  474. <xs:element name="KulTarz" type="KulTarzType"/>
  475. <xs:simpleType name="KulTarzType">
  476. <xs:restriction base="xs:string"/>
  477. </xs:simpleType>
  478. <xs:element name="TAKSİTLER" type="TAKSİTLERType"/>
  479. <xs:complexType name="TAKSİTLERType">
  480. <xs:sequence>
  481. <xs:element name="TAKSİT" type="TAKSİTType" minOccurs="1" maxOccurs="unbounded"/>
  482. </xs:sequence>
  483. </xs:complexType>
  484. <xs:element name="TAKSİT" type="TAKSİTType"/>
  485. <xs:complexType name="TAKSİTType">
  486. <xs:sequence>
  487. <xs:element name="VadeTarihi" type="VadeTarihiType"/>
  488. <xs:element name="Tutar" type="TutarType"/>
  489. </xs:sequence>
  490. </xs:complexType>
  491. <xs:element name="VadeTarihi" type="VadeTarihiType"/>
  492. <xs:simpleType name="VadeTarihiType">
  493. <xs:restriction base="xs:string"/>
  494. </xs:simpleType>
  495. <xs:element name="Tutar" type="TutarType"/>
  496. <xs:simpleType name="TutarType">
  497. <xs:restriction base="xs:string"/>
  498. </xs:simpleType>
  499. <xs:element name="SİGORTALILAR" type="SİGORTALILARType"/>
  500. <xs:complexType name="SİGORTALILARType">
  501. <xs:sequence>
  502. <xs:element name="SİGORTALI" type="SİGORTALIType"/>
  503. </xs:sequence>
  504. </xs:complexType>
  505. <xs:element name="SİGORTALI" type="SİGORTALIType"/>
  506. <xs:complexType name="SİGORTALIType">
  507. <xs:sequence>
  508. <xs:element name="MüşteriNumarası" type="MüşteriNumarasıType"/>
  509. <xs:element name="AdıSoyadı-Ünvanı" type="AdıSoyadı-ÜnvanıType"/>
  510. <xs:element name="DoğumTarihi" type="DoğumTarihiType"/>
  511. <xs:element name="EvTelefonu1" type="EvTelefonu1Type"/>
  512. <xs:element name="EvTelefonu2" type="EvTelefonu2Type"/>
  513. <xs:element name="İşTelefonu1" type="İşTelefonu1Type"/>
  514. <xs:element name="İşTelefonu2" type="İşTelefonu2Type"/>
  515. <xs:element name="FaxNumarası" type="FaxNumarasıType"/>
  516. <xs:element name="CepNumarası" type="CepNumarasıType"/>
  517. <xs:element name="E-Posta" type="E-PostaType"/>
  518. <xs:element name="VergiKimlikNumarası" type="VergiKimlikNumarasıType"/>
  519. <xs:element name="VergiDairesi" type="VergiDairesiType"/>
  520. <xs:element name="TCKimlikNumarası" type="TCKimlikNumarasıType"/>
  521. <xs:element name="ÖzelTüzelKodu" type="ÖzelTüzelKoduType"/>
  522. <xs:element name="Uyruğu" type="UyruğuType"/>
  523. <xs:element name="BabaAdı" type="BabaAdıType"/>
  524. <xs:element name="Adres1" type="Adres1Type"/>
  525. <xs:element name="Adres2" type="Adres2Type"/>
  526. <xs:element name="Adres3" type="Adres3Type"/>
  527. <xs:element name="Adres4" type="Adres4Type"/>
  528. <xs:element name="Adres5" type="Adres5Type"/>
  529. <xs:element name="İlçe" type="İlçeType"/>
  530. <xs:element name="İl" type="İlType"/>
  531. <xs:element name="TemsilciNo" type="TemsilciNoType"/>
  532. </xs:sequence>
  533. </xs:complexType>
  534. <xs:element name="MüşteriNumarası" type="MüşteriNumarasıType"/>
  535. <xs:simpleType name="MüşteriNumarasıType">
  536. <xs:restriction base="xs:string"/>
  537. </xs:simpleType>
  538. <xs:element name="AdıSoyadı-Ünvanı" type="AdıSoyadı-ÜnvanıType"/>
  539. <xs:simpleType name="AdıSoyadı-ÜnvanıType">
  540. <xs:restriction base="xs:string"/>
  541. </xs:simpleType>
  542. <xs:element name="DoğumTarihi" type="DoğumTarihiType"/>
  543. <xs:simpleType name="DoğumTarihiType">
  544. <xs:restriction base="xs:string"/>
  545. </xs:simpleType>
  546. <xs:element name="EvTelefonu1" type="EvTelefonu1Type"/>
  547. <xs:simpleType name="EvTelefonu1Type">
  548. <xs:restriction base="xs:string"/>
  549. </xs:simpleType>
  550. <xs:element name="EvTelefonu2" type="EvTelefonu2Type"/>
  551. <xs:simpleType name="EvTelefonu2Type">
  552. <xs:restriction base="xs:string"/>
  553. </xs:simpleType>
  554. <xs:element name="İşTelefonu1" type="İşTelefonu1Type"/>
  555. <xs:simpleType name="İşTelefonu1Type">
  556. <xs:restriction base="xs:string"/>
  557. </xs:simpleType>
  558. <xs:element name="İşTelefonu2" type="İşTelefonu2Type"/>
  559. <xs:simpleType name="İşTelefonu2Type">
  560. <xs:restriction base="xs:string"/>
  561. </xs:simpleType>
  562. <xs:element name="FaxNumarası" type="FaxNumarasıType"/>
  563. <xs:simpleType name="FaxNumarasıType">
  564. <xs:restriction base="xs:string"/>
  565. </xs:simpleType>
  566. <xs:element name="CepNumarası" type="CepNumarasıType"/>
  567. <xs:simpleType name="CepNumarasıType">
  568. <xs:restriction base="xs:string"/>
  569. </xs:simpleType>
  570. <xs:element name="E-Posta" type="E-PostaType"/>
  571. <xs:simpleType name="E-PostaType">
  572. <xs:restriction base="xs:string"/>
  573. </xs:simpleType>
  574. <xs:element name="VergiKimlikNumarası" type="VergiKimlikNumarasıType"/>
  575. <xs:simpleType name="VergiKimlikNumarasıType">
  576. <xs:restriction base="xs:string"/>
  577. </xs:simpleType>
  578. <xs:element name="VergiDairesi" type="VergiDairesiType"/>
  579. <xs:simpleType name="VergiDairesiType">
  580. <xs:restriction base="xs:string"/>
  581. </xs:simpleType>
  582. <xs:element name="TCKimlikNumarası" type="TCKimlikNumarasıType"/>
  583. <xs:simpleType name="TCKimlikNumarasıType">
  584. <xs:restriction base="xs:string"/>
  585. </xs:simpleType>
  586. <xs:element name="ÖzelTüzelKodu" type="ÖzelTüzelKoduType"/>
  587. <xs:simpleType name="ÖzelTüzelKoduType">
  588. <xs:restriction base="xs:string"/>
  589. </xs:simpleType>
  590. <xs:element name="Uyruğu" type="UyruğuType"/>
  591. <xs:simpleType name="UyruğuType">
  592. <xs:restriction base="xs:string"/>
  593. </xs:simpleType>
  594. <xs:element name="BabaAdı" type="BabaAdıType"/>
  595. <xs:simpleType name="BabaAdıType">
  596. <xs:restriction base="xs:string"/>
  597. </xs:simpleType>
  598. <xs:element name="Adres1" type="Adres1Type"/>
  599. <xs:simpleType name="Adres1Type">
  600. <xs:restriction base="xs:string"/>
  601. </xs:simpleType>
  602. <xs:element name="Adres2" type="Adres2Type"/>
  603. <xs:simpleType name="Adres2Type">
  604. <xs:restriction base="xs:string"/>
  605. </xs:simpleType>
  606. <xs:element name="Adres3" type="Adres3Type"/>
  607. <xs:simpleType name="Adres3Type">
  608. <xs:restriction base="xs:string"/>
  609. </xs:simpleType>
  610. <xs:element name="Adres4" type="Adres4Type"/>
  611. <xs:simpleType name="Adres4Type">
  612. <xs:restriction base="xs:string"/>
  613. </xs:simpleType>
  614. <xs:element name="Adres5" type="Adres5Type"/>
  615. <xs:simpleType name="Adres5Type">
  616. <xs:restriction base="xs:string"/>
  617. </xs:simpleType>
  618. <xs:element name="İlçe" type="İlçeType"/>
  619. <xs:simpleType name="İlçeType">
  620. <xs:restriction base="xs:string"/>
  621. </xs:simpleType>
  622. <xs:element name="İl" type="İlType"/>
  623. <xs:simpleType name="İlType">
  624. <xs:restriction base="xs:string"/>
  625. </xs:simpleType>
  626. <xs:element name="TemsilciNo" type="TemsilciNoType"/>
  627. <xs:simpleType name="TemsilciNoType">
  628. <xs:restriction base="xs:string"/>
  629. </xs:simpleType>
  630. <xs:element name="TEMİNATLAR" type="TEMİNATLARType"/>
  631. <xs:complexType name="TEMİNATLARType">
  632. <xs:sequence>
  633. <xs:element name="TEMİNAT" type="TEMİNATType" minOccurs="0" maxOccurs="unbounded"/>
  634. </xs:sequence>
  635. </xs:complexType>
  636. <xs:element name="TEMİNAT" type="TEMİNATType"/>
  637. <xs:complexType name="TEMİNATType">
  638. <xs:sequence>
  639. <xs:element name="TeminatKodu" type="TeminatKoduType"/>
  640. <xs:element name="TeminatAdı" type="TeminatAdıType"/>
  641. <xs:element name="Bedel" type="BedelType"/>
  642. <xs:element name="Fiyat" type="FiyatType"/>
  643. <xs:element name="İndirimliPrim" type="İndirimliPrimType"/>
  644. </xs:sequence>
  645. </xs:complexType>
  646. <xs:element name="TeminatKodu" type="TeminatKoduType"/>
  647. <xs:simpleType name="TeminatKoduType">
  648. <xs:restriction base="xs:string"/>
  649. </xs:simpleType>
  650. <xs:element name="TeminatAdı" type="TeminatAdıType"/>
  651. <xs:simpleType name="TeminatAdıType">
  652. <xs:restriction base="xs:string"/>
  653. </xs:simpleType>
  654. <xs:element name="Bedel" type="BedelType"/>
  655. <xs:simpleType name="BedelType">
  656. <xs:restriction base="xs:string"/>
  657. </xs:simpleType>
  658. <xs:element name="Fiyat" type="FiyatType"/>
  659. <xs:simpleType name="FiyatType">
  660. <xs:restriction base="xs:string"/>
  661. </xs:simpleType>
  662. <xs:element name="İndirimliPrim" type="İndirimliPrimType"/>
  663. <xs:simpleType name="İndirimliPrimType">
  664. <xs:restriction base="xs:string"/>
  665. </xs:simpleType>
  666. <xs:element name="Branslar" type="BranslarType"/>
  667. <xs:complexType name="BranslarType">
  668. <xs:sequence>
  669. <xs:element name="Brans" type="BransType" minOccurs="0" maxOccurs="unbounded"/>
  670. </xs:sequence>
  671. </xs:complexType>
  672. <xs:element name="Brans" type="BransType"/>
  673. <xs:complexType name="BransType">
  674. <xs:sequence>
  675. <xs:element name="BransKodu" type="BransKoduType"/>
  676. <xs:element name="BransAd" type="BransAdType"/>
  677. <xs:element name="TeminatBedel" type="TeminatBedelType"/>
  678. <xs:element name="BransNetPrim" type="BransNetPrimType"/>
  679. <xs:element name="Komisyon" type="KomisyonType"/>
  680. </xs:sequence>
  681. </xs:complexType>
  682. <xs:element name="BransKodu" type="BransKoduType"/>
  683. <xs:simpleType name="BransKoduType">
  684. <xs:restriction base="xs:string"/>
  685. </xs:simpleType>
  686. <xs:element name="BransAd" type="BransAdType"/>
  687. <xs:simpleType name="BransAdType">
  688. <xs:restriction base="xs:string"/>
  689. </xs:simpleType>
  690. <xs:element name="TeminatBedel" type="TeminatBedelType"/>
  691. <xs:simpleType name="TeminatBedelType">
  692. <xs:restriction base="xs:string"/>
  693. </xs:simpleType>
  694. <xs:element name="BransNetPrim" type="BransNetPrimType"/>
  695. <xs:simpleType name="BransNetPrimType">
  696. <xs:restriction base="xs:string"/>
  697. </xs:simpleType>
  698. <xs:element name="Komisyon" type="KomisyonType"/>
  699. <xs:simpleType name="KomisyonType">
  700. <xs:restriction base="xs:string"/>
  701. </xs:simpleType>
  702. <xs:element name="PoliçeBaşTar" type="PoliçeBaşTarType"/>
  703. <xs:simpleType name="PoliçeBaşTarType">
  704. <xs:restriction base="xs:string"/>
  705. </xs:simpleType>
  706. <xs:element name="PoliçeBitTar" type="PoliçeBitTarType"/>
  707. <xs:simpleType name="PoliçeBitTarType">
  708. <xs:restriction base="xs:string"/>
  709. </xs:simpleType>
  710. </xs:schema>
  711. ]]>
  712. </XmlSchema>
  713. <CdsSkeleton />
  714. <XslTransform />
  715. - <Skeleton>
  716. - <![CDATA[ <?xml version="1.0"?><DATAPACKET Version="2.0"><METADATA><FIELDS><FIELD attrname="AcenteKodu" fieldtype="string" WIDTH="4"/><FIELD attrname="Talikodu" fieldtype="string" WIDTH="1"/><FIELD attrname="TanzimTarihi" fieldtype="string" WIDTH="8"/><FIELD attrname="BaşlangıçTarihi" fieldtype="string" WIDTH="8"/><FIELD attrname="BitişTarihi" fieldtype="string" WIDTH="8"/><FIELD attrname="İşlemTarihi" fieldtype="string" WIDTH="8"/><FIELD attrname="İşlemSaati" fieldtype="string" WIDTH="6"/><FIELD attrname="PoliceNumarası" fieldtype="string" WIDTH="20"/><FIELD attrname="YenilemeNumarası" fieldtype="string" WIDTH="2"/><FIELD attrname="ZeylNo" fieldtype="string" WIDTH="2"/><FIELD attrname="UrunKodu" fieldtype="string" WIDTH="4"/><FIELD attrname="BranşKodu" fieldtype="string" WIDTH="4"/><FIELD attrname="ZeylKodu" fieldtype="string" WIDTH="2"/><FIELD attrname="iptal" fieldtype="string" WIDTH="1"/><FIELD attrname="NetPrim" fieldtype="string" WIDTH="12"/><FIELD attrname="YangınSigortaVergisi" fieldtype="string" WIDTH="12"/><FIELD attrname="GiderVergisi" fieldtype="string" WIDTH="12"/><FIELD attrname="GarantiFonu" fieldtype="string" WIDTH="12"/><FIELD attrname="TrafikHizmetleriGeliştirmeFonu" fieldtype="string" WIDTH="12"/><FIELD attrname="BrütPrim" fieldtype="string" WIDTH="12"/><FIELD attrname="AcenteKomisyonu" fieldtype="string" WIDTH="12"/><FIELD attrname="PoliçeTürü" fieldtype="string" WIDTH="2"/><FIELD attrname="DövizCinsi" fieldtype="string" WIDTH="3"/><FIELD attrname="DövizKuru" fieldtype="string" WIDTH="12"/><FIELD attrname="MüşteriNumarası1" fieldtype="string" WIDTH="10"/><FIELD attrname="AdıSoyadı-Ünvanı1" fieldtype="string" WIDTH="48"/><FIELD attrname="DoğumTarihi1" fieldtype="string" WIDTH="8"/><FIELD attrname="EvTelefonu11" fieldtype="string" WIDTH="20"/><FIELD attrname="EvTelefonu21" fieldtype="string" WIDTH="20"/><FIELD attrname="İşTelefonu11" fieldtype="string" WIDTH="20"/><FIELD attrname="İşTelefonu21" fieldtype="string" WIDTH="20"/><FIELD attrname="FaxNumarası1" fieldtype="string" WIDTH="20"/><FIELD attrname="CepNumarası1" fieldtype="string" WIDTH="20"/><FIELD attrname="E-Posta1" fieldtype="string" WIDTH="28"/><FIELD attrname="VergiKimlikNumarası1" fieldtype="string" WIDTH="10"/><FIELD attrname="VergiDairesi1" fieldtype="string" WIDTH="32"/><FIELD attrname="TCKimlikNumarası1" fieldtype="string" WIDTH="11"/><FIELD attrname="ÖzelTüzelKodu1" fieldtype="string" WIDTH="1"/><FIELD attrname="Uyruğu1" fieldtype="string" WIDTH="7"/><FIELD attrname="BabaAdı1" fieldtype="string" WIDTH="32"/><FIELD attrname="Adres11" fieldtype="string" WIDTH="32"/><FIELD attrname="Adres21" fieldtype="string" WIDTH="35"/><FIELD attrname="Adres31" fieldtype="string" WIDTH="24"/><FIELD attrname="Adres41" fieldtype="string" WIDTH="32"/><FIELD attrname="Adres51" fieldtype="string" WIDTH="20"/><FIELD attrname="İlçe1" fieldtype="string" WIDTH="20"/><FIELD attrname="İl1" fieldtype="string" WIDTH="20"/><FIELD attrname="TemsilciNo1" fieldtype="string" WIDTH="1"/><FIELD attrname="Line" fieldtype="string" WIDTH="1"/><FIELD attrname="AracDegerKodu" fieldtype="string" WIDTH="6"/><FIELD attrname="Marka" fieldtype="string" WIDTH="20"/><FIELD attrname="Model" fieldtype="string" WIDTH="30"/><FIELD attrname="Plaka" fieldtype="string" WIDTH="10"/><FIELD attrname="TescilTarihi" fieldtype="string" WIDTH="8"/><FIELD attrname="ModelYili" fieldtype="string" WIDTH="4"/><FIELD attrname="RuhsatSahibi" fieldtype="string" WIDTH="32"/><FIELD attrname="MotorNo" fieldtype="string" WIDTH="25"/><FIELD attrname="SasiNo" fieldtype="string" WIDTH="25"/><FIELD attrname="YerAdedi" fieldtype="string" WIDTH="2"/><FIELD attrname="Tonaj" fieldtype="string" WIDTH="5"/><FIELD attrname="KulTarzKodu" fieldtype="string" WIDTH="3"/><FIELD attrname="KulTarzKodu2" fieldtype="string" WIDTH="2"/><FIELD attrname="KulTarz" fieldtype="string" WIDTH="32"/><FIELD attrname="VadeTarihi" fieldtype="string" WIDTH="8"/><FIELD attrname="Tutar" fieldtype="string" WIDTH="12"/><FIELD attrname="MüşteriNumarası2" fieldtype="string" WIDTH="10"/><FIELD attrname="AdıSoyadı-Ünvanı2" fieldtype="string" WIDTH="48"/><FIELD attrname="DoğumTarihi2" fieldtype="string" WIDTH="8"/><FIELD attrname="EvTelefonu12" fieldtype="string" WIDTH="20"/><FIELD attrname="EvTelefonu22" fieldtype="string" WIDTH="20"/><FIELD attrname="İşTelefonu12" fieldtype="string" WIDTH="20"/><FIELD attrname="İşTelefonu22" fieldtype="string" WIDTH="20"/><FIELD attrname="FaxNumarası2" fieldtype="string" WIDTH="20"/><FIELD attrname="CepNumarası2" fieldtype="string" WIDTH="20"/><FIELD attrname="E-Posta2" fieldtype="string" WIDTH="28"/><FIELD attrname="VergiKimlikNumarası2" fieldtype="string" WIDTH="10"/><FIELD attrname="VergiDairesi2" fieldtype="string" WIDTH="32"/><FIELD attrname="TCKimlikNumarası2" fieldtype="string" WIDTH="11"/><FIELD attrname="ÖzelTüzelKodu2" fieldtype="string" WIDTH="1"/><FIELD attrname="Uyruğu2" fieldtype="string" WIDTH="7"/><FIELD attrname="BabaAdı2" fieldtype="string" WIDTH="32"/><FIELD attrname="Adres12" fieldtype="string" WIDTH="32"/><FIELD attrname="Adres22" fieldtype="string" WIDTH="35"/><FIELD attrname="Adres32" fieldtype="string" WIDTH="24"/><FIELD attrname="Adres42" fieldtype="string" WIDTH="32"/><FIELD attrname="Adres52" fieldtype="string" WIDTH="20"/><FIELD attrname="İlçe2" fieldtype="string" WIDTH="20"/><FIELD attrname="İl2" fieldtype="string" WIDTH="20"/><FIELD attrname="TemsilciNo2" fieldtype="string" WIDTH="1"/><FIELD attrname="PoliçeBaşTar" fieldtype="string" WIDTH="8"/><FIELD attrname="PoliçeBitTar" fieldtype="string" WIDTH="8"/><FIELD attrname="TEMİNAT" fieldtype="nested"><FIELDS><FIELD attrname="TeminatKodu" fieldtype="string" WIDTH="4"/><FIELD attrname="TeminatAdı" fieldtype="string" WIDTH="37"/><FIELD attrname="Bedel" fieldtype="string" WIDTH="20"/><FIELD attrname="Fiyat" fieldtype="string" WIDTH="20"/><FIELD attrname="İndirimliPrim" fieldtype="string" WIDTH="6"/></FIELDS><PARAMS/></FIELD><FIELD attrname="Brans" fieldtype="nested"><FIELDS><FIELD attrname="BransKodu" fieldtype="string" WIDTH="3"/><FIELD attrname="BransAd" fieldtype="string" WIDTH="23"/><FIELD attrname="TeminatBedel" fieldtype="string" WIDTH="10"/><FIELD attrname="BransNetPrim" fieldtype="string" WIDTH="7"/><FIELD attrname="Komisyon" fieldtype="string" WIDTH="6"/></FIELDS><PARAMS/></FIELD><FIELD attrname="TAKSİT" fieldtype="nested"><FIELDS><FIELD attrname="VadeTarihi" fieldtype="string" WIDTH="8"/><FIELD attrname="Tutar" fieldtype="string" WIDTH="12"/></FIELDS><PARAMS/></FIELD></FIELDS><PARAMS/></METADATA><ROWDATA/><METADATA><FIELDS><FIELD attrname="AcenteKodu" fieldtype="string" WIDTH="4"/><FIELD attrname="Talikodu" fieldtype="string" WIDTH="1"/><FIELD attrname="TanzimTarihi" fieldtype="string" WIDTH="8"/><FIELD attrname="BaşlangıçTarihi" fieldtype="string" WIDTH="8"/><FIELD attrname="BitişTarihi" fieldtype="string" WIDTH="8"/><FIELD attrname="İşlemTarihi" fieldtype="string" WIDTH="8"/><FIELD attrname="İşlemSaati" fieldtype="string" WIDTH="6"/><FIELD attrname="PoliceNumarası" fieldtype="string" WIDTH="20"/><FIELD attrname="YenilemeNumarası" fieldtype="string" WIDTH="2"/><FIELD attrname="ZeylNo" fieldtype="string" WIDTH="2"/><FIELD attrname="UrunKodu" fieldtype="string" WIDTH="4"/><FIELD attrname="BranşKodu" fieldtype="string" WIDTH="4"/><FIELD attrname="ZeylKodu" fieldtype="string" WIDTH="2"/><FIELD attrname="iptal" fieldtype="string" WIDTH="1"/><FIELD attrname="NetPrim" fieldtype="string" WIDTH="12"/><FIELD attrname="YangınSigortaVergisi" fieldtype="string" WIDTH="12"/><FIELD attrname="GiderVergisi" fieldtype="string" WIDTH="12"/><FIELD attrname="GarantiFonu" fieldtype="string" WIDTH="12"/><FIELD attrname="TrafikHizmetleriGeliştirmeFonu" fieldtype="string" WIDTH="12"/><FIELD attrname="BrütPrim" fieldtype="string" WIDTH="12"/><FIELD attrname="AcenteKomisyonu" fieldtype="string" WIDTH="12"/><FIELD attrname="PoliçeTürü" fieldtype="string" WIDTH="2"/><FIELD attrname="DövizCinsi" fieldtype="string" WIDTH="3"/><FIELD attrname="DövizKuru" fieldtype="string" WIDTH="12"/><FIELD attrname="MüşteriNumarası1" fieldtype="string" WIDTH="10"/><FIELD attrname="AdıSoyadı-Ünvanı1" fieldtype="string" WIDTH="48"/><FIELD attrname="DoğumTarihi1" fieldtype="string" WIDTH="8"/><FIELD attrname="EvTelefonu11" fieldtype="string" WIDTH="20"/><FIELD attrname="EvTelefonu21" fieldtype="string" WIDTH="20"/><FIELD attrname="İşTelefonu11" fieldtype="string" WIDTH="20"/><FIELD attrname="İşTelefonu21" fieldtype="string" WIDTH="20"/><FIELD attrname="FaxNumarası1" fieldtype="string" WIDTH="20"/><FIELD attrname="CepNumarası1" fieldtype="string" WIDTH="20"/><FIELD attrname="E-Posta1" fieldtype="string" WIDTH="28"/><FIELD attrname="VergiKimlikNumarası1" fieldtype="string" WIDTH="10"/><FIELD attrname="VergiDairesi1" fieldtype="string" WIDTH="32"/><FIELD attrname="TCKimlikNumarası1" fieldtype="string" WIDTH="11"/><FIELD attrname="ÖzelTüzelKodu1" fieldtype="string" WIDTH="1"/><FIELD attrname="Uyruğu1" fieldtype="string" WIDTH="7"/><FIELD attrname="BabaAdı1" fieldtype="string" WIDTH="32"/><FIELD attrname="Adres11" fieldtype="string" WIDTH="32"/><FIELD attrname="Adres21" fieldtype="string" WIDTH="35"/><FIELD attrname="Adres31" fieldtype="string" WIDTH="24"/><FIELD attrname="Adres41" fieldtype="string" WIDTH="32"/><FIELD attrname="Adres51" fieldtype="string" WIDTH="20"/><FIELD attrname="İlçe1" fieldtype="string" WIDTH="20"/><FIELD attrname="İl1" fieldtype="string" WIDTH="20"/><FIELD attrname="TemsilciNo1" fieldtype="string" WIDTH="1"/><FIELD attrname="Line" fieldtype="string" WIDTH="1"/><FIELD attrname="AracDegerKodu" fieldtype="string" WIDTH="6"/><FIELD attrname="Marka" fieldtype="string" WIDTH="20"/><FIELD attrname="Model" fieldtype="string" WIDTH="30"/><FIELD attrname="Plaka" fieldtype="string" WIDTH="10"/><FIELD attrname="TescilTarihi" fieldtype="string" WIDTH="8"/><FIELD attrname="ModelYili" fieldtype="string" WIDTH="4"/><FIELD attrname="RuhsatSahibi" fieldtype="string" WIDTH="32"/><FIELD attrname="MotorNo" fieldtype="string" WIDTH="25"/><FIELD attrname="SasiNo" fieldtype="string" WIDTH="25"/><FIELD attrname="YerAdedi" fieldtype="string" WIDTH="2"/><FIELD attrname="Tonaj" fieldtype="string" WIDTH="5"/><FIELD attrname="KulTarzKodu" fieldtype="string" WIDTH="3"/><FIELD attrname="KulTarzKodu2" fieldtype="string" WIDTH="2"/><FIELD attrname="KulTarz" fieldtype="string" WIDTH="32"/><FIELD attrname="VadeTarihi" fieldtype="string" WIDTH="8"/><FIELD attrname="Tutar" fieldtype="string" WIDTH="12"/><FIELD attrname="MüşteriNumarası2" fieldtype="string" WIDTH="10"/><FIELD attrname="AdıSoyadı-Ünvanı2" fieldtype="string" WIDTH="48"/><FIELD attrname="DoğumTarihi2" fieldtype="string" WIDTH="8"/><FIELD attrname="EvTelefonu12" fieldtype="string" WIDTH="20"/><FIELD attrname="EvTelefonu22" fieldtype="string" WIDTH="20"/><FIELD attrname="İşTelefonu12" fieldtype="string" WIDTH="20"/><FIELD attrname="İşTelefonu22" fieldtype="string" WIDTH="20"/><FIELD attrname="FaxNumarası2" fieldtype="string" WIDTH="20"/><FIELD attrname="CepNumarası2" fieldtype="string" WIDTH="20"/><FIELD attrname="E-Posta2" fieldtype="string" WIDTH="28"/><FIELD attrname="VergiKimlikNumarası2" fieldtype="string" WIDTH="10"/><FIELD attrname="VergiDairesi2" fieldtype="string" WIDTH="32"/><FIELD attrname="TCKimlikNumarası2" fieldtype="string" WIDTH="11"/><FIELD attrname="ÖzelTüzelKodu2" fieldtype="string" WIDTH="1"/><FIELD attrname="Uyruğu2" fieldtype="string" WIDTH="7"/><FIELD attrname="BabaAdı2" fieldtype="string" WIDTH="32"/><FIELD attrname="Adres12" fieldtype="string" WIDTH="32"/><FIELD attrname="Adres22" fieldtype="string" WIDTH="35"/><FIELD attrname="Adres32" fieldtype="string" WIDTH="24"/><FIELD attrname="Adres42" fieldtype="string" WIDTH="32"/><FIELD attrname="Adres52" fieldtype="string" WIDTH="20"/><FIELD attrname="İlçe2" fieldtype="string" WIDTH="20"/><FIELD attrname="İl2" fieldtype="string" WIDTH="20"/><FIELD attrname="TemsilciNo2" fieldtype="string" WIDTH="1"/><FIELD attrname="PoliçeBaşTar" fieldtype="string" WIDTH="8"/><FIELD attrname="PoliçeBitTar" fieldtype="string" WIDTH="8"/><FIELD attrname="TEMİNAT" fieldtype="nested"><FIELDS><FIELD attrname="TeminatKodu" fieldtype="string" WIDTH="4"/><FIELD attrname="TeminatAdı" fieldtype="string" WIDTH="37"/><FIELD attrname="Bedel" fieldtype="string" WIDTH="20"/><FIELD attrname="Fiyat" fieldtype="string" WIDTH="20"/><FIELD attrname="İndirimliPrim" fieldtype="string" WIDTH="6"/></FIELDS><PARAMS/></FIELD><FIELD attrname="Brans" fieldtype="nested"><FIELDS><FIELD attrname="BransKodu" fieldtype="string" WIDTH="3"/><FIELD attrname="BransAd" fieldtype="string" WIDTH="23"/><FIELD attrname="TeminatBedel" fieldtype="string" WIDTH="10"/><FIELD attrname="BransNetPrim" fieldtype="string" WIDTH="7"/><FIELD attrname="Komisyon" fieldtype="string" WIDTH="6"/></FIELDS><PARAMS/></FIELD><FIELD attrname="TAKSİT" fieldtype="nested"><FIELDS><FIELD attrname="VadeTarihi" fieldtype="string" WIDTH="8"/><FIELD attrname="Tutar" fieldtype="string" WIDTH="12"/></FIELDS><PARAMS/></FIELD></FIELDS><PARAMS/></METADATA><ROWDATA/></DATAPACKET>
  717.  
  718. ]]>
  719. </Skeleton>
  720. </XmlTransformation>





  Alıntı
Bu mesajı beğenenler:


Benzer Konular...
Konu: Yazar Cevaplar: Gösterim: Son Mesaj
  [VBA] Birden çok Seçenek Seçili Alandaki Verileri Kopyalama evidi 9 635 26-02-2025, 17:36
Son Mesaj: evidi
  Form üzerinden Bir Kaç Tabloya Verileri Kaydetmek myesukan 2 399 21-01-2025, 16:45
Son Mesaj: myesukan
  [SORGU] Farklı Sütunlardaki Aynı Verileri Saymak TheREDROSE 11 796 31-07-2024, 16:15
Son Mesaj: TheREDROSE
access-sql-18 Dsum Ile Toplam Alırken Tarih Aralığınıda Süzme Yaptırma Sorunu kesoka 2 541 07-04-2024, 16:13
Son Mesaj: kesoka
  Tablodaki Verileri Yan Yana Yazdırmak 10pele 11 695 09-03-2024, 02:52
Son Mesaj: dsezgin
  Ağ Konumundaki Excel Dosyasından Alınan Verileri Güncelleyememe geneclean 2 414 20-02-2024, 14:27
Son Mesaj: dsezgin
  Verileri Güncellemek m_demir 18 997 21-01-2024, 19:59
Son Mesaj: m_demir
  Bir Sütuna Girilen Verileri Başka Bir Sütun Ile Karşılaştırıp Hesaplama bilservisci 4 716 08-01-2024, 11:58
Son Mesaj: bilservisci

Foruma Git:


Bu konuyu görüntüleyen kullanıcı(lar):