Projekt

Allgemein

Profil

« Zurück | Weiter » 

Revision 33db5e13

Von Tamino Steinert vor fast 2 Jahren hinzugefügt

  • ID 33db5e132188e12d8d58ea67ccd05b31c60aea1a
  • Vorgänger 96f6aa8d
  • Nachfolger 5fe86fc4

InvoiceItem: um Datenbankfeld für Warenbuchungsmethode erweitert

Unterschiede anzeigen:

SL/DB/MetaSetup/InvoiceItem.pm
41 41 
  sellprice              => { type => 'numeric', precision => 15, scale => 5 },
42 42 
  serialnumber           => { type => 'text' },
43 43 
  subtotal               => { type => 'boolean', default => 'false' },
44 
  tax_chart_type         => { type => 'varchar', length => 20 },
44 45 
  tax_id                 => { type => 'integer' },
45 46 
  trans_id               => { type => 'integer' },
46 47 
  transdate              => { type => 'text' },
SL/IR.pm
451 451 
                           project_id = ?, serialnumber = ?, price_factor_id = ?,
452 452 
                           price_factor = (SELECT factor FROM price_factors WHERE id = ?), marge_price_factor = ?,
453 453 
                           active_price_source = ?, active_discount_source = ?
454 
                           ,expense_chart_id = ?, tax_id = ?, inventory_chart_id = ?
454 
                           ,expense_chart_id = ?, inventory_chart_id = ?, tax_id = ?, tax_chart_type = ?
455 455 
        WHERE id = ?
456 456 
SQL
457 457 

  		




  ......




  462
  462
  
    
               conv_i($form->{"project_id_$i"}), $form->{"serialnumber_$i"},


  		




  463
  463
  
    
               conv_i($form->{"price_factor_id_$i"}), conv_i($form->{"price_factor_id_$i"}), conv_i($form->{"marge_price_factor_$i"}),


  		




  464
  464
  
    
               $form->{"active_price_source_$i"}, $form->{"active_discount_source_$i"},


  		




  465
  
  
    
               $form->{"expense_chart_id_$i"}, $form->{"tax_id_$i"}, $form->{"inventory_chart_id_$i"},


  		




  
  465
  
    
               $form->{"expense_chart_id_$i"}, $form->{"inventory_chart_id_$i"}, $form->{"tax_id_$i"}, $form->{"tax_chart_type_$i"},


  		




  466
  466
  
    
               conv_i($form->{"invoice_id_$i"}));


  		




  467
  467
  
    
    do_query($form, $dbh, $query, @values);


  		




  468
  468
  
    
    push @processed_invoice_ids, $form->{"invoice_id_$i"};


  		




  ......




  1090
  1090
  
    
        i.price_factor_id, i.price_factor, i.marge_price_factor, i.discount, i.active_price_source, i.active_discount_source,


  		




  1091
  1091
  
    
        p.partnumber, p.part_type, pr.projectnumber, pg.partsgroup


  		




  1092
  1092
  
    
        ,p.classification_id


  		




  1093
  
  
    
        ,i.expense_chart_id, i.tax_id, i.inventory_chart_id


  		




  
  1093
  
    
        ,i.expense_chart_id, i.inventory_chart_id, i.tax_id, i.tax_chart_type


  		




  1094
  1094
  
    

  		




  1095
  1095
  
    
        FROM invoice i


  		




  1096
  1096
  
    
        JOIN parts p ON (i.parts_id = p.id)


  		












  

    
      sql/Pg-upgrade2/add_tax_chart_type_to_invoice_items.sql
    
  





  
  1
  
    
-- @tag: add_tax_chart_type_to_invoice_items


  		




  
  2
  
    
-- @description: Auswahl von Warenbuchungsmethode pro Einkaufrechnungszeile


  		




  
  3
  
    
-- @depends: release_3_7_0


  		




  
  4
  
    

  		




  
  5
  
    
ALTER TABLE invoice ADD COLUMN tax_chart_type VARCHAR(20);


  		












Auch abrufbar als:  Unified diff