Name Type MSSql Type Oracle Type DB2 Type Postgresql Nullable Description
OPUD_OH_Idnr int NUMBER(38,0) int int false ID of the object.
OPUD_OPU_Lnr smallint NUMBER(38,0) smallint smallint false Line number of the prompt set within the object.
OPUD_VName varchar (32) VARCHAR2 (32 CHAR) varchar(32) varchar (32) false Name of the prompt set variable.
OPUD_PName varchar (200) VARCHAR2 (200 CHAR) varchar(200) varchar (200) true Name of the prompt set.
OPUD_HasList smallint NUMBER(38,0) smallint smallint true Indicates whether or not this variable is an array or a list.
OPUD_Value varchar(max) CLOB clob(20480 k) INLINE LENGTH 1024 COMPACT text true Default value of this prompt set element.
OPUD_MsgNr int NUMBER(38,0) int int true Indicates whether the value has already been validated or not. -1 = not checked, 0 = successful check, >1 = check failed
OPUD_MsgInsert varchar (1024) VARCHAR2 (1024 CHAR) varchar(1024) varchar (1024) true Inserts for OPUD_MsgNr.
OPUD_AltView smallint NUMBER(38,0) smallint smallint true Flag for an 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