ReceiptArticles0.472572cmtrueGtrueAnztrueBezeichnungtrueCHF/StktrueCHF0.439239cmtrueTextBox10=Fields!TaxCode.Value+Fields!DiscountLocked.Valuetrue=Fields!Quantity.Valuetrue=Fields!Title.Valuetrue=Fields!UnitPrice.Valuetrue=Fields!NonDiscountPrice.Value0.468473cmtruetruetrueTextBox72=Fields!TareGrams.ValuetrueTextBox73="CHF\"+Fields!Unit.Valuetrue=Fields!Editmode.Value<>20.468473cmtruetruetruetrue=IIF(Fields!SaleId.Value IS NULL,Fields!DiscountPercent.Value,Fields!OriginalPrice.Value)true=Fields!Discount.Value=0=Fields!SaleId.Value Is NULL0.468473cmtruetrue2trueTextBoxDiscount=IIF(Fields!DiscountPercent.Value IS NULL,"Rabatt",("Rabatt "& ToInt16 (Fields!DiscountPercent.Value)&"%"))true=Fields!Discount.Value* Sign ( Fields!Quantity.Value*-1 )=Fields!Discount.Value=0=Fields!Quantity.Value0NotEqual3.668473cm0.3cm0.8cm3.65cm1.1cm1.4cm5.2cm=Count(Fields!Title.Value)=07.25cm6
0.3cm29.7cm21cm7.25cmTrueIntegerReportParameter1IntegerReportParameter1StringtrueReportParameter1IntegertrueReportParameter1R0lGODlhyAA+APcAAFa+5H5+fbPi8tHR0YqKipzZ7wCZ1HPJ6Mbq9YjR7Pb29p2dnKKiopGRkYGBgQCY1Pr7+rq6uWFhYbS0tOz4+9ra2rvl80274gCT0sHo9e/u7pqamra3tkpKSjiy3wCc1aTc8Mzs9jWx3qampsnJyOn3+/j4+GnG52pqauDg4Bin2g2i2NXu91hYWPX19I6OjSSr28TExKqqqvPz8nzN6oDP6gSd1sHBwLOzskK34f7+/nBwcNzd3NbW1qre8Syu3eX1+tnx+M/PzlxcXJeXll3B5XR0dO3t7NTU1BKl2WHD5UZGRpTW7fDw8G5ubujp6N3y+fr9/ufn5mxsbLy9vHJycmVlZWZmZgCd1svLymhoaPD5/JSUlFpaWuvr6sPDwoaGhq6urnh4eHZ2dqioqPb8/djY2F9fX83NzPT7/d/f3uTk462trMfHxoSEhHp6egmh2LCwsOL0+mbE5uLi4r6/vj214B6o2vLy8W/I6EW44VdXV+Xl5Aag1+Dz+dfX1oLQ62XD5gOc1VVVVU9PT01NTVRUVExMTE5OTgCY01JSUlFRUVBQUFNTU/j493p5ef7+/ePk49vc2/39/ODg3/z8+/b29fz8/Nzc2/Dw7/r6+fT0887Ozf39/f3+/uLi4crKyerq6djY19PU00lJSebm5cDAv7/Av+7u7ezs68HBwaysq3x8e8jIx97e3bS0s9ra2ZWVlXh4d66urcbGxaqqqXFxcYaGhZOTk0tLS+jo57/n9LCwr8zMy01OTre3t6iop1BRUN3d3GpqaVlZWW5ubVVWVoODg09PUGdnZ29vb7u7uqCgoFNTVGNjY3d3d7W1tba2tfn5+J+fn5eXl3DF5qurq9na2ZCQkAGe1/Hx8Kenp93e3enp6M/Pz+Pj4mlpaampqd/g3/f39uHh4WPE5oCAf8XFxdXV1aSko4eHh1laWcPDw1laWmhoZ1hYV3JycbKysWtra4iIiG1tbYDM6XV2dnV1dQmf1m3I51paWYWFhQCe1lZWVv///////iH/C1hNUCBEYXRhWE1QPD94cGFja2V0IGJlZ2luPSLvu78iIGlkPSJXNU0wTXBDZWhpSHpyZVN6TlRjemtjOWQiPz4gPHg6eG1wbWV0YSB4bWxuczp4PSJhZG9iZTpuczptZXRhLyIgeDp4bXB0az0iQWRvYmUgWE1QIENvcmUgNS4wLWMwNjAgNjEuMTM0Nzc3LCAyMDEwLzAyLzEyLTE3OjMyOjAwICAgICAgICAiPiA8cmRmOlJERiB4bWxuczpyZGY9Imh0dHA6Ly93d3cudzMub3JnLzE5OTkvMDIvMjItcmRmLXN5bnRheC1ucyMiPiA8cmRmOkRlc2NyaXB0aW9uIHJkZjphYm91dD0iIiB4bWxuczp4bXA9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC8iIHhtbG5zOnhtcE1NPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvbW0vIiB4bWxuczpzdFJlZj0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL3NUeXBlL1Jlc291cmNlUmVmIyIgeG1wOkNyZWF0b3JUb29sPSJBZG9iZSBQaG90b3Nob3AgQ1M1IFdpbmRvd3MiIHhtcE1NOkluc3RhbmNlSUQ9InhtcC5paWQ6NjU2ODk1QkQ3Rjg1MTFERkI5NTk4MjI4MzU5NDUzNzEiIHhtcE1NOkRvY3VtZW50SUQ9InhtcC5kaWQ6NjU2ODk1QkU3Rjg1MTFERkI5NTk4MjI4MzU5NDUzNzEiPiA8eG1wTU06RGVyaXZlZEZyb20gc3RSZWY6aW5zdGFuY2VJRD0ieG1wLmlpZDo2NTY4OTVCQjdGODUxMURGQjk1OTgyMjgzNTk0NTM3MSIgc3RSZWY6ZG9jdW1lbnRJRD0ieG1wLmRpZDo2NTY4OTVCQzdGODUxMURGQjk1OTgyMjgzNTk0NTM3MSIvPiA8L3JkZjpEZXNjcmlwdGlvbj4gPC9yZGY6UkRGPiA8L3g6eG1wbWV0YT4gPD94cGFja2V0IGVuZD0iciI/PgH//v38+/r5+Pf29fTz8vHw7+7t7Ovq6ejn5uXk4+Lh4N/e3dzb2tnY19bV1NPS0dDPzs3My8rJyMfGxcTDwsHAv769vLu6ubi3trW0s7KxsK+urayrqqmop6alpKOioaCfnp2cm5qZmJeWlZSTkpGQj46NjIuKiYiHhoWEg4KBgH9+fXx7enl4d3Z1dHNycXBvbm1sa2ppaGdmZWRjYmFgX15dXFtaWVhXVlVUU1JRUE9OTUxLSklIR0ZFRENCQUA/Pj08Ozo5ODc2NTQzMjEwLy4tLCsqKSgnJiUkIyIhIB8eHRwbGhkYFxYVFBMSERAPDg0MCwoJCAcGBQQDAgEAACH5BAAAAAAALAAAAADIAD4AAAj/AP8JHEiwoMGDCBMqXMiwocOHECNKnEixosWLGDNq3Mixo8ePIEOKHEmypMmTKFOqXMmypcuXMGPKnEmzps2bOHPq3HnSn8+fQCECHeqP50CiRRci/ak06NGlD5f6FOrvkqQ6OFaxgaZKUiWmCn+u+TKBDZtXN2BBmBpx6D+3H0uwmEu3TMKp5FRN0PpKlbBLbA3604RnxoxNkAQWpXQj66xfoDQERuhzkiRTWbd2XTuZsgsczxoVOpQr16FCze4xgwUp6UF/46g4IDa69OlG90ZI6XzXn58Ccy7YEWHnQh4BJXhTdh0WkIE+0G1kQ8D8qItlAfbUNl3I0DNg3Xj7/4tATIKEIVn86Thnrt/2Q4gkEKFUnaA/Bb/eiCbNvVGVBWZMUp99wtjSASGD9KPggoMwcto0A/qEhDK5IGLIggwykksX8azVVAgA9GHAAwaUWCKJSdAgx4AF+SPHLizaV0MiWNT4wQfUteiPEE5UmCCG/TTYwRDQdFKdP6+Q0kgjh5gzDhfw/YhhI7m08It4lFRxoJQMLpJLIRDe1cMQiABppnuq1OcTMIoQciaQVJqDSoz+UFCEDQZgwc+efPL5QSIrABIFnQKsUESMR83IZ405HtVJOsgw8iaGiuTihjbM+QPNIQu2QA8iXJpJZTqT+YMJmZMu2AEHLPojzQ6FYP84CCGH1IpII/0ocgUeR/6zQS4XMtgmIYsEq+ozLkQIhQg09ulsn39eQEGEINiAgRKIKqbonoy65hMRpHA5yLCKhEqKA9J4u6mwCxrCCCLFAmlIIex46w8rnGJIK2m35mrFnJSRUGaXDoSBQzjzSIDIEkSoWUsHUg7iiyFasBLAFC10h2EuBHTmTxB3GPDsyH0mYkcaRwpgwwcGYMuQP9vy061i/jCTS8SFDKJFAAHIo52x/XTABVua5ktpIUMYYc4OXViIISPyjJOUP1kg2GUABltDgASELEENnbEYPW40Q+FBBQoDHDnAILgqaAgh2GAi9WClrKLPIgzSm2kJMIj/7CwWBiTyAIl6OpsIAHuHzE/L2b4V88xvZRGv24zEIszc0qwxwh6KdInG1OtiWIgV8XQjIAShWLNH2woWcqViC+TyNBtl3yAPJ636E4CbCiqCgtT2+dOEJpnq8EisCs7Ky1IDDME6ImIE5k8RiTxrwAp60JAADXas4PeiBoDg7QkP7Mn4y49jkaOrTvAepCJXIiUEMc9HX1TRTwdwBFJUWN06GFNrAPL60Ygz7C94mVBA7hwwsFxFTU2C4YT/3LMB5YxngONKm2IE8IHC7elG+QDCUKBQhDz1yQAwQNlbWICPwp1PKelbnyoG2I9DLMCC0Ggg2/5wv9D1YxFTmIGa//zhAPcpwgqbuB8uBljAA7ZIKekw2g9lAJblqIOJQ9gNZWaQjM4pKBdheoseviczGxTAY/5wjrMM4IP7AaJ85nMZDKvHLfX9BAwNbIQzQtEqLnqxH7mIRw+NRghWWDACAzREF0pxv23IbkGMYEAVG+IPSTQiYoR4AX2U85ZNWOGPiHiBVH4yDaMhQh33C0IfPLi4BOTuAmQ0AOIEIoLvvTAsMfSJJ/9YiAqO0h8CXFAhRPkWHxLiERYcgKSStwc13C8F7zDWIBAxD2dyUjD+IEAHgBSrWwhBB+LpQbkWtIgGUIED6EynOqnwgmX2gxFGEJA/QBBLEQzqLhmokZ9gUP+GOiXhA3y65V1y6Q8kjFNB5TynOhcqG3fCU57GRGaEyNGCYA1iEJi4nz9iQQoggcoNoGhN496Cih1IsR/zUoQR4oGpTH2hgf3g3GkKQdOa1vQQi9jDgnznCJ8oIZZnVEoOvocFOATBnwCNY+NgRkeZ2dEfOJCiTG1KVZoqQqe9Q0FP8aegY1pwDe2w6CAkMbVMwOOkgyhEMGwRhzktNRVi6ADQgqQhZ1BBer+gYaomtQhlcMYOROVHCLLljwPA0XwCQGpA5YjLpnbLHwx45F5TtQgncCaiFowEMcRK1qNo4BHAAlKDciEBsi3VEQwYxCFYR85CYMNDxTzpZM2EiGP/TKWWflqBCJVSgFgyQbFKfRkNHPtUZsh2thg65U8wGyHNcjZTmtjGHlZrpkq9wARL9YcruDCEQvwxeR3AxlS4CklCmPe86E2veRl2Pw8QtQ8sIKwFyPgAQPhjCypI6uJmqZRABHawNTspI9RLYPQuoRaDXJBXm7vZ5I31SP74BBHO4F0zkUKUI/XJEcIhgUMAbRC5SNNbloFBK6GBBChOsYpXTAJarOF+YzxhG5WSAf3yIxE18EcZYKBfA9hhqYBdlG594kgGmZjFSE4xLbyQ4K5K9DXOdXBnsZmJMDhDYwzKxesc4hM8AMMQ30WEIX3SCh0aogK/hMpbDHtC/uLT/8Y49ocnfqDfoh41LGm4g34/oIIt+IQKGDxzmpGiGOZCucFBenBvNkEGY3yXEFUQEFVAMQRjFdCtFDVWIawx0tdYwMY1sgCi/FHjkuXYH7Ds0wN+GxYOQusHnnhLpoUZh04LxtCCiXKip9yb5rHOEHv4hq2PYtwuIcEnmpAH3hCKAgUq5TUUyC+0YAAFOpWaT3H2RwKayo8PwMDPlCmDe1UdiPtpYgrLfuc9iPfsWxPyyblG9EV5HZYwYHAR6Bi1mkDhvn4gAhT324AUEcEMTvqjE8ATTB4Oa747iHqSb7n2nrIdAhuwUpb9FIwn5kBGLHwgA1OjhhQLIclWXcISav/CdYt0Pe9MiQcN/WbEKFr1iy9U0SeIZJAhOusPcqCUQYhgAPGQ0ok4DE1NQJA2tD5wARAgoAQtkviNcyxGMvLjAXqo9lBKkOoTesA+SFhExBixCnkSBRLhaIDHVG4flitaMb9Ik/T8EQMdKkIUERqHFQ4xjz/MzSd0QPdOrZCst/gDG9vMmxNMoQtLTAICm5ACFe5RiEUc+zVMYHhAA3eATEk9zm9BgCBYubgVlCMDQQgCAvKQBKsDbsY0c4MU02qEG3TD8RCYAR+WUYWcObNFbD+K26fsD0tYwVJI2KpPpFCFdBtiCOF5DQ5y5otGoIAAXIjFPoaQbkCKd2oakAf/TH+IiC4kwwi2sAIxECGpQnQsQnPgtqrz4Hk4U/0t+ZC/zAzwAeiwzMYTdygt0g0S4E4KMmDmZwQ74AwtwH7u8X72EXyKMXxTUwc5gwiKMAzzkH23MAQGeAhuIB4QYAvLNC415TQ71Q/CkCk90AUG6DaKwAiM0AjSZAgapHEA0CzO8gD0Zx+fd3/+EAV6oH91RDIP8APJIRjz84IoFYMzaCyGYAhmkCkS+BYUaHhvwDvjggg0hYK9swdT+BrnsARzdSbEcgNqIgrOEFqTZQhLQEyv4Q/kA4A8WH+m5i0U4AE6SDKG8wN+0CoDIAFsuFeNsAQVFIHvllnypmj+AAqk/1CGZkIIwXBXlIEJ6gBIB6VzhJALO+ANrXIE1LAHuVAsocI2mzgEC+BElAECd5AIHbQndeiD9pcpaXACeMKHm1cE0xIWXoANgESKotUIiJALZzANkmEfOLAEi7CMHXAPFvQNb7OMMshzakAAv1iKb5MLU4A7YVFJsZAM5IcIiEAIz8cK0ZAu3fgJC2ALXdAIhCCOxLIHEhAA28BHS7UFNQADi/MAGFANdoht9/cUu5ADf8J/fQI4D/ABIpBY2eUKG+AExNAm8JhTEmAO1rA/R1IHziAPHGkFECgYUuAE4MCRKIAC9EEzwkAEKLAHiyCO41iO8ZBw3egPLkAOSBADdf9wCr0gCakATtk1GFIgCq2Qk22ADpSQCT7ZaT5RBiFQAAegBLCnGD8YIZ4QAgfQPSzDf3DgAXmQAffEZT4hDaXwB21AlOhADplgeAhRCY7Qlm0pDQoBCW7plonxFPfxCUhACzmZBbDgBSJFFWoWFaM0EUQRdbPYGy6yCwIgALvgB0lJmIOJmE4hmQYnFUaREaR2mE0xmZfZmSyRmXfomaJpFKAJkMNmH5t5mqO5mrIYmm3RDRHwFXdRAULAbj2hmqyJmVOpI0Qzd71wBunCmf4wCztgDreAjsEzNXPXm8xJM+OlC2Fgm7lpEqU5cQH5FpdADpKAcv4QCn+AKW+hAZT/YArgkC6bYAZ8AE5HMQYxIA1DsIL2oQGiYI/jcA2fAE4uoAlSgAnB2QnfUAHJ4g+ZMJ9FoQHaIAm7AVVn8Am8Mp3UuZuKoQ3mQA+2EIJxYAWsAA640wrOYA9XQA//IA7KcA9X8DVTIwPzMAIOIJuKMQFW8AxaMACoYAtjMAW44A+8wDNXcAz/MA5gIA9VEACQ0Apa8AxWwGkBQA9vMATTAAnZYQsTgJsOKhHVOXXeggtvIA2VcATkMAQzJwNOoAHOQDbkOQ7wAA3+oA3JcA5T0wakJUSToBgVMASf4wWOMA9qpwFnIAS1cA+QkApDIAkjoAyO1w1HkAwA5woSkAJV/4AD/iAKQ2AGJPA7dTmlI1GloPcWlTAFnugTZCALPkEO4MALRuATnFAMc9oA1LABVkAG9xMDTqAK8HAODcCN/rAAAfAT2jAE+UZEbGANX3MJ8nAOYmBzPvEF67ABRLABEpAFshADPhEAI+AN8gAYlkoSmAqEECAPM/cWZCBRagAOMmA/nOAEf3AGA6AGmBAJQuQT9HBXlHAFWgAw/rABDqCrQ9ADPuEAs2ANseAPmxoDz9AG90MFyUAJmMANpTAOtgCturMNnIAC1nqtIuEPu5AIJmIAGFAP3vICAQAYa8ADZ4BmDGALn9ACtOAPqnAFmzAMVCQN0ecTquETb9APwv/2FkjQBTMnBRqgDl/TDcQwANtwo5WgBVnAAFXQUymgC2eAhnjAZMqwDP4wAMSgBt4wBJhSqRTrEf5QAgXwtWA7WEfhBbLwDA4QABDABsowD/SQNjIgAfPwCGPwDz1ADw7ACjekGH8gD25gDtTADAEQnP5gDVcwD8pwDqlgBPtgBA1DBjdUCffQC+MQAEbgBo+gAKrgDmAwBstjBE5AAFYwAq7iADsQC8i5tR9BaPbRCeSgBlt1BBWAcm9xBMKwCZbwFuOACaXQGkcxDqLwYjqgAbbpDxpwDajwFtLAAwnalkWxCWsBCWsgDFu1CRXAZP9gCxGwBvQqDcIgBaj7Ek5AARZwwZmGNzW86Zw0k77h+xOQAA6mIL7X9L3yaxFFQQJPIKXzm79Uob/827/++78AHMACPMAEXMAGfMAILBABAQA7image/gifinitial catalog=arcavis_dev;persist security info=True;user id=arcavis;data source=sequens.cloudapp.net;password=arcavisdbpass;SQLNumberTransactionIdTitleSaleDaySaleTimeReceiptHeaderTaxNumberReceiptFooterLogoBarcodeSellerNameAmountRemarksClientBonusPointsAmountEURSELECT R.Id AS Number
,R.Id AS TransactionId
,'Zwischenrechnung' AS Title
,GETDATE() SaleDay
,GETDATE() SaleTime
,B.ReceiptHeader
,B.TaxNumber
,B.ReceiptFooter
,Logo
,CASE
WHEN AllowSelfScanning = 1
AND ISNULL(C.ContactEmail, '') <> ''
AND ISNULL(C.AppPassword, '') = ''
THEN 'R,C,' + HostUrl + ',' + C.ContactEmail
ELSE ''
END Barcode
,U.Realname AS SellerName
,RA.Amount
,R.Remarks
,C.DisplayName + CHAR(10) + ISNULL(C.Street, '') + ' ' + ISNULL(C.StreetNumber, '') + CHAR(10) + ISNULL(Zip, '') + ' ' + ISNULL(City, '') AS Client
,0 AS BonusPoints
,RA.Amount / ISNULL((
SELECT ExchangeRate
FROM Currencies
WHERE CurrencyIsoCode = 'EUR'
), 1) AS AmountEUR
FROM Reservations R
INNER JOIN (SELECT ReservationId, ROUND(SUM(Quantity * UnitPrice - Discount),2) Amount FROM ReservationArticles WHERE ReservationId=@ReservationId GROUP BY ReservationId) RA ON RA.ReservationId = R.Id
INNER JOIN [Configuration] ON [Configuration].Id = 0
INNER JOIN ReservationTypes RT ON R.ReservationTypeId = RT.Id
INNER JOIN PointOfSales POS ON POS.Id=@PointOfSaleId
INNER JOIN Branches B ON B.Id=POS.BranchId
INNER JOIN Users U ON U.Id = @UserId
LEFT OUTER JOIN Persons C ON R.PersonId = C.Id
LEFT OUTER JOIN Places PL ON PL.Id = C.PlaceId
WHERE R.Id = @ReservationIdArcavis=Parameters!ReservationId.Value=Parameters!PointOfSaleId.Value=Parameters!UserId.ValueTitleQuantityDiscountDiscountPercentPriceNonDiscountPriceOriginalPriceNetPriceUnitPriceSaleIdTaxCodeTaxRateDiscountLockedUnitEditModeTareGramsDECLARE @xml xml
SELECT @xml = CONVERT(xml,'<root><s>' + REPLACE(@ReceiptPositions,',','</s><s>') + '</s></root>')
SELECT CASE
WHEN U.Editmode = 2
THEN U.TitleShort_de + ' '
ELSE ''
END + A.Title AS Title
,A.Quantity
,A.Discount
,A.DiscountPercent
,(A.Quantity * A.UnitPrice - Discount) Price
,(A.Quantity * A.UnitPrice) NonDiscountPrice
,OA.Price * A.Quantity OriginalPrice
,ROUND((A.Quantity * A.UnitPrice - Discount) / (1+TaxRate),2) NetPrice
,UnitPrice
,NULL SaleId
,CASE
WHEN A.TaxRate = 0.077
THEN 'A'
WHEN A.TaxRate = 0.025
THEN 'B'
WHEN A.TaxRate = 0.038
THEN 'C'
WHEN A.TaxRate = 0
THEN 'F'
ELSE CONVERT(VARCHAR, OA.TaxId)
END AS TaxCode
,A.TaxRate
,CASE
WHEN OA.IsDiscountLocked = 1
THEN '*'
ELSE ''
END AS DiscountLocked
,U.TitleShort_de Unit
,U.EditMode
,U.TareGrams
FROM ReservationArticles A
INNER JOIN Articles OA ON OA.Id = A.ArticleId
INNER JOIN Units U ON U.Id = A.UnitId
WHERE A.ReservationId = @ReservationId
AND (ISNULL(@ReceiptPositions,'') = '' OR
A.Sort IN (SELECT T.c.value('.','int')
FROM @xml.nodes('/root/s') T(c)))Arcavis=Parameters!ReservationId.Value=Parameters!ReceiptPositions.Value