Name Type MSSql Type Oracle Type DB2 Type Postgresql Nullable Description
EJPPV_AH_Idnr int NUMBER(38,0) int int false RunID
EJPPV_EJPP_Lnr smallint NUMBER(38,0) smallint smallint false Task Lnr
EJPPV_OPU_Lnr smallint NUMBER(38,0) smallint smallint false OPU_Lnr
EJPPV_PName varchar (200) VARCHAR2 (200 CHAR) varchar(200) varchar (200) true Prompt Set Name '' in case of value
EJPPV_VName varchar (32) VARCHAR2 (32 CHAR) varchar(32) varchar (32) false Value Name or Prompt Set Element Variablen Name
EJPPV_Type char (1) CHAR (1 CHAR) char(1) char (1) true 1 is Value, 2 is Prompted Value
EJPPV_Value varchar(max) CLOB clob(20480 k) INLINE LENGTH 1024 COMPACT text true Value or map to parent (&xxx) (usage of system values possible here)
EJPPV_HasList smallint NUMBER(38,0) smallint smallint true has JPPVA data in case of Array
EJPPV_MsgNr int NUMBER(38,0) int int true not used
EJPPV_MsgInsert varchar (1024) VARCHAR2 (1024 CHAR) varchar(1024) varchar (1024) true not used
EJPPV_Format varchar (32) VARCHAR2 (32 CHAR) varchar(32) varchar (32) true not used
EJPPV_Quotes char (1) CHAR (1 CHAR) char(1) char (1) true not used

Indexes:

Name Fields Primary Unique Clustered Nonclustered
PK_EJPPV EJPPV_AH_Idnr, EJPPV_EJPP_Lnr, EJPPV_OPU_Lnr, EJPPV_VName true true true false

Foreign Keys:

Name Local References Foreign References

Return to the Index File