Lawson Insight Technical Documentation

                            ETTIMECARD FILE

REFERENCED BY

ET530     ET540

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

TCR-TC-ID              Numeric 10
Element: Numeric 1

TCR-TC-RES-ID          Numeric 10
Element: Numeric 1

TCR-TC-NAME            Alpha 50
Element: Alpha 50

TCR-TC-PAYPERIOD       Numeric 5
Element: Numeric

TCR-TC-BEGIN-DATE      Numeric 8  (yyyymmdd)
Element: Date

TCR-TC-END-DATE        Numeric 8  (yyyymmdd)
Element: Date

TCR-TC-BILL-HOURS      Signed 7.2
Element: Hours

TCR-TC-PAY-HOURS       Signed 7.2
Element: Hours

TCR-TC-BILL-STATUS     Numeric 5
Element: Numeric

TCR-TC-PAY-STATUS      Numeric 5
Element: Numeric

TCR-TC-TYPE            Numeric 5
Element: Numeric

TCR-TC-RELATED-TC      Numeric 10
Element: Numeric 1

TCR-TC-PAYROLL-ID      Numeric 10
Element: Numeric 1

TCR-TC-COMMENT-IND     Numeric 10
Element: Numeric 1

TCR-TC-TEMPID          Alpha 40
Element: Alpha 40

TCR-TC-DISP-ID         Numeric 10
Element: Numeric 1

TCR-TC-INVOICE         Alpha 30
Element: Alpha 30

TCR-TC-ERRFLAG         Numeric 10
Element: Numeric 1

TCR-TC-PAYAPPRDATE     Numeric 8  (yyyymmdd)
Element: Date

TCR-TC-BILAPPRDATE     Numeric 8  (yyyymmdd)
Element: Date

TCR-TC-MOD-ID          Numeric 10
Element: Numeric 1

TCR-TC-MOD-DATE        Numeric 8  (yyyymmdd)
Element: Date

TCR-TC-INTERR          Numeric 10
Element: Numeric 1

                         ETTIMECARD FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

TCRSET1   TC-ID                                                  ET530   ET540