Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ETASSIGN


                             ETASSIGN FILE

REFERENCED BY

ET530     ET540

UPDATED BY

ET700

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

ETG-ASGN-ID            Numeric 10
Element: Numeric 1

ETG-ASGN-IMPT-ID       Numeric 10
Element: Numeric 1

ETG-ASGN-ACT-ID        Numeric 10                                ET700
Element: Numeric 1

ETG-ASGN-RES-ID        Numeric 10                                ET700
Element: Numeric 1

ETG-ASGN-ROLE-ID       Numeric 10
Element: Numeric 1

ETG-ASGN-SOURCE        Numeric 5                                 ET700
Element: Numeric

ETG-ASGN-HOURS         Signed 7.2
Element: Hours

ETG-ASGN-STARTDATE     Numeric 8  (yyyymmdd)                     ET700
Element: Date

ETG-ASGN-FINDATE       Numeric 8  (yyyymmdd)                     ET700
Element: Date

ETG-ASGN-PAY-CODE      Alpha 10
Element: Alpha 10

ETG-ASGN-ACCTCATID     Numeric 10
Element: Numeric 1

ETG-ASGN-REVCAT-ID     Numeric 10
Element: Numeric 1

                         ETASSIGN FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ETGSET1   ASGN-ID                                                ET530   ET540