Will there be just 1 transaction per bank voucher, or can there be many transactions embedded in each voucher? This points to the next logical question: Do you want to end up with 1 table (voucher) which contains fields for 1 transaction only or do you want 2 tables (voucher and transaction). If two tables, how will you tie the two tables together (foreign key from transaction to voucher).
Do you have an XSD schema for this XML?
Give us more info and we may be able to help more.
>I have a complex xml file containing two data level.
>
>I have used xmltocursor("xmlfile", "test", 512) function to convert this file to cursor. Function is working. But It converted only outer part of xml. The inner xml part of this file starting with "TRANSACTION" keyword transfered as TRANSACTION field. The xlm file is below.
>
>How can I transfer this file completely to cursor.
>
>Thanks in advance
>
>
>
><?xml version='1.0' encoding='ISO-8859-9' ?><BANK_VOUCHERS><BANK_VOUCHER DBOP='INS'>
><DATE>27.03.2006</DATE><NUMBER>15370115761</NUMBER><DIVISION> 204</DIVISION><TYPE>3</TYPE><CREATED_BY>1</CREATED_BY><HOUR_CREATED>16</HOUR_CREATED><MIN_CREATED>03</MIN_CREATED><SEC_CREATED>33</SEC_CREATED><TRANSACTIONS><TRANSACTION>
><BANKACC_CODE>34 0601</BANKACC_CODE><ARP_CODE>3463</ARP_CODE><DATE>28.03.2006</DATE><TRCODE>3</TRCODE><MODULENR>7</MODULENR><DESCRIPTION>İst.Boğaziçi.Perpa 3463 KODLU BAYII</DESCRIPTION>
><DEBIT>252000</DEBIT><AMOUNT>252000</AMOUNT><TC_XRATE>1</TC_XRATE>
></TRANSACTION></TRANSACTIONS></BANK_VOUCHER></BANK_VOUCHERS>
>