Revision bfeee737
Von Cem Aydin vor etwa 2 Jahren hinzugefügt
| SL/IS.pm | ||
|---|---|---|
| 1516 | 1516 |
globalproject_id = ?, delivery_customer_id = ?, |
| 1517 | 1517 |
transaction_description = ?, delivery_vendor_id = ?, |
| 1518 | 1518 |
donumber = ?, invnumber_for_credit_note = ?, direct_debit = ?, qrbill_without_amount = ?, |
| 1519 |
qr_reference = ?, delivery_term_id = ? |
|
| 1519 |
qr_reference = ?, qr_unstructured_message = ?, delivery_term_id = ?
|
|
| 1520 | 1520 |
WHERE id = ?|; |
| 1521 | 1521 |
@values = ( $form->{"invnumber"}, $form->{"ordnumber"}, $form->{"quonumber"}, $form->{"cusordnumber"},
|
| 1522 | 1522 |
conv_date($form->{"invdate"}), conv_date($form->{"orddate"}), conv_date($form->{"quodate"}), conv_date($form->{tax_point}), conv_i($form->{"customer_id"}),
|
| ... | ... | |
| 1530 | 1530 |
conv_i($form->{"globalproject_id"}), conv_i($form->{"delivery_customer_id"}),
|
| 1531 | 1531 |
$form->{transaction_description}, conv_i($form->{"delivery_vendor_id"}),
|
| 1532 | 1532 |
$form->{"donumber"}, $form->{"invnumber_for_credit_note"}, $form->{direct_debit} ? 't' : 'f', $form->{qrbill_without_amount} ? 't' : 'f',
|
| 1533 |
$qr_reference, conv_i($form->{delivery_term_id}),
|
|
| 1533 |
$qr_reference, $form->{"qr_unstructured_message"}, conv_i($form->{delivery_term_id}),
|
|
| 1534 | 1534 |
conv_i($form->{"id"}));
|
| 1535 | 1535 |
do_query($form, $dbh, $query, @values); |
| 1536 | 1536 |
|
| ... | ... | |
| 2283 | 2283 |
a.mtime, a.itime, |
| 2284 | 2284 |
a.language_id, a.delivery_customer_id, a.delivery_vendor_id, a.type, |
| 2285 | 2285 |
a.transaction_description, a.donumber, a.invnumber_for_credit_note, |
| 2286 |
a.marge_total, a.marge_percent, a.direct_debit, a.qrbill_without_amount, a.qr_reference, a.delivery_term_id, |
|
| 2286 |
a.marge_total, a.marge_percent, a.direct_debit, a.qrbill_without_amount, a.qr_reference, a.qr_unstructured_message, a.delivery_term_id,
|
|
| 2287 | 2287 |
dc.dunning_description, |
| 2288 | 2288 |
e.name AS employee |
| 2289 | 2289 |
FROM ar a |
Auch abrufbar als: Unified diff
Swiss QR-Bill: Unstrukturierte Mitteilung in Rechnung hinzufügen