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
| FB141 | GL292 | GL293 | GL294 | GL95.4 | GL99.1 |
| 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). |
|
||||||||||||||||
| 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 |
|
||||||||||||||||
| RWF-LINE-NBR Element: Line Number | Numeric 6 This field contains the column line number. 000001 000050 |
|
||||||||||||||||
| RWF-FOLDER-NAME Element: Folder Name | Alpha 12 This is the name of a folder defined in RW01.1 (Folder). |
|
||||||||||||||||
| 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. |
|
||||||||||||||||
| RWF-COL-POSITION Element: Column Position | Numeric 3 This is the amount of space between columns. |
|
||||||||||||||||
| RWF-SIZE Element: Size | Numeric 2 This field indicates the width of the column. |
|
||||||||||||||||
| 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 |
|
||||||||||||||||
| 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 |
|
||||||||||||||||
| 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 |
|
||||||||||||||||
| 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 |
|
||||||||||||||||
| 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 |
|
||||||||||||||||
| 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 |
|
||||||||||||||||
| 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 |
|
||||||||||||||||
| RWF-DOL-PCT-SIGN Dollar or Percent Sign | Alpha 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 |
|
||||||||||||||||
| 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. |
|
||||||||||||||||
| 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. |
|
||||||||||||||||
| 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. |
|
||||||||||||||||
| 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 |
|
||||||||||||||||
| 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. |
|
||||||||||||||||
| 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 |
|
||||||||||||||||
| 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. |
|
||||||||||||||||
| 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. |
|
||||||||||||||||
| 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. |
|
||||||||||||||||
| 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. |
|
||||||||||||||||
| 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. |
|
||||||||||||||||
| 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. |
|
||||||||||||||||
| 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. |
|
||||||||||||||||
| 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. |
|
||||||||||||||||
| 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 |
|
||||||||||||||||
| RWF-LEVEL-GROUP Element: Level Group | Alpha 12 This field indicates the level group as defined in RW40.1 (Level Group). |
|
||||||||||||||||
| 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 |
|
||||||||||||||||
| RWF-ACCOUNT-GROUP Element: Account Group | Alpha 12 This field identifies the account group as defined in RW40.3 (Account Group). |
|
||||||||||||||||
| 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 |
|
||||||||||||||||
| RWF-SUB-ACCT-GRP Element: Subaccount Group | Alpha 12 This field identifies the subaccount group as defined in RW40.4 (Subaccount Group). |
|
||||||||||||||||
| RWF-OVD-ACCTUNIT Accounting Unit Override | Alpha 15 Occurs 4 Times The accounting units defined for the column. |
|
||||||||||||||||
| 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 |
|
||||||||||||||||
| 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 |
|
||||||||||||||||
| 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 |
|
||||||||||||||||
| 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) |
|
||||||||||||||||
| RWF-IMAGE Element: Image | Alpha 233 This is an image of the report header. |
|
||||||||||||||||
| RWF-COMPLETE-FLAG Element: Complete Flag | Alpha 1 This flag indicates whether the format is complete. Y = Complete N = Incomplete " " |
|
||||||||||||||||
| 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 |
|
||||||||||||||||
| RWF-FR-RANGE Element: From Range | Signed 16.5 This is the beginning range to be included or excluded. |
|
||||||||||||||||
| RWF-TH-RANGE Element: Through Range | Signed 16.5 This is the ending range to be included or excluded. |
|
||||||||||||||||
| 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. |
|
||||||||||||||||
| 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. |
|
||||||||||||||||
| RWF-SUMRY-ACCT-ID Element: Summary Account ID | Numeric 6 The summary account name as defined in GL00.1 (Chart of Accounts). |
|
||||||||||||||||
| 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. |
|
||||||||||||||||
| 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. |
|
| NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| RWFSET1 |
FORMAT RECORD-TYPE LINE-NBR |
|
|||||||||||||||||||||||||||||
| RWFSET2 |
FOLDER-NAME FORMAT LINE-NBR |
|
| ||||||||||||||||||||||||||||
| RWFSET4 |
FORMAT LINE-NBR |
|
| ||||||||||||||||||||||||||||
| RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Account Group | RWHEADER |
Required
| |||||||||||||||
| Compute | CMPUTE |
Required
| |||||||||||||||
| Data Dict | RWDICT |
Not Required
| |||||||||||||||
| Defaults | RWFORMAT |
Required
| |||||||||||||||
| Folder | GLCODES |
Required
| |||||||||||||||
| Glchart | GLCHART |
Not Required
| |||||||||||||||
| Glchartsum | GLCHARTSUM |
Not Required
| |||||||||||||||
| Heading 1 | RWFORMAT |
Not Required
| |||||||||||||||
| Heading 2 | RWFORMAT |
Not Required
| |||||||||||||||
| Heading 3 | RWFORMAT |
Not Required
| |||||||||||||||
| Heading 4 | RWFORMAT |
Not Required
| |||||||||||||||
| Heading 5 | RWFORMAT |
Not Required
| |||||||||||||||
| Heading 6 | RWFORMAT |
Not Required
| |||||||||||||||
| Heading 7 | RWFORMAT |
Not Required
| |||||||||||||||
| Level Group | RWHEADER |
Required
| |||||||||||||||
| Mxlisthdr | MXLISTHDR |
Not Required
| |||||||||||||||
| Subacct Group | RWHEADER |
Required
|
| RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Acct Grp Det | RWGRPDET |
| |||||||||||||||||||||
| Columns | RWFORMAT |
Delete Cascades
| |||||||||||||||||||||
| Headings | RWFORMAT |
Delete Cascades
| |||||||||||||||||||||
| Lvl Grp Det | RWGRPDET |
| |||||||||||||||||||||
| Rwformatau | RWFORMATAU |
| |||||||||||||||||||||
| Sub Grp Det | RWGRPDET |
|
All trademarks and registered trademarks are the property of their
respective owners.