change texas-style tax exemptions to be against a specific line item rather than...

[freeside.git] / FS / FS / Schema.pm

diff --git a/FS/FS/Schema.pm b/FS/FS/Schema.pm
index 451ef2d..d502a12 100644 (file)
--- a/FS/FS/Schema.pm
+++ b/FS/FS/Schema.pm
@@ -976,6 +976,24 @@ sub tables_hashref {
       'index'       => [],
     },
 
+    'cust_tax_exempt_pkg' => {
+      'columns' => [
+        'exemptpkgnum',  'serial', '', '',
+        #'custnum',      'int', '', '',
+        'billpkgnum',   'int', '', '',
+        'taxnum',       'int', '', '',
+        'year',         'int', '', '',
+        'month',        'int', '', '',
+        'amount',       @money_type,
+      ],
+      'primary_key' => 'exemptpkgnum',
+      'unique' => [],
+      'index'  => [ [ 'taxnum', 'year', 'month' ],
+                    [ 'billpkgnum' ],
+                    [ 'taxnum' ]
+                  ],
+    },
+
     'router' => {
       'columns' => [
         'routernum', 'serial', '', '',