SEPA Nuclet update v1.2 to v2.0: reference attribute split, SEPA Export File business object and SQL data migrations.

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).

The following changes and extensions must be observed on an update:

1. In version 2.0.0 the general reference attribute is replaced by the dedicated attributes "Creditor Reference" (for credit transfers) and "Debitor Reference" (for direct debits) (as described under prerequisites). The original attribute "Reference" is retained for now, but is obsolete and will be dropped in one of the future versions of the SEPA Nuclet; expected with version 2.2.0.
2. In addition, the export files are stored in an additional business object ("SEPA Export File"). Up to now these files were held directly in the "SEPA Export".

Data migrations must be carried out for both changes if SEPA exports have already been performed in your system.

If you have been using an older version of the SEPA Nuclet in your application and an update to version 2.0.0 is pending, please observe the notes listed here.

-- Anmerkung: "abcd_" steht für das tatsächliche Tabellenpräfix der Tabelle.
-- Es entspricht dem Wert "Lokaler Identifizierer" im Nuclet-Managment des SEPA-Nuclets.
--
-- Bitte führen Sie diese Anweisungen erst nach dem Import des SEPA-Nuclets v2.0.0 und den durchgeführten Objektimporten durch.

UPDATE abcd_sepaexport SET intid_strordertype = (SELECT intid FROM abcd_sepaordertype WHERE strkey = 'DIRECT_DEBIT_INITIATION');
UPDATE abcd_sepaexport SET struid_nuclosprocess = (SELECT struid_strprocess FROM abcd_sepaordertype WHERE strkey = 'DIRECT_DEBIT_INITIATION');

-- Anmerkung: "abcd_" steht für das tatsächliche Tabellenpräfix der Tabelle.
-- Es entspricht dem Wert "Lokaler Identifizierer" im Nuclet-Managment des SEPA-Nuclets.
--
-- Bitte führen Sie diese Anweisung erst nach dem Import des SEPA-Nuclets v2.0.0 durch.

UPDATE abcd_sepatransaction SET intid_strdebitorreference = intid_strreference;

-- Anmerkung: "abcd_" steht für das tatsächliche Tabellenpräfix der Tabelle.
-- Es entspricht dem Wert "Lokaler Identifizierer" im Nuclet-Managment des SEPA-Nuclets.
--
-- Bitte führen Sie diese Anweisung direkt nach dem Import des SEPA-Nuclets v2.0.0 durch.

INSERT INTO abcd_sepaexportfile (intid, strfilepath, strfile, intid_strordertype, intid_strsequencetype, strpaymentinformationid, 
    strmessageid, intid_strsepaexport, strnote, strmessageidnumber, datchanged, strchanged, datcreated, strcreated, intversion)
SELECT
    nextval('idfactory'), strfilepath, strfile, intid_strordertype, null as "intid_strsequencetype", strpaymentinformationid, 
    strmessageid, intid, '' as "strnote", strmessageidnumber, 
    datchanged, strchanged, datcreated, strcreated, 0 as "intversion"
FROM
    abcd_sepaexport;