Add a New NUMERIC Domain

You use the NUMERIC Domain dialog box to add a new domain that uses one of the numeric data types.

To create a new NUMERIC domain:

  1. Open the Domains (SP) application.

  2. At the bottom of the Domains table window, click Add New Domain and select Add New NUMERIC Domain. The NUMERIC Domain dialog box opens.

  3. In the Domain field, enter a name for the domain.

  4. In the Domain Description field, enter a short description.

  5. In the Data Type field, enter a valid data type or click Select Value . The choices are: FLOAT, SMALLINT, INTEGER, DURATION, DECIMAL, and AMOUNT.

  6. Depending on the data type the Length field may or may not be editable. If editable, enter a length that is equal to or less than the length of the field that will use the domain. For example, if you are adding a domain for a field in the Assets (SP) application that has a length of 12, then specify a length of 12.

Since you can use a domain with multiple fields, the length you specify here must be less than or equal to the length of the shortest field you will use the domain with. For example, if you want to use the domain with three fields of lengths 8, 10, and 12, specify a length of 8 or less for the domain.

Note: If you specify a length greater than the field the domain is used in, you will not be able to assign the domain to the attribute in Database Configuration. Alternatively, you can specify a greater length here and later go to Database Configuration and change the length of the field that uses the domain.

  1. For DECIMAL data type only: In the Scale field, enter a scale value if different from the default, 2.

  2. Click New Row.

  3. Fill in the Value and Description fields as appropriate.

  4. The system by default applies domains at the system level. If you want a domain value to apply to a specific organization or site, enter the relevant values in the Organization and Site fields.

Note: Either leave the Organization and/or Site fields empty for all values (users in all organizations and sites can access them) or specify organization and/or site for all values (only users in the specified organizations and/or sites can access them).

          Not following the above recommendation can yield complicated outcomes. For example, if you enter a value 100 with no organization specified, a value 300 with Organization A specified, and a value 500 with Organization B specified, then records in Organization A will only have access to 300. Records that are in Organization B will only have access to 500. Records that are in other organizations will only have access to 100. Once you specify an organization and/or site for one value, records in that organization and/or site will no longer have access to values that have no organization/site specified.

  1. In the Customer field, select a customer to associate the domain with the customer and restrict use of the domain to objects that are associated with the customer.

  2. Click New Row again to add more values, or click Close Details .

  3. Click OK.

You have now added a new domain to the database. However, you must still attach the domain to the object/attribute you want the domain to be used with, as well as other tasks.

See Also

Domains (SP) application

Add a New NUMERIC RANGE Domain

Domain Post-requisites