metasql/registrar.contracts.sql

diff --git a/metasql/registrar.contracts.sql b/metasql/registrar.contracts.sql
index e4ada55..d58045e 100644 (file)
--- a/metasql/registrar.contracts.sql
+++ b/metasql/registrar.contracts.sql
@@ -47,7 +47,12 @@ SELECT
         CONCAT(
             item.item_number,
             CASE WHEN LENGTH(item.item_descrip1) > 0 THEN E'\n' || item.item_descrip1 END
-        ) AS product
+        ) AS product,
+        CASE WHEN aropen.aropen_paid < aropen.aropen_amount
+            'NO'
+        ELSE
+            'YES'
+        END AS is_paid
 FROM
         invcitem
 LEFT JOIN