From: ivan <ivan>
Date: Tue, 25 Oct 2011 23:46:58 +0000 (+0000)
Subject: add legacy_cust_bill to hold legacy invoice content, RT#12981
X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=commitdiff_plain;h=ee8121c4f331351c1163746648741abcd088ad30

add legacy_cust_bill to hold legacy invoice content, RT#12981
---

diff --git a/FS/FS/Schema.pm b/FS/FS/Schema.pm
index 5c30a5e37..93571b685 100644
--- a/FS/FS/Schema.pm
+++ b/FS/FS/Schema.pm
@@ -538,6 +538,23 @@ sub tables_hashref {
       'index' => [ ['custnum'], ['_date'], ['statementnum'], ['agent_invid'] ],
     },
 
+    #for importing invoices from a legacy system for display purposes only
+    # no effect upon balance
+    'legacy_cust_bill' => {
+      'columns' => [
+        'legacyinvnum',  'serial',     '',      '', '', '',
+        'legacyid',     'varchar', 'NULL', $char_d, '', '',
+        'custnum',          'int',     '',      '', '', '', 
+        '_date',       @date_type,                  '', '', 
+        'charged',    @money_type,                  '', '', 
+        'content_pdf',     'blob', 'NULL',      '', '', '',
+        'content_html',    'text', 'NULL',      '', '', '',
+      ],
+      'primary_key' => 'legacyinvnum',
+      'unique' => [],
+      'index'  => [ ['legacyid', 'custnum'], ],
+    },
+
     'cust_statement' => {
       'columns' => [
         'statementnum', 'serial', '', '', '', '',