PayRef ( reference )

European (structured) payment reference

Average rating: 4.4 (30 votes) Log in to vote

Michael Bijnens
freelance developer
/

Sample input:

PayRef ( 20130001 )

Sample output:

+++002/0130/00176+++

Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

/* ============================================
#
# Purpose:			create a valid structured payment reference of given reference
#
# Arthor:				Michael Bijnens
# Creation date:		01/01/2014
#
# Note:				this function is only applicable for EU payments!
#
=============================================*/

Let ( 
	[
		ref = Right ( "0000000000" & reference ; 10 ) ;
		mod = Mod ( ref ; 97 ) ;
		m = 
			Case ( 
				mod = 0 ;
				97 ; 
				GetAsText ( Right ( "0" & mod ; 2) ) 
			) ;
		additive = "+++"
	] ;

		/* eg.  +++123/4567/890+++
		----------------------------- */
		additive & Left ( ref ; 3 ) & "/" & Middle ( ref ; 4 ; 4 ) & "/" & Right ( ref ; 3 ) & m & additive

)

Michael Bijnens - Junior FileMaker Analyst / Programmer
-------------------------

This CF can only be used by European payment transfers !!!

I use this function for invoices or orders.

What do you need ?

1) A number field "number" with a generated number ( year & serial.. or something else )
2) A text field "payref" with auto calculation ( PayRef ( number ) ).

Comments

		comment, VR Nov 26, 2013
What exactly is a "European payment transfer"? I cannot find any online resources mentioning it. AFAIK, modulo-97 check digits are generated as follows: SerialIncrement ( "00" ; 98 - Mod ( input ; 97 ) ) See, for example: http://en.wikipedia.org/wiki/International_Bank_Account_Number#Generating_IBAN_check_digits In your example using 20130001 as the input, the check digits would be calculated as "22" instead of "76".

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

PayRef ( reference )

Comments

Support this website.

Support this website.