Hi @Babs ,

If this is for a query you can use VOUCHER_TYPE_API.Get_Description(company,voucher_type) method to get the description for voucher type.

Regards,

Akila

HI @AkilaR 

Thanks for your quick response.

I don’t have access to IFS database so can’t confirm this myself.

Can you help confirm if this query will return the company, voucher_types and their descriptions:
 

SELECT DISTINCT 

GEN_LED_VOUCHER_ROW_TAB.COMPANY, 

GEN_LED_VOUCHER_ROW_TAB.VOUCHER_TYPE,

ifsapp.VOUCHER_TYPE_API.Get_Description(GEN_LED_VOUCHER_ROW_TAB.voucher_type) AS VOUCHER_DESC

FROM ifsapp.GEN_LED_VOUCHER_ROW_TAB GEN_LED_VOUCHER_ROW_TAB

Hi @Babs ,

I believe below will be a reasonably faster query than above.

select a.company, a.voucher_type, VOUCHER_TYPE_API.Get_Description(company,voucher_type) VOUCHER_DESC
from gen_led_voucher_row_tab a
group by a.company, a.voucher_type

Regards,

Akila