Where are variables stored for the Finance Request

[archit2]

I want to access the table where "Variables values" are stored for the Finance Request.

• This is (sn_sm_finance_request) table (depreciated application).
• It's extended off the service order table.

Please Note:

• sc_item_option_mtom, which has variables values for sc_req_item, did not have Finance records in it.
• item_option_new contains the questions/variable but it does not have variable values, like sc_item_option_mtom does. 

Any help would be greatly appreciated!

[Harish KM · Accepted solution]

You need to look for question_answer table and 'item_option_new'. This is where record producer variables are stored

[Vaishnavi Lathk]

Hi,

variables store intially for catalog item table(sc_item_option_mtom) and for record producer table(item_option_new/question_answer).

Regards,

Vaishnavi

[archit2]

Thanks, I was able to find the variable values in question_answer table.