RADEFINE

Ratio Definitions

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

REFERENCED BY
FB01.1 FB01.2 FB141 GL292 GL293 GL294
GL85.1 GL95.4 GL99.1 RW00.1 RW00.6 RW03.1
RW03.2 RW10.2 RW10.3 RW10.4 RW10.8 RW11.1
RW11.2 RW11.3 RW11.4 RW20.1 RW20.2 RW20.8
RW210 RW298 RW40.1 RW40.3 RW40.4 RW40.5
RW40.6 RW40.7 RW40.8 RW50.1 RW60.1 RW60.2
RW60.3 RW70.1 ML292 ML293 ML95.4 ML99.1
SNGL.1 RW01.1 RW01.2 RW201


UPDATED BY
RW230 RW30.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RAD-RATIO-NAME
Element: Ratio Name
Alpha 10
The name given to a ratio that is defined in RA30.1 (Ratio Definition).
RW298 RW30.1
RAD-FOLDER-NAME
Element: Folder Name
Alpha 12
The name of a folder defined in RW01.1 (Folder).
RW30.1
RAD-FISCAL-YEAR
Element: Year
Numeric 4
This is the fiscal year for the ratio total.
RW230 RW30.1
RAD-DESCRIPTION
Element: Description
Alpha 30 (Lower Case)
The description of the ratio.
RW30.1
RAD-CALC-DATE
Element: Calc Date
Numeric 8 (yyyymmdd)
The date amounts were last calculated.
RW230 RW30.1
RAD-CALC-TIME
Element: Sys Time
Numeric 6 (hhmmss)
RW230 RW30.1
RAD-COMPUTE-NAME
Element: Compute Name
Alpha 12
The 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
Element: Ratio
Signed 15.5 Occurs 13 Times
The ratio values calculated by the system.
RW230 RW30.1


RADEFINE FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RADSET1 RATIO-NAME
...
FB01.1 FB01.2
FB141 GL292
GL293 GL294
GL85.1 GL95.4
GL99.1 RW00.1
RW00.6 RW03.1
RW03.2 RW10.2
RW10.3 RW10.4
RW10.8 RW11.1
RW11.2 RW11.3
RW11.4 RW20.1
RW20.2 RW20.8
RW210 RW230
RW298 RW30.1
RW40.1 RW40.3
RADSET2 FOLDER-NAME
RATIO-NAME
KeyChange
RW01.1 RW01.2
RW201 RW230
RADSET3 FISCAL-YEAR
RATIO-NAME
KeyChange
RW230
RADSET4 FOLDER-NAME
FISCAL-YEAR
RATIO-NAME
KeyChange
RW230


RADEFINE FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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


RADEFINE FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Radefinau RADEFINAU
RAD-RATIO-NAME->RAA-RATIO-NAME
  RAA-ACTION
  RAA-DATE
  RAA-TIME
  RAA-UNIQUE-I-D


File created: Thu Jun 09 02:14:17 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.