Collapse AllExpand All

11.3.1. Characteristics

Characteristics may be used to create additional layers of information about Items, Customers, CRM Accounts, and more. For example, Characteristics defined on an Item master may be associated with Sales Order Items. And, if the Sales Order leads to the automatic generation of additional Orders (i.e., Work Orders or Purchase Orders), then the subsequent Orders will inherit the parent Sales Order Characteristics.

To access the master list of Characteristics, select the "Characteristics" option. The following screen will appear.

Characteristics Master List

The "Characteristics" screen displays information on all existing Characteristics, including Characteristic name and Characteristic description.

11.3.1.1. Characteristic

To create a new Characteristic, select the NEW button. The following screen will appear:

Create New Characteristic

When creating a new Characteristic, you are presented with the following options:

Name

Enter a unique name to identify the Characteristic.

Type

Specify one of the following Characteristic Type options:

Text

Select if you want the Characteristic to be a text string. Text type Characteristics have access to the input mask and validator options.

List

Select if you want the Characteristic to present a list of possible values. If selected, you will have the option to enter possible Characteristic values and their preferred sort order.

Date

Select if you want the Characteristic to be a date string. The formatting of date type Characteristics conforms to the Locale setting for the logged in user.

Order

Specify the sort order for the Characteristic. This option is useful whenever you present multiple Characteristics in a given context. For example, if you have five Contact Characteristics defined, the sort order will determine which Characteristic appears at the top of the sort order when a Contact record is being entered or edited.

Include in searches

Select to indicate you want the Characteristic to be included in searches related to records where the Characteristic is used. Not selecting this option means the Characteristic will not be included in searches. This feature exists to help improve potential performance penalties incurred when multiple Characteristics are included in search criteria. If you use multiple Characteristics to define certain records (e.g., Items, Customers, etc.), you can improve search performance by choosing to only include in searches those Characteristics which you are most likely to search on.

May be used on

Select one or more of the following Characteristic assignment options by selecting the relevant check boxes. The Characteristic will then be available for use in the specified screen(s).

  • Address

  • Account

  • Item

  • Quote

  • Vendor

  • Projects

  • Contact

  • Employee

  • Lot/Serial

  • Sales Order

  • Purchase Order

  • Project Tasks

  • Customer

  • Incident

  • Opportunity

  • Invoice

  • Voucher

Options

The options presented will vary depending on the Characteristic type you choose. The range of possible options are described below:

Text options

The following options will be available for text type Characteristics. These advanced options are not required, but if used they will enforce greater consistency and control over the values entered for your text type Characteristics. Typically when using these advanced validation features, you will specify either an input mask or a validator. If you decide to use both at once, they must be coordinated and consistent—otherwise users will experience difficulties when attempting to enter text type Characteristic values.

Input Mask

Select from the available options—or manually enter an input mask of your own design. An input mask creates a template to guide users as they enter values for a Characteristic. It is a form of light data validation. For example, if you specify the input mask 00/00/0000, then users will be presented with the following template when they are entering values for the Characteristic : "__/__/____". In this case, users will simply have to fill in the blanks between the separators.

00/00/0000

Select this format to prompt users to enter a date format with the pattern shown (e.g., MM/DD/YYYY).

### - ### - ####

Select this format to prompt users to enter a numerical format with the pattern shown. This example would be a good match for telephone numbers (e.g., 757-555-1111).

### - ## - ####

Select this format to prompt users to enter a numerical format with the pattern shown. This example would be a good match for social security numbers (e.g., 012-34-5678).

00,000.00

Select this format to prompt users to enter a price format with the pattern shown.

Validator

Select from the available options—or manually enter a validator of your own design. A validator is used to strictly enforce the format of data users can enter in a field. If you specify a validator for a Characteristic, then users will have to conform to the format when entering values for the Characteristic. Values which do not conform will not be accepted.

[Y/N]

Select this boolean validator to require users to enter "Y" or "N" for Yes or No.

\S+

Select this validator to require users to enter one or more non-white-space characters. So, for example, this validator would accept the value "Inventory" but not "Inventory Availability".

[1-9]\d{0,3}

Select this validator to require users to enter a number from 1-9999.

[A-Z]\d{5}[1-9]

Select this validator to require users to enter a value where the first character is A-Z, the next five characters are numbers 0-9, and the last character is a number 1-9. While this pattern may not be very useful for most people, it does illustrate how you can create your own regular expressions to design a validator to meet your own custom needs.

www\S?(\.com|net|org)

Select this validator to require users to enter a website address (e.g., www.xtuple.com)

List options

The following options will be available for list type Characteristics:

NEW

Select to create a new value for the Characteristic.

Value

Use your mouse to click in the "Value" field. Once you see the cursor in the "Value" field, you can begin typing your value information. The value entered here will appear as a listed option when the specified Characteristic is used. For example, possible values might be "True" and "False"—or any other combination of values you can imagine.

Order

Specify the sort order for each value in the list. If the order of the value "True" is "1" and the value for "False" is "2", then "True" will appear above "False" in the Characteristic list.

DELETE

Highlight a Characteristic value and select this button to remove the value from the list.

Date options

There are no options for date type Characteristics. The formatting of date type Characteristics conforms to the Locale setting for the logged in user.

Description

Use the "Description" tab to enter a brief description of the Characteristic.