Revision d96ae6f5
Von Jan Büren vor etwa 2 Jahren hinzugefügt
| SL/DB/MetaSetup/BankTransaction.pm | ||
|---|---|---|
|
amount => { type => 'numeric', not_null => 1, precision => 15, scale => 5 },
|
||
|
cleared => { type => 'boolean', default => 'false', not_null => 1 },
|
||
|
currency_id => { type => 'integer', not_null => 1 },
|
||
|
exchangerate => { type => 'numeric', precision => 15, scale => 5 },
|
||
|
id => { type => 'serial', not_null => 1 },
|
||
|
invoice_amount => { type => 'numeric', default => '0', precision => 15, scale => 5 },
|
||
|
itime => { type => 'timestamp', default => 'now()' },
|
||
| SL/DB/MetaSetup/Invoice.pm | ||
|---|---|---|
|
duedate => { type => 'date' },
|
||
|
dunning_config_id => { type => 'integer' },
|
||
|
employee_id => { type => 'integer' },
|
||
|
exchangerate => { type => 'numeric', precision => 15, scale => 5 },
|
||
|
gldate => { type => 'date', default => 'now' },
|
||
|
globalproject_id => { type => 'integer' },
|
||
|
id => { type => 'integer', not_null => 1, sequence => 'glid' },
|
||
| SL/DB/MetaSetup/PurchaseInvoice.pm | ||
|---|---|---|
|
direct_debit => { type => 'boolean', default => 'false' },
|
||
|
duedate => { type => 'date' },
|
||
|
employee_id => { type => 'integer' },
|
||
|
exchangerate => { type => 'numeric', precision => 15, scale => 5 },
|
||
|
gldate => { type => 'date', default => 'now' },
|
||
|
globalproject_id => { type => 'integer' },
|
||
|
id => { type => 'integer', not_null => 1, sequence => 'glid' },
|
||
| sql/Pg-upgrade2/exchangerate_in_arap.sql | ||
|---|---|---|
|
-- @tag: exchangerate_in_arap
|
||
|
-- @description: Wechselkurs optional in Belegen und Banktransaktionen speichern
|
||
|
-- @depends: release_3_6_1
|
||
|
|
||
|
ALTER TABLE ar ADD COLUMN exchangerate NUMERIC(15,5);
|
||
|
ALTER TABLE ap ADD COLUMN exchangerate NUMERIC(15,5);
|
||
|
ALTER TABLE bank_transactions ADD COLUMN exchangerate NUMERIC(15,5);
|
||
Auch abrufbar als: Unified diff
AR,AP und BankTransactions können eigenen Wechselkurs haben