metasql/registrar.invoices.sql

diff --git a/metasql/registrar.invoices.sql b/metasql/registrar.invoices.sql
index 861b705..20803bc 100644 (file)
--- a/metasql/registrar.invoices.sql
+++ b/metasql/registrar.invoices.sql
@@ -30,6 +30,13 @@ FROM
             invchead_invcdate,
             invchead_invcnumber,
             to_char(invchead_invcdate,'DD/Mon/YYYY') AS f_invchead_invcdate,
+            invchead_billto_name,
+            invchead_billto_address1,
+            invchead_billto_address2,
+            invchead_billto_address3,
+            invchead_billto_city,
+            invchead_billto_state,
+            invchead_billto_country,
             custinfo.cust_name AS cust_name,
             admin_cntct.cntct_registrar_organization AS admin_cntct_registrar_organization,
             CONCAT(