Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                            EETRAVELHD FILE

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

UPDATED BY

ET03.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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

ETH-EXPENSE-NBR      Alpha 10                                    ET03.1
Expense Number       The expense report number.

ETH-VENDOR           Alpha 9                                     ET03.1
Vendor ID            The vendor's identification code.



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

ETH-DEF-ACCT-UNIT    Alpha 15                                    ET03.1
Default Accounting   The general ledger accounting unit that
Unit                 defaults to all expense accounts
                     entered.


ETH-BILLABLE         Alpha 1                                     ET03.1
Billable Indicator   Indicates whether the expense is
                     billable.

ETH-ADVANCE-NBR      Alpha 10                                    ET03.1
Advance Number       This user-defined field is used to
                     identify the advance to be entered.


ETH-CURRENCY-CODE    Alpha 5                                     ET03.1
Currency Code        This field contains the company base
                     currency code established in GL10.1
                     (Company).

ETH-APPROVAL-CODE    Alpha 3                                     ET03.1
Approval Code        A user-defined code used for approving
                     advances and expenses to be released to
                     the Accounts Payable System.


ETH-DESC             Alpha 30  (Lower Case)                      ET03.1
Description          Description.

ETH-BEG-DATE         Numeric 8  (yyyymmdd) Occurs 3 Times        ET03.1
Beginning Date       The beginning date in a range of dates.


ETH-END-DATE         Numeric 8  (yyyymmdd) Occurs 3 Times        ET03.1
Ending Date          The ending date in a range of dates.

ETH-EE-COMMENT       Alpha 60 Occurs 3 Times                     ET03.1
Ee Comment           Travel expense comment.

ETH-NAME             Alpha 30  (Lower Case)                      ET03.1
Name                 Contains the company description.

ETH-EE-STATUS        Alpha 1                                     ET03.1
Ee Status            Expense status.

ETH-TRAN-EXP-TOTAL   Signed 15.2                                 ET03.1
Tran Exp Total       Transaction expense total.

ETH-TRAN-APP-TOTAL   Signed 15.2                                 ET03.1
Tran App Total       Transaction application total.

ETH-ACTIVITY         Alpha 15                                    ET03.1
Activity             Activities are the processes or
                     procedures that produce work. Cost
                     objects (products, services, customers,
                     and so on) are the reasons for
                     performing the activity. Activities and
                     cost object activities are used
                     synonymously in the Activity Management
                     system. Direct costs are posted to
                     activities, and indirect costs are
                     allocated to activities based on
                     activity drivers.

                     Activities are grouped or organized by
                     activity levels. There are two kinds of
                     activities: "posting allowed" and
                     "summary only." Use posting level
                     activities to budget and maintain all
                     posted transactions. Summary activities
                     or macro activities combine information
                     and balances from lower level activities
                     for reporting and inquiries.

ETH-ACCT-CATEGORY    Alpha 5                                     ET03.1
Account Category     Account categories are groupings of
                     costs, revenues, or a combination of
                     both used for reporting and inquiries
                     for activities in the Activity
                     Management system. All transactions are
                     posted to an account category within an
                     activity. You can assign a specific
                     General Ledger account or range of
                     accounts (company, accounting unit,
                     account, and subaccount) that make up
                     the transactions posted to an account
                     category using AC07.1 (Account
                     Assignment).

                     Period-to-date, year-to-date, and
                     life-to-date balances are maintained by
                     account category for activities. Account
                     categories must be assigned to
                     activities before you do any budgeting
                     or transaction processing.

                         EETRAVELHD FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ETHSET1   COMPANY       Used to access travel expenses.          ET03.1
          EXPENSE-NBR
          VENDOR
          BEFORE-AFTER