Revision 4b8e5682
Von Tamino Steinert vor mehr als 2 Jahren hinzugefügt
- ID 4b8e56821eac8b83856dca20e2ca8371081c13f5
- Vorgänger 72b80f91
| SL/IR.pm | ||
|---|---|---|
|
my $query =
|
||
|
qq|SELECT
|
||
|
p.id, p.partnumber, p.description, p.lastcost AS sellprice, p.listprice,
|
||
|
p.unit, p.part_type, p.onhand, p.formel,
|
||
|
p.unit, p.part_type, stocks.onhand, p.formel,
|
||
|
p.notes AS partnotes, p.notes AS longdescription, p.not_discountable,
|
||
|
p.price_factor_id,
|
||
|
p.ean,
|
||
| ... | ... | |
|
pg.partsgroup
|
||
|
|
||
|
FROM parts p
|
||
|
LEFT JOIN stocks ON (stocks.part_id = p.id)
|
||
|
LEFT JOIN chart c1 ON
|
||
|
((SELECT inventory_accno_id
|
||
|
FROM buchungsgruppen
|
||
Auch abrufbar als: Unified diff
Separate Tabelle für onhand (stocks) für Artikel