Seitenhistorie
...
| Info | ||
|---|---|---|
| ||
The marking mentioned in point 4 is performed by the DATEV Nuclet by default. This uses the export date ("Export Date DATEV") in the respective reference objects (see the prerequisites in section 3). |
| Codeblock | ||||
|---|---|---|---|---|
| ||||
/**
* Anmerkungen:
*
* - "intid_reference" ist ein Pflichtfeld, das der Zuordnung der Referenzobjekte zum DATEV-Export dient
* - "date_from" und "date_until" sind Pflichtparameter zur Kennzeichnung des zu exportierenden Zeitraumes
* - "datexportdatumdatev" ist das Export-Datum zur Kennzeichnung bereits exportierter Datensätze (s.o.)
*
*/
SELECT
buchungsposition.intid "intid_reference",
buchungsposition.datdatum "Datum",
buchungsposition.strgegenkonto "Gegenkonto",
buchungsposition.strkonto "Konto",
buchungsposition.strbelegfeld "Belegfeld 1",
buchungsposition.dblumsatz "Umsatz",
buchungsposition.strwaehrung "Währung",
buchungsposition.strbuchungstext "Buchungstext"
FROM
em65_buchungsposition buchungsposition
WHERE
buchungsposition.datdatum BETWEEN '$date_from' AND '$date_until'
AND buchungsposition.datexportdatumdatev IS NULL |
...
- The number, order and titles of the columns returned by the SELECT are arbitrary.
- The column titles are displayed by the application as defined in the SQL – but the display behaviour can also be adjusted in the respective layout.
- The mandatory parameters "INTID_T_UD_GENERIC_OBJECT" and "INTID" must be present, as is usual for dynamic business objects (see the section "Dynamic business objects" in der the Nuclos Wiki).
| Info |
|---|
the context menu function "Show details..." is to be used for the references in DATEV exports, then the respective reference business object used must be selected in the dynamic entity. |
...
Überblick
Inhalte