[AWA] Which table in UC4 SQL database that holds Variable & Prompt settings for jobplan?

Document ID : KB000109872
Last Modified Date : 22/08/2018
Show Technical Document Details
Which table in UC4 database that holds the "Variable & Prompt" values for jobplan? 
The "Variable" information is stored in OV table, and "Prompt" information is stored in OPU table.
The reference keys to OH_Idnr (of jobplan) are OV_OH_Idnr and OPU_OH_Idnr. 

Another referent information:
- The default value of the prompt itself will be in OPSE 
- Value of prompt if defined on object level will be in OPUD 
- Value is overwritten in JOBP - value will be within JPPV