metasql/registrar.contracts.sql

diff --git a/metasql/registrar.contracts.sql b/metasql/registrar.contracts.sql
index 3fa1313..ae89819 100644 (file)
--- a/metasql/registrar.contracts.sql
+++ b/metasql/registrar.contracts.sql
@@ -33,7 +33,17 @@ SELECT
             aropen.aropen_distdate
         ), 0) AS cust_aropen_paid,
         item.item_number AS item_number,
-        item.item_descrip1 AS item_descrip1
+        item.item_descrip1 AS item_descrip1,
+
+        CONCAT(
+            invchead_billto_name,
+            CASE WHEN LENGTH(invchead_billto_address1) > 0 THEN E'\n' || invchead_billto_address1 END,
+            CASE WHEN LENGTH(invchead_billto_address2) > 0 THEN E'\n' || invchead_billto_address2 END,
+            CASE WHEN LENGTH(invchead_billto_address3) > 0 THEN E'\n' || invchead_billto_address3 END,
+            CASE WHEN LENGTH(invchead_billto_city) > 0 THEN E'\n' || invchead_billto_city END,
+            CASE WHEN LENGTH(invchead_billto_state) > 0 THEN E'\n' || invchead_billto_state END,
+            CASE WHEN LENGTH(invchead_billto_country) > 0 THEN E'\n' || invchead_billto_country END
+        ) AS contacts,
 FROM
         invcitem
 LEFT JOIN