From b6eb07c5b6482b9129d106548e7605c5f8b31c86 Mon Sep 17 00:00:00 2001
From: =?utf8?q?Jan=20B=C3=BCren?= <jan@kivitendo-premium.de>
Date: Mon, 14 Dec 2015 15:34:49 +0100
Subject: [PATCH] =?utf8?q?Revert=20"retrieve=5Fitems=20in=20IR.pm=20bzgl.?=
 =?utf8?q?=20notes=20=C3=BCberarbeitet"?=
MIME-Version: 1.0
Content-Type: text/plain; charset=utf8
Content-Transfer-Encoding: 8bit

This reverts commit 8ce157d5872ae618bddee07147e0f902a3b3e31d.

Die DB-Aliase werden doch benötigt.
---
 SL/IR.pm | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git a/SL/IR.pm b/SL/IR.pm
index b0aa13430..55987afcf 100644
--- a/SL/IR.pm
+++ b/SL/IR.pm
@@ -1285,9 +1285,9 @@ sub retrieve_item {
     qq|SELECT
          p.id, p.partnumber, p.description, p.lastcost AS sellprice, p.listprice,
          p.unit, p.assembly, p.onhand, p.formel,
-         p.not_discountable,
+         p.notes AS partnotes, p.notes AS longdescription, p.not_discountable,
          p.inventory_accno_id, p.price_factor_id,
-         p.ean, p.notes,
+         p.ean,
 
          pfac.factor AS price_factor,
 
-- 
2.20.1