X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=FS%2FFS%2FSchema.pm;h=93571b68560b986bb26cac2f40d032c28e0593c7;hb=b490e791cc60013989d908041f174467e362a1ea;hp=53599953535ff056ca16555e7908fd7f3e13c8ad;hpb=83bc1fdf7145a2525b7e48f1dc6064e55ab4f31b;p=freeside.git

diff --git a/FS/FS/Schema.pm b/FS/FS/Schema.pm
index 535999535..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', '', '', '', '',
@@ -1382,19 +1399,19 @@ sub tables_hashref {
 
     'pay_batch' => { #batches of payments to an external processor
       'columns' => [
-        'batchnum',   'serial',    '',   '', '', '', 
-	'payby',      'char',      '',    4, '', '', # CARD/CHEK
-        'status',     'char', 'NULL',     1, '', '', 
-        'download',   @date_type, '', '', 
-        'upload',     @date_type, '', '', 
+        'batchnum', 'serial',     '', '', '', '', 
+        'agentnum',    'int', 'NULL', '', '', '', 
+	'payby',      'char',     '',  4, '', '', # CARD/CHEK
+        'status',     'char', 'NULL',  1, '', '', 
+        'download',       @date_type,     '', '', 
+        'upload',         @date_type,     '', '', 
       ],
       'primary_key' => 'batchnum',
       'unique' => [],
       'index' => [],
     },
 
-    'cust_pay_batch' => { #what's this used for again?  list of customers
-                          #in current CARD batch? (necessarily CARD?)
+    'cust_pay_batch' => { #list of customers in current CARD/CHEK batch
       'columns' => [
         'paybatchnum',   'serial',    '',   '', '', '', 
         'batchnum',   'int',    '',   '', '', '',