From 2600b955cf838f89ebf145142d77c7ded343b706 Mon Sep 17 00:00:00 2001 From: Geoff Sams <gsams@roanoketexas.com> Date: Wed, 6 Mar 2019 20:54:15 -0600 Subject: [PATCH] LP1681930 fm_IDL.xml billing/paid total column type correction. Both xact_billing_totals and xact_paid_totals had incorrect unvoided sum column types of int, this corrects them both to money instead. Signed-off-by: Geoff Sams <gsams@roanoketexas.com> Signed-off-by: Rogan Hamby <rogan.hamby@gmail.com> Signed-off-by: Galen Charlton <gmc@equinoxinitiative.org> --- Open-ILS/examples/fm_IDL.xml | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/Open-ILS/examples/fm_IDL.xml b/Open-ILS/examples/fm_IDL.xml index c8db25c2b6..3ed0f2acac 100644 --- a/Open-ILS/examples/fm_IDL.xml +++ b/Open-ILS/examples/fm_IDL.xml @@ -10301,7 +10301,7 @@ SELECT usr, <class id="rxbt" controller="open-ils.reporter-store" oils_obj:fieldmapper="reporter::xact_billing_totals" oils_persist:tablename="reporter.xact_billing_totals" reporter:label="Transaction Billing Totals"> <fields oils_persist:primary="xact"> <field reporter:label="Transaction ID" name="xact" reporter:datatype="int" /> - <field reporter:label="Unvoided Billing Amount" name="unvoided" reporter:datatype="int" /> + <field reporter:label="Unvoided Billing Amount" name="unvoided" reporter:datatype="money" /> <field reporter:label="Voided Billing Amount" name="voided" reporter:datatype="money"/> <field reporter:label="Total Billing Amount" name="total" reporter:datatype="money"/> </fields> @@ -10312,7 +10312,7 @@ SELECT usr, <class id="rxpt" controller="open-ils.reporter-store" oils_obj:fieldmapper="reporter::xact_paid_totals" oils_persist:tablename="reporter.xact_paid_totals" reporter:label="Transaction Paid Totals"> <fields oils_persist:primary="xact"> <field reporter:label="Transaction ID" name="xact" reporter:datatype="int" /> - <field reporter:label="Unvoided Paid Amount" name="unvoided" reporter:datatype="int" /> + <field reporter:label="Unvoided Paid Amount" name="unvoided" reporter:datatype="money" /> <field reporter:label="Voided (Returned) Paid Amount" name="voided" reporter:datatype="money"/> <field reporter:label="Total Paid Amount" name="total" reporter:datatype="money"/> </fields> -- 2.11.0