Name Type MSSql Type Oracle Type DB2 Type Postgresql Nullable Description
EPUD_AH_Idnr int NUMBER(38,0) int int false RunID
EPUD_OPU_Lnr smallint NUMBER(38,0) smallint smallint false OPU_Lnr
EPUD_VName varchar (32) VARCHAR2 (32 CHAR) varchar(32) varchar (32) false Variable name of the Prompt Set Element
EPUD_PName varchar (200) VARCHAR2 (200 CHAR) varchar(200) varchar (200) true Prompt Set Name
EPUD_HasList smallint NUMBER(38,0) smallint smallint true Has OPUDA entries for MULTI+Array (Checkbox, Checklist)
EPUD_Value varchar(max) CLOB clob(20480 k) INLINE LENGTH 1024 COMPACT text true String representation of value
EPUD_MsgNr int NUMBER(38,0) int int true Indicates whether the value has already been validated (-1 not checked, 0 check ok, >1 check wrong)
EPUD_MsgInsert varchar (1024) VARCHAR2 (1024 CHAR) varchar(1024) varchar (1024) true Inserts f�r EPUD_MsgNr
EPUD_Format varchar (32) VARCHAR2 (32 CHAR) varchar(32) varchar (32) true Output-format of value
EPUD_MultiSelect smallint NUMBER(38,0) smallint smallint true Multi select allowed
EPUD_SeparatedBy char (1) CHAR (1 CHAR) char(1) char (1) true Value Separator for multi select without list
EPUD_Quotes char (1) CHAR (1 CHAR) char(1) char (1) true Quote character
EPUD_Order smallint NUMBER(38,0) smallint smallint true Display Order in GUI
EPUD_OPSE_Lnr smallint NUMBER(38,0) smallint smallint true Prompt Set Element Line number (for UI order)
EPUD_Key varchar (200) VARCHAR2 (200 CHAR) varchar(200) varchar (200) true Used for XML-Variable contains key of the Variable-Object (OVW_VValue)
EPUD_XPath varchar (1024) VARCHAR2 (1024 CHAR) varchar(1024) varchar (1024) true XPath expression for XML-Variable

Indexes:

Name Fields Primary Unique Clustered Nonclustered
PK_EPUD EPUD_AH_Idnr, EPUD_OPU_Lnr, EPUD_VName true true true false

Foreign Keys:

Name Local References Foreign References

Return to the Index File