Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             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
Company              The company number represents an
                     established company and is entered on
                     all function codes.

END-EXPENSE-NBR      Alpha 10                                    ET02.2
Expense Number       The expense report number.

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



END-BEFORE-AFTER     Alpha 1                                     ET02.2
Before After         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
Sequence Number      This field contains the record sequence
                     number.

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

END-TRAN-EXP-AMT     Signed 15.2                                 ET02.2
Transaction Expense  The transaction amount for the
Amount               distribution.

END-APP-EXP-AMT      Signed 15.2                                 ET02.2
App Exp Amt          The application expense amount for the
                     distribution.

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

END-CATEGORY         Alpha 9                                     ET02.2
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