Name Type MSSql Type Oracle Type DB2 Nullable Description
OPPF_OH_Idnr int NUMBER(38,0) int false Reference to the object header
OPPF_Lnr smallint NUMBER(38,0) smallint false Ascending number of the filter
OPPF_Fltrname varchar (255) VARCHAR2 (255 CHAR) varchar(255) true Name of the Filter Object
OPPF_Result smallint NUMBER(38,0) smallint true True/False
OPPF_Retcode smallint NUMBER(38,0) smallint true Returncode
OPPF_Execute varchar (255) VARCHAR2 (255 CHAR) varchar(255) true Object to execute
OPPF_StatusInsert varchar (100) VARCHAR2 (100 CHAR) varchar(100) true Custom specific message insert

Indexes:

Name Fields Primary Unique Clustered Nonclustered
PK_OPPF OPPF_OH_Idnr, OPPF_Lnr true true true false

Foreign Keys:

Name Local References Foreign References
FK_OPPF_OH OPPF_OH_Idnr OH_Idnr

Return to the Index File