Add Field/Edit Field

Window Details
	Navigation
	Overview
	Fields

How Do I
	Create a User-Defined Field (UDF)	Export User-Defined Field (UDF) Validation List
	Map User-Defined Fields (UDFs)	Select Multiple Data Sources for a UDF

Related Topics
	User-Defined Field and Table Maintenance	User-Defined Script Maintenance
	User-Defined Fields

Navigation

Select Custom Office Main menu > User-Defined Field and Table Maintenance. In the User-Defined Field and Table Maintenance window, select the module and table. In the User-Defined Fields window, click Add or Edit.

For tables in some modules, when the table is selected in the User-Defined Field and Table Maintenance window, a modified Add Field window appears first. The modified Add Field window appears only if one or more business objects exist for the table the UDF is being added to.

Overview

Use Add Field/Edit Field to add or edit a user-defined field. If a user-defined field is in use for the current table, the control type and data type cannot be changed, nor can the length be reduced.

Fields

Add Field (Tables in some modules only)
Field Name	Data Source
Description	Column
Source	Ignore If Null / Ignore If Zero
Business Object	Column Information

Add Field/Edit Field (All tables)
Field Name	Control Type
Description

1. Attributes
Data Type Maximum Length Uppercase Fixed Font Center Text Right-Justify	Borderless Exclude from Report Selection Mask Default Value Caption

2. Validation
Validation Types	Required Field

3. Data Sources
Data Sources Grid	Ignore
Select	Expression
Data Source	DM
Column