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