Name Type MSSql Type Oracle Type DB2 Nullable Description
JPPA_OH_Idnr int NUMBER(38,0) int false reference to the object header (OH)
JPPA_JPP_Lnr smallint NUMBER(38,0) smallint false reference to the jobplan process (JPP)
JPPA_Lnr smallint NUMBER(38,0) smallint false ascending number of the jobplan after
JPPA_PreLnr smallint NUMBER(38,0) smallint true ascending number of the precondition
JPPA_LineDef varchar (255) VARCHAR2 (255 CHAR) varchar(255) true desctiption of the line: aaa/bbb/c/d;.... aaa=row bbb=column c=position in the job d=option (line width)
JPPA_When varchar (30) VARCHAR2 (30 CHAR) varchar(30) true when precondition
JPPA_Name varchar (32) VARCHAR2 (32 CHAR) varchar(32) true Name of the line
JPPA_BranchType smallint NUMBER(38,0) 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_JPPA JPPA_OH_Idnr, JPPA_JPP_Lnr, JPPA_Lnr true true true false

Foreign Keys:

Name Local References Foreign References
FK_JPPA_JPP JPPA_OH_Idnr, JPPA_JPP_Lnr JPP_OH_Idnr, JPP_Lnr

Return to the Index File