RWFORMAT – Report Writer Format

System: General Ledger (GL)
Prefix: RWF
Primary key: FORMAT, RECORD-TYPE, LINE-NBR
Fields: 55
Updated by: 14 programs
Referenced by: 41 programs

RWFORMAT is the Report Writer Format table in Lawson General Ledger (prefix RWF). It is indexed by FORMAT, RECORD-TYPE, LINE-NBR (RWFSET1); alternate indexes: RWFSET2 and RWFSET4. It is related 1:1 to RWHEADER, CMPUTE, RWDICT, RWFORMAT, GLCODES, GLCHART, GLCHARTSUM and MXLISTHDR and 1:M to RWGRPDET, RWFORMAT and RWFORMATAU. It is updated by FB141, GL292, GL293, GL294, GL95.4, GL99.1, ML292, ML293 and 6 more and referenced by ACVW.1, ATVW.1, FB01.1, FB01.2, GLAV.1, GLCV.1, GLVW.1, RW00.1 and 33 more. The table has 55 fields, 3 indexes and 23 documented relations.

About RWFORMAT

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.

Fields (55)

Column = COBOL field name without the RWF- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / column	Type	Description & values	Updated by
`RWF-FORMAT` PK 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 +7 more
`RWF-RECORD-TYPE` PK 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 +6 more
`RWF-LINE-NBR` PK LINE_NBR	Numeric 6	This field contains the column line number. 000001 000050	FB141, GL292, GL293, GL294, GL95.4, GL99.1, ML292, ML293 +6 more
`RWF-FOLDER-NAME` FOLDER_NAME	Alpha 12	This is the name of a folder defined in RW01.1 (Folder).	RW20.2, RW20.8
`RWF-DICT-FLAG` DICT_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 +5 more
`RWF-COL-POSITION` COL_POSITION	Numeric 3	This is the amount of space between columns.	FB141, GL292, GL293, GL294, GL95.4, GL99.1, ML292, ML293 +5 more
`RWF-SIZE` SIZE	Numeric 2	This field indicates the width of the column.	FB141, GL292, GL293, GL294, GL95.4, GL99.1, ML292, ML293 +5 more
`RWF-TOTAL-TYPE` 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 +5 more
`RWF-DATA-TYPE` 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 +5 more
`RWF-DECIMALS` 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 +5 more
`RWF-UNDERLINE` 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 +5 more
`RWF-SIGN` 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 ( = () Brackets Brackets `C` CR `U` Unfavorable `-` Dash `N` No Sign	FB141, GL292, GL293, GL294, GL95.4, GL99.1, ML292, ML293 +5 more
`RWF-COMMAS` 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 +5 more
`RWF-OFFSET` 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 +5 more
`RWF-DOL-PCT-SIGN` DOL_PCT_SIGN	Alpha 1	—	FB141, GL292, GL293, GL294, GL95.4, GL99.1, ML292, ML293 +5 more
`RWF-ZERO-SUPPRESS` ZERO_SUPPRESS	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 +5 more
`RWF-COMPUTE-NAME` COMPUTE_NAME	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 +5 more
`RWF-DICT-CODE` DICT_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 +5 more
`RWF-DATA-ITEM` DATA_ITEM	Derived	This field contains the first six characters of the dictionary code.	—
`RWF-CASE-CODE` 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 +5 more
`RWF-DIVISOR` 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 +5 more
`RWF-BUDGET-NBR` BUDGET_NBR	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 +5 more
`RWF-COMPANY-OVD` COMPANY_OVD	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 +5 more
`RWF-FR-COMPANY` FR_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 +5 more
`RWF-TH-COMPANY` TH_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 +5 more
`RWF-FR-VAR-LEVELS` FR_VAR_LEVELS	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 +5 more
`RWF-TH-VAR-LEVELS` TH_VAR_LEVELS	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 +5 more
`RWF-FR-ACCOUNT` FR_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 +5 more
`RWF-TH-ACCOUNT` TH_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 +5 more
`RWF-FR-SUB-ACCT` FR_SUB_ACCT	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 +5 more
`RWF-TH-SUB-ACCT` TH_SUB_ACCT	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 +5 more
`RWF-LEVEL-OVD` LEVEL_OVD	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 +5 more
`RWF-LEVEL-GROUP` 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 +5 more
`RWF-ACCOUNT-OVD` ACCOUNT_OVD	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 +5 more
`RWF-ACCOUNT-GROUP` 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 +5 more
`RWF-SUB-ACCT-OVD` SUB_ACCT_OVD	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 +5 more
`RWF-SUB-ACCT-GRP` SUB_ACCT_GRP	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 +5 more
`RWF-OVD-ACCTUNIT` OVD_ACCTUNIT	Alpha 15 Occurs 4 Times ×4	The accounting units defined for the column.	FB141, GL292, GL293, GL294, GL95.4, GL99.1, ML292, ML293 +5 more
`RWF-GHOST-COLUMN` 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 +5 more
`RWF-IGNORE-SGN-RV` IGNORE_SGN_RV	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 +5 more
`RWF-DEB-CRED-ONLY` DEB_CRED_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 +5 more
`RWF-PRINT-SIZE` 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 +4 more
`RWF-IMAGE` IMAGE	Alpha 233	This is an image of the report header.	FB141, GL292, GL293, GL294, GL95.4, GL99.1, ML292, ML293 +5 more
`RWF-COMPLETE-FLAG` COMPLETE_FLAG	Alpha 1	This flag indicates whether the format is complete. " " `Y` Complete `N` Incomplete	RW20.1, RW20.2
`RWF-SELECT-OPT` SELECT_OPT	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 +5 more
`RWF-FR-RANGE` FR_RANGE	Signed 16.5	This is the beginning range to be included or excluded.	FB141, GL292, GL293, GL294, GL95.4, GL99.1, ML292, ML293 +5 more
`RWF-TH-RANGE` TH_RANGE	Signed 16.5	This is the ending range to be included or excluded.	FB141, GL292, GL293, GL294, GL95.4, GL99.1, ML292, ML293 +5 more
`RWF-LOGICAL-OP` LOGICAL_OP	Alpha 1	—	—
`RWF-OVD-COLUMN` OVD_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` DESCRIPTION	Alpha 30 (Lower Case)	This is the description of the format.	RW20.2, RW20.8
`RWF-BLANK` BLANK	Derived	This derived field is always blank. It is used in drill around to allow column headings.	—
`RWF-CHART-NAME` 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 +5 more
`RWF-SUMRY-ACCT-ID` SUMRY_ACCT_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 +5 more
`RWF-MATRIX-LIST` 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 +5 more
`RWF-ACCOUNT-LIST` 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 +5 more

Indexes (3)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`RWFSET1`	`FORMAT`, `RECORD-TYPE`, `LINE-NBR`	Primary		ACVW.1, ATVW.1, FB01.1, FB01.2, FB141, GL292, GL293, GL294 +22 more (list truncated in source)
`RWFSET2`	`FOLDER-NAME`, `FORMAT`, `LINE-NBR`	KeyChange, Subset	Where RECORD-TYPE = "1"	GL292, GL293, RW01.1, RW01.2, RW201, RW220
`RWFSET4`	`FORMAT`, `LINE-NBR`	Subset	Where RECORD-TYPE = "1"	FB141, GL292, GL293, GL294, GL95.4, GL99.1, RW00.1, RW20.1 +8 more

Relations

One to one (17) — lookups and parents

Relation	Table	Rules	Condition	Field map
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`

One to many (6) — child tables

Relation	Table	Rules	Field map
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`
Rwformatau	RWFORMATAU		`RWF-FORMAT` → `RFA-FORMAT`, `RWF-RECORD-TYPE` → `RFA-RECORD-TYPE`, `RWF-LINE-NBR` → `RFA-LINE-NBR`, → `RFA-ACTION`, → `RFA-DATE`, → `RFA-TIME`, → `RFA-UNIQUE-I-D`
Sub Grp Det	RWGRPDET		`"S"` → `RGD-RECORD-TYPE`, `RWF-SUB-ACCT-GRP` → `RGD-HEAD-NAME`, → `RGD-RANGE-NUMBER`

Programs

Updated by (14)

FB141 Remote Budget Consolidation
GL292 Balance Sheet
GL293 Income Statement
GL294 Projection by Level
GL95.4 Chart Query
GL99.1 Organization Query
ML292 Ledger Balance Sheet
ML293 Ledger Income Statement
ML95.4 Ledger Chart Query
ML99.1 Organization Query
RW20.1 Format
RW20.2 Define Format
RW20.8 Format Copy
SNGL.1 General Ledger Notification Update

Referenced by (41)

ACVW.1 Build GL Accounting Unit View
ATVW.1 Build Account Category View
FB01.1 Budget User Class
FB01.2 Define User Class
GLAV.1 Build GL Accounting Unit View
GLCV.1 General Ledger Chart View Build
GLVW.1 Build GL Accounting Unit View
RW00.1 Report Writer
RW00.6 Report Copy
RW01.1 Folder
RW01.2 Folders
RW03.1 User Class
RW03.2 Define User Class
RW10.2 Account Rows
RW10.3 Level Rows
RW10.4 Both Rows
RW10.8 Row Copy
RW100 Report Generation
RW11.1 Define Accounts Row
RW11.2 Define Levels Row
RW11.3 Define Both Type Row
RW11.4 Line Copy
RW201 Folder Listing
RW210 Row Listing
RW220 Format Listing
RW298 Usage Report
RW299 Detail Report Listing
RW30.1 Ratio Definition
RW40.1 Level Group
RW40.3 Account Group
RW40.4 Subaccount Group
RW40.5 Group Copy
RW40.6 Define Level Group
RW40.7 Define Account Group
RW40.8 Define Subaccount Group
RW50.1 Compute Statement
RW60.1 Total Range
RW60.2 Define Total Range
RW60.3 Total Range Copy
RW70.1 Total Names
SLVW.1 Build SL Accounting Unit View