Revision 89b26688
Von Sven Schöling vor mehr als 9 Jahren hinzugefügt
SL/IS.pm | ||
---|---|---|
761 | 761 |
sellprice, fxsellprice, discount, allocated, assemblyitem, |
762 | 762 |
unit, deliverydate, project_id, serialnumber, pricegroup_id, |
763 | 763 |
ordnumber, donumber, transdate, cusordnumber, base_qty, subtotal, |
764 |
marge_percent, marge_total, lastcost, active_price_source, |
|
764 |
marge_percent, marge_total, lastcost, active_price_source, active_discount_source, |
|
765 |
|
|
765 | 766 |
price_factor_id, price_factor, marge_price_factor) |
766 |
VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, |
|
767 |
VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
|
|
767 | 768 |
(SELECT factor FROM price_factors WHERE id = ?), ?)|; |
768 | 769 |
|
769 | 770 |
@values = ($invoice_id, conv_i($form->{id}), conv_i($form->{"id_$i"}), |
... | ... | |
776 | 777 |
$form->{"cusordnumber_$i"}, $baseqty, $form->{"subtotal_$i"} ? 't' : 'f', |
777 | 778 |
$form->{"marge_percent_$i"}, $form->{"marge_absolut_$i"}, |
778 | 779 |
$form->{"lastcost_$i"}, |
779 |
$form->{"active_price_source_$i"}, |
|
780 |
$form->{"active_price_source_$i"}, $form->{"active_discount_source_$i"},
|
|
780 | 781 |
conv_i($form->{"price_factor_id_$i"}), conv_i($form->{"price_factor_id_$i"}), |
781 | 782 |
conv_i($form->{"marge_price_factor_$i"})); |
782 | 783 |
do_query($form, $dbh, $query, @values); |
... | ... | |
1678 | 1679 |
i.id AS invoice_id, |
1679 | 1680 |
i.description, i.longdescription, i.qty, i.fxsellprice AS sellprice, i.discount, i.parts_id AS id, i.unit, i.deliverydate AS reqdate, |
1680 | 1681 |
i.project_id, i.serialnumber, i.id AS invoice_pos, i.pricegroup_id, i.ordnumber, i.donumber, i.transdate, i.cusordnumber, i.subtotal, i.lastcost, |
1681 |
i.price_factor_id, i.price_factor, i.marge_price_factor, i.active_price_source, |
|
1682 |
i.price_factor_id, i.price_factor, i.marge_price_factor, i.active_price_source, i.active_discount_source,
|
|
1682 | 1683 |
p.partnumber, p.assembly, p.notes AS partnotes, p.inventory_accno_id AS part_inventory_accno_id, p.formel, p.listprice, |
1683 | 1684 |
pr.projectnumber, pg.partsgroup, prg.pricegroup |
1684 | 1685 |
|
Auch abrufbar als: Unified diff
PriceSource: Rabattbehandlung