Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

EENONDETL


                             EENONDETL FILE

This file contains non-travel expense detail information. This file is used
by the web based employee expense programs.

UPDATED BY

ET02.2    ET02.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

END-COMPANY            Numeric 4                                 ET02.2
Element: Company       Identifies the AP company if the
                       resource type = V.  Identifies the HR
                       company if the resource type = E.  It is
                       blank for type A, P or Q resources.

END-EXPENSE-NBR        Alpha 10                                  ET02.2
Element: Expense NumberThe expense report number.

END-VENDOR             Alpha 9  (Right Justified)                ET02.2
Element: Vendor ID     The vendor's identification code.



END-BEFORE-AFTER       Alpha 1                                   ET02.2
Element: Account Flag  Used by the web travel/non-travel
                       expense entry and approval routines. A
                       value of "B" indicates that the expense
                       has been entered by an employee. A value
                       of "A" indicates that the expense has
                       been approved.

END-SEQ                Numeric 3                                 ET02.2
Element: Sequence NumbeThis field contains the record sequence
                       number.

END-CAT-DESC           Alpha 50                                  ET02.2
Element: Cat Desc      Category description.

END-TRAN-EXP-AMT       Signed 18.2                               ET02.2
Element: Intl Amt      The transaction amount for the
                       distribution.

END-APP-EXP-AMT        Signed 18.2                               ET02.2
Element: Intl Amt      The application expense amount for the
                       distribution.

END-EXPENSE-DATE       Numeric 8  (yyyymmdd)                     ET02.2
Element: Date          The date the expense was incurred.

END-CATEGORY           Alpha 9                                   ET02.2
Element: Category      A category code is user-defined and
                       represents a general ledger account for
                       a specific type of expense type during
                       expense entry.

                         EENONDETL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ENDSET1   COMPANY       Used to access detail lines for a        ET02.1  ET02.2
          EXPENSE-NBR   non-travel expense.
          VENDOR
          BEFORE-AFTER
          SEQ