Hello all,
Can anyone help me with the table/field name where I can find the descriptions to the voucher_types captured on gen_led_voucher_row_tab table.
Thanks.
Solved
VOUCHER_TYPE DESC
+1Best answer by AkilaR
Hi
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
+11Hi
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
+1HI
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
+11Hi
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
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.