SEPA-Nuclet – 4.5 SEPA: Datenquellen: (bis Version 1.2.0: "References2SepaExport")

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    
*/

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 
*/