| OPSE_OH_Idnr |
int |
NUMBER(38,0) |
int |
int |
false |
ID of the prompt set. |
| OPSE_Name |
varchar (32) |
VARCHAR2 (32 CHAR) |
varchar(32) |
varchar (32) |
false |
Name of the prompt set element. |
| OPSE_Lnr |
smallint |
NUMBER(38,0) |
smallint |
smallint |
true |
Sequenced number for the prompt set elements. |
| OPSE_RefName |
varchar (200) |
VARCHAR2 (200 CHAR) |
varchar(200) |
varchar (200) |
true |
Name of the reference object. |
| OPSE_RefType |
varchar (8) |
VARCHAR2 (8 CHAR) |
varchar(8) |
varchar (8) |
true |
Type of the reference object. |
| OPSE_RefKeyName |
varchar (200) |
VARCHAR2 (200 CHAR) |
varchar(200) |
varchar (200) |
true |
Key of the reference. |
| OPSE_HasList |
smallint |
NUMBER(38,0) |
smallint |
smallint |
true |
Indicates whether or not this element is a list. |
| OPSE_Value |
varchar(max) |
CLOB |
clob(20480 k) INLINE LENGTH 1024 COMPACT |
text |
true |
The textual representation of the value. |
| OPSE_OutputFormat |
varchar (32) |
VARCHAR2 (32 CHAR) |
varchar(32) |
varchar (32) |
true |
The output format of the value at time of acces. |
| OPSE_MinValue |
varchar (64) |
VARCHAR2 (64 CHAR) |
varchar(64) |
varchar (64) |
true |
Min. value allowed. |
| OPSE_MaxValue |
varchar (64) |
VARCHAR2 (64 CHAR) |
varchar(64) |
varchar (64) |
true |
Max. value allowed. |
| OPSE_Uppercase |
smallint |
NUMBER(38,0) |
smallint |
smallint |
true |
Indicates whether or not the text value is converted to upper case. |
| OPSE_Required |
smallint |
NUMBER(38,0) |
smallint |
smallint |
true |
Indicates whether or not this element is required and needs to be set. |
| OPSE_ShowAsPw |
smallint |
NUMBER(38,0) |
smallint |
smallint |
true |
Indicates whether or not this element is a password field. |
| OPSE_MultiSelect |
smallint |
NUMBER(38,0) |
smallint |
smallint |
true |
Indicates whether or not multi-select is allowed for this element. |
| OPSE_SeparatedBy |
char (1) |
CHAR (1 CHAR) |
char(1) |
char (1) |
true |
Defines the separator in case the element contains of multiple values. |
| OPSE_Quotes |
char (1) |
CHAR (1 CHAR) |
char(1) |
char (1) |
true |
Defines the character used for quotes. |
| OPSE_InputAssist |
smallint |
NUMBER(38,0) |
smallint |
smallint |
true |
Indicates whether an input assistent is enabled or not. |
| OPSE_XUI_TYPE |
varchar (255) |
VARCHAR2 (255 CHAR) |
varchar(255) |
varchar (255) |
true |
Defines the type of the ui component. |
| OPSE_MsgNr |
int |
NUMBER(38,0) |
int |
int |
true |
Indicates whether the value has already been validated or not. -1 = not checked, 0 = check ok, >1 check wrong |
| OPSE_MsgInsert |
varchar (1024) |
VARCHAR2 (1024 CHAR) |
varchar(1024) |
varchar (1024) |
true |
The message inserts for OPSE_MsgNr |
| OPSE_AltView |
smallint |
NUMBER(38,0) |
smallint |
smallint |
true |
Flag for alternative view. |
| OPSE_CustomField |
varchar (255) |
VARCHAR2 (255 CHAR) |
varchar(255) |
varchar (255) |
true |
Value of the custom field of this entry. |
| OPSE_XUI |
varchar(max) |
CLOB |
clob(20480 k) INLINE LENGTH 1200 COMPACT |
text |
true |
XML description for the prompt set element. |
| OPSE_Key |
varchar (200) |
VARCHAR2 (200 CHAR) |
varchar(200) |
varchar (200) |
true |
Used for XML variables and contains the key of the variable object. (OVW_VValue) |
| OPSE_XPath |
varchar(1024) |
VARCHAR2 (1024 CHAR) |
varchar(1024) |
varchar(1024) |
true |
XPath expression for XML variables |