Revision 7eae8fac
Von Moritz Bunkus vor fast 18 Jahren hinzugefügt
| SL/IS.pm | ||
|---|---|---|
|
|
||
|
$query =
|
||
|
qq|SELECT
|
||
|
(SELECT c.accno FROM chart c
|
||
|
WHERE d.inventory_accno_id = c.id) AS inventory_accno,
|
||
|
(SELECT c.accno FROM chart c
|
||
|
WHERE d.income_accno_id = c.id) AS income_accno,
|
||
|
(SELECT c.accno FROM chart c
|
||
|
WHERE d.expense_accno_id = c.id) AS expense_accno,
|
||
|
(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.inventory_accno_id = c.id) AS inventory_accno,
|
||
|
(SELECT c.accno FROM chart c WHERE d.income_accno_id = c.id) AS income_accno,
|
||
|
(SELECT c.accno FROM chart c WHERE d.expense_accno_id = c.id) AS expense_accno,
|
||
|
(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,
|
||
|
d.curr AS currencies
|
||
|
${query_transdate}
|
||
|
FROM defaults d|;
|
||
Auch abrufbar als: Unified diff
Kosmetik.