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 GLCV.1 GLVW.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 Dividor 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-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. 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 GLCV.1 GLVW.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 |