RWHEADER FILE
Report Writer Header
This file maintains Report Writer header information for Account Rows, Level
Rows, or Both Type Rows, Level Group, Account Group, Subaccount Group, Total
Range, or User Class.
REFERENCED BY
AC20.1 AC20.2 AC20.3 AC20.4 AC30.2 AC30.3
ACVW.1 CA10.1 CA10.8 RW00.1 RW00.2 RW100
RW20.5 RW20.6 RW240 RW260 RW299 RW70.1
GL87.1 GL88.1 GLCV.1 GLVW.1 RW01.1 RW01.2
RW201 FB95.1 FB95.2 FB95.3 FB95.4 FB95.5
FB95.6 GL55.1 GL95.1 GL95.2 GL95.3 GL95.4
GL95.5 GL95.6 GL95.7 GL95.8 GL95.9 GL96.1
GL96.2 GL96.3 GL96.4 GL96.5 GL97.1 GL97.2
GL97.3 GL97.4 GL97.5 GL97.6 GL97.7 GL97.8
GL97.9 GL98.1 GL98.2 GL98.3 GL98.4 GL98.5
GL99.1 GL99.2 GL99.3 GL99.4 GL99.5 GL99.6
RW298 FB20.2 FB201 GL256 RW203 RW215
UPDATED BY
FB01.2 RW03.2 RW10.2 RW10.3 RW10.4 RW10.8
RW11.1 RW11.2 RW11.3 RW11.4 RW210 RW40.1
RW40.3 RW40.4 RW40.5 RW40.6 RW40.7 RW40.8
RW60.1 RW60.2 RW60.3
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RWH-HEAD-TYPE Alpha 1 FB01.2 RW03.2
Head Type This field identifies if it is a Row RW10.2 RW10.3
Type, User Class, Total Range, or Group. RW10.4 RW11.1
RW11.2 RW11.3
RW40.6 RW40.7
G = Level, Acct or Subacct Group RW40.8 RW60.2
R = Row File
T = Total Range
U = User Class
B = Budget User Class
RWH-HEAD-NAME Alpha 12 FB01.2 RW03.2
Header This is the name of a level, account or RW10.2 RW10.3
subaccount group; row name; total range; RW10.4 RW10.8
or user class. RW11.1 RW11.2
RW11.3 RW40.5
RW40.6 RW40.7
RW40.8 RW60.2
RW60.3
RWH-RECORD-TYPE Alpha 1 RW10.2 RW10.3
Record This field identifies the type of RW10.4 RW11.1
record defined. RW11.2 RW11.3
RW40.6 RW40.7
A = Accounts RW40.8 RW60.2
B = Both Levels and Accts
L = Levels
R = Total Ranges
S = Subaccounts
RWH-RECORD-TYPE-1 Derived
Record This field is used for drill around. It
displays the Record Type field values.
RWH-FOLDER-NAME Alpha 12 RW10.2 RW10.3
folder This is the folder name as defined in RW10.4 RW10.8
RW01.1 (Folder). RW11.1 RW11.2
RW11.3 RW40.5
RW40.6 RW40.7
RW40.8 RW60.2
RW60.3
RWH-DESCRIPTION Alpha 30 (Lower Case) FB01.2 RW03.2
Header Description This is the folder description. RW10.2 RW10.3
RW10.4 RW10.8
RW100 RW11.1
RW11.2 RW11.3
RW40.5 RW40.6
RW40.7 RW40.8
RW60.2 RW60.3
RWH-PERSON-RESP Alpha 15 (Lower Case) RW100 RW40.6
Person Responsible This is the name of the person
responsible for this record.
RWH-NBR-LINES Numeric 6 RW10.2 RW10.3
Number of Lines This is the number of detail lines. RW10.4 RW11.4
RW40.1 RW40.3
RW40.4 RW60.1
RWH-LINE-NBR Numeric 6 RW10.2 RW10.3
Line Number This is the detail line number. RW10.4 RW11.4
RW210 RW40.1
RW40.3 RW40.4
RW40.6 RW40.7
RW40.8 RW60.1
RWHEADER FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RWHSET1 HEAD-TYPE AC20.1 AC20.2
HEAD-NAME AC20.3 AC20.4
RECORD-TYPE AC30.2 AC30.3
ACVW.1 CA10.1
CA10.8 RW00.1
RW00.2 RW10.2
RW10.3 RW10.4
RW10.6 RW10.7
RW10.8 RW100
RW11.1 RW11.2
RW11.3 RW11.4
RW20.5 RW20.6
RW210 RW240
RW260 RW299
RW40.1 RW40.2
...
RWHSET2 FOLDER-NAME KeyChange RW01.1 RW01.2
HEAD-TYPE RW201 RW260
HEAD-NAME
RECORD-TYPE
RWHSET3 HEAD-NAME FB95.1 FB95.2
HEAD-TYPE FB95.3 FB95.4
RECORD-TYPE FB95.5 FB95.6
GL55.1 GL95.1
GL95.2 GL95.3
GL95.4 GL95.5
GL95.6 GL95.7
GL95.8 GL95.9
GL96.1 GL96.2
GL96.3 GL96.4
GL96.5 GL97.1
GL97.2 GL97.3
GL97.4 GL97.5
GL97.6 GL97.7
GL97.8 GL97.9
...
RWHSET4 FOLDER-NAME KeyChange, Subset RW240
RECORD-TYPE Where HEAD-TYPE = "G"
HEAD-NAME
RWHSET5 FOLDER-NAME KeyChange, Subset RW11.1 RW11.2
HEAD-NAME Where HEAD-TYPE = "R" RW11.3 RW210
RECORD-TYPE
RWHSET6 FOLDER-NAME KeyChange, Subset RW260
HEAD-NAME Where HEAD-TYPE = "T"
RECORD-TYPE
RWHSET7 RECORD-TYPE KeyChange, Subset RW210
FOLDER-NAME Where HEAD-TYPE = "R"
HEAD-NAME
RWHSET8 HEAD-TYPE RW210 RW298
RECORD-TYPE
HEAD-NAME
RWHSET9 HEAD-TYPE FB01.1 FB01.2
HEAD-NAME FB20.2 FB201
GL256 RW01.1
RW01.2 RW03.1
RW03.2 RW10.2
RW10.3 RW10.4
RW11.1 RW11.2
RW11.3 RW201
RW203 RW215
RWHEADER FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Folder GLCODES Required
"F" -> GCD-RECORD-TYPE
RWH-FOLDER-NAME -> GCD-FOLDER-NAME
Spaces -> GCD-PROCESS-GROUP
Spaces -> GCD-SYSTEM
Zeroes -> GCD-COMPANY
RWHEADER FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Account Group RWGRPDET Delete Cascades
Valid When RWH-HEAD-TYPE = "G"
"A" -> RGD-RECORD-TYPE
RWH-HEAD-NAME -> RGD-HEAD-NAME
RGD-RANGE-NUMBER
Buduser Class RWUSER
Valid When RWH-HEAD-TYPE = "B"
RWH-HEAD-NAME -> RWU-USER-CLASS
RWU-USERNAME
Fbheader FBHEADER
Valid When RWH-HEAD-TYPE = "B"
RWH-HEAD-NAME -> FBH-USER-CLASS
FBH-COMPANY
FBH-FISCAL-YEAR
FBH-BUDGET-NBR
Level Group RWGRPDET Delete Cascades
Valid When RWH-HEAD-TYPE = "G"
"L" -> RGD-RECORD-TYPE
RWH-HEAD-NAME -> RGD-HEAD-NAME
RGD-RANGE-NUMBER
Row Request RWREQUEST Delete Restricted
Valid When RWH-HEAD-TYPE = "R"
RWH-HEAD-NAME -> RWR-ROW-FILE-NAME
RWR-REQUEST-NAME
Rowdetail RWROWDET Delete Cascades
Valid When RWH-HEAD-TYPE = "R"
RWH-RECORD-TYPE -> RRD-RECORD-TYPE
RWH-HEAD-NAME -> RRD-HEAD-NAME
RRD-LINE-NBR
Rwfolder GLCODES Delete Restricted
Valid When RWH-HEAD-TYPE = "U"
RWH-HEAD-NAME -> GCD-USER-CLASS
GCD-FOLDER-NAME
Subacct Group RWGRPDET Delete Cascades
Valid When RWH-HEAD-TYPE = "G"
"S" -> RGD-RECORD-TYPE
RWH-HEAD-NAME -> RGD-HEAD-NAME
RGD-RANGE-NUMBER
Total Ranges RWROWDET Delete Cascades
Valid When RWH-HEAD-TYPE = "T"
"R" -> RRD-RECORD-TYPE
RWH-HEAD-NAME -> RRD-HEAD-NAME
RRD-LINE-NBR
User Class RWUSER Delete Cascades
Valid When RWH-HEAD-TYPE = "U"
RWH-HEAD-NAME -> RWU-USER-CLASS
RWU-USERNAME
|