Electronic Reporting Iso20022 (DK) Where does data come from.

(0) Share

Report

Posted on by JacobBF

Hi All.

I am trying to do a vendor payment for the Danish bank Nordea. For that they want the Header to include two specific info, the SignerID, and the Cust info.

"<GrpHdr>5
<MsgId>100789</MsgId>
<CreDtTm>2015-11-30T14:56:33</CreDtTm>
<NbOfTxs>1</NbOfTxs>
<InitgPty><Id><OrgId><Othr>
<Id>SIGNERID</Id><SchmeNm><Cd>CUST</Cd></SchmeNm>
</Othr></OrgId></Id>
</InitgPty>
</GrpHdr>"

When I create the file, the SignerId is filled with data from the field: company ID under the Bank account used for this payment.

But I'm missing the Cust field. This is filled with the word "bank" which I do not know where it picks it from. This field should contain either Data I got from the Bank (Nordea), but I don't know where to place it, for it to be picked to the report.

"<GrpHdr>
<MsgId>SERW-000004-20210907045624</MsgId>
<CreDtTm>2021-09-07T04:56:24</CreDtTm>
<NbOfTxs>1</NbOfTxs>
<InitgPty>
<Nm>Serwiz Aps</Nm>
<Id>
<OrgId>
<Othr>
<Id>----------</Id>
<SchmeNm>
<Cd>BANK</Cd>
</SchmeNm>
</Othr>
</OrgId>"

Hope someone can help me because I have used a couple of days trying to understand ER (Electronic Reporting), but the documentation from MS is Lacking info on how to understand their own encoding.

regards

Jacob

I have the same question (0)

All responses (10)

Answers (4)

Verified answer

Alireza Eshaghzadeh 14,684 Super User 2025 Season 2 on at

Like (0)

Report

Hi Jacob,

You need to create a derive config from "ISO20022 Credit transfer (DK) and then you can edit the mapping for

-ISO20022CTReports/XMLHeader/Document/CstmrCdtTrfInitn/GrpHdr/InitgPty/Id/OrgId/Othr/Id : map to the field that you have defined your Signer ID for Nordea . e.g. Company ID or Division on the bank account

-ISO20022CTReports/XMLHeader/Document/CstmrCdtTrfInitn/GrpHdr/InitgPty/Id/OrgId/Othr/SchmeNm/Cd - Here you can use a fixed value as "CUST" .

Hope it helps,

Regards,

Alireza

Was this reply helpful? Yes No
JacobBF 35 on at

Like (0)

Report

Hi Alireza.

When using the standard file, it print the Bank in the field. But how can i see if this is a fixed value or maybe even see where it comes from in FO?

regards

Jacob

Was this reply helpful? Yes No
Verified answer

Alireza Eshaghzadeh 14,684 Super User 2025 Season 2 on at

Like (1)

Report

Hi Jacob,

Ref. to previous screenshot, ISO20022CTReports/XMLHeader/Document/CstmrCdtTrfInitn/GrpHdr/InitgPty/Id/OrgId/Othr/SchmeNm/Cd is mapped to "'$PaymentByDebtor'.'$FirstPaymentInGroup'.InitiatingParty.Identification.'$identification'.Scheme.Code"

In order to find this, first choose "Mapping" on the right ribbon and then on the spesific node click on "Edit formula" (if it already have mapping):

Regards,

Alireza

Was this reply helpful? Yes No
JacobBF 35 on at

Like (0)

Report

Hi Alireza.

That far I also got. Found the path etc. but the question is where the "Scheme.Code" picks up data from. This I can't figure out.

I can see the path in both the left tree structure and in the right one, but still the Scheme.Code, does not mention a valid field i can regonize from FO.

An example is also the ID, which i also boxed in below picture. This gives me a value from the bank settings. But the Scheme.code, I don't know where comes from.

regards

Jacob

Was this reply helpful? Yes No
Verified answer

Alireza Eshaghzadeh 14,684 Super User 2025 Season 2 on at

Like (1)

Report

Hi again Jacobe,

You can find this mapping information from model mapping (i.e. Payment model mapping 1611)

When you check $scheme id for Company Id (DK), it shows the following formula which value will be used:

The previous provided screenshot indicate that SchmeNm > Cd > String is mapped to @.Scheme.Code. As it is already mentioned, you can modify this field and possibly use fast value in regards with specs from the Nordea Bank.

Regards,

Alireza

Was this reply helpful? Yes No
JacobBF 35 on at

Like (0)

Report

Uhh how i would wish i understood how you got to that point in where you could see the $scheme.. I am not able to see it.

Was this reply helpful? Yes No
Verified answer

Alireza Eshaghzadeh 14,684 Super User 2025 Season 2 on at

Like (1)

Report

Hi Jacob,

You need to find the model mapping which is back this element for this format. In this case, it is "CustomerCreditTransferInitiation" on Payment model mapping 1611.

Please find the following link from Microsoft docs for ER Config:

docs.microsoft.com/.../general-electronic-reporting

Regards,

Alireza Eshaghzadeh| Business Consultant | My blog

Please mark this thread as verified if the answer is helpful.

Was this reply helpful? Yes No
JacobBF 35 on at

Like (0)

Report

Alireza Eshaghzadeh Thanks for your help, it helped me a lot to understand the Electronic Documents for ISO20022 vendor payment files.

I got it all set up and now they are working fine for the customer, and I took the knowledge and have continued on several other companies to set this up now.

Thanks again for your big help.

Was this reply helpful? Yes No
Karollll 15 on at

Like (0)

Report

Hello Jacob,
Is it working for vendor payments for Nordea Danmark?

Thank you.

Was this reply helpful? Yes No
johnny@365freelance... 23 on at

Like (0)

Report

Hi Jacob

Did you manage to setup and create a ISO20022 (DK) vendor payment file including 1 FIK payment, 1 bank transfer payment & 1 IBAN foreign payment? And if so can buy some time from you?

Regards,

Johnny

Was this reply helpful? Yes No