V3 Custom Field Formats

Type and format of Custom Field values. For example, a custom field defined as a ZIPCODE field can store up to 10 characters in the format XXXXX-XXXX.

NONE is the default.

📘

These values are case-sensitive.

ValueDescription
AuditAudit - Login id, name of the user or last-change date time of the user information for the specified field Id.
XCheckbox - A single character alpha field that functions as a checkbox and accepts only X.
DATEDATE - A date value in the format yyyy-MM-dd
DECIMALDECIMAL - A numeric field with one or more decimal digits
DECIMAL_1DECIMAL_1 - A numeric field allowing up to 1 decimal digits
DECIMAL_2DECIMAL_2 - A numeric field allowing up to 2 decimal digits.
DECIMAL_3DECIMAL_3 - A numeric field allowing up to 3 decimal digits.
DECIMAL_4DECIMAL_4 - A numeric field allowing up to 4 decimal digits.
DECIMAL_5DECIMAL_5 - A numeric field allowing up to 5 decimal digits.
DECIMAL_6DECIMAL_6 - A numeric field allowing up to 6 decimal digits.
DECIMAL_7DECIMAL_7 - A numeric field allowing up to 7 decimal digits.
DECIMAL_9DECIMAL_9 - A numeric field allowing up to 9 decimal digits
DECIMAL_10DECIMAL_10 - A numeric field allowing up to 10 decimal digits
DROPDOWNLISTDROPDOWNLIST - A dropdown list from which the user selects a predefined value.
DROPDOWNDROPDOWN - Editable - A dropdown list that allows the user to enter text. The user can type a value or select from the list of predefined values.
INTEGERINTEGER - A numeric field, with no decimal places.
MONTHDAYMONTHDAY - A 5-character numeric field for recording a date in the format mm-dd.
PHONEPHONE - A 17-character alpha/numeric field for recording a phone number in the format 111-111-1111 1111. Positions 4 and 8 contain dashes (-), and position 13 is a blank space.
SSNSSN - An 11-character numeric field for recording a social security number. Positions 4 and 7 contain dashes.
STATESTATE - A 2-character alpha field for recording a state abbreviation.
STRINGSTRING - An alpha/numeric field used to type a series of characters. If the values are numbers, they cannot be used for calculations. A typical use of the String field type is for a street address.
Y/NY/N - A single character alpha field that accepts only Y (for yes) or N (for no).
ZIPCODEZIPCODE - A 10-character numeric field for recording zip codes in the format 11111-1111. Position 6 contains a dash (-).