|
|
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 AC127 AC130 AC20.1 AC20.2
AC20.3 AC20.4 AC22.1 AC30.2 AC30.3 AC32.1
ACVW.1 CA10.1 CA10.5 CA10.8 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
GLCV.1 GLVW.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 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
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
Allocations Usage 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
CMP-FB-USAGE Alpha 1 RW50.1
Budgeting Usage 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
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-DEFAULT-HEADNG Alpha 20 (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
AC127 AC130
AC20.1 AC20.2
AC20.3 AC20.4
AC22.1 AC30.2
AC30.3 AC32.1
ACVW.1 CA10.1
CA10.5 CA10.8
CA110 FB100
FB120 FB141
FB20.1 FB20.6
FB20.7 FB21.1
FB230 FB231
FB30.1 FB31.1
GL292 GL293
...
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
|