Revision 4b8e5682
Von Tamino Steinert vor mehr als 1 Jahr hinzugefügt
- ID 4b8e56821eac8b83856dca20e2ca8371081c13f5
- Vorgänger 72b80f91
| SL/IS.pm | ||
|---|---|---|
| 2630 | 2630 |
c3.new_chart_id AS expense_new_chart, |
| 2631 | 2631 |
date($transdate) - c3.valid_from AS expense_valid, |
| 2632 | 2632 |
|
| 2633 |
p.unit, p.part_type, p.onhand,
|
|
| 2633 |
p.unit, p.part_type, stocks.onhand,
|
|
| 2634 | 2634 |
p.notes AS partnotes, p.notes AS longdescription, |
| 2635 | 2635 |
p.not_discountable, p.formel, p.payment_id AS part_payment_id, |
| 2636 | 2636 |
p.price_factor_id, p.weight, |
| ... | ... | |
| 2640 | 2640 |
pg.partsgroup |
| 2641 | 2641 |
|
| 2642 | 2642 |
FROM parts p |
| 2643 |
LEFT JOIN stocks ON (stocks.part_id = p.id) |
|
| 2643 | 2644 |
LEFT JOIN chart c1 ON |
| 2644 | 2645 |
((SELECT inventory_accno_id |
| 2645 | 2646 |
FROM buchungsgruppen |
Auch abrufbar als: Unified diff
Separate Tabelle für onhand (stocks) für Artikel