Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                              CMPUTE FILE

                           Compute Statements

This file contains compute statements, which are a combination of data
dictionary items and mathematical operations. RW50.1 (Compute Statement)
updates this file. This file is shared by the Allocations, Report Writer,
Ratio Analysis, and Budgeting applications.


REFERENCED BY

AC121     AC123     AC130     AC20.1    AC20.2    AC20.3
AC20.4    AC20.5    AC30.1    AC30.2    AC30.3    AC32.1
AC490     ACVW.1    AM00.1    AM00.2    AM180     AM88.2
CA10.1    CA10.5    CA10.7    CA110     FB100     FB120
FB141     FB20.1    FB20.6    FB20.7    FB21.1    FB230
FB231     FB30.1    FB31.1    GL292     GL293     GL294
GL95.4    GL99.1    RW100     RW20.1    RW20.2    RW220
RW230     RW250     RW298     RW299     RW30.1    GLAV.1
GLCV.1    GLVW.1    SLVW.1    RW01.1    RW01.2    RW201

UPDATED BY

RW50.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

CMP-COMPUTE-NAME     Alpha 12                                    RW50.1
Compute Statement    This is the name assigned to an
Name                 algebraic equation created in RW50.1
                     (Compute  Statement). A compute
                     statement consists of data dictionary
                     items and mathematical operation
                     symbols.


CMP-FOLDER-NAME      Alpha 12                                    RW50.1
Folder               This is the name of a folder.

                     Folders are defined in RW01.1 (Folder).


CMP-A-COMPUTE        Alpha 280                                   RW50.1
Compute Statement    A compute statement is an algebraic
                     formula consisting of mathematical
                     operators and Lawson data dictionary
                     items.


CMP-CASE-CODE        Alpha 44 Occurs 40 Times                    RW50.1
Case Code            A case code represents internal data
                     dictionary information. Case codes are
                     used to access data dictionary items
                     requested in the compute statement.


CMP-OP-CODE          Numeric 2 Occurs 40 Times                   RW50.1
Operation Code       This is the internal operation code.
                     Operation codes are used in compute
                     statements, which can be defined in
                     RW50.1 (Compute Statement).


CMP-AU-FLAG          Numeric 1                                   RW50.1
Accounting Unit Flag This field indicates whether to
                     override the default accounting unit in
                     the computation.

                     Use 1 to override the defined accounting
                     unit. Use 2 to override the generic
                     accounting unit defined.



CMP-BUD-FLAG         Alpha 1                                     RW50.1
Budget Flag          This field indicates whether the budget
                     number must be supplied.


CMP-DESCRIPTION      Alpha 30  (Lower Case)                      RW50.1
Compute Statement    This is the description of the compute
Description          statement.


CMP-RW-USAGE         Alpha 1                                     RW50.1
Report Writer Usage  This field determines whether this
                     compute statement is used by Report
                     Writer.

                     Use X in this field to indicate that the
                     compute statement is used by Report
                     Writer.


                     X

CMP-RA-USAGE         Alpha 1                                     RW50.1
Ratio Analysis Usage This field determines whether the
                     compute statement is used by Ratio
                     Analysis.

                     Use X in this field to indicate that the
                     compute statement is used by Ratio
                     Analysis.


                     X

CMP-CA-USAGE         Alpha 1                                     RW50.1
Cost Allocations     This field determines whether the
Usage                compute statement is used by
                     Allocations.

                     Use X in this field to indicate that the
                     compute statement is used by
                     Allocations.


                     X

CMP-FB-USAGE         Alpha 1                                     RW50.1
Flexible Budgeting   This field determines whether the
Usage                compute statement is used by Budgeting.

                     Use X in this field to indicate that the
                     compute statement is used by Budgeting.


                     X

CMP-AC-USAGE         Alpha 1                                     RW50.1
Activity Management  This field indicates whether the
Usage                compute statement is used by Activity
                     Management.

                     Use X in this field to indicate that the
                     compute statement is used by Activity
                     Management.


                     X

CMP-LM-USAGE         Alpha 1                                     RW50.1
Lm Usage

CMP-DEFAULT-HEADNG   Alpha 32  (Lower Case)                      RW50.1
Default Heading      Occurs 3 Times
                     This default heading is used by the
                     desktop Report Writer Designer.


                         CMPUTE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CMPSET1   COMPUTE-NAME                                           AC121   AC123
                                                                 AC130   AC20.1
                                                                 AC20.2  AC20.3
                                                                 AC20.4  AC20.5
                                                                 AC30.1  AC30.2
                                                                 AC30.3  AC32.1
                                                                 AC490   ACVW.1
                                                                 AM00.1  AM00.2
                                                                 AM180   AM88.2
                                                                 CA10.1  CA10.5
                                                                 CA10.7  CA110
                                                                 FB100   FB120
                                                                 FB141   FB20.1
                                                                 FB20.6  FB20.7
                                                                 FB21.1  FB230
                                                                 ...

CMPSET2   FOLDER-NAME                                            RW01.1  RW01.2
          COMPUTE-NAME                                           RW201   RW250

                         CMPUTE FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Folder         GLCODES      Required

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