Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

EETRAVELHD


                            EETRAVELHD FILE

UPDATED BY

ET03.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

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

ETH-EXPENSE-NBR        Alpha 10                                  ET03.1
Element: Expense NumberThe expense report number.

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



ETH-BEFORE-AFTER       Alpha 1                                   ET03.1
Element: Account Flag

ETH-DEF-ACCT-UNIT      Alpha 15                                  ET03.1
Element: Accounting Unit

ETH-BILLABLE           Alpha 1                                   ET03.1
Element: Billable Indicator

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

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

ETH-APPROVAL-CODE      Alpha 3                                   ET03.1
Element: Authority Code

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

ETH-BEG-DATE           Numeric 8  (yyyymmdd) Occurs 3 Times      ET03.1
Element: Date

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

ETH-EE-COMMENT         Alpha 60 Occurs 3 Times                   ET03.1
Element: Ee Comment

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

ETH-EE-STATUS          Alpha 1                                   ET03.1
Element: Account Flag

ETH-TRAN-EXP-TOTAL     Signed 15.2                               ET03.1
Element: Tran App Total

ETH-TRAN-APP-TOTAL     Signed 15.2                               ET03.1
Element: Tran App Total

ETH-ACTIVITY           Alpha 15                                  ET03.1
Element: 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
Element: Account CategoAccount 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