Name Type MSSql Type Oracle Type DB2 Type Postgresql Nullable Description
OFC_OH_Idnr int NUMBER(38,0) int int false ID of the object filter.
OFC_Lnr smallint NUMBER(38,0) smallint smallint false Sequenced number within the filter object.
OFC_SrcType char (1) CHAR (1 CHAR) char(1) char (1) true Source type of this filter. R = Report, F = File, O = Registered Job Output
OFC_Condition char (1) CHAR (1 CHAR) char(1) char (1) true Filter condition for this line. C = contains, N = does not contain
OFC_SrcName varchar (255) VARCHAR2 (255 CHAR) varchar(255) varchar (255) true Source of the filter. Report type (e.g. ACT, LOG, REP) or file name.
OFC_FilterText varchar (255) VARCHAR2 (255 CHAR) varchar(255) varchar (255) true Filter text for this filter line.

Indexes:

Name Fields Primary Unique Clustered Nonclustered
PK_OFC OFC_OH_Idnr, OFC_Lnr true true true false

Foreign Keys:

Name Local References Foreign References
FK_OFC_OFA OFC_OH_Idnr OFA_OH_Idnr

Return to the Index File