...
| Status |
|---|
| colour | Blue |
|---|
| title | Integrators |
|---|
|
| Status |
|---|
| colour | Green |
|---|
| title | StandUpdated: Jul 2026 |
|---|
|
| Status |
|---|
| colour | Grey |
|---|
| title | gilt fuer applies to Nuclos 4.2026.x |
|---|
|
| Panel |
|---|
|
Auf dieser SeiteOn this page |
| Hinweis |
|---|
| title | 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). |
...
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.
| Codeblock |
|---|
| language | sql |
|---|
| title | DebitorReferences2SEPAExport |
|---|
| linenumbers | true |
|---|
|
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
*/ |
...
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.
| Codeblock |
|---|
| language | sql |
|---|
| title | CreditorReferences2SEPAExport |
|---|
| linenumbers | true |
|---|
|
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
*/ |
...
