Name Type MSSql Type Oracle Type DB2 Type Postgresql Nullable Description
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

Indexes:

Name Fields Primary Unique Clustered Nonclustered
PK_OPSE OPSE_OH_Idnr, OPSE_Name true true true false

Foreign Keys:

Name Local References Foreign References
FK_OPSE_OH OPSE_OH_Idnr OH_Idnr

Return to the Index File