Name Type MSSql Type Oracle Type DB2 Nullable Description
JPPF_OH_Idnr int NUMBER(38,0) int false reference to the object header (OH)
JPPF_JPP_Lnr smallint NUMBER(38,0) smallint false reference to the jobplan process (JPP) , always 001
JPPF_Source smallint NUMBER(38,0) smallint true 1=VARA, 2=ARRAY
JPPF_SourceName varchar (200) VARCHAR2 (200 CHAR) varchar(200) true Name of VARA or ARRAY
JPPF_Column smallint NUMBER(38,0) smallint true Used only if Source=VARA
JPPF_PublishAs varchar (32) VARCHAR2 (32 CHAR) varchar(32) true Name of the VARA under which the value is available in the ProcessFlow.

Indexes:

Name Fields Primary Unique Clustered Nonclustered
PK_JPPF JPPF_OH_Idnr, JPPF_JPP_Lnr true true true false

Foreign Keys:

Name Local References Foreign References
FK_JPPF_JPP JPPF_OH_Idnr, JPPF_JPP_Lnr JPP_OH_Idnr, JPP_Lnr

Return to the Index File