RADEFINE – Ratio Definitions

System
General Ledger (GL)
Prefix
RAD
Primary key
RATIO-NAME
Fields
8
Updated by
2 programs
Referenced by
46 programs

RADEFINE is the Ratio Definitions table in Lawson General Ledger (prefix RAD). It is indexed by RATIO-NAME (RADSET1); alternate indexes: RADSET2, RADSET3 and RADSET4. It is related 1:1 to CMPUTE and GLCODES and 1:M to RADEFINAU. It is updated by RW230 and RW30.1 and referenced by FB01.1, FB01.2, FB141, GL292, GL293, GL294, GL85.1, GL95.4 and 38 more. The table has 8 fields, 4 indexes and 3 documented relations.

About RADEFINE

This file contains the ratio total name, compute statements that are assigned to the ratio total and amounts.

Fields (8)

Column = COBOL field name without the RAD- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#RAD-RATIO-NAME PK
RATIO_NAME		Alpha 10The name given to a ratio that is defined in RA30.1 (Ratio Definition).RW298, RW30.1
#RAD-FOLDER-NAME SET2 SET4
FOLDER_NAME		Alpha 12The name of a folder defined in RW01.1 (Folder).RW30.1
#RAD-FISCAL-YEAR SET3 SET4
FISCAL_YEAR		Numeric 4This is the fiscal year for the ratio total.RW230, RW30.1
#RAD-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)The description of the ratio.RW30.1
#RAD-CALC-DATE
CALC_DATE		Numeric 8 (yyyymmdd)The date amounts were last calculated.RW230, RW30.1
#RAD-CALC-TIME
CALC_TIME		Numeric 6 (hhmmss)—RW230, RW30.1
#RAD-COMPUTE-NAME
COMPUTE_NAME		Alpha 12The name assigned to an arithmetic equation created in Compute Statement (RW50.1). A compute statement consists of data dictionary items and operation symbols.RW30.1
#RAD-RATIO
RATIO		Signed 15.5 Occurs 13 Times ×13The ratio values calculated by the system.RW230, RW30.1

Indexes (4)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
RADSET1
  1. RATIO-NAME
PrimaryFB01.1, FB01.2, FB141, GL292, GL293, GL294, GL85.1, GL95.4 +22 more (list truncated in source)
RADSET2
  1. FOLDER-NAME
  2. RATIO-NAME
KeyChangeRW01.1, RW01.2, RW201, RW230
RADSET3
  1. FISCAL-YEAR
  2. RATIO-NAME
KeyChangeRW230
RADSET4
  1. FOLDER-NAME
  2. FISCAL-YEAR
  3. RATIO-NAME
KeyChangeRW230

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
CMPUTEGLCODESRADEFINAURADEFINE

One to one (2) — lookups and parents

RelationTableRulesConditionField map
ComputeCMPUTERequired
RAD-COMPUTE-NAME→CMP-COMPUTE-NAME
FolderGLCODESRequired
"F"→GCD-RECORD-TYPE
RAD-FOLDER-NAME→GCD-FOLDER-NAME
Spaces→GCD-PROCESS-GROUP
Spaces→GCD-SYSTEM
Zeroes→GCD-COMPANY

One to many (1) — child tables

RelationTableRulesConditionField map
RadefinauRADEFINAU
RAD-RATIO-NAME→RAA-RATIO-NAME
—→RAA-ACTION
—→RAA-DATE
—→RAA-TIME
—→RAA-UNIQUE-I-D

Programs

Updated by (2)

Referenced by (46)