Revision 89b26688
Von Sven Schöling vor mehr als 9 Jahren hinzugefügt
| SL/OE.pm | ||
|---|---|---|
| 532 | 532 |
sellprice = ?, discount = ?, unit = ?, reqdate = ?, project_id = ?, serialnumber = ?, ship = ?, |
| 533 | 533 |
pricegroup_id = ?, ordnumber = ?, transdate = ?, cusordnumber = ?, subtotal = ?, |
| 534 | 534 |
marge_percent = ?, marge_total = ?, lastcost = ?, price_factor_id = ?, |
| 535 |
active_price_source = ?, |
|
| 535 |
active_price_source = ?, active_discount_source = ?,
|
|
| 536 | 536 |
price_factor = (SELECT factor FROM price_factors WHERE id = ?), marge_price_factor = ? |
| 537 | 537 |
WHERE id = ? |
| 538 | 538 |
SQL |
| ... | ... | |
| 547 | 547 |
$form->{"cusordnumber_$i"}, $form->{"subtotal_$i"} ? 't' : 'f',
|
| 548 | 548 |
$form->{"marge_percent_$i"}, $form->{"marge_absolut_$i"},
|
| 549 | 549 |
$form->{"lastcost_$i"},
|
| 550 |
$form->{"active_price_source_$i"},
|
|
| 550 |
$form->{"active_price_source_$i"}, $form->{"active_discount_source_$i"},
|
|
| 551 | 551 |
conv_i($form->{"price_factor_id_$i"}), conv_i($form->{"price_factor_id_$i"}),
|
| 552 | 552 |
conv_i($form->{"marge_price_factor_$i"}),
|
| 553 | 553 |
conv_i($orderitems_id), |
| ... | ... | |
| 947 | 947 |
o.sellprice, o.parts_id AS id, o.unit, o.discount, p.notes AS partnotes, p.inventory_accno_id AS part_inventory_accno_id, |
| 948 | 948 |
o.reqdate, o.project_id, o.serialnumber, o.ship, o.lastcost, |
| 949 | 949 |
o.ordnumber, o.transdate, o.cusordnumber, o.subtotal, o.longdescription, |
| 950 |
o.price_factor_id, o.price_factor, o.marge_price_factor, o.active_price_source, |
|
| 950 |
o.price_factor_id, o.price_factor, o.marge_price_factor, o.active_price_source, o.active_discount_source,
|
|
| 951 | 951 |
pr.projectnumber, p.formel, |
| 952 | 952 |
pg.partsgroup, o.pricegroup_id, (SELECT pricegroup FROM pricegroup WHERE id=o.pricegroup_id) as pricegroup |
| 953 | 953 |
FROM orderitems o |
Auch abrufbar als: Unified diff
PriceSource: Rabattbehandlung