CMPUTE – Compute Statements
- System
- General Ledger (GL)
- Prefix
CMP- Primary key
COMPUTE-NAME- Fields
- 16
- Updated by
- 1 program
- Referenced by
- 89 programs
CMPUTE is the Compute Statements table in Lawson General Ledger (prefix CMP). It is indexed by COMPUTE-NAME (CMPSET1); alternate indexes: CMPSET2. It is related 1:1 to GLCODES and 1:M to CMPUTEAU. It is updated by RW50.1 and referenced by AC121, AC123, AC130, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 and 81 more. The table has 16 fields, 2 indexes and 2 documented relations.
About CMPUTE
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.
Fields (16)
Column = COBOL field name without the CMP- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
CMP-COMPUTE-NAME PKCOMPUTE_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-NAMEFOLDER_NAME | Alpha 12 | This is the name of a folder. Folders are defined in RW01.1 (Folder). | RW50.1 |
CMP-A-COMPUTEA_COMPUTE | Alpha 280 | A compute statement is an algebraic formula consisting of mathematical operators and Lawson data dictionary items. | RW50.1 |
CMP-CASE-CODECASE_CODE | Alpha 44 Occurs 40 Times ×40 | 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-CODEOP_CODE | Numeric 2 Occurs 40 Times ×40 | 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-FLAGAU_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-FLAGBUD_FLAG | Alpha 1 | This field indicates whether the budget number must be supplied. | RW50.1 |
CMP-DESCRIPTIONDESCRIPTION | Alpha 30 (Lower Case) | This is the description of the compute statement. | RW50.1 |
CMP-RW-USAGERW_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-USAGERA_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-USAGECA_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-USAGEFB_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-USAGEAC_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-USAGELM_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-USAGESL_USAGE | Alpha 1 | — | — |
CMP-DEFAULT-HEADNGDEFAULT_HEADNG | Alpha 32 (Lower Case) | Occurs 3 Times This default heading is used by the desktop Report Writer Designer. | RW50.1 |
Indexes (2)
Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
CMPSET1 | COMPUTE-NAME | Primary | AC121, AC123, AC130, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +22 more (list truncated in source) | |
CMPSET2 | FOLDER-NAME, COMPUTE-NAME | KeyChange | RW01.1, RW01.2, RW201, RW250 |
Relations
One to one (1) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Folder | GLCODES | Required | "F" → GCD-RECORD-TYPE, CMP-FOLDER-NAME → GCD-FOLDER-NAME, Spaces → GCD-PROCESS-GROUP, Spaces → GCD-SYSTEM, Zeroes → GCD-COMPANY |
One to many (1) — child tables
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Cmputeau | CMPUTEAU | CMP-COMPUTE-NAME → CTA-COMPUTE-NAME, CTA-ACTION, CTA-DATE, CTA-TIME, CTA-UNIQUE-I-D |
Programs
Updated by (1)
- RW50.1 Compute Statement
Referenced by (89)
- AC121 Budget Calculation
- AC123 Budget Copy
- AC130 Allocation Calculation
- AC20.1 Life Only Budget
- AC20.2 Annual Budget
- AC20.3 Period Budget
- AC20.4 Activity Budgets by Activity
- AC20.5 Activity Budgets by Account Category
- AC30.1 Allocation
- AC30.2 Multiple Pool Allocation
- AC30.3 List Allocation
- AC32.1 Allocation Pool
- AC37.1 Allocation Group
- AC490 Activity Reconciliation
- ACVW.1 Build GL Accounting Unit View
- AM00.1 Book
- AM00.2 Books
- AM180 Depreciation Calculation and Listing
- AM88.2 Book Dimension Definition
- ATVW.1 Build Account Category View
- CA10.1 Allocation
- CA10.5 Allocation Calculation
- CA10.7 Allocation Detail
- CA10.9 Allocation Driver
- CA110 Allocation Calculation
- FB01.1 Budget User Class
- FB01.2 Define User Class
- FB100 Budget Calculation - Computes
- FB120 Intracompany Mass Budgeting
- FB141 Remote Budget Consolidation
- FB20.1 Period Budget, Rate
- FB20.6 Period Budget, Amounts
- FB20.7 Period Budget, Units
- FB21.1 Budget by Period
- FB230 Computed by Accounting Unit Listing
- FB231 Computed by Account Listing
- FB30.1 Computed By Accounting Unit
- FB31.1 Computed By Account
- GL292 Balance Sheet
- GL293 Income Statement
- GL294 Projection by Level
- GL95.4 Chart Query
- GL99.1 Organization Query
- GLAV.1 Build GL Accounting Unit View
- GLCV.1 General Ledger Chart View Build
- GLVW.1 Build GL Accounting Unit View
- ML292 Ledger Balance Sheet
- ML293 Ledger Income Statement
- ML95.4 Ledger Chart Query
- ML99.1 Organization Query
- RW00.1 Report Writer
- RW00.6 Report Copy
- RW01.1 Folder
- RW01.2 Folders
- RW03.1 User Class
- RW03.2 Define User Class
- RW10.2 Account Rows
- RW10.3 Level Rows
- RW10.4 Both Rows
- RW10.8 Row Copy
- RW100 Report Generation
- RW11.1 Define Accounts Row
- RW11.2 Define Levels Row
- RW11.3 Define Both Type Row
- RW11.4 Line Copy
- RW20.1 Format
- RW20.2 Define Format
- RW20.8 Format Copy
- RW201 Folder Listing
- RW210 Row Listing
- RW220 Format Listing
- RW230 Ratio Listing
- RW250 Compute Listing
- RW298 Usage Report
- RW299 Detail Report Listing
- RW30.1 Ratio Definition
- RW40.1 Level Group
- RW40.3 Account Group
- RW40.4 Subaccount Group
- RW40.5 Group Copy
- RW40.6 Define Level Group
- RW40.7 Define Account Group
- RW40.8 Define Subaccount Group
- RW60.1 Total Range
- RW60.2 Define Total Range
- RW60.3 Total Range Copy
- RW70.1 Total Names
- SLVW.1 Build SL Accounting Unit View
- SNGL.1 General Ledger Notification Update