SEPA Nuclet data sources: dynamic business objects (Debitor/Creditor References to SEPA export) with example SQL. |
Language: Deutsch · English
Adapt the dynamic business objects that display the records contained in a SEPA export in the user interface.
Auf dieser Seite |
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). |
(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.
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
*/ |
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.
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
*/ |