From 1d1646e6ceae2f119d28855ba916fb761909e327 Mon Sep 17 00:00:00 2001 From: miker Date: Mon, 28 Aug 2006 21:04:43 +0000 Subject: [PATCH] replacing tcn with item barcode git-svn-id: svn://svn.open-ils.org/ILS/trunk@5742 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Evergreen/src/extras/import/legacy_bill.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/Evergreen/src/extras/import/legacy_bill.sql b/Evergreen/src/extras/import/legacy_bill.sql index 6cd529f5bb..ebb2be3575 100644 --- a/Evergreen/src/extras/import/legacy_bill.sql +++ b/Evergreen/src/extras/import/legacy_bill.sql @@ -17,12 +17,12 @@ INSERT INTO money.billing (xact,billing_ts,amount,billing_type,note) lb.bill_date AS billing_ts, (lb.balance / 100.0)::NUMERIC(6,2) AS amount, lb.reason AS billing_type, - 'TCN of Bib Record: ' || br.tcn_value AS note + 'Item Barcode: ' || jl.item_id AS note FROM legacy_bill lb JOIN money.grocery mg ON (lb.user_key = mg.usr) JOIN actor.usr au ON (lb.user_key = au.id) JOIN actor.org_unit ou ON (lb.library = ou.shortname) - LEFT JOIN biblio.record_entry br ON (lb.cat_key = br.id) + LEFT JOIN joined_legacy jl USING (cat_key, call_key, item_key) WHERE lb.paid IS FALSE; COMMIT; -- 2.43.2