Revision 72e96428
Von Jan Büren vor etwa 6 Jahren hinzugefügt
| SL/DATEV.pm | ||
|---|---|---|
| 553 | 553 |
UNION ALL |
| 554 | 554 |
|
| 555 | 555 |
SELECT ac.acc_trans_id, ac.transdate, ac.gldate, ac.trans_id,gl.id, ac.amount, ac.taxkey, ac.memo, |
| 556 |
gl.reference AS invnumber, gl.transdate AS duedate, ac.amount as umsatz, NULL as deliverydate, gl.itime::date,
|
|
| 556 |
gl.reference AS invnumber, NULL AS duedate, ac.amount as umsatz, NULL as deliverydate, gl.itime::date,
|
|
| 557 | 557 |
gl.description AS name, NULL as ustid, '' AS vcname, NULL AS customer_id, NULL AS vendor_id, |
| 558 | 558 |
c.accno, c.description AS accname, c.taxkey_id as charttax, c.datevautomatik, c.id, ac.chart_link AS link, |
| 559 | 559 |
FALSE AS invoice, |
Auch abrufbar als: Unified diff
DATEX-Export, kein Fälligkeitsdatum für Dialogbuchungen exportieren