Hi, I was wondering what's "itemprices" table for, it has 3 fields: itemnumber price1 price2 I'm using koha version 2.1.2. regards -- Ernesto Silva - Webmaster - Universidad ORT Uruguay Cuareim 1451. Montevideo. Montevideo - 11100. Uruguay. Email: silva@ort.edu.uy "Men and nations will act rationally when all other possibilities have been exhausted." Katz law.
Ernesto Silva a écrit :
Hi, I was wondering what's "itemprices" table for, it has 3 fields:
itemnumber price1 price2
I'm using koha version 2.1.2.
regards
It's useless it seems : [paul@bureau koha]$ grep -R "itemsprices" * misc/koha.mysql:# Structure de la table `itemsprices` misc/koha.mysql:CREATE TABLE itemsprices ( Just used in the DB definition nowhere else ... (also, look at db scheme, on the wiki, it's in the "dropable tables ???" list) -- Paul POULAIN Consultant indépendant en logiciels libres responsable francophone de koha (SIGB libre http://www.koha-fr.org)
Hi
Hi, I was wondering what's "itemprices" table for, it has 3 fields:
itemnumber price1 price2
I'm using koha version 2.1.2.
I would *think* but am not sure, that this is information used in the full acquisitions mode - I will need to hear from Chris to be sure. In full acquisitions you record serveral different pieces of price information.... 1/. The list price of an item (ie what it says you will pay in the catalogue) 2/. The actual price you paid - which for us here in NZ is often different because of the vagaries of international exchange rates etc 3/. The Replacement Price - the amount that would be charged to a patron who looses a book - usually the recomended retail price. I'm not sure if these relate, but that's what I'd *expect* an itemprices table to be for Cheers Rachel
regards
It's useless it seems : [paul@bureau koha]$ grep -R "itemsprices" * misc/koha.mysql:# Structure de la table `itemsprices` misc/koha.mysql:CREATE TABLE itemsprices (
Just used in the DB definition nowhere else ... (also, look at db scheme, on the wiki, it's in the "dropable tables ???" list)
-- _____________________________________________________________ Rachel Hamilton-Williams Katipo Communications MANAGING DIRECTOR Ph 021 389 128 or +64 04 934 1285 mailto:rachel@katipo.co.nz PO Box 12487, Wellington http://www.katipo.co.nz New Zealand Koha Open Source Library System http://www.koha.org
Rachel Hamilton-Williams a écrit :
Hi
Hi, I was wondering what's "itemprices" table for, it has 3 fields: itemnumber price1 price2
I'm using koha version 2.1.2.
I would *think* but am not sure, that this is information used in the full acquisitions mode - I will need to hear from Chris to be sure.
Again, in the code, the itemsprice appears nowhere. Maybe it's used in a non-official/katipo specific installation, but I don't see it anywhere in the code. Chris, happy-married-guy, your opinion ? -- Paul POULAIN Consultant indépendant en logiciels libres responsable francophone de koha (SIGB libre http://www.koha-fr.org)
On Wed, Oct 27, 2004 at 09:57:06AM +0200, Paul POULAIN said:
Again, in the code, the itemsprice appears nowhere. Maybe it's used in a non-official/katipo specific installation, but I don't see it anywhere in the code. Chris, happy-married-guy, your opinion ?
Hi All Nope its a hang over from the original conversion from HLT's old system. The itemprice info is stored in the items table, other price information is stored in aqorders (if full acquisitions is in use) Chris -- Chris Cormack Programmer 027 4500 789 Katipo Communications Ltd chris@katipo.co.nz www.katipo.co.nz
participants (4)
-
Chris Cormack -
Ernesto Silva -
Paul POULAIN -
Rachel Hamilton-Williams