|
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
AC34.1 ACVW.1 ATVW.1 CA10.1 CA10.7 GL256
GL55.1 RW00.1 RW00.2 RW100 RW20.5 RW20.6
RW240 RW260 RW298 RW299 RW70.1 GLAV.1
GLCV.1 GLDM.3 GLVW.1 SLVW.1 RW01.1 RW01.2
RW201 FB11.1 FB111 FB160 FB211 FB296
FB60.1 FB95.1 FB95.2 FB95.3 FB95.4 FB95.5
FB95.6 GL298 GL90.6 GL94.1 GL94.2 GL94.3
GL94.4 GL94.5 GL94.6 GL94.7 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 FB20.2 FB201 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
Element: 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
Element: Head Name 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
Element: Record Type 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
Element: Record Type 1 This field is used for drill around. It
displays the Record Type field values.
RWH-FOLDER-NAME Alpha 12 RW10.2 RW10.3
Element: Folder Name 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
Element: Header DescripThis 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
Element: Person Resp This is the name of the person
responsible for this record.
RWH-NBR-LINES Numeric 6 RW10.2 RW10.3
Element: Nbr 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
Element: Line Nbr 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 AC34.1 ACVW.1
HEAD-NAME ATVW.1 CA10.1
RECORD-TYPE CA10.7 GL256
GL55.1 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 RW298
RW299 RW40.1
RW40.2 RW40.3
...
RWHSET2 FOLDER-NAME KeyChange RW01.1 RW01.2
HEAD-TYPE RW201 RW260
HEAD-NAME
RECORD-TYPE
RWHSET3 HEAD-NAME AC34.1 FB11.1
HEAD-TYPE FB111 FB160
RECORD-TYPE FB211 FB296
FB60.1 FB95.1
FB95.2 FB95.3
FB95.4 FB95.5
FB95.6 GL298
GL55.1 GL90.6
GL94.1 GL94.2
GL94.3 GL94.4
GL94.5 GL94.6
GL94.7 GL95.1
GL95.2 GL95.3
GL95.4 GL95.5
GL95.6 GL95.7
...
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
|