Rechnungsadresse aus den Stammdaten bei periodischen Rechnungen verwenden (Anzeige...

[mfinanz.git] / SL / DB / MetaSetup / Customer.pm

diff --git a/SL/DB/MetaSetup/Customer.pm b/SL/DB/MetaSetup/Customer.pm
index aca58747029048a3e88ebd8ba25e0867e77fa51e..01b2b63e914cc2b855bf5f1a6f0e1b144ebb22f2 100644 (file)
--- a/SL/DB/MetaSetup/Customer.pm
+++ b/SL/DB/MetaSetup/Customer.pm
@@ -23,6 +23,7 @@ __PACKAGE__->meta->columns(
   creditlimit               => { type => 'numeric', default => '0', precision => 15, scale => 5 },
   currency_id               => { type => 'integer', not_null => 1 },
   customernumber            => { type => 'text' },
   creditlimit               => { type => 'numeric', default => '0', precision => 15, scale => 5 },
   currency_id               => { type => 'integer', not_null => 1 },
   customernumber            => { type => 'text' },

+  contact_origin            => { type => 'text' },

   delivery_term_id          => { type => 'integer' },
   department_1              => { type => 'text' },
   department_2              => { type => 'text' },
   delivery_term_id          => { type => 'integer' },
   department_1              => { type => 'text' },
   department_2              => { type => 'text' },


@@ -38,7 +39,7 @@ __PACKAGE__->meta->columns(
   iban                      => { type => 'text' },
   id                        => { type => 'integer', not_null => 1, sequence => 'id' },
   itime                     => { type => 'timestamp', default => 'now()' },
   iban                      => { type => 'text' },
   id                        => { type => 'integer', not_null => 1, sequence => 'id' },
   itime                     => { type => 'timestamp', default => 'now()' },

-  klass                     => { type => 'integer', default => '0' },
+  invoice_mail              => { type => 'text' },

   language                  => { type => 'text' },
   language_id               => { type => 'integer' },
   mandate_date_of_signature => { type => 'date' },
   language                  => { type => 'text' },
   language_id               => { type => 'integer' },
   mandate_date_of_signature => { type => 'date' },


@@ -47,8 +48,10 @@ __PACKAGE__->meta->columns(
   name                      => { type => 'text', not_null => 1 },
   notes                     => { type => 'text' },
   obsolete                  => { type => 'boolean', default => 'false' },
   name                      => { type => 'text', not_null => 1 },
   notes                     => { type => 'text' },
   obsolete                  => { type => 'boolean', default => 'false' },

+  order_lock                => { type => 'boolean', default => 'false' },

   payment_id                => { type => 'integer' },
   phone                     => { type => 'text' },
   payment_id                => { type => 'integer' },
   phone                     => { type => 'text' },

+  pricegroup_id             => { type => 'integer' },

   salesman_id               => { type => 'integer' },
   street                    => { type => 'text' },
   taxincluded               => { type => 'boolean' },
   salesman_id               => { type => 'integer' },
   street                    => { type => 'text' },
   taxincluded               => { type => 'boolean' },


@@ -91,6 +94,11 @@ __PACKAGE__->meta->foreign_keys(
     key_columns => { payment_id => 'id' },
   },
 
     key_columns => { payment_id => 'id' },
   },
 

+  pricegroup => {
+    class       => 'SL::DB::Pricegroup',
+    key_columns => { pricegroup_id => 'id' },
+  },
+

   taxzone => {
     class       => 'SL::DB::TaxZone',
     key_columns => { taxzone_id => 'id' },
   taxzone => {
     class       => 'SL::DB::TaxZone',
     key_columns => { taxzone_id => 'id' },