Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

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 Name           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
Description          The description of the ratio.

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

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

RAD-COMPUTE-NAME     Alpha 12                                    RW30.1
Compute Statement    The name assigned to an arithmetic
Name                 equation created in Compute Statement
                     (RW50.1).  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