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.

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
FOLDER_NAME		Alpha 12The name of a folder defined in RW01.1 (Folder).RW30.1
RAD-FISCAL-YEAR
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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
RADSET1RATIO-NAMEPrimaryFB01.1, FB01.2, FB141, GL292, GL293, GL294, GL85.1, GL95.4 +22 more (list truncated in source)
RADSET2FOLDER-NAME, RATIO-NAMEKeyChangeRW01.1, RW01.2, RW201, RW230
RADSET3FISCAL-YEAR, RATIO-NAMEKeyChangeRW230
RADSET4FOLDER-NAME, FISCAL-YEAR, RATIO-NAMEKeyChangeRW230

Relations

One to one (2) — lookups and parents

RelationTableRulesConditionField map
ComputeCMPUTERequiredRAD-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
RadefinauRADEFINAURAD-RATIO-NAME → RAA-RATIO-NAME, → RAA-ACTION, → RAA-DATE, → RAA-TIME, → RAA-UNIQUE-I-D

Programs

Updated by (2)

Referenced by (46)