| Name | Type MSSql | Type Oracle | Type DB2 | Nullable | Description |
|---|---|---|---|---|---|
| OFC_OH_Idnr | int | NUMBER(38,0) | int | false | Reference to the object header (OH) |
| OFC_Lnr | smallint | NUMBER(38,0) | smallint | false | Ascending number of the filter |
| OFC_SrcType | char (1) | CHAR (1 CHAR) | char(1) | true | R=Report, F=File, O=Registered Job Output |
| OFC_Condition | char (1) | CHAR (1 CHAR) | char(1) | true | C=contains, N=does not contain |
| OFC_SrcName | varchar (255) | VARCHAR2 (255 CHAR) | varchar(255) | true | Reporttype or Filename |
| OFC_FilterText | varchar (255) | VARCHAR2 (255 CHAR) | varchar(255) | true | FilterText |
| Name | Fields | Primary | Unique | Clustered | Nonclustered |
|---|---|---|---|---|---|
| PK_OFC | OFC_OH_Idnr, OFC_Lnr | true | true | true | false |
| Name | Local References | Foreign References |
|---|---|---|
| FK_OFC_OFA | OFC_OH_Idnr | OFA_OH_Idnr |
Return to the Index File