Solved

VOUCHER_TYPE DESC

  • 18 April 2024
  • 3 replies
  • 37 views
B
Rank
Badge +1
  • Babs
  • Do Gooder (Customer)
  • 3 replies

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.

icon

Best answer by AkilaR 18 April 2024, 20:56

View original

3 replies

AkilaR
Rank
Userlevel 6
Badge +11

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

B
Rank
Badge +1

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

 

AkilaR
Rank
Userlevel 6
Badge +11

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

Reply


Terms & ConditionsCookie settings