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

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 UniThe general ledger accounting unit that
                       defaults to all expense accounts
                       entered.

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 CodeA 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
Element: Description

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

ETH-END-DATE           Numeric 8  (yyyymmdd) Occurs 3 Times      ET03.1
Element: Ending Date   The end date for this effort period.

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 18.2                               ET03.1
Element: Intl Amt

ETH-TRAN-APP-TOTAL     Signed 18.2                               ET03.1
Element: Intl Amt

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.

                       Valid account category types are:
                       cost
                       revenue
                       accrual
                       pass thru

                         EETRAVELHD FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ETHSET1   COMPANY                                                ET03.1
          EXPENSE-NBR
          VENDOR
          BEFORE-AFTER