Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

EEMATCHING


                            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
Element: Company       The company number. Must be a valid       EE520
                       record in the Accounts Payable Company
                       file.

EEM-VENDOR             Alpha 9  (Right Justified)                EE20.2  EE30.1
Element: Vendor        The employee number. Must be a valid      EE520
                       record in the Accounts Payable Vendor
                       file.

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

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

EEM-AMT-APPLIED        Signed 18.2                               EE20.2  EE30.1
Element: Intl Amt      The amount of the advance that is         EE520
                       applied to the expense(s).

EEM-BASE-ADV-AMT       Signed 18.2                               EE20.2  EE30.1
Element: Intl Amt      The amount of the advance in the          EE520
                       company base currency.

                         EEMATCHING FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

EEMSET1   COMPANY                                                AP30.4  AP300
          VENDOR                                                 EE135   EE20.2
          EXPENSE-NBR                                            EE20.4  EE220
          ADVANCE-NBR                                            EE30.1  EE35.1
                                                                 EE35.2  EE520

EEMSET2   COMPANY                                                AP30.4  EE20.1
          VENDOR                                                 EE20.2  EE30.1
          ADVANCE-NBR
          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