EETRAVELDT FILE

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

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                                     ET03.2
Vendor ID            The vendor's identification code.



ETD-BEFORE-AFTER     Alpha 1                                     ET03.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.

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           Travel expense comment.

                         EETRAVELDT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ETDSET1   COMPANY       Used to access detail lines for travel   ET03.1  ET03.2
          EXPENSE-NBR   expenses.
          VENDOR
          BEFORE-AFTER
          SEQ