| Name | Type MSSql | Type Oracle | Type DB2 | Type Postgresql | Nullable | Description |
|---|---|---|---|---|---|---|
| AJPOV_AH_Idnr | int | NUMBER(38,0) | int | int | false | reference to the archive header (AH) (RunID) |
| AJPOV_AJPP_Lnr | smallint | NUMBER(38,0) | smallint | smallint | false | ascending number of the jobplan process (Task Lnr) |
| AJPOV_Location | smallint | NUMBER(38,0) | smallint | smallint | false | 1=Pre, 2=Post |
| AJPOV_AJPPO_Lnr | smallint | NUMBER(38,0) | smallint | smallint | false | ascending number of conditions in a workflow-task |
| AJPOV_VName | varchar (32) | VARCHAR2 (32 CHAR) | varchar(32) | varchar (32) | false | Variable name (S=Parameterset) |
| AJPOV_Value | varchar(max) | CLOB | clob(128 M) INLINE LENGTH 1024 COMPACT | text | true | Variable value |
| AJPOV_Type | char (1) | CHAR (1 CHAR) | char(1) | char (1) | true | V=Value, S=Parameterset |
| AJPOV_AltView | smallint | NUMBER(38,0) | smallint | smallint | true | Flag for alternative view |
| Name | Fields | Primary | Unique | Clustered | Nonclustered |
|---|---|---|---|---|---|
| PK_AJPOV | AJPOV_AH_Idnr, AJPOV_AJPP_Lnr, AJPOV_Location, AJPOV_AJPPO_Lnr, AJPOV_VName | true | true | true | false |
| Name | Local References | Foreign References |
|---|---|---|
| FK_AJPOV_AJPPO | AJPOV_AH_Idnr, AJPOV_AJPP_Lnr, AJPOV_Location, AJPOV_AJPPO_Lnr | AJPPO_AH_Idnr, AJPPO_AJPP_Lnr, AJPPO_Location, AJPPO_Lnr |
Return to the Index File