LP1681930 fm_IDL.xml billing/paid total column type correction.
authorGeoff Sams <gsams@roanoketexas.com>
Thu, 7 Mar 2019 02:54:15 +0000 (20:54 -0600)
committerGalen Charlton <gmc@equinoxinitiative.org>
Thu, 1 Aug 2019 14:41:44 +0000 (10:41 -0400)
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

index c8db25c..3ed0f2a 100644 (file)
@@ -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>