| Name | Type MSSql | Type Oracle | Type DB2 | Nullable | Description |
|---|---|---|---|---|---|
| JPVA_OH_Idnr | int | NUMBER(38,0) | int | false | OH_Idnr of Process Flow |
| JPVA_JPP_Lnr | smallint | NUMBER(38,0) | smallint | false | Task Lnr |
| JPVA_OPU_Lnr | smallint | NUMBER(38,0) | smallint | false | OPU_Lnr |
| JPVA_JPPV_VName | varchar (32) | VARCHAR2 (32 CHAR) | varchar(32) | false | Value Name or Prompt Set Element Variablen Name |
| JPVA_Lnr | int | NUMBER(38,0) | int | false | Ascending number (index of array) |
| JPVA_Value | varchar(max) | CLOB | clob(20480 k) INLINE LENGTH 1024 COMPACT | true | Value = Caption on MULTI+Array (Checkbox, Checklist) |
| Name | Fields | Primary | Unique | Clustered | Nonclustered |
|---|---|---|---|---|---|
| PK_JPVA | JPVA_OH_Idnr, JPVA_JPP_Lnr, JPVA_OPU_Lnr, JPVA_JPPV_VName, JPVA_Lnr | true | true | true | false |
| Name | Local References | Foreign References |
|---|---|---|
| FK_JPVA_JPPV | JPVA_OH_Idnr, JPVA_JPP_Lnr, JPVA_OPU_Lnr, JPVA_JPPV_VName | JPPV_OH_Idnr, JPPV_JPP_Lnr, JPPV_OPU_Lnr, JPPV_VName |
Return to the Index File