Lawson Insight Technical Documentation |
|
RWFORMAT
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
Element: 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
Element: 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
Element: 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
Element: Folder Name This is the name of a folder defined in
RW01.1 (Folder).
RWF-DICT-FLAG Alpha 1 FB141 GL292
Element: Dictionary FlaThis 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
Element: Column PositioThis is the amount of space between GL293 GL294
columns. GL95.4 GL99.1
RW20.1 RW20.2
RWF-SIZE Numeric 2 FB141 GL292
Element: 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
Element: 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
Element: 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
Element: Number of DeciThis 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
Element: Underline " " = Default GL293 GL294
Y = Yes GL95.4 GL99.1
N = No RW20.1 RW20.2
RWF-SIGN Alpha 1 FB141 GL292
Element: 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
Element: 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
Element: 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 GL293 GL294
Sign GL95.4 GL99.1
RW20.1 RW20.2
RWF-ZERO-SUPPRESS Alpha 1 FB141 GL292
Element: Suppress Zeros" " = Default GL293 GL294
Y = Yes GL95.4 GL99.1
N = No RW20.1 RW20.2
RWF-COMPUTE-NAME Alpha 12 FB141 GL292
Element: Compute StatemIf 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
Element: Dictionary CodIf 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
Element: Data Item This field contains the first six
characters of the dictionary code.
RWF-CASE-CODE Alpha 44 FB141 GL292
Element: 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
Element: 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
Element: 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
Element: Company OverriThis 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
Element: From Company GL293 GL294
GL95.4 GL99.1
RW20.1 RW20.2
RWF-TH-COMPANY Numeric 4 FB141 GL292
Element: Through Company GL293 GL294
GL95.4 GL99.1
RW20.1 RW20.2
RWF-FR-VAR-LEVELS Alpha 30 FB141 GL292
Element: From Variable Level GL293 GL294
GL95.4 GL99.1
RW20.1 RW20.2
RWF-TH-VAR-LEVELS Alpha 30 FB141 GL292
Through Variable GL293 GL294
Level GL95.4 GL99.1
RW20.1 RW20.2
RWF-FR-ACCOUNT Numeric 6 FB141 GL292
Element: From Account GL293 GL294
GL95.4 GL99.1
RW20.1 RW20.2
RWF-TH-ACCOUNT Numeric 6 FB141 GL292
Element: Through Account GL293 GL294
GL95.4 GL99.1
RW20.1 RW20.2
RWF-FR-SUB-ACCT Numeric 4 FB141 GL292
Element: From Subaccount GL293 GL294
GL95.4 GL99.1
RW20.1 RW20.2
RWF-TH-SUB-ACCT Numeric 4 FB141 GL292
Element: Through Subaccount GL293 GL294
GL95.4 GL99.1
RW20.1 RW20.2
RWF-LEVEL-OVD Alpha 1 FB141 GL292
Element: Level OverrideUse 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
Element: 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
Element: Account OverriUse 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
Element: 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
Element: 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
Element: Subaccount GroThis 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
Element: 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
Element: Ignore Sign ReThis 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
Element: Debit or CrediThis 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
Element: 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
Element: 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
Element: Complete Flag This flag indicates whether the format
is complete.
Y = Complete
N = Incomplete
" "
RWF-SELECT-OPT Alpha 1 FB141 GL292
Element: 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
Element: 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
Element: 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
Element: Logical Op
RWF-OVD-COLUMN Derived
Element: Override ColumThis 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
Element: Format DescripThis is the description of the format.
RWF-BLANK Derived
Element: Blank This derived field is always blank. It
is used in drill around to allow column
headings.
RWF-CHART-NAME Alpha 12 FB141 GL292
Element: 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
Element: Summary AccounThe 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
Element: 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
Element: 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
|