Projekt

Allgemein

Profil

« Zurück | Weiter » 

Revision 14f563b8

Von Jan Büren vor etwa 2 Jahren hinzugefügt

  • ID 14f563b82e441cabd6827bddc55f6aa7fd0b0b64
  • Vorgänger b193b8c3
  • Nachfolger aff556ec

AR,AP und BankTransactions können eigenen Wechselkurs haben

Unterschiede anzeigen:

SL/DB/MetaSetup/BankTransaction.pm
12 12 
  amount                => { type => 'numeric', not_null => 1, precision => 15, scale => 5 },
13 13 
  cleared               => { type => 'boolean', default => 'false', not_null => 1 },
14 14 
  currency_id           => { type => 'integer', not_null => 1 },
15 
  exchangerate          => { type => 'numeric', precision => 15, scale => 5 },
15 16 
  id                    => { type => 'serial', not_null => 1 },
16 17 
  invoice_amount        => { type => 'numeric', default => '0', precision => 15, scale => 5 },
17 18 
  itime                 => { type => 'timestamp', default => 'now()' },
SL/DB/MetaSetup/Invoice.pm
26 26 
  duedate                   => { type => 'date' },
27 27 
  dunning_config_id         => { type => 'integer' },
28 28 
  employee_id               => { type => 'integer' },
29 
  exchangerate              => { type => 'numeric', precision => 15, scale => 5 },
29 30 
  gldate                    => { type => 'date', default => 'now' },
30 31 
  globalproject_id          => { type => 'integer' },
31 32 
  id                        => { type => 'integer', not_null => 1, sequence => 'glid' },
SL/DB/MetaSetup/PurchaseInvoice.pm
19 19 
  direct_debit            => { type => 'boolean', default => 'false' },
20 20 
  duedate                 => { type => 'date' },
21 21 
  employee_id             => { type => 'integer' },
22 
  exchangerate            => { type => 'numeric', precision => 15, scale => 5 },
22 23 
  gldate                  => { type => 'date', default => 'now' },
23 24 
  globalproject_id        => { type => 'integer' },
24 25 
  id                      => { type => 'integer', not_null => 1, sequence => 'glid' },
sql/Pg-upgrade2/exchangerate_in_arap.sql
1 
-- @tag: exchangerate_in_arap
2 
-- @description: Wechselkurs optional in Belegen und Banktransaktionen speichern
3 
-- @depends: release_3_6_1
4 

  		




  
  5
  
    
ALTER TABLE ar                ADD COLUMN exchangerate NUMERIC(15,5);


  		




  
  6
  
    
ALTER TABLE ap                ADD COLUMN exchangerate NUMERIC(15,5);


  		




  
  7
  
    
ALTER TABLE bank_transactions ADD COLUMN exchangerate NUMERIC(15,5);


  		












Auch abrufbar als:  Unified diff