Revision 89b26688
Von Sven Schöling vor mehr als 9 Jahren hinzugefügt
| SL/DO.pm | ||
|---|---|---|
| 285 | 285 |
sellprice, discount, unit, reqdate, project_id, serialnumber, |
| 286 | 286 |
ordnumber, transdate, cusordnumber, |
| 287 | 287 |
lastcost, price_factor_id, price_factor, marge_price_factor, pricegroup_id, |
| 288 |
active_price_source) |
|
| 288 |
active_price_source, active_discount_source)
|
|
| 289 | 289 |
VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, |
| 290 |
(SELECT factor FROM price_factors WHERE id = ?), ?, ?, ?)|; |
|
| 290 |
(SELECT factor FROM price_factors WHERE id = ?), ?, ?, ?, ?)|;
|
|
| 291 | 291 |
my $h_item = prepare_query($form, $dbh, $q_item); |
| 292 | 292 |
|
| 293 | 293 |
my $q_item_stock = |
| ... | ... | |
| 343 | 343 |
conv_i($form->{"price_factor_id_$i"}), conv_i($form->{"price_factor_id_$i"}),
|
| 344 | 344 |
conv_i($form->{"marge_price_factor_$i"}),
|
| 345 | 345 |
$pricegroup_id, |
| 346 |
$form->{"active_price_source_$i"});
|
|
| 346 |
$form->{"active_price_source_$i"}, $form->{"active_discount_source_$i"});
|
|
| 347 | 347 |
do_statement($form, $h_item, $q_item, @values); |
| 348 | 348 |
|
| 349 | 349 |
my $stock_info = DO->unpack_stock_information('packed' => $form->{"stock_${in_out}_$i"});
|
| ... | ... | |
| 690 | 690 |
doi.reqdate, doi.project_id, doi.serialnumber, doi.lastcost, |
| 691 | 691 |
doi.ordnumber, doi.transdate, doi.cusordnumber, doi.longdescription, |
| 692 | 692 |
doi.price_factor_id, doi.price_factor, doi.marge_price_factor, doi.pricegroup_id, |
| 693 |
doi.active_price_source, |
|
| 693 |
doi.active_price_source, doi.active_discount_source,
|
|
| 694 | 694 |
pr.projectnumber, dord.transdate AS dord_transdate, dord.donumber, |
| 695 | 695 |
pg.partsgroup |
| 696 | 696 |
FROM delivery_order_items doi |
Auch abrufbar als: Unified diff
PriceSource: Rabattbehandlung