| Name | Type MSSql | Type Oracle | Type DB2 | Nullable | Description |
|---|---|---|---|---|---|
| JPOV_OH_Idnr | int | NUMBER(38,0) | int | false | reference to the object header (OH) |
| JPOV_JPP_Lnr | smallint | NUMBER(38,0) | smallint | false | ascending number of the element |
| JPOV_Location | smallint | NUMBER(38,0) | smallint | false | 1=Pre, 2=Post |
| JPOV_JPPO_Lnr | smallint | NUMBER(38,0) | smallint | false | ascending number of conditions in a workflow-task |
| JPOV_VName | varchar (32) | VARCHAR2 (32 CHAR) | varchar(32) | false | Variable name (S=Parameterset) |
| JPOV_Value | varchar(max) | CLOB | clob(128 M) INLINE LENGTH 1024 COMPACT | true | Variable value |
| JPOV_Type | char (1) | CHAR (1 CHAR) | char(1) | true | V=Value, S=Parameterset |
| JPOV_AltView | smallint | NUMBER(38,0) | smallint | true | Flag for alternative view |
| Name | Fields | Primary | Unique | Clustered | Nonclustered |
|---|---|---|---|---|---|
| PK_JPOV | JPOV_OH_Idnr, JPOV_JPP_Lnr, JPOV_Location, JPOV_JPPO_Lnr, JPOV_VName | true | true | true | false |
| Name | Local References | Foreign References |
|---|---|---|
| FK_JPOV_JPPO | JPOV_OH_Idnr, JPOV_JPP_Lnr, JPOV_Location, JPOV_JPPO_Lnr | JPPO_OH_Idnr, JPPO_JPP_Lnr, JPPO_Location, JPPO_Lnr |
Return to the Index File