Name Type MSSql Type Oracle Type DB2 Nullable Description
OPUD_OH_Idnr int NUMBER(38,0) int false OH_Idnr of the assigned executable object
OPUD_OPU_Lnr smallint NUMBER(38,0) smallint false OPU_Lnr
OPUD_VName varchar (32) VARCHAR2 (32 CHAR) varchar(32) false Variable name of the Prompt Set Element
OPUD_PName varchar (200) VARCHAR2 (200 CHAR) varchar(200) true Prompt Set Name
OPUD_HasList smallint NUMBER(38,0) smallint true Has OPUDA entries for MULTI+Array (Checkbox, Checklist)
OPUD_Value varchar(max) CLOB clob(20480 k) INLINE LENGTH 1024 COMPACT true String representation of value
OPUD_MsgNr int NUMBER(38,0) int true Indicates whether the value has already been validated (-1 not checked, 0 check ok, >1 check wrong)
OPUD_MsgInsert varchar (1024) VARCHAR2 (1024 CHAR) varchar(1024) true Inserts f�r OPUD_MsgNr
OPUD_AltView smallint NUMBER(38,0) smallint true Flag for alternative view

Indexes:

Name Fields Primary Unique Clustered Nonclustered
PK_OPUD OPUD_OH_Idnr, OPUD_OPU_Lnr, OPUD_VName true true true false

Foreign Keys:

Name Local References Foreign References
FK_OPUD_OPU OPUD_OH_Idnr, OPUD_OPU_Lnr OPU_OH_Idnr, OPU_Lnr

Return to the Index File