Name Type MSSql Type Oracle Type DB2 Nullable Description
AJPPO_AH_Idnr int NUMBER(38,0) int false reference to the archive header (AH) (RunID)
AJPPO_AJPP_Lnr smallint NUMBER(38,0) smallint false ascending number of the jobplan process (Task Lnr)
AJPPO_Location smallint NUMBER(38,0) smallint false 1=Pre, 2=Post
AJPPO_Lnr smallint NUMBER(38,0) smallint false ascending number of conditions in a workflow-task
AJPPO_CarName varchar (32) VARCHAR2 (32 CHAR) varchar(32) true Name of the Condition/Action
AJPPO_Type char (1) CHAR (1 CHAR) char(1) true Type Condition/Action or structure info (C=Condition, A=Action, E=ELSE, F=ENDIF)
AJPPO_Active smallint NUMBER(38,0) smallint true 0=inactive, 1=active
AJPPO_Once smallint NUMBER(38,0) smallint true 0=every, 1=ONCE
AJPPO_Status smallint NUMBER(38,0) smallint true Status of Condition/Action
AJPPO_Count int NUMBER(38,0) int true Counter how often the conditions was checked/actions was taken
AJPPO_UIInfo varchar(max) CLOB clob(20480 k) COMPACT true User field for UI

Indexes:

Name Fields Primary Unique Clustered Nonclustered
PK_AJPPO AJPPO_AH_Idnr, AJPPO_AJPP_Lnr, AJPPO_Location, AJPPO_Lnr true true true false

Foreign Keys:

Name Local References Foreign References
FK_AJPPO_AJPP AJPPO_AH_Idnr, AJPPO_AJPP_Lnr AJPP_AH_Idnr, AJPP_Lnr

Return to the Index File