Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

CMPUTE


                              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
AC37.1    AC490     ACVW.1    AM00.1    AM00.2    AM180
AM88.2    CA10.1    CA10.5    CA10.7    CA10.9    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
Element: Compute Name  This is the name assigned to an
                       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
Element: Folder  Name  This is the name of a folder.

                       Folders are defined in RW01.1 (Folder).


CMP-A-COMPUTE          Alpha 280                                 RW50.1
Element: Compute StatemA 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
Element: 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
Element: Operation CodeThis 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
Element: Accounting UniThis 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
Element: 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
Element: Report Writer 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
Element: Ratio AnalysisThis 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
Lease Management       This field indicates whether the compute
Usage                  statement is used by Lease Management.

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

CMP-DEFAULT-HEADNG     Alpha 32  (Lower Case)                    RW50.1
Element: Default HeadinOccurs 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
                                                                 AC37.1  AC490
                                                                 ACVW.1  AM00.1
                                                                 AM00.2  AM180
                                                                 AM88.2  CA10.1
                                                                 CA10.5  CA10.7
                                                                 CA10.9  CA110
                                                                 FB100   FB120
                                                                 FB141   FB20.1
                                                                 FB20.6  FB20.7
                                                                 ...

CMPSET2   FOLDER-NAME   KeyChange                                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