System Control Table Components
Purpose: The System Control table is where you define many of the processing characteristics of the system. The options in this table are used to control special system information, such as:
• How the system will calculate pricing in Order Entry
• How SKU information will appear
• Whether you will use Cart/Bin picking
• How you will assign purchase order numbers
The information defined in the System Control table is confidential and critical to the operation of your system. Access to the System Control table is restricted to users who have security. You must be defined as a system administrator in your user record in order to change information in this table. This table should not be available to all users.
In this chapter:
• Work with System Control Values Screen
• Create System Control Value Screen
• Change System Control Value Screen
• Display System Control Value Screen
• Work with System Control Values by Code Screen
• Display System Control Value History Screen
• Display All System Control Value History Screen
• Print System Control Value History Window
• System Control Value History Report
Work with System Control Values Screen
Purpose: Use this screen to create, change, delete, and display a system control value.
How to display this screen: Select Control Values for an application area on the Work with System Values/Features Screen, available by entering WSYS in the Fast path field or by selecting Work with System Values/Features from a menu.
Field |
Description |
Grp (Application group) |
The application group to which these system control values relate. Alphanumeric, 3 positions; optional. |
Description-Value |
A description of this system control value. Alphanumeric, 75 positions; optional. |
Screen Options |
Procedure |
Create a system control value |
Select Create to advance to the Create System Control Value Screen. |
Change a system control value |
Select Change for a system control value to advance to the Change System Control Value Screen. |
Copy a system control value |
Select Copy for a system control value to advance to the Copy Company Info Window. |
Delete a system control value |
Select Delete for a system control value to delete it. Note: You can delete a system control value only if you have created it. You cannot delete a system control value that was delivered with the system. |
Display a system control value and a detailed description (on-line help) of the system control value |
Select Display for a system control value to advance to the Display System Control Value Screen. |
View the history of a system control value |
Select View History for a system control value to advance to the Display System Control Value History Screen. Note: This option is not available for an “umbrella” system control value, that is, a value used to group other system control values; instead, the system displays an error message: Option not valid for Umbrella value. For example, you cannot select this option for Pricing Values (B31); instead, you can view history for any of the system control values available under the Pricing Values umbrella. |
View the history of all system control values |
Select View History in the gray sidebar rather than for a particular system control value to advance to the Display All System Control Value History Screen. |
Create System Control Value Screen
Purpose: Use this screen to create a system control value. Typically, you would create a system control value only if you were modifying the system and needed to add a control parameter as part of the modification.
Screen layout: Almost all of the system control value screens have common fields. These are:
• Application
• Application group
• Sequence #
• Description
• Narrative
How to display this screen: Select Create at the Work with System Control Values Screen.
Field |
Description |
Application (Application area) |
The application area (for example, Order Entry) to which this system control value belongs. Application areas are used to categorize similar control values, secured features, and menu options by functional area. Once an application area has been assigned to a control value, it cannot be changed. Alphanumeric, 3 positions; display-only. |
Applic group (Application group) |
The application group to which this system value relates. Application groups further define functions within an application area and are used to categorize similar control values, secured features, and menu options. Example: Within the Order Entry application area, examples of application groups may be freight and tax. The application group you enter is validated against the Application Group table. See Setting Up Application Groups. Alphanumeric, 3 positions; required. |
Value |
A number that you assign to the system control value that identifies it to the system. This is an internal code that programs reference when checking a specific system control value. Once you have assigned this value, you cannot change it. The Value field is not shown in change or display mode. Alphanumeric, 3 positions; required. |
Type |
The type of parameter this system control value represents. The value you assign in the Type field describes whether an alphanumeric code, a number, percentage, or some other value will be required for the system control value. Example: If you create a control value that requires entry of a whole number, you must assign Number and not Y/N. When you assign one of the Type values in this field, its representation will appear on Change and Display screens. Example: If you enter Number as the type, Number will appear as the field (instead of Type) on the Change and Display screens. Valid values: • Long = The value is alphanumeric, up to 255 positions, so you can enter a long value such as a URL. • Number = The value is numeric, 7 positions so you can enter a number. • Quantity = The value is numeric, 7 positions so you can enter a quantity. • Y/N = The value is a checkbox, which you can select or unselect. • Code = The value is alphanumeric, 10 positions so you can enter a code. • Dollar value = The value is numeric, 11 positions with a 2-place decimal so you can enter a dollar amount. • System name = The value is alphanumeric, 10 positions so you can enter a system or program name. • Percentage = The value is numeric, 5 positions with a 2-place decimal so you can enter a percentage amount. • Weight = The value is numeric, 7 positions with a 3 place decimal so you can enter a weight amount. • Date = The value is numeric, 6 positions so you can enter a date. Required. |
Sequence# |
The number you assign controls the order in which the control values display on the screen within the application group. Numeric, 5 positions; required. |
Description |
A description of this system control value that explains this control value and appears on all System Control Value screens. Alphanumeric, 75 positions; required. |
Narrative |
Free-form text that describes in detail this system control value. Alphanumeric, 2 lines, 75 positions each line; required. |
Change System Control Value Screen
To change: Select Change for a system control value at the Work with System Control Values Screen to advance to the Change System Control Value screen. You cannot change the Description or Application fields. See Create System Control Value Screen for a description of these fields.
Note: The Value field from the Create System Control Value screen does not appear. To display the value (SCV code) that has been assigned to a system control value, use the Display System Control Value Screen. The Value field appears as the SCV code field on the Display screen.
The field that differs from the Create screen is the Code field. When this control value was created, the control value Type was CDE. Because of the control value type, you are required to enter an alphanumeric description (up to 10 characters) in this field. Each Change screen in this topic provides a description of the value you are required to enter.
If you change a system control value and the change does not take effect: Changing certain system control values requires that you exit Order Management System and re-enter before your changes take effect. Some require you to stop and restart the background async jobs (MBJC).
To copy: Select Copy for any system control value at the Work with System Control Values Screen to advance to the Copy Company Info window.
Copy to one company: This window allows you to enter a code for the company to which you want to copy all system control values that do not already exist in the target company from the source company. Then select OK. You receive a system message that the system control value has been created for the company code you entered in the pop-up window.
Copy to all companies: To copy system control values to all companies that you have defined, do not enter a company code, but select All Companies to copy system control values to all companies.
Existing values: If you copy a system control value for which a value has already been defined, the system control value is copied to the target company with the value that was defined in the source company.
If you copy a system control value to a company that already contains the same system control value, you receive a message that the control value you wanted to copy already exists. It does not replace the existing system control value.
Companies are defined using the Working with Companies (WCMP) menu option.
Display System Control Value Screen
To display: Select Display for a system control value at the Work with System Control Values Screen to advance to the Display System Control Value screen.
Note: Help text appears only in Display mode.
Enter help text: Select Change Mode to make the Help text fields enterable.
Work with System Control Values by Code Screen
Purpose: This screen provides a different presentation of the system control values: it lists the entire set of system control values by their 3-position alphanumeric SCV code instead of by application area.
This screen allows you to scan by the system control value's description; you do not need to know which application area the system control value is in.
How to display this screen: Select SCV/Code at the Work with System Values/Features Screen, available by entering WSYS in the Fast path field or by selecting Work with System Values/Features from a menu.
Field |
Description |
|
(Code) |
The SCV code. Alphanumeric, 3 positions; optional. |
Description-Value |
The description of this system control value. Alphanumeric, 75 positions; optional. |
This screen includes the following options in addition to those at the Work with System Control Values Screen.
Option |
Procedure |
View the history of a system control value |
Select View History for a system control value to advance to the Display System Control Value History Screen. Note: This option is not available for an “umbrella” system control value, that is, a value used to group other system control values; instead, the system displays an error message: Option not valid for Umbrella value. For example, you cannot select this option for Pricing Values (B31); instead, you can view history for any of the system control values available under the Pricing Values umbrella. |
View the history of all system control values |
Select View History in the gray sidebar rather than for a particular system control value to advance to the Display All System Control Value History Screen. |
Display System Control Value History Screen
Purpose: Use this screen to review the history of a particular system control value, including when it was created and each time a setting was changed.
History created when? The system creates a record in the System Control Value History table each time you:
• Add:
- create a new system control value by select Create at the Work with System Control Values by Code Screen
- add a new system control value by applying a PTF upgrade (Note: A Change record is also created immediately afterward)
- copy system control values from one company to another
• Change:
- select Change for a system control value to advance to the Change System Control Value Screen and then select OK, regardless of whether you actually change any information. If you did not actually change the value, the Before and After values displayed at this screen are the same.
- select Change for an umbrella system control value and change the value for an individual system control value that displays under the umbrella system control value. In this situation, the system creates a record in the System Control Value History table for the individual system control value that you have changed.
- use Working with FIFO Cost Conversion (WFCV) to change from or to FIFO costing
- add a new system control value by applying a PTF upgrade (Note: A Change record is created immediately after creating the Add record)
• Delete: select Delete for a system control value to delete it. You can review deleted system control values through the Display All System Control Value History Screen or the System Control Value History Report.
History not created when? There are no System Control Value History records for changes that you make to a system control value by other means, such as updating the System Control table directly.
System control value history for PTF upgrades: When you create a new system control value through applying a PTF upgrade, the upgrade creates two system control value history records: an Add record and a Change record. The Add record has a Before value of blank or zero and an After value of your selected setting, and the Change record has the selected setting as both the Before and After values.
Entity-level overrides: You can set entity-level system control value overrides by selecting Change for the value at the Work with Entity SCV Overrides Screen in Working with Entities (WENT). The system also uses the System Control Value History table to track these changes. Changes to entity-level values are displayed only through Working with Entities (WENT), while changes to the company-level System Control table are displayed only through Work with System Values/Features (WSYS); however, both types of changes are included in the System Control Value History Report.
Note: The Display System Control Value History screen is not available for entity-level system control value overrides; instead, you can select View History in the gray sidebar at the Work with Entity SCV Overrides Screen to advance to the Display All System Control Value History Screen.
How to display this screen: Select View History for a system control value at the Work with System Control Values by Code Screen or the Work with System Control Values Screen.
Note: This option is not available for an “umbrella” system control value, that is, a value used to group other system control values; instead, the system displays an error message: Option not valid for Umbrella value. For example, you cannot select this option for Pricing Values (B31); instead, you can view history for any of the system control values available under the Pricing Values umbrella by selecting them individually.
Field |
Description |
Value code |
The Cde you selected at the Work with System Control Values by Code Screen or the Work with System Control Values Screen. Alphanumeric, 3 positions; display-only. |
Type |
The type of system control value. Possible types are: • CDE = code • DTE = date • LNG = long text string • NBR = number • PCT = percentage • QTY = quantity • VAL = value • VNM = system name • WGT = weight • Y/N = yes/no value See the Create System Control Value Screen for a discussion of each type. Alphanumeric, 3 positions; display-only. |
Description |
The description of the system control value. Alphanumeric, 75 positions; display-only. |
Action |
The action taken for the system control value which created the System Control Value History record. Possible actions are: • Add = This type of record is created when you create a new system control value or copy system control values from one company to another. • Change = This type of record is created when you select Change for a system control value to advance to the Change System Control Value Screen and then select OK, regardless of whether you actually change any information. If you did not actually change the value, the Before and After values displayed at this screen are the same. It is also created when you use Work with FIFO Cost Conversion (WFCV) to change from or to FIFO costing or immediately after creating the Add record when you create a new system control value through a PTF upgrade • Delete = This type of record is created when you select Delete for a system control value. You should not delete system-supplied control values. Note: Records of deletions are displayed on the Display All System Control Value History Screen and on the System Control Value History report. Display-only. |
Date |
The date when the action occurred. Numeric, 6 positions (in user date format); display-only. |
Time |
The time when the action occurred. Numeric, 6 positions (HH:MM:SS format); display-only. |
Before |
The setting of the system control value before the action occurred. This field is blank for Add records. LNG: alphanumeric, 255 positions; display-only. NBR and QTY types: numeric, 7 positions; display-only. CDE and VNM types: alphanumeric, 10 positions; display-only. VAL types: numeric, 11 positions with a 2-place decimal; display-only. PCT types: numeric, 5 positions with a 2-place decimal; display-only. WGT types: numeric, 7 positions with a 2-place decimal; display-only. DTE types: numeric, 6 positions; display-only. |
After |
The setting of the system control value after the action occurred. The same as the Before setting: • if the user changed some other field, such as the Narrative, or simply selected OK after selecting Change for a system control value • for a Delete history record or for an Add record (both blank or zero) • a Change record created immediately after an Add record when you add a new system control value by applying a PTF upgrade LNG: alphanumeric, 255 positions; display-only. NBR and QTY types: numeric, 7 positions; display-only. CDE and VNM types: alphanumeric, 10 positions; display-only. VAL types: numeric, 11 positions with a 2-place decimal; display-only. PCT types: numeric, 5 positions with a 2-place decimal; display-only. WGT types: numeric, 7 positions with a 2-place decimal; display-only. DTE types: numeric, 6 positions; display-only. |
User |
The user ID of the person who performed the action. Alphanumeric, 10 positions; display-only. |
Display All System Control Value History Screen
Purpose: Use this screen to review history for all system control values, including those you have deleted.
How to display this screen: Select View History in the gray sidebar rather than for a particular system control value at the Work with System Control Values by Code Screen or the Work with System Control Values Screen (for company-level system control values) or the Work with Entity SCV Overrides Screen (for entity-level system control value overrides).
If displayed for entity-level overrides: If you display this screen by selecting View History at the Work with Entity SCV Overrides Screen, only changes made to the selected entity are included on the screen.
Field |
Description |
Date |
The date when the action occurred. You can enter a date to display changes that occurred on that date or later. Numeric, 6 positions (in user date format); optional. |
Cde |
The code identifying the system control value. You can enter a complete code to display changes for that code only. Alphanumeric, 3 positions; optional. |
Description (unlabeled field to the right of the Cde) |
The description of the system control value. If the system control value has been deleted, the description displayed is SCV does not exist. Alphanumeric, 75 positions; display-only. |
Action |
The action taken to update the System Control table. Possible actions are: • Add = This type of record is created when you create a new system control value or copy system control values from one company to another • Change = This type of record is created when you select Change for a system control value to advance to the Change System Control Value Screen (or similar screen for umbrella or entity-level values) and then select OK, regardless of whether you actually change any information. If you did not actually change the value, the Before and After values displayed at this screen are the same. This type of record is also created when you use Work with FIFO Cost Conversion (WFCV) to change from or to FIFO costing or immediately after creating the Add record when you create a new system control value through a PTF upgrade • Delete = This type of record is created when you select Delete for a system control value. You should not delete system-supplied control values. Display-only. |
Time |
The time when the action occurred. Numeric, 6 positions (HH:MM:SS format); display-only. |
Before |
The setting of the system control value before the action occurred. This field is blank for Add records. LNG: alphanumeric, 255 positions; display-only. NBR and QTY types: numeric, 7 positions; display-only. CDE and VNM types: alphanumeric, 10 positions; display-only. VAL types: numeric, 11 positions with a 2-place decimal; display-only. PCT types: numeric, 5 positions with a 2-place decimal; display-only. WGT types: numeric, 7 positions with a 2-place decimal; display-only. DTE types: numeric, 6 positions; display-only. |
After |
The setting of the system control value after the action occurred. The same as the Before setting: • if the user changed some other field, such as the Narrative, or simply selected OK after selecting Change for a system control value • for a Delete history record or for an Add record (both blank or zero) • a Change record created immediately after an Add record when you add a new system control value by applying a PTF upgrade LNG: alphanumeric, 255 positions; display-only. NBR and QTY types: numeric, 7 positions; display-only. CDE and VNM types: alphanumeric, 10 positions; display-only. VAL types: numeric, 11 positions with a 2-place decimal; display-only. PCT types: numeric, 5 positions with a 2-place decimal; display-only. WGT types: numeric, 7 positions with a 2-place decimal; display-only. DTE types: numeric, 6 positions; display-only. |
User |
The user ID of the person who performed the action. Alphanumeric, 10 positions; display-only. |
Option |
Procedure |
Print a report of all system control value activity for a selected period |
Select Print list to advance to the Print System Control Value History Window. |
Print System Control Value History Window
Purpose: Use this window to select the date range to include on the System Control Value History Report, and to generate the report. The report will include all system control value history that occurred in the specified date range, including any activity both at the company level and any changes to entity-level overrides made through the Work with Entity SCV Overrides Screen.
How to display this window: Select Print List at the Display All System Control Value History Screen.
Completing this screen:
1. Enter the Starting date and the Ending date to include on the report. The system verifies that your Ending date is not earlier than your Starting date, and that your Starting date is not in the future. Each date is a six-position numeric field in user date format.
2. Select Submit to submit the PRT_SCVHIS job, which generates the System Control Value History Report.
Note: If there are no System Control Value History records for the date range you enter, the PRT_SCVHIS job is deleted and no report is generated; the job does not produce an empty report. There might be no records if there were no updates to the System Control table for the selected period.
