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.
Best answer by AkilaR
View originalHello 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.
Best answer by AkilaR
View originalHi
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
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
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.