| Name | Type MSSql | Type Oracle | Type DB2 | Nullable | Description |
|---|---|---|---|---|---|
| AJPVA_AH_Idnr | int | NUMBER(38,0) | int | false | RunID |
| AJPVA_AJPP_Lnr | smallint | NUMBER(38,0) | smallint | false | Task Lnr |
| AJPVA_OPU_Lnr | smallint | NUMBER(38,0) | smallint | false | OPU_Lnr |
| AJPVA_AJPPV_VName | varchar (32) | VARCHAR2 (32 CHAR) | varchar(32) | false | Value Name or Prompt Set Element Variablen Name |
| AJPVA_Lnr | int | NUMBER(38,0) | int | false | Ascending number (index of array) |
| AJPVA_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_AJPVA | AJPVA_AH_Idnr, AJPVA_AJPP_Lnr, AJPVA_OPU_Lnr, AJPVA_AJPPV_VName, AJPVA_Lnr | true | true | true | false |
| Name | Local References | Foreign References |
|---|---|---|
| FK_AJPVA_AJPPV | AJPVA_AH_Idnr, AJPVA_AJPP_Lnr, AJPVA_OPU_Lnr, AJPVA_AJPPV_VName | AJPPV_AH_Idnr, AJPPV_AJPP_Lnr, AJPPV_OPU_Lnr, AJPPV_VName |
Return to the Index File