Language: Deutsch · English

4.5 SEPA: Data sources

Adapt the dynamic business objects that display the records contained in a SEPA export in the user interface.

HOW-TO INTEGRATORS STAND: JUL 2026 GILT FUER NUCLOS 4.2026.X

Auf dieser Seite

Machine-translated – under review

This page was machine-translated from German as a first draft and is currently under review. The authoritative source remains the German original (see the language switch above).

4.5.1 Dynamic business object "DebitorReferences2SepaExport"

(up to version 1.2.0: "References2SepaExport")

The dynamic business object "DebitorReferences2SEPAExport" is used to display the records contained in an export in the user interface (i.e. in the detail view of the SEPA export for direct debits).

If you want this functionality, please adapt the template to your application purposes. The idea behind it is to be able to display, in a given SEPA export, all payment references bound to that export via the SEPA payment information.

An example of such an adaptation is given – commented out – in the SQL code. General information on creating dynamic entities can be found in the Nuclos wiki.

DebitorReferences2SEPAExport

SELECT 
    0 AS INTID,
    0 AS INTID_T_UD_GENERICOBJECT,
    true AS "Offen?",
    to_date('01.01.2014', 'dd.mm.yyyy') AS "Fälligkeitsdatum",
    'NO-12345' AS "Rechnung",
    0.0 AS "Betrag",
    null AS "Exportdatum SEPA"
/**
 * replace!
 *
 * Bitte ersetzen Sie dieses Beispiel mit einem anwendungspezifischen SQL-Statement.
 *
 *
SELECT 
    clientBillingPosition.intid AS INTID,
    clientBillingPosition.intid_strsepatransaction AS INTID_T_UD_GENERICOBJECT,
    clientBillingPosition.blnisopen AS "Offen?",
    clientBillingPosition.datduedate AS "Fälligkeitsdatum",
    clientBilling.strbillingnumber AS "Rechnung",
    clientBillingPosition.dblamount AS "Betrag",
    clientBillingPosition.datsepaexportdate AS "Exportdatum SEPA"
FROM
    t_eo_clientbillingposition clientBillingPosition,
    t_eo_clientbilling clientBilling
WHERE
    clientBillingPosition.intid_strclientbilling = clienBilling.intid    
*/

4.5.2 Dynamic business object "CreditorReferences2SepaExport"

Analogously to 4.5.1, the dynamic business object "CreditorReferences2SEPAExport" is used to display the records contained in an export in the user interface (i.e. in the detail view of the SEPA export for credit transfers).

If you want this functionality, please adapt the template to your application purposes. The idea behind it is to be able to display, in a given SEPA export, all payment references bound to that export via the SEPA payment information.

An example of such an adaptation is given – commented out – in the SQL code. General information on creating dynamic entities can be found in the Nuclos wiki.

CreditorReferences2SEPAExport

SELECT 
 0 AS INTID,
 0 AS INTID_T_UD_GENERICOBJECT,
 true AS "Offen?",
 to_date('01.01.2014', 'dd.mm.yyyy') AS "Fälligkeitsdatum",
 'NO-12345' AS "Eingangsrechnung",
 0.0 AS "Betrag",
 null AS "Exportdatum SEPA"
/**
 * replace!
 *
 * Bitte ersetzen Sie dieses Beispiel mit einem anwendungspezifischen SQL-Statement.
 *
 *
SELECT 
 supplierBillingPosition.intid AS INTID,
 supplierBillingPosition.intid_strsepatransaction AS INTID_T_UD_GENERICOBJECT,
 supplierBillingPosition.blnisopen AS "Offen?",
 supplierBillingPosition.datduedate AS "Fälligkeitsdatum",
 supplierBilling.strbillingnumber AS "Rechnung",
 supplierBillingPosition.dblamount AS "Betrag",
 supplierBillingPosition.datsepaexportdate AS "Exportdatum SEPA"
FROM
 t_eo_supplierbillingposition supplierBillingPosition,
 t_eo_supplierbilling supplierBilling
WHERE
 supplierBillingPosition.intid_strsupplierbilling = supplierBilling.intid 
*/