 |
| ||||||||
What field types are available for custom field requests?
All data displayed to users or collected from users appears within fields. You can choose from many different types of fields when requesting a custom field. All field types are reportable unless otherwise noted.
Some field types support enumerations, which are data structures that display a list of choices. You load the list of choices ahead of time to populate the choosers.
The following list describes the available form field types.
Keep in mind that some field types may not be available due to limitations on a given class.
Boolean
Displays Yes and No radio buttons. By default, the initial setting contains null (no option selected). This field can be preset to a specific choice:
Date and Calendar Date
Users select a date from the calendar icon. Reports always use Calendar Date as the data type for all custom date fields, so creating a field with a Calendar Date type ensures that dates appear correctly in reports.
Date fields display a calendar to allow users to select a date. For each Date or Calendar Date field, select one of the following date formats:
 | Default |
 | Concise |
 | Padded concise |
 | Month Year |
 | Day Month Year |
 | Reporting Field |
Text
Accepts one line of free text up to 1,000 characters in length. Specify the width of the box (in characters). This field can be set to a default value, and you can point this field type to an enumeration.
Text Multiple Select
Displays an enumeration pick list. This field can be set to a default value.
Integer
Accepts integers (whole numbers), such as 2 or 34567. Integers are limited to the range of -(2^32) to (2^3). This field can be set to a default value, and you can point this field type to an enumeration.
Long
Accepts a long integer (whole number).
Decimal Number
Accepts integers (whole numbers) or decimal numbers (fractions), such as 2, 5353.6767, or 0.008. Decimal numbers are limited to 38 digits of precision.
Percentage
Accepts integers (whole numbers) or decimal numbers (fractions) that are treated as percentages when used in calculations. For example, if users enter 25, the site uses 0.25 in calculations that use that value.
Note: Percentage values can be greater than 100.
Money
Accepts a decimal number that your site treats as a currency value in calculations and conversions. Your site can perform currency conversions on values entered in Money fields.
Currency
Accepts one currency code.
Long Text
Accepts one line of text of unlimited length. This field is similar to the Long Rich Text field, but without rich-text capability. This field does not support enumerations. The data from this field is not available in reports.
Multiline Text
Accepts multiple lines of free text, up to 1,000 characters. Specify the width (in characters) and height (in lines) of the text box. This field can be set to a default value.
Long Rich Text
Accepts formatted text of unlimited length. This field displays a text box and uses a rich-text editor. For example, users can format text to use bold, italics, color, bullets, and other light formatting. If text overflows the text box, scrollbars appear to allow easier editing. The data from this field is not available in reports.
User Multiple Select
Accepts zero or more user names.
User
Accepts one user name.
Product Multiple Select
Accepts zero or more product names.
Department Multiple Select
Accepts zero or more department names.
Business Unit
Accepts one business unit name.
Account
Accepts one account name.
Sub Account
Accepts one sub account name.
Cost Center
Accepts one cost center name.
Project
Accepts one project name.
Region Multiple Select
Accepts zero or more region names.
Address
Accepts one address.
Country
Accepts one country name.
Supplier Multiple Select
Accepts zero or more supplier or customer company names.
Supplier
Accepts one supplier name.
Company
Accepts one company name.
Commodity Multiple Select
Accepts zero or more United Nations Standard Products and Services Code (UNSPSC) commodity or service names.
Commodity Code
Accepts one commodity or service name.
Unit of Measure
Accepts one United Nations Unit of Measure value.
Flex Master Data
Flex master data types are custom data types that you define for a specific customer. You select these fields just like any other field type and place them in your design. You determine the characteristics of flex master data types.
Flex master data is typically more complex than most data. For example, you would use an enumeration and a text field to store the names of hospitals. However, you can use flex master data to store the names of hospitals and attributes, such as their addresses and phone numbers, the availability of specialized departments or equipment, and the name of the hospital administrator. When users select a hospital, they can click it to view the attribute data. You refer to each flex master data template through a name, such as "Hospital."
The following example illustrates a flex master data object named "El Camino Hospital" when completing an insurance claim form:
Field Customization
Field Customization > Operational Procurement Field Customization
Field Customization > Sourcing/Contracts Field Customization