Table AFC

Definition of table: AFC - Archive Object Filter Content

generated: 12.12.2016 18:33:00
by UC2010.accdb

AE Database 11.2 (Step 018)

Name Type Len Attributes Description

AFC_AH_Idnr Long Integer 4 UC: Null=False Reference to the archive header (AH)

AFC_APPF_Lnr Integer 2 UC: Null=False Number of the filter in APPF

AFC_Lnr Integer 2 UC: Null=False Ascending number of the filter

AFC_SrcType Text 1 UC: Null=True R=Report, F=File

AFC_Condition Text 1 UC: Null=True C=contains, N=does not contain

AFC_SrcName Text 255 UC: Null=True Reporttype or Filename

AFC_FilterText Text 255 UC: Null=True FilterText

Name	Type	Len	Attributes	Description
AFC_AH_Idnr	Long Integer	4	UC: Null=False	Reference to the archive header (AH)
AFC_APPF_Lnr	Integer	2	UC: Null=False	Number of the filter in APPF
AFC_Lnr	Integer	2	UC: Null=False	Ascending number of the filter
AFC_SrcType	Text	1	UC: Null=True	R=Report, F=File
AFC_Condition	Text	1	UC: Null=True	C=contains, N=does not contain
AFC_SrcName	Text	255	UC: Null=True	Reporttype or Filename
AFC_FilterText	Text	255	UC: Null=True	FilterText

Indexes:

Name Fields

PK_AFC AFC_AH_Idnr, AFC_APPF_Lnr, AFC_Lnr

Name	Fields
PK_AFC	AFC_AH_Idnr, AFC_APPF_Lnr, AFC_Lnr

Return to the Index File