Hi Team,
I need one help form you.
I have below table structure with the data. I want this data to be sent as XML to destination. so i want to convert this table data to XML .How do i need to convert?
BU_CODE BU_TYPE CUST_NO CUR_CODE SALES_DATE RECEIPT_NO TILL_NO INVOICE_TOTAL ON_HOLD_FLAG
312 STO EUR 11/17/2012 104 9 381.72 N
312 STO EUR 11/17/2012 199 5 147.52 N
312 STO EUR 11/17/2012 23 52 110.84 N
312 STO EUR 11/17/2012 63 6 67.77 N
***************************************
<?xml version="1.0" encoding="UTF-8" ?>
- <tendermanagement xmlns="http://www.ikea.com/sarec/declaredfunds" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.prod.com/S_Dest/declaredfunds declaredFunds.xsd" buType="STO" buCode="312" sourceSystem="RIMS">
- <!-- RIMS
-->
<tendermovement date="2012-11-17T01:00:00Z" bookingType="DROP" tenderType="B2B Invoice" salesAreaGroup="STORE" valueTendered="381.72" tillNo="9" transactionNo="104" />
<tendermovement date="2012-11-17T01:00:00Z" bookingType="DROP" tenderType="B2B Invoice" salesAreaGroup="STORE" valueTendered="147.52" tillNo="5" transactionNo="199" />
<tendermovement date="2012-11-17T01:00:00Z" bookingType="DROP" tenderType="B2B Invoice" salesAreaGroup="STORE" valueTendered="119.84" tillNo="52" transactionNo="23" />
<tendermovement date="2012-11-17T01:00:00Z" bookingType="DROP" tenderType="B2B Invoice" salesAreaGroup="STORE" valueTendered="67.77" tillNo="6" transactionNo="63" />
</tendermanagement>