Employee Number on (Swedish) Payment File

Hi All,

I am currently modifying a standard 'Swedish Bankgiro Inland' payment format to create an employee salary payment format (Loner) which need to be send to a Swedish bank.

I am struggling with the having the right Oracle 'path' to retrieve the Employee Number from Employee type Supplier. As shown in below table I need to have it entered at the field with the red ???

Does anyone has experience with this or can help me?

Oracle R12.2.5

1	2	Number		‘35’	Record type 35
3	6	Date, YYMMDD	R, ‘ ‘	IF PaymentDueDate >= SYSDATE THEN PaymentDueDate ELSE SYSDATE - 1 END IF	Payment date
9	4	Alpha		‘ ‘	blank
13	16	Alpha	R, ‘0’