|
|
RADEFINE FILE
Ratio Definitions
This file contains the ratio total name, compute statements that are assigned
to the ratio total and amounts.
REFERENCED BY
GL85.1 RW298 RW01.1 RW01.2 RW201
UPDATED BY
RW230 RW30.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RAD-RATIO-NAME Alpha 10 RW298 RW30.1
Element: Ratio Name The name given to a ratio that is
defined in RA30.1 (Ratio Definition).
RAD-FOLDER-NAME Alpha 12 RW30.1
Element: Folder Name The name of a folder defined in RW01.1
(Folder).
RAD-FISCAL-YEAR Numeric 4 RW230 RW30.1
Element: Year This is the fiscal year for the ratio
total.
RAD-DESCRIPTION Alpha 30 (Lower Case) RW30.1
Element: Description The description of the ratio.
RAD-CALC-DATE Numeric 8 (yyyymmdd) RW230 RW30.1
Element: Calc Date The date amounts were last calculated.
RAD-CALC-TIME Numeric 6 (hhmmss) RW230 RW30.1
Element: Sys Time
RAD-COMPUTE-NAME Alpha 12 RW30.1
Element: Compute Name The name assigned to an arithmetic
equation created in Compute Statement
(RW50.1). A compute statement consists
of data dictionary items and operation
symbols.
RAD-RATIO Signed 15.5 Occurs 13 Times RW230 RW30.1
Element: Ratio The ratio values calculated by the
system.
RADEFINE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RADSET1 RATIO-NAME GL85.1 RW230
RW298 RW30.1
RADSET2 FOLDER-NAME KeyChange RW01.1 RW01.2
RATIO-NAME RW201 RW230
RADSET3 FISCAL-YEAR KeyChange RW230
RATIO-NAME
RADSET4 FOLDER-NAME KeyChange RW230
FISCAL-YEAR
RATIO-NAME
RADEFINE FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Compute CMPUTE Required
RAD-COMPUTE-NAME -> CMP-COMPUTE-NAME
Folder GLCODES Required
"F" -> GCD-RECORD-TYPE
RAD-FOLDER-NAME -> GCD-FOLDER-NAME
Spaces -> GCD-PROCESS-GROUP
Spaces -> GCD-SYSTEM
Zeroes -> GCD-COMPANY
|
