Revision fcde4c20
Von Kivitendo Admin vor etwa 8 Jahren hinzugefügt
SL/IS.pm | ||
---|---|---|
1656 | 1656 |
my ($dbh, $myconfig, $form, $position, $id, $totalqty) = @_; |
1657 | 1657 |
|
1658 | 1658 |
my $query = |
1659 |
qq|SELECT a.parts_id, a.qty, p.assembly, p.partnumber, p.description, p.unit,
|
|
1659 |
qq|SELECT a.parts_id, a.qty, p.part_type, p.partnumber, p.description, p.unit,
|
|
1660 | 1660 |
p.inventory_accno_id, p.income_accno_id, p.expense_accno_id |
1661 | 1661 |
FROM assembly a |
1662 | 1662 |
JOIN parts p ON (a.parts_id = p.id) |
... | ... | |
1797 | 1797 |
|
1798 | 1798 |
# reverse inventory items |
1799 | 1799 |
my $query = |
1800 |
qq|SELECT i.id, i.parts_id, i.qty, i.assemblyitem, p.assembly, p.inventory_accno_id
|
|
1800 |
qq|SELECT i.id, i.parts_id, i.qty, i.assemblyitem, p.part_type, p.inventory_accno_id
|
|
1801 | 1801 |
FROM invoice i |
1802 | 1802 |
JOIN parts p ON (i.parts_id = p.id) |
1803 | 1803 |
WHERE i.trans_id = ?|; |
... | ... | |
2003 | 2003 |
i.description, i.longdescription, i.qty, i.fxsellprice AS sellprice, i.discount, i.parts_id AS id, i.unit, i.deliverydate AS reqdate, |
2004 | 2004 |
i.project_id, i.serialnumber, i.pricegroup_id, i.ordnumber, i.donumber, i.transdate, i.cusordnumber, i.subtotal, i.lastcost, |
2005 | 2005 |
i.price_factor_id, i.price_factor, i.marge_price_factor, i.active_price_source, i.active_discount_source, |
2006 |
p.partnumber, p.assembly, p.notes AS partnotes, p.inventory_accno_id AS part_inventory_accno_id, p.formel, p.listprice,
|
|
2006 |
p.partnumber, p.part_type, p.notes AS partnotes, p.inventory_accno_id AS part_inventory_accno_id, p.formel, p.listprice,
|
|
2007 | 2007 |
pr.projectnumber, pg.partsgroup, prg.pricegroup |
2008 | 2008 |
|
2009 | 2009 |
FROM invoice i |
... | ... | |
2314 | 2314 |
c3.new_chart_id AS expense_new_chart, |
2315 | 2315 |
date($transdate) - c3.valid_from AS expense_valid, |
2316 | 2316 |
|
2317 |
p.unit, p.assembly, p.onhand,
|
|
2317 |
p.unit, p.part_type, p.onhand,
|
|
2318 | 2318 |
p.notes AS partnotes, p.notes AS longdescription, |
2319 | 2319 |
p.not_discountable, p.formel, p.payment_id AS part_payment_id, |
2320 | 2320 |
p.price_factor_id, p.weight, |
Auch abrufbar als: Unified diff
Ware/Erzeugnis/Dienstleistung per parts.part_type unterscheiden 2
kivitendo Code angepasst.