Name Type MSSql Type Oracle Type DB2 Type Postgresql Nullable Description
FJPPA_FE_Idnr int NUMBER(38,0) int int false reference to the task header (FE)
FJPPA_FJPP_Lnr smallint NUMBER(38,0) smallint smallint false reference to the jobplan process (FJPP)
FJPPA_Lnr smallint NUMBER(38,0) smallint smallint false ascending number of the jobplan after
FJPPA_PreLnr smallint NUMBER(38,0) smallint smallint false ascending number of the precondition
FJPPA_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)
FJPPA_When varchar (30) VARCHAR2 (30 CHAR) varchar(30) varchar (30) true when precondition
FJPPA_Name varchar (32) VARCHAR2 (32 CHAR) varchar(32) varchar (32) true Name of the line
FJPPA_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_FJPPA FJPPA_FE_Idnr, FJPPA_FJPP_Lnr, FJPPA_Lnr true true true false

Foreign Keys:

Name Local References Foreign References
FK_FJPPA_FJPP FJPPA_FE_Idnr, FJPPA_FJPP_Lnr FJPP_FE_Idnr, FJPP_Lnr

Return to the Index File