Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            EETRAVELHD FILE

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  (Right Justified)                  ET03.1
Vendor ID            The vendor's identification code.



ETH-BEFORE-AFTER     Alpha 1                                     ET03.1
Before After

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

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 Company
                     (GL10.1 ).

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

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

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

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

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

ETH-TRAN-APP-TOTAL   Signed 15.2                                 ET03.1
Tran App 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.


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                                                ET03.1
          EXPENSE-NBR
          VENDOR
          BEFORE-AFTER