Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                            EMPEXPENSE FILE

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

UPDATED BY

ET01.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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

ETC-EE-CATEGORY      Alpha 9                                     ET01.1
Ee Category          Expense category.

ETC-SEA-CATEGORY     Alpha 40                                    ET01.1
Sea Category         SEA category.

ETC-CATEGORY-TYPE    Alpha 1                                     ET01.1
Category Type        This field is used to set up the
                     default category type for the
                     Distribution File (EEDISTRIB).


ETC-CAT-STATUS       Alpha 1                                     ET01.1
Cat Status           Category status.

ETC-CATEGORY-NAME    Alpha 40                                    ET01.1
Category Name        Category name.

                         EMPEXPENSE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ETCSET1   COMPANY       Used to relate an EE expense catgory to  ET01.1
          EE-CATEGORY   a web expense category.
          SEA-CATEGORY
          CATEGORY-TYPE
          CAT-STATUS

ETCSET2   COMPANY       Used to relate a web expense category    ET01.1
          SEA-CATEGORY  to an EE expense category.
          EE-CATEGORY
          CATEGORY-TYPE
          CAT-STATUS