diff options
| author | ivan <ivan> | 2011-10-25 23:46:58 +0000 |
|---|---|---|
| committer | ivan <ivan> | 2011-10-25 23:46:58 +0000 |
| commit | ee8121c4f331351c1163746648741abcd088ad30 (patch) | |
| tree | 683eea5fb9d66818f887c45203e6c5179fdcc653 | |
| parent | 75769d888d9c306d5d5ccde3260c0267268cf4ed (diff) | |
add legacy_cust_bill to hold legacy invoice content, RT#12981
| -rw-r--r-- | FS/FS/Schema.pm | 17 |
1 files changed, 17 insertions, 0 deletions
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', '', '', '', '', |