metasql/registrar.contracts.sql
authorEdward <edward@roojs.com>
Wed, 17 Dec 2014 08:40:09 +0000 (16:40 +0800)
committerEdward <edward@roojs.com>
Wed, 17 Dec 2014 08:40:09 +0000 (16:40 +0800)
metasql/registrar.contracts.sql

index 8191087..f96a8da 100644 (file)
@@ -22,14 +22,14 @@ SELECT
             custinfo.cust_curr_id,
             aropen.aropen_amount,
             aropen.aropen_distdate
-        ), 0) AS aropen_amount_base,
+        ), 0) AS cust_aropen_amount,
         aropen.aropen_paid AS aropen_paid,
         COALESCE(currtocurr(
             aropen.aropen_curr_id,
             custinfo.cust_curr_id,
             aropen.aropen_paid,
             aropen.aropen_distdate
-        ), 0) AS aropen_paid_base,
+        ), 0) AS cust_aropen_paid,
         item.item_number AS item_number,
         item.item_descrip1 AS item_descrip1
 FROM