Name Type MSSql Type Oracle Type DB2 Nullable Description
JPPV_OH_Idnr int NUMBER(38,0) int false OH_Idnr of Process Flow
JPPV_JPP_Lnr smallint NUMBER(38,0) smallint false Task Lnr
JPPV_OPU_Lnr smallint NUMBER(38,0) smallint false OPU_Lnr
JPPV_PName varchar (200) VARCHAR2 (200 CHAR) varchar(200) false Prompt Set Name '' in case of value
JPPV_VName varchar (32) VARCHAR2 (32 CHAR) varchar(32) false Value Name or Prompt Set Element Variablen Name
JPPV_Type char (1) CHAR (1 CHAR) char(1) true 1 is Value, 2 is Prompted Value
JPPV_Value varchar(max) CLOB clob(20480 k) INLINE LENGTH 1024 COMPACT true Value or map to parent (&xxx) (usage of system values possible here)
JPPV_HasList smallint NUMBER(38,0) smallint true has JPPVA data in case of Array
JPPV_MsgNr int NUMBER(38,0) int true Indicates whether the value has already been validated (-1 not checked, 0 check ok, >1 check wrong)
JPPV_MsgInsert varchar (1024) VARCHAR2 (1024 CHAR) varchar(1024) true Inserts f�r JPPV_MsgNr
JPPV_AltView smallint NUMBER(38,0) smallint true Flag for alternative view

Indexes:

Name Fields Primary Unique Clustered Nonclustered
PK_JPPV JPPV_OH_Idnr, JPPV_JPP_Lnr, JPPV_OPU_Lnr, JPPV_VName true true true false

Foreign Keys:

Name Local References Foreign References
FK_JPPV_JPP JPPV_OH_Idnr, JPPV_JPP_Lnr JPP_OH_Idnr, JPP_Lnr

Return to the Index File