Add Field/Edit Field

 

Window Details

 

Navigation

 

Overview

 

Fields

 

 

How Do I

 

 

Export User-Defined Field (UDF) Validation List

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)

Column Information

 

Add Field/Edit Field (All tables)

 

 

 

1. Attributes

 

Uppercase

Fixed Font

Center Text

Right-Justify

Borderless

Exclude from Report Selection

Mask Display

 

 

2. Validation

 

Required Field

 

 

3. Data Sources

 

Data Sources Grid

Ignore

Select

Expression

Data Source

DM

Column