CMPUTE

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 ATVW.1 AM00.1 AM00.2
AM180 AM88.2 CA10.1 CA10.5 CA10.7 CA10.9
CA110 FB01.1 FB01.2 FB100 FB120 FB141
FB20.1 FB20.6 FB20.7 FB21.1 FB230 FB231
FB30.1 FB31.1 GL292 GL293 GL294 GL95.4
GL99.1 RW00.1 RW00.6 RW03.1 RW03.2 RW10.2
RW10.3 RW10.4 RW10.8 RW100 RW11.1 RW11.2
RW11.3 RW11.4 RW20.1 RW20.2 RW20.8 RW210
RW220 RW230 RW250 RW298 RW299 RW30.1
RW40.1 RW40.3 RW40.4 RW40.5 RW40.6 RW40.7
RW40.8 RW60.1 RW60.2 RW60.3 RW70.1 GLAV.1
GLCV.1 GLVW.1 ML292 ML293 ML95.4 ML99.1
SLVW.1 SNGL.1 RW01.1 RW01.2 RW201


UPDATED BY
RW50.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CMP-COMPUTE-NAME
Element: Compute Name
Alpha 12
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.
RW50.1
CMP-FOLDER-NAME
Element: Folder Name
Alpha 12
This is the name of a folder. Folders are defined in RW01.1 (Folder).
RW50.1
CMP-A-COMPUTE
Element: Compute Statement
Alpha 280
A compute statement is an algebraic formula consisting of mathematical operators and Lawson data dictionary items.
RW50.1
CMP-CASE-CODE
Element: Case Code
Alpha 44 Occurs 40 Times
A case code represents internal data dictionary information. Case codes are used to access data dictionary items requested in the compute statement.
RW50.1
CMP-OP-CODE
Element: Operation Code
Numeric 2 Occurs 40 Times
This is the internal operation code. Operation codes are used in compute statements, which can be defined in RW50.1 (Compute Statement).
RW50.1
CMP-AU-FLAG
Element: Accounting Unit Flag
Numeric 1
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.
RW50.1
CMP-BUD-FLAG
Element: Budget Flag
Alpha 1
This field indicates whether the budget number must be supplied.
RW50.1
CMP-DESCRIPTION
Compute Statement
Description
Alpha 30 (Lower Case)
This is the description of the compute statement.
RW50.1
CMP-RW-USAGE
Element: Report Writer Usage
Alpha 1
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
RW50.1
CMP-RA-USAGE
Element: Ratio Analysis Usage
Alpha 1
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
RW50.1
CMP-CA-USAGE
Cost Allocations
Usage
Alpha 1
This field determines whether the compute statement is used by Allocations. Use X in this field to indicate that the compute statement is used by Allocations.
X
RW50.1
CMP-FB-USAGE
Flexible Budgeting
Usage
Alpha 1
This field determines whether the compute statement is used by Budgeting. Use X in this field to indicate that the compute statement is used by Budgeting.
X
RW50.1
CMP-AC-USAGE
Activity Management
Usage
Alpha 1
This field indicates whether the compute statement is used by Activity Management. Use X in this field to indicate that the compute statement is used by Activity Management.
X
RW50.1
CMP-LM-USAGE
Lease Management
Usage
Alpha 1
This field indicates whether the compute statement is used by Lease Management. Use X in this field to indicate that the compute statement is used by Lease Management.
RW50.1
CMP-SL-USAGE
Element: Sl Usage
Alpha 1
CMP-DEFAULT-HEADNG
Element: Default Heading
Alpha 32 (Lower Case)
Occurs 3 Times
This default heading is used by the desktop Report Writer Designer.
RW50.1


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 ATVW.1
AM00.1 AM00.2
AM180 AM88.2
CA10.1 CA10.5
CA10.7 CA10.9
CA110 FB01.1
FB01.2 FB100
FB120 FB141
CMPSET2 FOLDER-NAME
COMPUTE-NAME
KeyChange
RW01.1 RW01.2
RW201 RW250


CMPUTE FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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


CMPUTE FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Cmputeau CMPUTEAU
CMP-COMPUTE-NAME->CTA-COMPUTE-NAME
  CTA-ACTION
  CTA-DATE
  CTA-TIME
  CTA-UNIQUE-I-D


File created: Thu Jun 09 02:13:38 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.