From 6a820190812c3ed553e8a5e40696e4935358c473 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 7270ee3be6..9b256d050d 100644
--- a/Open-ILS/examples/fm_IDL.xml
+++ b/Open-ILS/examples/fm_IDL.xml
@@ -10300,7 +10300,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>
@@ -10311,7 +10311,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