EEMATCHING FILE

                        Advance-Expense Matching

The Matching file contains open and applied employee advance records and
applied expense records.

REFERENCED BY

EE135     EE220     EE35.1    EE35.2

UPDATED BY

AP30.4    AP300     EE20.1    EE20.2    EE20.4    EE30.1
EE520

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

EEM-COMPANY          Numeric 4                                   EE20.2  EE30.1
Company              The company number. Must be a valid         EE520
                     record in the Accounts Payable Company
                     file.

EEM-VENDOR           Alpha 9                                     EE20.2  EE30.1
Vendor ID            The employee number. Must be a valid        EE520
                     record in the Accounts Payable Vendor
                     file.

EEM-EXPENSE-NBR      Alpha 10                                    EE20.2  EE30.1
Expense Number       A unique number assigned to an employee     EE520
                     expense.

EEM-ADVANCE-NBR      Alpha 10                                    EE20.2  EE30.1
Advance Number       A unique number assigned to an employee     EE520
                     advance.

EEM-AMT-APPLIED      Signed 15.2                                 EE20.2  EE30.1
Applied Amount       The amount of the advance that is           EE520
                     applied to the expense(s).

EEM-BASE-ADV-AMT     Signed 15.2                                 EE20.2  EE30.1
Advance Amount       The amount of the advance in the            EE520
                     company base currency.

                         EEMATCHING FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

EEMSET1   COMPANY       This index is used to access open        AP30.4  AP300
          VENDOR        advances for a specific employee and     EE135   EE20.2
          EXPENSE-NBR   company.                                 EE20.4  EE220
          ADVANCE-NBR                                            EE30.1  EE35.1
                                                                 EE35.2  EE520

EEMSET2   COMPANY       This index is used to access applied     AP30.4  EE20.1
          VENDOR        advances for a specific employee and     EE20.2  EE30.1
          ADVANCE-NBR   company.
          EXPENSE-NBR

                         EEMATCHING FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Eeadvance      EEADVANCE    Required

                            EEM-COMPANY        -> EEA-COMPANY
                            EEM-VENDOR         -> EEA-VENDOR
                            EEM-ADVANCE-NBR    -> EEA-ADVANCE-NBR

Eeexpense      EEEXPENSE    Required

                            EEM-COMPANY        -> EXP-COMPANY
                            EEM-VENDOR         -> EXP-VENDOR
                            EEM-EXPENSE-NBR    -> EXP-EXPENSE-NBR