WILLIAMS COMMON FEATURES 2/21/92
DSP01 ACCOUNT/CENTER MASTER FILE MAINTENANCE MASS CHANGE
Company/Location 001 BRU
From Account/Center 1210 C3
To Account/Center 1210 C4
Sequence Code A
Transaction Code
From To
Account Desc
Center Desc
Statement/Responsibility Codes
Percent Denominator
Beg Period/Yr, End Period/Yr
Account Class
Restrict to Subsystem
Currency/Translation Codes
Revalue Flag/Revalue Code
Submit Y
F2=Command F3=Exit F4=Prompt F9=Inquiry
F20=Mass Create
This screen is used to maintain multiple Account/Center Master File records. The user can modify a number of the indicated data fields, modifying both Financial and Statistical Account/Center Master File records with one request.
The range of records to be changed is specified in the From Account/Center and To Account/Center fields. Note that the account number range and center number range are processed separately. Consider the situation where the following ranges have been defined:
FROM ACCOUNT: 1000 TO ACCOUNT: 2000
FROM CENTER: 300 TO CENTER: 301
In this case, a record will be changed if the account is in the range 1000-2000 OR the center is in the range 300 - 301, depending on the sequence code chosen for the mass maintenance. For example, record 3000/300 will change, because the center is within the specified range if the processing is performed in center sequence.
Control totals for the requested maintenance will be printed on report CF230.
The fields below the transaction code define the Account/Center Master File values to be changed (from values) and the new values (to values). Records with at least one of the specified from-field values will have the matching fields changed to the specified to-field values.
COMPANY
Required. Must exist on the Reference File category 002.
LOCATION
Required. This field defines the location for which single or multiple account/centers will be processed for change. Must exist on the Reference File category 002.
FROM ACCOUNT NUMBER/FROM CENTER NUMBER
Optional. These fields define the single account/center to be processed for change if the account/center is blank, or the starting point of a range of account/centers to be processed for change if the account/center is not blank.
TO ACCOUNT NUMBER/TO CENTER NUMBER.
Optional. These fields define the ending point of a range of account/centers to be processed for change. The to account/center number must be greater than the from account/center number.
SEQUENCE CODE
Required. This field determines the order in which account/center records will be processed. Valid values are:
A - Select all accounts in the specified range, including accounts which have associated centers falling within the specified center range
C - Select all centers in the specified range, including centers which have associated accounts falling within the specified account range.
TRANSACTION CODE
Required. This field determines the processing to be performed. Valid values are defined on Reference File category 338.
ACCOUNT DESCRIPTION
Optional. This field contains the general text description or title of the Master File account.
CENTER DESCRIPTION
Optional. This field contains the general text description or title of the Master File center associated with an account.
STATEMENT CODE
Optional. This code is used by financial statement reports to sequence headings, line descriptions, and accounts within a company/location.
RESPONSIBILITY CODE
Optional. This field is used to assign responsibility areas to Income Statement accounts so that account amounts are accumulated into their proper responsibility areas when preparing Responsibility Reports. If entered, the account must be an Income Statement account (account type 4-6), and the code must exist on the reference file.
PERCENT DENOMINATOR
Optional. This code specifies the percent denominator into which an account balance should be accumulated. Valid values are:
0 - Do not include amount in a base percent denominator amount.
1-9 - Include account in a base percent denominator amount.
BEGINNING PERIOD
Optional. This field determines the beginning fiscal period in which the account will be active. Beginning period/year cannot be greater than ending period/year.
BEGINNING YEAR
Optional. This field determines the beginning fiscal year in which the account will be active.
ENDING PERIOD
Optional. This field determines the fiscal period after which the account will become inactive.
ENDING YEAR
Optional. This field determines the fiscal year after which the account will become inactive.
ACCOUNT CLASS
Optional. This field is required for validation processing in the Accounts Receivable System, and must exist on the reference file.
RESTRICT TO SUBSYSTEM
Optional. This flag is used to provide a level of security to the account. When the flag is set to Y, users will be prevented from making journal entries to the account in General Ledger, and the account is only valid in the Accounts Receivable/Accounts Payable/Inventory Accounting subsystem. When the flag is set to N, there are no restrictions on the account.
CURRENCY CODE (Multi-currency only)
Optional. This field is used to specify which foreign currency transactions are valid for the account. If a specific currency is specified, all transactions for the account must be made in that currency. If all-currencies is specified (denoted by '999'), then all foreign currency transactions are valid for the account.
CURRENCY TRANSLATION RATE CODE (Multi-currency only)
Optional. This field determines the exchange rate used to translate base amounts on the Account/Center Master File into a target foreign currency.
CURRENCY REVALUATION FLAG (Multi-currency only)
Optional. This field is used to flag whether the account should be revalued in the base currency. If the flag is set to Y, the account will be revalued.
CURRENCY REVALUATION RATE CODE (Multi-currency only)
Optional. This field determines the exchange rate used for currency revaluation.
SUBMIT CODE
Required. This field is used to either submit the transaction to batch, or to process the transaction online.
COMMAND KEYS
Enter - Submit the request.
F2 - Display a window where a fast path option or mnemonic can be entered. Fast path allows the next menu selection to be made directly from the screen. When the window is displayed, pressing F3 will remove it.
F3 - Exit the screen without submitting the request.
F4 - Display a list of values for the field where the cursor is positioned. If you select one of the items from the list, it will be returned to the application screen.
F9 - Enter the Account/Center Master File Inquiry Program.
F20 - Used to display the Account/Center Master File Mass Create Screen.
|