Revision cc06de5e
Von Niclas Zimmermann vor mehr als 11 Jahren hinzugefügt
| SL/DATEV.pm | ||
|---|---|---|
| 355 | 355 |
qq|SELECT ac.acc_trans_id, ac.transdate, ac.trans_id,ar.id, ac.amount, ac.taxkey, |
| 356 | 356 |
ar.invnumber, ar.duedate, ar.amount as umsatz, |
| 357 | 357 |
ct.name, |
| 358 |
c.accno, c.taxkey_id as charttax, c.datevautomatik, c.id, c.link,
|
|
| 358 |
c.accno, c.taxkey_id as charttax, c.datevautomatik, c.id, ac.chart_link AS link,
|
|
| 359 | 359 |
ar.invoice |
| 360 | 360 |
FROM acc_trans ac |
| 361 | 361 |
LEFT JOIN ar ON (ac.trans_id = ar.id) |
| ... | ... | |
| 370 | 370 |
SELECT ac.acc_trans_id, ac.transdate, ac.trans_id,ap.id, ac.amount, ac.taxkey, |
| 371 | 371 |
ap.invnumber, ap.duedate, ap.amount as umsatz, |
| 372 | 372 |
ct.name, |
| 373 |
c.accno, c.taxkey_id as charttax, c.datevautomatik, c.id, c.link,
|
|
| 373 |
c.accno, c.taxkey_id as charttax, c.datevautomatik, c.id, ac.chart_link AS link,
|
|
| 374 | 374 |
ap.invoice |
| 375 | 375 |
FROM acc_trans ac |
| 376 | 376 |
LEFT JOIN ap ON (ac.trans_id = ap.id) |
| ... | ... | |
| 385 | 385 |
SELECT ac.acc_trans_id, ac.transdate, ac.trans_id,gl.id, ac.amount, ac.taxkey, |
| 386 | 386 |
gl.reference AS invnumber, gl.transdate AS duedate, ac.amount as umsatz, |
| 387 | 387 |
gl.description AS name, |
| 388 |
c.accno, c.taxkey_id as charttax, c.datevautomatik, c.id, c.link,
|
|
| 388 |
c.accno, c.taxkey_id as charttax, c.datevautomatik, c.id, ac.chart_link AS link,
|
|
| 389 | 389 |
FALSE AS invoice |
| 390 | 390 |
FROM acc_trans ac |
| 391 | 391 |
LEFT JOIN gl ON (ac.trans_id = gl.id) |
Auch abrufbar als: Unified diff
chart_link auslesen
Die Spalte chart_link aus der acc_trans wird jetzt auch in der
ausgelesen (im Datev-Export und bei Berichten).