Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

TRNOVERDTL


                            TRNOVERDTL FILE

REFERENCED BY

HCHP.1

UPDATED BY

HC02.5    HC02.2    HC02.6    HC10.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

TOD-MEAS-OBJ-ID        Numeric 12                                HC02.5  HC10.1
Element: Obj Id        This is the object identifier. It is
                       used to relate commitments or posted
                       transactions back to the originating
                       subsystems. Each subsystem record that
                       is updated as a commitment or posted
                       transaction is assigned an object
                       identifier. The object identifier is
                       maintained in the subsystem files and in
                       the Activity Commitments Detail and
                       Activity Transaction files. The object
                       identifier is a unique key used to drill
                       back from Activity Management to the
                       subsystems.

TOD-GROUP-NAME         Alpha 50  (Lower Case)                    HC02.5  HC10.1
Element: Member Name   This is an override member name for
                       Data Mart dimensions with no association
                       to a Budget dimension.

TOD-SEQ-NBR            Numeric 4                                 HC02.5  HC10.1
Element: Seq Nbr       An automatically assigned sequence
                       number.

TOD-NBR-FIELD-KEY      Numeric 1                                 HC02.5  HC10.1
Element: Nbr Field Key

TOD-INC-EXC-FLAG       Alpha 1                                   HC02.5  HC10.1
Element: Inc Exc Flag

TOD-BEG-VALUE          Alpha 25                                  HC02.5  HC10.1
Element: Beg Value

TOD-END-VALUE          Alpha 25                                  HC02.5  HC10.1
Element: End Value                                               HCHP.1

TOD-DTL-GROUPING       Alpha 2                                   HC02.5  HC10.1
Element: Dtl Grouping

                         TRNOVERDTL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

TODSET1   MEAS-OBJ-ID                                            HC02.2  HC02.5
          GROUP-NAME                                             HC02.6
          SEQ-NBR

TODSET2   MEAS-OBJ-ID                                            HC02.5  HCHP.1
          GROUP-NAME
          DTL-GROUPING
          SEQ-NBR

TODSET3   MEAS-OBJ-ID
          NBR-FIELD-KEY
          GROUP-NAME
          DTL-GROUPING
          SEQ-NBR