| OPSE_OH_Idnr |
int |
NUMBER(38,0) |
int |
false |
Oh_idnr of the Prompt Set |
| OPSE_Name |
varchar (32) |
VARCHAR2 (32 CHAR) |
varchar(32) |
false |
Prompt Set Element VariablenName |
| OPSE_Lnr |
smallint |
NUMBER(38,0) |
smallint |
true |
Prompt Set Element Line number (for UI order) Line number (for UI order) |
| OPSE_RefName |
varchar (200) |
VARCHAR2 (200 CHAR) |
varchar(200) |
true |
Reference to an Object |
| OPSE_RefType |
varchar (8) |
VARCHAR2 (8 CHAR) |
varchar(8) |
true |
Type of reference object |
| OPSE_RefKeyName |
varchar (200) |
VARCHAR2 (200 CHAR) |
varchar(200) |
true |
Referenced Key in the reference object |
| OPSE_HasList |
smallint |
NUMBER(38,0) |
smallint |
true |
OPSEA has entries for MULTI+Array (Checkbox, Checklist) |
| OPSE_Value |
varchar(max) |
CLOB |
clob(20480 k) INLINE LENGTH 1024 COMPACT |
true |
Text representation of value |
| OPSE_OutputFormat |
varchar (32) |
VARCHAR2 (32 CHAR) |
varchar(32) |
true |
Output Format of the value at time of access |
| OPSE_MinValue |
varchar (64) |
VARCHAR2 (64 CHAR) |
varchar(64) |
true |
Min allowed value |
| OPSE_MaxValue |
varchar (64) |
VARCHAR2 (64 CHAR) |
varchar(64) |
true |
Max allowed value OR string length |
| OPSE_Uppercase |
smallint |
NUMBER(38,0) |
smallint |
true |
Convert value to upper-case (Strings only) |
| OPSE_Required |
smallint |
NUMBER(38,0) |
smallint |
true |
Input is required |
| OPSE_ShowAsPw |
smallint |
NUMBER(38,0) |
smallint |
true |
Field is shown as password field (***) |
| OPSE_MultiSelect |
smallint |
NUMBER(38,0) |
smallint |
true |
Multi select allowed |
| OPSE_SeparatedBy |
char (1) |
CHAR (1 CHAR) |
char(1) |
true |
Value Separator for multi select without list |
| OPSE_Quotes |
char (1) |
CHAR (1 CHAR) |
char(1) |
true |
quote character |
| OPSE_InputAssist |
smallint |
NUMBER(38,0) |
smallint |
true |
For Text field only (Default = true) |
| OPSE_XUI_TYPE |
varchar (255) |
VARCHAR2 (255 CHAR) |
varchar(255) |
true |
Type of the Prompt Element. E.g. combo, text, � |
| OPSE_MsgNr |
int |
NUMBER(38,0) |
int |
true |
Indicates whether the value has already been validated (-1 not checked, 0 check ok, >1 check wrong) |
| OPSE_MsgInsert |
varchar (1024) |
VARCHAR2 (1024 CHAR) |
varchar(1024) |
true |
Inserts f�r OPSE_MsgNr |
| OPSE_AltView |
smallint |
NUMBER(38,0) |
smallint |
true |
Flag for alternative view |
| OPSE_CustomField |
varchar (255) |
VARCHAR2 (255 CHAR) |
varchar(255) |
true |
Value of the custom field of this entry |
| OPSE_XUI |
varchar(max) |
CLOB |
clob(20480 k) INLINE LENGTH 1200 COMPACT |
true |
Prompt Set Element XML-GUI-Descr. |
| OPSE_Key |
varchar (200) |
VARCHAR2 (200 CHAR) |
varchar(200) |
true |
Used for XML-Variable contains key of the Variable-Object (OVW_VValue) |
| OPSE_XPath |
varchar(1024) |
VARCHAR2 (1024 CHAR) |
varchar(1024) |
true |
XPath expression for XML-Variable |