Name Type MSSql Type Oracle Type DB2 Type Postgresql Nullable Description
APPF_AH_Idnr int NUMBER(38,0) int int false Reference to the archive header
APPF_Lnr smallint NUMBER(38,0) smallint smallint false Ascending number of the filter
APPF_Fltrname varchar (255) VARCHAR2 (255 CHAR) varchar(255) varchar (255) true Name of the Filter Object
APPF_Result smallint NUMBER(38,0) smallint smallint true True/False
APPF_Retcode smallint NUMBER(38,0) smallint smallint true Returncode
APPF_Execute varchar (255) VARCHAR2 (255 CHAR) varchar(255) varchar (255) true Object to execute
APPF_Operator char (1) CHAR (1 CHAR) char(1) char (1) true A=AND, O=OR
APPF_Status smallint NUMBER(38,0) smallint smallint true 0=open, 1900=done
APPF_StatusInsert varchar (100) VARCHAR2 (100 CHAR) varchar(100) varchar (100) true Custom specific message insert

Indexes:

Name Fields Primary Unique Clustered Nonclustered
PK_APPF APPF_AH_Idnr, APPF_Lnr true true true false

Foreign Keys:

Name Local References Foreign References
FK_APPF_AH APPF_AH_Idnr AH_Idnr

Return to the Index File