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

Indexes:

Name Fields Primary Unique Clustered Nonclustered
PK_FJPPF FJPPF_FE_Idnr, FJPPF_FJPP_Lnr true true true false

Foreign Keys:

Name Local References Foreign References
FK_FJPPF_FJPP FJPPF_FE_Idnr, FJPPF_FJPP_Lnr FJPP_FE_Idnr, FJPP_Lnr

Return to the Index File