Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

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     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
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      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
Element: Suppress ZerosThis 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
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  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
Element: Through CompanThis 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
Element: From Variable 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
Element: 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
Element: Through AccounThis 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
Element: From SubaccounThis 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
Element: Through SubaccThis 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
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   The accounting unit list is a company     GL293   GL294
                       override parameter option which is        GL95.4  GL99.1
                       defined in MX10 (List) for object type    RW20.1  RW20.2
                       ACCTU.

RWF-ACCOUNT-LIST       Alpha 12                                  FB141   GL292
Element: Account List  The account list is an account override   GL293   GL294
                       parameter option which is defined in      GL95.4  GL99.1
                       MX10 (List) for object type ACCNT.        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