Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ETACTIVITY


                            ETACTIVITY FILE

REFERENCED BY

ET175     ET530     ET540     ET542

UPDATED BY

ET700

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

ETA-ACT-ID             Numeric 10
Element: Numeric 1

ETA-ACT-IMPT-ID        Numeric 10
Element: Numeric 1

ETA-ACT-CODE           Alpha 15                                  ET700
Element: Activity

ETA-ACT-DESC           Alpha 80                                  ET700
Element: Alpha 80

ETA-ACT-GROUP          Alpha 15                                  ET700
Element: Group

ETA-ACT-BILLABLE       Numeric 10                                ET700
Element: Numeric 1

ETA-ACT-SOURCE         Numeric 10                                ET700
Element: Numeric 1

ETA-ACT-MANAGER-ID     Numeric 10
Element: Numeric 1

ETA-ACT-STARTDATE      Numeric 8  (yyyymmdd)                     ET700
Element: Date

ETA-ACT-FINDATE        Numeric 8  (yyyymmdd)                     ET700
Element: Date

ETA-ACT-PROJ-CODE      Alpha 12
Element: Alpha 12

ETA-ACT-PROJ-DESC      Alpha 80
Element: Alpha 80

ETA-ACT-MGRREVEXP      Numeric 10                                ET700
Element: Numeric 1

ETA-ACT-MGRREVTIME     Numeric 10                                ET700
Element: Numeric 1

ETA-ACT-STATUS         Numeric 10                                ET700
Element: Numeric 1

ETA-ACT-GL-COMPANY     Numeric 10
Element: Numeric 1

ETA-ACT-ACCT-UNIT      Alpha 15
Element: Alpha 15

ETA-ACT-SELFASSIGN     Numeric 10                                ET700
Element: Numeric 1

ETA-ACT-CURRENCY       Numeric 10                                ET700
Element: Numeric 1

ETA-ACT-ENT-TYPE       Numeric 10                                ET700
Element: Numeric 1

ETA-ACT-ACCTCAT-ID     Numeric 10
Element: Numeric 1

ETA-ACT-REVCAT-ID      Numeric 10
Element: Numeric 1

ETA-ACT-CATGRP-ID      Numeric 10
Element: Numeric 1

                         ETACTIVITY FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ETASET1   ACT-ID                                                 ET175   ET530
                                                                 ET540   ET542

ETASET2   ACT-GROUP                                              ET700
          ACT-CODE
          ACT-ID