Revision 72528ede
Von Tamino Steinert vor mehr als 2 Jahren hinzugefügt
- ID 72528edece18f8ac73ff702e83050c674db69b38
- Vorgänger 72b80f91
| SL/IS.pm | ||
|---|---|---|
|
c3.new_chart_id AS expense_new_chart,
|
||
|
date($transdate) - c3.valid_from AS expense_valid,
|
||
|
|
||
|
p.unit, p.part_type, p.onhand,
|
||
|
p.unit, p.part_type, onhands.onhand,
|
||
|
p.notes AS partnotes, p.notes AS longdescription,
|
||
|
p.not_discountable, p.formel, p.payment_id AS part_payment_id,
|
||
|
p.price_factor_id, p.weight,
|
||
| ... | ... | |
|
pg.partsgroup
|
||
|
|
||
|
FROM parts p
|
||
|
LEFT JOIN onhands ON (onhands.parts_id = p.id)
|
||
|
LEFT JOIN chart c1 ON
|
||
|
((SELECT inventory_accno_id
|
||
|
FROM buchungsgruppen
|
||
Auch abrufbar als: Unified diff
Separate Tabelle für onhand (onhands) für Artikel