RWFORMAT

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 ATVW.1 RW00.1 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
RW100 RW20.1 RW20.2 RW20.8 ML292 ML293
ML95.4 ML99.1 SNGL.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RWF-FORMAT
Element: Format
Alpha 12
This is the name that identifies the format as defined in RW20.1 (Format).
FB141 GL292
GL293 GL294
GL95.4 GL99.1
ML292 ML293
ML95.4 ML99.1
RW20.1 RW20.2
RW20.8 RW298
SNGL.1
RWF-RECORD-TYPE
Element: Record Type
Alpha 1
This field indicates the type of record defined.
1 = Format Description
2 = Format Heading
3 = Column Detail
FB141 GL292
GL293 GL294
GL95.4 GL99.1
ML292 ML293
ML95.4 ML99.1
RW20.1 RW20.2
RW298 SNGL.1
RWF-LINE-NBR
Element: Line Number
Numeric 6
This field contains the column line number.
000001
000050
FB141 GL292
GL293 GL294
GL95.4 GL99.1
ML292 ML293
ML95.4 ML99.1
RW20.1 RW20.2
RW298 SNGL.1
RWF-FOLDER-NAME
Element: Folder Name
Alpha 12
This is the name of a folder defined in RW01.1 (Folder).
RW20.2 RW20.8
RWF-DICT-FLAG
Element: Dictionary Flag
Alpha 1
This field is Y (Yes) if the record type is Format Heading and dictionary items are contained in the heading.
FB141 GL292
GL293 GL294
GL95.4 GL99.1
ML292 ML293
ML95.4 ML99.1
RW20.1 RW20.2
SNGL.1
RWF-COL-POSITION
Element: Column Position
Numeric 3
This is the amount of space between columns.
FB141 GL292
GL293 GL294
GL95.4 GL99.1
ML292 ML293
ML95.4 ML99.1
RW20.1 RW20.2
SNGL.1
RWF-SIZE
Element: Size
Numeric 2
This field indicates the width of the column.
FB141 GL292
GL293 GL294
GL95.4 GL99.1
ML292 ML293
ML95.4 ML99.1
RW20.1 RW20.2
SNGL.1
RWF-TOTAL-TYPE
Element: Total Type
Alpha 1
This field determines how column totals are calculated and printed. 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
FB141 GL292
GL293 GL294
GL95.4 GL99.1
ML292 ML293
ML95.4 ML99.1
RW20.1 RW20.2
SNGL.1
RWF-DATA-TYPE
Element: Data Type
Alpha 1
Required if the record type is Column Detail. This is the type of data for the record.
A = Alpha/Numeric Field
N = Numeric Field
FB141 GL292
GL293 GL294
GL95.4 GL99.1
ML292 ML293
ML95.4 ML99.1
RW20.1 RW20.2
SNGL.1
RWF-DECIMALS
Element: Number of Decimals
Numeric 1
This field determines the number of decimals for column amounts. For example, if you select 3, the value 100 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
FB141 GL292
GL293 GL294
GL95.4 GL99.1
ML292 ML293
ML95.4 ML99.1
RW20.1 RW20.2
SNGL.1
RWF-UNDERLINE
Element: Underline
Alpha 1
This field lets you override the option you selected in the Sign Reversal field in RW10 (Rows). The default is No.
" " = Default
Y = Yes
N = No
FB141 GL292
GL293 GL294
GL95.4 GL99.1
ML292 ML293
ML95.4 ML99.1
RW20.1 RW20.2
SNGL.1
RWF-SIGN
Element: Sign
Alpha 1
This field determines how negative values are represented in the report. 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
FB141 GL292
GL293 GL294
GL95.4 GL99.1
ML292 ML293
ML95.4 ML99.1
RW20.1 RW20.2
SNGL.1
RWF-COMMAS
Element: Commas
Alpha 1
This field determines if commas are used in column amounts. If you select Yes, the value 1000 appears as 1,000. The default is No.
" " = Default
N = No
Y = Yes
FB141 GL292
GL293 GL294
GL95.4 GL99.1
ML292 ML293
ML95.4 ML99.1
RW20.1 RW20.2
SNGL.1
RWF-OFFSET
Element: Offset
Alpha 1
This field determines what side totals are justified at. The default is None. You can select to justify totals to the left and right.
" " = Default
R = Right Offset
L = Left Offset
N = No Offset
FB141 GL292
GL293 GL294
GL95.4 GL99.1
ML292 ML293
ML95.4 ML99.1
RW20.1 RW20.2
SNGL.1
RWF-DOL-PCT-SIGN
Dollar or Percent
Sign
Alpha 1
FB141 GL292
GL293 GL294
GL95.4 GL99.1
ML292 ML293
ML95.4 ML99.1
RW20.1 RW20.2
SNGL.1
RWF-ZERO-SUPPRESS
Element: Suppress Zeros
Alpha 1
This field lets you override the option you selected in the Sign Reversal field in RW10 (Rows). The default is No.
" " = Default
Y = Yes
N = No
FB141 GL292
GL293 GL294
GL95.4 GL99.1
ML292 ML293
ML95.4 ML99.1
RW20.1 RW20.2
SNGL.1
RWF-COMPUTE-NAME
Element: Compute Statement
Alpha 12
If you enter a value in the Dictionary Code field, leave this field blank. This field indicates the compute statement to 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.
FB141 GL292
GL293 GL294
GL95.4 GL99.1
ML292 ML293
ML95.4 ML99.1
RW20.1 RW20.2
SNGL.1
RWF-DICT-CODE
Element: Dictionary Code
Alpha 20
If you enter a value in the Compute Statement field, leave this field blank. This field indicates the dictionary code 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.
FB141 GL292
GL293 GL294
GL95.4 GL99.1
ML292 ML293
ML95.4 ML99.1
RW20.1 RW20.2
SNGL.1
RWF-DATA-ITEM
Element: Data Item
Derived
This field contains the first six characters of the dictionary code.
RWF-CASE-CODE
Element: Case Code
Alpha 44
The case code is a representation of a dictionary item used to execute and process the item. The code is composed of a series of alphanumeric codes that describe attributes of the dictionary item.
FB141 GL292
GL293 GL294
GL95.4 GL99.1
ML292 ML293
ML95.4 ML99.1
RW20.1 RW20.2
SNGL.1
RWF-DIVISOR
Element: Divisor
Numeric 7
This field indicates the divisor to use in the column.
0000000 = Default
0000001 = Whole Amount
0000100 = Hundreds
0001000 = Thousands
1000000 = Millions
FB141 GL292
GL293 GL294
GL95.4 GL99.1
ML292 ML293
ML95.4 ML99.1
RW20.1 RW20.2
SNGL.1
RWF-BUDGET-NBR
Element: Budget Number
Numeric 3
This field indicates the budget number to use in this column. Another way to indicate the budget number is by 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.
FB141 GL292
GL293 GL294
GL95.4 GL99.1
ML292 ML293
ML95.4 ML99.1
RW20.1 RW20.2
SNGL.1
RWF-COMPANY-OVD
Element: Company Override
Alpha 1
This indicates the override company number defined by the report or row. Use No if you want to use the default company value defined in the header record.
Y = Yes
N = No
FB141 GL292
GL293 GL294
GL95.4 GL99.1
ML292 ML293
ML95.4 ML99.1
RW20.1 RW20.2
SNGL.1
RWF-FR-COMPANY
Element: From Company
Numeric 4
Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.
FB141 GL292
GL293 GL294
GL95.4 GL99.1
ML292 ML293
ML95.4 ML99.1
RW20.1 RW20.2
SNGL.1
RWF-TH-COMPANY
Element: Through Company
Numeric 4
Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.
FB141 GL292
GL293 GL294
GL95.4 GL99.1
ML292 ML293
ML95.4 ML99.1
RW20.1 RW20.2
SNGL.1
RWF-FR-VAR-LEVELS
Element: From Variable Level
Alpha 30
A level that represents the location of an accounting unit in an organization's level structure.
FB141 GL292
GL293 GL294
GL95.4 GL99.1
ML292 ML293
ML95.4 ML99.1
RW20.1 RW20.2
SNGL.1
RWF-TH-VAR-LEVELS
Through Variable
Level
Alpha 30
A level that represents the location of an accounting unit in an organization's level structure.
FB141 GL292
GL293 GL294
GL95.4 GL99.1
ML292 ML293
ML95.4 ML99.1
RW20.1 RW20.2
SNGL.1
RWF-FR-ACCOUNT
Element: From Account
Numeric 6
This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.
FB141 GL292
GL293 GL294
GL95.4 GL99.1
ML292 ML293
ML95.4 ML99.1
RW20.1 RW20.2
SNGL.1
RWF-TH-ACCOUNT
Element: Through Account
Numeric 6
This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.
FB141 GL292
GL293 GL294
GL95.4 GL99.1
ML292 ML293
ML95.4 ML99.1
RW20.1 RW20.2
SNGL.1
RWF-FR-SUB-ACCT
Element: From Subaccount
Numeric 4
This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record.
FB141 GL292
GL293 GL294
GL95.4 GL99.1
ML292 ML293
ML95.4 ML99.1
RW20.1 RW20.2
SNGL.1
RWF-TH-SUB-ACCT
Element: Through Subaccount
Numeric 4
This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record.
FB141 GL292
GL293 GL294
GL95.4 GL99.1
ML292 ML293
ML95.4 ML99.1
RW20.1 RW20.2
SNGL.1
RWF-LEVEL-OVD
Element: Level Override
Alpha 1
Use Yes if you want to override the level value defined by the report or row. Use No if you want to use the default level value defined in the header record.
Y = Yes
N = No
FB141 GL292
GL293 GL294
GL95.4 GL99.1
ML292 ML293
ML95.4 ML99.1
RW20.1 RW20.2
SNGL.1
RWF-LEVEL-GROUP
Element: Level Group
Alpha 12
This field indicates the level group as defined in RW40.1 (Level Group).
FB141 GL292
GL293 GL294
GL95.4 GL99.1
ML292 ML293
ML95.4 ML99.1
RW20.1 RW20.2
SNGL.1
RWF-ACCOUNT-OVD
Element: Account Override
Alpha 1
Use Yes if you want to override the account value defined by the report or row. Use No if you want to use the default account value defined in the header record.
Y = Yes
N = No
FB141 GL292
GL293 GL294
GL95.4 GL99.1
ML292 ML293
ML95.4 ML99.1
RW20.1 RW20.2
SNGL.1
RWF-ACCOUNT-GROUP
Element: Account Group
Alpha 12
This field identifies the account group as defined in RW40.3 (Account Group).
FB141 GL292
GL293 GL294
GL95.4 GL99.1
ML292 ML293
ML95.4 ML99.1
RW20.1 RW20.2
SNGL.1
RWF-SUB-ACCT-OVD
Element: Subaccount
Alpha 1
Use Yes if you want to override the subaccount value defined by the report or row. Use No if you want to use the default subaccount value defined in the header record.
Y = Yes
N = No
FB141 GL292
GL293 GL294
GL95.4 GL99.1
ML292 ML293
ML95.4 ML99.1
RW20.1 RW20.2
SNGL.1
RWF-SUB-ACCT-GRP
Element: Subaccount Group
Alpha 12
This field identifies the subaccount group as defined in RW40.4 (Subaccount Group).
FB141 GL292
GL293 GL294
GL95.4 GL99.1
ML292 ML293
ML95.4 ML99.1
RW20.1 RW20.2
SNGL.1
RWF-OVD-ACCTUNIT
Accounting Unit
Override
Alpha 15 Occurs 4 Times
The accounting units defined for the column.
FB141 GL292
GL293 GL294
GL95.4 GL99.1
ML292 ML293
ML95.4 ML99.1
RW20.1 RW20.2
SNGL.1
RWF-GHOST-COLUMN
Element: Ghost Column
Alpha 1
This field determines whether this column is a ghost column. A ghost column does not print, but is used in calculations and referenced by compute statements. The default is No.
" " = Default
N = No
Y = Yes
FB141 GL292
GL293 GL294
GL95.4 GL99.1
ML292 ML293
ML95.4 ML99.1
RW20.1 RW20.2
SNGL.1
RWF-IGNORE-SGN-RV
Element: Ignore Sign Reversal
Alpha 1
This field lets you override the option you selected in the Sign Reversal field in RW10 (Rows). The default is No.
" " = Default
N = No
Y = Yes
FB141 GL292
GL293 GL294
GL95.4 GL99.1
ML292 ML293
ML95.4 ML99.1
RW20.1 RW20.2
SNGL.1
RWF-DEB-CRED-ONLY
Element: Debit or Credit Only
Alpha 1
This field determines how the column totals appear. 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
FB141 GL292
GL293 GL294
GL95.4 GL99.1
ML292 ML293
ML95.4 ML99.1
RW20.1 RW20.2
SNGL.1
RWF-PRINT-SIZE
Element: Print Size
Alpha 1
This indicates the number of characters that print per inch. The default is 132 Characters.
R = Regular (132)
C = Condensed (233)
A = Condensed (158)
B = Condensed (198)
D = Portrait (80)
FB141 GL292
GL293 GL294
GL95.4 GL99.1
ML292 ML293
ML95.4 ML99.1
RW20.2 SNGL.1
RWF-IMAGE
Element: Image
Alpha 233
This is an image of the report header.
FB141 GL292
GL293 GL294
GL95.4 GL99.1
ML292 ML293
ML95.4 ML99.1
RW20.1 RW20.2
SNGL.1
RWF-COMPLETE-FLAG
Element: Complete Flag
Alpha 1
This flag indicates whether the format is complete.
Y = Complete
N = Incomplete
" "
RW20.1 RW20.2
RWF-SELECT-OPT
Element: Select Option
Alpha 1
This option determines whether the column includes or excludes ranges or provides no criteria.
I = Include Range
E = Exclude Range
N = No Criteria
FB141 GL292
GL293 GL294
GL95.4 GL99.1
ML292 ML293
ML95.4 ML99.1
RW20.1 RW20.2
SNGL.1
RWF-FR-RANGE
Element: From Range
Signed 16.5
This is the beginning range to be included or excluded.
FB141 GL292
GL293 GL294
GL95.4 GL99.1
ML292 ML293
ML95.4 ML99.1
RW20.1 RW20.2
SNGL.1
RWF-TH-RANGE
Element: Through Range
Signed 16.5
This is the ending range to be included or excluded.
FB141 GL292
GL293 GL294
GL95.4 GL99.1
ML292 ML293
ML95.4 ML99.1
RW20.1 RW20.2
SNGL.1
RWF-LOGICAL-OP
Element: Logical Op
Alpha 1
RWF-OVD-COLUMN
Element: Override Column
Derived
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
Element: Format Description
Alpha 30 (Lower Case)
This is the description of the format.
RW20.2 RW20.8
RWF-BLANK
Element: Blank
Derived
This derived field is always blank. It is used in drill around to allow column headings.
RWF-CHART-NAME
Element: Chart Name
Alpha 12
This is the name you assigned to the chart of accounts when you defined your company structure in the General Ledger system.
FB141 GL292
GL293 GL294
GL95.4 GL99.1
ML292 ML293
ML95.4 ML99.1
RW20.1 RW20.2
SNGL.1
RWF-SUMRY-ACCT-ID
Element: Summary Account ID
Numeric 6
The summary account name as defined in GL00.1 (Chart of Accounts).
FB141 GL292
GL293 GL294
GL95.4 GL99.1
ML292 ML293
ML95.4 ML99.1
RW20.1 RW20.2
SNGL.1
RWF-MATRIX-LIST
Element: Matrix List
Alpha 12
The accounting unit list is a company override parameter option which is defined in MX10 (List) for object type ACCTU.
FB141 GL292
GL293 GL294
GL95.4 GL99.1
ML292 ML293
ML95.4 ML99.1
RW20.1 RW20.2
SNGL.1
RWF-ACCOUNT-LIST
Element: Account List
Alpha 12
The account list is an account override parameter option which is defined in MX10 (List) for object type ACCNT.
FB141 GL292
GL293 GL294
GL95.4 GL99.1
ML292 ML293
ML95.4 ML99.1
RW20.1 RW20.2
SNGL.1


RWFORMAT FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RWFSET1 FORMAT
RECORD-TYPE
LINE-NBR
ACVW.1 ATVW.1
FB141 GL292
GL293 GL294
GL95.4 GL99.1
RW00.1 RW100
RW20.1 RW20.2
RW20.8 RW220
RW298 RW299
GLAV.1 GLCV.1
GLVW.1 ML292
ML293 ML95.4
ML99.1 SLVW.1
SNGL.1
RWFSET2 FOLDER-NAME
FORMAT
LINE-NBR
KeyChange, Subset
WhereRECORD-TYPE ="1"
GL292 GL293
RW01.1 RW01.2
RW201 RW220
RWFSET4 FORMAT
LINE-NBR
Subset
WhereRECORD-TYPE ="1"
FB141 GL292
GL293 GL294
GL95.4 GL99.1
RW00.1 RW20.1
RW20.2 RW20.8
RW298 ML292
ML293 ML95.4
ML99.1 SNGL.1


RWFORMAT FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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
NAME
RELATED 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


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

Home
Contact Us



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