Name Type MSSql Type Oracle Type DB2 Nullable Description
EFC_AH_Idnr int NUMBER(38,0) int false Reference to the archive header (AH)
EFC_EPPF_Lnr smallint NUMBER(38,0) smallint false Number of the filter in EPPF
EFC_Lnr smallint NUMBER(38,0) smallint false Ascending number of the filter
EFC_SrcType char (1) CHAR (1 CHAR) char(1) true R=Report, F=File, O=Registered Job Output
EFC_Condition char (1) CHAR (1 CHAR) char(1) true C=contains, N=does not contain
EFC_SrcName varchar (255) VARCHAR2 (255 CHAR) varchar(255) true Reporttype or Filename
EFC_FilterText varchar (255) VARCHAR2 (255 CHAR) varchar(255) true FilterText

Indexes:

Name Fields Primary Unique Clustered Nonclustered
PK_EFC EFC_AH_Idnr, EFC_EPPF_Lnr, EFC_Lnr true true true false

Foreign Keys:

Name Local References Foreign References

Return to the Index File