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