PayRef ( reference )
European (structured) payment reference
Average rating: 4.4 (30 votes) Log in to vote
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
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 ) ).
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:
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.