Revision 470cd722
Von Sven Schöling vor mehr als 7 Jahren hinzugefügt
SL/DATEV.pm | ||
---|---|---|
384 | 384 |
|
385 | 385 |
my $query = |
386 | 386 |
qq|SELECT ac.acc_trans_id, ac.transdate, ac.trans_id,ar.id, ac.amount, ac.taxkey, ac.memo, |
387 |
ar.invnumber, ar.duedate, ar.amount as umsatz, ar.deliverydate, |
|
387 |
ar.invnumber, ar.duedate, ar.amount as umsatz, ar.deliverydate, ar.itime::date,
|
|
388 | 388 |
ct.name, ct.ustid, ct.customernumber AS vcnumber, ct.id AS customer_id, NULL AS vendor_id, |
389 | 389 |
c.accno, c.description AS accname, c.taxkey_id as charttax, c.datevautomatik, c.id, ac.chart_link AS link, |
390 | 390 |
ar.invoice, |
... | ... | |
406 | 406 |
UNION ALL |
407 | 407 |
|
408 | 408 |
SELECT ac.acc_trans_id, ac.transdate, ac.trans_id,ap.id, ac.amount, ac.taxkey, ac.memo, |
409 |
ap.invnumber, ap.duedate, ap.amount as umsatz, ap.deliverydate, |
|
409 |
ap.invnumber, ap.duedate, ap.amount as umsatz, ap.deliverydate, ap.itime::date,
|
|
410 | 410 |
ct.name, ct.ustid, ct.vendornumber AS vcnumber, NULL AS customer_id, ct.id AS vendor_id, |
411 | 411 |
c.accno, c.description AS accname, c.taxkey_id as charttax, c.datevautomatik, c.id, ac.chart_link AS link, |
412 | 412 |
ap.invoice, |
... | ... | |
428 | 428 |
UNION ALL |
429 | 429 |
|
430 | 430 |
SELECT ac.acc_trans_id, ac.transdate, ac.trans_id,gl.id, ac.amount, ac.taxkey, ac.memo, |
431 |
gl.reference AS invnumber, gl.transdate AS duedate, ac.amount as umsatz, NULL as deliverydate, |
|
431 |
gl.reference AS invnumber, gl.transdate AS duedate, ac.amount as umsatz, NULL as deliverydate, gl.itime::date,
|
|
432 | 432 |
gl.description AS name, NULL as ustid, '' AS vcname, NULL AS customer_id, NULL AS vendor_id, |
433 | 433 |
c.accno, c.description AS accname, c.taxkey_id as charttax, c.datevautomatik, c.id, ac.chart_link AS link, |
434 | 434 |
FALSE AS invoice, |
Auch abrufbar als: Unified diff
GDPDU: itime in Buchungen mit anzeigen