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       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.

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 18.2 Occurs 18 Times               ET03.2
Element: Intl Amt      The transaction amount for the
                       distribution.

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

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