metasql/registrar.invoices.sql

diff --git a/metasql/registrar.invoices.sql b/metasql/registrar.invoices.sql
index 1fccf9d..6e57fa3 100644 (file)
--- a/metasql/registrar.invoices.sql
+++ b/metasql/registrar.invoices.sql
@@ -60,18 +60,7 @@ FROM
                 CASE WHEN LENGTH(admin_cntct_addr.addr_state) > 0 THEN E'\n' || admin_cntct_addr.addr_state END,
                 CASE WHEN LENGTH(admin_cntct_addr.addr_country) > 0 THEN E'\n' || admin_cntct_addr.addr_country END
             ) AS contacts,
-            COALESCE(currtocurr(
-                aropen.aropen_curr_id,
-                custinfo.cust_curr_id,
-                aropen.aropen_amount),
-                aropen.aropen_distdate
-            ), 0) AS original_amount,
-            COALESCE(currtocurr(
-                aropen.aropen_curr_id,
-                custinfo.cust_curr_id,
-                aropen.aropen_paid),
-                aropen.aropen_distdate
-            ), 0) AS paid_amount,
+            
             COALESCE(currtocurr(
                 aropen.aropen_curr_id,
                 custinfo.cust_curr_id,