Revision 030c2086
Von Rolf Fluehmann vor fast 9 Jahren hinzugefügt
| SL/Form.pm | ||
|---|---|---|
|
d.closedto, d.revtrans,
|
||
|
(SELECT cu.name FROM currencies cu WHERE cu.id=d.currency_id) AS defaultcurrency,
|
||
|
(SELECT c.accno FROM chart c WHERE d.fxgain_accno_id = c.id) AS fxgain_accno,
|
||
|
(SELECT c.accno FROM chart c WHERE d.fxloss_accno_id = c.id) AS fxloss_accno
|
||
|
(SELECT c.accno FROM chart c WHERE d.fxloss_accno_id = c.id) AS fxloss_accno,
|
||
|
(SELECT c.accno FROM chart c WHERE d.rndgain_accno_id = c.id) AS rndgain_accno,
|
||
|
(SELECT c.accno FROM chart c WHERE d.rndloss_accno_id = c.id) AS rndloss_accno
|
||
|
FROM defaults d|;
|
||
|
$ref = selectfirst_hashref_query($self, $dbh, $query);
|
||
|
map { $self->{$_} = $ref->{$_} } keys %$ref;
|
||
| ... | ... | |
|
current_date AS transdate, d.closedto, d.revtrans,
|
||
|
(SELECT cu.name FROM currencies cu WHERE cu.id=d.currency_id) AS defaultcurrency,
|
||
|
(SELECT c.accno FROM chart c WHERE d.fxgain_accno_id = c.id) AS fxgain_accno,
|
||
|
(SELECT c.accno FROM chart c WHERE d.fxloss_accno_id = c.id) AS fxloss_accno
|
||
|
(SELECT c.accno FROM chart c WHERE d.fxloss_accno_id = c.id) AS fxloss_accno,
|
||
|
(SELECT c.accno FROM chart c WHERE d.rndgain_accno_id = c.id) AS rndgain_accno,
|
||
|
(SELECT c.accno FROM chart c WHERE d.rndloss_accno_id = c.id) AS rndloss_accno
|
||
|
FROM defaults d|;
|
||
|
$ref = selectfirst_hashref_query($self, $dbh, $query);
|
||
|
map { $self->{$_} = $ref->{$_} } keys %$ref;
|
||
Auch abrufbar als: Unified diff
Belege runden, und Rundungsdifferenzen auf Extrakonten buchen.