Projekt

Allgemein

Profil

« Zurück | Weiter » 

Revision 37ce1a9c

Von Waldemar Toews vor fast 11 Jahren hinzugefügt

  • ID 37ce1a9c9052de31c299f37bdf591a8d87e3963a
  • Vorgänger 1f6a2920
  • Nachfolger 2565f6c2

Zusatzspalten fuer Kontoinhaber

Unterschiede anzeigen:

SL/DB/MetaSetup/Customer.pm
26 26 
  delivery_term_id    => { type => 'integer' },
27 27 
  department_1        => { type => 'varchar', length => 75 },
28 28 
  department_2        => { type => 'varchar', length => 75 },
29 
  depositor           => { type => 'text' },
29 30 
  direct_debit        => { type => 'boolean', default => 'false' },
30 31 
  discount            => { type => 'float', precision => 4 },
31 32 
  email               => { type => 'text' },
SL/DB/MetaSetup/SepaExportItem.pm
18 18 
  execution_date           => { type => 'date' },
19 19 
  id                       => { type => 'integer', not_null => 1, sequence => 'id' },
20 20 
  our_bic                  => { type => 'varchar', length => 100 },
21 
  our_depositor            => { type => 'text' },
21 22 
  our_iban                 => { type => 'varchar', length => 100 },
22 23 
  reference                => { type => 'varchar', length => 35 },
23 24 
  requested_execution_date => { type => 'date' },
24 25 
  sepa_export_id           => { type => 'integer', not_null => 1 },
25 26 
  vc_bic                   => { type => 'varchar', length => 100 },
27 
  vc_depositor             => { type => 'text' },
26 28 
  vc_iban                  => { type => 'varchar', length => 100 },
27 29 
);
28 30 

  		












  

    
      SL/DB/MetaSetup/Vendor.pm
    
  





  24
  24
  
    
  delivery_term_id => { type => 'integer' },


  		




  25
  25
  
    
  department_1     => { type => 'varchar', length => 75 },


  		




  26
  26
  
    
  department_2     => { type => 'varchar', length => 75 },


  		




  
  27
  
    
  depositor        => { type => 'text' },


  		




  27
  28
  
    
  direct_debit     => { type => 'boolean', default => 'false' },


  		




  28
  29
  
    
  discount         => { type => 'float', precision => 4 },


  		




  29
  30
  
    
  email            => { type => 'text' },


  		












  

    
      sql/Pg-upgrade2/add_depositor_for_customer_vendor.sql
    
  





  
  1
  
    
-- @tag: add_depositor_for_customer_vendor


  		




  
  2
  
    
-- @description: Einführen einer Depositor (Kontoinhaber) Spalte bei Customer bzw. Vendor


  		




  
  3
  
    
-- @depends: sepa


  		




  
  4
  
    

  		




  
  5
  
    
ALTER TABLE customer          ADD depositor     text;


  		




  
  6
  
    
ALTER TABLE vendor            ADD depositor     text;


  		




  
  7
  
    
ALTER TABLE sepa_export_items ADD our_depositor text;


  		




  
  8
  
    
ALTER TABLE sepa_export_items ADD vc_depositor  text;


  		




  
  9
  
    

  		




  
  10
  
    
UPDATE customer SET depositor = name;


  		




  
  11
  
    
UPDATE vendor   SET depositor = name;


  		












Auch abrufbar als:  Unified diff