|
|
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 ATVW.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
SNGL.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-SL-USAGE Alpha 1
Element: Sl Usage
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 ATVW.1
AM00.1 AM00.2
AM180 AM88.2
CA10.1 CA10.5
CA10.7 CA10.9
CA110 FB100
FB120 FB141
FB20.1 FB20.6
...
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
|
