Name Type MSSql Type Oracle Type DB2 Type Postgresql Nullable Description
JPPCV_OH_Idnr int NUMBER(38,0) int int false ID of the workflow.
JPPCV_JPP_Lnr smallint NUMBER(38,0) smallint smallint false Sequenced number of the workflow tasks.
JPPCV_VName varchar (200) VARCHAR2 (200 CHAR) varchar(200) varchar (200) false Name of the value.
JPPCV_Type smallint NUMBER(38,0) smallint smallint false Parameter type of the task. SAP: 0 = jxpb job parameter, 1 = http connection, 2 = rfc connection, DB: 1 = db connection parameter, RA: 2 = job panel, 3 = general panel, 4 = connection panel, 5 = agent panel, 6 = others panel, 7 = pushed values
JPPCV_Encrypted smallint NUMBER(38,0) smallint smallint true Indicates whether the value is encrypted or not. 0 = not encrypted, 1 = encryption type 1 (deprecated), 2 = encryption type 2 (new)
JPPCV_Connection smallint NUMBER(38,0) smallint smallint true Indicates whether or not the value is a connection value.
JPPCV_Key varbinary(16) RAW(16) varchar(16) for bit data bytea true Key for encrypted values.
JPPCV_Value varchar(max) CLOB clob(20480 k) INLINE LENGTH 30000 COMPACT text true Value.
JPPCV_IsUtf8 smallint NUMBER(38,0) smallint smallint true Indicates if JPPCV_Value is stored in UTF-8 (1) or legacy encoding (0) if it is encrypted

Indexes:

Name Fields Primary Unique Clustered Nonclustered
PK_JPPCV JPPCV_OH_Idnr, JPPCV_JPP_Lnr, JPPCV_VName, JPPCV_Type true true true false

Foreign Keys:

Name Local References Foreign References
FK_JPPCV_JPP JPPCV_OH_Idnr, JPPCV_JPP_Lnr JPP_OH_Idnr, JPP_Lnr

Return to the Index File