DMEE fetch records for IBAN or Bank account number at the same field

[Former Member]

Hi Experts,

I am doing some development for Singapore Bank's DME where in IBAN number of the EU vendor to be populated.

I know the structure & Field name to be populated.  However, the case is we need to populate IBAN number for EU vendors and Bank acccount number for other vendors.

The business uses same payment method for both scenarios.

Can some one please help me what condition I shall put in order to differentiate the IBAN & Bank account number ?

Regards,

BSK.

[former_member194797 · Accepted solution]

Hi,

The conditions are:

For IBAN:

FPAYH ZIBAN 2 <> SPACE                                1

and of course for bank account:

FPAYH ZIBAN 2 =  SPACE                                1

[Former Member · Accepted solution]

Thank you, Henri.

What if the payment record holds both Account number and IBAN and as if I am required to fetch only Bank Account Number?

Regards - BSK

[former_member194797 · Accepted solution]

This is a little strange, because usually IBAN takes priority over BBAN (basic bank account number).

But if required, you should have conditions in several rows, like

FPAYH ZIBAN 2 <> SPACE                               1   AND

FPAYH ZBNKN 2 = SPACE                                1