RWHEADER

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
CA10.1 CA10.7 FB11.1 FB111 FB160 FB211
FB296 FB60.1 FB95.1 FB95.2 FB95.3 FB95.4
FB95.5 FB95.6 GL194 GL256 GL291 GL292
GL293 GL298 GL299 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 AC34.1 ACVW.1 ATVW.1
GL55.1 RW00.1 RW00.2 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
AD290 AD50.1 AD95.1 AD96.1 AD97.1 AD97.2
AD97.3 AD98.1 AD98.2 AD98.3 ML94.1 ML94.2
ML94.3 ML94.4 ML95.1 ML95.2 ML95.3 ML95.4
ML95.5 ML95.6 ML95.7 ML95.8 ML95.9 ML96.1
ML96.2 ML96.3 ML96.4 ML96.5 ML97.1 ML97.2
ML97.3 ML97.4 ML97.5 ML97.6 ML97.7 ML97.8
ML97.9 ML98.1 ML98.2 ML98.3 ML98.4 ML98.5
ML99.1 ML99.2 ML99.3 ML99.4 ML99.5 ML99.6
FB20.2 FB201 RW203 RW215


UPDATED BY
FB01.2 RW03.2 RW10.2 RW10.3 RW10.4 RW10.8
RW100 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
Element: Head Type
Alpha 1
This field identifies if it is a Row Type, User Class, Total Range, or Group.
G = Level, Acct or Subacct Group
R = Row File
T = Total Range
U = User Class
B = Budget User Class
FB01.2 RW03.2
RW10.2 RW10.3
RW10.4 RW11.1
RW11.2 RW11.3
RW40.6 RW40.7
RW40.8 RW60.2
RWH-HEAD-NAME
Element: Head Name
Alpha 12
This is the name of a level, account or subaccount group; row name; total range; or user class.
FB01.2 RW03.2
RW10.2 RW10.3
RW10.4 RW10.8
RW11.1 RW11.2
RW11.3 RW40.5
RW40.6 RW40.7
RW40.8 RW60.2
RW60.3
RWH-RECORD-TYPE
Element: Record Type
Alpha 1
This field identifies the type of record defined.
A = Accounts
B = Both Levels and Accts
L = Levels
R = Total Ranges
S = Subaccounts
RW10.2 RW10.3
RW10.4 RW11.1
RW11.2 RW11.3
RW40.6 RW40.7
RW40.8 RW60.2
RWH-RECORD-TYPE-1
Element: Record Type 1
Derived
This field is used for drill around. It displays the Record Type field values.
RWH-FOLDER-NAME
Element: Folder Name
Alpha 12
This is the folder name as defined in RW01.1 (Folder).
RW10.2 RW10.3
RW10.4 RW10.8
RW11.1 RW11.2
RW11.3 RW40.5
RW40.6 RW40.7
RW40.8 RW60.2
RW60.3
RWH-DESCRIPTION
Element: Header Description
Alpha 30 (Lower Case)
This is the folder description.
FB01.2 RW03.2
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
Element: Person Resp
Alpha 15 (Lower Case)
This is the name of the person responsible for this record.
RW100 RW40.6
RWH-NBR-LINES
Element: Nbr Lines
Numeric 6
This is the number of detail lines.
RW10.2 RW10.3
RW10.4 RW11.4
RW40.1 RW40.3
RW40.4 RW60.1
RWH-LINE-NBR
Element: Line Nbr
Numeric 6
This is the detail line number.
RW10.2 RW10.3
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
HEAD-NAME
RECORD-TYPE
...
AC34.1 ACVW.1
ATVW.1 CA10.1
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
HEAD-TYPE
HEAD-NAME
RECORD-TYPE
KeyChange
RW01.1 RW01.2
RW201 RW260
RWHSET3 HEAD-NAME
HEAD-TYPE
RECORD-TYPE
...
AC34.1 AD290
AD50.1 AD95.1
AD96.1 AD97.1
AD97.2 AD97.3
AD98.1 AD98.2
AD98.3 FB11.1
FB111 FB160
FB211 FB296
FB60.1 FB95.1
FB95.2 FB95.3
FB95.4 FB95.5
FB95.6 GL194
GL291 GL292
GL293 GL298
GL299 GL55.1
RWHSET4 FOLDER-NAME
RECORD-TYPE
HEAD-NAME
KeyChange, Subset
WhereHEAD-TYPE ="G"
RW240
RWHSET5 FOLDER-NAME
HEAD-NAME
RECORD-TYPE
KeyChange, Subset
WhereHEAD-TYPE ="R"
RW11.1 RW11.2
RW11.3 RW210
RWHSET6 FOLDER-NAME
HEAD-NAME
RECORD-TYPE
KeyChange, Subset
WhereHEAD-TYPE ="T"
RW260
RWHSET7 RECORD-TYPE
FOLDER-NAME
HEAD-NAME
KeyChange, Subset
WhereHEAD-TYPE ="R"
RW210
RWHSET8 HEAD-TYPE
RECORD-TYPE
HEAD-NAME
RW210 RW298
RWHSET9 HEAD-TYPE
HEAD-NAME
FB01.1 FB01.2
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
NAME
RELATED 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
NAME
RELATED 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


File created: Thu Jun 09 11:13:34 2016

Home
Contact Us



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