By default, the foreign key relations specified in the pkfield XML element are checked for equality (default value: logicaloperator="eq"). This applies to the corresponding definitions in the document table (doctable), the document header table (docreftable) and the data table (table).
You can perform other comparisons by specifying the following operators:
The comparisons are performed lexicographically in line with the Unicode character list, i.e., the value 00999 is less than the value 9. Alphanumeric text values can also be compared.
Example
The associated reference period for each EEINV-EINZDAT date value is to be determined. This value represents a time interval with a start and end date. All three date fields (EEINV-EINZDAT, EANLH-VON, EANLH-BIS) are to be extracted. The file extract below shows the corresponding configuration with the foreign key comparisons less than or equal to or greater than or equal to for extracting field values from the EANLH table:
<?xml version="1.0" encoding="ISO-8859-1"?>
<!DOCTYPE xmlextractor_tableconfiguration SYSTEM
'xmlextractor_tableconfiguration.dtd'>
<xmlextractor_tableconfiguration>
<configuration name="ISU">
<docspec>
<doctable name="EEINV">
<pkfield name="EINZBELEG"/>
<pkfield name="VERTRAG"/>
</doctable>
</docspec>
<table name="EEINV">
<pkfield name="EINZBELEG" fktablename="EEINV"
fkfieldname="EINZBELEG"/>
<pkfield name="VERTRAG" fktablename="EEINV"
fkfieldname="VERTRAG"/>
<fieldtoread name="ANLAGE"/>
<fieldtoread name="EINZDAT"/>
</table>
<table name="EANLH">
<pkfield name="ANLAGE" fktablename="EEINV"
fkfieldname="ANLAGE"/>
<pkfield name="VON" fktablename="EEINV"
fkfieldname="EINZDAT" logicaloperator="leq"/>
<pkfield name="BIS" fktablename="EEINV"
fkfieldname="EINZDAT" logicaloperator="geq"/>
<fieldtoread name="VON"/>
<fieldtoread name="BIS"/>
<fieldtoread name="TARIFTYP"/>
</table>
</configuration>
</xmlextractor_tableconfiguration>
A system event extracted with this configuration could look like this:
<event>
<attribute type="EEINV-EINZBELEG">000000800002</attribute>
<attribute type="EEINV-VERTRAG">00012532</attribute>
<attribute type="EEINV-ANLAGE">00045678</attribute>
<attribute type="EEINV-EINZDAT">20041015</attribute>
<attribute type="EANLH-VON">20041001</attribute>
<attribute type="EANLH-BIS">20050930</attribute>
<attribute type="EANLH-TARIFTYP">YELLOW-PRIVAT</attribute>
</event>