RWFORMAT FILE
Report Writer Format
This file maintains the vertical, or format and columns, portion of a Report
Writer report. It includes information on format description, format heading,
and column detail defined in RW20.1 (Format).
If the value for a field is the default, the value used in the report column
is the default for the field as defined in the header record. If the value for
the field is a non-default value, the non-default value overrides the default
in the column.
REFERENCED BY
ACVW.1 RW00.1 RW100 RW220 RW298 RW299
GLAV.1 GLCV.1 GLVW.1 SLVW.1 RW01.1 RW01.2
RW201
UPDATED BY
FB141 GL292 GL293 GL294 GL95.4 GL99.1
RW20.1 RW20.2 RW20.8
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RWF-FORMAT Alpha 12 FB141 GL292
Format This is the name that identifies the GL293 GL294
format as defined in RW20.1 (Format). GL95.4 GL99.1
RW20.1 RW20.2
RW20.8 RW298
RWF-RECORD-TYPE Alpha 1 FB141 GL292
Record Type This field indicates the type of record GL293 GL294
defined. GL95.4 GL99.1
RW20.1 RW20.2
1 = Format Description RW298
2 = Format Heading
3 = Column Detail
RWF-LINE-NBR Numeric 6 FB141 GL292
Line Number This field contains the column line GL293 GL294
number. GL95.4 GL99.1
RW20.1 RW20.2
000001 RW298
000050
RWF-FOLDER-NAME Alpha 12 RW20.2 RW20.8
Folder Name This is the name of a folder defined in
RW01.1 (Folder).
RWF-DICT-FLAG Alpha 1 FB141 GL292
Dictionary Flag This field is Y (Yes) if the record GL293 GL294
type is Format Heading and dictionary GL95.4 GL99.1
items are contained in the heading. RW20.1 RW20.2
RWF-COL-POSITION Numeric 3 FB141 GL292
Column Position This is the amount of space between GL293 GL294
columns. GL95.4 GL99.1
RW20.1 RW20.2
RWF-SIZE Numeric 2 FB141 GL292
Size This field indicates the width of the GL293 GL294
column. GL95.4 GL99.1
RW20.1 RW20.2
RWF-TOTAL-TYPE Alpha 1 FB141 GL292
Total Type This field determines how column totals GL293 GL294
are calculated and printed. GL95.4 GL99.1
RW20.1 RW20.2
The default is Sum Down, which adds the
net or rounded result of each value.
Recalculate adds the original or
unrounded amount of each value.
Do Not Print does not print totals.
" " = Default
S = Sum Down
R = Recalculate Across
N = No Totals
RWF-DATA-TYPE Alpha 1 FB141 GL292
Data Type Required if the record type is Column GL293 GL294
Detail. This is the type of data for the GL95.4 GL99.1
record. RW20.1 RW20.2
A = Alpha/Numeric Field
N = Numeric Field
RWF-DECIMALS Numeric 1 FB141 GL292
Number of Decimals This field determines the number of GL293 GL294
decimals for column amounts. For GL95.4 GL99.1
example, if you select 3, the value 100 RW20.1 RW20.2
appears as 100.00.
The default is No Decimals.
0 = No Decimals
1 = One Decimal
2 = Two Decimals
3 = Three Decimals
4 = Four Decimals
5 = Five Decimals
9 = Default
RWF-UNDERLINE Alpha 1 FB141 GL292
Underline This field determines whether columns GL293 GL294
are underlined. The default is Yes. GL95.4 GL99.1
RW20.1 RW20.2
To allow underlining, you must select
Yes in this field and the row line Type
must be Underline.
If you select yes, each column heading
is underlined, a line is placed above
the row total, after the last row total,
and after the column total.
" " = Default
Y = Yes
N = No
RWF-SIGN Alpha 1 FB141 GL292
Sign This field determines how negative GL293 GL294
values are represented in the report. GL95.4 GL99.1
RW20.1 RW20.2
The default is Dash -. For example, if
you have a debit of $200.00, the value
appears as $200.00-.
" " = Default
C = CR
( = () Brackets
< = <> Brackets
U = Unfavorable
- = Dash
N = No Sign
RWF-COMMAS Alpha 1 FB141 GL292
Commas This field determines if commas are GL293 GL294
used in column amounts. If you select GL95.4 GL99.1
Yes, the value 1000 appears as 1,000. RW20.1 RW20.2
The default is No.
" " = Default
N = No
Y = Yes
RWF-OFFSET Alpha 1 FB141 GL292
Offset This field determines what side totals GL293 GL294
are justified at. The default is None. GL95.4 GL99.1
RW20.1 RW20.2
You can select to justify totals to the
left and right.
" " = Default
R = Right Offset
L = Left Offset
N = No Offset
RWF-DOL-PCT-SIGN Alpha 1 FB141 GL292
Dollar or Percent This field determines the symbol that GL293 GL294
Sign appears in the first line for each row GL95.4 GL99.1
in the column, the row total, and the RW20.1 RW20.2
first line in the next row following the
total. For example, if you select $:
Row Names in Column One Column Two
TOTAL CORPORATE
Corporate $20,000
Administration 7,000
Human Resources 3,000
MIS 1,000
Total Corporate $31,000
HOSPITALS' DEPTS
Diagnostics-Grove $26,000
OB-GYN-Grove 9,000
etc.....
Total Hospitals $99,999
RWF-ZERO-SUPPRESS Alpha 1 FB141 GL292
Suppress Zeros This field determines whether zero GL293 GL294
amounts appear on the report. GL95.4 GL99.1
RW20.1 RW20.2
The default is No.
" " = Default
Y = Yes
N = No
RWF-COMPUTE-NAME Alpha 12 FB141 GL292
Compute Statement If you enter a value in the Dictionary GL293 GL294
Code field, leave this field blank. This GL95.4 GL99.1
field indicates the compute statement to RW20.1 RW20.2
use for this column. A compute statement
is an arithmetic equation created in
RW50.1 (Compute Statement), consisting
of data dictionary items and operation
symbols.
RWF-DICT-CODE Alpha 20 FB141 GL292
Dictionary Code If you enter a value in the Compute GL293 GL294
Statement field, leave this field blank. GL95.4 GL99.1
This field indicates the dictionary code RW20.1 RW20.2
to use in this column. You can also use
this field to indicate the budget number
for the column by enclosing the budget
number in parentheses and attaching it
to the dictionary code.
RWF-DATA-ITEM Derived
Data Item This field contains the first six
characters of the dictionary code.
RWF-CASE-CODE Alpha 44 FB141 GL292
Case Code The case code is a representation of a GL293 GL294
dictionary item used to execute and GL95.4 GL99.1
process the item. The code is composed RW20.1 RW20.2
of a series of alphanumeric codes that
describe attributes of the dictionary
item.
RWF-DIVISOR Numeric 7 FB141 GL292
Divisor This field indicates the divisor to use GL293 GL294
in the column. GL95.4 GL99.1
RW20.1 RW20.2
0000000 = Default
0000001 = Whole Amount
0000100 = Hundreds
0001000 = Thousands
1000000 = Millions
RWF-BUDGET-NBR Numeric 3 FB141 GL292
Budget Number This field indicates the budget number GL293 GL294
to use in this column. Another way to GL95.4 GL99.1
indicate the budget number is by RW20.1 RW20.2
enclosing the budget number in
parentheses and attaching it to the
dictionary code.
This field is required if a dictionary
code is entered without a budget number
attached.
RWF-COMPANY-OVD Alpha 1 FB141 GL292
Company Override This indicates the override company GL293 GL294
number defined by the report or row. Use GL95.4 GL99.1
No if you want to use the default RW20.1 RW20.2
company value defined in the header
record.
Y = Yes
N = No
RWF-FR-COMPANY Numeric 4 FB141 GL292
From Company This is the company number for the from GL293 GL294
company. GL95.4 GL99.1
RW20.1 RW20.2
RWF-TH-COMPANY Numeric 4 FB141 GL292
Through Company This is the company number used as the GL293 GL294
ending company. GL95.4 GL99.1
RW20.1 RW20.2
RWF-FR-VAR-LEVELS Alpha 30 FB141 GL292
From Variable Level This is the variable level assigned as GL293 GL294
the from or beginning level number. GL95.4 GL99.1
RW20.1 RW20.2
RWF-TH-VAR-LEVELS Alpha 30 FB141 GL292
Through Variable This is the variable level used as the GL293 GL294
Level ending variable level for the range. GL95.4 GL99.1
RW20.1 RW20.2
RWF-FR-ACCOUNT Numeric 6 FB141 GL292
From Account This is the beginning account for a GL293 GL294
range of accounts. GL95.4 GL99.1
RW20.1 RW20.2
RWF-TH-ACCOUNT Numeric 6 FB141 GL292
Through Account This is the ending account for a range GL293 GL294
of accounts. GL95.4 GL99.1
RW20.1 RW20.2
RWF-FR-SUB-ACCT Numeric 4 FB141 GL292
From Subaccount This is the beginning subaccount for a GL293 GL294
range of subaccounts. GL95.4 GL99.1
RW20.1 RW20.2
RWF-TH-SUB-ACCT Numeric 4 FB141 GL292
Through Subaccount This is the ending subaccount for a GL293 GL294
range of subaccounts. GL95.4 GL99.1
RW20.1 RW20.2
RWF-LEVEL-OVD Alpha 1 FB141 GL292
Level Override Use Yes if you want to override the GL293 GL294
level value defined by the report or GL95.4 GL99.1
row. Use No if you want to use the RW20.1 RW20.2
default level value defined in the
header record.
Y = Yes
N = No
RWF-LEVEL-GROUP Alpha 12 FB141 GL292
Level Group This field indicates the level group as GL293 GL294
defined in RW40.1 (Level Group). GL95.4 GL99.1
RW20.1 RW20.2
RWF-ACCOUNT-OVD Alpha 1 FB141 GL292
Account Override Use Yes if you want to override the GL293 GL294
account value defined by the report or GL95.4 GL99.1
row. Use No if you want to use the RW20.1 RW20.2
default account value defined in the
header record.
Y = Yes
N = No
RWF-ACCOUNT-GROUP Alpha 12 FB141 GL292
Account Group This field identifies the account group GL293 GL294
as defined in RW40.3 (Account Group). GL95.4 GL99.1
RW20.1 RW20.2
RWF-SUB-ACCT-OVD Alpha 1 FB141 GL292
Subaccount Use Yes if you want to override the GL293 GL294
subaccount value defined by the report GL95.4 GL99.1
or row. Use No if you want to use the RW20.1 RW20.2
default subaccount value defined in the
header record.
Y = Yes
N = No
RWF-SUB-ACCT-GRP Alpha 12 FB141 GL292
Subaccount Group This field identifies the subaccount GL293 GL294
group as defined in RW40.4 (Subaccount GL95.4 GL99.1
Group). RW20.1 RW20.2
RWF-OVD-ACCTUNIT Alpha 15 Occurs 4 Times FB141 GL292
Accounting Unit The accounting units defined for the GL293 GL294
Override column. GL95.4 GL99.1
RW20.1 RW20.2
RWF-GHOST-COLUMN Alpha 1 FB141 GL292
Ghost Column This field determines whether this GL293 GL294
column is a ghost column. A ghost column GL95.4 GL99.1
does not print, but is used in RW20.1 RW20.2
calculations and referenced by compute
statements.
The default is No.
" " = Default
N = No
Y = Yes
RWF-IGNORE-SGN-RV Alpha 1 FB141 GL292
Ignore Sign Reversal This field lets you override the option GL293 GL294
you selected in the Sign Reversal field GL95.4 GL99.1
in RW10 (Rows). RW20.1 RW20.2
The default is No.
" " = Default
N = No
Y = Yes
RWF-DEB-CRED-ONLY Alpha 1 FB141 GL292
Debit or Credit Only This field determines how the column GL293 GL294
totals appear. GL95.4 GL99.1
RW20.1 RW20.2
The default is Net Balance, which prints
the totals normally. You can select to
print Debit Only, Net Debit, or Net
Credit.
For example, if you want to view the
debit balance for a company, select
Debit Only.
" " = Default
C = Credit Only
D = Debit Only
N = No
RWF-PRINT-SIZE Alpha 1 FB141 GL292
Print Size This indicates the number of characters GL293 GL294
that print per inch. The default is 132 GL95.4 GL99.1
Characters. RW20.2
R = Regular (132)
C = Condensed (233)
A = Condensed (158)
B = Condensed (198)
D = Portrait (80)
RWF-IMAGE Alpha 233 FB141 GL292
Image This is an image of the report header. GL293 GL294
GL95.4 GL99.1
RW20.1 RW20.2
RWF-COMPLETE-FLAG Alpha 1 RW20.1 RW20.2
Complete Flag This flag indicates whether the format
is complete.
Y = Complete
N = Incomplete
" "
RWF-SELECT-OPT Alpha 1 FB141 GL292
Select Option This option determines whether the GL293 GL294
column includes or excludes ranges or GL95.4 GL99.1
provides no criteria. RW20.1 RW20.2
I = Include Range
E = Exclude Range
N = No Criteria
RWF-FR-RANGE Signed 16.5 FB141 GL292
From Range This is the beginning range to be GL293 GL294
included or excluded. GL95.4 GL99.1
RW20.1 RW20.2
RWF-TH-RANGE Signed 16.5 FB141 GL292
Through Range This is the ending range to be included GL293 GL294
or excluded. GL95.4 GL99.1
RW20.1 RW20.2
RWF-LOGICAL-OP Alpha 1
Logical Op
RWF-OVD-COLUMN Derived
Override Column This field indicates whether to
override the column. Use Yes if you want
to override this column. Use No if you
want to use the default value defined in
the header record for this column.
RWF-DESCRIPTION Alpha 30 (Lower Case) RW20.2 RW20.8
Format Description This is the description of the format.
RWF-BLANK Derived
Blank This derived field is always blank. It
is used in drill around to allow column
headings.
RWF-CHART-NAME Alpha 12 FB141 GL292
Chart Name This is the name you assigned to the GL293 GL294
chart of accounts when you defined your GL95.4 GL99.1
company structure in the General Ledger RW20.1 RW20.2
system.
RWF-SUMRY-ACCT-ID Numeric 6 FB141 GL292
Summary Account ID The summary account name as defined in GL293 GL294
GL00.1 (Chart of Accounts). GL95.4 GL99.1
RW20.1 RW20.2
RWF-MATRIX-LIST Alpha 12 FB141 GL292
Matrix List Matrix categories are selection GL293 GL294
parameters used to build a list of GL95.4 GL99.1
objects (for example, accounting units). RW20.1 RW20.2
Matrix categories and values are the
basis of the selection and sorting. A
matrix list can then be used for
reporting on and processing objects.
RWF-ACCOUNT-LIST Alpha 12 FB141 GL292
Account List GL293 GL294
GL95.4 GL99.1
RW20.1 RW20.2
RWFORMAT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RWFSET1 FORMAT ACVW.1 FB141
RECORD-TYPE GL292 GL293
LINE-NBR GL294 GL95.4
GL99.1 RW00.1
RW100 RW20.1
RW20.2 RW20.8
RW220 RW298
RW299 GLAV.1
GLCV.1 GLVW.1
SLVW.1
RWFSET2 FOLDER-NAME KeyChange, Subset RW01.1 RW01.2
FORMAT Where RECORD-TYPE = "1" RW201 RW220
LINE-NBR
RWFSET4 FORMAT Subset FB141 GL292
LINE-NBR Where RECORD-TYPE = "1" GL293 GL294
GL95.4 GL99.1
RW00.1 RW20.1
RW20.2 RW20.8
RW298
RWFORMAT FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Account Group RWHEADER Required
When RWF-ACCOUNT-GROUP != Spaces
"G" -> RWH-HEAD-TYPE
RWF-ACCOUNT-GROUP -> RWH-HEAD-NAME
"A" -> RWH-RECORD-TYPE
Compute CMPUTE Required
When RWF-COMPUTE-NAME != Spaces
RWF-COMPUTE-NAME -> CMP-COMPUTE-NAME
Data Dict RWDICT Not Required
RWF-DICT-CODE -> RWD-DICT-NAME
Defaults RWFORMAT Required
RWF-FORMAT -> RWF-FORMAT
"1" -> RWF-RECORD-TYPE
1 -> RWF-LINE-NBR
Folder GLCODES Required
"F" -> GCD-RECORD-TYPE
RWF-FOLDER-NAME -> GCD-FOLDER-NAME
Spaces -> GCD-PROCESS-GROUP
Spaces -> GCD-SYSTEM
Zeroes -> GCD-COMPANY
Glchart GLCHART Not Required
RWF-CHART-NAME -> GCH-CHART-NAME
Glchartsum GLCHARTSUM Not Required
RWF-CHART-NAME -> GCS-CHART-NAME
RWF-SUMRY-ACCT-ID -> GCS-SUMRY-ACCT-ID
Heading 1 RWFORMAT Not Required
RWF-FORMAT -> RWF-FORMAT
"2" -> RWF-RECORD-TYPE
1 -> RWF-LINE-NBR
Heading 2 RWFORMAT Not Required
RWF-FORMAT -> RWF-FORMAT
"2" -> RWF-RECORD-TYPE
2 -> RWF-LINE-NBR
Heading 3 RWFORMAT Not Required
RWF-FORMAT -> RWF-FORMAT
"2" -> RWF-RECORD-TYPE
3 -> RWF-LINE-NBR
Heading 4 RWFORMAT Not Required
RWF-FORMAT -> RWF-FORMAT
"2" -> RWF-RECORD-TYPE
4 -> RWF-LINE-NBR
Heading 5 RWFORMAT Not Required
RWF-FORMAT -> RWF-FORMAT
"2" -> RWF-RECORD-TYPE
5 -> RWF-LINE-NBR
Heading 6 RWFORMAT Not Required
RWF-FORMAT -> RWF-FORMAT
"2" -> RWF-RECORD-TYPE
6 -> RWF-LINE-NBR
Heading 7 RWFORMAT Not Required
RWF-FORMAT -> RWF-FORMAT
"2" -> RWF-RECORD-TYPE
7 -> RWF-LINE-NBR
Level Group RWHEADER Required
When RWF-LEVEL-GROUP != Spaces
"G" -> RWH-HEAD-TYPE
RWF-LEVEL-GROUP -> RWH-HEAD-NAME
"L" -> RWH-RECORD-TYPE
Mxlisthdr MXLISTHDR Not Required
"ACCTU" -> MLH-OBJ-TYPE
RWF-MATRIX-LIST -> MLH-MATRIX-LIST
Subacct Group RWHEADER Required
When RWF-SUB-ACCT-GRP != Spaces
"G" -> RWH-HEAD-TYPE
RWF-SUB-ACCT-GRP -> RWH-HEAD-NAME
"S" -> RWH-RECORD-TYPE
RWFORMAT FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acct Grp Det RWGRPDET
"A" -> RGD-RECORD-TYPE
RWF-ACCOUNT-GROUP -> RGD-HEAD-NAME
RGD-RANGE-NUMBER
Columns RWFORMAT Delete Cascades
RWF-FORMAT -> RWF-FORMAT
"3" -> RWF-RECORD-TYPE
RWF-LINE-NBR
Headings RWFORMAT Delete Cascades
RWF-FORMAT -> RWF-FORMAT
"2" -> RWF-RECORD-TYPE
RWF-LINE-NBR
Lvl Grp Det RWGRPDET
"L" -> RGD-RECORD-TYPE
RWF-LEVEL-GROUP -> RGD-HEAD-NAME
RGD-RANGE-NUMBER
Sub Grp Det RWGRPDET
"S" -> RGD-RECORD-TYPE
RWF-SUB-ACCT-GRP -> RGD-HEAD-NAME
RGD-RANGE-NUMBER
|
