Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            EETRAVELDT FILE

UPDATED BY

ET03.2    ET03.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

ETD-COMPANY          Numeric 4                                   ET03.2
Company              The company number represents an
                     established company and is entered on
                     all function codes.

ETD-EXPENSE-NBR      Alpha 10                                    ET03.2
Expense Number       The expense report number.

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



ETD-BEFORE-AFTER     Alpha 1                                     ET03.2
Before After

ETD-SEQ              Numeric 3                                   ET03.2
Sequence Number      This field contains the record sequence
                     number.

ETD-TRAN-EXP-AMT     Signed 15.2 Occurs 18 Times                 ET03.2
Transaction Expense  The transaction amount for the
Amount               distribution.

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

ETD-EE-COMMENT       Alpha 60                                    ET03.2
Ee Comment

                         EETRAVELDT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ETDSET1   COMPANY                                                ET03.1  ET03.2
          EXPENSE-NBR
          VENDOR
          BEFORE-AFTER
          SEQ