Add User-Defined Table - Fields

 

Add User-Defined Table

Expand/Collapse all Show/Hide All

Table Name

Enter the name of the user-defined table (UDT) to add. You can enter up to 23 characters. When a table name is entered, all characters are automatically converted to uppercase, spaces are converted to underscores (_), and the table name is prepended with GL_UDT_.

Expand/Collapse item Entry Sample

GL_UDT_PROJECTS

 

Description

Enter a description for the UDT. You can enter up to 40 characters. This field is available only if a name has been entered in the Table Name field. When a table description is entered, the characters are automatically converted to lowercase with initial capitalization, and the description is prepended with the two-letter module code and appended with (UDT).

Expand or collapse item Entry Sample

G/L Projects

 

Key Field Name

Enter the field name for the key into the UDT. You can enter up to 20 characters. This field is available only if a name has been entered in the Table Name field. When a key field name is entered, all characters are automatically converted to uppercase, spaces are converted to underscores, and the key field name is prepended with UDF_ and appended with _CODE.

Expand or collapse item Example

The following examples show how the key field name can reflect the kind of data the UDT is based on:

Enter....

If....

UDF_PROJECT_CODE

The table is based on project codes.

 

Key Field Description

Enter a description for the key field. You can enter up to 40 characters. This field is available only if a name has been entered in the Table Name field. When a key field description is entered, the characters are automatically converted to lowercase with initial capitalization, and the description is appended with the word Code.

Expand or collapse item Entry Sample

Project Code

 

Key Field Length

Enter the length of the key for the UDT. The key field length must be at least 2 but no more than 96 characters long.

Expand or collapse item Example

Enter....

If....

10

The table is based on 10-digit project codes.

 

 

© Sage Group plc 2019. Privacy Policy | Copyright/Trademarks