Name Type MSSql Type Oracle Type DB2 Type Postgresql Nullable Description
AJPPA_AH_Idnr int NUMBER(38,0) int int false reference to the archive header (AH)
AJPPA_AJPP_Lnr smallint NUMBER(38,0) smallint smallint false reference to the jobplan process (AJPP)
AJPPA_Lnr smallint NUMBER(38,0) smallint smallint false ascending number of the jobplan after
AJPPA_PreLnr smallint NUMBER(38,0) smallint smallint false ascending number of the precondition
AJPPA_LineDef varchar (255) VARCHAR2 (255 CHAR) varchar(255) varchar (255) true desctiption of the line: aaa/bbb/c/d;.... aaa=row bbb=column c=position in the job d=option (line width)
AJPPA_When varchar (30) VARCHAR2 (30 CHAR) varchar(30) varchar (30) true when precondition
AJPPA_Status int NUMBER(38,0) int int true state of the precondition
AJPPA_Name varchar (32) VARCHAR2 (32 CHAR) varchar(32) varchar (32) true Name of the line
AJPPA_BranchType smallint NUMBER(38,0) smallint smallint true position (branch) of the object in IF: 1=true; 2=false; or FOREACH: 1=LoopPath; 2= EndPath

Indexes:

Name Fields Primary Unique Clustered Nonclustered
PK_AJPPA AJPPA_AH_Idnr, AJPPA_AJPP_Lnr, AJPPA_Lnr true true true false

Foreign Keys:

Name Local References Foreign References
FK_AJPPA_AJPP AJPPA_AH_Idnr, AJPPA_AJPP_Lnr AJPP_AH_Idnr, AJPP_Lnr

Return to the Index File