Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                             RADEFINE FILE

                           Ratio Definitions

This file contains the ratio total name, compute statements that are assigned
to the ratio total and amounts.


REFERENCED BY

GL85.1    RW298     RW01.1    RW01.2    RW201

UPDATED BY

RW230     RW30.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

RAD-RATIO-NAME       Alpha 10                                    RW298   RW30.1
Ratio                The name given to a ratio that is
                     defined in RA30.1 (Ratio Definition).


RAD-FOLDER-NAME      Alpha 12                                    RW30.1
Folder               The name of a folder defined in RW01.1
                     (Folder).


RAD-FISCAL-YEAR      Numeric 4                                   RW230   RW30.1
Fiscal Year          This is the fiscal year for the ratio
                     total.


RAD-DESCRIPTION      Alpha 30  (Lower Case)                      RW30.1
Ratio Description    The description of the ratio.

RAD-CALC-DATE        Numeric 8  (yyyymmdd)                       RW230   RW30.1
Last Calculated Date The date amounts were last calculated.

RAD-CALC-TIME        Numeric 6  (hhmmss)                         RW230   RW30.1
Last Calculated Time The time amounts were last calculated.

RAD-COMPUTE-NAME     Alpha 12                                    RW30.1
Comptute             The name assigned to an arithmetic
                     equation created in RW50 (Compute
                     Statement).  A compute statement
                     consists of data dictionary items and
                     operation symbols.


RAD-RATIO            Signed 15.5 Occurs 13 Times                 RW230   RW30.1
Ratio                The ratio values calculated by the
                     system.


                         RADEFINE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

RADSET1   RATIO-NAME                                             GL85.1  RW230
                                                                 RW298   RW30.1

RADSET2   FOLDER-NAME   KeyChange                                RW01.1  RW01.2
          RATIO-NAME                                             RW201   RW230

RADSET3   FISCAL-YEAR   KeyChange                                RW230
          RATIO-NAME

RADSET4   FOLDER-NAME   KeyChange                                RW230
          FISCAL-YEAR
          RATIO-NAME

                         RADEFINE FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Compute        CMPUTE       Required

                            RAD-COMPUTE-NAME    -> CMP-COMPUTE-NAME

Folder         GLCODES      Required

                            "F"                 -> GCD-RECORD-TYPE
                            RAD-FOLDER-NAME     -> GCD-FOLDER-NAME
                            Spaces              -> GCD-PROCESS-GROUP
                            Spaces              -> GCD-SYSTEM
                            Zeroes              -> GCD-COMPANY