Revision d96ae6f5
Von Jan Büren vor fast 2 Jahren hinzugefügt
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
AR,AP und BankTransactions können eigenen Wechselkurs haben