Name Type MSSql Type Oracle Type DB2 Nullable Description
AFC_AH_Idnr int NUMBER(38,0) int false Reference to the archive header (AH)
AFC_APPF_Lnr smallint NUMBER(38,0) smallint false Number of the filter in APPF
AFC_Lnr smallint NUMBER(38,0) smallint false Ascending number of the filter
AFC_SrcType char (1) CHAR (1 CHAR) char(1) true R=Report, F=File
AFC_Condition char (1) CHAR (1 CHAR) char(1) true C=contains, N=does not contain
AFC_SrcName varchar (255) VARCHAR2 (255 CHAR) varchar(255) true Reporttype or Filename
AFC_FilterText varchar (255) VARCHAR2 (255 CHAR) varchar(255) true FilterText

Indexes:

Name Fields Primary Unique Clustered Nonclustered
PK_AFC AFC_AH_Idnr, AFC_APPF_Lnr, AFC_Lnr true true true false

Foreign Keys:

Name Local References Foreign References
FK_AFC_APPF AFC_AH_Idnr, AFC_APPF_Lnr APPF_AH_Idnr, APPF_Lnr

Return to the Index File