Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

EETRAVELDT


                            EETRAVELDT FILE

UPDATED BY

ET03.2    ET03.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

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

ETD-EXPENSE-NBR        Alpha 10                                  ET03.2
Element: Expense NumberThe expense report number.

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



ETD-BEFORE-AFTER       Alpha 1                                   ET03.2
Element: Account Flag

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

ETD-TRAN-EXP-AMT       Signed 15.2 Occurs 18 Times               ET03.2
Element: Adj Amt

ETD-EXPENSE-DATE       Numeric 8  (yyyymmdd)                     ET03.2
Element: Date

ETD-EE-COMMENT         Alpha 60                                  ET03.2
Element: 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