Numeric Table Maintenance

Use Numeric Table Maintenance to maintain the table that sets up the user-definable numeric fields, which are an optional part of the information for each of the maintenances listed below.  During Numeric Table Maintenance you can assign the field label (field name) and special properties for the field to have.  While there are sixty separate numeric fields available for each of the maintenances listed, you only define as many fields as you need.  

Notes:

• Follow the instructions to maintain the table for the user-defined numeric fields for:

• Customers. You can view the user-definable fields during the Customer view of the Enhanced Inquiry or the  Customer User Definable Panel of the Customer Inquiry.

• Locations.  You can view the user-definable numeric fields during the Location view of the Enhanced Inquiry or the Customer User Definable Panel of the Customer Inquiry.

• Companies.  You can view the user-definable numeric fields during the Company User Definable Window.

• Meters.  You can view the user-definable numeric fields during the Meter User Definable window.

• Trailers.  You can view the user-definable numeric fields during the Trailer User Definable window.

• Components.  You can view the user-definable numeric fields during the Component User Definable window.

• Backflow Master.  You can view the user-definable numeric fields during the Backflow User Definable window.

• Connections.  You can view the user-definable numeric fields during the User Definable area of the Connections view.

• In addition, there are user-definable alpha fields that are an optional part of each maintenance.  For more information, see Alpha Table Maintenance.

Directions:

To see directions for...

• Opening Numeric Table Maintenance, click More.

   

  1.  Click Daily Work from the Menu Bar.

  2.  Click File Maintenance.

  3.  Click Table Maintenance.

  4.  Click Customer Extended Labels Table.

  5.  Click Numeric Table.
  
  Or, use the keyboard shortcut:  [ALT] [y] [m] [t] [l] [n].

   

  Numeric Table Maintenance Window Example:

  

   

• Creating a Numeric Table, click More.

   

  IMPORTANT:  You can not create a new Numeric Table.  The necessary table is created during the software installation and updates.  To maintain the Numeric Table, see the instructions for editing later in this topic.

   

• Editing a Numeric Table, click More.

   

  CAUTION:  To avoid losing data, you must save the changed record.

  1. To display the record to be changed, simply open Numeric Table Maintenance.  The record automatically displays.

  2. To position the mouse to the field to be edited, press [TAB] or click the field using the mouse.

  3. Enter the data changes.

  4. To complete the edit process, click Save or press [ENTER].
     Keyboard shortcut:  [ALT + s]

  Numeric Table Maintenance Prompts Tip:  To see more information about a field, click the hyperlink for the field name.
  	To update the new or changed information, click Save or press [ENTER]. Keyboard shortcut:  [ALT + s]
  	CAUTION To avoid losing data, you must save new or changed records.
  	Search is not active for this program.
  	Retrieve is not required in this program.
  Note:  There are three options for each field:  Numeric Field Label, Special Formatting, and Special Conditions.  Each column (one column for each of the three options) is described below along with the general instructions.
  Numeric Description 1 - 16	Displays the number of the field being maintained.
  Numeric Field Label	Enter the label or the title of the field. (up to 30 characters)
  Numeric Special Field Format	To specify the type of formatting for the field, click a choice in the drop-down list. Special Format Options: Number 1.0 - Format the field as a 1-digit number with no decimal places. Example:  1 Number 2.0 - Format the field as a 2-digit number with no decimal places. Example:  10 Number 12.2 - Format the field as a 12-digit number with 2 decimal places. Example:  100,000,000,000.00 Currency 12.2 - Format the field for currency as a 12-digit number with 2 decimal places. Example:  $100,000,000,000,00 Date (MM/DD/YYYY) - Format the field as a date. Example:  10/23/2006
  Numeric Field Special Conditions	To specify the special field conditions, click a choice in the drop-down list. Special Field Conditions: None - No special condition available for numeric fields.

• Deleting a Numeric Table fields, click More.

  Important:  To maintain data integrity, you can not delete the Customer Labels Numeric Table.  However, you can delete a field label within the table.

  To delete a field within the Numeric Table:

  1. To position the pointer to the field that you want to delete, press [TAB] or click the field using the mouse.

  2. Press [DELETE] or [BACKSPACE] to remove the entire field label.

  3. To complete the field delete, click Save or press [ENTER].