test

declare @p1 int
set @p1=NULL
exec SnProPOS_AddNote @p1 output,N'<SunPosSrv-xml><Record SalesTransPosHdr="0" SalesTransInitDate="2/4/2015" SalesTransEmploeeCode="0" SalesTransResourceCode="0" SalesTransNoteNo="342870" SalesTransNoteCode="89" SalesTransNoteRow="0" 
SalesTransNoteRowNo="1051090" SalesTransSaleTime="21" SalesTransCover="0" SalesTransGuests="0" SalesTransNotes="" SalesTransBeginTime="2/5/2015 9:00:17 PM" SalesTransEndTime="" SalesTransRealDate="2/5/2015" SalesTransOrderBeginTime="2/5/2015 9:00:17 PM" 
SalesTransOrderIssuedTime="2/5/2015 9:01:00 PM" SalesTransPerson="" SalesTransPosWaiterCleared="0" SalesTransPosWaiterClearedTime="" SalesStationOID="2" CustomerOID="1" TableOID="2" SalesManOID="1" PosSalesManOID="1" PaySalesManOID="0" 
SalesTransWater="0" SalesTransPosCanceled="0" SalesTransPosTotDiscPerc="0" SalesTransPosTotDiscVal="0" SalesTransPosType="0" SalesTransPosFiscalSN="" SalesTransPosLock="0" SalesTransPosAitiol="ΛΙΑΝΙΚΗ ΠΩΛΗΣΗ" SalesTransPosDelPlace="" TruckCmpOID="" 
SalesTransPosOnHold="" FinYearOID="16" SalesTransPosNoteAitiol="" SalesTransPosRoomNo="" SalesTransPosRoomType="" SalesTransPosAgent="" SalesTransPosCustomer="" SalesTransPosAccount="0" SalesTransPosRegNo="0" SalesTransPosDONSN="" RelayOID="0" SalesTransPosFromSalesStationOID="0" SalesTransPosToSalesStationOID="0" SalesTransPosMemberCode="" MainCustomerOID="0" SalesTransPosMainMemberCode="" SalesTransPosDailyOrderNo="0" SalesTransOID="0" SalesTransCashNet="3.81" SalesTransCashTip="0" SalesTransCashVat="0.49" SalesTransCashGrs="4.3" SalesTransQuantity="1" SalesTransOtherNoteNo="0" SalesTransItemNotes="" SalesTransDiscVal="0" SalesTransServRow="7" SalesTransFinNetVal="3.81" SalesTransFinVatVal="0.49" SalesTransFinPayVal="4.3" SalesTransConItemOID="0" SalesTransPosItemFlag="0" SalesTransPosItemStatus="0" SalesTransPosCustDiscPerc="0" SalesTransPosCustDiscVal="0" SalesTransPosItemDiscPerc="0" SalesTransPosItemDiscVal="0" SalesTransUpdSales="0" ShopItemOID="464" VatPercentOID="43" SalePriceOID="17" SalesTransStatus="0" SalesTransOrderPayedTime="" SalesTransOrderExecTime="" SalesTransPosRelOID="0" SalesTransPosNoteDiscPerc="0" SalesTransPosNoteDiscVal="0" SalesTransCashMtx="0.02" SalesTransPosPrice="4.3" SalesTransVatPerc="13" SalesTransMtxPerc="0.5" SalesTransPosFiscalDep="0" SalesTransPosStationNo="2" ItemCode="" ItemBookID="" AbbreviationDescr="" SalesTransPosPriceTicket="0" SalesTransPosTicketPerc="0" SalesTransPosTicketVal="0" SalesTransPosFODep="" SalesTransPosSeat="0" SalesTransPosUID="{EF836234-42E3-4845-AEB1-0958E33C552F}" SalesTransPosDummyCard="" ComboDtlOID="0" ItemLevel="1" MenuDtlOID="0"/><PayWay SalesPayWayOID="0" SalesPWDate="" SalesPWNoteCode="0" SalesPWNoteNo="0" SalesPWNoteRow="0" SalesPWValue="4.3" PayWayOID="6" SalesPWSalesMan="0" SalesPWPosHdr="0" SalesPWStationNo="0" SubsidyOID="0"/><GiftTransInfo AchieveLimit="0" CompletedAddedValue="0" GiftPrice="0" ChargePolicy="0" CustomerLianikis="1"/></SunPosSrv-xml>
',0,0,N'<POSPortions>
<Info Mode="Consume" UserOID="10" />
<Item ShopItemOID="464"  Quantity="1" />
</POSPortions>',0
select @p1