Name Type MSSql Type Oracle Type DB2 Nullable Description
AJPPV_AH_Idnr int NUMBER(38,0) int false RunID
AJPPV_AJPP_Lnr smallint NUMBER(38,0) smallint false Task Lnr
AJPPV_OPU_Lnr smallint NUMBER(38,0) smallint false OPU_Lnr
AJPPV_PName varchar (200) VARCHAR2 (200 CHAR) varchar(200) false Prompt Set Name '' in case of value
AJPPV_VName varchar (32) VARCHAR2 (32 CHAR) varchar(32) false Value Name or Prompt Set Element Variablen Name
AJPPV_Type char (1) CHAR (1 CHAR) char(1) true 1 is Value, 2 is Prompted Value
AJPPV_Value varchar(max) CLOB clob(20480 k) INLINE LENGTH 1024 COMPACT true Value or map to parent (&xxx) (usage of system values possible here)
AJPPV_HasList smallint NUMBER(38,0) smallint true has JPPVA data in case of Array
AJPPV_Format varchar (32) VARCHAR2 (32 CHAR) varchar(32) true Output-format of value

Indexes:

Name Fields Primary Unique Clustered Nonclustered
PK_AJPPV AJPPV_AH_Idnr, AJPPV_AJPP_Lnr, AJPPV_OPU_Lnr, AJPPV_VName true true true false

Foreign Keys:

Name Local References Foreign References
FK_AJPPV_AJPP AJPPV_AH_Idnr, AJPPV_AJPP_Lnr AJPP_AH_Idnr, AJPP_Lnr

Return to the Index File