UF-002 Export to XML 00000010 SELECT T0.DocNum, T0.DocDate, T0.CardName, T0.DocTotal, T1.Address, T1.ZipCode, T1.City, T0.Comments FROM ORDR T0 JOIN OCRD T1 ON T0.CardCode = T1.CardCode WHERE T0.DocEntry = DocKey@ <?xml version="1.0"?> <SalesOrder Number="@Get('DocNum')" Date="@Get('DocDate')"> <Address> <Name>@Get('CardName')</Name> <Street>@Get('Address')</Street> <City>@Get('City')</City> <Zip>@Get('ZipCode')</Zip> </Address> <Remarks>@Get('Comments')</Remarks> <Items> #foreach(@line in @Lines) #BEGIN <Item Code="@line.Get('ItemCode')" Name="@line.Get('Dscription')" Quantity="@line.Get('Quantity')" Price="@line.Get('LineTotal')"></Item> #END </Items> <Total>@Get('DocTotal')</Total> </SalesOrder> BLANK . 2 dd.MM.yyyy 1 D:\Order DocKey@.xml utf-8 1 Y N D:\LogFolder Lines SELECT T0.ItemCode, T0.Dscription, T0.Quantity, T0.LineTotal FROM RDR1 T0 WHERE T0.DocEntry = DocKey@ 1