Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

RADEFINE


                             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
Element: Base Name     The name given to a ratio that is
                       defined in RA30.1 (Ratio Definition).


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


RAD-FISCAL-YEAR        Numeric 4                                 RW230   RW30.1
Element: Last Closed YeThis is the fiscal year for the ratio
                       total.


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

RAD-CALC-DATE          Numeric 8  (yyyymmdd)                     RW230   RW30.1
Element: Date

RAD-CALC-TIME          Numeric 6  (hhmmss)                       RW230   RW30.1
Element: Sys Time

RAD-COMPUTE-NAME       Alpha 12                                  RW30.1
Element: Name User

RAD-RATIO              Signed 15.5 Occurs 13 Times               RW230   RW30.1
Element: 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