QAD 2017 Enterprise Edition > User Guides > System Administration > UI Customization > User-Defined Fields
  
User-Defined Fields
User-Defined Fields (UDFs) are predefined fields in the database tables and can be customized to store additional information specific to your business requirements.
Use User Defined Field Create to activate a UDF before you can add it to the UI.
When activated, a UDF can be designated as a filter field in the Search Criteria and can be added to the Search Criteria Result Grid. UDFs are also available for Excel integration, if this functionality is available for the component you have customized.
To include a UDF in the selection criteria for a report or in the report itself, you have to create a non-intrusive customization in order to adapt the selection and the report logic.
UDFs are available for all business components, both on master data, such as business relations and suppliers, and for transactional components, such as customer invoices and supplier invoices.
The following UDFs are available for each category of field:

UDF Types
 
Type
Number
Validation
Combo
10
User-defined value list
Date
5
Valid date
Decimal
5
Valid decimal
Integer
5
Valid (signed) integer
Short
10
Free text (maximum 20 characters) or value retrieved through lookup
Long
2
Free text (maximum 255 characters) or value retrieved through lookup
Note
1
Free text (maximum 2000 characters)
QAD Reserved
4
These fields are reserved for use by QAD only.
There are four types of QAD reserved field:
• QADCO1: Free text (maximum 20 characters) or value retrieved through lookup
• QADCO2: Free text (maximum 255 characters) or value retrieved through lookup
• QADT01: Valid date
• QADD01: Valid decimal